[EMAIL PROTECTED] wrote:
Running OpenBSD 3.9-stable
# start mysql server.
/usr/local/bin/mysqld_safe &


I am using this:
# Start MySQL server
if [ -x /usr/local/bin/mysqld_safe ] ; then
su -c _mysql root -c '/usr/local/bin/mysqld_safe &' > /dev/null & echo -n ' mysql'
fi

But in rc.local no problem.

If I put the same into the rc.conf.local, then I get the same error as you do. I saw that a long time ago, but never reported it really. I didn't think it was a big deal then. May be I should have. In all fairness, I didn't try to dig up why that was as I assume it was the order of the boot and that as I read and understood it from the FAQ that rc.conf.local was doing what rc.conf does and was the best place to do that to keep rc.conf clean and that rc.local should be the place to add what's not available by default in the system.

Obviously, that's just what I thought and shouldn't be taken as the facts either. I am sure someone else will correct that if I make gross assumptions here. But I took it to be, you leave the rc.conf alone. You change what you would change before in the rc.conf in the new rc.conf.local and as far as any new process not listed in the rc.conf, you put them into the rc.local. May be I am wrong thinking that way, but it sure works very well.

Also, I like to enforce the use of the login.class as well to increase my limits and keep the default the same. That's why you see the su stuff there.

Works for me for sure.

I just tested it again by rebooting a spare server with it.

Error in rc.conf.local, but no error when place in the rc.local one.

Hope this help some.

Daniel

PS: I had the same issue with QMail as well, if not in the right config file as well.

=====================
Error with configuration in rc.conf.local

060819 01:20:58  mysqld started
060819 01:20:58  mysqld started
060819 1:20:59 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 060819 1:20:59 [ERROR] Do you already have another mysqld server running on port: 3306 ?
060819  1:20:59 [ERROR] Aborting

060819  1:21:00 [Note] /usr/local/libexec/mysqld: Shutdown complete

060819 01:21:00  mysqld ended

060819  1:21:00 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.22' socket: '/var/run/mysql/mysql.sock' port: 3306 OpenBSD port: mysql-server-5.0.22

==========================
Message with same startup place in rc.local instead produce no error message and is very clean as well.

060819 01:30:20  mysqld started
060819  1:30:21 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.22' socket: '/var/run/mysql/mysql.sock' port: 3306 OpenBSD port: mysql-server-5.0.22

Reply via email to