[CentOS] Centos + python + sqlalchemy + mysql

Wed Feb 2 20:32:26 UTC 2011
przemolicc at poczta.fm <przemolicc at poczta.fm>

I am trying to use the following set (all from standard repositories):
centos (5.5) + python 2.6 + sqlalchemy + mysql. However while running my script I get:

Traceback (most recent call last):
  File "./oraping2.py", line 43, in <module>
    main()
  File "./oraping2.py", line 23, in main
    db = create_engine('mysql:///u1oraping@localhost:3306/oraping',echo=False,pool_recycle=1800)
  File "/usr/lib/python2.6/site-packages/sqlalchemy/engine/__init__.py", line 244, in create_engine
    return strategy.create(*args, **kwargs)
  File "/usr/lib/python2.6/site-packages/sqlalchemy/engine/strategies.py", line 60, in create
    dbapi = dialect_cls.dbapi(**dbapi_args)
  File "/usr/lib/python2.6/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 101, in dbapi
    return __import__('MySQLdb')
  File "/usr/lib64/python2.4/site-packages/MySQLdb/__init__.py", line 19, in <module>
    import _mysql
ImportError: /usr/lib64/python2.4/site-packages/_mysql.so: undefined symbol: Py_InitModule4

Did anybody faced this error ?
Does anybody use the above set of software on Centos ?

Regards
Przemek

-----------------------------------------------------------------

Sprawdz pogode.
Kliknij >>> http://linkint.pl/f2903