[Zope] Re: mysql socket problem, MOSX 10.4.7

[Tres Seaver]

-----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          tseaver at 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-----