#!/bin/sh

database=$(/sbin/e-smith/config getprop zarafa-server DbName);
if [ "$database" = "" ];
then
db="zarafa"
else
db="$database"
fi

dbuser=$(/sbin/e-smith/config getprop zarafa-server DbUser);
if [ "$dbuser" = "" ];
then
user="zarafa"
else
user="$dbuser"
fi

pass=`dd if=/dev/urandom count=2000 bs=1 2>/dev/null| tr -dc "a-zA-Z0-9-_!@#$&*" | cut -c-64`

/sbin/e-smith/config setprop zarafa-server DbPassword "$pass";

/usr/bin/mysql << EOF
use $db;
use mysql;
GRANT ALL PRIVILEGES ON $db.* TO $user@localhost IDENTIFIED BY '$pass';
flush privileges;
\q;
EOF

/bin/echo -e "\n** The pass word has been changed to: $pass **"
/bin/echo -e "** please wait while the Zarafa services restart **\n"

/sbin/e-smith/signal-event zarafa-services update

exit
