From: John Lathrop
Date: March 13 1999 5:02pm
Subject: Stuck Again...frustrated...DBD:mysql
List-Archive: http://lists.mysql.com/perl/3
Message-Id: <001c01be6d73$3c54a740$5ede3ece@default>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Here I am...stuck again....

I'm trying to access a database using DBD::mysql on my internet provider's
system running FreeBSD 2.2-980222-SNAP.  I was able to get all of the
necessary modules installed and test (with great difficulty but it finally
happened).

This is the first simple test program I tried looking like this:

    use lib '/domains/johnlathrop.com/local_lib/lib/perl5/site_perl';
    use strict;
    use DBI;

    my $dbh = DBI->connect('DBI:mysql:test',<username>,<password>) || die
"Database connection not made...";

    $dbh->disconnect();


I have tried running it in perl several ways:

    /usr/local/bin/perl test.pl
    /usr/local/bin/perl test.pl --static --config
    /usr/local/bin/perl test.pl --static
    /usr/local/bin/perl test.pl -static -config
    /usr/local/bin/perl test.pl -static

I always get a familiar looking error like this:

install_driver(mysql) failed: Can't load
'/domains/johnlathrop.com/local_lib/lib
/perl5/site_perl/i386-freebsd/auto/DBD/mysql/mysql.so' for module
DBD::mysql: Can't find shared library "libmysqlclient.so.6.0" at
/usr/local/lib/perl5/i386-freebsd/5.00401/DynaLoader.pm line 155.

 at (eval 1) line 2

 at test.pl line 8


Some information in the mail archives suggested to add links to the
libmysqlclient.so.6.0 file.  I've added links all over the place.  None of
the links that I added worked.

If I could just get this to work with someone's help... :-(