DBD-mysql-2.9003 Installation Issues

--=====================_34464266==.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed

Hello:

I have been trying to get DBD-mysql-2.9003 installed without success. Any
suggestions are welcomed. The specifics of my install are as follows:

Solaris 9 --- using gcc-3.2.1

perl-5.8.0 --- with threading support
./Configure --- accepted all defaults except for gcc as compiler &
thread support

mysql-3.23.58
CC=gcc ./configure --prefix=/usr/local/mysql --without-server
make
make install

**** have tried both source and binary versions of mysql with the same
results ****

mysql-standard-4.0.20-sun-solaris2.9-sparc
simply unpacked binary in /usr/local and linked to /usr/local/mysql

DBI-1.42
perl Makefile.PL
make
make install
removed working directory

DBD-mysql-2.9003
perl Makefile.PL
make
make install

**** Everything installs successfully, no errors. ****

Output of crle:

Configuration file [3]: /var/ld/ld.config
Default Library Path
(ELF): /usr/lib:/usr/local/lib:/usr/local/mysql/lib:/usr/local/ssl/ lib
Trusted Directories (ELF): /usr/lib/secure (system default)

Command line:
crle -c /var/ld/ld.config -l
/usr/lib:/usr/local/lib:/usr/local/mysql/lib:/usr/local/ssl/ lib

When I try to run a script I get the following error:

# perl mysql_test.pl
install_driver(mysql) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris-thread-mu lti/auto/DBD/mysql/mysql.so'
for module DBD::mysql: ld.so.1: perl: fatal: relocation error: file
/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris-thread-mul ti/auto/DBD/mysql/mysql.so:
symbol net_buffer_length: referenced symbol not found at
/usr/local/lib/perl5/5.8.0/sun4-solaris-thread-multi/DynaLoa der.pm line 229.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at mysql_test.pl line 12

# more mysql_test.pl
#!/usr/bin/perl -w

use DBI;
use threads;

$username = 'user';
$auth = 'password';
$db_name = 'database=bvstats;host=server.domain.net';
$i=0;

## OPEN DB CONNECTION
$dbh = DBI->connect("DBI:mysql:$db_name", $username, $auth)
or &db_error_connect(DBI->errstr);


$query = qq(SELECT id, ip FROM users WHERE ip != '' LIMIT 5);
$sth = $dbh->prepare($query) || &db_error_prep($sth->errstr);
$sth->execute || &db_error_exec($sth->errstr);
my @data;
while (@data = $sth->fetchrow_array())
{
if($sth->err)
{
print "There was a fetchrow error: $sth->errstr";
}

$userinfo[$i] = $data[0];
$user_ip[$i] = $data[1];
$i++;

print qq($i: $userinfo[$i] | $user_ip[$i] \n);
}

$sth->finish;



Thanks,

Lauri-

~~~~~~~~~~~~~~~~~~~~~~~
Lauri Bettencourt
UNIX System Administrator
lbetten@wn.net
~~~~~~~~~~~~~~~~~~~~~~~
--=====================_34464266==.ALT--