mysql5: is it running and how can I tell?
My guess is that it isn't. And I don't know why. Using ps gives me this. root 47 0.0 0.1 27884 816 ?? Ss 10:46PM 0:00.04/opt/local/bin/daemondo --label=mysql5 --start-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper start ; --stop-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper stop ; --restart-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper restart ; --pid=/opt/local/var/mysql.pid running the script by hand gives me this. /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper start Starting MySQL/opt/local/share/mysql5/mysql/mysql.server: line 159: kill: (580) - No such process the offending line 159? 152 wait_for_pid () { 153 i=0 154 while test $i -ne $service_startup_timeout ; do 155 sleep 1 156 case "$1" in 157 'created') 158 test -s $pid_file && i='' && break 159 kill -0 $2 || break # if the program goes away, stop waiting 160 ;; 161 'removed') and I get these messages now: Workaround Bonjour: Unknown error: 0 I don't think they are anything to do with mysql, perhaps apache2 since it doesn't do zeroconf stuff like the vendor-supplied httpd. -- Paul Beard / www.paulbeard.org/ <paulbeard@gmail.com/paulbeard@mac.com>
"paul beard" <paulbeard@gmail.com> on Monday, July 9, 2007 at 11:03 PM -0800 wrote:
My guess is that it isn't. And I don't know why. Using ps gives me this.
root 47 0.0 0.1 27884 816 ?? Ss 10:46PM 0:00.04 /opt/local/bin/daemondo --label=mysql5 --start-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper start ; --stop-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper stop ; --restart-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper restart ; --pid=/opt/local/var/mysql.pid
running the script by hand gives me this.
/opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper start Starting MySQL/opt/local/share/mysql5/mysql/mysql.server: line 159: kill: (580) - No such process
the offending line 159?
152 wait_for_pid () { 153 i=0 154 while test $i -ne $service_startup_timeout ; do 155 sleep 1 156 case "$1" in 157 'created') 158 test -s $pid_file && i='' && break 159 kill -0 $2 || break # if the program goes away, stop waiting 160 ;; 161 'removed')
and I get these messages now: Workaround Bonjour: Unknown error: 0
I don't think they are anything to do with mysql, perhaps apache2 since it doesn't do zeroconf stuff like the vendor-supplied httpd.
Yeah, doesn't look like it is running because I don't see mysqld running in the ps output. The Bonjour message is unrelated, though I'm not sure why they occur. Is it a new install, and if so have you run mysql_install_db5? Here is how I setup mysql5. http://homepage.mac.com/duling/halfdozen/NeDi-Howto.html#d0e94 Mark
On Jul 10, 2007, at 11:29, markd@macports.org wrote:
On Monday, July 9, 2007 at 11:03 PM paul beard wrote:
My guess is that it isn't. And I don't know why. Using ps gives me this.
root 47 0.0 0.1 27884 816 ?? Ss 10:46PM 0:00.04 /opt/local/bin/daemondo --label=mysql5 --start-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper start ; --stop-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper stop ; --restart-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper restart ; --pid=/opt/local/var/mysql.pid
running the script by hand gives me this.
/opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper start Starting MySQL/opt/local/share/mysql5/mysql/mysql.server: line 159: kill: (580) - No such process
the offending line 159?
152 wait_for_pid () { 153 i=0 154 while test $i -ne $service_startup_timeout ; do 155 sleep 1 156 case "$1" in 157 'created') 158 test -s $pid_file && i='' && break 159 kill -0 $2 || break # if the program goes away, stop waiting 160 ;; 161 'removed')
and I get these messages now: Workaround Bonjour: Unknown error: 0
I don't think they are anything to do with mysql, perhaps apache2 since it doesn't do zeroconf stuff like the vendor-supplied httpd.
Yeah, doesn't look like it is running because I don't see mysqld running in the ps output. The Bonjour message is unrelated, though I'm not sure why they occur. Is it a new install, and if so have you run mysql_install_db5? Here is how I setup mysql5.
http://homepage.mac.com/duling/halfdozen/NeDi-Howto.html#d0e94
Also, have a look at the MySQL error log. See if it says anything helpful. You're not really meant to run the wrapper script yourself. The correct way to stop MySQL is: sudo launchctl unload -w /Library/LaunchDaemons/ org.macports.mysql5.plist And the correct way to start it is: sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist
On 7/10/07, Ryan Schmidt <ryandesign@macports.org> wrote:
On Jul 10, 2007, at 11:29, markd@macports.org wrote:
On Monday, July 9, 2007 at 11:03 PM paul beard wrote:
My guess is that it isn't. And I don't know why. Using ps gives me this.
root 47 0.0 0.1 27884 816 ?? Ss 10:46PM 0:00.04 /opt/local/bin/daemondo --label=mysql5 --start-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper start ; --stop-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper stop ; --restart-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper restart ; --pid=/opt/local/var/mysql.pid
running the script by hand gives me this.
/opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper start Starting MySQL/opt/local/share/mysql5/mysql/mysql.server: line 159: kill: (580) - No such process
the offending line 159?
152 wait_for_pid () { 153 i=0 154 while test $i -ne $service_startup_timeout ; do 155 sleep 1 156 case "$1" in 157 'created') 158 test -s $pid_file && i='' && break 159 kill -0 $2 || break # if the program goes away, stop waiting 160 ;; 161 'removed')
and I get these messages now: Workaround Bonjour: Unknown error: 0
I don't think they are anything to do with mysql, perhaps apache2 since it doesn't do zeroconf stuff like the vendor-supplied httpd.
Yeah, doesn't look like it is running because I don't see mysqld running in the ps output. The Bonjour message is unrelated, though I'm not sure why they occur. Is it a new install, and if so have you run mysql_install_db5? Here is how I setup mysql5.
http://homepage.mac.com/duling/halfdozen/NeDi-Howto.html#d0e94
Also, have a look at the MySQL error log. See if it says anything helpful.
You're not really meant to run the wrapper script yourself. The correct way to stop MySQL is:
sudo launchctl unload -w /Library/LaunchDaemons/ org.macports.mysql5.plist
And the correct way to start it is:
sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist
I prefer this: launchctl load -w /opt/local/etc/LaunchDaemons/org.macports.mysql5/org.macports.mysql5.plist as it keeps the plist back in the /opt tree where it belongs. It does require editing /etc/launch.conf, but I don't see that as a big deal versus adding symlinks all over the place. I did get mysql running by hand after re-rerunning the install script. Still had to change permissions on the db_dir afterwards. Still not sure if it will startup by itself, but i'll test that next. -- Paul Beard / www.paulbeard.org/ <paulbeard@gmail.com/paulbeard@mac.com>
participants (3)
-
markd＠macports.org
-
paul beard
-
Ryan Schmidt