Erreurs Zimbra

Que pensez-vous de cet article?

Table des matières

Afficher les tables Mysql Zimbra

su zimbra

$ logmysql zimbra_logger

mysql> show tables;

Plus d'affichage des statistiques

• Editez le fichier : /opt/zimbra/logger/db/data/Nom_du_Serveur.err

Exemple d'erreur :

080712  9:50:49 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed

• Lancez une console

su zimbra

$ logmysql zimbra_logger

mysql> check table mta;
+-------------------+-------+----------+------------------------------------------------------+
| Table             | Op    | Msg_type | Msg_text                                             |
+-------------------+-------+----------+------------------------------------------------------+
| zimbra_logger.mta | check | warning  | Table is marked as crashed and last repair failed    |
| zimbra_logger.mta | check | error    | Size of indexfile is: 1024        Should be: 1947648 |
| zimbra_logger.mta | check | error    | Corrupt                                              |
+-------------------+-------+----------+------------------------------------------------------+
3 rows in set (0.01 sec)

• Lancez :

mysql> repair table mta;
+-------------------+--------+----------+----------+
| Table             | Op     | Msg_type | Msg_text |
+-------------------+--------+----------+----------+
| zimbra_logger.mta | repair | status   | OK       |
+-------------------+--------+----------+----------+
1 row in set (7.58 sec)

• Puis de nouveau :

mysql> check table mta;
+-------------------+-------+----------+----------+
| Table             | Op    | Msg_type | Msg_text |
+-------------------+-------+----------+----------+
| zimbra_logger.mta | check | status   | OK       |
+-------------------+-------+----------+----------+
1 row in set (1.03 sec)

Pour valider la réparation de la table.

Services Zimbra

• Antivirus :

zmclamdctl

• spell :

zmapachectl

• mta :

zmsaslauthdctl

• stats

zmstatctl

Restaurer la planification par défaut des sauvegardes

zmschedulebackup -D