tphyahoo has asked for the wisdom of the Perl Monks concerning the following question:
http://www.cpanforum.com/posts/3561
(I actually actually tried posting at cpanforum first, but the cpanforum submission feature appears to be broken)
Basically, I followed the instructions for the cygwin install in the documentation at
http://search.cpan.org/src/RUDY/DBD-mysql-2.9008/INSTALL.html#windows_cygwin
*****************
UPDATE: that was for an old version of DBD::mysql. Maybe that was the problem. The newer version is at
stay tuned....
*****************
UPDATE: you can probably skip this next bit, as it refers to my attempt to follow the documentation in the out of date DBD::mysql.
Following this to the letter requires the source for mysql version 3.23.54a, which isn't even available any more from mysql.
http://downloads.mysql.com/archives.php?p=mysql-4.0
(they're not even allowing source downloads for mysql4 anymore.)
I attempted the install under cygwin with the latest mysql (mysql5). Makefile.PL went okay.
make failed with
*****************hartman@ds0014 ~/.cpan/build/DBD-mysql-4.001 $ make gcc -c -I/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI -I/usr/local/my +sql/include/mysql -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -DPERL_USE_SAFE_P +UTENV -fno- strict-aliasing -pipe -I/usr/local/include -DUSEIMPORTLIB -O3 -DVERS +ION=\"4.001\" -DXS_VERSION=\"4.001\" "-I/usr/lib/perl5/5.8/cygwin/CO +RE" dbdim p.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 thi +s function) dbdimp.c:2531: error: (Each undeclared identifier is reported only onc +e 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
UPDATE: okay, start reading again.
The current documentation of DBD::mysql suggests installation via ppm for win32.
I normally work under activestate, but in this case I thought cygwin would be better, because I had a script that needed to be modified to run on windows, and a number of dependency modules didn't compile easily under Active State to my recollection. So now, it seems I have everything working nicely under cygwin, except DBD::mysql, which I really need.
So, first question: given DBD::mysql installed via ppm, is there a way I can access this from a perl script run under cygwin?
Second question, barring that, has nyone been able to get DBD::mysql to work under cygwin for a recent version, or can point me to a way to download the old source? Or other constructive feedback?
Thanks in advance!
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: can't install DBD::mysql under cygwin for mysql5
by shmem (Chancellor) on Feb 08, 2007 at 15:22 UTC | |
by tphyahoo (Vicar) on Feb 08, 2007 at 15:30 UTC | |
by shmem (Chancellor) on Feb 08, 2007 at 15:45 UTC | |
Re: can't install DBD::mysql under cygwin for mysql5
by bingos (Vicar) on Feb 08, 2007 at 18:05 UTC |