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.

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.

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

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.

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!