LinuxQuestions.org
Visit Jeremy's Blog.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
Reload this Page Can't find mysql_config file with Perl Mod install
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 06-19-2007, 12:10 PM   #1
tekmann33
Member
 
Registered: Nov 2006
Posts: 188

Rep: Reputation: 30
Can't find mysql_config file with Perl Mod install

I am running a Fedora core 6 machine and I have just installed myql-5.0.41 from source file.

I can run the mysql server with no problem and also log in as a client and do database stuff.


Now I am installing bugzilla, which requires mysql to work, and part of that process is installing a bunch of perl modules to make it work. The one problem I am having with one of them is with the following command:

Code:
/usr/bin/perl -MCPAN -e 'install DBD::mysql'
This is supposed to install the correct DBD module for the database that I am running, which is MYSQL. However, I receive the following output from this command:


Code:
root@FireCracker bugzilla-3.0]# /usr/bin/perl -MCPAN -e 'install DBD::mysql'
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
  Database was generated on Mon, 18 Jun 2007 00:09:44 GMT
Running install for module DBD::mysql
Running make for C/CA/CAPTTOFU/DBD-mysql-4.005.tar.gz
CPAN: Digest::MD5 loaded ok
CPAN: Compress::Zlib loaded ok
Checksum for /root/.cpan/sources/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.005.tar.gz ok
Scanning cache /root/.cpan/build for sizes
DBD-mysql-4.005/
DBD-mysql-4.005/ChangeLog
DBD-mysql-4.005/constants.h
DBD-mysql-4.005/dbdimp.c
DBD-mysql-4.005/dbdimp.h
DBD-mysql-4.005/eg/
DBD-mysql-4.005/eg/prepare_memory_usage.pl
DBD-mysql-4.005/eg/proc_example1.pl
DBD-mysql-4.005/eg/proc_example2.pl
DBD-mysql-4.005/eg/proc_example3.pl
DBD-mysql-4.005/INSTALL.html
DBD-mysql-4.005/lib/
DBD-mysql-4.005/lib/Bundle/
DBD-mysql-4.005/lib/Bundle/DBD/
DBD-mysql-4.005/lib/Bundle/DBD/mysql.pm
DBD-mysql-4.005/lib/DBD/
DBD-mysql-4.005/lib/DBD/mysql/
DBD-mysql-4.005/lib/DBD/mysql/GetInfo.pm
DBD-mysql-4.005/lib/DBD/mysql/INSTALL.pod
DBD-mysql-4.005/lib/DBD/mysql.pm
DBD-mysql-4.005/Makefile.PL
DBD-mysql-4.005/Makefile.PL.embedded
DBD-mysql-4.005/MANIFEST
DBD-mysql-4.005/MANIFEST.SKIP
DBD-mysql-4.005/META.yml
DBD-mysql-4.005/myld
DBD-mysql-4.005/mysql.xs
DBD-mysql-4.005/README
DBD-mysql-4.005/t/
DBD-mysql-4.005/t/00base.t
DBD-mysql-4.005/t/10connect.t
DBD-mysql-4.005/t/20createdrop.t
DBD-mysql-4.005/t/30insertfetch.t
DBD-mysql-4.005/t/35limit.t
DBD-mysql-4.005/t/35prepare.t
DBD-mysql-4.005/t/40bindparam.t
DBD-mysql-4.005/t/40bindparam2.t
DBD-mysql-4.005/t/40blobs.t
DBD-mysql-4.005/t/40catalog.t
DBD-mysql-4.005/t/40listfields.t
DBD-mysql-4.005/t/40nulls.t
DBD-mysql-4.005/t/40numrows.t
DBD-mysql-4.005/t/41bindparam.t
DBD-mysql-4.005/t/41blobs_prepare.t
DBD-mysql-4.005/t/42bindparam.t
DBD-mysql-4.005/t/50chopblanks.t
DBD-mysql-4.005/t/50commit.t
DBD-mysql-4.005/t/60leaks.t
DBD-mysql-4.005/t/70takeimp.t
DBD-mysql-4.005/t/75supported_sql.t
DBD-mysql-4.005/t/80procs.t
DBD-mysql-4.005/t/insertid.t
DBD-mysql-4.005/t/lib.pl
DBD-mysql-4.005/t/multi_statement.t
DBD-mysql-4.005/t/mysql.dbtest
DBD-mysql-4.005/t/param_values.t
DBD-mysql-4.005/t/prepare_noerror.t
DBD-mysql-4.005/t/texecute.t
DBD-mysql-4.005/t/utf8.t
DBD-mysql-4.005/TODO
Removing previously used /root/.cpan/build/DBD-mysql-4.005

  CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-4.005.tar.gz

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 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 466.
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
Running make test
  Make had some problems, maybe interrupted? Won't test
Running make install
  Make had some problems, maybe interrupted? Won't install
[root@FireCracker bugzilla-3.0]#
I noticed the message about not being able to find the myql_config file, but it is in the mysql bin directory as shown:

[
Code:
root@FireCracker bin]# pwd
/usr/local/mysql/bin
[root@FireCracker bin]# ls
comp_err           mysql              mysql_convert_table_format  mysql_fix_privilege_tables  mysqltest               perror
innochecksum       mysqlaccess        mysqld_multi                mysqlhotcopy                mysqltestmanagerc       replace
msql2mysql         mysqladmin         mysqld_safe                 mysqlimport                 mysqltestmanager-pwgen  resolveip
myisamchk          mysqlbinlog        mysqldump                   mysql_install_db            mysql_tzinfo_to_sql     resolve_stack_dump
myisam_ftdump      mysqlbug           mysqldumpslow               mysql_secure_installation   mysql_upgrade
myisamlog          mysqlcheck         mysql_explain_log           mysql_setpermission         mysql_upgrade_shell
myisampack         mysql_client_test  mysql_find_rows             mysqlshow                   mysql_waitpid
my_print_defaults  mysql_config       mysql_fix_extensions        mysql_tableinfo             mysql_zap
I then thought it might be an issue where I do not have the right development package. Rpm.pbone did not have a development package for Fedora 6 mysql, so I tried the Fedora 5 develop package for mysql, but it had a problem installing it:

Code:
 Missing Dependency: mysql = 5.0.41-1.fc5.remi is needed by package mysql-devel

I do have mysql 5.0.41 installed and running, but it wasn't from an rpm...I compiled it from source code.

Is there something I am missing? I would rather not uninstall the source code and install the rpm version of mysql if I can help it.

Any input that anyone can give me would be appreciated.
Last edited by tekmann33; 06-19-2007 at 12:13 PM.
 
Old 06-20-2007, 07:36 AM   #2
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Rocky 9.2
Posts: 18,356

Rep: Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751Reputation: 2751
Use this hint in your output:

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

to run (ie add your dir)

perl Makefile.PL --cflags=-I/usr/local/mysql/bin
 
Old 06-20-2007, 12:52 PM   #3
tekmann33
Member
 
Registered: Nov 2006
Posts: 188

Original Poster
Rep: Reputation: 30
Quote:
Originally Posted by chrism01
Use this hint in your output:

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

to run (ie add your dir)

perl Makefile.PL --cflags=-I/usr/local/mysql/bin

I had some trouble running this command. I received error output indicating that it still could not find the mysql_config file. So, I edited the .bashrc file and exported into my PATH statement the /usr/local/mysql/bin path.

That seemed to further the installation, however upon installing, the script performs a series of tests where some seemed to have failed. The output was rather long, but here are a few of them:

Code:
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base.............ok 1/5install_driver(mysql) failed: Can't load '/root/.cpan/build/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.15: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.8/i386-linux-thread-multi/DynaLoader.pm line 230.
 at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at t/00base.t line 38
t/00base.............dubious                                                 
        Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 4-5
        Failed 2/5 tests, 60.00% okay
t/10connect..........install_driver(mysql) failed: Can't load '/root/.cpan/build/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.15: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.8/i386-linux-thread-multi/DynaLoader.pm line 230.
 at (eval 5) line 3
Compilation failed in require at (eval 5) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at t/10connect.t line 25
# Looks like your test died before it could output anything.
t/10connect..........dubious                                                 
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-2
        Failed 2/2 tests, 0.00% okay
t/20createdrop.......install_driver(mysql) failed: Can't load '/root/.cpan/build/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.15: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.8/i386-linux-thread-multi/DynaLoader.pm line 230.
 at (eval 5) line 3
Compilation failed in require at (eval 5) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at t/20createdrop.t line 21
# Looks like your test died before it could output anything.
t/20createdrop.......dubious                                                 
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-4
        Failed 4/4 tests, 0.00% okay
t/30insertfetch......install_driver(mysql) failed: Can't load '/root/.cpan/build/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.15: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.8/i386-linux-thread-multi/DynaLoader.pm line 230.
 at (eval 5) line 3
Compilation failed in require at (eval 5) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at t/30insertfetch.t line 21
# Looks like your test died before it could output anything.
t/30insertfetch......dubious                                                 
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-9
        Failed 9/9 tests, 0.00% okay
t/35limit............install_driver(mysql) failed: Can't load '/root/.cpan/build/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.15: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.8/i386-linux-thread-multi/DynaLoader.pm line 230.
 at (eval 5) line 3
Compilation failed in require at (eval 5) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at t/35limit.t line 24
# Looks like your test died before it could output anything.
t/35limit............dubious                                                 
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-111
        Failed 111/111 tests, 0.00% okay
t/35prepare..........install_driver(mysql) failed: Can't load '/root/.cpan/build/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.15: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.8/i386-linux-thread-multi/DynaLoader.pm line 230.
 at (eval 5) line 3
Compilation failed in require at (eval 5) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at t/35prepare.t line 25
# Looks like your test died before it could output anything.
t/35prepare..........dubious                                                 
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-49

Here is the summary:

Code:
Test returned status 2 (wstat 512, 0x200)
Failed Test         Stat Wstat Total Fail  Failed  List of Failed
-------------------------------------------------------------------------------
t/00base.t             2   512     5    4  80.00%  4-5
t/10connect.t        255 65280     2    4 200.00%  1-2
t/20createdrop.t     255 65280     4    8 200.00%  1-4
t/30insertfetch.t    255 65280     9   18 200.00%  1-9
t/35limit.t          255 65280   111  222 200.00%  1-111
t/35prepare.t        255 65280    49   98 200.00%  1-49
t/40bindparam.t        2   512    ??   ??       %  ??
t/40bindparam2.t       2   512    13   26 200.00%  1-13
t/40blobs.t            2   512    11   22 200.00%  1-11
t/40catalog.t        255 65280    ??   ??       %  ??
t/40listfields.t       2   512    19   38 200.00%  1-19
t/40nulls.t            2   512    11   22 200.00%  1-11
t/40numrows.t          2   512    25   50 200.00%  1-25
t/41bindparam.t        2   512    11   22 200.00%  1-11
t/41blobs_prepare.t    2   512    24   48 200.00%  1-24
t/42bindparam.t        2   512    11   22 200.00%  1-11
t/50chopblanks.t       2   512    35   70 200.00%  1-35
t/50commit.t           2   512    30   60 200.00%  1-30
t/75supported_sql.t    2   512    16   32 200.00%  1-16
t/80procs.t            2   512    ??   ??       %  ??
t/insertid.t           2   512    16   32 200.00%  1-16
t/multi_statement.t  255 65280     7   14 200.00%  1-7
t/param_values.t       2   512     8   16 200.00%  1-8
t/prepare_noerror.t    2   512    ??   ??       %  ??
t/texecute.t           2   512     9   18 200.00%  1-9
t/utf8.t               2   512    ??   ??       %  ??
2 tests skipped.
Failed 26/28 test scripts, 7.14% okay. 423/426 subtests failed, 0.70% okay.
make: *** [test_dynamic] Error 2
  /usr/bin/make test -- NOT OK
Running make install
  make test had returned bad status, won't install without force
Not sure what to make of this.
 
Old 06-20-2007, 02:34 PM   #4
tekmann33
Member
 
Registered: Nov 2006
Posts: 188

Original Poster
Rep: Reputation: 30
Decided to install the DBD via yum:

yum install perl-DBD-MySQL


This seemed to work.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot find mysql_config file tekmann33 Linux - Newbie 2 12-11-2006 06:50 PM
GdkPixbuf mod install for Gtk-Perl-0.7009 for Acidrip and dvd::rip dns21 Linux - Software 5 09-28-2005 08:37 PM
How do I install the TrueCombat mod for Quake 3? Guide at site is dead can't find tu RHLinuxGUY Linux - Games 2 08-07-2005 11:54 AM
how do i install mod perl with apache2 unixmad Linux - Newbie 2 08-22-2004 12:00 PM
perl(Cwd) perl(File::Basename) perl(File::Copy) perl(strict)....What are those? Baldorg Linux - Software 1 11-09-2003 08:09 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:48 PM.

Contact Us - Advertising Info - Rules - Privacy - LQ Merchandise - Donations - Contributing Member - LQ Sitemap -
Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration