mysqld: Command not found

bshearer · 04-15-2005, 10:03 AM

greetings!

here is my setup

openbsd 3.5

installed mysql-server-4.0.18

all appears ok except it created _mysql user and group and I already had mysql set as the userid and group. no biggie...

however, after a reboot it appears that mysqld did not start

when i enter mysqld the message Command not found appears.

any ideas?

thanks

buddy

sigsegv · 04-15-2005, 01:14 PM

Taken from the first hit on this google search...

Quote:

To configure OpenBSD to automatically start mysql with every system start-up then you can edit the rc.conf.local file to modfiy the configuration and rc.local to take action when the configurations are set.

Edit: /etc/rc.conf.local file to include in Section 2 the following lines:

mysql=YES

Edit: /etc/rc.local

After the 'starting local daemons' and before the following echo '.', Insert the following instructions to the /etc/rc.local file:
echo -n 'starting local daemons:'
# [ ... stuff left out ... ]

if [ X"${mysql}" == X"YES" -a -x /usr/local/bin/mysqld_safe ]; then

echo -n " mysqld"; /usr/local/bin/mysqld_safe --user=_mysql --log &

for i in 1 2 3 4 5 6; do
if [ -S /var/run/mysql/mysql.sock ]; then
break
else
sleep 1
echo -n "."
fi
done

fi
# [ ... stuff left out ... ]
echo '.'

Now each restart of the machine will automatically check to see whether we have enabled mysql in the configuration file (rc.conf) and then start the mysql daemon. If we wish to disable mysql we can simply change mysql=YES to mysql=NO

Note: /usr/local/share/mysql/mysql.server is a script for starting/stopping mysql daemon. The files are there with mysql-server-4.0.18 on OpenBSD 3.5 so your mileage may vary.

HTH

bshearer · 04-15-2005, 01:20 PM

yea, i saw that too but the line

Edit: /etc/rc.conf.local file to include in Section 2 the following lines:

stops me because I have no /etc/rc.conf.local file to edit

how do i get past this?

Thanks for your help!!!

frob23 · 04-15-2005, 02:10 PM

You create the file (it is not there in the base install).

Most .local files are not created for you because, by definition, they are for very specific local settings and changes.

bshearer · 04-15-2005, 03:50 PM

That did it.

Thanks to all

Buddy