An announcement and a request for assistance...
am 04.06.2009 14:05:03 von Curtis JewellStrawberry Perl (a release of Perl, a compiler toolchain, and additional
modules for Win32 systems) is now including DBD::mysql in the modules it
installs as of July 2009 Beta 2 (the betas for the versions of
Strawberry that will get released in July - 5.10.0.6 and 5.8.9.2)
Part of the reason for this is that we want to have first class support
for open-source databases out of the box. And we're getting there.
In that light, I have a few requests for the good people here:
1) If you can test it with your real-life scripts that use DBD::mysql,
it'd be appreciated. Report back any bugs. I ran the tests that were
included with DBD::mysql 4.005 on my own system whem I was adding it in,
and they passed, but that only makes me so confident. (IIRC, I tested it
against the 5.1.34-community version, available as
mysql-5.1.34-win32.msi - not the Windows Essentials build of that
version.)
I have to admit, I don't use MySQL myself.
2) Right now, the version of DBD::mysql that's included is 4.005 -
because that's what was on the uwinnipeg repository as a PPM that was
already built. (I converted the PPM to a PAR file, took out the html
files, and installed that.) I found some directions in a few different
places for building DBD::mysql, but I could never get version 4.011 to
run the "make"step - (it's actually "dmake", and that's provided as
part of the provided compiler toolchain) successfully. Again, note the
version of MySQL stated above. Assistance would be welcome in getting a
current version of DBD::mysql to build on my system, because what I can
build or install successfully is what will get installed in Strawberry.
I'll try again soon and send up what the errors where, and what I did -
probably within the next few days.
3) In that light, DBD::mysql should build more naturally against
Strawberry - I should be able to do a sequence of steps such as this
example (which is taken from the DBD::Pg svn repository, and which I
used to make the version of DBD::Pg that's included) and make it work.
I should not HAVE to edit the generated Makefile!
-------------------------------
* Strawberry Perl issues:
You'll need to create a .a library from the .dll before
running the Makefile.PL, by running pexports and dlltool
as shown below, within the C:\Program Files\PostgreSQL\8.3\bin
directory:
pexports libpq.dll > libpq.def
dlltool -dllname libpq.dll --def libpq.def --output-lib ..\lib\libpq.a
Then you'll need to set the required environment:
set PATH=C:\PROGRA~1\PostgreSQL\8.3\bin;%PATH%
set DBI_DSN=dbi:Pg:dbname=testdb
set DBI_USER=*PostgreSQL username*
set DBI_PASS=*PostgreSQL password*
set POSTGRES_HOME=C:/PROGRA~1/PostgreSQL/8.3
set POSTGRES_INCLUDE=C:/PROGRA~1/PostgreSQL/8.3/include
set POSTGRES_LIB=C:/PROGRA~1/PostgreSQL/8.3/lib
Note that the username and password are the ones for PostgreSQL, NOT the
ones for the Windows account that the PostgreSQL installer creates to
run
the service safely.
(You may wish to set these variables on the system level, by going to
Control Panel > System > Advanced tab > Environment Variables button and
adding the environment variables there.)
Now the Makefile.PL can be ran:
perl Makefile.PL
dmake
dmake test
dmake install
-------------------------------
Thank you in advance for any help!
--
Curtis Jewell
swordsman@csjewell.fastmail.us
%DCL-E-MEM-BAD, bad memory
-VMS-F-PDGERS, pudding between the ears
[I use PC-Alpine, which deliberately does not display colors and
pictures in HTML mail]
--
Curtis Jewell
swordsman@csjewell.fastmail.us
%DCL-E-MEM-BAD, bad memory
-VMS-F-PDGERS, pudding between the ears
[I use PC-Alpine, which deliberately does not display colors and pictures in HTML mail]
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org