[Zope] sorry, repost of can't get MysqL working with zope, help me please

[Chris Keyes]

Hi Jacob

Can you please type python
and then show us the output... I suspect that it may not be the version 
you think it is :-)

Jacob Singh wrote:

> This is the scenario, when trying to re-run the setup script for
> MySQLDB:
> And this is running from the correct python version.  I even deleted all
> the files (that I know of ) from the python dir that pertained to
> MySQLDB
> 
> [org@server1 MySQL-python-0.9.0]$ python setup.py 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)
> [org@server1 MySQL-python-0.9.0]$
> 
> 
> -----Original Message-----
> From: Jens Vagelpohl [mailto:jens@zope.com] 
> Sent: Monday, November 12, 2001 7:59 AM
> To: Jacob Singh
> Cc: zope@zope.org
> Subject: Re: [Zope] sorry, repost of can't get MysqL working with zope,
> help me please
> 
> to get rid of that error message you must recompile the Python-MySQLDB 
> using your newer python.
> 
> different versions of python have no problem at all co-existing
> peacefully,
>   as long as you don't install them in the very same location as the old
> 
> version. simply overwriting an existing installation, however, will give
> 
> you problems along the way.
> 
> jens
> 
> 
> On Sunday, November 11, 2001, at 05:48 , Jacob Singh wrote:
> 
> 
>>So here is what I have tried:
>>
>>
>>
>>I installed the Python-MySQLDB mod, but was using an old version of
>>python, then I upgraded python and re-installed it.  then I banged my
>>head against the wall trying to figure out how to use my python
>>executable and not Zope's.  Finnally figured that out (basically
>>undocumented) So then ZMySQLdb showed up as functional but gave the
>>following message and restarted the server whenever I tried to use it:
>>
>>
>>
>>WARNING: Python C API version mismatch for module _mysql:
>>
>>  This Python has API version 1010, module _mysql has version 1007.
>>
>>
>>
>>I have no idea what this means, so I tried making a symlink between a
>>directory in my lib/python and lib/python2.1 directories to the
>>directory containing the Python-MySQLdb .so file and using the Zope
>>provided interpreter (to no avail).  It can't find the module.  I
>>
> think
> 
>>one of my problems may also lie in that I don't know how to uninstall
>>the old python, I didn't really upgrade, I just installed the new one
>>and overwrote the python executable, with the new one, I know this
>>probably wasn't too smooth, but this is a learning process.  NEway,
>>
> any
> 
>>help would be GREATLY appreciated.  And if any Zope Dev's are reading
>>this. PLEASE make MySQL and PostGRES connectivity standard with any
>>
> Zope
> 
>>installation.
>>
>>Thank you
>>
>>Jacob Singh
>>
>>
> 
>