Hi,
I have mysql server running on RedHat 7, and I can access it directly by
typing 'mysql' and I can use the test database, as any user. I can confirm
that the database is running, and I can connect to it.
I installed DBI-1.14 and Data-ShowTable-3.3. Then with
Msql-Mysql-modules-1.2215, I ran
perl Makefile.PL
make
make test
The test failed all the way through because it couldn't connect. The
following is the type of error I got.
t/10dsnlist.........DBI->connect(database=test) failed: Can't connect to
local M
ySQL server through socket '/tmp/mysql.sock' (111) at t/10dsnlist.t line 45
Cannot connect: Can't connect to local MySQL server through socket
'/tmp/mysql.s
ock' (111)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:database=test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
If I I'm at my wits end as to what I should try next.
Thanks so much for your help,
Dan
p.s.
Some of the RPMs I have installed:
perl-5.6.0-9
make-3.79.1-5
kernel-headers-2.4.0-0.26
glibc-2.1.92-14
glibc-devel-2.1.92-14
MySQL-3.23.30-1
MySQL-client-3.23.30-1
MySQL-devel-3.23.30-1
I wrote a perl script,
use DBI;
my @drivers = DBI->available_drivers;
print join("\n",@drivers);
and mysql is listed as one of the available drivers.