[MacPorts] #41806: mysql5 does not run

[MacPorts]

#41806: mysql5 does not run
----------------------------+-----------------------
  Reporter:  bpabbott@…     |      Owner:  pixilla@…
      Type:  defect         |     Status:  new
  Priority:  Normal         |  Milestone:
 Component:  ports          |    Version:  2.2.1
Resolution:                 |   Keywords:
      Port:  mysql5-server  |
----------------------------+-----------------------
Changes (by ryandesign@…):

 * cc: ryandesign@… (added)
 * owner:  macports-tickets@… => pixilla@…


Old description:

> I'm having trouble running mysql5. With Lion, I was successful following
> the
> instructions at the link below.
>
> https://trac.macports.org/wiki/howto/MAMP#mysql
>
> I've recently upgraded to Mavericks and returned to these same
> instructions.
>
> {{{
> sudo port install mysql5-server
> }}}
>
> {{{
> sudo -u mysql mysql_install_db5
> sudo chown -R mysql:mysql /opt/local/var/db/mysql5/
> sudo chown -R mysql:mysql /opt/local/var/run/mysql5/
> }}}
>
> The directory `/opt/local/var/log/mysql5` did not exist, so I created it
> and
> changed the permissions.
>
> {{{
> sudo mkdir -p /opt/local/var/log/mysql5
> sudo chown -R mysql:mysql /opt/local/var/log/mysql5/
> }}}
>
> Next I activated my MySQL server.
>
> {{{
> sudo port load mysql5-server
> }}}
>
> Which returned the error below.
>
> {{{
> Error: org.macports.load for port mysql5-server returned: Launchd plist
> /Library/LaunchDaemons/org.macports.mysql5.plist was not found
> Please see the log file for port mysql5-server for details:
> /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mysql5/mysql5-server/main.log
> To report a bug, follow the instructions in the guide:
>     http://guide.macports.org/#project.tickets
> Error: Processing of port mysql5-server failed
> }}}
>
> The log contains a bit more info.
>
> {{{
> version:1
> :debug:main Executing org.macports.main (mysql5-server)
> :debug:load load phase started at Fri Dec 13 18:27:18 EST 2013
> :debug:load Executing org.macports.load (mysql5-server)
> :error:load org.macports.load for port mysql5-server returned: Launchd
> plist /Library/LaunchDaemons/org.macports.mysql5.plist was not found
> :debug:load Error code: NONE
> :debug:load Backtrace: Launchd plist
> /Library/LaunchDaemons/org.macports.mysql5.plist was not found
>     while executing
> "$procedure $targetname"
> :info:load Warning: targets not executed for mysql5-server:
> org.macports.load
> :notice:load Please see the log file for port mysql5-server for details:
> /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mysql5/mysql5-server/main.log
> }}}

New description:

 I'm having trouble running mysql5. With Lion, I was successful following
 the
 instructions at the link below.

 wiki:howto/MAMP#mysql

 I've recently upgraded to Mavericks and returned to these same
 instructions.

 {{{
 sudo port install mysql5-server
 }}}

 {{{
 sudo -u mysql mysql_install_db5
 sudo chown -R mysql:mysql /opt/local/var/db/mysql5/
 sudo chown -R mysql:mysql /opt/local/var/run/mysql5/
 }}}

 The directory `/opt/local/var/log/mysql5` did not exist, so I created it
 and
 changed the permissions.

 {{{
 sudo mkdir -p /opt/local/var/log/mysql5
 sudo chown -R mysql:mysql /opt/local/var/log/mysql5/
 }}}

 Next I activated my MySQL server.

 {{{
 sudo port load mysql5-server
 }}}

 Which returned the error below.

 {{{
 Error: org.macports.load for port mysql5-server returned: Launchd plist
 /Library/LaunchDaemons/org.macports.mysql5.plist was not found
 Please see the log file for port mysql5-server for details:
 /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mysql5/mysql5-server/main.log
 To report a bug, follow the instructions in the guide:
     http://guide.macports.org/#project.tickets
 Error: Processing of port mysql5-server failed
 }}}

 The log contains a bit more info.

 {{{
 version:1
 :debug:main Executing org.macports.main (mysql5-server)
 :debug:load load phase started at Fri Dec 13 18:27:18 EST 2013
 :debug:load Executing org.macports.load (mysql5-server)
 :error:load org.macports.load for port mysql5-server returned: Launchd
 plist /Library/LaunchDaemons/org.macports.mysql5.plist was not found
 :debug:load Error code: NONE
 :debug:load Backtrace: Launchd plist
 /Library/LaunchDaemons/org.macports.mysql5.plist was not found
     while executing
 "$procedure $targetname"
 :info:load Warning: targets not executed for mysql5-server:
 org.macports.load
 :notice:load Please see the log file for port mysql5-server for details:
 /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_mysql5/mysql5-server/main.log
 }}}

--

Comment:

 Installing the mysql5-server port should have created the _mysql user
 (note the preceding underscore), and the /opt/local/var/log/mysql5
 directory, and the /Library/LaunchDaemons/org.macports.mysql5.plist file,
 and it does in fact do all those things on my Mavericks system. What is
 the output of these commands on your system:
 {{{
 port -v installed | grep mysql5
 port contents mysql5-server
 }}}

-- 
Ticket URL: <https://trac.macports.org/ticket/41806#comment:1>
MacPorts <http://www.macports.org/>
Ports system for OS X