yes, I got it fixed. While installing Msql-Mysql-Modules I have specified option for --mysql-libdir
perl Makefile.PL --mysql-libdir=/var/lib/mysql But, do it I installed MySQL-shared-3.23.44-1.i386.rpm which I haven't done, earlier. I don't know, by what got it fixed. and thanks to mysql.sock, mickalo post on http:[EMAIL PROTECTED]/ by which I understand. And thanks all. -- On Thu, 15 Nov 2001 12:22:30 SubbaReddy M wrote: >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) >It's checking for /tmp/mysql.sock, but it's in /var/lib/mysql/mysql.sock. > >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 > >