Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Had mysql working underl Mac OS 10.2; just upgraded to 10.3, mysql still works from command line. 10.3 comes with Perl 5.8.1. CPAN worked with the "install Bundle::CPAN" command. Worked on "install DBI", but fails with "install DBD::mysql", which is essential to get this system up an running for in house production/testing of Perl-based web applications.

Any ideas/advice? Here's what CPAN says. this may be obvious enough, but i'm not an expert on editing install files.. 

/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" /Library/Perl/5.8.1/darwin-th
+read-multi-2level/auto/DBI/Driver.xst > mysql.xsi<br />
/usr/bin/perl /System/Library/Perl/5.8.1/ExtUtils/xsubpp  -typemap /Sy
+stem/Library/Perl/5.8.1/ExtUtils/typemap  mysql.xs > mysql.xsc && mv 
+mysql.xsc mysql.c<br />
Warning: duplicate function definition 'do' detected in mysql.xs, line
+ 192<br />
Warning: duplicate function definition 'rows' detected in mysql.xs, li
+ne 290<br />
cc -c  -I/Library/Perl/5.8.1/darwin-thread-multi-2level/auto/DBI -I/us
+r/local/mysql/include -O3 -fno-omit-frame-pointer -g -pipe -pipe -fno
+-common -DPERL_DARWIN -no-cpp-precomp -fno-strict-aliasing -I/usr/loc
+al/include -Os   -DVERSION=\"2.9003\" -DXS_VERSION=\"2.9003\"  "-I/Sy
+stem/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE"   mysql.c
rm -f blib/arch/auto/DBD/mysql/mysql.bundle
LD_RUN_PATH="/usr/lib" /usr/bin/perl myld MACOSX_DEPLOYMENT_TARGET=10.
+3 cc  -bundle -undefined dynamic_lookup -L/usr/local/lib dbdimp.o mys
+ql.o  -o blib/arch/auto/DBD/mysql/mysql.bundle   -L/usr/local/mysql/l
+ib -lmysqlclient -lz -lm   
make: *** [blib/arch/auto/DBD/mysql/mysql.bundle] Error 1
  /usr/bin/make -j3 -- NOT OK

[download]

edited: Wed Nov 5 23:47:22 2003 by jeffa - code tags

Replies are listed 'Best First'.
Re: Can't Install DBD::mysql
by CountZero (Bishop) on Nov 06, 2003 at 07:38 UTC
    There is a "Pure Perl" driver for MySQL here. If all else fails, you can try to use that, although the performance is not as good as the "normal" DBD.

    CountZero

    "If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law

[reply]
Re: Can't Install DBD::mysql
by graff (Chancellor) on Nov 06, 2003 at 06:09 UTC
    Based on what you've posted, it's not at all clear to me what could be causing the problem. (Perhaps you've left some stuff out?)

    If it's the case that you're getting reports about not being able to pass tests during the installation process, this can happen if you've assigned a password for the mysql root user account (as per the recommendations in the mysql installation), but forgot to provide the password when starting up the DBD::mysql installation. In this case, the tests fail because the "make test" portion of the install can't connect to the mysql server. (Of course, this also assumes that the mysql daemons are actually running when you install DBD.)

    I apologize for being a little foggy on the exact manner for specifying the connection info, but the module docs and/or other monks should be able to help, if that's the problem.

[reply]
Re: Can't Install DBD::mysql
by tantarbobus (Hermit) on Nov 06, 2003 at 22:49 UTC
[reply]

Back to Seekers of Perl Wisdom