Can't get MySQLdb to connect

[Peter Nikolaidis]

Greetings,

	I am attempting to get MySQLdb 0.9.2 installed on Mac OS 10.2 with a 
Fink distribution of Python 2.2.2.  I have seen only a few posts on the 
subject, some of them relate to "conflicting header files," but I don't 
know what to do about conflicting header files, or where I would find 
them, and once I found them, which ones to remove.

	I have compiled MySQL 4.1 and installed into /usr/local/mysql, but 
since have moved to a Fink package installation or 4.0.13.  Although 
MySQLdb appears to install successfully (I think), I am unable to 
connect when I try, as shown below:

 >>> import sys
 >>> import MySQLdb
 >>> conn = MySQLdb.connect (db = 'mydb', host = 'localhost', user = 
'myuser', passwd = 'mypassword')
Traceback (most recent call last):
   File "<stdin>", line 1, in ?
   File "/sw/lib/python2.2/site-packages/MySQLdb/__init__.py", line 63, 
in Connect
     return apply(Connection, args, kwargs)
   File "/sw/lib/python2.2/site-packages/MySQLdb/connections.py", line 
116, in __init__
     self.converter[types.StringType] = self.string_literal
TypeError: object does not support item assignment
 >>>

	My setup.py file contains the following (although I've tried many 
variations, commenting and uncommenting stuff with no real success):

# include files and library locations should cover most platforms
include_dirs = [
#    '/usr/include/mysql',
#	 '/usr/local/include/mysql',
#    '/usr/local/mysql/include/mysql',
	 '/sw/include/mysql'
     ]
library_dirs = [
#    '/usr/lib/mysql',
#	 '/usr/local/lib/mysql',
#    '/usr/local/mysql/lib/mysql',
	 '/sw/lib/mysql', '/sw/lib'
     ]

This is what happens when I build:

running build
running build_py
not copying CompatMysqldb.py (output up-to-date)
not copying _mysql_exceptions.py (output up-to-date)
not copying MySQLdb/__init__.py (output up-to-date)
not copying MySQLdb/converters.py (output up-to-date)
not copying MySQLdb/connections.py (output up-to-date)
not copying MySQLdb/cursors.py (output up-to-date)
not copying MySQLdb/sets.py (output up-to-date)
not copying MySQLdb/times.py (output up-to-date)
not copying MySQLdb/constants/__init__.py (output up-to-date)
not copying MySQLdb/constants/CR.py (output up-to-date)
not copying MySQLdb/constants/FIELD_TYPE.py (output up-to-date)
not copying MySQLdb/constants/ER.py (output up-to-date)
not copying MySQLdb/constants/FLAG.py (output up-to-date)
not copying MySQLdb/constants/REFRESH.py (output up-to-date)
not copying MySQLdb/constants/CLIENT.py (output up-to-date)
running build_ext
skipping '_mysql' extension (up-to-date)

And when I run setup.py install:

running install
running build
running build_py
not copying CompatMysqldb.py (output up-to-date)
not copying _mysql_exceptions.py (output up-to-date)
not copying MySQLdb/__init__.py (output up-to-date)
not copying MySQLdb/converters.py (output up-to-date)
not copying MySQLdb/connections.py (output up-to-date)
not copying MySQLdb/cursors.py (output up-to-date)
not copying MySQLdb/sets.py (output up-to-date)
not copying MySQLdb/times.py (output up-to-date)
not copying MySQLdb/constants/__init__.py (output up-to-date)
not copying MySQLdb/constants/CR.py (output up-to-date)
not copying MySQLdb/constants/FIELD_TYPE.py (output up-to-date)
not copying MySQLdb/constants/ER.py (output up-to-date)
not copying MySQLdb/constants/FLAG.py (output up-to-date)
not copying MySQLdb/constants/REFRESH.py (output up-to-date)
not copying MySQLdb/constants/CLIENT.py (output up-to-date)
running build_ext
skipping '_mysql' extension (up-to-date)
running install_lib
not copying build/lib.darwin-6.6-PowerMacintosh-2.2/_mysql.so (output 
up-to-date)
not copying 
build/lib.darwin-6.6-PowerMacintosh-2.2/_mysql_exceptions.py (output 
up-to-date)
not copying build/lib.darwin-6.6-PowerMacintosh-2.2/CompatMysqldb.py 
(output up-to-date)
not copying build/lib.darwin-6.6-PowerMacintosh-2.2/MySQLdb/__init__.py 
(output up-to-date)
not copying 
build/lib.darwin-6.6-PowerMacintosh-2.2/MySQLdb/connections.py (output 
up-to-date)
not copying 
build/lib.darwin-6.6-PowerMacintosh-2.2/MySQLdb/constants/__init__.py 
(output up-to-date)
not copying 
build/lib.darwin-6.6-PowerMacintosh-2.2/MySQLdb/constants/CLIENT.py 
(output up-to-date)
not copying 
build/lib.darwin-6.6-PowerMacintosh-2.2/MySQLdb/constants/CR.py (output 
up-to-date)
not copying 
build/lib.darwin-6.6-PowerMacintosh-2.2/MySQLdb/constants/ER.py (output 
up-to-date)
not copying 
build/lib.darwin-6.6-PowerMacintosh-2.2/MySQLdb/constants/FIELD_TYPE.py 
(output up-to-date)
not copying 
build/lib.darwin-6.6-PowerMacintosh-2.2/MySQLdb/constants/FLAG.py 
(output up-to-date)
not copying 
build/lib.darwin-6.6-PowerMacintosh-2.2/MySQLdb/constants/REFRESH.py 
(output up-to-date)
not copying 
build/lib.darwin-6.6-PowerMacintosh-2.2/MySQLdb/converters.py (output 
up-to-date)
not copying build/lib.darwin-6.6-PowerMacintosh-2.2/MySQLdb/cursors.py 
(output up-to-date)
not copying build/lib.darwin-6.6-PowerMacintosh-2.2/MySQLdb/sets.py 
(output up-to-date)
not copying build/lib.darwin-6.6-PowerMacintosh-2.2/MySQLdb/times.py 
(output up-to-date)
skipping byte-compilation of 
/sw/lib/python2.2/site-packages/_mysql_exceptions.py to 
_mysql_exceptions.pyc
skipping byte-compilation of 
/sw/lib/python2.2/site-packages/CompatMysqldb.py to CompatMysqldb.pyc
skipping byte-compilation of 
/sw/lib/python2.2/site-packages/MySQLdb/__init__.py to __init__.pyc
skipping byte-compilation of 
/sw/lib/python2.2/site-packages/MySQLdb/connections.py to 
connections.pyc
skipping byte-compilation of 
/sw/lib/python2.2/site-packages/MySQLdb/constants/__init__.py to 
__init__.pyc
skipping byte-compilation of 
/sw/lib/python2.2/site-packages/MySQLdb/constants/CLIENT.py to 
CLIENT.pyc
skipping byte-compilation of 
/sw/lib/python2.2/site-packages/MySQLdb/constants/CR.py to CR.pyc
skipping byte-compilation of 
/sw/lib/python2.2/site-packages/MySQLdb/constants/ER.py to ER.pyc
skipping byte-compilation of 
/sw/lib/python2.2/site-packages/MySQLdb/constants/FIELD_TYPE.py to 
FIELD_TYPE.pyc
skipping byte-compilation of 
/sw/lib/python2.2/site-packages/MySQLdb/constants/FLAG.py to FLAG.pyc
skipping byte-compilation of 
/sw/lib/python2.2/site-packages/MySQLdb/constants/REFRESH.py to 
REFRESH.pyc
skipping byte-compilation of 
/sw/lib/python2.2/site-packages/MySQLdb/converters.py to converters.pyc
skipping byte-compilation of 
/sw/lib/python2.2/site-packages/MySQLdb/cursors.py to cursors.pyc
skipping byte-compilation of 
/sw/lib/python2.2/site-packages/MySQLdb/sets.py to sets.pyc
skipping byte-compilation of 
/sw/lib/python2.2/site-packages/MySQLdb/times.py to times.pyc


	Any help would be greatly appreciated.

Thanks,

Peter