#!@l_prefix@/lib/openpkg/bash @l_prefix@/etc/rc
##
##  rc.mysql4 -- Run-Command for MySQL Database
##

%config
    mysql4_enable="yes"
    mysql4_pwd_file=@l_prefix@/etc/mysql4/my.pwd
    mysql4_cnf_file=@l_prefix@/etc/mysql4/my.cnf
    mysql4_log_prolog="true"
    mysql4_log_epilog="true"
    mysql4_log_numfiles="10"
    mysql4_log_minsize="1M"
    mysql4_log_complevel="9"

%common
    #   same paths as in my.cnf
    mysql4_pid_file=@l_prefix@/var/mysql4/mysqld.pid
    mysql4_log_err=@l_prefix@/var/mysql4/mysqld.err
    mysql4_log_common=@l_prefix@/var/mysql4/common.log
    mysql4_log_update=@l_prefix@/var/mysql4/update.log

%start -p 200 -u @l_rusr@
    opServiceEnabled mysql4 || exit 0
    cd @l_prefix@
    @l_prefix@/bin/mysqld_safe >/dev/null 2>&1 \
        --mysqld=@mysqld@ \
        --pid-file="$mysql4_pid_file" \
        --err-log="$mysql4_log_err" &

%stop -p 200 -u @l_rusr@
    opServiceEnabled mysql4 || exit 0
    @l_prefix@/bin/mysqladmin \
        --defaults-extra-file=${mysql4_pwd_file} \
        shutdown

%restart -u @l_rusr@
    opServiceEnabled mysql4 || exit 0
    cd @l_prefix@
    @l_prefix@/bin/mysqladmin \
        --defaults-extra-file=${mysql4_pwd_file} \
        shutdown
    @l_prefix@/bin/mysqld_safe >/dev/null 2>&1 \
        --mysqld=@mysqld@ \
        --pid-file="$mysql4_pid_file" \
        --err-log="$mysql4_log_err" &

%daily -u @l_rusr@
    opServiceEnabled mysql4 || exit 0
    shtool rotate -f \
        -n${mysql4_log_numfiles} -s${mysql4_log_minsize} -d \
        -z${mysql4_log_complevel} -o@l_rusr@ -g@l_rgrp@ -m644 \
        -P "${mysql4_log_prolog}" \
        -E "@l_prefix@/bin/mysqladmin \
            --defaults-extra-file=${mysql4_pwd_file} \
            flush-logs; ${mysql4_log_epilog}" \
        ${mysql4_log_common} \
        ${mysql4_log_update} \
        ${mysql4_log_err}