Problems when "make" in DBD::mysql

Problems when "make" in DBD::mysql

am 08.09.2007 11:51:35 von francescomoi

Hi.

Trying to install 'DBD::mysql' on Linux, I'm getting errors when
'make'.

1) Installed DBI-1.59
2) Installed Data-ShowTable-3.3
3) Downloaded 'Msql-Mysql-modules-1.2219'
4) []# perl Makefile.PL
----------------------------
Which drivers do you want to install?

1) MySQL only
2) mSQL only (either of mSQL 1 or mSQL 2)
3) MySQL and mSQL (either of mSQL 1 or mSQL 2)

4) mSQL 1 and mSQL 2
5) MySQL, mSQL 1 and mSQL 2

Enter the appropriate number: [3] 1

Do you want to install the MysqlPerl emulation? You might keep your
old
Mysql module (to be distinguished from DBD::mysql!) if you are
concerned
about compatibility to existing applications! [n]
WARNING: PL_FILES takes a hash reference not a array reference.
Please inform the author.
Checking if your kit is complete...
Looks good
Note (probably harmless): No library found for -lgz
Using DBI 1.59 (for perl 5.008008 on i386-linux-thread-multi)
installed in /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/
auto/DBI/
Writing Makefile for DBD::mysql
Writing Makefile for Msql-Mysql-modules
---------------------------------

5) []# make
------------------
Warning: duplicate function definition 'rows' detected in mysql.xs,
line 407
gcc -c -I/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/aut o/
DBI -I/usr/local/mysql/include/mysql -I../dbd -I/usr/lib/perl5/
site_perl/5.8.8/i386-linux-thread-multi/auto/DBI -I/usr/lib/
perl5/5.8.8/i386-linux-thread-multi -D_REENTRANT -D_GNU_SOURCE -fno-
strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/
include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm
-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-
protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -
fasynchronous-unwind-tables -DVERSION=\"2.0419\" -DXS_VERSION=
\"2.0419\" -fPIC "-I/usr/lib/perl5/5.8.8/i386-linux-thread-multi/
CORE" -DDBD_MYSQL mysql.c
mysql.xs: In function 'XS_DBD__mysql__dr__ListDBs':
mysql.xs:98: warning: passing argument 3 of 'mysql_dr_error' discards
qualifiers from pointer target type
mysql.xs: In function 'XS_DBD__mysql__dr__admin_internal':
mysql.xs:138: warning: passing argument 3 of 'mysql_dr_error' discards
qualifiers from pointer target type
mysql.xs:144: error: too few arguments to function 'mysql_shutdown'
mysql.xs:186: warning: passing argument 3 of 'mysql_dr_error' discards
qualifiers from pointer target type
mysql.xs: In function 'XS_DBD__mysql__db__InsertID':
mysql.xs:234: warning: format '%lu' expects type 'long unsigned int',
but argument 5 has type 'my_ulonglong'
mysql.xs: In function 'XS_DBD__mysql__db__ListDBs':
mysql.xs:250: warning: passing argument 3 of 'mysql_dr_error' discards
qualifiers from pointer target type
mysql.xs: In function 'XS_DBD__mysql__db__ListTables':
mysql.xs:271: warning: passing argument 3 of 'mysql_dr_error' discards
qualifiers from pointer target type
make[1]: *** [mysql.o] Error 1
make[1]: Leaving directory `/root/install/Msql-Mysql-modules-1.2219/
mysql'
make: *** [subdirs] Error 2
-----------------------------------------

My data:
- OS: Fedora Core 7
- MySQL 5.0.45
- gcc version 4.1.2 20070502 (Red Hat 4.1.2-12)
- /usr/local/mysql/include/mysql DOES exist
- /usr/local/mysql/bin is within PATH

I also tried with:
perl -MCPAN -e 'install "DBD::mysql"'
but got another error:
--------
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/75supported_sql.t 2 512 16 32 200.00% 1-16
t/80procs.t 2 512 ?? ?? % ??
t/insertid.t 2 512 16 32 200.00% 1-16
t/multi_statement.t 255 65280 7 14 200.00% 1-7
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
t/utf8.t 2 512 ?? ?? % ??
2 tests skipped.
Failed 26/28 test scripts, 7.14% okay. 423/426 subtests failed, 0.70%
okay.
make: *** [test_dynamic] Error 2
/usr/bin/make test -- NOT OK
Running make install
make test had returned bad status, won't install without force
----------------

Any suggestion?