Tiny Core Linux

Tiny Core Base => Raspberry Pi => Topic started by: teh-botol on December 25, 2016, 01:23:47 AM

Title: MySQL-Python connector: version libmysqlclient didn't match
Post by: teh-botol on December 25, 2016, 01:23:47 AM

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 (https://github.com/farcepest/MySQLdb1)


BR,
adit

Title: Re: MySQL-Python connector: version libmysqlclient didn't match
Post by: teh-botol on December 25, 2016, 02:45:35 AM

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

BR,
adit

Title: Re: MySQL-Python connector: version libmysqlclient didn't match
Post by: bmarkus on December 25, 2016, 06:20:52 AM

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

Title: Re: MySQL-Python connector: version libmysqlclient didn't match
Post by: teh-botol on December 25, 2016, 07:06:04 AM

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


Title: Re: MySQL-Python connector: version libmysqlclient didn't match
Post by: bmarkus on December 25, 2016, 08:00:35 AM

Thanks for noting, fixed.

Title: Re: MySQL-Python connector: version libmysqlclient didn't match
Post by: teh-botol on December 25, 2016, 08:38:11 AM

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/ (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.

Title: Re: MySQL-Python connector: version libmysqlclient didn't match
Post by: bmarkus on December 26, 2016, 03:07:24 AM

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