Skip Menu |

This queue is for tickets about the Net-MySQL CPAN distribution.

Report information
The Basics
Id: 20160
Status: open
Priority: 0/
Queue: Net-MySQL

People
Owner: Nobody in particular
Requestors: anders [...] hig.se
Cc:
AdminCc:

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



Subject: Cannot connect to a Mysql 3.23.47 in Net::MySQL 0.09
#!/usr/local/bin/perl use strict; use Net::MySQL; my $mysql = Net::MySQL->new( hostname => 'test-host', debug => 1, database => 'test', user => 'test', password => 'badpassword' ); gives: Use INET Socket: test-host 3306/tcp Net::MySQL::_get_server_information(): 28 00 00 00 0A 33 2E 32 33 2E 34 37 00 64 31 00 (....3.23.47.d1. 00 39 6B 30 4C 6B 59 5C 41 00 0C 00 08 02 00 00 .9k0LkY.A....... 00 00 00 00 00 00 00 00 00 00 00 00 ............ Protocol Version: 10 Server Version: 3.23.47 Salt: 9k0LkY\A Net::MySQL::_send_login_message(): 3F 00 00 01 0D A6 03 00 00 00 00 01 21 00 00 00 ?............... 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 00 00 00 00 74 65 73 74 00 14 96 05 61 34 5A C5 ....test....a4Z. D4 79 51 49 A7 3E 0A F1 E6 31 A5 93 9E 2E 74 65 .yQI.....1....te 73 74 00 st. Net::MySQL::_request_authentication(): 41 00 00 02 FF 15 04 41 63 63 65 73 73 20 64 65 A......Access.de 6E 69 65 64 20 66 6F 72 20 75 73 65 72 3A 20 27 nied.for.user..' 40 65 78 61 63 74 6F 72 2E 68 69 67 2E 73 65 27 .exactor.hig.se' 20 28 55 73 69 6E 67 20 70 61 73 73 77 6F 72 64 .(Using.password 3A 20 4E 4F 29 ..NO) Access denied for user: '@exactor.hig.se' (Using password: NO) at ./1.pl line 5 Error occurs on 2 hosts: This is perl, v5.8.7 built for sun4-solaris SunOS scriptor 5.10 Generic_118822-26 sun4u sparc SUNW,Sun-Fire-280R This is perl, v5.8.8 built for i586-linux-thread-multi Linux exactor 2.6.16.13-4-smp #1 SMP Wed May 3 04:53:23 UTC 2006 i686 i686 i386 GNU/Linux
On Mi. 28. Jun. 2006, 07:34:58, guest wrote: Show quoted text
> Access denied for user: '@exactor.hig.se' (Using password: NO) at ./1.pl > line 5 >
Hi, I've the same problem here with HP-UX 11i and Net::MySQL 0.0.9. BUT, the version 0.0.8 does it, so the latest changes caused the problem. Greets, Andi
From: krisodb [...] gmail.com
You need to keep working with version 0.08. 0.09 is updated using the new algorithme which is needed from mysql4.1 onwards. A proper solution would be checking the version first and then use the proper function. Those should be minor updates, the code for the calculation is still there. On Wed Jun 28 07:34:58 2006, guest wrote: Show quoted text
> #!/usr/local/bin/perl > use strict; > use Net::MySQL; > > my $mysql = Net::MySQL->new( > hostname => 'test-host', > debug => 1, > database => 'test', > user => 'test', > password => 'badpassword' > ); > > gives: > > Use INET Socket: test-host 3306/tcp > Net::MySQL::_get_server_information(): > 28 00 00 00 0A 33 2E 32 33 2E 34 37 00 64 31 00 (....3.23.47.d1. > 00 39 6B 30 4C 6B 59 5C 41 00 0C 00 08 02 00 00 .9k0LkY.A....... > 00 00 00 00 00 00 00 00 00 00 00 00 ............ > Protocol Version: 10 > Server Version: 3.23.47 > Salt: 9k0LkY\A > Net::MySQL::_send_login_message(): > 3F 00 00 01 0D A6 03 00 00 00 00 01 21 00 00 00 ?............... > 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ > 00 00 00 00 74 65 73 74 00 14 96 05 61 34 5A C5 ....test....a4Z. > D4 79 51 49 A7 3E 0A F1 E6 31 A5 93 9E 2E 74 65 .yQI.....1....te > 73 74 00 st. > Net::MySQL::_request_authentication(): > 41 00 00 02 FF 15 04 41 63 63 65 73 73 20 64 65 A......Access.de > 6E 69 65 64 20 66 6F 72 20 75 73 65 72 3A 20 27 nied.for.user..' > 40 65 78 61 63 74 6F 72 2E 68 69 67 2E 73 65 27 .exactor.hig.se' > 20 28 55 73 69 6E 67 20 70 61 73 73 77 6F 72 64 .(Using.password > 3A 20 4E 4F 29 ..NO) > Access denied for user: '@exactor.hig.se' (Using password: NO) at ./1.pl > line 5 > > > Error occurs on 2 hosts: > This is perl, v5.8.7 built for sun4-solaris > SunOS scriptor 5.10 Generic_118822-26 sun4u sparc SUNW,Sun-Fire-280R > > This is perl, v5.8.8 built for i586-linux-thread-multi > Linux exactor 2.6.16.13-4-smp #1 SMP Wed May 3 04:53:23 UTC 2006 i686 > i686 i386 GNU/Linux