Problem installing DBD::mysql on Cygwin

David Vergin <[email protected]> Mon, 17 Mar 2008 17:01:14 -0700
Newsgroups gmane.comp.db.mysql.perl
Message-ID <[email protected]>
Installing DBD::mysql in cygwin has always required a little extra 
effort. But Cygwin's upgrade to perl 5.10 wiped out a number of CPAN 
installs including DBD::mysql. This time around I'm stumped.

The instructions in the DBD::mysql-4.006 README file fail because 
mysql_config cannot be found.

Following the instructions in the DBD::mysql-4.006 INSTALL.html file 
starts better but then fails during compilation (see below).

I'm glad to post more or try things at this end to help sort this out, 
but at this point the solution is beyond my skills. TIA -- David

Results for INSTALL.html method for installing on cygwin:
---------------------8<----------------------------------------------
admin@GatewayM275 /c/Docume~1/dvergin/Desktop/DBD-mysql-4.006
$ cp /usr/local/mysql/bin/mysql_config .

admin@GatewayM275 /c/Docume~1/dvergin/Desktop/DBD-mysql-4.006
$ perl Makefile.PL --testhost=127.0.0.1
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  (default      ) =
   testsocket    (default      ) =
   testuser      (default      ) =

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

Using DBI 1.602 (for perl 5.010000 on cygwin-thread-multi-64int) 
installed in /usr/lib/perl5/site_perl/5.10/cygwin/auto/DBI/
Writing Makefile for DBD::mysql

admin@GatewayM275 /c/Docume~1/dvergin/Desktop/DBD-mysql-4.006
$ make
gcc -c  -I/usr/lib/perl5/site_perl/5.10/cygwin/auto/DBI 
-I/usr/local/mysql/include/mysql -DDBD_MYSQL_INSERT_ID_IS_GOOD -g 
-DPERL_USE_SAFE_PUTENV -U__STRICT_ANSI__ -fno-strict-aliasing 
-I/usr/local/include -DUSEIMPORTLIB -O3   -DVERSION=\"4.006\" 
-DXS_VERSION=\"4.006\"  "-I/usr/lib/perl5/5.10/cygwin/CORE"   dbdimp.c
dbdimp.c: In function `mysql_db_FETCH_attrib':
dbdimp.c:2269: warning: cast from pointer to integer of different size
dbdimp.c: In function `mysql_st_prepare':
dbdimp.c:2482: error: `ER_UNSUPPORTED_PS' undeclared (first use in this 
function)
dbdimp.c:2482: error: (Each undeclared identifier is reported only once
dbdimp.c:2482: error: for each function it appears in.)
dbdimp.c: In function `mysql_st_FETCH_attrib':
dbdimp.c:4073: warning: cast from pointer to integer of different size
make: *** [dbdimp.o] Error 1
---------------------8<----------------------------------------------

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]