Bug #94838 for DBD-mysql: Makefile.PL cannot connect to mysql on Windows using environment variables

Thu Apr 17 13:20:00 2014 CHORNY [...] cpan.org - Ticket created

Subject:

Makefile.PL cannot connect to mysq on Windows

I'm checking for problems with Strawberry Perl generation. Show quoted text

>SET

DBD_MYSQL_TESTDB=testdb DBD_MYSQL_TESTHOST=localhost DBD_MYSQL_TESTPASSWORD=... DBD_MYSQL_TESTPORT=3306 DBD_MYSQL_TESTUSER=testuser ... Show quoted text

>perl Makefile.PL

C:\PROGRA~1\MySQL\MYSQLS~1.5\bin\MYSQLA~1.EXE: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)' Problem running C:\PROGRA~1\MySQL\MYSQLS~1.5\bin\MYSQLA~1.EXE - aborting ... Result is same if I don't set environment variables. -- Alexandr Ciornii, http://chorny.net

Wed Aug 27 12:58:34 2014 CHORNY [...] cpan.org - Broken in 4.028 added

Wed Aug 27 21:46:45 2014 CHORNY [...] cpan.org - Correspondence added

This happens because sub win32_mysql_config is called before sub Configure. -- Alexandr Ciornii, http://chorny.net

Wed Jan 28 05:08:26 2015 MICHIELB [...] cpan.org - Taken

Thu Jan 29 09:59:42 2015 MICHIELB [...] cpan.org - Subject changed from 'Makefile.PL cannot connect to mysq on Windows' to 'Makefile.PL cannot connect to mysql on Windows using environment variables'

Thu Jan 29 14:42:11 2015 MICHIELB [...] cpan.org - Correspondence added

On Wed Aug 27 21:46:45 2014, CHORNY wrote: Show quoted text

> This happens because sub win32_mysql_config is called before sub Configure. >

Thanks for your report. I have now added https://github.com/perl5-dbi/DBD-mysql/commit/1f836e365f1bf4099bd79f2468e9d97a5be1b222 which fixes *this* issue but I found two more: * env variable DBD_MYSQL_CONFIG does not work * on Windows, mysql_config is not found if in PATH -- Michiel

Thu Jan 29 14:42:11 2015 The RT System itself - Status changed from 'new' to 'open'

Sun Feb 01 16:06:40 2015 MICHIELB [...] cpan.org - Correspondence added

Thanks, I pushed this now into master! -- Michiel

Sun Feb 01 16:06:52 2015 MICHIELB [...] cpan.org - Status changed from 'open' to 'resolved'