using mysqld_multi - reboot only session 1 starts.

We are using mysqld_multi to start three instances, the command /usr/
bin/mysqld_multi --config-file=/etc/my.cnf start 1-3 works just fine.
But when I tried to put that in rc.local only 3306 would start. Ok
fine.

So I created 3 scripts that I put in /etc/init.d called mysqld1, 2,
and 3.

So now /sbin/service mysqld start | stop | status all work just fine.

I then added them to run level 3.

I can stop, start, and status any or all but when I reboot I have a
problem.

$ sudo /sbin/service mysqld status
Reporting MySQL servers
MySQL server from group: mysqld1 is running
MySQL server from group: mysqld2 is not running
MySQL server from group: mysqld3 is not running
$ sudo /sbin/service mysqld2 start
$ sudo /sbin/service mysqld status
Reporting MySQL servers
MySQL server from group: mysqld1 is running
MySQL server from group: mysqld2 is running
MySQL server from group: mysqld3 is not running
$ sudo /sbin/chkconfig --list | grep mysql
mysqld 0:off 1:off 2:off 3:off 4:off 5:off 6:off
mysqld1 0:off 1:off 2:off 3:on 4:off 5:off 6:off
mysqld2 0:off 1:off 2:off 3:on 4:off 5:off 6:off
mysqld3 0:off 1:off 2:off 3:on 4:off 5:off 6:off
$ sudo tail /var/log/mysql/mysqld3.log
090513 16:06:50 [ERROR] Can't start server: Bind on TCP/IP port:
Permission denied
090513 16:06:50 [ERROR] Do you already have another mysqld server
running on port: 3308 ?
090513 16:06:50 [ERROR] Aborting

090513 16:06:50 InnoDB: Starting shutdown...
090513 16:06:52 InnoDB: Shutdown completed; log sequence number 0
195828884
090513 16:06:52 [Note] /usr/libexec/mysqld: Shutdown complete

090513 16:06:52 mysqld ended

I have this same error but for port 3307 for mysqld2 but as you can
see it starts just fine when I run it after the server is up, why?

Any help greatly appreciated.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org