I have started a new project in .NET which uses some old system's datababase in MySql. The data stored in mysql is periodicaly transfered to MS Sql on which our system works. I need to authenticate users with their login and password. User's passwords are stored as hash generated by OLD_PASSWORD function from mysql. Is there any way to generate such hash using Ms Sql or .NET ?
A:
Here is a Perl module that emulates MySQL's password()
function for both 4.0 and prior (which is now OLD_PASSWORD()
function) and 4.1 and higher.
While I realize that it's not .NET :-) that's the only piece of code (besides MySQL source)I found when I was looking for this, although I needed Java implementation. It worked for me and helped with migration - perhaps you'll be able to port it to .NET or run it as external process.
ChssPly76
2009-08-08 22:29:36