Unable to connect with the database

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Unable to connect with the database

uwin_pandi
Love all..,
I am going on fighting with bugzilla Installation.But still strucking to install.
Now the new problem arised.
 
     Unable to connect with  the database
   

Pls help me to install and run bugzilla.


root>/usr/bin/perl -MCPAN -e 'install "DBD::mysql"'

CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
Database was generated on Wed, 24 May 2006 04:27:41 GMT
Running install for module DBD::mysql
Running make for C/CA/CAPTTOFU/DBD-mysql-3.0004.tar.gz
CPAN: Digest::MD5 loaded ok
Checksum for /root/.cpan/sources/authors/id/C/CA/CAPTTOFU/DBD-mysql-3.0004.tar.gz ok
Scanning cache /root/.cpan/build for sizes
DBD-mysql-3.0004/
DBD-mysql-3.0004/ChangeLog
DBD-mysql-3.0004/constants.h
DBD-mysql-3.0004/dbdimp.c
DBD-mysql-3.0004/dbdimp.h
DBD-mysql-3.0004/INSTALL.html
DBD-mysql-3.0004/lib/
DBD-mysql-3.0004/lib/Bundle/
DBD-mysql-3.0004/lib/Bundle/DBD/
DBD-mysql-3.0004/lib/Bundle/DBD/mysql.pm
DBD-mysql-3.0004/lib/DBD/
DBD-mysql-3.0004/lib/DBD/mysql/
DBD-mysql-3.0004/lib/DBD/mysql/GetInfo.pm
DBD-mysql-3.0004/lib/DBD/mysql/INSTALL.pod
DBD-mysql-3.0004/lib/DBD/mysql.pm
DBD-mysql-3.0004/lib/Mysql/
DBD-mysql-3.0004/lib/Mysql/Statement.pm
DBD-mysql-3.0004/lib/Mysql.pm
DBD-mysql-3.0004/Makefile.PL
DBD-mysql-3.0004/Makefile.PL.embedded
DBD-mysql-3.0004/MANIFEST
DBD-mysql-3.0004/MANIFEST.SKIP
DBD-mysql-3.0004/META.yml
DBD-mysql-3.0004/myld
DBD-mysql-3.0004/mysql.xs
DBD-mysql-3.0004/README
DBD-mysql-3.0004/t/
DBD-mysql-3.0004/t/00base.t
DBD-mysql-3.0004/t/10dsnlist.t
DBD-mysql-3.0004/t/20createdrop.t
DBD-mysql-3.0004/t/30insertfetch.t
DBD-mysql-3.0004/t/35limit.t
DBD-mysql-3.0004/t/35prepare.t
DBD-mysql-3.0004/t/40bindparam.t
DBD-mysql-3.0004/t/40blobs.t
DBD-mysql-3.0004/t/40listfields.t
DBD-mysql-3.0004/t/40nulls.t
DBD-mysql-3.0004/t/40numrows.t
DBD-mysql-3.0004/t/41bindparam.t
DBD-mysql-3.0004/t/41blobs_prepare.t
DBD-mysql-3.0004/t/42bindparam.t
DBD-mysql-3.0004/t/50chopblanks.t
DBD-mysql-3.0004/t/50commit.t
DBD-mysql-3.0004/t/60leaks.t
DBD-mysql-3.0004/t/dbdadmin.t
DBD-mysql-3.0004/t/insertid.t
DBD-mysql-3.0004/t/lib.pl
DBD-mysql-3.0004/t/mysql.dbtest
DBD-mysql-3.0004/t/param_values.t
DBD-mysql-3.0004/t/._prepare_noerror.t
DBD-mysql-3.0004/t/prepare_noerror.t
DBD-mysql-3.0004/t/texecute.t
DBD-mysql-3.0004/TODO
Removing previously used /root/.cpan/build/DBD-mysql-3.0004

CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-3.0004.tar.gz

I will use the following settings for compiling and testing:

cflags (mysql_config) = -I/usr/include/mysql -mcpu=i486 -fno-strength-reduce
embedded (mysql_config) =
libs (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lresolv
mysql_config (guessed ) = mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testsocket (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Checking if your kit is complete...
Looks good
Using DBI 1.50 (for perl 5.008 on i386-linux-thread-multi) installed in /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI/
Writing Makefile for DBD::mysql
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Mysql.pm blib/lib/Mysql.pm
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
gcc -c -I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI/ -I/usr/include/mysql -mcpu=i486 -fno-strength-reduce -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -march=i386 -mcpu=i686 -DVERSION=\"3.0004\" -DXS_VERSION=\"3.0004\" -fPIC "-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" dbdimp.c
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI//Driver.xst > mysql.xsi
/usr/bin/perl /usr/lib/perl5/5.8.0/ExtUtils/xsubpp -typemap /usr/lib/perl5/5.8.0/ExtUtils/typemap mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 224
Warning: duplicate function definition 'rows' detected in mysql.xs, line 559
gcc -c -I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI/ -I/usr/include/mysql -mcpu=i486 -fno-strength-reduce -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -march=i386 -mcpu=i686 -DVERSION=\"3.0004\" -DXS_VERSION=\"3.0004\" -fPIC "-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/lib/mysql:/usr/lib:/lib" /usr/bin/perl myld gcc -shared -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lresolv
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/Mysql.3pm
Manifying blib/man3/DBD::mysql::INSTALL.3pm
Manifying blib/man3/Bundle::DBD::mysql.3pm
/usr/bin/make -- OK
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/10dsnlist..........ok
t/20createdrop.......ok
t/30insertfetch......ok
t/35limit............ok
t/35prepare..........ok
t/40bindparam........ok
t/40blobs............ok
t/40listfields.......ok
t/40nulls............ok
t/40numrows..........ok
t/41bindparam........ok
t/41blobs_prepare....ok
t/42bindparam........ok
t/50chopblanks.......ok
t/50commit...........DBD::mysql::db do failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=innodb' at line 1 at t/50commit.t line 86.
DBD::mysql::db do failed: Table 'test.testaj' doesn't exist at t/50commit.t line 107.
DBD::mysql::st execute failed: Table 'test.testaj' doesn't exist at t/50commit.t line 43.
DBD::mysql::st execute failed: Table 'test.testaj' doesn't exist at t/50commit.t line 43.
DBD::mysql::db do failed: Table 'test.testaj' doesn't exist at t/50commit.t line 120.
DBD::mysql::st execute failed: Table 'test.testaj' doesn't exist at t/50commit.t line 43.
DBD::mysql::st execute failed: Table 'test.testaj' doesn't exist at t/50commit.t line 43.
DBD::mysql::db do failed: Table 'test.testaj' doesn't exist at t/50commit.t line 132.
DBD::mysql::st execute failed: Table 'test.testaj' doesn't exist at t/50commit.t line 43.
DBD::mysql::st execute failed: Table 'test.testaj' doesn't exist at t/50commit.t line 43.
DBD::mysql::db do failed: Table 'test.testaj' doesn't exist at t/50commit.t line 169.
DBD::mysql::st execute failed: Table 'test.testaj' doesn't exist at t/50commit.t line 43.
DBD::mysql::st execute failed: Table 'test.testaj' doesn't exist at t/50commit.t line 43.
DBD::mysql::db do failed: Table 'test.testaj' doesn't exist at t/50commit.t line 185.
DBD::mysql::db do failed: Table 'test.testaj' doesn't exist at t/50commit.t line 202.
DBD::mysql::db do failed: Unknown table 'testaj' at t/50commit.t line 219.
t/50commit...........NOK 9Confused test output: test 9 answered after test 9
t/50commit...........NOK 10Confused test output: test 10 answered after test 11
t/50commit...........NOK 11Confused test output: test 11 answered after test 13
t/50commit...........ok 12/30Confused test output: test 12 answered after test 15
t/50commit...........NOK 13Confused test output: test 13 answered after test 17
t/50commit...........NOK 14Confused test output: test 14 answered after test 18
t/50commit...........NOK 15Confused test output: test 15 answered after test 20
t/50commit...........ok 16/30Confused test output: test 16 answered after test 21
t/50commit...........NOK 17Confused test output: test 17 answered after test 23
t/50commit...........ok 18/30Confused test output: test 18 answered after test 24
t/50commit...........NOK 19Confused test output: test 19 answered after test 26
t/50commit...........ok 20/30Confused test output: test 20 answered after test 27
t/50commit...........NOK 21Confused test output: test 21 answered after test 28
t/50commit...........ok 22/30Confused test output: test 22 answered after test 29
t/50commit...........FAILED tests 5-16, 18-22, 24-25, 27, 29
Failed 21/30 tests, 30.00% okay
t/60leaks............skipped
all skipped: $ENV{SLOW_TESTS} is not set or Proc::ProcessTable not installed
t/dbdadmin...........ok
t/insertid...........ok
t/param_values.......ok
t/prepare_noerror....FAILED test 2
Failed 1/3 tests, 66.67% okay
t/texecute...........ok
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/50commit.t 30 21 70.00% 5-16 18-22 24-25 27 29
t/prepare_noerror.t 3 1 33.33% 2
1 test skipped.
Failed 2/22 test scripts, 90.91% okay. 22/434 subtests failed, 94.93% okay.
make: *** [test_dynamic] Error 29
/usr/bin/make test -- NOT OK
Running make install
make test had returned bad status, won't install without force