Module DBD::Mysql et mysql

Module DBD::Mysql et mysql_config

Bonjour,

Je suis actuellement entrain de travailler sur une VM RedHat et afin de tester des scripts Perl je dois installer le Module DBD::Mysql. Je l'ai téléchargé, détarré.

Lors de l’exécution de perl Makefile.PL, j'obtiens cette erreur que je n'arrive pas à corriger.

Citation:

Can't exec "mysql_config": No such file or directory at Makefile.PL line 76.

Cannot find the file 'mysql_config'! Your execution PATH doesn't seem
not contain the path to mysql_config. Resorting to guessed values!
Can't exec "mysql_config": No such file or directory at Makefile.PL line 454.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 454.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 454.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 454.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 454.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 454.
Failed to determine directory of mysql.h. Use

perl Makefile.PL --cflags=-I<dir>

to set this directory. For details see the INSTALL.html file,
section "C Compiler flags" or type

perl Makefile.PL --help

J'ai effectué plusieurs commandes de recherche afin de trouver mysql_config.pl, mais il n'existe pas. Le seul fichier de conf mysql que j'ai trouvé se trouve dans /etc/my.cnf

Et quand je lance perl Makefile.PL --mysql_config=/etc/my.cnf j'obtiens encore une fois une erreur.

Ayant farfouillé sur Internet sans trouver grand chose d'intéressant, je me trouve vers vous !

Je rencontre aussi un problème avec cpan (en console) ce qui fait que je ne peux passer par ce moyen pour installer des modules.

Merci d'avance !

Hello,

J'avance péniblement dans mes recherches, voici quelques infos en plus :

Version de la VM : RedHat RHEL 5.3 x86_64

Packages installés :

mysql :

Citation:

yum list "mysql*"
Loaded plugins: security
Installed Packages
MySQL-client.x86_64 5.6.16-1.rhel5 installed
MySQL-server.x86_64 5.6.16-1.rhel5 installed
MySQL-shared.x86_64 5.6.16-1.rhel5 installed
MySQL-shared-compat.x86_64 5.6.16-1.rhel5 installed

perl :

Citation:

yum list "perl*"
Loaded plugins: security
Installed Packages
perl.x86_64 4:5.8.8-18.el5_3.1 installed
perl-Cache-Cache.noarch 1.06-1.el5.rf installed
perl-Compress-Zlib.x86_64 1.42-1.fc6 installed
perl-Convert-ASN1.noarch 0.20-1.1 installed
perl-Crypt-DES.x86_64 2.05-3.2.el5.rf installed
perl-Crypt-SSLeay.x86_64 0.57-3.el5.rfx installed
perl-Crypt-xDBM_File.noarch 1.02-1.el5.rf installed
perl-DBI.x86_64 1.52-2.el5 installed
perl-Digest-SHA1.x86_64 2.11-1.2.1 installed
perl-Error.noarch 0.17017-1.el5.rf installed
perl-HTML-Template.noarch 2.9-1.el5.rf installed
perl-IO-Zlib.noarch 1.04-4.2.1 installed
perl-IPC-ShareLite.x86_64 0.17-1.el5.rf installed
perl-Socket6.x86_64 0.23-1.el5.rfx installed
perl-URI.noarch 1.35-3 installed

Avec ce lien : http://forums.mysql.com/read.php?51,...6062#msg-86062 , j'ai essayé de télécharger le rpm qui va bien mais lors de l'installation ce rpm dépend d'un autre rpm qui dépend de ce rpm :weird:

Bref, toujours pas trouvé la solution :?

EDIT : Sur cpan, ils disent de taper ça :

Citation:

yum install "perl(DBD::mysql)"

Voilà le résultat :

Citation:

yum install "perl(DBD::mysql)"
Loaded plugins: security
Setting up Install Process
Parsing package install arguments
No package perl(DBD::mysql) available.
Nothing to do

Via cpan ==> cpan DBD::mysql

Citation:

cpan DBD::mysql
CPAN: Storable loaded ok
LWP not available

Trying with "/usr/bin/wget -O -" to get
http://mirror.ibcp.fr/pub/CPAN/authors/01mailrc.txt.gz
--16:06:54-- http://mirror.ibcp.fr/pub/CPAN/authors/01mailrc.txt.gz
Resolving mirror.ibcp.fr... failed: Name or service not known.

System call "/usr/bin/wget -O - "http://mirror.ibcp.fr/pub/CPAN/authors/01mailrc.txt.gz" > /root/.cpan/sources/authors/01mailrc.txt"
returned status 1 (wstat 256)
Warning: expected file [/root/.cpan/sources/authors/01mailrc.txt.gz] doesn't exist
Please check, if the URLs I found in your configuration file
(http://mirror.ibcp.fr/pub/CPAN/) are valid. The urllist can be edited.
E.g. with 'o conf urllist push ftp://myurl/'

Could not fetch authors/01mailrc.txt.gz
LWP not available

Trying with "/usr/bin/wget -O -" to get
http://mirror.ibcp.fr/pub/CPAN/modul...details.txt.gz
--16:06:56-- http://mirror.ibcp.fr/pub/CPAN/modul...details.txt.gz
Resolving mirror.ibcp.fr... failed: Name or service not known.

System call "/usr/bin/wget -O - "http://mirror.ibcp.fr/pub/CPAN/modules/02packages.details.txt.gz" > /root/.cpan/sources/modules/02packages.details.txt"
returned status 1 (wstat 256)
Warning: expected file [/root/.cpan/sources/modules/02packages.details.txt.gz] doesn't exist
Please check, if the URLs I found in your configuration file
(http://mirror.ibcp.fr/pub/CPAN/) are valid. The urllist can be edited.
E.g. with 'o conf urllist push ftp://myurl/'

Could not fetch modules/02packages.details.txt.gz
LWP not available

Trying with "/usr/bin/wget -O -" to get
http://mirror.ibcp.fr/pub/CPAN/modul...odlist.data.gz
--16:06:58-- http://mirror.ibcp.fr/pub/CPAN/modul...odlist.data.gz
Resolving mirror.ibcp.fr... failed: Name or service not known.

System call "/usr/bin/wget -O - "http://mirror.ibcp.fr/pub/CPAN/modules/03modlist.data.gz" > /root/.cpan/sources/modules/03modlist.data"
returned status 1 (wstat 256)
Warning: expected file [/root/.cpan/sources/modules/03modlist.data.gz] doesn't exist
Please check, if the URLs I found in your configuration file
(http://mirror.ibcp.fr/pub/CPAN/) are valid. The urllist can be edited.
E.g. with 'o conf urllist push ftp://myurl/'

Could not fetch modules/03modlist.data.gz
Going to write /root/.cpan/Metadata
Warning: Cannot install DBD::mysql, don't know what it is.
Try the command

i /DBD::mysql/

to find objects with matching identifiers.

Commande : i /DBD::mysql/

Citation:

cpan> i /DBD::mysql/
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
Warning: Found only 0 objects in /root/.cpan/Metadata
LWP not available

Trying with "/usr/bin/wget -O -" to get
http://mirror.ibcp.fr/pub/CPAN/authors/01mailrc.txt.gz
--16:07:17-- http://mirror.ibcp.fr/pub/CPAN/authors/01mailrc.txt.gz
Resolving mirror.ibcp.fr... failed: Name or service not known.

System call "/usr/bin/wget -O - "http://mirror.ibcp.fr/pub/CPAN/authors/01mailrc.txt.gz" > /root/.cpan/sources/authors/01mailrc.txt"
returned status 1 (wstat 256)
Warning: expected file [/root/.cpan/sources/authors/01mailrc.txt.gz] doesn't exist
Please check, if the URLs I found in your configuration file
(http://mirror.ibcp.fr/pub/CPAN/) are valid. The urllist can be edited.
E.g. with 'o conf urllist push ftp://myurl/'

Could not fetch authors/01mailrc.txt.gz
LWP not available

Trying with "/usr/bin/wget -O -" to get
http://mirror.ibcp.fr/pub/CPAN/modul...details.txt.gz
--16:07:19-- http://mirror.ibcp.fr/pub/CPAN/modul...details.txt.gz
Resolving mirror.ibcp.fr... failed: Name or service not known.

System call "/usr/bin/wget -O - "http://mirror.ibcp.fr/pub/CPAN/modules/02packages.details.txt.gz" > /root/.cpan/sources/modules/02packages.details.txt"
returned status 1 (wstat 256)
Warning: expected file [/root/.cpan/sources/modules/02packages.details.txt.gz] doesn't exist
Please check, if the URLs I found in your configuration file
(http://mirror.ibcp.fr/pub/CPAN/) are valid. The urllist can be edited.
E.g. with 'o conf urllist push ftp://myurl/'

Could not fetch modules/02packages.details.txt.gz
LWP not available

Trying with "/usr/bin/wget -O -" to get
http://mirror.ibcp.fr/pub/CPAN/modul...odlist.data.gz
--16:07:21-- http://mirror.ibcp.fr/pub/CPAN/modul...odlist.data.gz
Resolving mirror.ibcp.fr... failed: Name or service not known.

System call "/usr/bin/wget -O - "http://mirror.ibcp.fr/pub/CPAN/modules/03modlist.data.gz" > /root/.cpan/sources/modules/03modlist.data"
returned status 1 (wstat 256)
Warning: expected file [/root/.cpan/sources/modules/03modlist.data.gz] doesn't exist
Please check, if the URLs I found in your configuration file
(http://mirror.ibcp.fr/pub/CPAN/) are valid. The urllist can be edited.
E.g. with 'o conf urllist push ftp://myurl/'

Could not fetch modules/03modlist.data.gz
Going to write /root/.cpan/Metadata
No objects found of any type for argument /DBD::mysql/

Je rencontre un problème avec l'installation des différentes modules avec yum :

Citation:

#yum install perl-DBD-MySQL.x86_64
Loaded plugins: security
Setting up Install Process
Parsing package install arguments
No package perl-DBD-MySQL.x86_64 available.
Nothing to do

Pas beaucoup d'infos sur le net qui me permettent de régler le problème. C'est l'un des paquet, si ce n'est le paquet, qui me manque pour pouvoir interagir avec la bdd.

J'ai toujours pas réussi à le faire marcher mais je cherche toujours !

Problème inexpliqué avec l'utilisation de yum.

Cependant avec apt-get install perl-DBD-mysql c'est passé.

Petite manip à faire cependant :
Dans /etc/apt/apt.conf il faut ajouter la ligne suivante :
Cache-Limit "16777216"

Et ça fonctionne !