-----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-Programs/1/ > 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 [EMAIL PROTECTED] Palladion Software "Excellence by Design" http://palladion.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v22.214.171.124 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFE2gk1+gerLs4ltQ4RAjTQAJ4j7O4kCKRpctlk8hywNTxJP96XbACgkhZI clb/IMxuLUdGwQhAV38R+Uk= =C5xn -----END PGP SIGNATURE----- _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )