mysql in a jail not starting
i have had many jails, and have never really had any problems with them until this one. for some reason, mysql wont start. nothing else is having any trouble starting, which is strange. is there a log file i can look in that might give me some clues as to whats going on? mysql_enable=YES is in my rc.conf, and when i start it i get: antares# /usr/local/etc/rc.d/mysql-server start Starting mysql. antares# /usr/local/etc/rc.d/mysql-server status mysql is not running. any tips for troubleshooting this would be apprciated. TIA, -- Jonathan Horne http://dfwlpiki.dfwlp.org [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql in a jail not starting
On Thursday 30 August 2007, Jonathan Horne said: i have had many jails, and have never really had any problems with them until this one. for some reason, mysql wont start. nothing else is having any trouble starting, which is strange. is there a log file i can look in that might give me some clues as to whats going on? mysql_enable=YES is in my rc.conf, and when i start it i get: antares# /usr/local/etc/rc.d/mysql-server start Starting mysql. antares# /usr/local/etc/rc.d/mysql-server status mysql is not running. any tips for troubleshooting this would be apprciated. TIA, Read the *.err files in /var/db/mysql. It should tell you why it's failing. Beech -- --- Beech Rintoul - FreeBSD Developer - [EMAIL PROTECTED] /\ ASCII Ribbon Campaign | FreeBSD Since 4.x \ / - NO HTML/RTF in e-mail | http://www.freebsd.org X - NO Word docs in e-mail | Latest Release: / \ - http://www.FreeBSD.org/releases/6.2R/announce.html --- ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql in a jail not starting
On Thursday 30 August 2007 14:34:34 Beech Rintoul wrote: Read the *.err files in /var/db/mysql. It should tell you why it's failing. Beech thanks, that led me right to it! antares# /usr/local/etc/rc.d/mysql-server status mysql is running as pid 1738. cheers, -- Jonathan Horne http://dfwlpiki.dfwlp.org [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql in a jail not starting
trouble starting, which is strange. is there a log file i can look in that might give me some clues as to whats going on? mysql_enable=YES is in my rc.conf, and when i start it i get: antares# /usr/local/etc/rc.d/mysql-server start Starting mysql. antares# /usr/local/etc/rc.d/mysql-server status mysql is not running. any tips for troubleshooting this would be apprciated. TIA, any logs already read? ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql in a jail
[EMAIL PROTECTED] wrote: I have a system running four jails. MySQL is running in two of the jails and I am trying to add it to a 3rd jail. Starting the server gets the message: 040302 19:34:15 mysql started 040302 19:34:15 Can't start server : Bind on unix socket: Permission denied 040302 19:34:15 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 040302 19:34:15 Aborting 040302 19:34:15 /usr/local/libexec/mysqld: Shutdown Complete 040302 19:34:15 mysqld ended The new jail was created by copying the file tree from a jail that had the desired configuration and then doing clean-up as required. In response to the error I tried configuring mysqld to use a different port and socket file. That did not fix the problem. I had forgotten the other two mysql's are using port 3306 and /tmp/mysql.sock. [...] Are you sure that each jail runs on its own, unique IP address? If not, port binding conflicts are to be expected. You cannot have multiple MySQL daemons on the same IP address/port combination, regardless of whether they run inside jails or not. Uwe -- Uwe Doering | EscapeBox - Managed On-Demand UNIX Servers [EMAIL PROTECTED] | http://www.escapebox.net ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
mysql in a jail
I have a system running four jails. MySQL is running in two of the jails and I am trying to add it to a 3rd jail. Starting the server gets the message: 040302 19:34:15 mysql started 040302 19:34:15 Can't start server : Bind on unix socket: Permission denied 040302 19:34:15 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 040302 19:34:15 Aborting 040302 19:34:15 /usr/local/libexec/mysqld: Shutdown Complete 040302 19:34:15 mysqld ended The new jail was created by copying the file tree from a jail that had the desired configuration and then doing clean-up as required. In response to the error I tried configuring mysqld to use a different port and socket file. That did not fix the problem. I had forgotten the other two mysql's are using port 3306 and /tmp/mysql.sock. I next removed mysql and its dependencies and reinstalled mysql-server-4.0.16 using pkg_add. I am still getting the same error. At this point I think it is a jail problem with something I missed in clean-up but I do not know where to look next. Having done all this, I recalled in installing the 2nd MySQL jail, it was necessary to remove and reinstall mysql. In that instance the re-installation solved the problem. Thanks for any ideas. _ Douglas Denault [EMAIL PROTECTED] Voice: 301-469-8766 Fax: 301-469-0601 ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]