Net-MySQL - Bad Handshake

Posted on Sun Feb 25 13:51:42 2007 by vk
Bad Handshake
Hi, I had been trying to use Net::MySQL with mysql on Ubuntu 6.06.2. when I try to run a test script
to just connect and do some basic stuff it gives Bad Handshake when I try to debug.
Please let me know what is going here. I have pasted the trace as the following:

Use UNIX Socket: /var/run/mysqld/mysqld.sock
Net::MySQL::_get_server_information():
4D 00 00 00 0A 35 2E 30 2E 32 32 2D 44 65 62 69 M....5.0.22-Debi
61 6E 5F 30 75 62 75 6E 74 75 36 2E 30 36 2E 32 an_0ubuntu6.06.2
2D 6C 6F 67 00 1F 00 00 00 61 3D 4C 47 5E 25 3A -log.....a=LG.%.
34 00 2C A2 08 02 00 00 00 00 00 00 00 00 00 00 4.,.............
00 00 00 00 35 4D 62 29 41 4A 33 5E 61 4C 37 6F ....5Mb)AJ3.aL7o
00 .
Protocol Version: 10
Server Version: 5.0.22-Debian_0ubuntu6.06.2-log
Salt: a=LG^%:45Mb)AJ3^aL7o
Net::MySQL::_send_login_message():
42 00 00 01 0D A6 03 00 00 00 00 01 21 00 00 00 B...............
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00 00 00 00 76 69 6A 61 79 00 14 FA 04 A8 BC 5C ....vy.......
C6 AA 65 4F BD 19 87 A9 80 21 1D 72 5F 58 D3 53 ..eO.......r_X.S
43 4F 4F 42 59 00 COOBY.
Net::MySQL::_request_authentication():
01 00 00 02 FE .....
connect database
Net::MySQL::_execute_command():
3E 00 00 00 03 0A 09 49 4E 53 45 52 54 20 49 4E .......INSERT.IN
54 4F 20 74 61 62 6C 65 6E 61 6D 65 20 28 66 69 TO.tablename.(fi
72 73 74 2C 20 6E 65 78 74 29 20 56 41 4C 55 45 rst,.next).VALUE
53 20 28 27 48 65 6C 6C 6F 27 2C 20 27 57 6F 27 S.('Hello',.'Wo'
29 0A ).
Net::MySQL::_execute_command():
16 00 00 03 FF 13 04 23 30 38 53 30 31 42 61 64 ........08S01Bad
20 68 61 6E 64 73 68 61 6B 65 .handshake
...Affected row: 0

-vijay
Write a response