mysqld_safe start error

[bsdnewbie999]

When i run "#/usr/local/bin/mysqld_safe &" i got these error message.

# /usr/local/bin/mysqld_safe &                                                 
[1] 8190
# touch: /var/mysql/fiddler.fiddler.com.err: No such file or directory
chown: /var/mysql/fiddler.fiddler.com.err: No such file or directory
Starting mysqld daemon with databases from /var/mysql
/usr/local/bin/mysqld_safe[314]: cannot create /var/mysql/fiddler.fiddler.com.err: No such file or directory
/usr/local/bin/mysqld_safe: cannot create /var/mysql/fiddler.fiddler.com.err: No such file or directory
STOPPING server from pid file /var/mysql/fiddler.fiddler.com.pid
tee: /var/mysql/fiddler.fiddler.com.err: No such file or directory
090403 15:43:31  mysqld ended
tee: /var/mysql/fiddler.fiddler.com.err: No such file or directory

[Carpetsmoker]

You should run MySQL as the mysql user, not as the super user, i.e.:
# mysqld_safe --user=mysql

The FreeBSD port adds the mysql user&group when the package is installed for you, I don't know if OpenBSD also does this; Create the user&group if they don't exist yet.

Does the /var/mysql directory exist? Also make sure it is chown(8)-ed to mysql:mysql

Additionally, you must run mysql_install_db to create the default MySQL administration database after you have first installed MySQL, remember to run it with the --user=mysql argument.
Please do read the mysql_install_db manual linked above, there are additional arguments that may be needed (i.e. --basedir).

[jggimi]

When you did your pgk_add, bsdnewbie, you got a message that said:

You can find detailed instructions on how to install a database
in /usr/local/share/doc/mysql/README.OpenBSD.

You must not have seen the message, or, paid no attention to it.

[bsdnewbie999]

Where i add this lines to?

And start the server like this:

	if [ -x /usr/local/bin/mysqld_safe ] ; then
		su -c mysql root -c '/usr/local/bin/mysqld_safe >/dev/null 2>&1 &' 
		echo -n ' mysql'
	fi

[jggimi]

Quoting rc.local(5):

rc.local is executed towards the end of rc (it is not the very last as
there are a few services that must be started at the very end). Normal-
ly, rc.local contains commands and daemons that are not part of the stock
installation.

[ocicat]

Originally Posted by bsdnewbie999

Where i add this lines to?

Once again, you are showing that you have no familarity with information found in the FAQ. This subject is covered in Section 10.3:

http://openbsd.org/faq/faq10.html#rc

[TerryP]

How I start MySQL, in 3 easy listings. (note the user/group used is named _mysql)

in /etc/rc.local:

# launch the MySQL database server
if [ -x /usr/local/bin/mysqld_safe -a -x /etc/rc.mysql ]; then
        /etc/rc.mysql
fi

echo '.'

in /etc/rc.mysql:

#!/bin/sh
#
# A simple script to launch mysqld with the proper login privileges
#

su -c _mysql root -c '/usr/local/bin/mysqld_safe >/dev/null 2>&1 &'
echo -n ' mysql'

in /etc/login.conf:

 #
 # This class is used when running MySQL from /etc/rc.local
 # XXX: It will *N_O_T* be used when starting/stopping mysqld manually!!
 #
 _mysql:\
         :ignorenologin:\
         :datasize=infinity:\
         :maxproc=infinity:\
         :openfiles=3580:\       # I've set this to sysctl::kern.maxfiles
         :stacksize-cur=8M:\
         :localcipher=blowfish,8:\
         :tc=daemon:

note: set it to need, see login.conf in OpenBSD manual for details.


The rc.mysql script is used so that if I have to stop my database for some reason, I can restart it with the correct credentials without having to check rc.local for the commands.



As Carpetsmoker, jggimi, and ocicat have pointed out - do be sure to read the documentation while you're at it, it helps.

[bsdnewbie999]

It works now.