{
my $db = ${'zabbix-proxy'}{'DbName'} || 'zabbix';
my $user = ${'zabbix-proxy'}{'DbUser'} || 'zabbix';
my $pass = ${'zabbix-proxy'}{'DbPassword'} || 'secret';

#my $schema = `rpm -qd zabbix-proxy-mysql | grep schema | grep mysql`;
my $schema = "/usr/share/zabbix-sql-scripts/mysql/proxy.sql";

$OUT .= <<"END";
#! /bin/sh
if [ \! -d /var/lib/mysql/$db ]; then
	/usr/bin/mariadb-admin create $db
fi
if [ \! -d /var/lib/mysql/$db/users.ibd ]; then
	cat $schema | /usr/bin/mariadb $db
fi

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

GRANT ALL PRIVILEGES ON $db.* TO $user\@localhost
            IDENTIFIED BY '$pass';

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',
                   '${'zabbix-proxy'}{DbName}',
                   '${'zabbix-proxy'}{DbUser}',
                   'Y', 'Y', 'Y', 'Y',
                   'Y', 'Y', 'Y', 'Y', 'Y',
                   'N', 'Y', 'Y');

FLUSH PRIVILEGES;

EOF
END
}
