MySQL5, MDK10.1, unresolved symbol

[Jean-Marie Gouy]

Hello,

I'm trying to use MySQL for Python, but when I run the script it returns this error :
" import _mysql
ImportError: /usr/lib/python2.4/site-packages/_mysql.so: undefined symbol: mysql_set_character_set"

I'm using Mandrake 10.1, MySQL 5.0, Python 2.4.3, and MySQL-python-1.2.1.

Any ideas? Thanks

[Andy Dustman]

You probably have multiple installations of MySQL. Check the current bug list, and check the output of mysql_config.

[Jean-Marie Gouy]

ok, it's fixed, I've rebuild MySQLdb. :)

[Jean-Marie Gouy]

Thanks, you were right, i had libmysqlclient from mysql4 installed.
Now it works fine, but it's strange, I had to create a symbolic link between libmysqlclient.so.15.0.0 libmysqlclient_r.so.12 ...

[Andy Dustman]

That's not good. You should eliminate all references to libmysqlclient_r.so.12 and rebuild MySQLdb. Otherwise you are using the 4.0 API with 5.0.