MySQLdb bloque mon script python

Bonjour a tous,


Alors voila, j'ai cree un script Python tout simple qui permet d'executer une requete SELECT puis de retourner les resultats, mais seulement voila, j'ai un probleme de librairies semblerait-il.

Lorsque j'execute mon script, voici ce qui est retourne :

Citation:

---

Traceback (most recent call last):
File "./test2.py", line 3, in ?
import MySQLdb
ImportError: No module named MySQLdb

---

Lorsque je check toutes mes librairies autour de "mysql" avec cette commande "rpm -qa | grep -i mysql", ca me retourne :

Citation:

---

MySQL-bench-5.0.92-0.glibc23
MySQL-client-5.0.95-0.cp1130.glibc23
MySQL-server-5.0.95-0.cp1130.glibc23
MySQL-devel-5.0.95-0.cp1130.glibc23
perl-DBD-MySQL-2.9004-3.1.centos4
lp-cpperl-DBD-MySQL-1.0-5
cpperl-DBD-MySQL-2.9004-3.1
MySQL-shared-5.0.95-0.cp1130.glibc23

---

Car en plus lorsque je souhaite installer "MySQL-python", ca me dit :

Citation:

---

Setting up Install Process
Setting up repositories
Reading repository metadata in from local files
Excluding Packages in global exclude list
Finished
Parsing package install arguments
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package MySQL-python.i386 0:1.2.1_p2-1.el4.1 set to be updated
--> Running transaction check
--> Processing Dependency: libmysqlclient_r.so.14(libmysqlclient_14) for package: MySQL-python
--> Processing Dependency: libmysqlclient_r.so.14 for package: MySQL-python
--> Processing Dependency: mx for package: MySQL-python
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package mx.i386 0:2.0.5-3 set to be updated
--> Running transaction check
--> Processing Dependency: libmysqlclient_r.so.14(libmysqlclient_14) for package: MySQL-python
--> Processing Dependency: libmysqlclient_r.so.14 for package: MySQL-python
--> Finished Dependency Resolution
Error: Missing Dependency: libmysqlclient_r.so.14(libmysqlclient_14) is needed by package MySQL-python
Error: Missing Dependency: libmysqlclient_r.so.14 is needed by package MySQL-python

---

Du coup en checkant "/usr/lib | grep mysqlcli" j'ai la version ulterieure :

Citation:

---

lrwxrwxrwx 1 root root 26 Nov 6 05:58 libmysqlclient_r.so -> libmysqlclient_r.so.15.0.0
lrwxrwxrwx 1 root root 26 Nov 6 05:58 libmysqlclient_r.so.15 -> libmysqlclient_r.so.15.0.0
-rwxr-xr-x 1 root root 2326897 Feb 22 2012 libmysqlclient_r.so.15.0.0
lrwxrwxrwx 1 root root 24 Nov 6 05:58 libmysqlclient.so -> libmysqlclient.so.15.0.0
lrwxrwxrwx 1 root root 24 Nov 6 05:58 libmysqlclient.so.15 -> libmysqlclient.so.15.0.0
-rwxr-xr-x 1 root root 2300496 Feb 22 2012 libmysqlclient.so.15.0.0

---

Que dois-je faire ??


Tout ca pour executer ce script

Code:

---

1 2 3 4 5 6 7 8 9 10 11

#!/usr/bin/python   import MySQLdb db = MySQLdb,connect("hostdb", "user", "pw", "db") cursor = db.cursor() query = """SELECT * FROM table""" lines = cursor.execute(query) while True: row = cursor.fetchone() if row == None: break db.close()

---

En plus en le faisant en PHP ce script j'aurais pas besoin de la librairie je suppose ?

Ce sera peut être pas la même que celle utilisée par PHP.

Dans le doute, fais $ php -i | grep mysql, si y'a des resultats, c'est que mysql est utilisable :)

Lorsque je tente de lancher mon script PHP

Code:

---

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

<?php   $con = mysql_connect("dbhost","user","pw"); if (!$con) { die('Could not connect: ' . mysql_error()); }   mysql_select_db("user", $con);   $result = mysql_query("SELECT * FROM mytable");   while($row = mysql_fetch_array($result)) { echo $row['id']; }   mysql_close($con);   ?>

---

J'ai ce probleme qui est sorti :

Citation:

---

Cannot load the ionCube PHP Loader - it was built with configuration 2.2.0, whereas running engine is API220090626,NTS
Zend Optimizer requires Zend Engine API version 220060519.
The Zend Engine API version 220090626 which is installed, is newer.
Contact Zend Technologies at http://www.zend.com/ for a later version of Zend Optimizer.


Warning: mysql_connect(): Access denied for user 'user'@'localhost' (using password: YES) in /home/tesst.php on line 3
Could not connect: Access denied for user 'user'@'localhost' (using password: YES)

---

Et lorsque je tente la commande que tu dis, j'ai pourtant :

Citation:

---

Cannot load the ionCube PHP Loader - it was built with configuration 2.2.0, whereas running engine is API220090626,NTS
Zend Optimizer requires Zend Engine API version 220060519.
The Zend Engine API version 220090626 which is installed, is newer.
Contact Zend Technologies at http://www.zend.com/ for a later version of Zend Optimizer.

Configure Command => './configure' '--disable-fileinfo' '--disable-mbregex' '--disable-pdo' '--disable-phar' '--enable-bcmath' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-gd-native-ttf' '--enable-libxml' '--enable-magic-quotes' '--enable-mbstring' '--enable-soap' '--enable-sockets' '--enable-zip' '--prefix=/usr/local' '--with-apxs2=/usr/local/apache/bin/apxs' '--with-curl=/opt/curlssl/' '--with-freetype-dir=/usr' '--with-gd' '--with-gettext' '--with-imap=/opt/php_with_imap_client/' '--with-imap-ssl=/usr' '--with-jpeg-dir=/usr' '--with-kerberos' '--with-libxml-dir=/opt/xml2' '--with-libxml-dir=/opt/xml2/' '--with-mcrypt=/opt/libmcrypt/' '--with-mysql=/usr' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-openssl=/usr' '--with-openssl-dir=/usr' '--with-pcre-regex=/opt/pcre' '--with-png-dir=/usr' '--with-xpm-dir=/usr/X11R6' '--with-zlib' '--with-zlib-dir=/usr' '--without-iconv' '--without-sqlite3'
mysql
MYSQL_SOCKET => /var/lib/mysql/mysql.sock
MYSQL_INCLUDE => -I/usr/include/mysql
MYSQL_LIBS => -L/usr/lib -lmysqlclient
mysql.allow_local_infile => On => On
mysql.allow_persistent => On => On
mysql.connect_timeout => 60 => 60
mysql.default_host => no value => no value
mysql.default_password => no value => no value
mysql.default_port => no value => no value
mysql.default_socket => /var/lib/mysql/mysql.sock => /var/lib/mysql/mysql.sock
mysql.default_user => no value => no value
mysql.max_links => Unlimited => Unlimited
mysql.max_persistent => Unlimited => Unlimited
mysql.trace_mode => Off => Off

---

Wow, ça c'est de l'install foirée ou je m'y connais pas.

Comment tu t'y es pris, t'as fait un genre de rpm -ivh --force --nodeps repos/*.rpm ???