MySQL-Python connector: version libmysqlclient didn't match

[teh-botol]

Hi Guys,

I just install PiCore 8.x with mariadb.
And I build MySQLdb1 (MySQL-Python connector) successfully.

But at runtime, I got this error:

Code: [Select]

tc@box:~/test$ ./start
Traceback (most recent call last):
  File "start.py", line 15, in <module>
    DB_ENGINE = create_engine(connstr)
  File "build/bdist.linux-armv7l/egg/sqlalchemy/engine/__init__.py", line 387, in create_engine

  File "build/bdist.linux-armv7l/egg/sqlalchemy/engine/strategies.py", line 80, in create
  File "build/bdist.linux-armv7l/egg/sqlalchemy/dialects/mysql/mysqldb.py", line 110, in dbapi
  File "build/bdist.linux-armv7l/egg/MySQLdb/__init__.py", line 19, in <module>

  File "build/bdist.linux-armv7l/egg/_mysql.py", line 7, in <module>
  File "build/bdist.linux-armv7l/egg/_mysql.py", line 6, in __bootstrap__
ImportError: /home/tc/.python-eggs/MySQL_python-1.2.4-py2.7-linux-armv7l.egg-tmp/_mysql.so: symbol mysql_shutdown, version libmysqlclient_16 not defined in file libmysqlclient.so.18 with link time reference


Ref:
MySQLdb1 source: https://github.com/farcepest/MySQLdb1


BR,
adit

[teh-botol]

FYI, I'm doing fine build and using MySQLdb1 inside TinyCore 7.x using virtual box.

BR,
adit

[bmarkus]

Looks it is incompatible with current MariaDB. Use mysql-connector-python.tcz from the repo.

[teh-botol]

I got: ImportError: No module named mysql
am I missing something?

Code: [Select]

tc@box:~/test$ ./start
Traceback (most recent call last):
  File "/home/tc/pos-cashier/globals.py", line 36, in <module>
    DB_ENGINE = create_engine(connstr)
  File "build/bdist.linux-armv7l/egg/sqlalchemy/engine/__init__.py", line 387, in create_engine

  File "build/bdist.linux-armv7l/egg/sqlalchemy/engine/strategies.py", line 80, in create
  File "build/bdist.linux-armv7l/egg/sqlalchemy/dialects/mysql/mysqlconnector.py", line 107, in dbapi
ImportError: No module named mysql


[bmarkus]

Thanks for noting, fixed.

[teh-botol]

Thx bmarkus, working great.

Information for someone needed (and personal note to try alternative):
I also tried download those connector from http://dev.mysql.com/downloads/connector/python/, "Platform Independent" one. For my surprise it's pure python. Hence, i tried it:
Extension needed setuptools.tcz

Code: [Select]

$ python setup.py build
$ python setup.py install --user
and it's working great.

[bmarkus]

pymysql.tcz added to repo. It is another MySQL connector written in pure Python.