Re: Cry for DBD::mysql help

[Charlie Minow]

Andrew,

MySQL is installed (from source, using the directions at Apple's developer web site) and working: I can use the command line client easily enough. DBI seemed to install without a hitch. The perl is just the stock Apple 5.6.0 that is in 10.1.5.

Here's what I get when I do the "perl Makefile.PL" step:

perl Makefile.PL --cflags=-I'/usr/local/mysql/include/mysql' --libs=-L'/usr/local/mysql/lib/mysql'
Can't exec "mysql_config": No such file or directory at Makefile.PL line 169.
readline() on closed filehandle main::PIPE at Makefile.PL line 171.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 169.
readline() on closed filehandle main::PIPE at Makefile.PL line 171.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 169.
readline() on closed filehandle main::PIPE at Makefile.PL line 171.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 169.
readline() on closed filehandle main::PIPE at Makefile.PL line 171.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 169.
readline() on closed filehandle main::PIPE at Makefile.PL line 171.
Can't exec "mysql_config": No such file or directory at Makefile.PL line 169.
readline() on closed filehandle main::PIPE at Makefile.PL line 171.
I will use the following settings for compiling and testing:

cflags (Users choice) = -I/usr/local/mysql/include/mysql
libs (Users choice) = -L/usr/local/mysql/lib/mysql
nocatchstderr (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Using DBI 1.30 installed in /Library/Perl/darwin/auto/DBI
Writing Makefile for DBD::mysql

And when I do the actual make:

charlie% sudo make
Password:
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
LD_RUN_PATH="" /usr/bin/perl myld cc -o blib/arch/auto/DBD/mysql/mysql.bundle -bundle -flat_namespace -undefined suppress dbdimp.o mysql.o
chmod 755 blib/arch/auto/DBD/mysql/mysql.bundle
cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
Manifying blib/man3/DBD::mysql.3
Manifying blib/man3/DBD::mysql::INSTALL.3
Manifying blib/man3/Bundle::DBD::mysql.3
Manifying blib/man3/Mysql.3

Notice the line starting with "LD_RUN_PATH" where there's no path. I wonder if that's my problem, since that path is filled in when I do the same step on a Linux server.

Thanks,

charlie

On Friday, November 22, 2002, at 09:58 AM, Andrew Brosnan wrote:

On 11/22/02 at 9:45 AM, [EMAIL PROTECTED] (Charlie Minow) wrote:

Hi,

  I've tried and tried and can't get DBD::mysql to work on my
powerbook. When I try to use it in a perl script i get a bunch of

errors

that start like this:

dyld: perl Undefined symbols:
_mysql_affected_rows
_mysql_close
_mysql_create_db
_mysql_data_seek
...... and about 20 more just like these.

I'm trying to install DBD::mysql from source code on 10.1.5 (because
I think I recall that once when I used CPAN it replaced my stock Perl
install with a new version). I've been able to do this on two Linux
servers, but for some reason I can't figure out what's going on on my
laptop.

Is MySQL installed and working itself? How did you install it? (from
source?)

Which Perl are you using? The one from OS X 10.1.5 or another?

Do you have DBI installed?

This link provided some helpful info for me to get DBD::mysql going:

http://duke.usask.ca/~dalglb/macosx/