[SOLVED]How to find out admin password for versions 1.10+

[blackhawk]

How do we either find out or reset admin account passwords for cmsms 1.10 and up? This guide only works for cmsms systems below 1.10...
http://wiki.cmsmadesimple.org/index.php ... d_password

thanks

[Jos]

Here are some hints:
http://forum.cmsmadesimple.org/viewtopi ... t+password

[thile]

val = md5(get_site_preference('sitemask','').$password);
Lookup the sitemask value in cmsms_siteprefs and insert it before the wanted password and then run the md5 algorithm.

[Dr.CSS]

I use this...

http://forum.cmsmadesimple.org/viewtopi ... 337#p70727

[Wishbone]

I use this...

http://forum.cmsmadesimple.org/viewtopi ... 337#p70727

.. which will only work if you don't salt your passwords in 1.10.*

[bess]

an universal solution with only one query :

update cms_users set password = (select md5(CONCAT(IFNULL((SELECT sitepref_value FROM cms_siteprefs WHERE sitepref_name = 'sitemask'),''),'NEW_PASSWORD'))) where username = 'USER_NAME'

works with cmsms < 1.10.x, cmsms >= 1.10.x, with or without salt password

more informations on :
http://www.linkedin.com/groupItem?view= ... re-0-b-ttl (you must be member of cmsmadesimple's group

[Insidea]

Lovely query bess, thank you, most probably solved our "change all client websites' CMSMS password"

regards,
Vaclav

[bess]

sincerely happy to see that it can be helpful