Running OpenBSD 3.9-stable
Installed mysql-server-5.0.18 via pkg_add
I'm now trying to get mysql to start automatically at boot.
Here is my rc.conf.local file contents:
ntpd_flags="" # enabled during install
# use -u to disable chroot, see httpd(8)
httpd_flags="" # for normal use: "" (or "-DSSL" after
reading ssl(8))
# start mysql server.
/usr/local/bin/mysqld_safe &
Now when the server boots, it appears to try and start
mysql twice in a row. Here is my error log:
060818 23:51:02 mysqld started
060818 23:51:02 mysqld started
/usr/local/libexec/mysqld: Error on delete of '/var/mysql/
pollux.lower-test' (Errcode: 2)
InnoDB: Unable to lock ./ibdata1, error: 35
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
060818 23:51:08 InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock ./ibdata1, error: 35
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
060818 23:51:09 InnoDB: Started; log sequence number 0 43655
060818 23:51:09 [ERROR] Can't start server : Bind on unix socket: No
such file or directory
060818 23:51:09 [ERROR] Do you already have another mysqld server
running on socket: /var/run/mysql/mysql.sock ?
060818 23:51:09 [ERROR] Aborting
060818 23:51:09 InnoDB: Starting shutdown...
InnoDB: Unable to lock ./ibdata1, error: 35
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 35
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
060818 23:51:12 InnoDB: Started; log sequence number 0 43655
060818 23:51:12 [ERROR] Can't start server: Bind on TCP/IP port:
Address already in use
060818 23:51:12 [ERROR] Do you already have another mysqld server
running on port: 3306 ?
060818 23:51:12 [ERROR] Aborting
060818 23:51:12 InnoDB: Starting shutdown...
060818 23:51:12 InnoDB: Shutdown completed; log sequence number 0 43655
060818 23:51:12 [Note] /usr/local/libexec/mysqld: Shutdown complete
060818 23:51:12 mysqld ended
060818 23:51:15 InnoDB: Shutdown completed; log sequence number 0 43655
060818 23:51:15 [Note] /usr/local/libexec/mysqld: Shutdown complete
060818 23:51:15 mysqld ended
I've checked to make sure that none of the following have any reference
to mysql at all: rc, rc.local, rc.conf
I do know that mysql runs fine if I don't try to start it automatically.
Any idea on where I can the find best procedure for starting MySQL
safely
and securely on boot. I have to assume a ton of people running OpenBSD
also run MySQL. So I find it strange that I can't find much
information on it.
Thanks for everyone's help,
Eric Stewart
e.stewart [at] mac [dot] com
