problem with p5-DBD-mysql

[Mark Frank]

Sorry for the duplicate email.  This one has a more reasonable subject 
line.

Early last week I upgraded perl to 5.8.7 and the successfully used the
perl-after-upgrade script.  

##################################################################

	# perl -v
	
	This is perl, v5.8.7 built for i386-freebsd-64int
	(with 1 registered patch, see perl -V for more detail)
	
##################################################################


After CVSUPing my ports tree on July 9th (and again a few minutes ago) I
am not able to upgrade p5-DBD-mysql.  Here is the output of "portupgrade
p5-DBD-mysql":


##################################################################

--->  Upgrading 'p5-DBD-mysql-2.9008' to 'p5-DBD-mysql-3.0001' (databases/p5-DBD-mysql)
--->  Building '/usr/ports/databases/p5-DBD-mysql'
===>  Cleaning for mysql-client-4.0.24_1
===>  Cleaning for p5-DBI-1.48
===>  Cleaning for libtool-1.5.18
===>  Cleaning for perl-5.8.7
===>  Cleaning for p5-DBD-mysql-3.0001
===>  Vulnerability check disabled, database not found
===>  Extracting for p5-DBD-mysql-3.0001
=> Checksum OK for DBD-mysql-3.0001.tar.gz.
===>   p5-DBD-mysql-3.0001 depends on file: /usr/local/bin/perl5.8.7 - found
===>  Patching for p5-DBD-mysql-3.0001
===>   p5-DBD-mysql-3.0001 depends on file: /usr/local/bin/perl5.8.7 - found
===>   p5-DBD-mysql-3.0001 depends on file: /usr/local/lib/perl5/site_perl/5.8.7/mach/DBI.pm - found
===>   p5-DBD-mysql-3.0001 depends on file: /usr/local/bin/perl5.8.7 - found
===>   p5-DBD-mysql-3.0001 depends on shared library: mysqlclient.12 - found
===>  Configuring for p5-DBD-mysql-3.0001
I will use the following settings for compiling and testing:

  cflags        (mysql_config) = -I/usr/local/include/mysql -O -pipe
  embedded      (mysql_config) = 
  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.48 (for perl 5.008007 on i386-freebsd-64int) installed in /usr/local/lib/perl5/site_perl/5.8.7/mach/auto/DBI/
Writing Makefile for DBD::mysql
===>  Building for p5-DBD-mysql-3.0001
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/local/lib/perl5/site_perl/5.8.7/mach/auto/DBI/ -I/usr/local/include/mysql -O -pipe -DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -O -pipe -O -pipe    -DVERSION=\"3.0001\"  -DXS_VERSION=\"3.0001\" -DPIC -fPIC "-I/usr/local/lib/perl5/5.8.7/mach/CORE"   dbdimp.c
dbdimp.c: In function `mysql_db_FETCH_attrib':
dbdimp.c:2035: warning: cast from pointer to integer of different size
dbdimp.c: In function `mysql_st_fetch':
dbdimp.c:2775: error: `MYSQL_BIND' undeclared (first use in this function)
dbdimp.c:2775: error: (Each undeclared identifier is reported only once
dbdimp.c:2775: error: for each function it appears in.)
dbdimp.c: In function `mysql_st_FETCH_attrib':
dbdimp.c:3416: warning: cast from pointer to integer of different size
*** Error code 1

Stop in /usr/ports/databases/p5-DBD-mysql/work/DBD-mysql-3.0001.
*** Error code 1

Stop in /usr/ports/databases/p5-DBD-mysql.
** Command failed [exit code 1]: /usr/bin/script -qa /tmp/portupgrade32615.0 make
** Fix the problem and try again.
** Listing the failed packages (*:skipped / !:failed)
	! databases/p5-DBD-mysql (p5-DBD-mysql-2.9008)	(compiler error)
--->  Packages processed: 0 done, 0 ignored, 0 skipped and 1 failed

##################################################################


There has been another report of this same error on freebsd-questions so
I am not alone in this.  Any suggestions?

Mark
-- 
"The fix is only temporary...unless it works." - Red Green