LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Enterprise Linux Forums > Linux - Enterprise
User Name
Password
Linux - Enterprise This forum is for all items relating to using Linux in the Enterprise.

Notices


Reply
  Search this Thread
Old 05-27-2008, 03:41 PM   #1
Newbie0520
LQ Newbie
 
Registered: May 2008
Posts: 8

Rep: Reputation: 0
Question Can't exec mysql_config


hi,

I am running SuSE 9 and am trying to install DBD::mysql using MCPAN. These are the errors I get:

Can't exec "mysql_config": No such file or directory at Makefile.PL line 466.
Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located
Can't exec "mysql_config": No such file or directory at Makefile.PL line 466.
Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located
Can't exec "mysql_config": No such file or directory at Makefile.PL line 466.
Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located
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
Warning: No success on command[/usr/bin/perl Makefile.PL]
CAPTTOFU/DBD-mysql-4.007.tar.gz
/usr/bin/perl Makefile.PL -- NOT OK
Failed during this command:
CAPTTOFU/DBD-mysql-4.007.tar.gz : writemakefile NO '/usr/bin/perl Makefile.PL' returned status 512

Any help will be appreciated.
 
Old 05-27-2008, 04:05 PM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 20,713

Rep: Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091
The error message tells you that you don't have mysql-config installed. Have you tried installing mysql-config? That's in the mysql-devel packages, which you need before compiling things that depend on mysql.
 
Old 05-28-2008, 10:35 AM   #3
Newbie0520
LQ Newbie
 
Registered: May 2008
Posts: 8

Original Poster
Rep: Reputation: 0
Thanks TBone, I installed the MySQL-devel-standard and now was able to "make" but now I am getting an error at the testing phase. I set up a user called logicom but still complaining.
This is the error log I get:

PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base....................ok
t/10connect.................skipped
all skipped: ERROR: Access denied for user 'logicom'@'localhost' (using password: NO) Can't continue test
t/20createdrop..............skipped
all skipped: ERROR: Access denied for user 'logicom'@'localhost' (using password: NO). Can't continue test
t/25lockunlock..............skipped
all skipped: Can't connect to database ERROR: Access denied for user 'logicom'@'localhost' (using password: NO). Can't continue test
t/29warnings................skipped
all skipped: ERROR: DBI connect('test','logicom',...) failed: Access denied for user 'logicom'@'localhost' (using password: NO) at t/29warnings.t line 15
t/30insertfetch.............skipped
all skipped: ERROR: Access denied for user 'logicom'@'localhost' (using password: NO). Can't continue test
t/31insertid................skipped
all skipped: ERROR: Access denied for user 'logicom'@'localhost' (using password: NO). Can't continue test
t/32insert_error............skipped
all skipped: ERROR: DBI connect('test','logicom',...) failed: Access denied for user 'logicom'@'localhost' (using password: NO) at t/32insert_error.t line 17
t/35limit...................skipped
all skipped: ERROR: DBI connect('test','logicom',...) failed: Access denied for user 'logicom'@'localhost' (using password: NO) at t/35limit.t line 18
t/35prepare.................skipped
all skipped: Can't connect to database ERROR: Access denied for user 'logicom'@'localhost' (using password: NO). Can't continue test
t/40bindparam...............skipped
all skipped: ERROR: Access denied for user 'logicom'@'localhost' (using password: NO). Can't continue test
t/40bindparam2..............skipped
all skipped: ERROR: Access denied for user 'logicom'@'localhost' (using password: NO). Can't continue test
t/40blobs...................skipped
all skipped: ERROR: Access denied for user 'logicom'@'localhost' (using password: NO). Can't continue test
t/40catalog.................skipped
all skipped: ERROR: Access denied for user 'logicom'@'localhost' (using password: NO). Can't continue test
t/40keyinfo.................skipped
all skipped: ERROR: Access denied for user 'logicom'@'localhost' (using password: NO). Can't continue test
t/40listfields..............skipped
all skipped: ERROR: Access denied for user 'logicom'@'localhost' (using password: NO). Can't continue test
t/40nulls...................skipped
all skipped: ERROR: Access denied for user 'logicom'@'localhost' (using password: NO). Can't continue test
t/40numrows.................skipped
all skipped: ERROR: Access denied for user 'logicom'@'localhost' (using password: NO). Can't continue test
t/40server_prepare..........skipped
all skipped: ERROR: DBI connect('test;mysql_server_prepare=1','logicom',...) failed: Access denied for user 'logicom'@'localhost' (using password: NO) at t/40server_prepare.t line 16
t/40server_prepare_error....skipped
all skipped: ERROR: DBI connect('test;mysql_server_prepare=1','logicom',...) failed: Access denied for user 'logicom'@'localhost' (using password: NO) at t/40server_prepare_error.t line 18
t/40types...................skipped
all skipped: ERROR: Access denied for user 'logicom'@'localhost' (using password: NO). Can't continue test
t/41bindparam...............skipped
all skipped: ERROR: Access denied for user 'logicom'@'localhost' (using password: NO). Can't continue test
t/41blobs_prepare...........skipped
all skipped: ERROR: Access denied for user 'logicom'@'localhost' (using password: NO). Can't continue test
t/42bindparam...............skipped
all skipped: ERROR: DBI connect('test','logicom',...) failed: Access denied for user 'logicom'@'localhost' (using password: NO) at t/42bindparam.t line 13
t/50chopblanks..............skipped
all skipped: ERROR: Access denied for user 'logicom'@'localhost' (using password: NO). Can't continue test
t/50commit..................skipped
all skipped: ERROR: Access denied for user 'logicom'@'localhost' (using password: NO). Can't continue test
t/55utf8....................skipped
all skipped: ERROR: DBI connect('test','logicom',...) failed: Access denied for user 'logicom'@'localhost' (using password: NO) at t/55utf8.t line 18
t/60leaks...................skipped
all skipped: Skip $ENV{SLOW_TESTS} is not set
t/65types...................skipped
all skipped: ERROR: DBI connect('test','logicom',...) failed: Access denied for user 'logicom'@'localhost' (using password: NO) at t/65types.t line 13
t/70takeimp.................skipped
all skipped: Can't connect to database ERROR: DBI connect('test','logicom',...) failed: Access denied for user 'logicom'@'localhost' (using password: NO) at t/70takeimp.t line 27
t/71impdata.................DBI connect('test','logicom',...) failed: Access denied for user 'logicom'@'localhost' (using password: NO) at t/71impdata.t line 14
skipped
all skipped: Can't obtain driver handle. Can't continue test
t/75supported_sql...........skipped
all skipped: ERROR: Access denied for user 'logicom'@'localhost' (using password: NO). Can't continue test
t/76multi_statement.........skipped
all skipped: ERROR: DBI connect('test','logicom',...) failed: Access denied for user 'logicom'@'localhost' (using password: NO) at t/76multi_statement.t line 15
t/80procs...................skipped
all skipped: ERROR: Access denied for user 'logicom'@'localhost' (using password: NO). Can't continue test
All tests successful, 33 tests skipped.
Files=34, Tests=6, 3 wallclock secs ( 2.60 cusr + 0.38 csys = 2.98 CPU)
CAPTTOFU/DBD-mysql-4.007.tar.gz
/usr/bin/make test -- OK
 
Old 05-28-2008, 11:07 AM   #4
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 20,713

Rep: Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091Reputation: 5091
Quote:
Originally Posted by Newbie0520 View Post
Thanks TBone, I installed the MySQL-devel-standard and now was able to "make" but now I am getting an error at the testing phase. I set up a user called logicom but still complaining.
This is the error log I get:

PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base....................ok
t/10connect.................skipped
all skipped: ERROR: Access denied for user 'logicom'@'localhost' (using password: NO) Can't continue test
...
...
...
All tests successful, 33 tests skipped.
Files=34, Tests=6, 3 wallclock secs ( 2.60 cusr + 0.38 csys = 2.98 CPU)

CAPTTOFU/DBD-mysql-4.007.tar.gz
/usr/bin/make test -- OK
The user you created was in Linux, not in the database, right? The 'logicom'@'localhost' is because the logicom user isn't created in MySQL.

The bottom line that says "/usr/bin/make test -- OK", tells you that things worked, and you're ready to go. The tests it skipped are verification pieces for the module.
 
Old 05-28-2008, 02:14 PM   #5
Newbie0520
LQ Newbie
 
Registered: May 2008
Posts: 8

Original Poster
Rep: Reputation: 0
Hi TBOne,

Thanks for all the help you are a life saver. I did set up the logicom user in MySQL but for some reason it was not connecting to do the testing. But the important thing is you were right everything was good and it installed with not problems and all the connections from my CGI scripts worked!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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
Can't find mysql_config file with Perl Mod install tekmann33 Linux - Software 3 06-20-2007 03:34 PM
exec {} \; ddaas Linux - General 3 02-05-2007 10:02 AM
Cannot find mysql_config file tekmann33 Linux - Newbie 2 12-11-2006 07:50 PM
exec cmd=perl... work but exec cgi doenst crions Slackware 5 12-09-2005 01:17 PM
Quick question, installing mysql_config shosterman Linux - Newbie 0 01-19-2004 07:50 PM

LinuxQuestions.org > Forums > Enterprise Linux Forums > Linux - Enterprise

All times are GMT -5. The time now is 05:46 AM.

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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration