Error importing on mysqldb 1.2 on Mac 10.4

[Jeremy Dunck]

Hi all.

First, thanks, Andy, for the lib.

I'm trying to use 1.2.0 on Mac 10.4.5 (w/ XCode 2.0), under Py 2.3.5 (as shipped w/ OS X) and mysql 4.1.13-standard (as installed from G4 binary from mysql.com), using gcc 3.3.

Build and install went smoothly.

However, when I import, I get this:

>>> import MySQLdb
Traceback (most recent call last):
File "<stdin>", line 1, in ?
File "/System/Library/Frameworks/Python.framework/Versions/2.3/lib/python2.3/site-packages/MySQLdb/init.py", line 27, in ?
import _mysql
ImportError: dlopen(./_mysql.so, 2): Symbol not found: _sprintf$LDBLStub
Referenced from: ./_mysql.so
Expected in: dynamic lookup

=====

I noted that several other mac install issues have been fixed in a later RC, but didn't see this particular issue.

Any pointers? Should I just try an RC?

[Jeremy Dunck]

Huzzah!

1.2.1 had the same problem for me, but I figured it out.

I was compiling with gcc 3.3, and changing to 4.0 did the trick. This may have something to do with me having XCode 2.0.

For clarity, since I had already installed mysqldb, the complete steps were:

1) remove the installed files from the failed install. The files are in site-packages, which you can find by importing sys and inspecting sys.path.
In my case, it was:
/Library/Python/2.3/site-packages
and these files and folders:
x rm /Library/Python/2.3/site-packages/_mysql*
x rm -rf /Library/Python/2.3/site-packages/MySQLdb

2) switch to gcc 4.0 with:
sudo gcc_select 4.0

3) the regular python build/install
x python setup.py build
x sudo python setup.py install

4) there is no step 4.

[Andy Dustman]

I have no idea what that means, but try the latest 1.2.1 release candidate.

I expect to release 1.2.1 shortly after PyCon 2006.