{

my $dbname = $zoneminder{'DbName'} || 'zm';
my $dbuser = $zoneminder{'DbUser'} || 'zm';
my $dbpass = $zoneminder{'DbPassword'} || 'secret';
my $ManagerPassword = $zoneminder{'ManagerPassword'} || 'admin';

$OUT .= << "HERE";
#! /bin/sh

if [ ! -d /var/lib/mysql/$dbname ]; then
    mysqladmin create $dbname

    if [ -e /usr/share/zoneminder/db/zm_create.sql ]; then
        mysql $dbname < /usr/share/zoneminder/db/zm_create.sql
    else
        echo "Error: file /usr/share/zoneminder/db/zm_create.sql doesn't exists"
        exit 1
    fi
fi



/usr/bin/mysql $dbname -e 'insert into Users VALUES (NULL,"admin",password("$ManagerPassword"),"",1,"View","Edit","Edit","Edit","Edit","Edit","Edit","","") 
 ON DUPLICATE KEY UPDATE `Password` = password("$ManagerPassword");'

/usr/bin/mysql <<EOF
USE mysql;

REPLACE INTO user (  
                     host,
                     user,
                     password)
            VALUES ( 
                     'localhost',
                     '$dbuser',
                     PASSWORD ('$dbpass'));


REPLACE INTO db (  
                   host,
                   db,
                   user,
                   select_priv, insert_priv, update_priv, delete_priv,
                   create_priv, alter_priv, index_priv, drop_priv, create_tmp_table_priv,
                   grant_priv, lock_tables_priv, references_priv)
          VALUES ( 
                   'localhost',
                   '$dbname',
                   '$dbuser',
                   'Y', 'Y', 'Y', 'Y',
                   'Y', 'Y', 'Y', 'Y', 'Y',
                   'N', 'Y', 'Y');


FLUSH PRIVILEGES;

EOF


HERE
}

