#! /bin/sh



if [[ ! -f /var/lib/mysql/sogo/sogo_folder_info.frm ]]; then
    # Create DB and populate
    exec mysql < /var/lib/sogo/smeserver/sogo_mysql_create_database.sql
fi

# set privileges
{
    my $db = 'sogo';
    my $user = 'sogo';
    my $pass = $sogod{'DbPassword'} || 'changeme';
    $OUT .= <<END
    /usr/bin/mariadb <<EOF
    CREATE DATABASE IF NOT EXISTS $db DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    use mysql;
    GRANT ALL PRIVILEGES ON $db.* TO $user\@localhost
            IDENTIFIED BY '$pass';
    flush privileges;
EOF
END


}
