#!/bin/sh

mySqlPassword="password"
mySqlUser="root"

#Start service mySQL if it is not running
mySQLStatus=`su - zimbra -c "mysql.server status" |gawk '{print $3}'`
if [ "$mySQLStatus" != "running" ]; then
su - zimbra -c 'mysql.server start --socket=/opt/zimbra/db/mysql.sock'
fi

#Backup zimbra mail's database
su - zimbra -c '/opt/zimbra/mysql/bin/mysqldump --user=$mySqlUser --password=$mySqlPassword --socket=/opt/zimbra/db/mysql.sock --all-databases > /opt/backup/zimbraBackup$(date +"%d%m%Y_%H%M%S").sql'

su - zimbra -c '/opt/zimbra/mysql/bin/mysqldump --user=root --password=password --socket=/opt/zimbra/db/mysql.sock --all-databases > /opt/backup/zimbraBackup$(date +"%d%m%Y_%H%M%S").sql'

#Backup zimbra mail's database
 su - zimbra -c '/opt/zimbra/mysql/bin/mysqldump --user=$mySqlUser --password=$mySqlPassword --socket=/opt/zimbra/db/mysql.sock --all-databases > /opt/backup/zimbraBackup$(date +"%d%m%Y_%H%M%S").sql'

su - zimbra -c '/opt/zimbra/mysql/bin/mysqldump --user=root --password=$mySqlPassword --socket=/opt/zimbra/db/mysql.sock --all-databases > /opt/backup/zimbraBackup$(date +"%d%m%Y_%H%M%S").sql'

su - zimbra -c '/opt/zimbra/mysql/bin/mysqldump --user=root --password=password --socket=/opt/zimbra/db/mysql.sock --all-databases > /opt/backup/zimbraBackup$(date +"%d%m%Y_%H%M%S").sql'

[root@mail backup]# sh -x ./exportDB.sh
+ mySqlPassword=password
+ mySqlUser=root
++ su - zimbra -c 'mysql.server status'
++ gawk '{print $3}'
+ mySQLStatus=running
+ '[' running '!=' running ']'
+ echo 'mySQL password: ' password
mySQL password:  password
+ su - zimbra -c '/opt/zimbra/mysql/bin/mysqldump --user=$mySqlUser --password=$mySqlPassword --socket=/opt/zimbra/db/mysql.sock --all-databases > /opt/backup/zimbraBackup$(date +"%d%m%Y_%H%M%S").sql'
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect

[root@mail backup]# su - zimbra -c '/opt/zimbra/mysql/bin/mysqldump --user=root --password=aaa --socket=/opt/zimbra/db/mysql.sock --all-databases > /opt/backup/zimbraBackup$(date +"%d%m%Y_%H%M%S").sql'
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

[root@mail backup]# sh -x ./exportDB.sh
+ mySqlPassword=password
+ mySqlUser=root
++ su - zimbra -c 'mysql.server status'
++ gawk '{print $3}'
+ mySQLStatus=running
+ '[' running '!=' running ']'
+ echo 'mySQL password: ' password
mySQL password:  password
+ su - zimbra -c '/opt/zimbra/mysql/bin/mysqldump -v --user=$mySqlUser --password=$mySqlPassword --socket=/opt/zimbra/db/mysql.sock --all-databases > /opt/backup/zimbraBackup$(date +"%d%m%Y_%H%M%S").sql'
-- Connecting to localhost...
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect

[root@mail backup]# sh -x ./exportDB.sh
+ mySqlPassword=password
+ mySqlUser=root
++ su - zimbra -c 'mysql.server status'
++ gawk '{print $3}'
+ mySQLStatus=running
+ '[' running '!=' running ']'
+ echo 'mySQL password: ' password
mySQL password:  password
+ su - zimbra -c '/opt/zimbra/mysql/bin/mysqldump -v --user=root --password=password --socket=/opt/zimbra/db/mysql.sock --all-databases > /opt/backup/zimbraBackup$(date +"%d%m%Y_%H%M%S").sql'

-- Retrieving table structure for table jiveExtComponentConf...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table jiveGroupProp...
-- Sending SELECT query...
-- Retrieving rows...

#!/bin/sh
mySQLUser="root"
mySQLPassword="password"

/opt/zimbra/mysql/bin/mysqldump --user=$mySQLUser --password=$mySQLPassword --socket=/opt/zimbra/db/mysql.sock --all-databases > /opt/backup/zimbraBackup.sql

#!/bin/sh
mySQLUser="root"
mySQLPassword="password"

su - zimbra -c '/opt/zimbra/mysql/bin/mysqldump --user=$mySQLUser --password=$mySQLPassword --socket=/opt/zimbra/db/mysql.sock --all-databases > /opt/backup/zimbraBackup.sql'

#!/bin/sh
#Stop zimbra service before backup (if it is running)
STATUS=`su - zimbra -c 'zmcontrol status |grep -i "mailbox"' | gawk '{print $2}'`
if [ "$STATUS" == "Running" ]; then
echo "Stopping Zimbra service...."
su - zimbra -c 'zmcontrol stop'
fi
echo ".... Service Zimbra has been stopped"

SCRIPT_FOLDER="/opt/backup"
BACKUP_FOLDER="/opt/backup"

mySqlPassword=`su - zimbra -c 'zmlocalconfig -s | grep "mysql_root_password"' | gawk '{print $3}'`
mySqlUser="root"

#Start service LDAP if it is not running
ldapStatus=`su - zimbra -c "ldap status | grep slapd" |gawk '{print $2}'`
if [ "$ldapStatus" != "running" ]; then
echo "Starting LDAP service..........."
su - zimbra -c 'ldap start'
fi
echo "..... Service LDAP has been started"

#Export LDAP users
$SCRIPT_FOLDER/export-acc-zcs.sh

#Stop service LDAP
su - zimbra -c 'ldap stop'

#Start service mySQL if it is not running
mySQLStatus=`su - zimbra -c "mysql.server status" |gawk '{print $3}'`
if [ "$mySQLStatus" != "running" ]; then
echo "Starting mysql service......"
su - zimbra -c 'mysql.server start --socket=/opt/zimbra/db/mysql.sock'
fi
echo "Service mysql has been started"

#Backup zimbra mail's database
echo "Starting backup database of Zimbra mail...."
/opt/zimbra/mysql/bin/mysqldump --user=$mySqlUser --password=$mySqlPassword --socket=/opt/zimbra/db/mysql.sock --all-databases > $BACKUP_FOLDER/zimbraBackup$(date +"%d%m%Y_%H%M%S").sql
echo "backup completed"

#Stop mysql service
su - zimbra -c 'mysql.server stop --socket=/opt/zimbra/db/mysql.sock'

#Backup index and store
echo "Starting backup index and store...."
tar -cvf $BACKUP_FOLDER/backupZimbraStore$(date +"%d%m%Y_%H%M%S").tar /opt/zimbra/store /opt/zimbra/index
echo "... Backup completed"

#Start zimbra service
START=`su - zimbra -c 'zmcontrol status |grep -i "mailbox"' |  gawk '{print $2}'`
if [ "$START" != "Running" ]; then
su - zimbra -c 'zmcontrol start'
fi
echo "Completed tasks"

#!/bin/sh

#Hapus Layar
clear

echo -e "###################################################################################"
echo -e "# Zimbra export-acc-zcs.sh ver 0.0.2                                              #"
echo -e "# Skrip untuk export account Zimbra berikut profile dan password                  #"
echo -e "# Masim 'Vavai' Sugianto - <a href="mailto:vavai@vavai.com">vavai@vavai.com</a> - http://www.vavai.com                 #"
echo -e "# Untuk saran dan pertanyaan silakan menggunakan Milis Komunitas Zimbra Indonesia #"
echo -e "# Link Komunitas : http://www.zimbra.web.id - http://www.opensuse.or.id           #"
echo -e "###################################################################################"

# /* Variable untuk bold */
ibold="\033[1m""\n===> "
ebold="\033[0m"

FOLDER="/opt/backup"

# /* Parameter */
#echo ""
#echo -n "Enter Domain Name (ex : vavai.com) : "
#read NAME_DOMAIN
#echo -n "Enter path folder for exported account (ex : /home/vavai/) : "
#read FOLDER

# /*export ldap user */
NAME_FILE="$FOLDER/zcs-acc-add$(date +"%d%m%Y_%H%M%S").zmp"
LDIF_FILE="$FOLDER/zcs-acc-mod$(date +"%d%m%Y_%H%M%S").ldif"

rm -f $NAME_FILE
rm -f $LDIF_FILE

touch $NAME_FILE
touch $LDIF_FILE

#echo "createDomain $NAME_DOMAIN" >> $NAME_FILE

# /* Check Zimbra version */
VERSION=`su - zimbra -c 'zmcontrol -v'`;
ZCS_VER="/tmp/zcsver.txt"
# get Zimbra LDAP password
ZIMBRA_LDAP_PASSWORD=`su - zimbra -c "zmlocalconfig -s zimbra_ldap_password | cut -d ' ' -f3"`

touch $ZCS_VER
echo $VERSION > $ZCS_VER

echo -e $ibold"Retrieve Zimbra User.............................."$ebold

grep "Release 5." $ZCS_VER
if [ $? = 0 ]; then
USERS=`su - zimbra -c 'zmprov gaa'`;
LDAP_MASTER_URL=`su - zimbra -c "zmlocalconfig -s ldap_master_url | cut -d ' ' -f3"`
fi

grep "Release 6." $ZCS_VER
if [ $? = 0 ]; then
USERS=`su - zimbra -c 'zmprov -l gaa'`;
LDAP_MASTER_URL="ldapi:///"
fi

echo -e $ibold"Processing account, please wait.............................."$ebold
# /* Proses insert account kedalam file hasil export */
for ACCOUNT in $USERS; do
NAME=`echo $ACCOUNT`;
DOMAIN=`echo $ACCOUNT | awk -F@ '{print $2}'`;
ACCOUNT=`echo $ACCOUNT | awk -F@ '{print $1}'`;
ACC=`echo $ACCOUNT | cut -d '.' -f1`

#if [ $NAME_DOMAIN == $DOMAIN ] ;
#Export all LDAP's users
if [ $DOMAIN == $DOMAIN ] ;
then
OBJECT="(&(objectClass=zimbraAccount)(mail=$NAME))"
dn=`/opt/zimbra/bin/ldapsearch -H $LDAP_MASTER_URL -w $ZIMBRA_LDAP_PASSWORD -D uid=zimbra,cn=admins,cn=zimbra -x $OBJECT | grep dn:`


displayName=`/opt/zimbra/bin/ldapsearch -H $LDAP_MASTER_URL -w $ZIMBRA_LDAP_PASSWORD -D uid=zimbra,cn=admins,cn=zimbra -x $OBJECT | grep displayName: | cut -d ':' -f2 | sed 's/^ *//g' | sed 's/ *$//g'`


givenName=`/opt/zimbra/bin/ldapsearch -H $LDAP_MASTER_URL -w $ZIMBRA_LDAP_PASSWORD -D uid=zimbra,cn=admins,cn=zimbra -x $OBJECT | grep givenName: | cut -d ':' -f2 | sed 's/^ *//g' | sed 's/ *$//g'`

userPassword=`/opt/zimbra/bin/ldapsearch -H $LDAP_MASTER_URL -w $ZIMBRA_LDAP_PASSWORD -D uid=zimbra,cn=admins,cn=zimbra -x $OBJECT | grep userPassword: | cut -d ':' -f3 | sed 's/^ *//g' | sed 's/ *$//g'`

cn=`/opt/zimbra/bin/ldapsearch -H $LDAP_MASTER_URL -w $ZIMBRA_LDAP_PASSWORD -D uid=zimbra,cn=admins,cn=zimbra -x $OBJECT | grep cn: | cut -d ':' -f2 | sed 's/^ *//g' | sed 's/ *$//g'`

initials=`/opt/zimbra/bin/ldapsearch -H $LDAP_MASTER_URL -w $ZIMBRA_LDAP_PASSWORD -D uid=zimbra,cn=admins,cn=zimbra -x $OBJECT | grep initials: | cut -d ':' -f2 | sed 's/^ *//g' | sed 's/ *$//g'`

sn=`/opt/zimbra/bin/ldapsearch -H $LDAP_MASTER_URL -w $ZIMBRA_LDAP_PASSWORD -D uid=zimbra,cn=admins,cn=zimbra -x $OBJECT | grep sn: | cut -d ':' -f2 | sed 's/^ *//g' | sed 's/ *$//g'`

	if [ $ACC == "admin" ] || [ $ACC == "wiki" ] || [ $ACC == "galsync" ] || [ $ACC == "ham" ] || [ $ACC == "spam" ]; then
    		echo "Skipping system account, $NAME..."
	else
		echo "createAccount $NAME passwordtemp displayName '$displayName' givenName '$givenName' sn '$sn' initials '$initials' zimbraPasswordMustChange FALSE" >> $NAME_FILE

    		echo "$dn
changetype: modify
replace: userPassword
userPassword:: $userPassword
" >> $LDIF_FILE
    		echo "Adding account $NAME"
	fi
else
	echo "Skipping account $NAME"
fi

done
echo -e $ibold"All account has been exported sucessfully into $NAME_FILE and $LDIF_FILE..."$ebold