Page 1 of 1
[SOLVED]How to find out admin password for versions 1.10+
Posted: Thu Apr 05, 2012 1:11 pm
by 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
Re: How to find out admin password for versions 1.10 and up?
Posted: Thu Apr 05, 2012 2:44 pm
by Jos
Re: How to find out admin password for versions 1.10 and up?
Posted: Fri Apr 06, 2012 9:57 am
by 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.
Re: [SOLVED]How to find out admin password for versions 1.10
Posted: Fri Apr 06, 2012 4:50 pm
by Dr.CSS
Re: [SOLVED]How to find out admin password for versions 1.10
Posted: Fri Apr 06, 2012 6:26 pm
by Wishbone
.. which will only work if you don't salt your passwords in 1.10.*
Re: [SOLVED]How to find out admin password for versions 1.10
Posted: Fri Apr 27, 2012 3:51 pm
by 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
Re: [SOLVED]How to find out admin password for versions 1.10
Posted: Thu May 10, 2012 11:53 am
by Insidea
Lovely query bess, thank you, most probably solved our "change all client websites' CMSMS password"
regards,
Vaclav
Re: [SOLVED]How to find out admin password for versions 1.10
Posted: Thu May 10, 2012 12:00 pm
by bess
sincerely happy to see that it can be helpful
