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 :
Lorsque je check toutes mes librairies autour de "mysql" avec cette commande "rpm -qa | grep -i mysql", ca me retourne :Traceback (most recent call last):
File "./test2.py", line 3, in ?
import MySQLdb
ImportError: No module named MySQLdb
Car en plus lorsque je souhaite installer "MySQL-python", ca me dit :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
Du coup en checkant "/usr/lib | grep mysqlcli" j'ai la version ulterieure :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
Que dois-je faire ??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
Tout ca pour executer ce script
En plus en le faisant en PHP ce script j'aurais pas besoin de la librairie je suppose ?
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()
Partager