Support

Admin Tools

#16898 User Password

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by nicholas on Wednesday, 31 July 2013 11:51 CDT

khadley
Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Yes
Joomla! version: Joomla! 2.5.13
PHP version: 5.3.21
MySQL version: 5.0.96-community
Host: (liquid web)
Admin Tools version: (2.5.6 pro)

Description of my issue: I recently purchased and installed admin tools, as i'm trying to get my sites more secure. I went through the process described with three sites and am having trouble creating new users, and changing the main super admin password (one last step i want to do as each of these sites had been compromised). Process being changing the admin login page, creating a htaccess file, and signing up for project honeypot and creating that access key).

when i say create a user or change the main user password, i am talking about under Users/User manager.

nicholas
Akeeba Staff
Manager
I suppose you are talking about what is being discussed here https://www.akeebabackup.com/documentation/troubleshooter/atspecialusers.html

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

khadley
yes, thanks for that link. I tried setting the admin settings in admin tools and then going to try to reset the password but get this message in one of the three sites (the other two worked)

Save failed with the following error: You cannot remove your own Super Admin permissions.

I'm not trying to change the permissions, jsut trying to reset the password for the super admin?

nicholas
Akeeba Staff
Manager
You seem to have upgraded a site to Joomla! 2.5.13. There is an issue in that Joomla! release affecting a few sites (including ours – which is why I know the problem and the solution). The problem occurs when you have multiple ACL assets with a level=0. Anyway, the solution is easy:

Open your site's database with phpMyAdmin or a similar tool. Find the Root Asset record (it's usually the very first one). It has lft=1. Set lft to 0 and save it. And now everything works.

This is a bug in Joomla!. When installed, Joomla! sets the value of lft to 1 for its root asset node. However, its code is looking for a record with lft = 0 which is inconsistent. The problem is that this code is called in an edge case which makes it extremely easy to fix (I have to literally change one character in one line of code) and extremely difficult to provide test instructions for the fix to be accepted by the Joomla! project. I hope to have enough time later this week to do that and fix this bug for all affected Joomla! users.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

khadley
Hi, thanks for that i'll give it a try. I have another question. If one is blocked out of a site in any way, forgotton password etc, there's a way to go through the php my admin and reset the password using MD5 encripted values. Are we still able to do that once all the recommended settings are in? or is there another way? i just want to make i know how in case!

nicholas
Akeeba Staff
Manager
If a user has forgotten his password he can do one of two things:
- ask a super administrator to change his password.
- use the Forgot Password link in Joomla!'s login page or module.
Editing the database should be the very last step. Since Joomla! is about to change the way it encrypts passwords (finally!) any currently known method that goes through phpMyAdmin would become obsolete very soon.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

khadley


hi, i'm not finding that root asset record. When i click php my admin i'm not seeing it, if i go to the robmarland database i don't see it (image attached) can you maybe lead me with a little more info? or maybe a screen shot?

nicholas
Akeeba Staff
Manager
You sent me the screenshot showing the list of your database tables. You have to click on the ebevu_assets table. Then you can find the root asset record.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

khadley
Hi, so i changed it to 0 (screen shot attached) and saved, then went back to the site and tried ot change the password, still gettting the same message. Any thoughts?

nicholas
Akeeba Staff
Manager
Can you post a screenshot of the error message?

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!