Re: MySQLdb Install Linux Not Working (SOLVED)

[Kharlamov Igor]

I solved the problem by next way:

1. Setup MySQL (version 4.1.22 or 5.0.51) by default. Location is /usr/local/mysql.
2. Check up file existing:

/usl/local/mysql/lib/mysql:

[zope@localhost mysql]$ ll
total 2640
-rw-r--r-- 1 root mysql 20842 Jan 29 14:05 libdbug.a
-rw-r--r-- 1 root mysql 70152 Jan 29 14:05 libheap.a
-rw-r--r-- 1 root mysql 22754 Jan 29 14:05 libmerge.a
-rw-r--r-- 1 root mysql 460804 Jan 29 14:05 libmyisam.a
-rw-r--r-- 1 root mysql 41762 Jan 29 14:05 libmyisammrg.a
-rw-r--r-- 1 root mysql 682096 Jan 29 14:05 libmysqlclient.a
-rwxr-xr-x 1 root mysql 879 Jan 29 14:05 libmysqlclient.la
lrwxrwxrwx 1 root mysql 24 Jan 29 14:05 libmysqlclient.so -> libmysqlclient.so.14.0.0
lrwxrwxrwx 1 root mysql 24 Jan 29 14:05 libmysqlclient.so.14 -> libmysqlclient.so.14.0.0
-rwxr-xr-x 1 root mysql 465740 Jan 29 14:05 libmysqlclient.so.14.0.0
-rw-r--r-- 1 root mysql 313436 Jan 29 14:05 libmystrings.a
-rw-r--r-- 1 root mysql 399512 Jan 29 14:05 libmysys.a
-rw-r--r-- 1 root mysql 158668 Jan 29 14:05 libnisam.a
-rw-r--r-- 1 root mysql 9412 Jan 29 14:05 libvio.a

2. Start MySQL and check up mysqladmin ping, should be:

[zope@localhost bin]$ ./mysqladmin ping
mysqld is alive

3. Before install MySQL-python set LD_LIBRARY_PATH, the best is to add into ./bash_profile or into ldconfig:

$ LD_LIBRARY_PATH=/usr/local/mysql/lib/mysql
$ export LD_LIBRARY_PATH

4. I've tried to implement MySQL-python-1.2.1_p2:

$ tar zxvf MySQL-python-1.2.1_p2
$ cd MySQL-python-1.2.1_p2

step1 (note, all is False):
in site.cfg set:
[options]
embedded = False
threadsafe = False
static = False

run:
$ python2.3 setup.py build

should be without errors.

step2:
in site.cfg set again, but now threadsafe is True:
[options]
embedded = False
threadsafe = True
static = False

run one more:
$ python2.3 setup.py build

5. Install (LD_LIBRARY_PATH must be the same):

# python2.3 setup.py install

6. Check up the results:

[zope@localhost MySQL-python-1.2.1_p2]$ python2.3
Python 2.3.6 (#1, Dec 28 2007, 12:39:17)
[GCC 4.1.1 20070105 (Red Hat 4.1.1-52)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import MySQLdb
>>>

should be without errors!

7. That's all, ready to use. I can implement MySQL under zope, for instance. Is running. Good.

But, i don't know exactly will it work with threadsafe ;) Sorry.



Edited 1 time(s). Last edit at 01/29/2008 09:35AM by Kharlamov Igor.