mysql won't run via rc.local

[benben159]

hi, i'm a newbie on this OpenBSD (version 4.7). i've built an ONMP (OpenBSD-Nginx-MySQL-PHP). i've installed MySQL (using `pkg_add mysql-server`), and i've put it on rc.local like this:

if [ X"${mysql}" == X"YES" -a -x /usr/local/bin/mysqld_safe ] ; then
su -c _mysql root -c `/usr/local/bin/mysqld_safe &` > /dev/null & echo -
n “ mysqld”
fi

it won't run (i've checked it on `ps aux` output). it'll run if i execute it manually from the console

$ sudo su -c _mysql root -c `/usr/local/bin/mysqld_safe &` > /dev/null

what should i do?

[phill]

I think the condition X"${mysql}" == X"YES" is only true if you also created a conf file containing mysql=YES. Just like rc works with rc.conf.

In my rc.local I only use the condition -x /usr/local/bin/mysqld_safe so:
if [ -x /usr/local/bin/mysqld_safe ] ; then
su -c _mysql root -c `/usr/local/bin/mysqld_safe &` > /dev/null & echo -
n “ mysqld”
fi

[benben159]

Originally Posted by phill

I think the condition X"${mysql}" == X"YES" is only true if you also created a conf file containing mysql=YES. Just like rc works with rc.conf.

In my rc.local I only use the condition -x /usr/local/bin/mysqld_safe so:
if [ -x /usr/local/bin/mysqld_safe ] ; then
su -c _mysql root -c `/usr/local/bin/mysqld_safe &` > /dev/null & echo -
n “ mysqld”
fi

i've done it before, by creating a file called rc.conf.local in /etc with

mysql=YES

in it. but it still won't run

[jggimi]

Only applications included with the OS use variables in the configuration files (rc.conf, rc.conf.local) with rc(8).

3rd party ports and packages do not use conf variables.

Standard practice is to use the script example provided in /usr/local/share/doc/mysql/README.OpenBSD.