Skip navigation links

MySQL Forums :: Connector/Python :: MySQLdb Install Linux Not Working


Advanced Search

Re: MySQLdb Install Linux Not Working (SOLVED)
Posted by: Kharlamov Igor ()
Date: January 29, 2008 09:33AM

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.

Options: ReplyQuote


Subject Written By Posted
MySQLdb Install Linux Not Working Robert Mazur 01/09/2008 09:10PM
Re: MySQLdb Install Linux Not Working Kharlamov Igor 01/28/2008 09:59AM
Re: MySQLdb Install Linux Not Working (SOLVED) Kharlamov Igor 01/29/2008 09:33AM
Re: MySQLdb Install Linux Not Working (SOLVED) in[firstname] in[lastname] 02/19/2008 03:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.