_Export_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

	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 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
     sleep 5
	 echo
	 echo "==================EXECUTANDO======================="
	 echo


# EXPORTAÇÃO TOTAL
	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"
	cd /opt/zimbra/backup/
	NULL="2>/dev/null"
	HOST=`hostname -d`
	DEST="/opt/zimbra/backup/"
	mkdir /tmp/$HOST-BKP-$(date "+%Y%m%d") >/dev/null 2>/dev/null
	\mv -f $DEST /tmp/$HOST-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 "Exportando COS..."
	echo
$ldapsearch -x -H $ldap_master_url -D $zimbra_ldap_userdn -w $zimbra_ldap_password -b '' -LLL "(objectclass=zimbraCOS)" > $DEST/cos/cos.ldiff
	echo "+-------------------------------------------------+OK"
	echo

	echo "Exportando Dominios..."
	echo
$zmprov gad printf 'OK --> ' | tee -a $DEST/dominio/dominio
	echo "+-------------------------------------------------+OK"
	echo
	
	echo "Exportando Contas..."
	echo
	zmhostname > $DEST/server_old
$zmprov -l gaaa | egrep -v "^virus|^ham|^spam|^galsync" > $DEST/contas/admins
$zmprov -l gaa | 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 "Exportando Briefcase..."
	echo
$zmprov -l gaa | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 > $DEST/listas/listas
$zmprov gadl | while read user_listas; do $zmprov gdlm $user_listas > $DEST/listas/$user_listas  2>/dev/null
	printf 'OK --> '
	echo "$user" ; done 
	echo "+-------------------------------------------------+OK"
	echo

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

	echo "Exportando Assinaturas..."
	echo
$zmprov -l gaa | egrep -v "^virus|^ham|^spam|^galsync" | while read user; do $zmprov gsig $user > $DEST/assinaturas/"$user" 2>/dev/null
	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 2>/dev/null
    sed -i -e "1d" /tmp/filtros
    sed 's/zimbraMailSieveScript: //g' /tmp/filtros  > $DEST/filtros/$user.filtros
    printf 'OK --> '
	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 "[`date`] ==== Fim da rotina..."