Archives de catégorie : Zimbra

Script Backup Zimbra

#!/bin/bash

## Autor : infragate
## version 2.0
## tested with zimbra version : 8.7.11.GA.1854.UBUNTU16.64_amd64.deb
## RESTORE mbox
## $ZMBOX -z -m $mbox postRestURL "//?fmt=zip&resolve=reset" $mbox.zip
## mailutils package

## colors

red='\033[0;31m'
RED='\033[1;31m'
green='\033[0;32m'
GREEN='\033[1;32m'
blue='\033[0;34m'
BLUE='\033[1;34m'
purple='\033[0;35m'
PURPLE='\033[1;35m'
cyan='\033[1;36m'
def='\033[0m'

#############
# VARIABLES #
#############
DATE=`date +%Y%m%d`
FQDN=`hostname -f`
ZHOME=/opt/zimbra

ZBACKUP=/backup/$FQDN/$DATE
ZMBOXBACKUP=$ZBACKUP/mailbox

ZCONFD=$ZHOME/conf
ZDUMPDIR=/opt/zimbra/backup
ZMBOX=/opt/zimbra/bin/zmmailbox

### Log & Mail
ZLOG=~/log_backup.txt
TEMP=~/temp.txt
RECEP=yourmail@domain.fr
ATT=~/mail.txt

### OPTS
MAIL_ALERT=1
CIFS_BACKUP=1

#### Exec
SLAPCAT=/opt/zimbra/common/sbin/slapcat
MYSQLDUMP=/opt/zimbra/common/bin/mysqldump

### LDAP
LDAPCONFDIR="/opt/zimbra/data/ldap/config"
LDAPDUMPNAME="zimbra_ldap"

### Mysql
MYSQL_USER="root"
MYSQL_PASSWORD="mJClQWgfgfgfNTAg1YQo3a"
MYSQL_SOCKET="/opt/zimbra/data/tmp/mysql/mysql.sock"
MYSQLDUMPNAME="zimbra_mysql"

### CIFS Backup
USER_SHARE=username
PASS_SHARE="E9????????2"
SHARE_SERVER=0.0.0.0
SHARE_FOLDER=folder_name
MOUNT_POINT=/backup

##############
#SCRIPT USAGE#
##############

ARGS=$(getopt -o a:h -l "action:help" -n "$(basename $0)" -- "$@")

function usage()
{
        echo -e "${GREEN}Usage:\t$(basename $0) [-a mysql | ldap | mbox | all]${def}" >&2
}

#Bad arguments
if [[ $? -ne 0 ]];
then
        echo -e "${RED}Error: unparsable arguments${def}" >&2
        exit 255
fi

eval set -- "${ARGS}"

while true
 do
        case "$1" in
                -a|--action)
                        shift
                        if [ -z "${action}" ]
                        then
                                action="$1"
                        else
                                echo -e "${RED}Error: -a option cannot be used several times.${def}" >&2
                                exit 255
                        fi
                        shift
                        ;;
                -h|--help)
                        shift
                        usage
                        exit
                        ;;
                --)
                        shift
                        break
                        ;;
        esac
done

#####################
##### FUNCTIONS     #
#####################

function log_date()
{
 echo $(date +%d/%m/%Y-%H:%M:%S)
}

####################

function test_dir()
{
 if [ ! -d $1 ]; then mkdir -p $1; fi
}

###################

function lblank()
{
 echo ""  >> $TEMP ;
}

####################

function send_mail()
{
 if [ $MAIL_ALERT = 1 ]
  then
    sed -r "s/\x1B\[([0-9];)?([0-9]{1,2}(;[0-9]{1,2})?)?[m]//g" $TEMP > $ATT ;
    mail -s "Zimbra Backup Report for `hostname` `date +%d/%m/%Y-%H:%M:%S`" $RECEP < $ATT ;
    [ "$?" != 0 ] && exit ;
    rm -rf $ATT ;
 fi
}

####################

function time_computing()
{
 elapsed="$(expr $time_end - $time_start)"
 hours=$(($elapsed / 3600))
 elapsed=$(($elapsed - $hours * 3600))
 minutes=$(($elapsed / 60))
 seconds=$(($elapsed - $minutes * 60))

 echo -e "${cyan}The $1 backup lasted : $hours hours $minutes minutes $seconds seconds ${def}" >> $TEMP ;
 lblank
}
##########################

function mount_cifs()
{
        if [ $CIFS_BACKUP = 1 ]
                then
         echo -e "${BLUE}$(log_date) CIFS BACKUP Method Selected${def}" >> $TEMP ;
         test_dir $MOUNT_POINT
         mount -t cifs \\\\$SHARE_SERVER\\$SHARE_FOLDER $MOUNT_POINT  -o username=$USER_SHARE,password=$PASS_SHARE
         [ "$?" != 0 ] &&  echo -e "${red}CIFS MOUNT : FAILED : BACKUP ABORTED${def}" >> $TEMP && exit ;
    fi
}
#########################

function umount_cifs()
{
        if [ $CIFS_BACKUP = 1 ]
                then
                 cd
                 umount $MOUNT_POINT
                 [ "$?" = 0 ] &&  echo -e "$(log_date) ${green}CIFS Share sucessfully unmounted${def}" >> $TEMP || echo -e "$(log_date) ${red}CIFS Share unmounting : FAILED${def}" >> $TEMP ;
    fi
}
############################

function mailbox_1by1()
{
 lblank
 echo -e "$(log_date)${BLUE} Mbox backup activated${def}" >> $TEMP;

 test_dir $ZBACKUP
 test_dir $ZMBOXBACKUP
 test_dir $ZDUMPDIR

 for mbox in `su - zimbra -c "zmprov -l gaa"`
  do
           echo -ne "$(log_date)${blue} Generating files from backup $mbox ... ${def}" >> $TEMP ;
           su - zimbra -c "$ZMBOX -z -m $mbox getRestURL "//?fmt=zip" > $ZDUMPDIR/$mbox.zip" ;
           ([ "$?" = 0 ] &&  echo -e "${green}DONE${def}" || echo -e "${red}FAILED${def}") >> $TEMP ;

 done
 mv $ZDUMPDIR/*.zip $ZMBOXBACKUP
}
#########################

function backup_mysql()
{
 lblank
 test_dir $ZBACKUP
        echo -ne "$(log_date)${BLUE} Mysql Backup activated ... ${def}" >> $TEMP ;

        if [[ -z "${MYSQL_USER}" || -z "${MYSQL_PASSWORD}" ]]
        then
                echo -e "${red}Error: mysql credentials have to be specified${def}" >> $TEMP ;
                exit 255
        fi

        dump_options="--user=${MYSQL_USER} --password=${MYSQL_PASSWORD} --socket="${MYSQL_SOCKET}" --all-databases \
                                  --single-transaction --flush-logs --events --ignore-table=mysql.event"

        $MYSQLDUMP ${dump_options} | gzip > "${ZBACKUP}"/"${MYSQLDUMPNAME}_${FQDN}.sql.gz"
        ([ "$?" = 0 ] &&  echo -e "${green}DONE${def}" || echo -e "${red}FAILED${def}") >> $TEMP ;
}

############################

function backup_ldap()
{
lblank
test_dir $ZBACKUP
        echo -ne "$(log_date)${BLUE} LDAP Backup activated ... ${def}" >> $TEMP ;

        $SLAPCAT -F "${LDAPCONFDIR}" -b "" | gzip > "${ZBACKUP}"/"${LDAPDUMPNAME}_${FQDN}.ldif.gz"
        ([ "$?" = 0 ] &&  echo -e "${green}DONE${def}" || echo -e "${red}FAILED${def}") >> $TEMP ;
}

################
### MAIN  ######
################


case ${action} in
        mbox)
                time_start=`date +%s`
                mount_cifs
                mailbox_1by1
                umount_cifs
                time_end=`date +%s`
                time_computing mbox
                cat $TEMP >> $ZLOG
                send_mail
                rm -rf $TEMP
                ;;

        mysql)
                time_start=`date +%s`
                mount_cifs
                backup_mysql
                umount_cifs
                time_end=`date +%s`
                time_computing mysql
                cat $TEMP >> $ZLOG
                send_mail
                rm -rf $TEMP
                ;;

        ldap)
                time_start=`date +%s`
                mount_cifs
                backup_ldap
                umount_cifs
                time_end=`date +%s`
                time_computing ldap
                cat $TEMP >> $ZLOG
                send_mail
                rm -rf $TEMP
                ;;

        all)
                time_start=`date +%s`
                mount_cifs
                backup_mysql
                ret_mysql=$?

                backup_ldap
                ret_ldap=$?

                mailbox_1by1
                ret_mbox=$?
                umount_cifs
                time_end=`date +%s`
                time_computing full
                cat $TEMP >> $ZLOG
                send_mail
                rm -rf $TEMP
                ;;

        "")
                usage
                ;;

        *)
                echo -e "${red} Error: unknown ${action} action. ${def}" >&2
                exit 255
                ;;
esac

Zimbra

Migration de liste de diffusion

Erreur de proxy.

method:	[unknown]
msg:	error while proxying request to target server: no such server: www.xxxxxxxx.fr
code:	service.PROXY_ERROR
detail:	soap:Receiver

Le problème vient de la migration ayant eu lieu il y a qq mois. Il faut corriger le mailhost dans ces mailing listes ce qui n’a pas été fait.

Voici les commandes qui permettent de résoudre le problème.

zmprov mdl informatique@xxxxxxxx.fr zimbraMailHost FDQN_host  
zmprov mdl interne@xxxxxxxx.fr zimbraMailHost FDQN_host 
zmprov mdl diffusion_mediatheque@xxxxxxxx.com zimbraMailHost FDQN_host

FDQN_host dans /etc/hosts

Quota

Affichage

     su zimbra
     zmprov gmi admin@xxxxxxx.fr
     

mailboxId: 2 quotaUsed: 1048575180 ( 1GO )

Modification

  su zimbra
  zmprov ma admin@xxxxxxx.fr zimbraMailQuota 2048576000

Vérification

  zmprov ga admin@xxxxxxx.fr | grep zimbraMailQuota

2048576000

Vidage d’une queue en deffered

    su root
    postsuper -d ALL deferred

Dénombrement de mail en queue qiuo dépassent les Quota :

    postqueue -p | grep -c "Over quota"

Contenu des mails ID pris au hasard :

    postcat -q 2F115168192D

recherche des clients Ipad

zgrep iPad mailbox.log.2015-03-19 | grep name | awk '{ print $5 }' | awk -F\; '{print $1}' | sort | uniq -c | sort -n

Contrôle des processus

   zmstatctl status
   zmstatctl restart

Vidage de boite au lettre

   zmmailbox -z -m admin@mail.domain.fr s -l 1000 -t message "in:inbox" | awk '{ if(NR > 4){print}}' | cut -c7- | awk '{print $1","}' | tr -d '\n' > /tmp/msgToDelete
   zmmailbox -z -m admin@mail.domain.fr dm `cat /tmp/msgToDelete`

Recherche de mot de passe

su zimbra ?

zmlocalconfig -s | grep mysql | grep password
zmlocalconfig -s | grep ldap | grep password

Incident Crash Zimbra

Préparation crash recovery zimbra 8.0

zmprov md <domain> zimbraDomainStatus maintenance
 zmprov ma zimbraAccountStatus active

/opt/zimbra/conf/my.cnf


innodb_force_recovery



/opt/zimbra/log/mysql_error.log and /opt/zimbra/log/mailbox.log for database errors

donne la version

zmcontrol -v

Release 8.6.0_GA_1153.RHEL6_64_20141215151155 RHEL6_64 FOSS edition, Patch 8.6.0_P3

zmcontrol stop
zmcontrol start


FQDN : Mail.tdc.fr


su zimbra

zmcontrol status

[zimbra@mail ~]$ zmcontrol status
Host mail.tdc.fr
	amavis                  Stopped
		amavisd is not running.
	antispam                Stopped
		zmamavisdctl is not running
	antivirus               Stopped
		zmamavisdctl is not running
	ldap                    Running
	logger                  Running
	mailbox                 Stopped
		mysql.server is not running.
	mta                     Running
	opendkim                Running
	service webapp          Stopped
		mysql.server is not running.
	snmp                    Running
	stats                   Stopped
	zimbra webapp           Stopped
		mysql.server is not running.
	zimbra webapp      Stopped
		mysql.server is not running.
	zimlet webapp           Stopped
		mysql.server is not running.
	zmconfigd               Running



postfix stop 

 zmcontrol status
Host mail.tdc.fr
	amavis                  Stopped
		amavisd is not running.
	antispam                Stopped
		zmamavisdctl is not running
	antivirus               Stopped
		zmamavisdctl is not running
	ldap                    Running
	logger                  Running
	mailbox                 Stopped
		mysql.server is not running.
	mta                     Stopped
		postfix is not running
	opendkim                Running
	service webapp          Stopped
		mysql.server is not running.
	snmp                    Running
	stats                   Stopped
	zimbra webapp           Stopped
		mysql.server is not running.
	zimbraAdmin webapp      Stopped
		mysql.server is not running.
	zimlet webapp           Stopped
		mysql.server is not running.
	zmconfigd               Running


zimbra@mail log]$ date
Thu Dec  3 08:03:32 CET 2015

/dev/mapper/vg_mail-lv_opt
   852G   33G  776G   5% /opt

 zmcontrol stop

 tar czfv /opt/db.tar.gz db/

(/opt/zimbra/db)

 zmcontrol start

stop mta

postfix stop

/opt/zimbra/conf/my.cnf

innodb_force_recovery = 1

innodb_force_recovery = 4

source ~/bin/zmshutil ; zmsetvars
[zimbra@mail conf]$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (111 "Connection refused")

innodb_force_recovery = 6

OK



zmmysqlstatus
MySQL uptime: 04 minutes

Connections and Threads:
-----------------------
Connections = 21
Max_used_connections = 4
Threads_cached = 0
Threads_connected = 4
Threads_created = 4
Threads_running = 1

Operations by type:
------------------
Com_select = 1
Com_insert = 0
Com_insert_select = 0
Com_update = 0
Com_delete = 0
Com_delete_multi = 0

Temp table activity:
-------------------
Created_tmp_disk_tables = 0
Created_tmp_files = 0

Row-level statistics:
--------------------
Handler_read_key = 0
Handler_read_first = 0
Handler_read_rnd = 0
Handler_read_rnd_next = 0
Handler_write = 0
Handler_update = 0
Handler_delete = 0
Handler_commit = 0
Handler_rollback = 0

Key Buffer:
----------
Key_read_requests = 0
Key_reads = 0
Key_write_requests = 0
Key_writes = 0

Handles:
-------
Open_files = 25
Open_tables = 96

Table scans:
-----------
Select_full_join = 0
Select_full_range_join = 0
Select_range_check = 0
Select_scan = 0

Sorting:
-------
Sort_merge_passes = 0
Sort_range = 0
Sort_rows = 0
Sort_scan = 0

Locking:
-------
Table_locks_immediate = 173
Table_locks_waited = 0

InnoDB Status:


MariaDB [(none)]> show databases ;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mboxgroup1         |
| mboxgroup10        |
| mboxgroup11        |
| mboxgroup12        |
| mboxgroup13        |
| mboxgroup14        |
| mboxgroup15        |
| mboxgroup16        |
| mboxgroup17        |
| mboxgroup18        |
| mboxgroup19        |
| mboxgroup2         |
| mboxgroup20        |
| mboxgroup21        |
| mboxgroup22        |
| mboxgroup23        |
| mboxgroup24        |
| mboxgroup25        |
| mboxgroup26        |
| mboxgroup27        |
| mboxgroup28        |
| mboxgroup29        |
| mboxgroup3         |
| mboxgroup30        |
| mboxgroup31        |
| mboxgroup32        |
| mboxgroup33        |
| mboxgroup34        |
| mboxgroup35        |
| mboxgroup36        |
| mboxgroup37        |
| mboxgroup38        |
| mboxgroup39        |
| mboxgroup4         |
| mboxgroup40        |
| mboxgroup41        |
| mboxgroup42        |
| mboxgroup5         |
| mboxgroup6         |
| mboxgroup7         |
| mboxgroup8         |
| mboxgroup9         |
| mysql              |
| performance_schema |
| test               |
| zimbra             |
+--------------------+
47 rows in set (0.00 sec)

mysql --batch --skip-column-names -e "show databases" | grep -e mbox -e zimbra > /opt/mysql.db.list

mysqldump $db -S $mysql_socket -u root --password=$mysql_root_password > /tmp/mysql.sql/$db.sql

mysqldump -u root -p$mysql_root_password --all-databases > /tmp/all_db.sql

/mysqldump -S /opt/zimbra/db/mysql.sock -u root --password=$mysql_root_password --all-databases > /tmp/all_db.sql

mysqldump: Got error: 2002: "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2 "No such file or directory")" when trying to connect

./mysqldump -S /opt/zimbra/db/mysql.sock -u root --password=$mysql_root_password --all-databases > /tmp/all_db.sql

SELECT /*!4!4000011 SSQL__NO__CACCHE */ ** FROROM ` `opeen_connversatiion`n`
Connection ID (thread ID): 8
Status: NOT_KILLED

 mysql --batch --skip-column-names -e "show databases" | grep -e mbox -e zimbra > /tmp/mysql.db.list
[zimbra@mail bin]$ mkdir /tmp/mysql.sql 
[zimbra@mail bin]$ for db in `cat /tmp/mysql.db.list`; do
>  ~/mysql/bin/mysqldump $db -S $mysql_socket -u root --password=$mysql_root_password > /tmp/mysql.sql/$db.sql
>      echo "Dumped $db"
>      sleep 10
>  done

Dumped mboxgroup1
Dumped mboxgroup10
Dumped mboxgroup11
Dumped mboxgroup12
Dumped mboxgroup13
Dumped mboxgroup14
Dumped mboxgroup15
Dumped mboxgroup16
Dumped mboxgroup17
Dumped mboxgroup18
Dumped mboxgroup19
Dumped mboxgroup2
Dumped mboxgroup20
Dumped mboxgroup21
Dumped mboxgroup22
Dumped mboxgroup23
Dumped mboxgroup24
Dumped mboxgroup25
Dumped mboxgroup26
Dumped mboxgroup27
Dumped mboxgroup28
Dumped mboxgroup29
Dumped mboxgroup3
Dumped mboxgroup30
Dumped mboxgroup31
Dumped mboxgroup32
Dumped mboxgroup33
Dumped mboxgroup34
Dumped mboxgroup35
Dumped mboxgroup36
Dumped mboxgroup37
Dumped mboxgroup38

mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM `open_conversation`': Lost connection to MySQL server during query (2013)
Dumped mboxgroup39

Dumped mboxgroup4
Dumped mboxgroup40
Dumped mboxgroup41

mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM `open_conversation`': Lost connection to MySQL server during query (2013)
Dumped mboxgroup42

Dumped mboxgroup5
Dumped mboxgroup6

mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `open_conversation` at row: 1554
Dumped mboxgroup7

Dumped mboxgroup8
Dumped mboxgroup9
Dumped zimbra


grep -n "Dump completed" *
mboxgroup10.sql:474:-- Dump completed on 2015-12-03  9:01:00
mboxgroup11.sql:474:-- Dump completed on 2015-12-03  9:01:10
mboxgroup12.sql:476:-- Dump completed on 2015-12-03  9:01:20
mboxgroup13.sql:471:-- Dump completed on 2015-12-03  9:01:30
mboxgroup14.sql:471:-- Dump completed on 2015-12-03  9:01:40
mboxgroup15.sql:471:-- Dump completed on 2015-12-03  9:01:50
mboxgroup16.sql:471:-- Dump completed on 2015-12-03  9:02:00
mboxgroup17.sql:471:-- Dump completed on 2015-12-03  9:02:10
mboxgroup18.sql:495:-- Dump completed on 2015-12-03  9:02:20
mboxgroup19.sql:471:-- Dump completed on 2015-12-03  9:02:30
mboxgroup1.sql:476:-- Dump completed on 2015-12-03  9:00:50
mboxgroup20.sql:471:-- Dump completed on 2015-12-03  9:02:50
mboxgroup21.sql:471:-- Dump completed on 2015-12-03  9:03:00
mboxgroup22.sql:471:-- Dump completed on 2015-12-03  9:03:11
mboxgroup23.sql:476:-- Dump completed on 2015-12-03  9:03:21
mboxgroup24.sql:471:-- Dump completed on 2015-12-03  9:03:31
mboxgroup25.sql:471:-- Dump completed on 2015-12-03  9:03:41
mboxgroup26.sql:471:-- Dump completed on 2015-12-03  9:03:51
mboxgroup27.sql:474:-- Dump completed on 2015-12-03  9:04:01
mboxgroup28.sql:471:-- Dump completed on 2015-12-03  9:04:11
mboxgroup29.sql:471:-- Dump completed on 2015-12-03  9:04:21
mboxgroup2.sql:487:-- Dump completed on 2015-12-03  9:02:40
mboxgroup30.sql:474:-- Dump completed on 2015-12-03  9:04:41
mboxgroup31.sql:471:-- Dump completed on 2015-12-03  9:04:51
mboxgroup32.sql:471:-- Dump completed on 2015-12-03  9:05:01
mboxgroup33.sql:479:-- Dump completed on 2015-12-03  9:05:11
mboxgroup34.sql:471:-- Dump completed on 2015-12-03  9:05:21
mboxgroup35.sql:474:-- Dump completed on 2015-12-03  9:05:31
mboxgroup36.sql:473:-- Dump completed on 2015-12-03  9:05:41
mboxgroup37.sql:471:-- Dump completed on 2015-12-03  9:05:51
mboxgroup38.sql:476:-- Dump completed on 2015-12-03  9:06:02
mboxgroup3.sql:475:-- Dump completed on 2015-12-03  9:04:31
mboxgroup40.sql:477:-- Dump completed on 2015-12-03  9:06:32
mboxgroup41.sql:473:-- Dump completed on 2015-12-03  9:06:42
mboxgroup4.sql:471:-- Dump completed on 2015-12-03  9:06:22
mboxgroup5.sql:483:-- Dump completed on 2015-12-03  9:07:02
mboxgroup6.sql:471:-- Dump completed on 2015-12-03  9:07:12
mboxgroup8.sql:481:-- Dump completed on 2015-12-03  9:07:32
mboxgroup9.sql:471:-- Dump completed on 2015-12-03  9:07:42
zimbra.sql:442:-- Dump completed on 2015-12-03  9:07:53

boite en echec 


 grep -L "Dump completed" /tmp/mysql.sql/*.sql

/tmp/mysql.sql/mboxgroup39.sql
/tmp/mysql.sql/mboxgroup42.sql
/tmp/mysql.sql/mboxgroup7.sql



dump de la base mysql
~/mysql/bin/mysqldump mysql -S $mysql_socket -u root --password=$mysql_root_password > /tmp/mysql.sql/mysql.sql;

OK

Arrêt interface web et boite mail

zmmailboxdctl stop

redump

for db in `cat /tmp/mysql.db.list`; do  ~/mysql/bin/mysqldump $db -S $mysql_socket -u root --password=$mysql_root_password > /tmp/mysql.sql/$db.sql;      echo "Dumped $db";      sleep 10;  done



151203  9:42:13 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup39"."tombstone"' in the cache. Attempting to load the tablespace with space id 1200.
151203  9:42:13 [ERROR] mysqld got signal 11 ;

This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see http://kb.askmonty.org/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed, 
something is definitely wrong and this may fail.

Server version: 10.0.15-MariaDB-log
key_buffer_size=134217728
read_buffer_size=1048576
max_used_connections=1
max_threads=112
thread_count=1
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 362747 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0x15716008
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x7f45738e2e38 thread_stack 0x48000
/opt/zimbra/mariadb/bin/mysqld(my_print_stacktrace+0x2e)[0xb7959e]
/opt/zimbra/mariadb/bin/mysqld(handle_fatal_signal+0x40b)[0x723e0b]
/lib64/libpthread.so.0[0x3bbf60f710]
/opt/zimbra/mariadb/bin/mysqld[0x9987be]
/opt/zimbra/mariadb/bin/mysqld[0x99dd56]
/opt/zimbra/mariadb/bin/mysqld[0x97ffa3]
/opt/zimbra/mariadb/bin/mysqld[0x9788f6]
/opt/zimbra/mariadb/bin/mysqld[0x8d03a2]
/opt/zimbra/mariadb/bin/mysqld(_ZN7handler13ha_index_nextEPh+0x114)[0x725394]
/opt/zimbra/mariadb/bin/mysqld[0x5ed32a]
/opt/zimbra/mariadb/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x1fe)[0x5d48fe]
/opt/zimbra/mariadb/bin/mysqld[0x5dc62d]
/opt/zimbra/mariadb/bin/mysqld(_ZN4JOIN10exec_innerEv+0xfa8)[0x602e68]
/opt/zimbra/mariadb/bin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x212)[0x6012d2]
/opt/zimbra/mariadb/bin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x28d)[0x60485d]
/opt/zimbra/mariadb/bin/mysqld[0x5a5e2c]
/opt/zimbra/mariadb/bin/mysqld(_Z21mysql_execute_commandP3THD+0x4d78)[0x5ae948]
/opt/zimbra/mariadb/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x3f9)[0x5b0819]
/opt/zimbra/mariadb/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x158b)[0x5b238b]
/opt/zimbra/mariadb/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x14e)[0x67e66e]
/opt/zimbra/mariadb/bin/mysqld(handle_one_connection+0x42)[0x67e992]
/lib64/libpthread.so.0[0x3bbf6079d1]
/lib64/libc.so.6(clone+0x6d)[0x3bbeee886d]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x374ac20): SELECT /*!40001 SQ1 SQL_NONO_CACHHE **/ ** FROMM `oppenn_cconnveerssattioon``
Connection ID (thread ID): 97
Status: NOT_KILLED

Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=onindex_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=offindex_merge_sort_intersection=off,engine_condition_pushdown=offengine_condition_pushdown=off,index_condition_pushdown=onindex_condition_pushdown=on,derived_merge=onderived_merge=on,derived_with_keys=onderived_with_keys=on,firstmatch=on,loosescan=on,materialization=onmaterialization=on,in_to_exists=onin_to_exists=on,semijoin=on,,partial_match_rowid_merge=on,partial_match_table_scan=onpartial_match_table_scan=on,subquery_cache=onsubquery_cache=on,mrr=off,,mrr_cost_based=off,,mrr_sort_keys=off,,outer_join_with_cache=on,,semijoin_with_cache=on,,join_cache_incremental=on,,join_cache_hashed=on,join_cache_bka=onjoin_cache_bka=on,optimize_join_buffer_size=off,,table_elimination=on,extended_keys=on,exists_to_in=onexists_to_in=on

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
151203 09:42:13 mysqld_safe Number of processes running now: 0
151203 09:42:13 mysqld_safe mysqld restarted
151203  9:42:13 [Note] InnoDB: Started in read only mode
151203  9:42:13 [Note] InnoDB: Using mutexes to ref count buffer pool pages
151203  9:42:13 [Note] InnoDB: The InnoDB memory heap is disabled
151203  9:42:13 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
151203  9:42:13 [Note] InnoDB: Memory barrier is not used
151203  9:42:13 [Note] InnoDB: Compressed tables use zlib 1.2.3
151203  9:42:13 [Note] InnoDB: Using Linux native AIO
151203  9:42:13 [Note] InnoDB: Compressed tables use zlib 1.2.3
151203  9:42:13 [Note] InnoDB: Using Linux native AIO
151203  9:42:13 [Note] InnoDB: Not using CPU crc32 instructions
151203  9:42:13 [Note] InnoDB: Disabling background IO write threads.
151203  9:42:13 [Note] InnoDB: Initializing buffer pool, size = 2.3G
151203  9:42:13 [Note] InnoDB: Completed initialization of buffer pool
151203  9:42:13 [Note] InnoDB: Highest supported file format is Barracuda.
151203  9:42:13 [Note] InnoDB: The user has set SRV_FORCE_NO_LOG_REDO on, skipping log redo
151203  9:42:13 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.21-70.0 started; log sequence number 0
151203  9:42:13 [Note] InnoDB: !!! innodb_force_recovery is set to 6 !!!
151203  9:42:13 [Note] InnoDB: !!! innodb_force_recovery is set to 6 !!!
151203  9:42:13 [Note] Plugin 'FEEDBACK' is disabled.
151203  9:42:13 [Note] Server socket created on IP: '127.0.0.1'.
151203  9:42:13 [Note] Event Scheduler: Loaded 0 events
151203  9:42:13 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."gtid_slave_pos"' in the cache. Attempting to load the tablespace with space id 968.
151203  9:42:13 [Warning] InnoDB: Allocated tablespace 968, old maximum was 0
151203  9:42:13 [Note] /opt/zimbra/mariadb/bin/mysqld: ready for connections.
Version: '10.0.15-MariaDB-log'  socket: '/opt/zimbra/db/mysql.sock'  port: 7306  Zimbra binary distribution
151203  9:42:23 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup4"."appointment"' in the cache. Attempting to load the tablespace with space id 53.
151203  9:42:23 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup4"."appointment_dumpster"' in the cache. Attempting to load the tablespace with space id 54.
151203  9:42:23 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup4"."data_source_item"' in the cache. Attempting to load the tablespace with space id 59.
151203  9:42:23 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup4"."imap_folder"' in the cache. Attempting to load the tablespace with space id 57.
151203  9:42:23 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup4"."imap_message"' in the cache. Attempting to load the tablespace with space id 58.
151203  9:42:23 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup4"."mail_item"' in the cache. Attempting to load the tablespace with space id 1029.
151203  9:42:23 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup4"."open_conversation"' in the cache. Attempting to load the tablespace with space id 52.
151203  9:42:23 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup4"."revision"' in the cache. Attempting to load the tablespace with space id 695.
151203  9:42:23 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup4"."tagged_item"' in the cache. Attempting to load the tablespace with space id 461.
151203  9:42:23 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup4"."mail_item_dumpster"' in the cache. Attempting to load the tablespace with space id 1030.
151203  9:42:23 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup4"."revision_dumpster"' in the cache. Attempting to load the tablespace with space id 696.
151203  9:42:23 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup4"."pop3_message"' in the cache. Attempting to load the tablespace with space id 56.
151203  9:42:23 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup4"."tag"' in the cache. Attempting to load the tablespace with space id 435.
151203  9:42:23 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup4"."tombstone"' in the cache. Attempting to load the tablespace with space id 55.
151203  9:42:33 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup40"."appointment"' in the cache. Attempting to load the tablespace with space id 1213.
151203  9:42:33 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup40"."appointment_dumpster"' in the cache. Attempting to load the tablespace with space id 1214.
151203  9:42:33 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup40"."data_source_item"' in the cache. Attempting to load the tablespace with space id 1219.
151203  9:42:33 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup40"."imap_folder"' in the cache. Attempting to load the tablespace with space id 1217.
151203  9:42:33 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup40"."imap_message"' in the cache. Attempting to load the tablespace with space id 1218.
151203  9:42:33 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup40"."mail_item"' in the cache. Attempting to load the tablespace with space id 1206.
151203  9:42:33 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup40"."open_conversation"' in the cache. Attempting to load the tablespace with space id 1212.
151203  9:42:33 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup40"."revision"' in the cache. Attempting to load the tablespace with space id 1208.
151203  9:42:33 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup40"."tagged_item"' in the cache. Attempting to load the tablespace with space id 1211.
151203  9:42:33 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup40"."mail_item_dumpster"' in the cache. Attempting to load the tablespace with space id 1207.
151203  9:42:33 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup40"."revision_dumpster"' in the cache. Attempting to load the tablespace with space id 1209.
151203  9:42:33 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup40"."pop3_message"' in the cache. Attempting to load the tablespace with space id 1216.
151203  9:42:33 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup40"."tag"' in the cache. Attempting to load the tablespace with space id 1210.
151203  9:42:33 [ERROR] InnoDB: Failed to find tablespace for table '"mboxgroup40"."tombstone"' in the cache. Attempting to load the tablespace with space id 1215.
2015-12-03 09:42:33 7f618e4df700  InnoDB: error clustered record for sec rec not found
InnoDB: index `i_conv_id` of table `mboxgroup40`.`open_conversation`
InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0
 0: len 4; hex 00000028; asc    (;;
 1: len 4; hex 00001000; asc  00001000; asc      ;;;
 2: 2: len 28; hex 5858574242544b4b7242425263637936364e34344d6b6b7278783966666a3131795151482b2b306b6b3d; asc ; asc XWWBTTKrrBRRcy66N4Mkkrxx9ffj11yQH++0kk=;;;


InnoDB: clust index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 0:PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 0: len 4; hex 000000000028; asc    (;;

 1: len 28; hex 58 len 28; hex 58414343717462676747414f69696b5a5a35366f65657766664b6c3858584368446f6f3d; asc XACCqttbgGAOOikZ56oewfKl8XChDDo==;;

 2: len 6; hex 00 len 6; hex 000005056ff87676; asc     oo v;;;
 3: len 7; hex 980000080c0150; asc         P;;;

 4: len 4; hex 00 len 4; hex 00000d0d61; asc     a;;;


TRANSACTION 91626006, ACTIVE 0 sec fetching rows
mysql tables in use 14, locked 14
MySQL thread id 3, OS thread handle 0x7f618e4df700, query id 279 localhost root Sending data
SELECT /*!40001 SQL_NO_CACHE */ * FROM `open_conversation`


Dumped mboxgroup7
mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `open_conversation` at row: 1554


boite en echec 


 grep -L "Dump completed" /tmp/mysql.sql/*.sql

/tmp/mysql.sql/mboxgroup39.sql
/tmp/mysql.sql/mboxgroup42.sql
/tmp/mysql.sql/mboxgroup7.sql



identificatoin de la bal en erreur

mysql --skip-column-names -e "SELECT id FROM zimbra.mailbox WHERE group_id=7" > /tmp/7list

une seule id par mboxgroup 7=7 42=42 etc

dump des tables 

mysql --skip-column-names -e "CONNECT mboxgroup7;SHOW TABLES" > /tmp/7tables

appointment
appointment_dumpster
data_source_item
imap_folder
imap_message
mail_item
mail_item_dumpster
open_conversation
pop3_message
revision
revision_dumpster
tag
tagged_item
tombstone

mkdir /tmp/7
for table in $(cat /tmp/7tables); do for i in $(cat /tmp/7list); do mysql -e "SELECT * FROM mboxgroup7.mail_item WHERE mailbox_id=$i" > /dev/null 2> /tmp/7/user-$i.err;done;done

/tmp/7/user-7.err vide pas d'erreur

tentative de dump
~/mysql/bin/mysqldump mboxgroup7 -S $mysql_socket -u root --password=$mysql_root_password > /tmp/mysql.sql/mboxgroup7_2.sql;

mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `open_conversation` at row: 1554


 zmlocalconfig -s zimbra_mysql_password
zimbra_mysql_password = AuddihzEm0tPvOcsJB9m9Byvz0NMK

echo $mysql_root_password
tS.gFsGWhYfosgEO1PiJlWM2xySdBD5J



mysql.server stop


kill -9 2PID_mysql

/opt/zimbra/db/data

cp -r data data_corrupt

mysql.server start

for db in `cat /tmp/mysql.db.list |grep mbox`
do
    mysql -u root --password=$mysql_root_password -e "drop database $db"
    echo -e "Dropped $db"
done

ERROR 1051 (42S02) at line 1: Unknown table 'mboxgroup23.appointment,mboxgroup23.appointment_dumpster,mboxgroup23.data_source_item,mboxgroup23.im' X toute les tables

Les databases ne se drop pas

mysql > drop database mboxgroup1 ;

ERROR 1051 (42S02): Unknown table 'mboxgroup1.appointment,mboxgroup1.appointment_dumpster,mboxgroup1.data_source_item,mboxgroup1.imap_f'


rm -rf  /opt/zimbra/db/data

mkdir /opt/zimbra/db/data 

 /opt/zimbra/libexec/zmmyinit --sql_root_pw $mysql_root_password

#Remove the innodb_force_recovery line from /opt/zimbra/conf/my.cnf 
. 
/opt/zimbra/libexec/zmmyinit --sql_root_pw $mysql_root_password

mysql -u root --password=$mysql_root_password

remise comme avant des droits zimbra et mysql

mysql -u root --password=$mysql_root_password zimbra < /tmp/mysql.sql/zimbra.sql 
mysql -u root --password=$mysql_root_password mysql < /opt/inter_syloe/mysql.dump1/mysql_db.sql  
flush privileges ;

test su zimbra , mysql ok connected sinon 
[zimbra@mail db]$ mysql
ERROR 1045 (28000): Access denied for user 'zimbra'@'localhost' (using password: YES)

reintégration 


for db in `cat /tmp/mysql.db.list`
do
    mysql -e "create database $db character set utf8"
    echo "Created $db"
done

ERROR 1007 (HY000) at line 1: Can't create database 'zimbra'; database exists
Created zimbra

normal

reintégration du reste 


for sql in /tmp/mysql.sql/mbox*
do
    mysql `basename $sql .sql` < $sql
    echo -e "Updated `basename $sql .sql` \n"
done

zmcontrol stop
zmcontrol start

dans /opt/zimbra/log/mailbox.log
Caused by: java.sql.SQLException: Access denied for user 'zimbra'@'localhost' (using password: YES)


zmlocalconfig -s | grep mysql_root_password
antispam_mysql_root_password = 
mysql_root_password = tS.gFsGWhYfosgEO1PiJlWM2xySdBD5J
tS.gFsGWhYfosgEO1PiJlWM2xySdBD5J

zmmypasswd --root tS.gFsGWhYfosgEO1PiJlWM2xySdBD5J
zmmypasswd AuddihzEm0tPvOcsJB9m9Byvz0NMK


[zimbra@mail log]$ zmlocalconfig -s | grep pass
antispam_mysql_password = 
antispam_mysql_root_password = 
client_ssl_truststore_password = ${mailboxd_truststore_password}
ldap_amavis_password = NgZuJDZ6
ldap_bes_searcher_password = zmbes-searcher
ldap_nginx_password = NgZuJDZ6
ldap_postfix_password = NgZuJDZ6
ldap_replication_password = NgZuJDZ6
ldap_root_password = NgZuJDZ6
mailboxd_keystore_base_password = zimbra
mailboxd_keystore_password = LNl0il8h
mailboxd_truststore_password = changeit
mysql_root_password = tS.gFsGWhYfosgEO1PiJlWM2xySdBD5J
zimbra_ldap_password = NgZuJDZ6
zimbra_mysql_password = AuddihzEm0tPvOcsJB9m9Byvz0NMK
zimbra_vami_password = vmware




068A2901207: to=<l.colon@tdc.fr>, relay=none, delay=62, delays=62/0/0/0.01, dsn=4.4.1, status=deferred (delivery temporarily suspended: connect to 127.0.0.1[127.0.0.1]:10024: Connection refused)


2015-12-03 12:08:27,483 ERROR [qtp509886383-234:http://127.0.0.1:2095/service/soap/BatchRequest] [name=n.gravet@tdc.fr;mid=5;oip=78.238.147.165;ua=ZCS/8.6.0_GA_1178;] mailbox - Failed to lock mailbox
Write Lock Owner - qtp509886383-157 prio=5 id=157 state=TERMINATED

com.zimbra.cs.mailbox.MailboxLock$LockFailedException: timeout
	at com.zimbra.cs.mailbox.MailboxLock.lock(MailboxLock.java:211)
	at com.zimbra.cs.mailbox.Mailbox.getFolderTree(Mailbox.java:4053)
	at com.zimbra.cs.session.SoapSession.expandLocalMountpoint(SoapSession.java:1120)
	at com.zimbra.cs.session.SoapSession.expandLocalMountpoints(SoapSession.java:1080)
	at com.zimbra.cs.session.SoapSession.expandLocalMountpoints(SoapSession.java:1083)
	at com.zimbra.cs.session.SoapSession.putRefresh(SoapSession.java:1064)
	at com.zimbra.soap.SoapEngine.generateResponseHeader(SoapEngine.java:689)
	at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:473)
	at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:266)
	at com.zimbra.soap.SoapServlet.doWork(SoapServlet.java:303)
	at com.zimbra.soap.SoapServlet.doPost(SoapServlet.java:213)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
	at com.zimbra.cs.servlet.ZimbraServlet.service(ZimbraServlet.java:206)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:738)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1651)
	at com.zimbra.cs.servlet.CsrfFilter.doFilter(CsrfFilter.java:176)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at com.zimbra.cs.servlet.RequestStringFilter.doFilter(RequestStringFilter.java:54)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at com.zimbra.cs.servlet.SetHeaderFilter.doFilter(SetHeaderFilter.java:59)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:83)
	at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:351)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at com.zimbra.cs.servlet.ETagHeaderFilter.doFilter(ETagHeaderFilter.java:47)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at com.zimbra.cs.servlet.ContextPathBasedThreadPoolBalancerFilter.doFilter(ContextPathBasedThreadPoolBalancerFilter.java:107)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at com.zimbra.cs.servlet.ZimbraQoSFilter.doFilter(ZimbraQoSFilter.java:116)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at com.zimbra.cs.servlet.ZimbraInvalidLoginFilter.doFilter(ZimbraInvalidLoginFilter.java:131)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at org.eclipse.jetty.servlets.DoSFilter.doFilterChain(DoSFilter.java:457)
	at org.eclipse.jetty.servlets.DoSFilter.doFilter(DoSFilter.java:326)
	at org.eclipse.jetty.servlets.DoSFilter.doFilter(DoSFilter.java:299)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:549)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:544)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1111)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:478)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1045)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
	at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:199)
	at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
	at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:309)
	at org.eclipse.jetty.server.handler.DebugHandler.handle(DebugHandler.java:81)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
	at org.eclipse.jetty.server.Server.handle(Server.java:462)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:279)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:232)
	at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:534)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:607)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:536)
	at java.lang.Thread.run(Thread.java:745)
2015-12-03 12:08:27,487 WARN  [qtp509886383-234:http://127.0.0.1:2095/service/soap/BatchRequest] [name=n.gravet@tdc.fr;mid=5;oip=78.238.147.165;ua=ZCS/8.6.0_GA_1178;] soap - handler exception
com.zimbra.cs.mailbox.MailboxLock$LockFailedException: timeout
	at com.zimbra.cs.mailbox.MailboxLock.lock(MailboxLock.java:211)
	at com.zimbra.cs.mailbox.Mailbox.getFolderTree(Mailbox.java:4053)
	at com.zimbra.cs.session.SoapSession.expandLocalMountpoint(SoapSession.java:1120)
	at com.zimbra.cs.session.SoapSession.expandLocalMountpoints(SoapSession.java:1080)
	at com.zimbra.cs.session.SoapSession.expandLocalMountpoints(SoapSession.java:1083)
	at com.zimbra.cs.session.SoapSession.putRefresh(SoapSession.java:1064)
	at com.zimbra.soap.SoapEngine.generateResponseHeader(SoapEngine.java:689)
	at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:473)
	at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:266)
	at com.zimbra.soap.SoapServlet.doWork(SoapServlet.java:303)
	at com.zimbra.soap.SoapServlet.doPost(SoapServlet.java:213)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
	at com.zimbra.cs.servlet.ZimbraServlet.service(ZimbraServlet.java:206)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:738)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1651)
	at com.zimbra.cs.servlet.CsrfFilter.doFilter(CsrfFilter.java:176)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at com.zimbra.cs.servlet.RequestStringFilter.doFilter(RequestStringFilter.java:54)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at com.zimbra.cs.servlet.SetHeaderFilter.doFilter(SetHeaderFilter.java:59)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:83)
	at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:351)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at com.zimbra.cs.servlet.ETagHeaderFilter.doFilter(ETagHeaderFilter.java:47)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at com.zimbra.cs.servlet.ContextPathBasedThreadPoolBalancerFilter.doFilter(ContextPathBasedThreadPoolBalancerFilter.java:107)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at com.zimbra.cs.servlet.ZimbraQoSFilter.doFilter(ZimbraQoSFilter.java:116)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at com.zimbra.cs.servlet.ZimbraInvalidLoginFilter.doFilter(ZimbraInvalidLoginFilter.java:131)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at org.eclipse.jetty.servlets.DoSFilter.doFilterChain(DoSFilter.java:457)
	at org.eclipse.jetty.servlets.DoSFilter.doFilter(DoSFilter.java:326)
	at org.eclipse.jetty.servlets.DoSFilter.doFilter(DoSFilter.java:299)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:549)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:544)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1111)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:478)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1045)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
	at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:199)
	at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
	at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:309)
	at org.eclipse.jetty.server.handler.DebugHandler.handle(DebugHandler.java:81)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
	at org.eclipse.jetty.server.Server.handle(Server.java:462)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:279)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:232)
	at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:534)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:607)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:536)
	at java.lang.Thread.run(Thread.java:745)

adminovatek@tdc.fr
P@ss4_CR34!

2015-12-03 12:32:36,400 WARN  [MailboxPurge] [name=c.rumeau@tdc.fr;mid=39;] purge - Unable to purge mailbox 39
com.zimbra.common.service.ServiceException: system failure: fetching all tags for mailbox 39


2015-12-03 12:32:36,400 WARN  [MailboxPurge] [name=c.rumeau@tdc.fr;mid=39;] purge - Unable to purge mailbox 39
com.zimbra.common.service.ServiceException: system failure: fetching all tags for mailbox 39
ExceptionId:MailboxPurge:1449142356399:ffc2f56ed921910f
Code:service.FAILURE
	at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:260)
	at com.zimbra.cs.db.DbTag.getAllTags(DbTag.java:227)
	at com.zimbra.cs.db.DbMailItem.getFoldersAndTags(DbMailItem.java:2148)
	at com.zimbra.cs.mailbox.Mailbox.loadFoldersAndTags(Mailbox.java:2201)
	at com.zimbra.cs.mailbox.Mailbox.beginTransaction(Mailbox.java:1771)
	at com.zimbra.cs.mailbox.Mailbox.beginTransaction(Mailbox.java:1691)
	at com.zimbra.cs.mailbox.Mailbox.purgeMessages(Mailbox.java:8491)
	at com.zimbra.cs.mailbox.PurgeThread.run(PurgeThread.java:157)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mboxgroup39.tag' doesn't exist

Query being executed when exception was thrown:
SELECT id, name, color, item_count, unread, listed, sequence, policy FROM mboxgroup39.tag WHERE mailbox_id = 39 AND id > 0


	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2834)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2313)
	at com.zimbra.cs.db.DebugPreparedStatement.executeQuery(DebugPreparedStatement.java:165)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at com.zimbra.cs.db.StatTrackingPreparedStatement.executeQuery(StatTrackingPreparedStatement.java:352)
	at com.zimbra.cs.db.DbTag.getAllTags(DbTag.java:221)


j.benaim@tdc.fr, target account=j.benaim@tdc.fr
2015-12-03 12:43:09,604 INFO  [qtp509886383-201:http://127.0.0.1:2095/service/soap/GetFolderRequest] [name=j.benaim@tdc.fr;aname=adminovatek@tdc.fr;mid=7;oip=88.167.75.104;ua=zclient/8.6.0_GA_1178;] cache - initializing folder and tag caches for mailbox 7
2015-12-03 12:43:09,610 INFO  [qtp509886383-201:http://127.0.0.1:2095/service/soap/GetFolderRequest] [name=j.benaim@tdc.fr;aname=adminovatek@tdc.fr;mid=7;oip=88.167.75.104;ua=zclient/8.6.0_GA_1178;] SoapEngine - handler exception
com.zimbra.common.service.ServiceException: system failure: fetching all tags for mailbox 7
ExceptionId:qtp509886383-201:http://127.0.0.1:2095/service/soap/GetFolderRequest:1449142989608:edf583f5b239a165
Code:service.FAILURE
	at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:260)
	at com.zimbra.cs.db.DbTag.getAllTags(DbTag.java:227)
	at com.zimbra.cs.db.DbMailItem.getFoldersAndTags(DbMailItem.java:2148)
	at com.zimbra.cs.mailbox.Mailbox.loadFoldersAndTags(Mailbox.java:2201)
	at com.zimbra.cs.mailbox.Mailbox.beginTransaction(Mailbox.java:1771)
	at com.zimbra.cs.mailbox.Mailbox.beginReadTransaction(Mailbox.java:1686)
	at com.zimbra.cs.mailbox.Mailbox.getItemById(Mailbox.java:2773)
	at com.zimbra.cs.mailbox.Mailbox.getItemById(Mailbox.java:2765)
	at com.zimbra.cs.mailbox.Mailbox.getFolderById(Mailbox.java:3903)
	at com.zimbra.cs.mailbox.Mailbox.getFolderTree(Mailbox.java:4057)
	at com.zimbra.cs.service.mail.GetFolder.handle(GetFolder.java:113)
	at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEngine.java:569)
	at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:432)
	at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:266)
	at com.zimbra.soap.SoapServlet.doWork(SoapServlet.java:303)
	at com.zimbra.soap.SoapServlet.doPost(SoapServlet.java:213)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
	at com.zimbra.cs.servlet.ZimbraServlet.service(ZimbraServlet.java:206)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:738)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1651)
	at com.zimbra.cs.servlet.CsrfFilter.doFilter(CsrfFilter.java:176)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at com.zimbra.cs.servlet.RequestStringFilter.doFilter(RequestStringFilter.java:54)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at com.zimbra.cs.servlet.SetHeaderFilter.doFilter(SetHeaderFilter.java:59)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:83)
	at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:351)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at com.zimbra.cs.servlet.ETagHeaderFilter.doFilter(ETagHeaderFilter.java:47)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at com.zimbra.cs.servlet.ContextPathBasedThreadPoolBalancerFilter.doFilter(ContextPathBasedThreadPoolBalancerFilter.java:107)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at com.zimbra.cs.servlet.ZimbraQoSFilter.doFilter(ZimbraQoSFilter.java:116)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at com.zimbra.cs.servlet.ZimbraInvalidLoginFilter.doFilter(ZimbraInvalidLoginFilter.java:131)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at org.eclipse.jetty.servlets.DoSFilter.doFilterChain(DoSFilter.java:457)
	at org.eclipse.jetty.servlets.DoSFilter.doFilter(DoSFilter.java:326)
	at org.eclipse.jetty.servlets.DoSFilter.doFilter(DoSFilter.java:299)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1622)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:549)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:544)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:221)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1111)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:478)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1045)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
	at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:199)
	at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
	at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:309)
	at org.eclipse.jetty.server.handler.DebugHandler.handle(DebugHandler.java:81)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
	at org.eclipse.jetty.server.Server.handle(Server.java:462)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:279)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:232)
	at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:534)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:607)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:536)
	at java.lang.Thread.run(Thread.java:745)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mboxgroup7.tag' doesn't exist

Query being executed when exception was thrown:
SELECT id, name, color, item_count, unread, listed, sequence, policy FROM mboxgroup7.tag WHERE mailbox_id = 7 AND id > 0

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mboxgroup39.tag' doesn't exist

Query being executed when exception was thrown:
SELECT id, name, color, item_count, unread, listed, sequence, policy FROM mboxgroup39.tag WHERE mailbox_id = 39 AND id > 


com.zimbra.cs.mailbox.MailboxLock$LockFailedException: timeout florence@tdc.fr

 /opt/zimbra/libexec/zmdiaglog -ajz
Saving diagnostic logging output to: /opt/zimbra/data/tmp/zmdiaglog-mail.tdc.fr.20151203-130208.25880

/opt/zimbra/data/tmp/zmdiaglog-mail.tdc.fr.20151203-130208.25880

zmlocalconfig mailboxd_java_options

mailboxd_java_options = -server -Djava.awt.headless=true -Dsun.net.inetaddr.ttl=${networkaddress_cache_ttl} -Dorg.apache.jasper.compiler.disablejsr199=true -XX:+UseConcMarkSweepGC -XX:PermSize=128m -XX:MaxPermSize=350m -XX:SoftRefLRUPolicyMSPerMB=1 -verbose:gc -XX:+PrintGCDetails -XX:+PrintGCApplicationStoppedTime -XX:-OmitStackTraceInFastThrow -Djava.net.preferIPv4Stack=true -XX:+PrintGCDateStamps -Xloggc:/opt/zimbra/log/gc.log -XX:-UseGCLogFileRotation -XX:NumberOfGCLogFiles=20 -XX:GCLogFileSize=4096K


To disable a Zimlet on the Zimbra server
Type zmzimletctl disable <zimletname>
Note: To enable a disabled Zimlet, type zmzimletctl enable <zimletname>.

 zmzimletctl listZimlets

com_zextras_zextras
zmzimletctl disable com_zextras_zextras
rien a faire => perte interface d'adminsitration

on réactive

zmzimletctl enable com_zextras_zextras

2015-12-03 13:33:21,670 ERROR [ZeXtras Activity Thread] [] extensions - Cannot migrate account config for account 20932ec4-a6a4-4f40-91d5-43d8f54f00f7: Unable to save configuration to mailbox 7

 Tables_in_mboxgroup6 |
+----------------------+  
| appointment          |
| appointment_dumpster |
| data_source_item     |
| imap_folder          |
| imap_message         |
| mail_item            |
| mail_item_dumpster   |
| open_conversation  
  |
| pop3_message         |
| revision             |
| revision_dumpster    |
| tag                  |
| tagged_item          |
| tombstone            |


desc pop3_message

CREATE TABLE `pop3_message` (
  `mailbox_id` int(10) unsigned NOT NULL,
  `data_source_id` char(36) NOT NULL,
  `uid` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `item_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`mailbox_id`,`item_id`),
  UNIQUE KEY `i_uid_pop3_id` (`uid`,`data_source_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `revision` (
  `mailbox_id` int(10) unsigned NOT NULL,
  `item_id` int(10) unsigned NOT NULL,
  `version` int(10) unsigned NOT NULL,
  `date` int(10) unsigned NOT NULL,
  `size` bigint(20) unsigned NOT NULL,
  `locator` varchar(1024) DEFAULT NULL,
  `blob_digest` varchar(44) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `metadata` mediumtext,
  `mod_metadata` int(10) unsigned NOT NULL,
  `change_date` int(10) unsigned DEFAULT NULL,
  `mod_content` int(10) unsigned NOT NULL,
  PRIMARY KEY (`mailbox_id`,`item_id`,`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `revision_dumpster` (
  `mailbox_id` int(10) unsigned NOT NULL,
  `item_id` int(10) unsigned NOT NULL,
  `version` int(10) unsigned NOT NULL,
  `date` int(10) unsigned NOT NULL,
  `size` bigint(20) unsigned NOT NULL,
  `locator` varchar(1024) DEFAULT NULL,
  `blob_digest` varchar(44) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `metadata` mediumtext,
  `mod_metadata` int(10) unsigned NOT NULL,
  `change_date` int(10) unsigned DEFAULT NULL,
  `mod_content` int(10) unsigned NOT NULL,
  PRIMARY KEY (`mailbox_id`,`item_id`,`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `tag` (
  `mailbox_id` int(10) unsigned NOT NULL,
  `id` int(11) NOT NULL,
  `name` varchar(128) NOT NULL,
  `color` bigint(20) DEFAULT NULL,
  `item_count` int(11) NOT NULL DEFAULT '0',
  `unread` int(11) NOT NULL DEFAULT '0',
  `listed` tinyint(1) NOT NULL DEFAULT '0',
  `sequence` int(10) unsigned NOT NULL,
  `policy` varchar(1024) DEFAULT NULL,
  PRIMARY KEY (`mailbox_id`,`id`),
  UNIQUE KEY `i_tag_name` (`mailbox_id`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `tagged_item` (
  `mailbox_id` int(10) unsigned NOT NULL,
  `tag_id` int(11) NOT NULL,
  `item_id` int(10) unsigned NOT NULL,
  UNIQUE KEY `i_tagged_item_unique` (`mailbox_id`,`tag_id`,`item_id`),
  KEY `fk_tagged_item_item` (`mailbox_id`,`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `tombstone` (
  `mailbox_id` int(10) unsigned NOT NULL,
  `sequence` int(10) unsigned NOT NULL,
  `date` int(10) unsigned NOT NULL,
  `type` tinyint(4) DEFAULT NULL,
  `ids` text,
  KEY `i_sequence` (`mailbox_id`,`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

mboxgroup42

problème d'heure sur le serveur, le named utilise dnssec.

error (broken trust chain) resolving pour RBL dans /var/log/message

J'ai modifié dans le fichier /etc/named.conf

#	dnssec-enable yes;
#	dnssec-validation yes;
       dnssec-enable no;
       dnssec-validation no;


pid amavis bloqué suppression /opt/zimbra/log/amavisd.pid


backup full de la DB mis dans /opt/rescue/mysql_dump_clean_3-12-2015-18-42.tar.gz

su zimbra
source ~/bin/zmshutil ; zmsetvars