Hello Gurus,
I have installed
MySQL-3.23.44-1.i386.rpm
MySQL-client-3.23.44-1.i386.rpm
and
DBI-1.20.tar.gz
Data-ShowTable-3.3.tar.gz
and when I trying to install the
Msql-Mysql-modules-1.2219 getting following error :.'/tmp/mysql.sock' (111)
When I checked
%mysqladmin variables
mysql.sock is running in /var/lib/mysql/mysql.sock
.....
| socket | /var/lib/mysql/mysql.sock|
| sort_buffer | 2097144|
| sql_mode |0 |
| table_cache | 64|
| table_type | MYISAM|
| thread_cache_size | 0 |
| thread_stack | 65536|
| transaction_isolation | READ-COMMITTED|
| timezone | IST |
| tmp_table_size | 33554432|
| tmpdir | /tmp/
|
| version | 3.23.44 |
| wait_timeout | 28800
+-----------------------------------------------------------------------------
[root@qclinux Msql-Mysql-modules-1.2219]# perl Makefile.PL
Which drivers do you want to install?
1) MySQL only
2) mSQL only (either of mSQL 1 or mSQL 2)
3) MySQL and mSQL (either of mSQL 1 or mSQL 2)
4) mSQL 1 and mSQL 2
5) MySQL, mSQL 1 and mSQL 2
Enter the appropriate number: [3] 1
Do you want to install the MysqlPerl emulation? You might keep your old
Mysql module (to be distinguished from DBD::mysql!) if you are concerned
about compatibility to existing applications! [y] n
Where is your MySQL installed? Please tell me the directory that
contains the subdir 'include'. [/usr/local]
Which database should I use for testing the MySQL drivers? [test]
On which host is database test running (hostname, ip address
or host:port) [localhost]
User name for connecting to database test? [undef]
Password for connecting to database test? [undef]
Creating files for MySQL ....................
Checking if your kit is complete...
Looks good
Note (probably harmless): No library found for -lgz
Using DBI 1.20 installed in /usr/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
Writing Makefile for DBD::mysql
Writing Makefile for Msql-Mysql-modules
[root@qclinux Msql-Mysql-modules-1.2219]# make
/usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.1/i686-linux \
-I/usr/lib/perl5/5.6.1 -Ilib -MExtUtils::PerlPP \
-e ppp "dbd/dbimon.in" "dbimon" "lib/DBD/mysql/Install/Config.pm"
/usr/bin/pod2text mysql/lib/DBD/mysql.pm >README
make[1]: Entering directory `/soft/mysql/Msql-Mysql-modules-1.2219/mysql'
cp lib/DBD/mysql.pm ../blib/lib/DBD/mysql.pm
cp lib/Bundle/DBD/mysql.pm ../blib/lib/Bundle/DBD/mysql.pm
cp lib/Mysql/Statement.pm ../blib/lib/Mysql/Statement.pm
cp lib/Mysql.pm ../blib/lib/Mysql.pm
cc -c -I/usr/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI -I/usr/local/include/mysql
-I../dbd -I/usr/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
-I/usr/lib/perl5/5.6.1/i686-linux -fno-strict-aliasing -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"2.0419\"
-DXS_VERSION=\"2.0419\" -fpic -I/usr/lib/perl5/5.6.1/i686-linux/CORE -DDBD_MYSQL
dbdimp.c
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" <
/usr/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI/Driver.xst > mysql.xsi
/usr/bin/perl -I/usr/lib/perl5/5.6.1/i686-linux -I/usr/lib/perl5/5.6.1
/usr/lib/perl5/5.6.1/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.6.1/ExtUtils/typemap
mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'rows' detected in mysql.xs, line 407
cc -c -I/usr/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI -I/usr/local/include/mysql
-I../dbd -I/usr/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI
-I/usr/lib/perl5/5.6.1/i686-linux -fno-strict-aliasing -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"2.0419\"
-DXS_VERSION=\"2.0419\" -fpic -I/usr/lib/perl5/5.6.1/i686-linux/CORE -DDBD_MYSQL
mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f ../blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/local/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66"
cc -shared -L/usr/local/lib dbdimp.o mysql.o -L/usr/local/lib/mysql -o
../blib/arch/auto/DBD/mysql/mysql.so -L/usr/local/lib/mysql -lmysqlclient -lm -lz
-L/usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66 -lgcc
chmod 755 ../blib/arch/auto/DBD/mysql/mysql.so
cp mysql.bs ../blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 ../blib/arch/auto/DBD/mysql/mysql.bs
Manifying ../blib/man3/DBD::mysql.3
Manifying ../blib/man3/Bundle::DBD::mysql.3
Manifying ../blib/man3/Mysql.3
make[1]: Leaving directory `/soft/mysql/Msql-Mysql-modules-1.2219/mysql'
cp dbimon blib/script/dbimon
/usr/bin/perl -I/usr/lib/perl5/5.6.1/i686-linux -I/usr/lib/perl5/5.6.1
-MExtUtils::MakeMaker -e "MY->fixin(shift)" blib/script/dbimon
Manifying blib/man1/dbimon.1
I am testing with <make test >
[root@qclinux Msql-Mysql-modules-1.2219]# make test
make[1]: Entering directory `/soft/mysql/Msql-Mysql-modules-1.2219/mysql'
make[1]: Leaving directory `/soft/mysql/Msql-Mysql-modules-1.2219/mysql'
make[1]: Entering directory `/soft/mysql/Msql-Mysql-modules-1.2219/mysql'
PERL_DL_NONLAZY=1 /usr/bin/perl -I../blib/arch -I../blib/lib
-I/usr/lib/perl5/5.6.1/i686-linux -I/usr/lib/perl5/5.6.1 -e 'use Test::Harness
qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/00base............ok
t/10dsnlist.........DBI->connect(database=test) failed: Can't connect to local MySQL
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.sock'
(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.
t/10dsnlist.........dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-3
Failed 3/3 tests, 0.00% okay
t/20createdrop......DBI->connect(database=test) failed: Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (111) at t/20createdrop.t line 47
Cannot connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(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.
t/20createdrop......dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-5
Failed 5/5 tests, 0.00% okay
t/30insertfetch.....DBI->connect(database=test) failed: Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (111) at t/30insertfetch.t line 48
Cannot connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(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.
t/30insertfetch.....dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40bindparam.......DBI->connect(database=test) failed: Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (111) at t/40bindparam.t line 64
Cannot connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(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.
t/40bindparam.......dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-28
Failed 28/28 tests, 0.00% okay
t/40blobs...........DBI->connect(database=test) failed: Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (111) at t/40blobs.t line 68
Cannot connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(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.
t/40blobs...........dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40listfields......DBI->connect(database=test) failed: Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (111) at t/40listfields.t line 57
Cannot connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(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.
t/40listfields......dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-16
Failed 16/16 tests, 0.00% okay
t/40nulls...........DBI->connect(database=test) failed: Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (111) at t/40nulls.t line 50
Cannot connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(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.
t/40nulls...........dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40numrows.........DBI->connect(database=test) failed: Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (111) at t/40numrows.t line 59
Cannot connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(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.
t/40numrows.........dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-25
Failed 25/25 tests, 0.00% okay
t/50chopblanks......DBI->connect(database=test) failed: Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (111) at t/50chopblanks.t line 57
Cannot connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(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.
t/50chopblanks......dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-35
Failed 35/35 tests, 0.00% okay
t/50commit..........DBI->connect(database=test) failed: Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (111) at t/50commit.t line 64
Can't call method "func" on an undefined value at ../tests/mysql.dbtest line 101.
t/50commit..........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-30
Failed 30/30 tests, 0.00% okay
t/60leaks...........skipped test on this platform
t/ak-dbd............DBI->connect(database=test) failed: Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (111) at t/ak-dbd.t line 59
t/ak-dbd............ok 3/90Can't call method "func" on an undefined value at
../tests/mysql.dbtest line 101.
t/ak-dbd............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1, 4-90
Failed 88/90 tests, 2.22% okay
t/dbdadmin..........DBI->connect(database=test) failed: Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (111) at t/dbdadmin.t line 60
t/dbdadmin..........NOK 1Cannot connect: Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (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.
t/dbdadmin..........dubious
Test returned status 10 (wstat 2560, 0xa00)
DIED. FAILED tests 1-20
Failed 20/20 tests, 0.00% okay
Failed Test Status Wstat Total Fail Failed List of Failed
--------------------------------------------------------------------------------
t/10dsnlist.t 10 2560 3 3 100.00% 1-3
t/20createdrop.t 10 2560 5 5 100.00% 1-5
t/30insertfetch.t 10 2560 11 11 100.00% 1-11
t/40bindparam.t 10 2560 28 28 100.00% 1-28
t/40blobs.t 10 2560 11 11 100.00% 1-11
t/40listfields.t 10 2560 16 16 100.00% 1-16
t/40nulls.t 10 2560 11 11 100.00% 1-11
t/40numrows.t 10 2560 25 25 100.00% 1-25
t/50chopblanks.t 10 2560 35 35 100.00% 1-35
t/50commit.t 255 65280 30 30 100.00% 1-30
t/ak-dbd.t 255 65280 90 88 97.78% 1, 4-90
t/dbdadmin.t 10 2560 20 20 100.00% 1-20
1 test skipped.
Failed 12/14 test scripts, 14.29% okay. 283/290 subtests failed, 2.41% okay.
make[1]: *** [test_dynamic] Error 2
make[1]: Leaving directory `/soft/mysql/Msql-Mysql-modules-1.2219/mysql'
make: *** [test] Error 2