Curtis Jewell | 4 Jun 14:05 2009
Picon

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.
(Continue reading)

Curtis Jewell | 4 Jun 14:13 2009
Picon

Re: An announcement and a request for assistance...

On Thu, 04 Jun 2009 06:05 -0600, "Curtis Jewell"
<lists.perl.DBD-mysql <at> csjewell.fastmail.us> wrote:
> 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)

I forgot to mention where to get it -
http://csjewell.comyr.com/perl/strawberryperlbeta.html is the location
to go to.

--Curtis

--
Curtis Jewell
swordsman <at> 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 <at> 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]
(Continue reading)

Curtis Jewell | 13 Jun 08:19 2009
Picon

Problems with testing DBD::mysql

I finally found a reasonably easy way to build DBD::mysql on Strawberry
Perl [you copy libmysql.lib -> libmysql.a and zlib.lib -> libzlib.a,
then run RKOBES's mysql_config_win32.pl script with
s/-lmysqlclient/-lmysql/ and then perl Makefile.PL && dmake runs
easily.] - I'll try and send a patch to the Makefile.PL when I get a
chance (probably within the next few days), but I'm running into a
failing test when I try to install anything above 4.006. 

[I have an anonymous-user set up on the database - I know this isn't
normal, I'm just getting the module to test correctly.]

An attempt to run a compile and test with 4.011 is shown below, along
with the versions of mysql and perl being used:

C:\DBD-mysql-4.011>perl Makefile.PL
Unknown option: testdb
Unknown option: testhost
Unknown option: testuser
Use of uninitialized value $ENV{"USER"} in concatenation (.) or string
at Makefi
le.PL line 491, <PIPE> line 24.
Use of uninitialized value in concatenation (.) or string at Makefile.PL
line 49
1, <PIPE> line 24.

PLEASE NOTE:

For 'make test' to run properly, you must ensure that the
database user '' can connect to your MySQL server
and has the proper privileges that these tests require such
(Continue reading)

Patrick Galbraith | 19 Jun 20:37 2009
Picon

DBD::mysql 4.012 Released!

Hi all!

I'm pleased to announce a release of DBD::mysql 4.012!

This release includes several fixes and modifications (per ChangeLog):

* Patch to bind_type_guessing from Craigslist, Thanks to Chris! 
Happiness is no quoted numbers. Fixed ChopBlanks to work with 
bind_type_guessing

* Patch for win32 strawberry build Thanks to Curtis Jewell! Windows 
needs love

* Patch for auto-reconnect to set active flag Thanks to Doug Fischer!

* Fixed bug 32464 http://bugs.mysql.com/bug.php?id=32464.
See also:  https://rt.cpan.org/Ticket/Display.html?id=46308

Add connection flag mysql_no_autocommit_cmd which users of MySQL Proxy 
can use to prevent 'set autocommit=#' from being issued by the driver. 
'perldoc DBD::mysql' to see how to use this new flag. Thanks to Russell 
Glaue for reporting this!

* Added bind-type-guessing options to Makefile.PL so the entire test 
suite can be run with bind_type_guessing set.

A little more info on the changes:

    * bind_type_guessing - this is a database handle attribute you can 
set (see perldoc DBD::mysql) by setting $dbh->{bind_type_guessing} = 1. 
(Continue reading)


Gmane