Mac Forum / Programming / Perl / September 2007

All,
I attempted to install DBD::MySQL from the CPAN repositories. I  
received a ton of errors seen below:

Can't exec "mysql_config": No such file or directory at Makefile.PL  
line 76.

Cannot find the file 'mysql_config'! Your execution PATH doesn't seem
not contain the path to mysql_config. Resorting to guessed values!
Can't exec "mysql_config": No such file or directory at Makefile.PL  
line 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL  
line 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL  
line 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL  
line 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL  
line 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL  
line 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL  
line 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL  
line 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL  
line 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL  
line 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL  
line 466.
Can't exec "mysql_config": No such file or directory at Makefile.PL  
line 466.
I will use the following settings for compiling and testing:

cc -c  -I/Library/Perl/5.8.6/darwin-thread-multi-2level/auto/DBI -I/
usr/local/mysql/include -DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -g -pipe -
fno-common -DPERL_DARWIN -no-cpp-precomp -fno-strict-aliasing -I/usr/
local/include -Os   -DVERSION=\"4.005\" -DXS_VERSION=\"4.005\"  "-I/
System/Library/Perl/5.8.6/darwin-thread-multi-2level/CORE"   dbdimp.c
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" /Library/Perl/5.8.6/darwin-
thread-multi-2level/auto/DBI/Driver.xst > mysql.xsi
/usr/bin/perl /System/Library/Perl/5.8.6/ExtUtils/xsubpp  -typemap /
System/Library/Perl/5.8.6/ExtUtils/typemap  mysql.xs > mysql.xsc &&  
mv mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs,  
line 225
Warning: duplicate function definition 'rows' detected in mysql.xs,  
line 612
cc -c  -I/Library/Perl/5.8.6/darwin-thread-multi-2level/auto/DBI -I/
usr/local/mysql/include -DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -g -pipe -
fno-common -DPERL_DARWIN -no-cpp-precomp -fno-strict-aliasing -I/usr/
local/include -Os   -DVERSION=\"4.005\" -DXS_VERSION=\"4.005\"  "-I/
System/Library/Perl/5.8.6/darwin-thread-multi-2level/CORE"   mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs

        Test returned status 255 (wstat 65280, 0xff00)
Failed Test         Stat Wstat Total Fail  Failed  List of Failed
------------------------------------------------------------------------
-------
t/00base.t           255 65280     5    4  80.00%  4-5
t/10connect.t        255 65280     2    4 200.00%  1-2
t/20createdrop.t     255 65280     4    8 200.00%  1-4
t/30insertfetch.t    255 65280     9   18 200.00%  1-9
t/35limit.t          255 65280   111  222 200.00%  1-111
t/35prepare.t        255 65280    49   98 200.00%  1-49
t/40bindparam.t      255 65280    ??   ??       %  ??
t/40bindparam2.t     255 65280    13   26 200.00%  1-13
t/40blobs.t          255 65280    11   22 200.00%  1-11
t/40catalog.t        255 65280    ??   ??       %  ??
t/40listfields.t     255 65280    19   38 200.00%  1-19
t/40nulls.t          255 65280    11   22 200.00%  1-11
t/40numrows.t        255 65280    25   50 200.00%  1-25
t/41bindparam.t      255 65280    11   22 200.00%  1-11
t/41blobs_prepare.t  255 65280    24   48 200.00%  1-24
t/42bindparam.t      255 65280    11   22 200.00%  1-11
t/50chopblanks.t     255 65280    35   70 200.00%  1-35
t/50commit.t         255 65280    30   60 200.00%  1-30
t/75supported_sql.t  255 65280    16   32 200.00%  1-16
t/80procs.t          255 65280    ??   ??       %  ??
t/insertid.t         255 65280    16   32 200.00%  1-16
t/multi_statement.t  255 65280     7   14 200.00%  1-7
t/param_values.t     255 65280     8   16 200.00%  1-8
t/prepare_noerror.t  255 65280    ??   ??       %  ??
t/texecute.t         255 65280     9   18 200.00%  1-9
t/utf8.t             255 65280    ??   ??       %  ??
2 tests skipped.
Failed 26/28 test scripts, 7.14% okay. 423/426 subtests failed, 0.70%  
okay.
make: *** [test_dynamic] Error 2
  /usr/bin/make test -- NOT OK

su: mysql_config: command not found

The install failed along with nearly 100% of the test failing. I am  
running Mac OS X 10.4.10 on a PowerBook G4 with Perl 5.8.6 installed,  
and MySQL 5.0.45.

Any help would be greatly appreciated! Thanks in advanace...

Tony Armstrong
anthony.o.armstrong@gmail.com

"I love a liar, but hate a cheater" -- (c) Ari Gold Entourage