Bug #19091 for DBD-mysql: 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
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
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