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)
