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)
> >
> >
--
Hardy Merrill
Red Hat, Inc.
