Actions

Talk

Difference between revisions of "How do you recover or reset your admin password?"

From Joomla! Documentation

(LAST_INSERT_ID( ): new section)
(Solution: new section)
Line 38: Line 38:
  
 
[[User:Toivo|Toivo]] 00:44, 10 May 2009 (UTC)
 
[[User:Toivo|Toivo]] 00:44, 10 May 2009 (UTC)
 +
 +
== Solution ==
 +
 +
My solution: I set manually values for tables jos_core_acl_aro,jos_core_acl_groups_aro_map and jos_core_acl_aro_sections. I had an other joomla database where I could compare values and make changes to "problem" database.

Revision as of 15:11, 4 May 2010

I think this will not work anymore, because in Joomla 1.5 an additional $salt parameter is used to encrypt the password. In the usertable the password is stored in the format:

$encript:$salt

so simple md5 hashed passwords will not work anymore...

Contents

Worked for me

It worked for me when I tested it. Mark Dexter 15:08, 4 October 2008 (EDT)

md5 CAN Be used in Joomla 1.5.7

Trust me :-) You can put in an md5 in the database as the password, When that user tries to login Joomla will notice that the password is md5 hashed and will then UPGRADE that password to a SALTED password, saving the result back to the database - thats why it works :-) Phil Taylor

LAST_INSERT_ID( )

Depending on the version of the MySQL server, the function LAST_INSERT_ID( ) can produce 0 and the recovery procedure fails.

You can insert the admin2 user into the last two tables 'manually'. Run this query to find out the id of the admin2 user:

SELECT * FROM `jos_users` WHERE username = 'admin2'

Use the value of id in the next query to replace 9999:

INSERT INTO `jos_core_acl_aro` VALUES (NULL, 'users', 9999, 0, 'Administrator', 0);

Use the value of id to replace 9999 to find out aro_id:

SELECT * FROM `jos_core_acl_aro` WHERE value = 9999

Use the value of aro_id in the last query to replace 8888:

INSERT INTO `jos_core_acl_groups_aro_map` VALUES (25, , 8888);

Toivo 00:44, 10 May 2009 (UTC)

Solution

My solution: I set manually values for tables jos_core_acl_aro,jos_core_acl_groups_aro_map and jos_core_acl_aro_sections. I had an other joomla database where I could compare values and make changes to "problem" database.