Skip Menu |

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

Report information
The Basics
Id: 47938
Status: resolved
Priority: 0/
Queue: Net-Wire10
People
Owner: Nobody in particular
Requestors: manithody [...] gmail.com
Cc:
AdminCc:
Bug Information
Severity: Important
Broken in:
  • 1.01
  • 1.00
Fixed in: 1.02

History Show all quoted text
  Thu Jul 16 05:28:18 2009 shivashankara.manithody [...] barcap.com - Ticket created
Subject: MySQL version 3.22.34 connection issue
First of all, thank you for the fantastic package. It works perfectly fine with my MySQL version 4.x, but when I tried to connect to Version 3.22.34 I got following error: Use of uninitialized value in left bitshift (<<) at /home/shiva/lib/Net/Wire10.pm line 1412. Use of uninitialized value in concatenation (.) or string at /home/shiva/lib/Net/Wire10.pm line 1414. I have enabled debug and attached the output for your reference.
Subject: mysql_error.txt
/home/shiva $ ./mysql_insert.pl Connecting to: xx.xx.xx.xx:3306/tcp Bytes in receive buffer: 28 Result :24 bytes of :0:24 Result :24 bytes of :1:0 Result :24 bytes of :2:0 Shifting a new macket totalling 28 bytes into the macket queue. Result :24 bytes of :0:24 Result :24 bytes of :1:0 Result :24 bytes of :2:0 Protocol Version: 10 Server version: 3.22.34 Server thread id: 4653 Result :44 bytes of :0:44 Result :44 bytes of :1:0 Server capabilities (ignored): 0x2c Use of uninitialized value in left bitshift (<<) at /home/shiva/lib/Net/Wire10.pm line 1412. Result :0 Use of uninitialized value in concatenation (.) or string at /home/shiva/lib/Net/Wire10.pm line 1414. bytes of :0: Server language (ignored): 0 'x' outside of string in unpack at /home/shiva/lib/Net/Wire10.pm line 1409.
  Thu Jul 16 05:43:34 2009 shivashankara.manithody [...] barcap.com - Correspondence added
Added more detailed debug info
************************************************************************************* With Debug - 1 ************************************************************************************* F:\Temp>perl insert.pl Connecting to: 10.65.194.85:3306/tcp Bytes in receive buffer: 28 Shifting a new macket totalling 28 bytes into the macket queue. Protocol Version: 10 Server version: 3.22.34 Server thread id: 5289 Server capabilities (ignored): 0x2c Use of uninitialized value in left bitshift (<<) at C:/Perl/5.10.0.1004/lib/Net/ Wire10.pm line 1412. Server language (ignored): 0 'x' outside of string in unpack at C:/Perl/5.10.0.1004/lib/Net/Wire10.pm line 1409. ************************************************************************************* With Debug - 2 ************************************************************************************* F:\Temp>perl sms.pl Net::Wire10::_check_received_macket_type(): -> serial: 0 -> length: 24 -> type: HANDSHAKE -> data: 18 00 00 00 0A 33 2E 32 32 2E 33 34 00 B6 14 01 .....3.22.34.... 00 41 69 70 76 22 40 5E 36 00 2C 00 .Aipv...6.,. Use of uninitialized value in left bitshift (<<) at C:/Perl/5.10.0.1004/lib/Net/ Wire10.pm line 1412. 'x' outside of string in unpack at C:/Perl/5.10.0.1004/lib/Net/Wire10.pm line 1409. ************************************************************************************* With Debug - 4 ************************************************************************************* F:\Temp>perl sms.pl Net::Wire10::_receive_packet_data(): 18 00 00 00 0A 33 2E 32 32 2E 33 34 00 B9 14 01 .....3.22.34.... 00 67 26 23 7D 6E 2F 3E 28 00 2C 00 .g...n..(.,. Use of uninitialized value in left bitshift (<<) at C:/Perl/5.10.0.1004/lib/Net/ Wire10.pm line 1412. 'x' outside of string in unpack at C:/Perl/5.10.0.1004/lib/Net/Wire10.pm line 14 09.
  Thu Jul 16 05:43:36 2009 The RT System itself - Status changed from 'new' to 'open'
  Sun Aug 23 07:27:35 2009 DUBEX [...] cpan.org - Correspondence added
You're welcome, hope you find it useful! Apologies for the wait, seems the CPAN tracker doesn't send out email notifications, weird. I couldn't find a 3.2 server to test against, it's no longer available from MySQL: http://downloads.mysql.com/archives.php?p=mysql-3.23 The debug data was very helpful though, thanks! The faulty code was written under the assumption that pre-4.1 servers use another protocol version than 10. Apparently that's not true, even though the protocol is radically different, the version number hasn't changed. I've added some sanity checks which should hopefully give us much more meaningful error messages. I couldn't find any documentation for the v3.22 revision of the protocol, so that's about all I can do for now (sorry).
  Sun Aug 23 07:27:40 2009 DUBEX [...] cpan.org - Status changed from 'open' to 'resolved'
  Sun Aug 23 07:29:01 2009 DUBEX [...] cpan.org - Ticket deleted
  Sun Aug 23 07:29:05 2009 DUBEX [...] cpan.org - Status changed from 'deleted' to 'open'
  Sun Aug 23 07:29:35 2009 DUBEX [...] cpan.org - Status changed from 'open' to 'resolved'
  Tue Aug 25 08:53:45 2009 DUBEX [...] cpan.org - Fixed in 1.02 added
  Tue Aug 25 08:53:45 2009 DUBEX [...] cpan.org - Fixed in 1.01 deleted
  Tue Aug 25 08:53:45 2009 DUBEX [...] cpan.org - Broken in 1.00 added