Problem logging in using mysql password function 1

[s0crates9]

Hi. I have a test server on a windows box with php 4.3.10 and mysql 4.1.10-nt. I built a login app and It works well using the mysql password('') function. Unfortunately I ported the app to a freebsd box running php 4.3.10 and mysql 4.1.12. The passwords come out differently and I don't understand why.

For instance, the password test looks like "378b243e220ca493" on the windows box and the freebsd database entry look like "*94BDCEBE19083CE". As you can see, very different. And this causes a lockout from logging in.

Instead of being routed to a "safe" login page, the error for a wrong username/password combo shows up.

Anyone have a clue what this could be or how to fix it?

 

[nego78]

Modify your app to use sha1() function.

How did you move database ? Dump?

Did you try to use old_password() on freebsd box?



Via-Net - web directory

 

[s0crates9]

As a matter of fact old_password worked! Thanks!

I think I will work on switching the coding to incorporate the sha1() function. Kudos Neog78, exactly what I wanted to know.

Here's a star! Make it two!