I am trying to install DBD::msql i run the under given commandn *$ sudo perl -MCPAN -e 'install DBD::mysql'*
CPAN: Storable loaded ok (v2.18) Going to read /home/raheel/.cpan/Metadata Database was generated on Sun, 26 Jul 2009 10:26:58 GMT Running install for module 'DBD::mysql' CPAN: Data::Dumper loaded ok (v2.121_14) 'YAML' not installed, falling back to Data::Dumper and Storable to read prefs '/home/raheel/.cpan/prefs' Running make for C/CA/CAPTTOFU/DBD-mysql-4.012.tar.gz CPAN: LWP::UserAgent loaded ok (v5.819) CPAN: Time::HiRes loaded ok (v1.9711) I would like to connect to one of the following sites to get 'authors/id/C/CA/CAPTTOFU/DBD-mysql-4.012.tar.gz': http://www.perl.org/CPAN/ ftp://ftp.perl.org/pub/CPAN/ Is it OK to try to connect to the Internet? [yes] yes Fetching with LWP: http://www.perl.org/CPAN/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.012.tar.gz CPAN: Digest::SHA loaded ok (v5.45) Fetching with LWP: http://www.perl.org/CPAN/authors/id/C/CA/CAPTTOFU/CHECKSUMS Checksum for /home/raheel/.cpan/sources/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.012.tar.gz ok DBD-mysql-4.012/ DBD-mysql-4.012/ChangeLog DBD-mysql-4.012/constants.h DBD-mysql-4.012/dbdimp.c DBD-mysql-4.012/dbdimp.h DBD-mysql-4.012/eg/ DBD-mysql-4.012/eg/._bug14979.pl DBD-mysql-4.012/eg/bug14979.pl DBD-mysql-4.012/eg/._bug21028.pl DBD-mysql-4.012/eg/bug21028.pl DBD-mysql-4.012/eg/bug30033.pl DBD-mysql-4.012/eg/bug30033pg.pl DBD-mysql-4.012/eg/decimal_test.pl DBD-mysql-4.012/eg/issue21946.pl DBD-mysql-4.012/eg/prepare_memory_usage.pl DBD-mysql-4.012/eg/proc_example1.pl DBD-mysql-4.012/eg/proc_example2.pl DBD-mysql-4.012/eg/proc_example2a.pl DBD-mysql-4.012/eg/proc_example2b.pl DBD-mysql-4.012/eg/proc_example3.pl DBD-mysql-4.012/eg/proc_example4.pl DBD-mysql-4.012/INSTALL.html DBD-mysql-4.012/lib/ DBD-mysql-4.012/lib/Bundle/ DBD-mysql-4.012/lib/Bundle/DBD/ DBD-mysql-4.012/lib/Bundle/DBD/mysql.pm DBD-mysql-4.012/lib/DBD/ DBD-mysql-4.012/lib/DBD/mysql/ DBD-mysql-4.012/lib/DBD/mysql/GetInfo.pm DBD-mysql-4.012/lib/DBD/mysql/INSTALL.pod DBD-mysql-4.012/lib/DBD/mysql.pm DBD-mysql-4.012/Makefile.PL DBD-mysql-4.012/Makefile.PL.embedded DBD-mysql-4.012/MANIFEST DBD-mysql-4.012/MANIFEST.SKIP DBD-mysql-4.012/META.yml DBD-mysql-4.012/myld DBD-mysql-4.012/mysql.xs DBD-mysql-4.012/README DBD-mysql-4.012/t/ DBD-mysql-4.012/t/00base.t DBD-mysql-4.012/t/10connect.t DBD-mysql-4.012/t/20createdrop.t DBD-mysql-4.012/t/25lockunlock.t DBD-mysql-4.012/t/29warnings.t DBD-mysql-4.012/t/30insertfetch.t DBD-mysql-4.012/t/31insertid.t DBD-mysql-4.012/t/32insert_error.t DBD-mysql-4.012/t/35limit.t DBD-mysql-4.012/t/35prepare.t DBD-mysql-4.012/t/40bindparam.t DBD-mysql-4.012/t/40bindparam2.t DBD-mysql-4.012/t/40blobs.t DBD-mysql-4.012/t/40catalog.t DBD-mysql-4.012/t/40keyinfo.t DBD-mysql-4.012/t/40listfields.t DBD-mysql-4.012/t/40nulls.t DBD-mysql-4.012/t/40numrows.t DBD-mysql-4.012/t/40server_prepare.t DBD-mysql-4.012/t/40server_prepare_error.t DBD-mysql-4.012/t/40types.t DBD-mysql-4.012/t/41bindparam.t DBD-mysql-4.012/t/41blobs_prepare.t DBD-mysql-4.012/t/42bindparam.t DBD-mysql-4.012/t/50chopblanks.t DBD-mysql-4.012/t/50commit.t DBD-mysql-4.012/t/51bind_type_guessing.t DBD-mysql-4.012/t/55utf8.t DBD-mysql-4.012/t/60leaks.t DBD-mysql-4.012/t/65types.t DBD-mysql-4.012/t/70takeimp.t DBD-mysql-4.012/t/71impdata.t DBD-mysql-4.012/t/75supported_sql.t DBD-mysql-4.012/t/76multi_statement.t DBD-mysql-4.012/t/80procs.t DBD-mysql-4.012/t/lib.pl DBD-mysql-4.012/t/mysql.dbtest DBD-mysql-4.012/t/mysql.mtest DBD-mysql-4.012/TODO CPAN: File::Temp loaded ok (v0.18) Warning (usually harmless): 'YAML' not installed, will not store persistent state CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-4.012.tar.gz PLEASE NOTE: For 'make test' to run properly, you must ensure that the database user 'root' can connect to your MySQL server and has the proper privileges that these tests require such as 'drop table', 'create table', 'drop procedure', 'create procedure' as well as others. mysql> grant all privileges on test.* to 'root'@'localhost' identified by 's3kr1t'; You can also optionally set the user to run 'make test' with: perl Makefile.pl --testuser=username I will use the following settings for compiling and testing: cflags (mysql_config) = -I/usr/include/mysql -DBIG_JOINS=1 -fPIC -fno-strict-aliasing embedded (mysql_config) = libs (mysql_config) = -Wl,-Bsymbolic-functions -rdynamic -L/usr/lib/mysql -lmysqlclient mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 0 testdb (default ) = test testhost (default ) = testpassword (default ) = testsocket (default ) = testuser (guessed ) = root To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Checking if your kit is complete... Looks good Unrecognized argument in LIBS ignored: '-Wl,-Bsymbolic-functions' Unrecognized argument in LIBS ignored: '-rdynamic' Multiple copies of Driver.xst found in: /usr/local/lib/perl/5.10.0/auto/DBI/ /usr/lib/perl5/auto/DBI/ at Makefile.PL line 902 Using DBI 1.607 (for perl 5.010000 on x86_64-linux-gnu-thread-multi) installed in /usr/local/lib/perl/5.10.0/auto/DBI/ Writing Makefile for DBD::mysql Could not read '/home/raheel/.cpan/build/DBD-mysql-4.012-Cbemxf/META.yml'. Falling back to other methods to determine prerequisites cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm cc -c -I/usr/local/lib/perl/5.10.0/auto/DBI -I/usr/include/mysql -DBIG_JOINS=1 -fPIC -fno-strict-aliasing -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -g -DVERSION=\"4.012\" -DXS_VERSION=\"4.012\" -fPIC "-I/usr/lib/perl/5.10/CORE" dbdimp.c dbdimp.c: In function ‘alloc_param’: dbdimp.c:113: warning: format not a string literal and no format arguments dbdimp.c: In function ‘alloc_bind’: dbdimp.c:131: warning: format not a string literal and no format arguments dbdimp.c: In function ‘alloc_fbind’: dbdimp.c:147: warning: format not a string literal and no format arguments dbdimp.c: In function ‘alloc_fbuffer’: dbdimp.c:162: warning: format not a string literal and no format arguments dbdimp.c: In function ‘parse_params’: dbdimp.c:477: warning: format not a string literal and no format arguments dbdimp.c: In function ‘my_login’: dbdimp.c:1786: warning: format not a string literal and no format arguments dbdimp.c: In function ‘mysql_db_login’: dbdimp.c:1847: warning: format ‘%ld’ expects type ‘long int’, but argument 2 has type ‘I32’ dbdimp.c:1847: warning: format ‘%ld’ expects type ‘long int’, but argument 3 has type ‘I32’ dbdimp.c: In function ‘mysql_db_disconnect’: dbdimp.c:1948: warning: format ‘%ld’ expects type ‘long int’, but argument 2 has type ‘I32’ dbdimp.c:1948: warning: format ‘%ld’ expects type ‘long int’, but argument 3 has type ‘I32’ dbdimp.c: In function ‘mysql_st_next_results’: dbdimp.c:2741: warning: format ‘%ld’ expects type ‘long int’, but argument 2 has type ‘I32’ dbdimp.c:2741: warning: format ‘%ld’ expects type ‘long int’, but argument 3 has type ‘I32’ dbdimp.c:2810: warning: format ‘%ld’ expects type ‘long int’, but argument 2 has type ‘I32’ dbdimp.c:2810: warning: format ‘%ld’ expects type ‘long int’, but argument 3 has type ‘I32’ dbdimp.c: In function ‘mysql_st_internal_execute41’: dbdimp.c:3075: warning: format ‘%d’ expects type ‘int’, but argument 3 has type ‘my_ulonglong’ dbdimp.c: In function ‘mysql_st_execute’: dbdimp.c:3192: warning: format ‘%ld’ expects type ‘long int’, but argument 2 has type ‘I32’ dbdimp.c:3192: warning: format ‘%ld’ expects type ‘long int’, but argument 3 has type ‘I32’ dbdimp.c:3199: warning: format ‘%ld’ expects type ‘long int’, but argument 2 has type ‘I32’ dbdimp.c:3199: warning: format ‘%ld’ expects type ‘long int’, but argument 3 has type ‘I32’ dbdimp.c: In function ‘mysql_describe’: dbdimp.c:3295: warning: format ‘%d’ expects type ‘int’, but argument 5 has type ‘long unsigned int’ dbdimp.c:3299: warning: format ‘%d’ expects type ‘int’, but argument 3 has type ‘long unsigned int’ dbdimp.c:3310: warning: format not a string literal and no format arguments dbdimp.c: In function ‘mysql_st_fetch’: dbdimp.c:3494: warning: format not a string literal and no format arguments dbdimp.c:3516: warning: format ‘%d’ expects type ‘int’, but argument 3 has type ‘long int’ dbdimp.c:3558: warning: format ‘%08lx’ expects type ‘long unsigned int’, but argument 3 has type ‘struct MYSQL_RES *’ dbdimp.c:3560: warning: format ‘%llu’ expects type ‘long long unsigned int’, but argument 3 has type ‘unsigned int’ dbdimp.c: In function ‘mysql_st_finish’: dbdimp.c:3741: warning: format ‘%ld’ expects type ‘long int’, but argument 2 has type ‘I32’ dbdimp.c:3741: warning: format ‘%ld’ expects type ‘long int’, but argument 3 has type ‘I32’ dbdimp.c: In function ‘mysql_st_FETCH_attrib’: dbdimp.c:4143: warning: format ‘%d’ expects type ‘int’, but argument 3 has type ‘my_ulonglong’ dbdimp.c: In function ‘mysql_bind_ph’: dbdimp.c:4325: warning: format ‘%d’ expects type ‘int’, but argument 3 has type ‘IV’ dbdimp.c:4343: warning: format ‘%d’ expects type ‘int’, but argument 3 has type ‘IV’ dbdimp.c:4370: warning: format ‘%d’ expects type ‘int’, but argument 3 has type ‘IV’ dbdimp.c: In function ‘mysql_db_reconnect’: dbdimp.c:4468: warning: format ‘%ld’ expects type ‘long int’, but argument 2 has type ‘I32’ dbdimp.c:4468: warning: format ‘%ld’ expects type ‘long int’, but argument 3 has type ‘I32’ /usr/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/local/lib/perl/5.10.0/auto/DBI/Driver.xst > mysql.xsi /usr/bin/perl /usr/share/perl/5.10/ExtUtils/xsubpp -typemap /usr/share/perl/5.10/ExtUtils/typemap mysql.xs > mysql.xsc && mv mysql.xsc mysql.c Warning: duplicate function definition 'do' detected in mysql.xs, line 225 Warning: duplicate function definition 'rows' detected in mysql.xs, line 650 cc -c -I/usr/local/lib/perl/5.10.0/auto/DBI -I/usr/include/mysql -DBIG_JOINS=1 -fPIC -fno-strict-aliasing -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -g -DVERSION=\"4.012\" -DXS_VERSION=\"4.012\" -fPIC "-I/usr/lib/perl/5.10/CORE" mysql.c mysql.xsi: In function ‘XS_DBD__mysql__db_disconnect’: mysql.xsi:306: warning: format ‘%ld’ expects type ‘long int’, but argument 2 has type ‘I32’ mysql.xsi:306: warning: format ‘%ld’ expects type ‘long int’, but argument 3 has type ‘I32’ mysql.xsi: In function ‘XS_DBD__mysql__db_DESTROY’: mysql.xsi:352: warning: format ‘%ld’ expects type ‘long int’, but argument 2 has type ‘I32’ mysql.xsi:352: warning: format ‘%ld’ expects type ‘long int’, but argument 3 has type ‘I32’ mysql.xsi:380: warning: format ‘%ld’ expects type ‘long int’, but argument 2 has type ‘I32’ mysql.xsi:380: warning: format ‘%ld’ expects type ‘long int’, but argument 3 has type ‘I32’ mysql.xsi: In function ‘XS_DBD__mysql__st_finish’: mysql.xsi:675: warning: format ‘%ld’ expects type ‘long int’, but argument 2 has type ‘I32’ mysql.xsi:675: warning: format ‘%ld’ expects type ‘long int’, but argument 3 has type ‘I32’ mysql.xsi: In function ‘XS_DBD__mysql__st_DESTROY’: mysql.xsi:752: warning: format ‘%ld’ expects type ‘long int’, but argument 2 has type ‘I32’ mysql.xsi:752: warning: format ‘%ld’ expects type ‘long int’, but argument 3 has type ‘I32’ mysql.xsi:766: warning: format ‘%ld’ expects type ‘long int’, but argument 2 has type ‘I32’ mysql.xsi:766: warning: format ‘%ld’ expects type ‘long int’, but argument 3 has type ‘I32’ mysql.xs: In function ‘XS_DBD__mysql__db_do’: mysql.xs:329: warning: format not a string literal and no format arguments mysql.xs:330: warning: format not a string literal and no format arguments mysql.xs:331: warning: format not a string literal and no format arguments mysql.xs:490: warning: format not a string literal and no format arguments mysql.xs: In function ‘XS_DBD__mysql__GetInfo_dbd_mysql_get_info’: mysql.xs:741: warning: format ‘%i’ expects type ‘int’, but argument 2 has type ‘struct SV *’ Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.so /usr/bin/perl myld cc -shared -O2 -g -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so \ -L/usr/lib/mysql -lmysqlclient \ 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.3pm Manifying blib/man3/DBD::mysql::INSTALL.3pm Manifying blib/man3/Bundle::DBD::mysql.3pm CAPTTOFU/DBD-mysql-4.012.tar.gz /usr/bin/make -- OK Warning (usually harmless): 'YAML' not installed, will not store persistent state Running make test PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/00base....................ok t/10connect.................skipped all skipped: ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Can't continue test t/20createdrop..............skipped all skipped: ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Can't continue test t/25lockunlock..............skipped all skipped: Can't connect to database ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Can't continue test t/29warnings................skipped all skipped: ERROR: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at t/29warnings.t line 15 t/30insertfetch.............skipped all skipped: ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Can't continue test t/31insertid................skipped all skipped: ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Can't continue test t/32insert_error............skipped all skipped: ERROR: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at t/32insert_error.t line 17 t/35limit...................skipped all skipped: ERROR: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at t/35limit.t line 18 t/35prepare.................skipped all skipped: Can't connect to database ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Can't continue test t/40bindparam...............skipped all skipped: ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Can't continue test t/40bindparam2..............skipped all skipped: ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Can't continue test t/40blobs...................Can't call method "get_info" on an undefined value at t/40blobs.t line 37. # Looks like your test died before it could output anything. t/40blobs...................dubious Test returned status 255 (wstat 65280, 0xff00) t/40catalog.................skipped all skipped: ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Can't continue test t/40keyinfo.................skipped all skipped: ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Can't continue test t/40listfields..............skipped all skipped: ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Can't continue test t/40nulls...................skipped all skipped: ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Can't continue test t/40numrows.................skipped all skipped: ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Can't continue test t/40server_prepare..........skipped all skipped: ERROR: DBI connect('test;mysql_server_prepare=1','root',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at t/40server_prepare.t line 16 t/40server_prepare_error....skipped all skipped: ERROR: DBI connect('test;mysql_server_prepare=1','root',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at t/40server_prepare_error.t line 18 t/40types...................skipped all skipped: ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Can't continue test t/41bindparam...............skipped all skipped: ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Can't continue test t/41blobs_prepare...........skipped all skipped: ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Can't continue test t/42bindparam...............skipped all skipped: ERROR: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at t/42bindparam.t line 13 t/50chopblanks..............skipped all skipped: ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Can't continue test t/50commit..................skipped all skipped: ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Can't continue test t/51bind_type_guessing......skipped all skipped: ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Can't continue test t/55utf8....................skipped all skipped: ERROR: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at t/55utf8.t line 18 t/60leaks...................skipped all skipped: Skip $ENV{SLOW_TESTS} is not set t/65types...................skipped all skipped: ERROR: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at t/65types.t line 13 t/70takeimp.................skipped all skipped: Can't connect to database ERROR: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at t/70takeimp.t line 27 t/71impdata.................DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at t/71impdata.t line 14 skipped all skipped: Can't obtain driver handle. Can't continue test t/75supported_sql...........skipped all skipped: ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Can't continue test t/76multi_statement.........skipped all skipped: ERROR: DBI connect('test','root',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at t/76multi_statement.t line 15 t/80procs...................skipped all skipped: ERROR: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). Can't continue test Failed Test Stat Wstat Total Fail List of Failed ------------------------------------------------------------------------------- t/40blobs.t 255 65280 ?? ?? ?? 33 tests skipped. Failed 1/35 test scripts. 0/6 subtests failed. Files=35, Tests=6, 3 wallclock secs ( 1.84 cusr + 0.23 csys = 2.07 CPU) Failed 1/35 test programs. 0/6 subtests failed. make: *** [test_dynamic] Error 255 CAPTTOFU/DBD-mysql-4.012.tar.gz /usr/bin/make test -- NOT OK //hint// to see the cpan-testers results for installing this module, try: reports CAPTTOFU/DBD-mysql-4.012.tar.gz Warning (usually harmless): 'YAML' not installed, will not store persistent state Running make install make test had returned bad status, won't install without force Can any body tell me where is the problem. and when i run this command it gives me this output *r...@pc99:/usr/lib/perl/5.10.0$ perl -MDBD::mysql -le 'print "ok"' ok* Regards,
