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