Message-Id: <200702220140.l1M1ehY8015740@exmails2.chem.ucla.edu>
Reply-To: <mjanis AT chem DOT ucla DOT edu>
From: "Michael Janis" <mjanis AT chem DOT ucla DOT edu>
To: <cygwin AT cygwin DOT com>
Subject: DBD::mysql install problem cygwin
Date: Wed, 21 Feb 2007 17:40:09 -0800
MIME-Version: 1.0
Content-Type: text/plain; 	charset="iso-8859-1"
In-Reply-To: 
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Content-Transfer-Encoding: 8bit

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).  Apologies if this is not a true cygwin
problem, but it may stem from my cygwin installation on a dual core machine.

The output of build DBD::mysql:

user AT 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

 
--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/