Hello,
I am very new to the DBI module. I am trying to connect to a
mysql installation on a server over the internet, however I cannot get
the DBD::mysql driver installed properly. When I try to install via
CPAN with the command 'sudo -H cpan -i DBD::mysql' I get the error:
CPAN: Storable loaded ok (v2.18)
Going to read /var/root/.cpan/Metadata
Database was generated on Tue, 06 Apr 2010 13:34:47 GMT
CPAN: YAML loaded ok (v0.71)
Going to read /var/root/.cpan/build/
............................................................................DONE
Found 16 old builds, restored the state of 16
Running install for module 'DBD::mysql'
Running make for C/CA/CAPTTOFU/DBD-mysql-4.013.tar.gz
Has already been unwrapped into directory /var/root/.cpan/build/DBD-
mysql-4.013-CoqaqX
'/usr/bin/perl Makefile.PL' returned status 512, won't make
Running make test
Make had some problems, won't test
Running make install
Make had some problems, won't install
Has anybody encountered this and know a workaround? I could not get a
manual install to work either, although I will admit I don't have any
previous experience doing a manual install. I tried to follow the
instructions on the DBD::mysql module page have been reading this
group and searching for solutions online but nothing has worked. When
I try a manual install i get the message:
PLEASE NOTE:
For 'make test' to run properly, you must ensure that the
database user 'robertmulley' can connect to your MySQL server
and has the proper privileges that these tests require such
as 'drop table', 'create table', 'drop procedure', 'create procedure'
as well as others.
mysql> grant all privileges on test.* to 'robertmulley'@'localhost'
identified by 's3kr1t';
You can also optionally set the user to run 'make test' with:
perl Makefile.pl --testuser=username
Can't exec "mysql_config": No such file or directory at Makefile.PL
line 464.
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 464.
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 464.
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
I have MAMP installed and running. Also I don't care about connecting
to localhost, is there a way to run the drop table tests ect on a
server over the internet? Thanks.
