misc/83225: Building problen in p5-DBD-mysql40-3.0001 .

[Joe Horn]

>Number:         83225
>Category:       misc
>Synopsis:       Building problen in p5-DBD-mysql40-3.0001 .
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Sun Jul 10 16:10:20 GMT 2005
>Closed-Date:
>Last-Modified:
>Originator:     Joe Horn
>Release:        5.4-RELEASE-p3
>Organization:
MI, CHU, Taiwan
>Environment:
FreeBSD Leo.mi.chu.edu.tw 5.4-RELEASE-p3 FreeBSD 5.4-RELEASE-p3 #5: Fri Jul  1 00:50:14 CST 2005     root at Leo.mi.chu.edu.tw:/usr/obj/usr/src/sys/Leo  i386
>Description:
I am still using MySQL 4.0 on my box .
But the original p5-DBD-mysql seems only support MySQL 4.1 ( messages below show that!? )

  Port:   p5-DBD-mysql-3.0001
  Path:   /usr/ports/databases/p5-DBD-mysql
  Info:   MySQL driver for the Perl5 Database Interface (DBI)
  Maint:  skv at FreeBSD.org
  B-deps: mysql-client-4.1.12 p5-DBI-1.48 perl-5.8.7
  R-deps: mysql-client-4.1.12 p5-DBI-1.48 perl-5.8.7
  WWW:    http://search.cpan.org/dist/DBD-mysql/

So I should change and upgrade p5-DBD-mysql-2.9008 to 5-DBD-mysql40-3.0001 , right ?
But it still shows this error while building :
===>  Building for p5-DBD-mysql40-3.0001
...... ( some messages ignored )
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

Because I have others machine running MySQL 4.1 , I found that the struct named MYSQL_BIND is not been declared in mysql.h if the MySQL version is 4.0 .

Maybe we need the old version of p5-DBD-mysql ?
>How-To-Repeat:
      
>Fix:
      
>Release-Note:
>Audit-Trail:
>Unformatted: