DBD::mysql install problem cygwin

Hi,

 

I am experiencing problems installing DBD-mysql with cygwin.  I closely
followed the instructions
(http://search.cpan.org/dist/DBD-mysql/lib/DBD/mysql/INSTALL.pod#Windows%2FC
ygWin) for installation via cygwin.  During the build MySQL clients under
Cygwin process I had to use make -j1 in order to avoid fork errors (this is
a dual core system, see below).

 

The output of build DBD::mysql:

 

user@compName ~/mysqlsource/DBD-mysql-4.001

$ cp /usr/local/mysql/bin/mysql_config . 

$ perl Makefile.PL --testhost=127.0.0.1 --testuser=xxxxx
--testpassword=xxxxx

I will use the following settings for compiling and testing:

 

  cflags        (mysql_config ) = -I/usr/local/mysql/include/mysql

  embedded      (mysql_config ) = 

  libs          (mysql_config ) = -L/usr/local/mysql/lib/mysql -lmysqlclient
-lz -lcrypt -lm

  mysql_config  (guessed      ) = mysql_config

  nocatchstderr (default      ) = 0

  nofoundrows   (default      ) = 0

  ssl           (guessed      ) = 0

  testdb        (default      ) = test

  testhost      (User's choice) = 127.0.0.1

  testpassword  (User's choice) = xxxxx

  testsocket    (default      ) = 

  testuser      (User's choice) = xxxxx

 

To change these settings, see 'perl Makefile.PL --help' and

'perldoc INSTALL'.

 

Using DBI 1.53 (for perl 5.008007 on cygwin-thread-multi-64int) installed in
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI/

Writing Makefile for DBD::mysql

 

$ make    

gcc -c  -I/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI
-I/usr/local/mysql/include/mysql -DDBD_MYSQL_INSERT_ID_IS_GOOD -g
-DPERL_USE_SAFE_PUTENV -fno-strict-aliasing -pipe -I/usr/local/include
-DUSEIMPORTLIB -O3   -DVERSION=\"4.001\" -DXS_VERSION=\"4.001\"
"-I/usr/lib/perl5/5.8/cygwin/CORE"   dbdimp.c

In file included from dbdimp.c:20:

dbdimp.h:23:45: mysqld_error.h: No such file or directory

dbdimp.c: In function `mysql_db_FETCH_attrib':

dbdimp.c:2319: warning: cast from pointer to integer of different size

dbdimp.c: In function `mysql_st_prepare':

dbdimp.c:2531: error: `ER_UNSUPPORTED_PS' undeclared (first use in this
function)

dbdimp.c:2531: error: (Each undeclared identifier is reported only once

dbdimp.c:2531: error: for each function it appears in.)

dbdimp.c: In function `mysql_st_FETCH_attrib':

dbdimp.c:4148: warning: cast from pointer to integer of different size

make: *** [dbdimp.o] Error 1

 

My system information is as follows:

Architecture: Core 2 Duo MacBook Pro

OS: Windows XP SP2 (via bootcamp)

Cygwin uname: CYGWIN_NT-5.1 compName 1.5.24(0.156/4/2) 2007-01-31 10:57 i686
Cygwin

Perl v.5.8.7 built for cygwin-thread-multi-64int

DBI 1.53 (for perl 5.008007 on cygwin-thread-mutli-64int)

Potential conflict: mingw/msys, installed in separate path

MySQL: Windows binary server version 5.0.27-community-nt

DBD-mysql: 4.001

 

$ make --version

GNU Make 3.81

Copyright (C) 2006  Free Software Foundation, Inc.

This is free software; see the source for copying conditions.

There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A

PARTICULAR PURPOSE.

 

This program built for i686-pc-cygwin

 

Can someone kindly shed some light on this?

 

Yours,

 

Michael Janis

UCLA Bioinformatics