RE: DBD::mysql install problem cygwin

2007-02-25 Thread Michael Janis 
Hi Brian,

This worked like a charm.  Sorry for the delayed reply; I wanted to attempt
both solutions suggested to me on this list; I appreciated your fast reply
and help in this matter.

Yours,

Michael Janis

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Brian Dessent
Sent: Wednesday, February 21, 2007 6:08 PM
To: cygwin@cygwin.com
Subject: Re: DBD::mysql install problem cygwin

Michael Janis wrote:

 In file included from dbdimp.c:20:
 dbdimp.h:23:45: mysqld_error.h: No such file or directory

I seem to recall this is a bug in the MySQL configury where it neglects
to install this header if you only build the client libs.  A workaround
would be to configure and install MySQL with --enable-server (even if
you plan to use the native Win32 server and not the Cygwin server), and
you should have the header installed.

Brian

--
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/


--
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/

RE: DBD::mysql install problem cygwin

2007-02-25 Thread Michael Janis 
Hi Yaakov,

Thank you for taking the time to create cygport and these ports which look
like they were created for my use.

Unfortunately I received errors at nearly every stage of the install process
and ultimately was unsuccessful.  However, I do appreciate your efforts.  I
would be happy to rediscover the (copious) output messages I received if
they will help you in creating / maintaining cygport.

Yours,

Michael

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Yaakov (Cygwin Ports)
Sent: Wednesday, February 21, 2007 7:46 PM
To: cygwin@cygwin.com
Subject: Re: DBD::mysql install problem cygwin

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256

Brian Dessent wrote:
 I seem to recall this is a bug in the MySQL configury where it neglects
 to install this header if you only build the client libs.  A workaround
 would be to configure and install MySQL with --enable-server (even if
 you plan to use the native Win32 server and not the Cygwin server), and
 you should have the header installed.

http://cygwin-ports.cvs.sourceforge.net/*checkout*/cygwin-ports/ports/libs/m
ysql/mysql-5.0.27-1.cygport
http://cygwin-ports.cvs.sourceforge.net/*checkout*/cygwin-ports/ports/perl/D
BD-mysql/perl-DBD-mysql-3.0006-1.cygport


Yaakov

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.5 (Cygwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFF3RIDpiWmPGlmQSMRCAUGAKDa0Wv2z3jvTxfD+VihvI6THWg0mACgoasn
ufbGe9oHj3hIEauZc2I4CWg=
=lk57
-END PGP SIGNATURE-

--
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/


--
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/

DBD::mysql install problem cygwin

2007-02-21 Thread Michael Janis 
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:

[EMAIL PROTECTED] ~/mysqlsource/DBD-mysql-4.001
$ cp /usr/local/mysql/bin/mysql_config . 
$ perl Makefile.PL --testhost=127.0.0.1 --testuser=x
--testpassword=x
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) = x
  testsocket    (default  ) = 
  testuser  (User's choice) = x

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/