Trouble on Alpha under RedHat 6.2

[Rob Steele]

It builds and installs without problems but it fails at import time with this message:

Python 1.5.2 (#1, Feb  1 2000, 16:32:24)  [GCC egcs-2.91.66 19990314/Linux (egcs- on linux-alpha
Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam
>>> import MySQLdb
Traceback (innermost last):
  File "<stdin>", line 1, in ?
  File "MySQLdb/__init__.py", line 27, in ?
    import _mysql
ImportError: /usr/lib/python1.5/site-packages/_mysql.so: undefined symbol: _OtsMove
>>>

I tried adding a library:

    libraries = [mysqlclient, "z", "ots"]

and then got this error:

Python 1.5.2 (#1, Feb  1 2000, 16:32:24)  [GCC egcs-2.91.66 19990314/Linux (egcs- on linux-alpha
Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam
>>> import MySQLdb
Traceback (innermost last):
  File "<stdin>", line 1, in ?
  File "MySQLdb/__init__.py", line 27, in ?
    import _mysql
ImportError: /usr/lib/python1.5/site-packages/_mysql.so: undefined symbol: __floor
>>>

Any ideas?

Thanks!
Rob

[Andy Dustman]

I guess you need the math libs. Add "m" to the list of libraries. I have no idea what ots is.

[Rob Steele]

Thanks for looking at for me.  I tried your suggestion

    libraries = [mysqlclient, "z", "ots", "m"]

but it didn't change the error message:

Python 1.5.2 (#1, Feb  1 2000, 16:32:24)  [GCC egcs-2.91.66 19990314/Linux (egcs- on linux-alpha
Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam
>>> import MySQLdb
Traceback (innermost last):
  File "<stdin>", line 1, in ?
  File "MySQLdb/__init__.py", line 27, in ?
    import _mysql
ImportError: /usr/lib/python1.5/site-packages/_mysql.so: undefined symbol: __floor
>>>

I'm stumped.

Thanks,
Rob

[Andy Dustman]

Make sure you are getting a rebuild. Changing library flags won't do that. rm -r build to be sure.

[Rob Steele]

I finally got it working this way:

In setup.py;

    libraries = [mysqlclient, "z", "ots"]

In _mysql.c:

#include <math.h>

double
__floor(double x)
{
    return floor(x); 
}

Would you be interested to see a load map?

Thanks,
Rob

[Rob Steele]

Yup.  Done that.  :(