On 30/09/11 3:57 AM, Andreas Raab wrote:
On 9/30/2011 4:35, Anindya Haldar wrote:
I believe this is a version issue. I tested my code with MySQL 5.0.67 on Mac OS X. The details of the test platform combinations are in the project page in Squeaksource.
Could you please let me know your MySQL version and platform? It is entirely possible that for certain versions/conditions the handshake protocol does another extra step. This is something I found NOT applicable for the version I was working with, although the reference C implementation does have such provisions.
I'm running MySql 5.0.77 server on CentOS 5.6 (which is the out-of-the-box version you get on CentOS via yum). This seems pretty close to what you're using. Is there a chance that I need to set up the database credentials in a specific way? I've just been using an existing user which works fine in other contexts but perhaps there's something specific that needs to be done?
Just a wild guess (based on working on a PostgreSQL driver) - you might try to change the authentication method used by the MySQL server. In PostgreSQL, there is plain text password and OS userid authentication methods, no idea if something similar is available in MySQL. The other authentication methods require hashing or encryption to implement.