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 :

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 :

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 :

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 :

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 : Sélectionner tout - Visualiser dans une fenêtre à part
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 ?