Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-mysql CPAN distribution.

Report information
The Basics
Id:
19091
Status:
rejected
Priority:
Low/Low
Queue:

People
Owner:
Nobody in particular
Requestors:
kyoung [...] sleepysousa.net
Cc:
AdminCc:

BugTracker
Severity:
Critical
Broken in:
3.0002_5
Fixed in:
(no value)



Subject: perl Makefile.PL returns "expr: syntax error" on FreeBSD 4.9
My machine is running FreeBSD 4.9-RELEASE, module DBI is already installed. Installing DBD::mysql both manually or using CPAN fails with similar errors, i.e. perl Makefile.PL returns "expr: syntax error". The output of both manual and CPAN installation are as below. The error is the same for 3.0002_5 and 3.0003_1. Thanks very much for your help. Kenneth kyoung@redpine:pwd /home/kyoung/opt/sleepysousa/src/perlmod/DBD-mysql-3.0003_1 kyoung@redpine:perl Makefile.PL expr: syntax error expr: syntax error expr: syntax error expr: syntax error expr: syntax error expr: syntax error expr: syntax error expr: syntax error expr: syntax error expr: syntax error expr: syntax error expr: syntax error expr: syntax error I will use the following settings for compiling and testing: cflags (mysql_config) = -I'//usr/local/include/mysql' embedded (guessed ) = libs (mysql_config) = -L//usr/local/lib/mysql - lmysqlclient -lz -lcrypt -lm mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ps-protocol (default ) = 1 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'. Using DBI 1.50 (for perl 5.008008 on i386-freebsd) installed in /home/kyoung/opt/sleepysousa/perl-5.8.8/lib/site_perl/5.8.8/i386- freebsd/auto/DBI/ Writing Makefile for DBD::mysql
Show quoted text
cpan> make DBD::mysql
Running make for module DBD::mysql Running make for C/CA/CAPTTOFU/DBD-mysql-3.0003.tar.gz Is already unwrapped into directory /home/kyoung/.cpan/build/DBD- mysql-3.0003 CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-3.0003.tar.gz expr: syntax error expr: syntax error expr: syntax error expr: syntax error expr: syntax error expr: syntax error expr: syntax error expr: syntax error expr: syntax error expr: syntax error expr: syntax error expr: syntax error expr: syntax error expr: syntax error I will use the following settings for compiling and testing: cflags (mysql_config) = -I'//usr/local/include/mysql' embedded (guessed ) = libs (mysql_config) = -L//usr/local/lib/mysql - lmysqlclient -lz -lcrypt -lm 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.008008 on i386-freebsd) installed in /home/kyoung/opt/sleepysousa/perl-5.8.8/lib/site_perl/5.8.8/i386- freebsd/auto/DBI/ Writing Makefile for DBD::mysql cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/Mysql.pm blib/lib/Mysql.pm cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm cc -c -I/home/kyoung/opt/sleepysousa/perl- 5.8.8/lib/site_perl/5.8.8/i386-freebsd/auto/DBI/ - I'//usr/local/include/mysql' -DDBD_MYSQL_INSERT_ID_IS_GOOD -g - DHAS_FPSETMASK -DHAS_FLOATINGPOINT_H -fno-strict-aliasing -pipe - I/usr/local/include -O -DVERSION=\"3.0003\" -DXS_VERSION=\"3.0003 \" -DPIC -fPIC "-I/home/kyoung/opt/sleepysousa/perl- 5.8.8/lib/5.8.8/i386-freebsd/CORE" dbdimp.c In file included from /home/kyoung/opt/sleepysousa/perl- 5.8.8/lib/site_perl/5.8.8/i386-freebsd/auto/DBI/DBIXS.h:31, from dbdimp.h:20, from dbdimp.c:20: /home/kyoung/opt/sleepysousa/perl-5.8.8/lib/site_perl/5.8.8/i386- freebsd/auto/DBI/dbipport.h:227: warning: `PERL_UNUSED_DECL' redefined /home/kyoung/opt/sleepysousa/perl-5.8.8/lib/5.8.8/i386- freebsd/CORE/perl.h:163: warning: this is the location of the previous definition /usr/home/kyoung/opt/sleepysousa/perl-5.8.8/bin/perl -p - e "s/~DRIVER~/mysql/g" /home/kyoung/opt/sleepysousa/perl- 5.8.8/lib/site_perl/5.8.8/i386-freebsd/auto/DBI//Driver.xst > mysql.xsi /usr/home/kyoung/opt/sleepysousa/perl- 5.8.8/bin/perl /home/kyoung/opt/sleepysousa/perl- 5.8.8/lib/5.8.8/ExtUtils/xsubpp - typemap /home/kyoung/opt/sleepysousa/perl- 5.8.8/lib/5.8.8/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 cc -c -I/home/kyoung/opt/sleepysousa/perl- 5.8.8/lib/site_perl/5.8.8/i386-freebsd/auto/DBI/ - I'//usr/local/include/mysql' -DDBD_MYSQL_INSERT_ID_IS_GOOD -g - DHAS_FPSETMASK -DHAS_FLOATINGPOINT_H -fno-strict-aliasing -pipe - I/usr/local/include -O -DVERSION=\"3.0003\" -DXS_VERSION=\"3.0003 \" -DPIC -fPIC "-I/home/kyoung/opt/sleepysousa/perl- 5.8.8/lib/5.8.8/i386-freebsd/CORE" mysql.c In file included from /home/kyoung/opt/sleepysousa/perl- 5.8.8/lib/site_perl/5.8.8/i386-freebsd/auto/DBI/DBIXS.h:31, from dbdimp.h:20, from mysql.xs:14: /home/kyoung/opt/sleepysousa/perl-5.8.8/lib/site_perl/5.8.8/i386- freebsd/auto/DBI/dbipport.h:227: warning: `PERL_UNUSED_DECL' redefined /home/kyoung/opt/sleepysousa/perl-5.8.8/lib/5.8.8/i386- freebsd/CORE/perl.h:163: warning: this is the location of the previous definition 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:/usr/lib" /usr/home/kyoung/opt/sleep ysousa/perl-5.8.8/bin/perl myld cc -shared -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so - L//usr/local/lib/mysql -lmysqlclient -lz -lcrypt -lm 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/DBD::mysql::INSTALL.3 Manifying blib/man3/Mysql.3 Manifying blib/man3/Bundle::DBD::mysql.3 /usr/bin/make -- OK
Show quoted text
cpan> test DBD::mysql
Running test for module DBD::mysql Running make for C/CA/CAPTTOFU/DBD-mysql-3.0003.tar.gz Is already unwrapped into directory /home/kyoung/.cpan/build/DBD- mysql-3.0003 Has already been processed within this session Running make test PERL_DL_NONLAZY=1 /usr/home/kyoung/opt/sleepysousa/perl- 5.8.8/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/40bindparam........ok t/40blobs............ok t/40listfields.......ok t/40nulls............ok t/40numrows..........ok t/41blobs_prepare....ok t/50chopblanks.......ok t/50commit...........DBD::mysql::db do failed: You have an error in your SQL syntax near 'ENGINE=bdb' at line 1 at t/50commit.t line 86. DBD::mysql::db do failed: Table 'test.testac' doesn't exist at t/50commit.t line 107. DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at t/50commit.t line 43. DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at t/50commit.t line 43. DBD::mysql::db do failed: Table 'test.testac' doesn't exist at t/50commit.t line 120. DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at t/50commit.t line 43. DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at t/50commit.t line 43. DBD::mysql::db do failed: Table 'test.testac' doesn't exist at t/50commit.t line 132. DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at t/50commit.t line 43. DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at t/50commit.t line 43. DBD::mysql::db do failed: Table 'test.testac' doesn't exist at t/50commit.t line 169. DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at t/50commit.t line 43. DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at t/50commit.t line 43. DBD::mysql::db do failed: Table 'test.testac' doesn't exist at t/50commit.t line 185. DBD::mysql::db do failed: Table 'test.testac' doesn't exist at t/50commit.t line 202. DBD::mysql::db do failed: Unknown table 'testac' 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 Confused 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 Confused test output: test 16 answered after test 21 t/50commit...........NOK 17Confused test output: test 17 answered after test 23 Confused test output: test 18 answered after test 24 t/50commit...........NOK 19Confused test output: test 19 answered after test 26 Confused test output: test 20 answered after test 27 t/50commit...........NOK 21Confused test output: test 21 answered after test 28 Confused 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/19 test scripts, 89.47% okay. 22/377 subtests failed, 94.16% okay. *** Error code 2 Stop in /usr/home/kyoung/.cpan/build/DBD-mysql-3.0003. /usr/bin/make test -- NOT OK
Show quoted text
cpan>
FYI, my perl version is 5.8.8. built for i386-freebsd Thanks. Kenneth On Fri May 05 03:28:19 2006, guest wrote:
Show quoted text
> My machine is running FreeBSD 4.9-RELEASE, module DBI is already > installed. > > Installing DBD::mysql both manually or using CPAN > fails with similar errors, i.e. perl Makefile.PL returns "expr:
syntax
Show quoted text
> error". > > The output of both manual and CPAN installation are as below. > The error is the same for 3.0002_5 and 3.0003_1. > Thanks very much for your help. > > Kenneth > > > > kyoung@redpine:pwd > /home/kyoung/opt/sleepysousa/src/perlmod/DBD-mysql-3.0003_1 > kyoung@redpine:perl Makefile.PL > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > I will use the following settings for compiling and testing: > > cflags (mysql_config) = -I'//usr/local/include/mysql' > embedded (guessed ) = > libs (mysql_config) = -L//usr/local/lib/mysql - > lmysqlclient -lz -lcrypt -lm > mysql_config (guessed ) = mysql_config > nocatchstderr (default ) = 0 > nofoundrows (default ) = 0 > ps-protocol (default ) = 1 > 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'. > > Using DBI 1.50 (for perl 5.008008 on i386-freebsd) installed > in /home/kyoung/opt/sleepysousa/perl-5.8.8/lib/site_perl/5.8.8/i386- > freebsd/auto/DBI/ > Writing Makefile for DBD::mysql > > >
> cpan> make DBD::mysql
> Running make for module DBD::mysql > Running make for C/CA/CAPTTOFU/DBD-mysql-3.0003.tar.gz > Is already unwrapped into directory /home/kyoung/.cpan/build/DBD- > mysql-3.0003 > > CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-3.0003.tar.gz > > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > I will use the following settings for compiling and testing: > > cflags (mysql_config) = -I'//usr/local/include/mysql' > embedded (guessed ) = > libs (mysql_config) = -L//usr/local/lib/mysql - > lmysqlclient -lz -lcrypt -lm > 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.008008 on i386-freebsd) installed > in /home/kyoung/opt/sleepysousa/perl-5.8.8/lib/site_perl/5.8.8/i386- > freebsd/auto/DBI/ > Writing Makefile for DBD::mysql > cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm > cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm > cp lib/Mysql.pm blib/lib/Mysql.pm > cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod > cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm > cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm > cc -c -I/home/kyoung/opt/sleepysousa/perl- > 5.8.8/lib/site_perl/5.8.8/i386-freebsd/auto/DBI/ - > I'//usr/local/include/mysql' -DDBD_MYSQL_INSERT_ID_IS_GOOD -g - > DHAS_FPSETMASK -DHAS_FLOATINGPOINT_H -fno-strict-aliasing -pipe - > I/usr/local/include -O -DVERSION=\"3.0003\" -DXS_VERSION=\"3.0003 > \" -DPIC -fPIC "-I/home/kyoung/opt/sleepysousa/perl- > 5.8.8/lib/5.8.8/i386-freebsd/CORE" dbdimp.c > In file included from /home/kyoung/opt/sleepysousa/perl- > 5.8.8/lib/site_perl/5.8.8/i386-freebsd/auto/DBI/DBIXS.h:31, > from dbdimp.h:20, > from dbdimp.c:20: > /home/kyoung/opt/sleepysousa/perl-5.8.8/lib/site_perl/5.8.8/i386- > freebsd/auto/DBI/dbipport.h:227: warning: `PERL_UNUSED_DECL'
redefined
Show quoted text
> /home/kyoung/opt/sleepysousa/perl-5.8.8/lib/5.8.8/i386- > freebsd/CORE/perl.h:163: warning: this is the location of the
previous
Show quoted text
> definition > /usr/home/kyoung/opt/sleepysousa/perl-5.8.8/bin/perl -p - > e "s/~DRIVER~/mysql/g" /home/kyoung/opt/sleepysousa/perl- > 5.8.8/lib/site_perl/5.8.8/i386-freebsd/auto/DBI//Driver.xst >
mysql.xsi
Show quoted text
> /usr/home/kyoung/opt/sleepysousa/perl- > 5.8.8/bin/perl /home/kyoung/opt/sleepysousa/perl- > 5.8.8/lib/5.8.8/ExtUtils/xsubpp - > typemap /home/kyoung/opt/sleepysousa/perl- > 5.8.8/lib/5.8.8/ExtUtils/typemap mysql.xs > mysql.xsc && mv
mysql.xsc
Show quoted text
> mysql.c > Warning: duplicate function definition 'do' detected in mysql.xs,
line
Show quoted text
> 224 > Warning: duplicate function definition 'rows' detected in mysql.xs, > line 559 > cc -c -I/home/kyoung/opt/sleepysousa/perl- > 5.8.8/lib/site_perl/5.8.8/i386-freebsd/auto/DBI/ - > I'//usr/local/include/mysql' -DDBD_MYSQL_INSERT_ID_IS_GOOD -g - > DHAS_FPSETMASK -DHAS_FLOATINGPOINT_H -fno-strict-aliasing -pipe - > I/usr/local/include -O -DVERSION=\"3.0003\" -DXS_VERSION=\"3.0003 > \" -DPIC -fPIC "-I/home/kyoung/opt/sleepysousa/perl- > 5.8.8/lib/5.8.8/i386-freebsd/CORE" mysql.c > In file included from /home/kyoung/opt/sleepysousa/perl- > 5.8.8/lib/site_perl/5.8.8/i386-freebsd/auto/DBI/DBIXS.h:31, > from dbdimp.h:20, > from mysql.xs:14: > /home/kyoung/opt/sleepysousa/perl-5.8.8/lib/site_perl/5.8.8/i386- > freebsd/auto/DBI/dbipport.h:227: warning: `PERL_UNUSED_DECL'
redefined
Show quoted text
> /home/kyoung/opt/sleepysousa/perl-5.8.8/lib/5.8.8/i386- > freebsd/CORE/perl.h:163: warning: this is the location of the
previous
Show quoted text
> definition > 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:/usr/lib" /usr/home/kyoung/opt/sleep
Show quoted text
> ysousa/perl-5.8.8/bin/perl myld cc -shared -L/usr/local/lib > dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so - > L//usr/local/lib/mysql -lmysqlclient -lz -lcrypt -lm > 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/DBD::mysql::INSTALL.3 > Manifying blib/man3/Mysql.3 > Manifying blib/man3/Bundle::DBD::mysql.3 > /usr/bin/make -- OK >
> cpan> test DBD::mysql
> Running test for module DBD::mysql > Running make for C/CA/CAPTTOFU/DBD-mysql-3.0003.tar.gz > Is already unwrapped into directory /home/kyoung/.cpan/build/DBD- > mysql-3.0003 > Has already been processed within this session > Running make test > PERL_DL_NONLAZY=1 /usr/home/kyoung/opt/sleepysousa/perl- > 5.8.8/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness > (0, 'blib/lib', 'blib/arch')" t/*.t >
t/00base.............ok
Show quoted text
> >
t/10dsnlist..........ok
Show quoted text
> >
t/20createdrop.......ok
Show quoted text
> >
t/30insertfetch......ok
Show quoted text
> >
t/35limit............ok
Show quoted text
> >
t/40bindparam........ok
Show quoted text
> >
t/40blobs............ok
Show quoted text
> >
t/40listfields.......ok
Show quoted text
> >
t/40nulls............ok
Show quoted text
> >
t/40numrows..........ok
Show quoted text
> >
t/41blobs_prepare....ok
Show quoted text
> >
t/50chopblanks.......ok
Show quoted text
> > t/50commit...........DBD::mysql::db do failed: You have an error in > your SQL syntax near 'ENGINE=bdb' at line 1 at t/50commit.t line 86. > DBD::mysql::db do failed: Table 'test.testac' doesn't exist at > t/50commit.t line 107. > DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at > t/50commit.t line 43. > DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at > t/50commit.t line 43. > DBD::mysql::db do failed: Table 'test.testac' doesn't exist at > t/50commit.t line 120. > DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at > t/50commit.t line 43. > DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at > t/50commit.t line 43. > DBD::mysql::db do failed: Table 'test.testac' doesn't exist at > t/50commit.t line 132. > DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at > t/50commit.t line 43. > DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at > t/50commit.t line 43. > DBD::mysql::db do failed: Table 'test.testac' doesn't exist at > t/50commit.t line 169. > DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at > t/50commit.t line 43. > DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at > t/50commit.t line 43. > DBD::mysql::db do failed: Table 'test.testac' doesn't exist at > t/50commit.t line 185. > DBD::mysql::db do failed: Table 'test.testac' doesn't exist at > t/50commit.t line 202. > DBD::mysql::db do failed: Unknown table 'testac' at t/50commit.t
line
Show quoted text
> 219. > t/50commit...........NOK 9Confused test output: test 9 answered
after
Show quoted text
> 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 > Confused 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 > Confused test output: test 16 answered after test 21 > t/50commit...........NOK 17Confused test output: test 17 answered > after test 23 > Confused test output: test 18 answered after test 24 > t/50commit...........NOK 19Confused test output: test 19 answered > after test 26 > Confused test output: test 20 answered after test 27 > t/50commit...........NOK 21Confused test output: test 21 answered > after test 28 > Confused 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
Show quoted text
> not installed >
t/dbdadmin...........ok
Show quoted text
> >
t/insertid...........ok
Show quoted text
> >
t/param_values.......ok
Show quoted text
> > t/prepare_noerror....FAILED test > 2 > Failed 1/3 tests, 66.67% okay >
t/texecute...........ok
Show quoted text
> > Failed Test Stat Wstat Total Fail Failed List of Failed > ---------------------------------------------------------------------
--
Show quoted text
> -------- > t/50commit.t 30 21 70.00% 5-16 18-22 24-25
27
Show quoted text
> 29 > t/prepare_noerror.t 3 1 33.33% 2 > 1 test skipped. > Failed 2/19 test scripts, 89.47% okay. 22/377 subtests failed,
94.16%
Show quoted text
> okay. > *** Error code 2 > > Stop in /usr/home/kyoung/.cpan/build/DBD-mysql-3.0003. > /usr/bin/make test -- NOT OK >
> cpan>
Please double-check this with that latest release of DBD::mysql, and if there are still errors reported, try running the mysql_config manually to see if that is the source of the errors. Thanks.
Hi and thanks for the bug report! I see in your problem you have: t/50commit...........DBD::mysql::db do failed: You have an error in your SQL syntax near 'ENGINE=bdb' at line 1 at t/50commit.t line 86. DBD::mysql::db do failed: Table 'test.testac' doesn't exist at I can say that MySQL doesn't support bdb table types any more, so that is one problem. Could you please try with the latest DBD::mysql 4.00 as there have been various fixes to the syntax of Makefile.PL as well as other code. Also, do you have a table type defaulting to bdb? You'll have to change that to some other table type (for transactional tables at least, perhaps use innodb). regards, Patrick On Fri May 05 03:28:19 2006, guest wrote:
Show quoted text
> My machine is running FreeBSD 4.9-RELEASE, module DBI is already > installed. > > Installing DBD::mysql both manually or using CPAN > fails with similar errors, i.e. perl Makefile.PL returns "expr: syntax > error". > > The output of both manual and CPAN installation are as below. > The error is the same for 3.0002_5 and 3.0003_1. > Thanks very much for your help. > > Kenneth > > > > kyoung@redpine:pwd > /home/kyoung/opt/sleepysousa/src/perlmod/DBD-mysql-3.0003_1 > kyoung@redpine:perl Makefile.PL > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > I will use the following settings for compiling and testing: > > cflags (mysql_config) = -I'//usr/local/include/mysql' > embedded (guessed ) = > libs (mysql_config) = -L//usr/local/lib/mysql - > lmysqlclient -lz -lcrypt -lm > mysql_config (guessed ) = mysql_config > nocatchstderr (default ) = 0 > nofoundrows (default ) = 0 > ps-protocol (default ) = 1 > 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'. > > Using DBI 1.50 (for perl 5.008008 on i386-freebsd) installed > in /home/kyoung/opt/sleepysousa/perl-5.8.8/lib/site_perl/5.8.8/i386- > freebsd/auto/DBI/ > Writing Makefile for DBD::mysql > > >
> cpan> make DBD::mysql
> Running make for module DBD::mysql > Running make for C/CA/CAPTTOFU/DBD-mysql-3.0003.tar.gz > Is already unwrapped into directory /home/kyoung/.cpan/build/DBD- > mysql-3.0003 > > CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-3.0003.tar.gz > > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > expr: syntax error > I will use the following settings for compiling and testing: > > cflags (mysql_config) = -I'//usr/local/include/mysql' > embedded (guessed ) = > libs (mysql_config) = -L//usr/local/lib/mysql - > lmysqlclient -lz -lcrypt -lm > 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.008008 on i386-freebsd) installed > in /home/kyoung/opt/sleepysousa/perl-5.8.8/lib/site_perl/5.8.8/i386- > freebsd/auto/DBI/ > Writing Makefile for DBD::mysql > cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm > cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm > cp lib/Mysql.pm blib/lib/Mysql.pm > cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod > cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm > cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm > cc -c -I/home/kyoung/opt/sleepysousa/perl- > 5.8.8/lib/site_perl/5.8.8/i386-freebsd/auto/DBI/ - > I'//usr/local/include/mysql' -DDBD_MYSQL_INSERT_ID_IS_GOOD -g - > DHAS_FPSETMASK -DHAS_FLOATINGPOINT_H -fno-strict-aliasing -pipe - > I/usr/local/include -O -DVERSION=\"3.0003\" -DXS_VERSION=\"3.0003 > \" -DPIC -fPIC "-I/home/kyoung/opt/sleepysousa/perl- > 5.8.8/lib/5.8.8/i386-freebsd/CORE" dbdimp.c > In file included from /home/kyoung/opt/sleepysousa/perl- > 5.8.8/lib/site_perl/5.8.8/i386-freebsd/auto/DBI/DBIXS.h:31, > from dbdimp.h:20, > from dbdimp.c:20: > /home/kyoung/opt/sleepysousa/perl-5.8.8/lib/site_perl/5.8.8/i386- > freebsd/auto/DBI/dbipport.h:227: warning: `PERL_UNUSED_DECL' redefined > /home/kyoung/opt/sleepysousa/perl-5.8.8/lib/5.8.8/i386- > freebsd/CORE/perl.h:163: warning: this is the location of the previous > definition > /usr/home/kyoung/opt/sleepysousa/perl-5.8.8/bin/perl -p - > e "s/~DRIVER~/mysql/g" /home/kyoung/opt/sleepysousa/perl- > 5.8.8/lib/site_perl/5.8.8/i386-freebsd/auto/DBI//Driver.xst > mysql.xsi > /usr/home/kyoung/opt/sleepysousa/perl- > 5.8.8/bin/perl /home/kyoung/opt/sleepysousa/perl- > 5.8.8/lib/5.8.8/ExtUtils/xsubpp - > typemap /home/kyoung/opt/sleepysousa/perl- > 5.8.8/lib/5.8.8/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 > cc -c -I/home/kyoung/opt/sleepysousa/perl- > 5.8.8/lib/site_perl/5.8.8/i386-freebsd/auto/DBI/ - > I'//usr/local/include/mysql' -DDBD_MYSQL_INSERT_ID_IS_GOOD -g - > DHAS_FPSETMASK -DHAS_FLOATINGPOINT_H -fno-strict-aliasing -pipe - > I/usr/local/include -O -DVERSION=\"3.0003\" -DXS_VERSION=\"3.0003 > \" -DPIC -fPIC "-I/home/kyoung/opt/sleepysousa/perl- > 5.8.8/lib/5.8.8/i386-freebsd/CORE" mysql.c > In file included from /home/kyoung/opt/sleepysousa/perl- > 5.8.8/lib/site_perl/5.8.8/i386-freebsd/auto/DBI/DBIXS.h:31, > from dbdimp.h:20, > from mysql.xs:14: > /home/kyoung/opt/sleepysousa/perl-5.8.8/lib/site_perl/5.8.8/i386- > freebsd/auto/DBI/dbipport.h:227: warning: `PERL_UNUSED_DECL' redefined > /home/kyoung/opt/sleepysousa/perl-5.8.8/lib/5.8.8/i386- > freebsd/CORE/perl.h:163: warning: this is the location of the previous > definition > 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:/usr/lib" /usr/home/kyoung/opt/sleep > ysousa/perl-5.8.8/bin/perl myld cc -shared -L/usr/local/lib > dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so - > L//usr/local/lib/mysql -lmysqlclient -lz -lcrypt -lm > 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/DBD::mysql::INSTALL.3 > Manifying blib/man3/Mysql.3 > Manifying blib/man3/Bundle::DBD::mysql.3 > /usr/bin/make -- OK >
> cpan> test DBD::mysql
> Running test for module DBD::mysql > Running make for C/CA/CAPTTOFU/DBD-mysql-3.0003.tar.gz > Is already unwrapped into directory /home/kyoung/.cpan/build/DBD- > mysql-3.0003 > Has already been processed within this session > Running make test > PERL_DL_NONLAZY=1 /usr/home/kyoung/opt/sleepysousa/perl- > 5.8.8/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/40bindparam........ok > > t/40blobs............ok > > t/40listfields.......ok > > t/40nulls............ok > > t/40numrows..........ok > > t/41blobs_prepare....ok > > t/50chopblanks.......ok > > t/50commit...........DBD::mysql::db do failed: You have an error in > your SQL syntax near 'ENGINE=bdb' at line 1 at t/50commit.t line 86. > DBD::mysql::db do failed: Table 'test.testac' doesn't exist at > t/50commit.t line 107. > DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at > t/50commit.t line 43. > DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at > t/50commit.t line 43. > DBD::mysql::db do failed: Table 'test.testac' doesn't exist at > t/50commit.t line 120. > DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at > t/50commit.t line 43. > DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at > t/50commit.t line 43. > DBD::mysql::db do failed: Table 'test.testac' doesn't exist at > t/50commit.t line 132. > DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at > t/50commit.t line 43. > DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at > t/50commit.t line 43. > DBD::mysql::db do failed: Table 'test.testac' doesn't exist at > t/50commit.t line 169. > DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at > t/50commit.t line 43. > DBD::mysql::st execute failed: Table 'test.testac' doesn't exist at > t/50commit.t line 43. > DBD::mysql::db do failed: Table 'test.testac' doesn't exist at > t/50commit.t line 185. > DBD::mysql::db do failed: Table 'test.testac' doesn't exist at > t/50commit.t line 202. > DBD::mysql::db do failed: Unknown table 'testac' 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 > Confused 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 > Confused test output: test 16 answered after test 21 > t/50commit...........NOK 17Confused test output: test 17 answered > after test 23 > Confused test output: test 18 answered after test 24 > t/50commit...........NOK 19Confused test output: test 19 answered > after test 26 > Confused test output: test 20 answered after test 27 > t/50commit...........NOK 21Confused test output: test 21 answered > after test 28 > Confused 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/19 test scripts, 89.47% okay. 22/377 subtests failed, 94.16% > okay. > *** Error code 2 > > Stop in /usr/home/kyoung/.cpan/build/DBD-mysql-3.0003. > /usr/bin/make test -- NOT OK >
> cpan>
Rejecting ticket because of no feedback from reporter and of course VERY old and now unsupported mysql and FreeBSD versions.


This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.