#20365: MySQL plist file creating unmanaged launchd jobs on boot --------------------------------+------------------------------------------- Reporter: conradwt@… | Owner: ryandesign@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 1.7.1 Keywords: | Port: mysql5 --------------------------------+------------------------------------------- Comment(by conradwt@…): After correcting the previous issue, here's what I'm seeing when I perform a 'ps ax | grep mysql': PowerMac G5 - Leopard Build (9J61) 1204 ?? Ss 0:00.01 /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=none 1213 ?? S 0:00.02 /bin/sh /opt/local/lib/mysql5/bin/mysqld_safe --datadir=/opt/local/var/db/mysql5 --pid-file=/opt/local/var/db/mysql5 /darnoc-desktop.local.pid 1233 ?? S 0:00.20 /opt/local/libexec/mysqld --basedir=/opt/local --datadir=/opt/local/var/db/mysql5 --user=mysql --pid- file=/opt/local/var/db/mysql5/darnoc-desktop.local.pid Note: pid 1233 corresponds to the anonymous jobs: 0x10d310.mysqld and 0x10ce60.mysqld MacBook Pro - Snow Leopard Build (10A411) 797 ?? Ss 0:00.01 /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=none 807 ?? S 0:00.01 /bin/sh /opt/local/lib/mysql5/bin/mysqld_safe --datadir=/opt/local/var/db/mysql5 --pid-file=/opt/local/var/db/mysql5 /darnoc-laptop.local.pid 827 ?? S 0:00.24 /opt/local/libexec/mysqld --basedir=/opt/local --datadir=/opt/local/var/db/mysql5 --user=mysql --pid- file=/opt/local/var/db/mysql5/darnoc-laptop.local.pid Note: pid 827 corresponds to an anonymous job: 0x100101610.anonymous.mysqld. Are these anonymous jobs or extra processes needed by MySQL to function as a database server? -- Ticket URL: <http://trac.macports.org/ticket/20365#comment:2> MacPorts <http://www.macports.org/> Ports system for Mac OS

#20365: MySQL plist file creating unmanaged launchd jobs on boot --------------------------------+------------------------------------------- Reporter: conradwt@… | Owner: ryandesign@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 1.7.1 Keywords: | Port: mysql5 --------------------------------+------------------------------------------- Comment(by conradwt@…): Would it possible to simply have launchd manage this instead of using both launchd and daemondo? Also, it seems that there might be a good reason to have the following: /Library/LaunchDaemons/org.macports.mysql5.plist /Library/LaunchDaemons/org.macports.mysql5-server.plist From what I understand about launchd and after watching the WWDC09 video on the subject, it would be possible to deal with this type of dependency scenario. I will need to do some research in this regard. -- Ticket URL: <http://trac.macports.org/ticket/20365#comment:4> MacPorts <http://www.macports.org/> Ports system for Mac OS

#20365: MySQL plist file creating unmanaged launchd jobs on boot --------------------------------+------------------------------------------- Reporter: conradwt@… | Owner: ryandesign@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 1.7.1 Keywords: | Port: mysql5 --------------------------------+------------------------------------------- Description changed by ryandesign@…: Old description:

I'm using Mac OS 10.5.7 and launchd plist script for MySQL Server 5.0.81 appears to be creating unmanaged jobs. For example, the

sudo launchctl list | grep mysql

137 - 0x10b050.mysqld 137 - 0x10a2a0.mysqld

Note: The above are anonymous jobs on Mac OS 10.5.7 that cannot be unloaded.

However, there's no way to manage these jobs because there's no associated plist file to unload them. At this time, the process is running:

ps ax | grep mysql

98 ?? S 0:00.02 /bin/sh ./bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/darnoc- desktop.local.pid

137 ?? S 0:01.06 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/darnoc-desktop.local.pid

Thus, Damien Sorresso recommends the following:

add a "-launchd" flag to the startup options

New description: I'm using Mac OS 10.5.7 and launchd plist script for MySQL Server 5.0.81 appears to be creating unmanaged jobs. For example, the {{{ sudo launchctl list | grep mysql 137 - 0x10b050.mysqld 137 - 0x10a2a0.mysqld }}} Note: The above are anonymous jobs on Mac OS 10.5.7 that cannot be unloaded. However, there's no way to manage these jobs because there's no associated plist file to unload them. At this time, the process is running: {{{ ps ax | grep mysql 98 ?? S 0:00.02 /bin/sh ./bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/darnoc- desktop.local.pid 137 ?? S 0:01.06 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/darnoc-desktop.local.pid }}} Thus, Damien Sorresso recommends the following: add a "-launchd" flag to the startup options -- -- Ticket URL: <http://trac.macports.org/ticket/20365#comment:6> MacPorts <http://www.macports.org/> Ports system for Mac OS