I can't install DBD::mysql on suse linux 8.1

I got my instructions here:
http://www.perl.com/CPAN/
http://search.cpan.org/author/TIMB/D.../Bundle/DBI.pm
http://search.cpan.org/author/JWIED/...e/DBD/mysql.pm

to do this
perl -MCPAN -e 'install Bundle:BI'
perl -MCPAN -e 'install Bundle:BD::mysql'

the DBI install worked.
I got the following error when doing the DBD::mysql install


perl Makefile.PL --help
Running make test
Make had some problems, maybe interrupted? Won't test
Running make install
Make had some problems, maybe interrupted? Won't install
Running install for module DBD::mysql
Running make for J/JW/JWIED/DBD-mysql-2.1020.tar.gz
Is already unwrapped into directory /root/.cpan/build/DBD-mysql-2.1020
Makefile.PL returned status 512
Running make test
Make had some problems, maybe interrupted? Won't test
Running make install
Make had some problems, maybe interrupted? Won't install
Bundle summary: The following items in bundle Bundle:BD::mysql had
installation problems:
Mysql DBD::mysql


cheers
Scott

As you've got DBI installed try downloading http://www.cpan.org/authors/id/J/JW/...-1.2219.tar.gz then follow the usual install processes (untar, perl Makefile.pl, make, make test, make install) and see if that works. I've never had any problems with installing modules this way apart from the odd missing dependency.

cheers

Jamie...

i never had any problems yet either.
was the mysql-server running when u installed the driver?
cheers, jens
btw.. i guess it's part of your distro, take a look at yast
(named perl-msql-mysql-modules)

DBI::mysql still does not work

I tried 2 things

1.
used YaST to install perl-msql-mysql-modules and my perl script failed.

2.
perl -MCPAN -e 'install Bundle:BI'
perl -MCPAN -e 'install Bundle:BB::mysql' had a warning probably because it was already installed by yast.

this is my scrip and the error

#!/usr/bin/perl

use DBI;

$name = "scott";
print "hi $name \n";

my $dbh = DBI->connect("DBI:mysql:test","someuser","somepassword");

DBI->connect(test) failed: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2) at ./test.pl line 8


-safe_mysqld was running
-I added /usr/local/mysql/bin to my path with
export PATH=$PATH:/usr/local/mysql/bin
but when I type "which mysql" it is not in the path.

cheers
scott

1. u don't need mysql/bin inthe $PATH

my $dsn = 'DBI:mysql:test:localhost';
$dbh = DBI->connect ($dsn, $db_user_name, $db_password, {RaiseError => 1 });

that's the way i connect, so maybe u have to add the host.
or maybe u get a more detailed error message.
try 'ps -e'
to see whether there is more than 1 mysql process running
mysql.sock(2) ! should be only one
can u communicate with the mysql normally?
cheers, jens

take a look at mysql error log - might be in mysql/data/host.err

Thanks everyone for your input.

I solved it by adding
mysql_socket=/tmp/mysql.sock
to the connect script

DBI->connect("dbi:mysql:test;mysql_socket=/tmp/mysql.sock", $someruser,$somepassword);

cheers
Scott