[CentOS] mysql-python

[Christopher Chan]

On Thursday, March 25, 2010 09:11 PM, JohnS wrote:
>
> On Thu, 2010-03-25 at 14:14 +0800, Christopher Chan wrote:
>> Is it me or does the MySQLdb module in Centos not support python's DBAPI
>> 2.0
>
> ---
> Well you give no clue to the code your using.  Post what type your
> using,
>
> It uses cursors so it it is compliant as far as I see.
>
> I get you installed it and it is dbapi 2.
>
> What does your python code look like?

The same as everything below except for the initialize() call.


>
> db = MySQLdb.connect (dsn='192.168.0.1:your_db',
>                        user='root', password='password')
> ##########################
> def addEntry(names):
>
>      cursor.initialize()
>      cursor = db.cursor ()
> ###########################
>
> I think a good idea would be to drop it and go to postgres, and import
> pgdb.


I would love to were it not for the fact that one of the target clients 
runs OpenSolaris and does not package a postgresql module for python. Grr...

Thanks, I will give this another shot before I give up on learning 
python and go back to perl or php land.