operational error!!!(databse MySQL)
Hi All, I installed zope in my machine and testing and learning with small test programs for database access. when I try to open a ZMySQL connection with the commands as Id : MySQL_database_connection Title : Z MySQL Database Connection Connection String : testdb bala testpassword and then when I press add I am getting the error as Error Type: OperationalError Error Value: (2002, "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)") I am using OS : Linux 7.1 (kernel 2.4.2) Zope : Zope-2.5.1 python : python-2.1.3 mysql : mysq-3.23.49 ZMySQLDA : ZMySQLDA-2.0.7 ZODBCDA : ZODBCDA-3.1.0b1 pls help me find out the reason for this error, I am new to zope. Thanks in anticipation, Bala. __________________________________________________ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com
Bala <cppbala@yahoo.com> writes:
Error Value: (2002, "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
Check /etc/my.cnf, where the socket is located. In case your client libraries think different about this you may establish a symbolic link to get started. This is only a workaround - the right thing to do would be to correct the client libraries and build the _mysql module from scratch. The right entries in /etc/my.cnf are the ones containing "socket". Maybe that they are set different in th client- and mysqld section. If you correct his other things may break. Btw: this is _not_ a problem with Zope and only partial a Python problem. Regards, Frank
Bala writes:
I installed zope in my machine and testing and learning with small test programs for database access.
when I try to open a ZMySQL connection with the commands as
Id : MySQL_database_connection Title : Z MySQL Database Connection Connection String : testdb bala testpassword
and then when I press add I am getting the error as
Error Type: OperationalError Error Value: (2002, "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)")
When I get this error, I forgot to start the MySQL database... Dieter
participants (3)
-
Bala -
Dieter Maurer -
Frank Tegtmeyer