Compile error in dbdimp.c. v 3.0007
am 19.09.2006 11:50:14 von Guillermo Gozalbes
------=_Part_5860_8903678.1158659414387
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
I can't compile the latest version of DBD:mysql downloaded from CPAN.
-
cpan> install DBD:mysql
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
Database was generated on Tue, 19 Sep 2006 04:32:30 GMT
Running install for module DBD::mysql
Running make for C/CA/CAPTTOFU/DBD-mysql-3.0007.tar.gz
CPAN: Digest::SHA loaded ok
CPAN: Module::Signature security checks disabled because Module::Signature
not installed. Please consider installing the Module::Signature module.
You may also need to be able to connect over the Internet to the public
keyservers like pgp.mit.edu (port 11371).
CPAN: Compress::Zlib loaded ok
Checksum for /root/.cpan/sources/authors/id/C/CA/CAPTTOFU/DBD-
mysql-3.0007.tar.gz ok
Scanning cache /root/.cpan/build for sizes
DBD-mysql-3.0007/
DBD-mysql-3.0007/ChangeLog
DBD-mysql-3.0007/constants.h
DBD-mysql-3.0007/dbdimp.c
DBD-mysql-3.0007/dbdimp.h
DBD-mysql-3.0007/eg/
DBD-mysql-3.0007/eg/prepare_memory_usage.pl
DBD-mysql-3.0007/eg/proc_example1.pl
DBD-mysql-3.0007/eg/proc_example2.pl
DBD-mysql-3.0007/eg/proc_example3.pl
DBD-mysql-3.0007/INSTALL.html
DBD-mysql-3.0007/lib/
DBD-mysql-3.0007/lib/Bundle/
DBD-mysql-3.0007/lib/Bundle/DBD/
DBD-mysql-3.0007/lib/Bundle/DBD/mysql.pm
DBD-mysql-3.0007/lib/DBD/
DBD-mysql-3.0007/lib/DBD/mysql/
DBD-mysql-3.0007/lib/DBD/mysql/GetInfo.pm
DBD-mysql-3.0007/lib/DBD/mysql/INSTALL.pod
DBD-mysql-3.0007/lib/DBD/mysql.pm
DBD-mysql-3.0007/lib/Mysql/
DBD-mysql-3.0007/lib/Mysql/Statement.pm
DBD-mysql-3.0007/lib/Mysql.pm
DBD-mysql-3.0007/Makefile.PL
DBD-mysql-3.0007/Makefile.PL.embedded
DBD-mysql-3.0007/MANIFEST
DBD-mysql-3.0007/MANIFEST.SKIP
DBD-mysql-3.0007/META.yml
DBD-mysql-3.0007/myld
DBD-mysql-3.0007/mysql.xs
DBD-mysql-3.0007/README
DBD-mysql-3.0007/t/
DBD-mysql-3.0007/t/00base.t
DBD-mysql-3.0007/t/10dsnlist.t
DBD-mysql-3.0007/t/20createdrop.t
DBD-mysql-3.0007/t/30insertfetch.t
DBD-mysql-3.0007/t/35limit.t
DBD-mysql-3.0007/t/35prepare.t
DBD-mysql-3.0007/t/40bindparam.t
DBD-mysql-3.0007/t/40bindparam2.t
DBD-mysql-3.0007/t/40blobs.t
DBD-mysql-3.0007/t/40listfields.t
DBD-mysql-3.0007/t/40nulls.t
DBD-mysql-3.0007/t/40numrows.t
DBD-mysql-3.0007/t/41bindparam.t
DBD-mysql-3.0007/t/41blobs_prepare.t
DBD-mysql-3.0007/t/42bindparam.t
DBD-mysql-3.0007/t/50chopblanks.t
DBD-mysql-3.0007/t/50commit.t
DBD-mysql-3.0007/t/60leaks.t
DBD-mysql-3.0007/t/dbdadmin.t
DBD-mysql-3.0007/t/insertid.t
DBD-mysql-3.0007/t/lib.pl
DBD-mysql-3.0007/t/mysql.dbtest
DBD-mysql-3.0007/t/param_values.t
DBD-mysql-3.0007/t/._prepare_noerror.t
DBD-mysql-3.0007/t/prepare_noerror.t
DBD-mysql-3.0007/t/texecute.t
DBD-mysql-3.0007/TODO
Removing previously used /root/.cpan/build/DBD-mysql-3.0007
CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-3.0007.tar.gz
I will use the following settings for compiling and testing:
cflags (mysql_config) = -I/usr/include/mysql -DBIG_JOINS=1
embedded (mysql_config) =
libs (mysql_config) = -L/usr/lib -lmysqlclient -lz -lcrypt -lnsl
-lm
mysql_config (guessed ) = mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
Use of uninitialized value in printf at Makefile.PL line 172, line
103.
test_user ( ) =
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.46 (for perl 5.008004 on i386-linux-thread-multi) installed in
/usr/lib/perl5/auto/DBI/
Writing Makefile for DBD::mysql
CPAN: YAML loaded ok
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/usr/lib/perl5/auto/DBI/ -I/usr/include/mysql -DBIG_JOINS=1
-DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE
-DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"3.0007\"
-DXS_VERSION=\"3.0007\" -fPIC "-I/usr/lib/perl/5.8/CORE" dbdimp.c
dbdimp.c: In function `mysql_st_internal_execute':
dbdimp.c:2390: parse error before `rows'
dbdimp.c:2467: `rows' undeclared (first use in this function)
dbdimp.c:2467: (Each undeclared identifier is reported only once
dbdimp.c:2467: for each function it appears in.)
make: *** [dbdimp.o] Error 1
/usr/bin/make -- NOT OK
Running make test
Can't test without successful make
Running make install
make had returned bad status, install seems impossible
Failed during this command:
CAPTTOFU/DBD-mysql-3.0007.tar.gz : make NO
-
In line 2390 of dbdimp.c i see the "rows" variable declaration in the code
but not in declaration space. This is correct in C?
How can solve it?
I need to move the declaration to the top of function?
Normally in install dbd:mysql using CPAN install.
How i can find the patched package .gz?
Regards,
--
--
Guillermo Gozalbes
Versus Soft S.L.
------=_Part_5860_8903678.1158659414387--
RE: Compile error in dbdimp.c. v 3.0007
am 20.09.2006 10:51:18 von Martin.Evans
Edit the file dbdimp.c. On line 2390 you will see:
my_ulonglong rows= 0;
Move this line up to where the other variables are declared i.e. line 2350
e.g.
{
D_imp_sth(h);
D_imp_dbh_from_sth;
STRLEN slen;
bool bind_type_guessing;
char *sbuf = SvPV(statement, slen);
char *table;
char *salloc;
int htype;
my_ulonglong rows= 0; /* MOVED LINE FROM BELOW */
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
On 19-Sep-2006 Guillermo Gozalbes wrote:
> I can't compile the latest version of DBD:mysql downloaded from CPAN.
>
> -
> cpan> install DBD:mysql
> CPAN: Storable loaded ok
> Going to read /root/.cpan/Metadata
> Database was generated on Tue, 19 Sep 2006 04:32:30 GMT
> Running install for module DBD::mysql
> Running make for C/CA/CAPTTOFU/DBD-mysql-3.0007.tar.gz
> CPAN: Digest::SHA loaded ok
>
> CPAN: Module::Signature security checks disabled because Module::Signature
> not installed. Please consider installing the Module::Signature module.
> You may also need to be able to connect over the Internet to the public
> keyservers like pgp.mit.edu (port 11371).
>
> CPAN: Compress::Zlib loaded ok
> Checksum for /root/.cpan/sources/authors/id/C/CA/CAPTTOFU/DBD-
> mysql-3.0007.tar.gz ok
> Scanning cache /root/.cpan/build for sizes
> DBD-mysql-3.0007/
> DBD-mysql-3.0007/ChangeLog
> DBD-mysql-3.0007/constants.h
> DBD-mysql-3.0007/dbdimp.c
> DBD-mysql-3.0007/dbdimp.h
> DBD-mysql-3.0007/eg/
> DBD-mysql-3.0007/eg/prepare_memory_usage.pl
> DBD-mysql-3.0007/eg/proc_example1.pl
> DBD-mysql-3.0007/eg/proc_example2.pl
> DBD-mysql-3.0007/eg/proc_example3.pl
> DBD-mysql-3.0007/INSTALL.html
> DBD-mysql-3.0007/lib/
> DBD-mysql-3.0007/lib/Bundle/
> DBD-mysql-3.0007/lib/Bundle/DBD/
> DBD-mysql-3.0007/lib/Bundle/DBD/mysql.pm
> DBD-mysql-3.0007/lib/DBD/
> DBD-mysql-3.0007/lib/DBD/mysql/
> DBD-mysql-3.0007/lib/DBD/mysql/GetInfo.pm
> DBD-mysql-3.0007/lib/DBD/mysql/INSTALL.pod
> DBD-mysql-3.0007/lib/DBD/mysql.pm
> DBD-mysql-3.0007/lib/Mysql/
> DBD-mysql-3.0007/lib/Mysql/Statement.pm
> DBD-mysql-3.0007/lib/Mysql.pm
> DBD-mysql-3.0007/Makefile.PL
> DBD-mysql-3.0007/Makefile.PL.embedded
> DBD-mysql-3.0007/MANIFEST
> DBD-mysql-3.0007/MANIFEST.SKIP
> DBD-mysql-3.0007/META.yml
> DBD-mysql-3.0007/myld
> DBD-mysql-3.0007/mysql.xs
> DBD-mysql-3.0007/README
> DBD-mysql-3.0007/t/
> DBD-mysql-3.0007/t/00base.t
> DBD-mysql-3.0007/t/10dsnlist.t
> DBD-mysql-3.0007/t/20createdrop.t
> DBD-mysql-3.0007/t/30insertfetch.t
> DBD-mysql-3.0007/t/35limit.t
> DBD-mysql-3.0007/t/35prepare.t
> DBD-mysql-3.0007/t/40bindparam.t
> DBD-mysql-3.0007/t/40bindparam2.t
> DBD-mysql-3.0007/t/40blobs.t
> DBD-mysql-3.0007/t/40listfields.t
> DBD-mysql-3.0007/t/40nulls.t
> DBD-mysql-3.0007/t/40numrows.t
> DBD-mysql-3.0007/t/41bindparam.t
> DBD-mysql-3.0007/t/41blobs_prepare.t
> DBD-mysql-3.0007/t/42bindparam.t
> DBD-mysql-3.0007/t/50chopblanks.t
> DBD-mysql-3.0007/t/50commit.t
> DBD-mysql-3.0007/t/60leaks.t
> DBD-mysql-3.0007/t/dbdadmin.t
> DBD-mysql-3.0007/t/insertid.t
> DBD-mysql-3.0007/t/lib.pl
> DBD-mysql-3.0007/t/mysql.dbtest
> DBD-mysql-3.0007/t/param_values.t
> DBD-mysql-3.0007/t/._prepare_noerror.t
> DBD-mysql-3.0007/t/prepare_noerror.t
> DBD-mysql-3.0007/t/texecute.t
> DBD-mysql-3.0007/TODO
> Removing previously used /root/.cpan/build/DBD-mysql-3.0007
>
> CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-3.0007.tar.gz
>
> I will use the following settings for compiling and testing:
>
> cflags (mysql_config) = -I/usr/include/mysql -DBIG_JOINS=1
> embedded (mysql_config) =
> libs (mysql_config) = -L/usr/lib -lmysqlclient -lz -lcrypt -lnsl
> -lm
> mysql_config (guessed ) = mysql_config
> nocatchstderr (default ) = 0
> nofoundrows (default ) = 0
> ssl (guessed ) = 0
> Use of uninitialized value in printf at Makefile.PL line 172, line
> 103.
> test_user ( ) =
> 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.46 (for perl 5.008004 on i386-linux-thread-multi) installed in
> /usr/lib/perl5/auto/DBI/
> Writing Makefile for DBD::mysql
> CPAN: YAML loaded ok
> 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/usr/lib/perl5/auto/DBI/ -I/usr/include/mysql -DBIG_JOINS=1
> -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE
> -DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -I/usr/local/include
> -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"3.0007\"
> -DXS_VERSION=\"3.0007\" -fPIC "-I/usr/lib/perl/5.8/CORE" dbdimp.c
> dbdimp.c: In function `mysql_st_internal_execute':
> dbdimp.c:2390: parse error before `rows'
> dbdimp.c:2467: `rows' undeclared (first use in this function)
> dbdimp.c:2467: (Each undeclared identifier is reported only once
> dbdimp.c:2467: for each function it appears in.)
> make: *** [dbdimp.o] Error 1
> /usr/bin/make -- NOT OK
> Running make test
> Can't test without successful make
> Running make install
> make had returned bad status, install seems impossible
> Failed during this command:
> CAPTTOFU/DBD-mysql-3.0007.tar.gz : make NO
>
> -
>
> In line 2390 of dbdimp.c i see the "rows" variable declaration in the code
> but not in declaration space. This is correct in C?
>
> How can solve it?
> I need to move the declaration to the top of function?
>
> Normally in install dbd:mysql using CPAN install.
>
> How i can find the patched package .gz?
>
> Regards,
>
> --
> --
> Guillermo Gozalbes
> Versus Soft S.L.
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org
RE: Compile error in dbdimp.c. v 3.0007
am 13.10.2006 20:48:03 von Andy McHargue
[ For threading: This is in response to http://lists.mysql.com/perl/3966
, but there doesn't seem to be a way to reply via the web, and I've only
just subscribed. ]
I experienced the same compile problem as Guillermo Gozalbes, and when I
made the suggested edit below, now I get
[~/.cpan/build/DBD-mysql-3.0007]$ make >make.out # make.out makes me
miss my wife
/usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1
But then I added the path to lib and include on my machine, like
perl Makefile.PL --cflags=-I/usr/local/mysql/include
--libs=/usr/local/mysql/lib
I was then able to make without any errors. My make test (output below)
ended with : Failed 22/23 test scripts, 4.35% okay. 437/440 subtests
failed, 0.68% okay.
make: *** [test_dynamic] Error 2 .
I went ahead and did a make install, that worked. But then when I run
my script (happens to be a Bugzilla test script), I get:
perl: relocation error:
/usr/local/perl/lib/site_perl/5.8.7/i686-linux/auto/DBD/mysq l/mysql.so:
undefined symbol: mysql_init
What's up with that?
Andy
===================
make test output :
===================
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base.............install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/00base.t line 38
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 4-5
Failed 2/5 tests, 60.00% okay
t/10dsnlist..........install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/10dsnlist.t line 45
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
t/20createdrop.......install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/20createdrop.t line 45
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-5
Failed 5/5 tests, 0.00% okay
t/30insertfetch......install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/30insertfetch.t line 48
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/35limit............install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/35limit.t line 50
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-113
Failed 113/113 tests, 0.00% okay
t/35prepare..........install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/35prepare.t line 37
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-30
Failed 30/30 tests, 0.00% okay
t/40bindparam........install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 5) line 3
Compilation failed in require at (eval 5) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/40bindparam.t line 64
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-28
Failed 28/28 tests, 0.00% okay
t/40bindparam2.......install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 5) line 3
Compilation failed in require at (eval 5) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/40bindparam2.t line 64
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-13
Failed 13/13 tests, 0.00% okay
t/40blobs............install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/40blobs.t line 64
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40listfields.......install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/40listfields.t line 57
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-18
Failed 18/18 tests, 0.00% okay
t/40nulls............install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/40nulls.t line 50
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40numrows..........install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/40numrows.t line 59
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-25
Failed 25/25 tests, 0.00% okay
t/41bindparam........install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/41bindparam.t line 37
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/41blobs_prepare....install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/41blobs_prepare.t line 71
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-24
Failed 24/24 tests, 0.00% okay
t/42bindparam........install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/42bindparam.t line 37
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/50chopblanks.......install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/50chopblanks.t line 57
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-35
Failed 35/35 tests, 0.00% okay
t/50commit...........install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/50commit.t line 64
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-30
Failed 30/30 tests, 0.00% okay
t/60leaks............skipped
all skipped: $ENV{SLOW_TESTS} is not set or Proc::ProcessTable
not installed
t/dbdadmin...........install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/dbdadmin.t line 74
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-21
Failed 21/21 tests, 0.00% okay
t/insertid...........install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/insertid.t line 13
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-12
Failed 12/12 tests, 0.00% okay
t/param_values.......install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/param_values.t line 16
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-8
Failed 8/8 tests, 0.00% okay
t/prepare_noerror....install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/prepare_noerror.t line 22
dubious
Test returned status 2 (wstat 512, 0x200)
t/texecute...........install_driver(mysql) failed: Can't load
'/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/ar ch/auto/DBD/mysql/mysql.so'
for module DBD::mysql:
/usr/home/uscannenberg/.cpan/build/DBD-mysql-3.0007/blib/arc h/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_stmt_free_result at
/usr/local/perl/lib/5.8.7/i686-linux/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at t/texecute.t line 17
dubious
Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------ -------------------
t/00base.t 2 512 5 4 80.00% 4-5
t/10dsnlist.t 2 512 9 18 200.00% 1-9
t/20createdrop.t 2 512 5 10 200.00% 1-5
t/30insertfetch.t 2 512 11 22 200.00% 1-11
t/35limit.t 2 512 113 226 200.00% 1-113
t/35prepare.t 2 512 30 60 200.00% 1-30
t/40bindparam.t 2 512 28 56 200.00% 1-28
t/40bindparam2.t 2 512 13 26 200.00% 1-13
t/40blobs.t 2 512 11 22 200.00% 1-11
t/40listfields.t 2 512 18 36 200.00% 1-18
t/40nulls.t 2 512 11 22 200.00% 1-11
t/40numrows.t 2 512 25 50 200.00% 1-25
t/41bindparam.t 2 512 11 22 200.00% 1-11
t/41blobs_prepare.t 2 512 24 48 200.00% 1-24
t/42bindparam.t 2 512 11 22 200.00% 1-11
t/50chopblanks.t 2 512 35 70 200.00% 1-35
t/50commit.t 2 512 30 60 200.00% 1-30
t/dbdadmin.t 2 512 21 42 200.00% 1-21
t/insertid.t 2 512 12 24 200.00% 1-12
t/param_values.t 2 512 8 16 200.00% 1-8
t/prepare_noerror.t 2 512 ?? ?? % ??
t/texecute.t 2 512 9 18 200.00% 1-9
1 test skipped.
Failed 22/23 test scripts, 4.35% okay. 437/440 subtests failed, 0.68% okay.
make: *** [test_dynamic] Error 2
On 19-Sep-2006 Martin J. Evans wrote:
Edit the file dbdimp.c. On line 2390 you will see:
my_ulonglong rows= 0;
Move this line up to where the other variables are declared i.e. line 2350
e.g.
{
D_imp_sth(h);
D_imp_dbh_from_sth;
STRLEN slen;
bool bind_type_guessing;
char *sbuf = SvPV(statement, slen);
char *table;
char *salloc;
int htype;
my_ulonglong rows= 0; /* MOVED LINE FROM BELOW */
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
On 19-Sep-2006 Guillermo Gozalbes wrote:
> I can't compile the latest version of DBD:mysql downloaded from CPAN.
>
> -
> cpan> install DBD:mysql
> CPAN: Storable loaded ok
> Going to read /root/.cpan/Metadata
> Database was generated on Tue, 19 Sep 2006 04:32:30 GMT
> Running install for module DBD::mysql
> Running make for C/CA/CAPTTOFU/DBD-mysql-3.0007.tar.gz
> CPAN: Digest::SHA loaded ok
>
> CPAN: Module::Signature security checks disabled because Module::Signature
> not installed. Please consider installing the Module::Signature module.
> You may also need to be able to connect over the Internet to the public
> keyservers like pgp.mit.edu (port 11371).
>
> CPAN: Compress::Zlib loaded ok
> Checksum for /root/.cpan/sources/authors/id/C/CA/CAPTTOFU/DBD-
> mysql-3.0007.tar.gz ok
> Scanning cache /root/.cpan/build for sizes
> DBD-mysql-3.0007/
> DBD-mysql-3.0007/ChangeLog
> DBD-mysql-3.0007/constants.h
> DBD-mysql-3.0007/dbdimp.c
> DBD-mysql-3.0007/dbdimp.h
> DBD-mysql-3.0007/eg/
> DBD-mysql-3.0007/eg/prepare_memory_usage.pl
> DBD-mysql-3.0007/eg/proc_example1.pl
> DBD-mysql-3.0007/eg/proc_example2.pl
> DBD-mysql-3.0007/eg/proc_example3.pl
> DBD-mysql-3.0007/INSTALL.html
> DBD-mysql-3.0007/lib/
> DBD-mysql-3.0007/lib/Bundle/
> DBD-mysql-3.0007/lib/Bundle/DBD/
> DBD-mysql-3.0007/lib/Bundle/DBD/mysql.pm
> DBD-mysql-3.0007/lib/DBD/
> DBD-mysql-3.0007/lib/DBD/mysql/
> DBD-mysql-3.0007/lib/DBD/mysql/GetInfo.pm
> DBD-mysql-3.0007/lib/DBD/mysql/INSTALL.pod
> DBD-mysql-3.0007/lib/DBD/mysql.pm
> DBD-mysql-3.0007/lib/Mysql/
> DBD-mysql-3.0007/lib/Mysql/Statement.pm
> DBD-mysql-3.0007/lib/Mysql.pm
> DBD-mysql-3.0007/Makefile.PL
> DBD-mysql-3.0007/Makefile.PL.embedded
> DBD-mysql-3.0007/MANIFEST
> DBD-mysql-3.0007/MANIFEST.SKIP
> DBD-mysql-3.0007/META.yml
> DBD-mysql-3.0007/myld
> DBD-mysql-3.0007/mysql.xs
> DBD-mysql-3.0007/README
> DBD-mysql-3.0007/t/
> DBD-mysql-3.0007/t/00base.t
> DBD-mysql-3.0007/t/10dsnlist.t
> DBD-mysql-3.0007/t/20createdrop.t
> DBD-mysql-3.0007/t/30insertfetch.t
> DBD-mysql-3.0007/t/35limit.t
> DBD-mysql-3.0007/t/35prepare.t
> DBD-mysql-3.0007/t/40bindparam.t
> DBD-mysql-3.0007/t/40bindparam2.t
> DBD-mysql-3.0007/t/40blobs.t
> DBD-mysql-3.0007/t/40listfields.t
> DBD-mysql-3.0007/t/40nulls.t
> DBD-mysql-3.0007/t/40numrows.t
> DBD-mysql-3.0007/t/41bindparam.t
> DBD-mysql-3.0007/t/41blobs_prepare.t
> DBD-mysql-3.0007/t/42bindparam.t
> DBD-mysql-3.0007/t/50chopblanks.t
> DBD-mysql-3.0007/t/50commit.t
> DBD-mysql-3.0007/t/60leaks.t
> DBD-mysql-3.0007/t/dbdadmin.t
> DBD-mysql-3.0007/t/insertid.t
> DBD-mysql-3.0007/t/lib.pl
> DBD-mysql-3.0007/t/mysql.dbtest
> DBD-mysql-3.0007/t/param_values.t
> DBD-mysql-3.0007/t/._prepare_noerror.t
> DBD-mysql-3.0007/t/prepare_noerror.t
> DBD-mysql-3.0007/t/texecute.t
> DBD-mysql-3.0007/TODO
> Removing previously used /root/.cpan/build/DBD-mysql-3.0007
>
> CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-3.0007.tar.gz
>
> I will use the following settings for compiling and testing:
>
> cflags (mysql_config) = -I/usr/include/mysql -DBIG_JOINS=1
> embedded (mysql_config) =
> libs (mysql_config) = -L/usr/lib -lmysqlclient -lz -lcrypt -lnsl
> -lm
> mysql_config (guessed ) = mysql_config
> nocatchstderr (default ) = 0
> nofoundrows (default ) = 0
> ssl (guessed ) = 0
> Use of uninitialized value in printf at Makefile.PL line 172, line
> 103.
> test_user ( ) =
> 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.46 (for perl 5.008004 on i386-linux-thread-multi) installed in
> /usr/lib/perl5/auto/DBI/
> Writing Makefile for DBD::mysql
> CPAN: YAML loaded ok
> 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/usr/lib/perl5/auto/DBI/ -I/usr/include/mysql -DBIG_JOINS=1
> -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE
> -DTHREADS_HAVE_PIDS -DDEBIAN -fno-strict-aliasing -I/usr/local/include
> -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"3.0007\"
> -DXS_VERSION=\"3.0007\" -fPIC "-I/usr/lib/perl/5.8/CORE" dbdimp.c
> dbdimp.c: In function `mysql_st_internal_execute':
> dbdimp.c:2390: parse error before `rows'
> dbdimp.c:2467: `rows' undeclared (first use in this function)
> dbdimp.c:2467: (Each undeclared identifier is reported only once
> dbdimp.c:2467: for each function it appears in.)
> make: *** [dbdimp.o] Error 1
> /usr/bin/make -- NOT OK
> Running make test
> Can't test without successful make
> Running make install
> make had returned bad status, install seems impossible
> Failed during this command:
> CAPTTOFU/DBD-mysql-3.0007.tar.gz : make NO
>
> -
>
> In line 2390 of dbdimp.c i see the "rows" variable declaration in the code
> but not in declaration space. This is correct in C?
>
> How can solve it?
> I need to move the declaration to the top of function?
>
> Normally in install dbd:mysql using CPAN install.
>
> How i can find the patched package .gz?
>
> Regards,
>
> --
> --
> Guillermo Gozalbes
> Versus Soft S.L.
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org