DBD::mysql install problem cygwin

------=_NextPart_000_00B5_01C755D8.C14797E0
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: 7bit

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








------=_NextPart_000_00B5_01C755D8.C14797E0--