2633 Views 8 Replies Latest reply: Nov 3, 2008 2:57 PM by theRocket
Thanks. I had looked there but didn't see anything Here is the content of org.mysql.mysqld.plist:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
I know that we are getting a bad DNS reverse that we are trying to resolve, but that was the only thing I saw in the file that seemed problematic. I do have a disabled key and OnDemand is off. Do you see anything else?
By the way, when I run serveradmin with full status I get:
*mysql:setStateVersion = 1*
*mysql:defaultFilesInstalled = yes*
*mysql:state = "RUNNING"*
*mysql:startTime = ""*
*mysql:logPaths:mysqlAdminLog = "/Library/Logs/MySQL.log"*
*mysql:logPaths:mysqlServiceLog = "/var/mysql/ferrari-moe.com.err"*
*mysql:readWriteSettingsVersion = 1*
*mysql:databaseLocation = "/var/mysql"*
*mysql:networkConnectAllowed = no*
When I run +sudo serveradmin stop mysql+ I get +mysql:error = "CANNOTSTATERR"+
I was hoping to just kill it with mysqladmin, but I get
*mysqladmin: connect to server at 'localhost' failed*
*error: 'Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)'*
*Check that mysqld is running and that the socket: '/var/mysql/mysql.sock' exists!*
I also don't have a mysql daemon showing up in Activity monitor
In MySQL.log I show
*2008-10-30 11:03:28 US/Pacific Stopping MySQL Service*
*2008-10-30 11:03:37 US/Pacific Stopping MySQL daemon...*
*2008-10-30 11:08:44 US/Pacific [E] MySQL daemon shutdown timed-out.*
When I run serveradmin shutdown.
Is it possible that serveradmin is just getting bad information somehow and MySQL really isn't running?
Thanks in advance
IIRC you can't rely on serveradmin if you've installed your own copy of apps. There's all kind of crossovers where serveradmin expects to find things in certain places and they're not there thanks to your custom install.
If you're running your own installation then you need to run your own (or vendor-provided) scripts to manage the server and pretty much ignore what serveradmin is telling you.
I think that is generally true, but there should be no crossover between Apple's MySQL install and the "official" MySQL install, at least according to the documentation from both sources. Serveradmin was reporting a running mysql although according to activity manager and top there were no mysql daemons running-- either stock or official. I just decided to force the official mysql to start up and it appears that it has. Hopefully launchd won't try to start up the stock release. I move the launchdaemon plist file so we will see.
I wouldn't encourage running two instances of a package on one box in parallel; any directions to the contrary, two separate versions in parallel is just asking for trouble. Certainly no overlap on the files and directories and such; it's having both versions running that I'd expect to see problems.
Pick one, and disable the other.
I do know of a few platforms and products that can run multiple versions in parallel (and outside of a virtual machine), but those platforms and products are rare.
I was seeing a lot of MySQL errors in my system log which surprised me since I didn't have MySQL enabled in my Server Admin.
I went into System Preferences and found a MySQL preference pane, it said that MySQL was running. Is this preference pane supposed to be there? I don't remember installing MySQL in the past, but maybe I did?
Furthermore I can't turn off this MySQL, I click the Stop button but it still says it is running.
If this isn't supposed to be there how do I uninstall it?
If you have the plist file as discussed above, I think you will have to shut MySQL off at the command line like this (depending on location):
sudo launchctl unload -w /Library/LaunchDaemons/com.mysql.mysqld.plist
I get my tips from Dan Benjamin: http://hivelogic.com/articles/2007/11/installing-mysql-on-mac-os-x