Skip Menu |
 

This queue is for tickets about the DBD-mysql CPAN distribution.

Report information
The Basics
Id: 51784
Status: resolved
Priority: 0/
Queue: DBD-mysql

People
Owner: Nobody in particular
Requestors: cpanrt [...] nfwebsolutions.com
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: (no value)
Fixed in: 4.013



Subject: Fix for "Problem running c:\mysql\bin\MYSQLA~1.EXE - aborting ..." -- Windows specific
Download (untitled) / with headers
text/plain 1.4k
When running Makefile.PL for DBD::mysql v4.013, I received the error: "Problem running c:\mysql\bin\MYSQLA~1.EXE - aborting ..." After peeking at the Makefile.PL file, I noticed that it executed mysqladmin.exe with the parameter of 'version' to fetch the MySQLd server version and TCP port details. This was failing and the MySQL server showed in its query log why: 091121 4:06:30 86 Connect Access denied for user 'ODBC'@'localhost' (using password: NO) When configuring MySQL, I often secure the setup by removing the default accounts using: DROP USER ''@'%'; DROP USER ''@'localhost'; DROP USER 'root'@'127.0.0.1'; FLUSH PRIVILEGES; Keeping 'root'@'localhost' and progressing from there onwards. This has meant that mysqladmin.exe can nor longer login unless given a valid username and password (else it tries to login as ODBC as shown above). I therefore modified the Makefile.pl to bypass this issue, replacing: Line 778: my $v = qx($mysqladmin version); With: my $v; if ( defined $opt->{'testuser'} and defined $opt->{'testpassword'}) ) { $v = qx( sprintf('%s --user=%s --password=%s version', $mysqladmin , $opt->{'testuser'}, $opt->{'testpassword'}) ); } else { $v = qx($mysqladmin version); } The patch makes use of login information for the optional test stage of the module installation. I feel the above patch may also help others who are inadvertently experiencing the same problem as myself. Thank you. Kind regards, Zeeshan.
Added your patch - thank you!


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.