mysql socket problem, MOSX 10.4.7
Yesterday I finally updated my MOSX Server 10.4.6 to 10.4.7. In addition to usual list of hosed configuration files and scripts, we now have a problem with Zope 2.7.x connecting to MySQL through a unix socket. We can connect with PHP apps, Filemaker Pro, and MySQL client. However, all Z MySQL database connections are broken. Here is the error: OperationalError: (2002, "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)") After googling and reading this article http://www.devshed.com/c/a/MySQL/Troubleshooting-Problems-with-MySQL-Program... I think the problem is that the socket file is supposed to be at /tmp/mysql.sock but it's not there. How does it get there? Can I copy it one from another (working) server and put it in that folder? It isn't present on my backup drive (which was supposed to be a complete bootable backup of the drive before the upgrade), so I don't know how we ever used the unix socket file - but we did! Thanks in advance! __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 baiewola wrote:
Yesterday I finally updated my MOSX Server 10.4.6 to 10.4.7. In addition to usual list of hosed configuration files and scripts, we now have a problem with Zope 2.7.x connecting to MySQL through a unix socket.
We can connect with PHP apps, Filemaker Pro, and MySQL client. However, all Z MySQL database connections are broken. Here is the error: OperationalError: (2002, "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)")
After googling and reading this article http://www.devshed.com/c/a/MySQL/Troubleshooting-Problems-with-MySQL-Program... I think the problem is that the socket file is supposed to be at /tmp/mysql.sock but it's not there. How does it get there? Can I copy it one from another (working) server and put it in that folder? It isn't present on my backup drive (which was supposed to be a complete bootable backup of the drive before the upgrade), so I don't know how we ever used the unix socket file - but we did!
You need to configure the MySQL server to listen on that socket: that will cause the "file" to be created, and Zope will then be able to connect. Note that this requires tha MySQL run on the same host as Zope. Tres. - -- =================================================================== Tres Seaver +1 202-558-7113 tseaver@palladion.com Palladion Software "Excellence by Design" http://palladion.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFE2gk1+gerLs4ltQ4RAjTQAJ4j7O4kCKRpctlk8hywNTxJP96XbACgkhZI clb/IMxuLUdGwQhAV38R+Uk= =C5xn -----END PGP SIGNATURE-----
baiewola wrote at 2006-8-9 05:16 -0700:
... We can connect with PHP apps, Filemaker Pro, and MySQL client. However, all Z MySQL database connections are broken. Here is the error: OperationalError: (2002, "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)")
After googling and reading this article http://www.devshed.com/c/a/MySQL/Troubleshooting-Problems-with-MySQL-Program... I think the problem is that the socket file is supposed to be at /tmp/mysql.sock but it's not there. How does it get there?
Usually, the server creates it on startup (when it is ready to accept connections there). -- Dieter
participants (3)
-
baiewola -
Dieter Maurer -
Tres Seaver