Hi all,
I've been unable to successfully install mysql-python.
Here are the details:
##########
# versions:
##########
OpenBSD 3.9 stable
Python 2.5
MySQL 3.23.58
MySQL-python-1.2.1_p2
##########
# build results:
##########
% python setup.py build
running build
running build_py
creating build
creating build/lib.openbsd-3.9-i386-2.5
copying _mysql_exceptions.py -> build/lib.openbsd-3.9-i386-2.5
creating build/lib.openbsd-3.9-i386-2.5/MySQLdb
copying MySQLdb/__init__.py -> build/lib.openbsd-3.9-i386-2.5/MySQLdb
copying MySQLdb/converters.py -> build/lib.openbsd-3.9-i386-2.5/MySQLdb
copying MySQLdb/connections.py -> build/lib.openbsd-3.9-i386-2.5/MySQLdb
copying MySQLdb/cursors.py -> build/lib.openbsd-3.9-i386-2.5/MySQLdb
copying MySQLdb/release.py -> build/lib.openbsd-3.9-i386-2.5/MySQLdb
copying MySQLdb/times.py -> build/lib.openbsd-3.9-i386-2.5/MySQLdb
creating build/lib.openbsd-3.9-i386-2.5/MySQLdb/constants
copying MySQLdb/constants/__init__.py ->
build/lib.openbsd-3.9-i386-2.5/MySQLdb/constants
copying MySQLdb/constants/CR.py ->
build/lib.openbsd-3.9-i386-2.5/MySQLdb/constants
copying MySQLdb/constants/FIELD_TYPE.py ->
build/lib.openbsd-3.9-i386-2.5/MySQLdb/constants
copying MySQLdb/constants/ER.py ->
build/lib.openbsd-3.9-i386-2.5/MySQLdb/constants
copying MySQLdb/constants/FLAG.py ->
build/lib.openbsd-3.9-i386-2.5/MySQLdb/constants
copying MySQLdb/constants/REFRESH.py ->
build/lib.openbsd-3.9-i386-2.5/MySQLdb/constants
copying MySQLdb/constants/CLIENT.py ->
build/lib.openbsd-3.9-i386-2.5/MySQLdb/constants
running build_ext
building '_mysql' extension
creating build/temp.openbsd-3.9-i386-2.5
gcc -fno-strict-aliasing -DNDEBUG -g -O3 -Wall -Wstrict-prototypes -fPIC
-I/usr/local/include/mysql -I/usr/local/include/python2.5 -c _mysql.c -o
build/temp.openbsd-3.9-i386-2.5/_mysql.o
-Dversion_info="(1,2,1,'final',2)" -D__version__="1.2.1_p2"
_mysql.c: In function `_mysql_server_init':
_mysql.c:222: warning: unused variable `s'
_mysql.c:223: warning: unused variable `cmd_argc'
_mysql.c:223: warning: unused variable `i'
_mysql.c:223: warning: unused variable `groupc'
_mysql.c:224: warning: unused variable `item'
_mysql.c:298: warning: label `finish' defined but not used
_mysql.c: In function `_mysql_escape_dict':
_mysql.c:1132: warning: passing arg 2 of `PyDict_Next' from incompatible
pointer type
gcc -shared -fPIC build/temp.openbsd-3.9-i386-2.5/_mysql.o
-L/usr/local/lib/mysql -lmysqlclient -lz -lm -o
build/lib.openbsd-3.9-i386-2.5/_mysql.so
##########
# install results:
##########
[root]# python setup.py install
running install
running build
running build_py
copying MySQLdb/release.py -> build/lib.openbsd-3.9-i386-2.5/MySQLdb
running build_ext
running install_lib
copying build/lib.openbsd-3.9-i386-2.5/_mysql_exceptions.py ->
/usr/local/lib/python2.5/site-packages
creating /usr/local/lib/python2.5/site-packages/MySQLdb
copying build/lib.openbsd-3.9-i386-2.5/MySQLdb/__init__.py ->
/usr/local/lib/python2.5/site-packages/MySQLdb
copying build/lib.openbsd-3.9-i386-2.5/MySQLdb/converters.py ->
/usr/local/lib/python2.5/site-packages/MySQLdb
copying build/lib.openbsd-3.9-i386-2.5/MySQLdb/connections.py ->
/usr/local/lib/python2.5/site-packages/MySQLdb
copying build/lib.openbsd-3.9-i386-2.5/MySQLdb/cursors.py ->
/usr/local/lib/python2.5/site-packages/MySQLdb
copying build/lib.openbsd-3.9-i386-2.5/MySQLdb/release.py ->
/usr/local/lib/python2.5/site-packages/MySQLdb
copying build/lib.openbsd-3.9-i386-2.5/MySQLdb/times.py ->
/usr/local/lib/python2.5/site-packages/MySQLdb
creating /usr/local/lib/python2.5/site-packages/MySQLdb/constants
copying build/lib.openbsd-3.9-i386-2.5/MySQLdb/constants/__init__.py ->
/usr/local/lib/python2.5/site-packages/MySQLdb/constants
copying build/lib.openbsd-3.9-i386-2.5/MySQLdb/constants/CR.py ->
/usr/local/lib/python2.5/site-packages/MySQLdb/constants
copying build/lib.openbsd-3.9-i386-2.5/MySQLdb/constants/FIELD_TYPE.py
-> /usr/local/lib/python2.5/site-packages/MySQLdb/constants
copying build/lib.openbsd-3.9-i386-2.5/MySQLdb/constants/ER.py ->
/usr/local/lib/python2.5/site-packages/MySQLdb/constants
copying build/lib.openbsd-3.9-i386-2.5/MySQLdb/constants/FLAG.py ->
/usr/local/lib/python2.5/site-packages/MySQLdb/constants
copying build/lib.openbsd-3.9-i386-2.5/MySQLdb/constants/REFRESH.py ->
/usr/local/lib/python2.5/site-packages/MySQLdb/constants
copying build/lib.openbsd-3.9-i386-2.5/MySQLdb/constants/CLIENT.py ->
/usr/local/lib/python2.5/site-packages/MySQLdb/constants
copying build/lib.openbsd-3.9-i386-2.5/_mysql.so ->
/usr/local/lib/python2.5/site-packages
byte-compiling
/usr/local/lib/python2.5/site-packages/_mysql_exceptions.py to
_mysql_exceptions.pyc
byte-compiling
/usr/local/lib/python2.5/site-packages/MySQLdb/__init__.py to
__init__.pyc
byte-compiling
/usr/local/lib/python2.5/site-packages/MySQLdb/converters.py to
converters.pyc
byte-compiling
/usr/local/lib/python2.5/site-packages/MySQLdb/connections.py to
connections.pyc
byte-compiling /usr/local/lib/python2.5/site-packages/MySQLdb/cursors.py
to cursors.pyc
byte-compiling /usr/local/lib/python2.5/site-packages/MySQLdb/release.py
to release.pyc
byte-compiling /usr/local/lib/python2.5/site-packages/MySQLdb/times.py
to times.pyc
byte-compiling
/usr/local/lib/python2.5/site-packages/MySQLdb/constants/__init__.py to
__init__.pyc
byte-compiling
/usr/local/lib/python2.5/site-packages/MySQLdb/constants/CR.py to CR.pyc
byte-compiling
/usr/local/lib/python2.5/site-packages/MySQLdb/constants/FIELD_TYPE.py
to FIELD_TYPE.pyc
byte-compiling
/usr/local/lib/python2.5/site-packages/MySQLdb/constants/ER.py to ER.pyc
byte-compiling
/usr/local/lib/python2.5/site-packages/MySQLdb/constants/FLAG.py to
FLAG.pyc
byte-compiling
/usr/local/lib/python2.5/site-packages/MySQLdb/constants/REFRESH.py to
REFRESH.pyc
byte-compiling
/usr/local/lib/python2.5/site-packages/MySQLdb/constants/CLIENT.py to
CLIENT.pyc
running install_egg_info
Writing
/usr/local/lib/python2.5/site-packages/MySQL_python-1.2.1_p2-py2.5.egg-info
##########
# test program db.py:
##########
#!/usr/local/bin/python
import MySQLdb
conn = MySQLdb.connect(db = 'xxxx', host = 'localhost', user = 'xxxx',
passwd = 'xxxx')
##########
# results of running db.py
##########
% ./db.py
Traceback (most recent call last):
File "./db.py", line 3, in <module>
import MySQLdb
File "/usr/local/lib/python2.5/site-packages/MySQLdb/__init__.py",
line 19, in <module>
import _mysql
ImportError: Cannot load specified object
