Opened 11 years ago

Closed 11 years ago

#41806 closed defect (worksforme)

mysql5 does not run

Reported by: bpabbott@… Owned by: pixilla (Bradley Giesbrecht)
Priority: Normal Milestone:
Component: ports Version: 2.2.1
Keywords: Cc: ryandesign (Ryan Carsten Schmidt)
Port: mysql5-server

Description (last modified by ryandesign (Ryan Carsten Schmidt))

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

Change History (3)

comment:1 Changed 11 years ago by ryandesign (Ryan Carsten Schmidt)

Cc: ryandesign@… added
Description: modified (diff)
Owner: changed from macports-tickets@… to pixilla@…

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

comment:2 Changed 11 years ago by bpabbott@…

Since my post, I rebooted, uninstalled mysql5 & mysql5-server, reinstalled, and then rebooted again. With that I was able to get everything running. Now I have no idea what when wrong.

In any event, thanks for the quick reply.

comment:3 Changed 11 years ago by ryandesign (Ryan Carsten Schmidt)

Resolution: worksforme
Status: newclosed

Ok good. I suspected that either mysql5-server was not installed or for some reason did not contain what it should, though I can think of no way for that to have happened. Glad you got it working.

Note: See TracTickets for help on using tickets.