Re: [IBMiOSS] MySQL-Python

So the sqlite route was what I tried when I couldn't get MySQL to work and I actually DID install sqlite from Perzl:

bash-4.2$ sqlite3
SQLite version 3.7.16.2 2013-04-12 11:52:43

However, it doesn't correct the error when I try to start up the app:

import sqlite3
File "/QOpenSys/QIBM/ProdData/OPS/Python2.7/lib/python2.7/sqlite3/__init__.py", line 24, in <module>
from dbapi2 import *
File "/QOpenSys/QIBM/ProdData/OPS/Python2.7/lib/python2.7/sqlite3/dbapi2.py", line 28, in <module>
from _sqlite3 import *
ImportError: No module named _sqlite3

It is looking for the module _sqlite3 which, based on the research I did on the error is *supposed* to live here:

Z:\QOpenSys\QIBM\ProdData\OPS\Python2.7\lib\python2.7\lib-dynload

as _sqlite.so

Not sure if I can copy that shared object from someplace but that seems to be what the import statement is choking on....


Pete Helgren
www.petesworkshop.com
GIAC Secure Software Programmer-Java
Twitter - Sys_i_Geek IBM_i_Geek

On 12/27/2016 12:42 PM, Kevin Adler wrote:

Ok, still haven't gotten lunch yet, but I think I know the problem. When I
run pip install, it complained about missing mysql_config so I added
/usr/local/mysql/bin to the path and I could find mysql_config. Running
that, I see it outputs a bunch of stuff:

Usage: /usr/local/mysql/bin/mysql_config [OPTIONS]
Options:
--cflags [-I/usr/local/mysql/include -g -q64 -ma -qstrict
-qoptimize=2 -qmaxmem=8192 -qalign=natural -qldbl128 -DUNIV_AIX
-DUNIV_AIX]
--include [-I/usr/local/mysql/include]
--libs [-Wl,-brtl -L/usr/local/mysql/lib/mysql
-lmysqlclient -lz -lnsl_r -lm]
--libs_r [-Wl,-brtl -L/usr/local/mysql/lib/mysql
-lmysqlclient_r -lz -lnsl_r -lm]
--plugindir [/usr/local/mysql/lib/mysql/plugin]
--socket [/tmp/mysql.sock]
--port [0]
--version [5.1.59]
--libmysqld-libs [-Wl,-brtl -L/usr/local/mysql/lib/mysql -lmysqld
-ldl -lz -lnsl_r -lm -lrt]


It looks like the MySQL-python is using that output to detect the CFLAGS
to use when building itself. Since the MySQL connector was built with XLC
and also 64-bit (at least for the random version I have installed on this
box), it has -q64 in the CFLAGS.

Looks like the MySQL DB2 connector is mutually incompatible with the
Python we ship with OPS. You could try downloading the tar file and using
the /opt/freeware/bin/python_64 like so:

/opt/freeware/bin/python_64 setup.py build
/opt/freeware/bin/python_64 setup.py install

Of course, you'll need XLC for that unfortunately.


If you can deal with sqlite, you can use pysqlite at least. The sqlite
package that comes with Python was built against the Perzl sqlite (by
accident). If you install the Perzl sqlite it should work. (We're working
to fix this properly).