"How do you recover your admin password?" don't work

Locked
User avatar
mejean
Joomla! Hero
Joomla! Hero
Posts: 2714
Joined: Thu Aug 18, 2005 12:28 pm
Location: viewforum.php?f=19
Contact:

"How do you recover your admin password?" don't work

Post by mejean » Wed Dec 10, 2008 1:10 pm

See on wiki http://docs.joomla.org/How_do_you_recov ... assword%3F

It's don't work for me Good SQL request should be :

Code: Select all

INSERT INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`)
        VALUES (null, 'Administrator2', 'admin2', '[email protected]', '21232f297a57a5a743894a0e4a801fc3', 'Super Administrator', 0, 1, 25, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `jos_core_acl_aro` VALUES (NULL, 'users', LAST_INSERT_ID(), 0, 'Administrator', 0);
INSERT INTO `jos_core_acl_groups_aro_map` VALUES (25, '', LAST_INSERT_ID());
It's work for latest Joomla! 1.0 and 1.5

Or

Code: Select all

INSERT INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`)
        VALUES (null, 'Administrator2', 'admin2', '[email protected]', '296e21e19e0a53e6eacc64bc8cf6e134:w15sQL14fsn2V8MFpPmWZTz9LVgmZIaj', 'Super Administrator', 0, 1, 25, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `jos_core_acl_aro` VALUES (NULL, 'users', LAST_INSERT_ID(), 0, 'Administrator', 0);
INSERT INTO `jos_core_acl_groups_aro_map` VALUES (25, '', LAST_INSERT_ID());
for Joomla! 1.5 (not tested on Joomla! 1.0)

Thank to Ouly.
Jérôme Bussière - simple utilisateur
www.cardabelle.net

User avatar
dextercowley
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3286
Joined: Sun Apr 06, 2008 4:44 am
Location: Seattle, WA, USA

Re: "How do you recover your admin password?" don't work

Post by dextercowley » Wed Dec 10, 2008 4:04 pm

Hi Jerome. Thanks for the suggestion. I'm testing them out. What are the matching passwords in your examples above? Thanks. Mark
Mark Dexter
"Well...how did I get here?"

User avatar
mejean
Joomla! Hero
Joomla! Hero
Posts: 2714
Joined: Thu Aug 18, 2005 12:28 pm
Location: viewforum.php?f=19
Contact:

Re: "How do you recover your admin password?" don't work

Post by mejean » Wed Dec 10, 2008 4:45 pm

Passwords is admin for each of this examples.

In the first case it's seem to be the old encryption before the 1.0.13, but works in a 1.0.15

If you create an new administrator with the password admin in the Joomla! console, result will not be 296e21e19e0a53e6eacc64bc8cf6e134:w15sQL14fsn2V8MFpPmWZTz9LVgmZIaj

I don't now exactly how Joomla! encrypt password.
Jérôme Bussière - simple utilisateur
www.cardabelle.net

User avatar
dextercowley
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3286
Joined: Sun Apr 06, 2008 4:44 am
Location: Seattle, WA, USA

Re: "How do you recover your admin password?" don't work

Post by dextercowley » Wed Dec 10, 2008 6:29 pm

Hi Jerome. Thanks for the information. I've updated the Wiki article with the new query. Mark
Mark Dexter
"Well...how did I get here?"


Locked

Return to “Feedback and Suggestions”