I wanted to build an awesome place for people to discuss module specific issues, but I don't have any more time for this, and there are much better places to discuss Perl-related issues. I'd recommend asking your question on Stack Overflow or on Perl Monks.
If you are looking for a Perl tutorial or Perl-related news, I hope these links will serve you well.
Posted on 2009-07-06 14:14:00-07 by stephenmcgowan
Yep you guessed! Install problems with DBD::MySQL
I've been reading through similar threads on this topic, but can't seem to see answers to these threads, only questions, which is why i'm posting my question in a hope that somebody can help me out with this. :)

Ok so from what it looks like, i'm erroring with the libs and cflags directories. I'm aware this is a common issue, so hopefully i can be put on the right track with this.

I'll link my code below:

cpan> install DBD::mysql CPAN: Storable loaded ok Going to read /Users/stevey_mac2k2/.cpan/Metadata Database was generated on Sun, 05 Jul 2009 21:26:57 GMT Running install for module DBD::mysql Running make for C/CA/CAPTTOFU/DBD-mysql-4.012.tar.gz CPAN: Digest::MD5 loaded ok CPAN: Compress::Zlib loaded ok Checksum for /Users/stevey_mac2k2/.cpan/sources/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.012.tar.gz ok Scanning cache /Users/stevey_mac2k2/.cpan/build for sizes DBD-mysql-4.012/ DBD-mysql-4.012/ChangeLog DBD-mysql-4.012/constants.h DBD-mysql-4.012/dbdimp.c DBD-mysql-4.012/dbdimp.h DBD-mysql-4.012/eg/ DBD-mysql-4.012/eg/._bug14979.pl DBD-mysql-4.012/eg/bug14979.pl DBD-mysql-4.012/eg/._bug21028.pl DBD-mysql-4.012/eg/bug21028.pl DBD-mysql-4.012/eg/bug30033.pl DBD-mysql-4.012/eg/bug30033pg.pl DBD-mysql-4.012/eg/decimal_test.pl DBD-mysql-4.012/eg/issue21946.pl DBD-mysql-4.012/eg/prepare_memory_usage.pl DBD-mysql-4.012/eg/proc_example1.pl DBD-mysql-4.012/eg/proc_example2.pl DBD-mysql-4.012/eg/proc_example2a.pl DBD-mysql-4.012/eg/proc_example2b.pl DBD-mysql-4.012/eg/proc_example3.pl DBD-mysql-4.012/eg/proc_example4.pl DBD-mysql-4.012/INSTALL.html DBD-mysql-4.012/lib/ DBD-mysql-4.012/lib/Bundle/ DBD-mysql-4.012/lib/Bundle/DBD/ DBD-mysql-4.012/lib/Bundle/DBD/mysql.pm DBD-mysql-4.012/lib/DBD/ DBD-mysql-4.012/lib/DBD/mysql/ DBD-mysql-4.012/lib/DBD/mysql/GetInfo.pm DBD-mysql-4.012/lib/DBD/mysql/INSTALL.pod DBD-mysql-4.012/lib/DBD/mysql.pm DBD-mysql-4.012/Makefile.PL DBD-mysql-4.012/Makefile.PL.embedded DBD-mysql-4.012/MANIFEST DBD-mysql-4.012/MANIFEST.SKIP DBD-mysql-4.012/META.yml DBD-mysql-4.012/myld DBD-mysql-4.012/mysql.xs DBD-mysql-4.012/README DBD-mysql-4.012/t/ DBD-mysql-4.012/t/00base.t DBD-mysql-4.012/t/10connect.t DBD-mysql-4.012/t/20createdrop.t DBD-mysql-4.012/t/25lockunlock.t DBD-mysql-4.012/t/29warnings.t DBD-mysql-4.012/t/30insertfetch.t DBD-mysql-4.012/t/31insertid.t DBD-mysql-4.012/t/32insert_error.t DBD-mysql-4.012/t/35limit.t DBD-mysql-4.012/t/35prepare.t DBD-mysql-4.012/t/40bindparam.t DBD-mysql-4.012/t/40bindparam2.t DBD-mysql-4.012/t/40blobs.t DBD-mysql-4.012/t/40catalog.t DBD-mysql-4.012/t/40keyinfo.t DBD-mysql-4.012/t/40listfields.t DBD-mysql-4.012/t/40nulls.t DBD-mysql-4.012/t/40numrows.t DBD-mysql-4.012/t/40server_prepare.t DBD-mysql-4.012/t/40server_prepare_error.t DBD-mysql-4.012/t/40types.t DBD-mysql-4.012/t/41bindparam.t DBD-mysql-4.012/t/41blobs_prepare.t DBD-mysql-4.012/t/42bindparam.t DBD-mysql-4.012/t/50chopblanks.t DBD-mysql-4.012/t/50commit.t DBD-mysql-4.012/t/51bind_type_guessing.t DBD-mysql-4.012/t/55utf8.t DBD-mysql-4.012/t/60leaks.t DBD-mysql-4.012/t/65types.t DBD-mysql-4.012/t/70takeimp.t DBD-mysql-4.012/t/71impdata.t DBD-mysql-4.012/t/75supported_sql.t DBD-mysql-4.012/t/76multi_statement.t DBD-mysql-4.012/t/80procs.t DBD-mysql-4.012/t/lib.pl DBD-mysql-4.012/t/mysql.dbtest DBD-mysql-4.012/t/mysql.mtest DBD-mysql-4.012/TODO Removing previously used /Users/stevey_mac2k2/.cpan/build/DBD-mysql-4.012 CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-4.012.tar.gz PLEASE NOTE: For 'make test' to run properly, you must ensure that the database user 'root' 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 'root'@'localhost' identified by 's3kr1t'; You can also optionally set the user to run 'make test' with: perl Makefile.pl --testuser=username I will use the following settings for compiling and testing: cflags (mysql_config) = -I/usr/local/mysql/include -g -Os -arch i386 -fno-common -D_P10 +03_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT -DDONT_DE +CLARE_CXA_PURE_VIRTUAL embedded (mysql_config) = libs (mysql_config) = -L/usr/local/mysql/lib -lmysqlclient -lz -lm -lmygcc mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 0 testdb (default ) = test testhost (default ) = testpassword (default ) = testsocket (default ) = testuser (guessed ) = root To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Checking if your kit is complete... Looks good Using DBI 1.609 (for perl 5.008008 on darwin-thread-multi-2level) installed in /Library/Perl/5.8.8/ +darwin-thread-multi-2level/auto/DBI/ Writing Makefile for DBD::mysql -- NOT OK Running make test Can't test without successful make Running make install make had returned bad status, install seems impossible


Thanks
Stephen
Direct Responses: Write a response