An announcement and a request for assistance...

Strawberry 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
[email protected]

%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
[email protected]

%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/[email protected]