5 # Copyright (C) 2005 Serg Oskin
12 if [ -f $ZM_CONFIG ]; then
15 echo "ERROR: $ZM_CONFIG not found."
18 for n in ZM_DB_SERVER ZM_DB_NAME ZM_DB_USER ZM_DB_PASS; do
20 if [ "$val" = "" ]; then
21 echo "ERROR($ZM_CONFIG): $n should exist and be not empty."
26 if [ "$ZM_DB_SERVER" = "localhost" ]; then
37 echo "CREATE DATABASE /*!32312 IF NOT EXISTS*/ $ZM_DB_NAME;" >>$sql
38 echo "USE $ZM_DB_NAME;" >>$sql
40 echo "GRANT all on $ZM_DB_NAME.* TO '$ZM_DB_USER'@'$ClientHost' IDENTIFIED BY '$ZM_DB_PASS';" >>$sql
42 echo -n "Enter MySQL Administrator username: "
44 cat $sql | mysql -B -h $ZM_DB_SERVER -u $admin -p
47 cat /usr/lib/zm/init/zmschema.sql | mysql -h $ZM_DB_SERVER -u $ZM_DB_USER -p$ZM_DB_PASS $ZM_DB_NAME
48 ( cd $ZM_PATH/init; perl $ZM_PATH/init/zmoptions -f $ZM_PATH/init/zmconfig.txt )