_Export_Import_Dados

#!/bin/bash

#+----------------GERANDO LOG-----------------------+OK"
SCRIPT=`basename $0`
LOG=`echo $SCRIPT.log | sed s/'.sh'/'.log'/g`
exec &> >(tee -a "$LOG")
echo "[`date`] ==== Inicio de rotina..."
#+----------------GERANDO LOG-----------------------+OK"

cd /tmp/
clear

#Checa se o usuario é zimbra
LOCAL_USER=`id -u -n`

if [ $LOCAL_USER != "zimbra" ] ; then
	echo "     Rodar como usuario Zimbra"
	echo "     saindo..."
	echo ""
	exit
fi
Principal() {
	clear
     dir="Diretorio Atual		 : `pwd`"
	 hostname="Hostname			 : `hostname --fqdn`"
	 ip="IP						 : `wget -qO - icanhazip.com`"
	 #ip="IP					 : `ifconfig | awk 'NR>=2 && NR<=2' | awk '{print $3}'`"
     versaoso="Versao S.O.		 : `lsb_release -d | cut -d : -f 2- | sed 's/^[ \t]*//;s/[ \t]*$//'`"
	 release="Release			 : `lsb_release -r | cut -d : -f 2- | sed 's/^[ \t]*//;s/[ \t]*$//'`"
	 codename="Codename			 : `lsb_release -c | cut -d : -f 2- | sed 's/^[ \t]*//;s/[ \t]*$//'`"
	 kernel="Kernel				 : `uname -r`"
	 arquitetura="Arquitetura	 : `uname -m`"
	 versaozimbra="Versao Zimbra : `/opt/zimbra/bin/zmcontrol -v`"
	 echo
     echo "+-------------------------------------------------+"
     echo "|           Utilitario para Zimbra                |"
     echo "+-------------------------------------------------+"
     echo "| Exportar / Importar Contas do Zimbra    v1.36   |"
     echo "+-------------------------------------------------+"
     echo "| Escrito por:                                    |"
     echo "| Thiago Castro - www.hostlp.cloud                |"
     echo "+-------------------------------------------------+"
     echo
     echo $dir
	 echo "+-------------------------------------------------+"
	 echo $hostname
	 echo "+-------------------------------------------------+"
	 echo $ip
	 echo "+-------------------------------------------------+"
	 echo $versaoso
	 echo "+-------------------------------------------------+"
	 echo $release
	 echo "+-------------------------------------------------+"
	 echo $codename
	 echo "+-------------------------------------------------+"
     echo $kernel
	 echo "+-------------------------------------------------+"
     echo $arquitetura
	 echo "+-------------------------------------------------+"
	 echo $versaozimbra
	 echo "+-------------------------------------------------+"
	 echo
	 echo "Este script irá exportar ou importar os dados de: "
	 echo "--> COS, dominios, contas, contatos, agendas, listas,"
	 echo "alias, assinaturas, filtros e briefcase <--"
	 echo "+-------------------------------------------------+"
     echo
	 echo "Aperte <ENTER> para continuar e começar..."
	 read 
	 echo "Opções:"
	 echo
     echo "1. Exportar"
	 echo "2. Importar"
	 echo
	 echo "3. Sair"
	 echo
	 echo
     echo -n "Entre com a opcao desejada => "
     read opcao
     echo
     case $opcao in
        1) Exportar1 ;;
        2) Importar1 ;;
        3) exit ;;
        *) "Opcao desconhecida." ; echo ; Principal ;;
     esac
}

Exportar1() {
# EXPORTAÇÃO POR DOMINIO
	clear
	source /opt/zimbra/bin/zmshutil
	zmsetvars
	zmprov="/opt/zimbra/bin/zmprov"
	zmmailbox="/opt/zimbra/bin/zmmailbox"
	ldapsearch="/opt/zimbra/common/bin/ldapsearch"
	ldapadd="/opt/zimbra/common/bin/ldapadd"
	echo "Digite o dominio completo para exportar os dados ou deixe vazio"
	echo "para exportar os dados de todos os dominios cadastrados"
	echo
	echo -n "Digite o dominio completo...: "
	read DOMAIN
	echo
	cd /opt/zimbra/backup/
	NULL="2>/dev/null"
	HOST=`hostname -d`
	DEST="/opt/zimbra/backup/"$DOMAIN""
	mkdir /tmp/$DOMAIN-BKP-$(date "+%Y%m%d") 2>/dev/null
	\mv $DEST /tmp/$DOMAIN-BKP-$(date "+%Y%m%d") 2>/dev/null
	mkdir $DEST/ldap $DEST/cos $DEST/dominio $DEST/contas $DEST/contatos $DEST/listas $DEST/alias $DEST/assinaturas $DEST/filtros $DEST/briefcase $DEST/agendas $DEST/chats $DEST/tags $DEST/comments $DEST/documentos $DEST/tarefas $DEST/mysql -p 2>/dev/null
	chown zimbra:zimbra $DEST -R

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

	echo "Exportando LDAP..."
	echo
/opt/zimbra/libexec/zmslapcat $DEST/ldap
	echo "+-------------------------------------------------+OK"
	echo

	echo "Exportando Configs LDAP..."
	echo
/opt/zimbra/libexec/zmslapcat -c $DEST/ldap
	echo "+-------------------------------------------------+OK"
	echo

	echo "Exportando AccessLog LDAP..."
	echo
/opt/zimbra/libexec/zmslapcat -a $DEST/ldap
	echo "+-------------------------------------------------+OK"
	echo
		
	echo "Exportar todas COS? - Sim/Nao"
	read CONFIRMA
	case $CONFIRMA in
	s|S|Sim|sim)
$ldapsearch -x -H $ldap_master_url -D $zimbra_ldap_userdn -w $zimbra_ldap_password -b '' -LLL "(objectclass=zimbraCOS)" > $DEST/cos/cos.ldiff
		;;
	n|N|Nao|nao)
	echo -n "Digite o nome do COS...: "
	read COS
	echo
$ldapsearch -x -H $ldap_master_url -D $zimbra_ldap_userdn -w $zimbra_ldap_password -b '' -LLL "(objectclass=zimbraCOS)" > $DEST/cos/"$COS".ldiff
	sed -i '/cn='$COS'/,$!d' $DEST/cos/"$COS".ldiff
	sed -i '/^$/,$d' $DEST/cos/"$COS".ldiff
		;;
	*) echo  "Opcao Invalida" ;; esac
	echo "+-------------------------------------------------+OK"
	echo
	
	echo "Exportando Dominio..."
	echo
$zmprov gad | grep "$DOMAIN" | tee -a $DEST/dominio/dominio
	echo "+-------------------------------------------------+OK"
	echo
	
	echo "Exportando Contas..."
	echo
	zmhostname > $DEST/server_old
$zmprov -l gaaa |grep "$DOMAIN" | egrep -v "^virus|^ham|^spam|^galsync" > $DEST/contas/admins
$zmprov -l gaa |grep "$DOMAIN" | egrep -v "^virus|^ham|^spam|^galsync" > $DEST/contas/usuarios
for user in `cat $DEST/contas/usuarios`; do $ldapsearch -x -H $ldap_master_url -D $zimbra_ldap_userdn -w $zimbra_ldap_password -b '' -LLL "(zimbraMailDeliveryAddress=$user)" > $DEST/contas/$user.ldiff
	printf 'OK --> '
	echo "$user" ; done
	echo "+-------------------------------------------------+OK"
	echo

	echo "Exportar dados de caixa postal? (tgz) - Sim/Nao"
	read CONFIRMA
	case $CONFIRMA in
	s|S|Sim|sim)
$zmprov -l gaa |grep "$DOMAIN" | egrep -v "^virus|^ham|^spam|^galsync" | while read user; do $zmmailbox -z -m $user gru "/?fmt=tgz" > $DEST/contas/"$user".tgz
	printf 'OK --> '
	echo "$user" ; done
		;;
	n|N|Nao|nao)
		;;
	*) echo  "Opcao Invalida" ;; esac
	echo "+-------------------------------------------------+OK"
	echo

	echo "Exportando Briefcase..."
	echo
$zmprov -l gaa |grep "$DOMAIN" | egrep -v "^virus|^ham|^spam|^galsync" | while read user; do $zmmailbox -z -m $user gru "/Briefcase/?fmt=tgz" > $DEST/briefcase/"$user"-briefcase.tgz 2>/dev/null
	printf 'OK --> '
	echo "$user" ; done 
	echo "+-------------------------------------------------+OK"
	echo

	echo "Exportando Agendas..."
	echo
$zmprov -l gaa |grep "$DOMAIN" | egrep -v "^virus|^ham|^spam|^galsync" | while read user; do $zmmailbox -z -m $user gru "/Calendar/?fmt=tgz" > $DEST/agendas/"$user"-agendas.tgz 2>/dev/null
	printf 'OK --> '
	echo "$user" ; done 
	echo "+-------------------------------------------------+OK"
	echo

	echo "Exportando Chats..."
	echo
$zmprov -l gaa |grep "$DOMAIN" | egrep -v "^virus|^ham|^spam|^galsync" | while read user; do $zmmailbox -z -m $user gru "/Chats/?fmt=tgz" > $DEST/chats/"$user"-chats.tgz 2>/dev/null
	printf 'OK --> '
	echo "$user" ; done 
	echo "+-------------------------------------------------+OK"
	echo

	echo "Exportando Tags..."
	echo
$zmprov -l gaa |grep "$DOMAIN" | egrep -v "^virus|^ham|^spam|^galsync" | while read user; do $zmmailbox -z -m $user gru "/Tags/?fmt=tgz" > $DEST/tags/"$user"-tags.tgz 2>/dev/null
	printf 'OK --> '
	echo "$user" ; done 
	echo "+-------------------------------------------------+OK"
	echo

	echo "Exportando Comments..."
	echo
$zmprov -l gaa |grep "$DOMAIN" | egrep -v "^virus|^ham|^spam|^galsync" | while read user; do $zmmailbox -z -m $user gru "/Comments/?fmt=tgz" > $DEST/comments/"$user"-comments.tgz 2>/dev/null
	printf 'OK --> '
	echo "$user" ; done 
	echo "+-------------------------------------------------+OK"
	echo
		
	echo "Exportando Contatos..."
	echo
$zmprov -l gaa |grep "$DOMAIN" | egrep -v "^virus|^ham|^spam|^galsync" | while read user; do $zmmailbox -z -m $user gru "/Contacts/?fmt=tgz" > $DEST/contatos/"$user"-contatos.tgz 2>/dev/null
$zmmailbox -z -m $user gru "/Emailed Contacts/?fmt=tgz" > $DEST/contatos/"$user"-emailed.tgz 2>/dev/null
	printf 'OK --> '
	echo "$user" ; done
	echo "+-------------------------------------------------+OK"
	echo

	echo "Exportando Documentos..."
	echo
$zmprov -l gaa |grep "$DOMAIN" | egrep -v "^virus|^ham|^spam|^galsync" | while read user; do $zmmailbox -z -m $user gru "/Notebook/?fmt=tgz" > $DEST/documentos/"$user"-documentos.tgz 2>/dev/null
	printf 'OK --> '
	echo "$user" ; done 
	echo "+-------------------------------------------------+OK"
	echo

	echo "Exportando Tarefas..."
	echo
$zmprov -l gaa |grep "$DOMAIN" | egrep -v "^virus|^ham|^spam|^galsync" | while read user; do $zmmailbox -z -m $user gru "/Tasks/?fmt=tgz" > $DEST/tarefas/"$user"-tarefas.tgz 2>/dev/null
	printf 'OK --> '
	echo "$user" ; done 
	echo "+-------------------------------------------------+OK"
	echo

	echo "Exportando Listas de Distribuição..."
	echo
$zmprov gadl |grep "$DOMAIN" > $DEST/listas/listas
$zmprov gadl |grep "$DOMAIN" | while read user_listas; do $zmprov gdlm $user_listas > $DEST/listas/$user_listas
	printf 'OK --> '
	echo "$user_listas -- OK" ; done
	echo "+-------------------------------------------------+OK"
	echo

	echo "Exportando Alias..."
	echo
$zmprov -l gaa |grep "$DOMAIN" | egrep -v "^virus|^ham|^spam|^galsync" | while read user; do $zmprov ga $user | grep zimbraMailAlias | awk '{print $2}' > $DEST/alias/"$user"
	printf 'OK --> '
	echo "$user" ; done
	echo "+-------------------------------------------------+OK"
	echo

	echo "Exportando Assinaturas..."
	echo
$zmprov -l gaa |grep "$DOMAIN" | egrep -v "^virus|^ham|^spam|^galsync" | while read user; do $zmprov gsig $user > $DEST/assinaturas/"$user"
	printf 'OK --> '
	echo "$user" ; done
	sed -i '/zimbraSignatureId/d' $DEST/assinaturas/"$user" ;
	sed -i '/# name/d' $DEST/assinaturas/"$user" ;
	echo "+-------------------------------------------------+OK"
	echo

	echo "Exportando Filtros..."
	echo
for user in `cat $DEST/contas/usuarios`; do $zmprov ga $user zimbraMailSieveScript > /tmp/filtros
    sed -i -e "1d" /tmp/filtros
    sed 's/zimbraMailSieveScript: //g' /tmp/filtros  > $DEST/filtros/$user.filtros
    echo "$user" ; done 
	echo "+-------------------------------------------------+OK"
	echo

	echo "Exportando MySQL..."
	echo
mysqldump --all-databases -S $mysql_socket -u root --password=$mysql_root_password | gzip > $DEST/mysql/zimbra.sql.gz
	echo "+-------------------------------------------------+OK"
	echo
	
	echo "Limpando arquivos vazios..."
	echo
	cd $DEST
	find . -type f -empty -exec rm -rf {} \;
	chown zimbra:zimbra $DEST -R
	echo "Dados Exportados"
    echo "Pressione qualquer tecla para continuar..."
    read msg
    Principal
}

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

Importar1() {
# IMPORTAÇÂO POR DOMINIO
# já com todos os dados no novo servidor
	clear
	source /opt/zimbra/bin/zmshutil
	zmsetvars
	zmprov="/opt/zimbra/bin/zmprov"
	zmmailbox="/opt/zimbra/bin/zmmailbox"
	ldapsearch="/opt/zimbra/common/bin/ldapsearch"
	ldapadd="/opt/zimbra/common/bin/ldapadd"
	echo "Importar todo os dados de um dominio"
	echo -n "Digite dominio completo...: "
	read DOMAIN
	echo
	cd /opt/zimbra/backup/
	NULL=`1&> /dev/null 2&> /dev/null`
	HOST=`hostname -d`
	DEST="/opt/zimbra/backup/"$DOMAIN""
	chown zimbra:zimbra $DEST -R
		
#######################################################

	echo "Limpando arquivos vazios..."
	echo
	cd $DEST
	find $DEST -type f -empty -exec rm -rf {} \;
	echo "+-------------------------------------------------+OK"
	echo

	echo "Importar todas COS? - Sim/Nao"
	read CONFIRMA
	case $CONFIRMA in
	s|S|Sim|sim)
$zmprov dc Default 2>/dev/null
$zmprov dc defaultExternal 2>/dev/null
$ldapadd -c -x -H $ldap_master_url -D $zimbra_ldap_userdn -w $zimbra_ldap_password -f $DEST/cos/cos.ldiff | egrep -v "^adding|^$"
		;;
	n|N|Nao|nao)
	echo -n "Digite o nome da COS...: "
	read COS
	echo
$zmprov dc $COS
$ldapadd -c -x -H $ldap_master_url -D $zimbra_ldap_userdn -w $zimbra_ldap_password -f $DEST/cos/"$COS".ldiff | egrep -v "^adding|^$"
	sed -i '/cn='$COS'/,$!d' $DEST/cos/"$COS".ldiff
	sed -i '/^$/,$d' $DEST/cos/"$COS".ldiff
	printf 'OK --> '
	echo "$COS"
		;;
	*) echo  "Opcao Invalida" ;; esac
	echo "+-------------------------------------------------+OK"
	echo

	echo "Importando Dominios..."
	echo
for domain in `cat $DEST/dominio/dominio`; do $zmprov cd $domain zimbraAuthMech zimbra 2>/dev/null | egrep -v "^adding|^$"
	printf 'OK --> '
	echo "$domain" ; done
	echo "+-------------------------------------------------+OK"
	echo

	echo "Importando Contas..."
	echo
	SERVEROL="`cat $DEST/server_old`"
	SERVERNE="`zmhostname`"
	find $DEST -type f -name '*.ldiff' -exec sed -i "s/$SERVEROL/$SERVERNE/g" "{}" \;
for user in `cat $DEST/contas/usuarios`; do $ldapadd -x -H $ldap_master_url -D $zimbra_ldap_userdn -c -w $zimbra_ldap_password -f $DEST/contas/$user.ldiff 2>/dev/null | egrep -v "^adding|^$"
	printf 'OK --> '
	echo "$user" ; done
	echo "+-------------------------------------------------+OK"
	echo

	echo "Importar dados de caixa postal? - Sim/Nao"
	echo "Local da importação -> "$DEST/contas/...tgz""
	read CONFIRMA
	case $CONFIRMA in
	s|S|Sim|sim)
for user in `cat $DEST/contas/usuarios` ; do $zmmailbox -z -m $user pru "/?fmt=tgz&resolve=skip" $DEST/contas/$user.tgz ; echo "$user" ; done
		;;
n|N|Nao|nao)
		;;
*) echo  "Opcao Invalida" ;; esac
	echo "+-------------------------------------------------+OK"
	echo

	echo "Importando Briefcase..."
	echo
for user in $(ls $DEST/briefcase |awk -F "-briefcase.tgz" '{print $1}') ; do $zmmailbox -z -m $user pru "/?fmt=tgz&resolve=skip" $DEST/briefcase/$user-briefcase.tgz 2>/dev/null
	printf 'OK --> '
	echo "$user" ; done 
	echo "+-------------------------------------------------+OK"
	echo

	echo "Importando Agendas..."
	echo
for user in $(ls $DEST/agendas |awk -F "-agendas.tgz" '{print $1}') ; do $zmmailbox -z -m $user pru "/?fmt=tgz&resolve=skip" $DEST/agendas/$user-agendas.tgz 2>/dev/null
	printf 'OK --> '
	echo "$user" ; done 
	echo "+-------------------------------------------------+OK"
	echo

	echo "Importando Chats..."
	echo
for user in $(ls $DEST/chats |awk -F "-chats.tgz" '{print $1}') ; do $zmmailbox -z -m $user pru "/?fmt=tgz&resolve=skip" $DEST/chats/$user-chats.tgz 2>/dev/null
	printf 'OK --> '
	echo "$user" ; done 
	echo "+-------------------------------------------------+OK"
	echo

	echo "Importando Tags..."
	echo
for user in $(ls $DEST/tags |awk -F "-tags.tgz" '{print $1}') ; do $zmmailbox -z -m $user pru "/?fmt=tgz&resolve=skip" $DEST/tags/$user-tags.tgz 2>/dev/null
	printf 'OK --> '
	echo "$user" ; done 
	echo "+-------------------------------------------------+OK"
	echo

	echo "Importando Comments..."
	echo
for user in $(ls $DEST/comments |awk -F "-tags.tgz" '{print $1}') ; do $zmmailbox -z -m $user pru "/?fmt=tgz&resolve=skip" $DEST/comments/$user-comments.tgz 2>/dev/null
	printf 'OK --> '
	echo "$user" ; done 
	echo "+-------------------------------------------------+OK"
	echo
		
	echo "Importando Contatos..."
	echo
for user in $(ls $DEST/contatos |awk -F "-contatos.tgz|-emailed.tgz" '{print $1}') ; do $zmmailbox -z -m $user pru "/?fmt=tgz&resolve=skip" $DEST/contatos/$user-contatos.tgz 2>/dev/null
$zmmailbox -z -m $user pru "/?fmt=tgz&resolve=skip" $DEST/contatos/$user-emailed.tgz 2>/dev/null
	printf 'OK --> '
	echo "$user" ; done 
	echo "+-------------------------------------------------+OK"
	echo

	echo "Importando Documentos..."
	echo
for user in $(ls $DEST/documentos |awk -F "-documentos.tgz" '{print $1}') ; do $zmmailbox -z -m $user pru "/?fmt=tgz&resolve=skip" $DEST/documentos/$user-documentos.tgz 2>/dev/null
	printf 'OK --> '
	echo "$user" ; done 
	echo "+-------------------------------------------------+OK"
	echo

	echo "Importando Tarefas..."
	echo
for user in $(ls $DEST/tarefas |awk -F "-tarefas.tgz" '{print $1}') ; do $zmmailbox -z -m $user pru "/?fmt=tgz&resolve=skip" $DEST/tarefas/$user-tarefas.tgz 2>/dev/null
	printf 'OK --> '
	echo "$user" ; done 
	echo "+-------------------------------------------------+OK"
	echo

	echo "Importando Listas de Distribuição..."
	echo
for user in `cat $DEST/listas/listas` ; do $zmprov cdl $user 2>/dev/null ; done
	echo
	echo "Povoando Listas..."
	echo
for list in `cat $DEST/listas/listas` ; do
for user in `grep -v '#' $DEST/listas/$list | grep '@'` ; do  $zmprov adlm $list $user 2>/dev/null
	printf 'OK --> '
	echo "$user" ; done ; done
	echo "+-------------------------------------------------+OK"
	echo

	echo "Importando Alias..."
	echo
for user in `cat $DEST/contas/usuarios`
do
    if [ -f "$DEST/alias/$user" ]; then
        for alias in `grep '@' $DEST/alias/$user`
        do
            $zmprov aaa $user $alias 2>/dev/null
            printf 'OK --> '
			echo "$alias"
        done
     fi
done
	echo "+-------------------------------------------------+OK"
	echo

	echo "Importando Assinaturas..."
	echo
for user in $(ls $DEST/assinaturas) ; do
$zmprov csig $user "`cat $DEST/assinaturas/$user |grep zimbraSignatureName | sed -e 's/zimbraSignatureName: //'`" zimbraPrefMailSignatureHTML "`cat $DEST/assinaturas/$user |grep zimbraPrefMailSignatureHTML | sed -e 's/zimbraPrefMailSignatureHTML: //'`"  2>/dev/null | egrep -v "^ERROR"
	printf 'OK --> '
	echo "$user";
done
	echo "+-------------------------------------------------+OK"
	echo

	echo "Importando Filtros..."
	echo
for user in $(ls $DEST/filtros |awk -F ".filtros" '{print $1}') ; do
$zmprov ma $user zimbraMailSieveScript "`cat $DEST/filtros/$user.filtros`" 2>/dev/null
	printf 'OK --> '
	echo "$user";
done
	echo "+-------------------------------------------------+OK"
	echo

	echo
	echo "Dados Importados"
    echo "Pressione qualquer tecla para continuar..."
    read msg
	Principal
} 
Principal

echo "[`date`] ==== Fim da rotina..."

#https://syslint.com/blog/tutorial/zimbra-server-migration-and-zimbra-account-transfer-the-perfect-method/
#https://blog.johannfenech.com/migrating-opensource-zimbra-8-6-0-on-centos-6-8-to-zimbra-8-7-1-on-centos-7-safely-and-with-no-downtime/