allowOldPasswords not working

[cfsalguero]

Old passwords support is not working.

Steps to reproduce:

1. Add old_passwords=1 to my.cnf & restart MySQL
2. Create a new user and set the password using OLD_PASSWORD("new pass")
3. Try to execute a query and it will fail.

If the user was created BEFORE restarting with old_passwords=1, it can connect/execute queries without problems.

[julienschmidt]

Does this work with other MySQL drivers / connectors e.g. in PHP, Java or C?
This sounds more like an MySQL issue to me.

@xaprb any idea what might be the problem?

[xaprb]

Not sure... we have this driver in some agent software in VividCortex, and it is connecting to old_password customer systems without problem. I wonder if there is something else specific about the OP's systems causing an edge case to hit.

[lufia]

I encountered this issue too.
I ran a query, then returns an error

ERROR 1045: Access denied for user 'user'@'localhost' (using password: YES).

my environment is:

• GOOS=linux
• GOARCH=386
• CentOS 5.7
• MySQL 5.0.95

on php program and mysql command can connect properly.

[toorop]

Same problem here with MySQL 5.1 on linux.
It works great with PHP & Python clients.

[julienschmidt]

What driver version are you using? The current git master?

[toorop]

@julienschmidt Yep, with the lastest driver.

On a cluster (master->slaves), nodes are MySql 5.1.69 except one with MariaDB 5.5.40 and i only have the problem with MySQL.

Notices that handshakes's structures are differents :

Mysql 5.1.69 (raw bytes from readInitPacket):

[10 53 46 49 46 54 57 45 48 117 98 117 110 116 117 48 46 49 49 46 49 48 46 49 45 108 111 103 0 113 154 252 85 99 33 116 73 79 49 71 81 0 255 247 33 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 63 43 86 79 106 74 114 125 65 105 108 99 0]

MariaDB 5.5.40:

[10 53 46 53 46 52 48 45 48 117 98 117 110 116 117 48 46 49 52 46 48 52 46 49 0 178 85 2 0 37 61 65 109 37 109 118 44 0 255 247 8 2 0 15 128 21 0 0 0 0 0 0 0 0 0 0 117 41 104 85 77 101 52 112 92 88 39 86 0 109 121 115 113 108 95 110 97 116 105 118 101 95 112 97 115 115 119 111 114 100 0]

Hope this help.

[julienschmidt]

We just merged #327. Can you please try if it works now?

If you take a look at http://play.golang.org/p/50weT5rcno, you can see that the different format is because MariaDB 5.5.40 out of the box tries to auth with mysql_native_password

[toorop]

Sorry for my late reply.
Yes it's works.
Thanks ;)