On Apr 8, 2007, at 2:23 PM, Altoine Barker wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Alright let me see if I can help. I will first need to know your setup (i.e. mac os x server version, macports version, mysql version(s), and exact installation steps up and until the point that you received your errors). Here are some points to look at to try to find your problem blindly. I do not know if you installed your Mac OS X Server with MySQL, but you should make sure that you have no MySQL Server instances running before installyin/upgrading MySQL. Run this command:
mysqladmin shutdown
Well, Tiger server comes with mysql4; I've reinstalled the Tiger server disks and also made sure that that is not running (subversion is the name of the machine):
subversion:~ admin$ mysqladmin shutdown 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! subversion:~ admin$ mysqladmin5 shutdown mysqladmin5: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/opt/ local/var/run/mysql5/mysqld.sock' (38)' Check that mysqld is running and that the socket: '/opt/local/var/ run/mysql5/mysqld.sock' exists! subversion:~ admin$ subversion:~ admin$ which mysql /usr/bin/mysql subversion:~ admin$ which mysql5 /opt/local/bin/mysql5 subversion:~ admin$
I've done 'top' and see no mysql5 running.
subversion:~ admin$ sudo killall mysql Password: No matching processes were found subversion:~ admin$ sudo killall mysql5 No matching processes were found subversion:~ admin$
Then install/upgrade mysql. I think this is the reason for the mysql.sock error message. HTH
- -Altoine
grimm@grimmwerks.com wrote:
Thanks Paul, but I've googled my arse off, and have tried what others have recommended:
- setting the socket in my.cnf - touching where the mysqld.sock should be, creating the file and making permissions 775
I've rebooted, restarted, etc. I've not had this problem on a non Tiger Server machine, but on this xserve, it's totally flaky.
I'll re-install mysql5 according to someone else's setup, but I really need to know the correct steps for OSX Server -- there's something going on there.
On Apr 7, 2007, at 9:28 PM, grimm@grimmwerks.com wrote:
I could really still use some help with mysql5 on Tiger server; no matter what I do I get:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (38)
I've tried setting it in the my.cnf, touching the actual file at /opt/local/var/run/mysql5/mysqld.sock
Anybody? This is driving me insane.
Thanks much. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGGTMWS0foIafBdlkRAmXIAJ49td4d2A4E0SS3d+bbQkv5RKvAngCeI3Xx 8p/s20fG2EipLJP9QRq5TOc= =ODVP -----END PGP SIGNATURE----- _______________________________________________ macports-users mailing list macports-users@lists.macosforge.org http://lists.macosforge.org/mailman/listinfo/macports-users