comment on

I'm having an issue similar in spirit, if not in every detail, to that described in

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

DBD::mysql

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
[download]

*****************

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!

In reply to can't install DBD::mysql under cygwin for mysql5 by tphyahoo

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		`&`
	<		`<`
	>		`>`
	[		`[`
	]		`]`

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.