Dan and Hardy,
Thanks for the help, guys. I first tried doing it the
"right" way by trying install the rpm, but it kept asking
for libmysqlclient.so.10 when I had libmysqclient.so.12
on my system.
So, I caved in and put in the symbolic link in /tmp and
*bingo* all the tests suddenly worked.
Now, onto Apache... wish me luck...
Ron
On Fri, 2003-08-29 at 07:52, Hardy Merrill wrote:
> Dan Rowles [EMAIL PROTECTED] wrote:
> > You've got two choices :)
> >
> > 1) Create a symlink in /tmp (man ln)
> > 2) Supply the socket as an argument to the DBI->connect method, using:-
> > DBI->connect("DBD:mysql:dbname;mysql_socket=/path/to/mysql.sock","user","pass");
> >
>
> One more option would be to install the perl-DBD-MySQL rpm
> from the Red Hat Linux 9 CD's. I'm on an RHL9 system and
> run MySQL and perl DBD::mysql, and I'm able to connect and
> query with DBI :-)
>
> To install the perl-DBD-MySQL rpm from RHL9 CD's, you can
> either
> 1. put CD 1 in, and the installer should pop up. You
> need to select the right category and click "Details"
> to see perl-DBD-MySQL - select it, and the installer
> will prompt you for the right CD(s) and will
> install it. Or,
> 2. install the rpm right from the CD:
> - mount CD 1
> # cd /mnt/cdrom/RedHat/RPMS
> # ls -l *DBD*
> - if you don't see perl-DBD-MySQL listed, eject
> that CD, mount the next one, and look there
>
> - when you find it, install it by doing
>
> rpm -ivh perl-DBD-MySQL-2.1021-3.i386.rpm
>
> Note: your version number may(?) be a little
> different
>
> HTH.
> --
> Hardy Merrill
> Red Hat, Inc.
>
> > perldoc DBD::mysql should give you all the answers you need.
> >
> > Hope this helps,
> >
> > Dan
> >
> >
> >
> >
> > On Fri, 2003-08-29 at 05:06, Ron Ih wrote:
> > > Hello,
> > >
> > > I am trying to install the DBD::mysql driver on my system, but
> > > the make test keeps failing. My system:
> > >
> > > AMD Duron 1.1GHz
> > > RedHat 9 Linux
> > > MySQL 4.0.14 (installed by rpm and working OK)
> > > DBI-1.38 (installed OK)
> > >
> > > I have tried editing the /etc/my.cnf file which is shown below:
> > >
> > > [client]
> > > port=3306
> > > socket=/var/lib/mysql/mysql.sock
> > >
> > > [mysqld]
> > > port=3306
> > > socket=/var/lib/mysql/mysql.sock
> > > set-variable = key_buffer_size=16M
> > > set-variable = max_allowed_packet=1M
> > >
> > > [mysqldump]
> > > quick
> > >
> > >
> > > I have verified that indeed my MySQL server is running:
> > >
> > >
> > > [EMAIL PROTECTED] root]$ mysqladmin version
> > > mysqladmin Ver 8.40 Distrib 4.0.14, for pc-linux on i686
> > > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> > > This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> > > and you are welcome to modify and redistribute it under the GPL license
> > >
> > > Server version 4.0.14-standard
> > > Protocol version 10
> > > Connection Localhost via UNIX socket
> > > UNIX socket /var/lib/mysql/mysql.sock
> > > Uptime: 1 hour 13 min 8 sec
> > >
> > > Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1
> > > Open tables: 0 Queries per second avg: 0.000
> > > [EMAIL PROTECTED] root]$
> > >
> > >
> > > However, the make test keeps failing with the error messages shown
> > > at the bottom of this email. It keeps trying to connect to MySQL
> > > through the socket in /tmp when its in /var/lib/mysql. How do I
> > > tell the compiler to look there? I am concerned that the compiler
> > > will direct the driver to look in /tmp. The perl Makefile.PL and
> > > make seem to work OK.
> > >
> > > I am technical although admittedly not a Linux of SW expert. How
> > > do I tell the compiler to change the socket location? I've scoured
> > > the net for a week on this and haven't been able to find an answer
> > > to this. Thanks in advance!!
> > >
> > >
> > > Ron
> > >
> > >
> > > DIED. FAILED tests 1-351
> > > Failed 351/351 tests, 0.00% okay
> > > t/dbdadmin.........DBI connect('test','',...) failed: Can't connect to
> > > local MySQL server through socket '/tmp/mysql.sock' (2) at t/dbdadmin.t
> > > line 74
> > > Cannot connect: Can't connect to local MySQL server through socket
> > > '/tmp/mysql.sock' (2)
> > > Either your server is not up and running or you have no
> > > permissions for acessing the DSN DBI:mysql:test.
> > > This test requires a running server and write permissions.
> > > Please make sure your server is running and you have
> > > permissions, then retry.
> > > t/dbdadmin.........dubious
> > > Test returned status 10 (wstat 2560, 0xa00)
> > > DIED. FAILED tests 1-21
> > > Failed 21/21 tests, 0.00% okay
> > > t/insertid.........DBI connect('test','',...) failed: Can't connect to
> > > local MySQL server through socket '/tmp/mysql.sock' (2) at t/insertid.t
> > > line 13
> > > t/insertid.........dubious
> > > Test returned status 255 (wstat 65280, 0xff00)
> > > DIED. FAILED tests 1-12
> > > Failed 12/12 tests, 0.00% okay
> > > t/mysql............Mysql connect('database=test;host=','',...) failed:
> > > Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
> > > at t/mysql.t line 55
> > > not ok 1: Can't connect to local MySQL server through socket
> > > '/tmp/mysql.sock' (2)
> > > It looks as if your server is not up and running.
> > > This test requires a running server.
> > > Please make sure your server is running and retry.
> > >
> > > [...] (further errors truncated)
> > >
> > >
