[SOLVED}How to reset password in newer versions?

[snowball]

The reset command in mysql doesnt work in the newer versions...

In the faq that is mentioned, however no alternative is written there...

So that issue was yesterday, today we found the password but by trying to reset it in the database there must be something been affected couse cannot seem to login at any way :s

CMS version 1.10.3

Anyone?

[scelle]

Have you tried the "Forgotten password" feature? If you don't know which e-mail address is attached to the admin account, edit it in the 'cms_users' database table.

Just make sure that you change the email for the admin account (has 'admin_access' attribute set to '1').

Hope it helps!

[snowball]

Yes also tried that, for some reason the mailer module emails every form thats filled in, but the forgot pasword function does not work, even though i can see the proper emailadres in the database...

[scelle]

Have you 'salted' your admin passwords during the installation?

Try pasting this in the 'password' database attribute:

Code: Select all

d5c3b0c53a5284266c0789ab0626cd38

It's 'admin' transliterated in 1.10. Maybe they've changed the encryption process somehow.

If it doesn't help, I would try reconfiguring the CMSMailer via database. Just go to the 'cms_siteprefs' table and edit appropriate settings (in my database starting with the 'CMSMailer_mapi_pref_' prefix). Put in some known and reliable SMTP server, an authorized user (password in plain text, and smtpauth to '1' if your SMTP server requires authentification).

Other than that - I don't know what else could be done.

[snowball]

Hi Scelle,

Thanks for your reply, I now have the original hash of the original password that I've lost... So I have the hash and the password but in my action trying to reset the password I have changed the md5 hash..

Before trying your solution, I would try changing this hash..

I am not so experienced running sql commands and am carefull...can I just paste the original hash in the field in phpmyadmin and run?





Thanks man!

[scelle]

Sure. Just paste it.

[snowball]

YESSSSSSSSSS!!!!

Thanks man! That did the trick!!!

[Wishbone]

Isn't there some way to change the password if it was salted? It seems that if you can change the password from the admin panel, you should be able to change the password using phpMyAdmin.

[snowball]

Yep, in phpmyadmin you can change it, just create a md5 hash of a new password and past that generated hash in the passwordfield of the admin user

To create a md5 hash i used a online md5 generator, filled in a new fresh password and hit "generate"... that code I used..

Now you can acces the cms with that username and new password.

Change the password again and voilla done...

Anyone need screenshot? sent pm..

Credits for user Scelle, i learned from you

[scelle]

Hey, it's nice when you can help.

You should look into that 'Forgotten Password Function Not Functioning ' issue, though...

[snowball]

OMG yes almost forgot that "little" issue lol, thanks again mate!

[Wishbone]

Yep, in phpmyadmin you can change it, just create a md5 hash of a new password and past that generated hash in the passwordfield of the admin user

I was asking about 'salted' passwords that are optional, but default in 1.10.* .. The md5 hash generator trick won't work in this case.