i try to change via sql the users passwords, but i cannot does,due the generated string its not md5, its another type.. please how can i reset users passwords with an sql command

NOTE: i refers to users, not admin or staff, the password for admins are in pure md5 and works perfectly the "md5('string')" sql command, but for users does not work.

6 months later

For understand how to reset inclusivelly create a new userhttps://groups.google.com/d/msg/venenuxsarisari/qe88Y7h-3Nc/P7R5Nr6mslsJat the end of the link are the "how to reset password" item topic

"NOTE: i refers to users, not admin or staff, the

password for admins are in pure md5 and works perfectly the

"md5('string')" sql command, but for users does not work."Actually none of the passwords are pure md5 but the system lets you use md5 in case someone really gets locked out and there is no admin account to use to reset the password.

thanks for clarification ntozier, its true, the password field are mixed md5 with sha, and osticket let u use md5 strings too, i forgot paste that.

Write a Reply...