Linux - EnterpriseThis forum is for all items relating to using Linux in the Enterprise.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
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
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
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.
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!
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.