authorization with mysql and encrypted password column

[primitiveorigin]

Hi,

I have mysql working as the authentication mechanism with tomcat as per the usual tutorial examples, but I would like it to work with the encrypted password column in the main mysql.user table so that we can immediately take advantage of existing database users.

I have been trying to set the digest property in the realm section of the server.xml (digest="MD5" etc), but it seems that I can never get the supplied user password to match the stored encrypted password in MySQL.

I can only ever authenticate with stored plain text passwords in the database.

Has anyone ever had any luck with this?

Cheers, Jared.

 

[CrystalAgentMan]

Hey,
I'm looking to do the same thing in production. I want to test in MS-SQL with JDBC, but can't seem to get MD5 working anywhere.
Have you figured this out?

Thanks,
Michael

 

[primitiveorigin]

Hi,

No, gave up on it. Tried everything I could think of, and no one else has responded anywhere.

I don't have to have this working at the moment, but would like to at some point soon. Please let me know if you get anywhere with it.

Cheers, Jared.