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");
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)
>
>
