Joomla Admin password reset - epic quest

Need help with the Administration of your Joomla! 2.5 site? This is the spot for you.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Post Reply
TotallyTroll
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Mon Nov 25, 2019 9:40 pm

Joomla Admin password reset - epic quest

Post by TotallyTroll » Thu Nov 28, 2019 10:18 am

I've met some clients website based on Joomla! 2.5. Had to do some changes to the text, links, etc. Went to administration tab and met pretty hardcore problem that seems to easy at the beginning. I can't access administration panel with provided password. It seems to be legit, because I don't got an error about invalid password. Page just refreshes to it's starting state.
ImageImage
When I entered obviously invalid password - I've got a proper message about it:
ImageImage
Next logic step is to reset password. Email recovery doesn't help. PHP plugin "Ratuj Admina" also have no power here )) And the most proper way: changing password via website database edit - seems to be "mission impossible".
First problem that database_users section doesn't have admin user at all. It has only one user with custom name. Second problem there is no password column in this database at all :eek: So there is nothing to change, to get access to administration section.
ImageImage

Help me please finally get access to administration panel.

User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 22347
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, The Netherlands
Contact:

Re: Joomla Admin password reset - epic quest

Post by pe7er » Thu Nov 28, 2019 10:33 am

Create a new Super User,
See "SQL code for use with Joomla"
https://docs.joomla.org/How_do_you_reco ... assword%3F
Kind Regards,
Peter Martin, Global Moderator
https://db8.nl - Joomla specialist, Nijmegen, Nederland
Co-developer of d2 Content https://data2site.com/joomla-extensions/d2-content

TotallyTroll
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Mon Nov 25, 2019 9:40 pm

Re: Joomla Admin password reset - epic quest

Post by TotallyTroll » Thu Nov 28, 2019 3:30 pm

pe7er wrote:
Thu Nov 28, 2019 10:33 am
Create a new Super User,
See "SQL code for use with Joomla"
https://docs.joomla.org/How_do_you_reco ... assword%3F
Thanks for your help, but I think first I have to add somehow a password column to my database. And then add new Admin2 with password "secret". Any chance to get SQL code for that?

User avatar
sozzled
Joomla! Exemplar
Joomla! Exemplar
Posts: 8210
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia
Contact:

Re: Joomla Admin password reset - epic quest

Post by sozzled » Thu Nov 28, 2019 6:11 pm

TotallyTroll wrote:
Thu Nov 28, 2019 3:30 pm
Thanks for your help, but I think first I have to add somehow a password column to my database. And then add new Admin2 with password "secret". Any chance to get SQL code for that?
Using the screenshot posted above, this is not the _users table for a J! 2.5 website. It is evident from the screenshot that shows a gender column. There is no gender column in any _users table in J! x.y website.

This probably helps to explain why you cannot find the password column. You're looking at the wrong table.
https://www.kuneze.com/blog
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 22347
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, The Netherlands
Contact:

Re: Joomla Admin password reset - epic quest

Post by pe7er » Fri Nov 29, 2019 5:24 am

TotallyTroll wrote:
Thu Nov 28, 2019 3:30 pm
Any chance to get SQL code for that?
To find the SQL code for any core Joomla table:
Check the /installation/sql/mysql/joomla.sql
Kind Regards,
Peter Martin, Global Moderator
https://db8.nl - Joomla specialist, Nijmegen, Nederland
Co-developer of d2 Content https://data2site.com/joomla-extensions/d2-content

TotallyTroll
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Mon Nov 25, 2019 9:40 pm

Re: Joomla Admin password reset - epic quest

Post by TotallyTroll » Tue Dec 03, 2019 1:56 pm

sozzled wrote:
Thu Nov 28, 2019 6:11 pm
TotallyTroll wrote:
Thu Nov 28, 2019 3:30 pm
Thanks for your help, but I think first I have to add somehow a password column to my database. And then add new Admin2 with password "secret". Any chance to get SQL code for that?
Using the screenshot posted above, this is not the _users table for a J! 2.5 website. It is evident from the screenshot that shows a gender column. There is no gender column in any _users table in J! x.y website.

This probably helps to explain why you cannot find the password column. You're looking at the wrong table.
Something weird with this website... I've looked through the whole database and didn't find any item related to users. Except one I showed in first post.
Here is how this database looks like:
ImageImage

User avatar
sozzled
Joomla! Exemplar
Joomla! Exemplar
Posts: 8210
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia
Contact:

Re: Joomla Admin password reset - epic quest

Post by sozzled » Tue Dec 03, 2019 4:03 pm

Scroll down further; there are more tables. The tables are listed in alphabetical order.

Look for the table avin_users.
https://www.kuneze.com/blog
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

TotallyTroll
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Mon Nov 25, 2019 9:40 pm

Re: Joomla Admin password reset - epic quest

Post by TotallyTroll » Wed Dec 04, 2019 12:42 am

sozzled wrote:
Tue Dec 03, 2019 4:03 pm
Scroll down further; there are more tables. The tables are listed in alphabetical order.

Look for the table avin_users.
It was completely my mistake. The tables overview in left window doesn't show all tables inside the database... I have to click on it and look into main window. No I've found super user and changed it's password to secret. And seems that login/password are correct, still I can't access administration panel. I've got the same problem as mister had in this topic: viewtopic.php?f=624&t=971423
Login page just refreshes to it's default state and requesting login again.

User avatar
sozzled
Joomla! Exemplar
Joomla! Exemplar
Posts: 8210
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia
Contact:

Re: Joomla Admin password reset - epic quest

Post by sozzled » Wed Dec 04, 2019 1:58 am

TotallyTroll wrote:
Wed Dec 04, 2019 12:42 am
I've found super user and changed its password to secret
Did you change the password to "secret"

... or did you change the password to "d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199" ???

Can you login to the backend of the J! 2.5 website? Yes or no, please.
https://www.kuneze.com/blog
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 22347
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, The Netherlands
Contact:

Re: Joomla Admin password reset - epic quest

Post by pe7er » Wed Dec 04, 2019 6:04 am

Could you check the #__extensions table to see if the two plugins
"Authentication - Joomla" +
"User - Joomla!"
that are essential for login, are enabled?
Kind Regards,
Peter Martin, Global Moderator
https://db8.nl - Joomla specialist, Nijmegen, Nederland
Co-developer of d2 Content https://data2site.com/joomla-extensions/d2-content

TotallyTroll
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Mon Nov 25, 2019 9:40 pm

Re: Joomla Admin password reset - epic quest

Post by TotallyTroll » Wed Dec 04, 2019 9:12 am

sozzled wrote:
Wed Dec 04, 2019 1:58 am
TotallyTroll wrote:
Wed Dec 04, 2019 12:42 am
I've found super user and changed its password to secret
Did you change the password to "secret"

... or did you change the password to "d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199" ???

Can you login to the backend of the J! 2.5 website? Yes or no, please.
Of course to "d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199" :D
"Backend" - do you mean mywebsite.com/administrator ?

User avatar
sozzled
Joomla! Exemplar
Joomla! Exemplar
Posts: 8210
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia
Contact:

Re: Joomla Admin password reset - epic quest

Post by sozzled » Wed Dec 04, 2019 9:29 am

TotallyTroll wrote:
Thu Nov 28, 2019 10:18 am
I've met some clients website based on Joomla! 2.5. Had to do some changes to the text, links, etc. Went to administration tab and met pretty hardcore problem that seems to easy at the beginning. I can't access administration panel with provided password. It seems to be legit, because I don't got an error about invalid password. Page just refreshes to it's starting state.
ImageImage
Let's just pause a moment. This is the login screen for the backend (your administrator site, if you would like to call it that) ... and this is your "client's" website.

You have spent the past week and you don't even know how to login?

I don't know what you know and I don't think your client knows what you don't know. Let's leave that to one side for a moment, shall we?

Can you login (using the screen you showed us at the beginning of this discussion) to the website? Yes or no. It's a pretty straightforward question.
https://www.kuneze.com/blog
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

TotallyTroll
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Mon Nov 25, 2019 9:40 pm

Re: Joomla Admin password reset - epic quest

Post by TotallyTroll » Wed Dec 04, 2019 9:38 am

sozzled wrote:
Wed Dec 04, 2019 9:29 am
TotallyTroll wrote:
Thu Nov 28, 2019 10:18 am
I've met some clients website based on Joomla! 2.5. Had to do some changes to the text, links, etc. Went to administration tab and met pretty hardcore problem that seems to easy at the beginning. I can't access administration panel with provided password. It seems to be legit, because I don't got an error about invalid password. Page just refreshes to it's starting state.
ImageImage
Let's just pause a moment. This is the login screen for the backend (your administrator site, if you would like to call it that) ... and this is your "client's" website.

You have spent the past week and you don't even know how to login?

I don't know what you know and I don't think your client knows what you don't know. Let's leave that to one side for a moment, shall we?

Can you login (using the screen you showed us at the beginning of this discussion) to the website? Yes or no. It's a pretty straightforward question.
Yes I was trying to login via /administrator page, that shown by screenshots in my first post.
No I can't login. Page just refreshing and asks for a log/pass again and again.

TotallyTroll
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Mon Nov 25, 2019 9:40 pm

Re: Joomla Admin password reset - epic quest

Post by TotallyTroll » Wed Dec 04, 2019 10:34 am

pe7er wrote:
Wed Dec 04, 2019 6:04 am
Could you check the #__extensions table to see if the two plugins
"Authentication - Joomla" +
"User - Joomla!"
that are essential for login, are enabled?
Found this plugins inside table and both of them are enabled.
ImageImage
ImageImage

User avatar
sozzled
Joomla! Exemplar
Joomla! Exemplar
Posts: 8210
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia
Contact:

Re: Cannot login to J! 2.5 backend

Post by sozzled » Wed Dec 04, 2019 5:18 pm

TotallyTroll wrote:
Wed Dec 04, 2019 9:38 am
I can't login. Page just refreshing and asks for a log/pass again and again.
That's all I wanted to know.

I saw the topic (with the subject) "Joomla Admin password reset" and I thought I could help. Well, after a week, we've successfully reset the Joomla administrator account password but this wasn't the problem, was it? The real problem was that you cannot actually login even with a legitimate user account and the correct password.

I don't know why you cannot login but the main reason why people cannot login usually because of some other problem, another piece of software, an undetected error, webhosting problem, or site hack. We don't know what you know and, if you want to understand why you cannot login to the backend of your client's website, you will need to tell us a lot more.

The best way to tell us "a lot more" is to use the Forum Post Assistant tool. I may or may not be able to help; I usually do not spend time working on J! 2.5 issues except when (a) they are ones easy ones like "how to reset the Joomla administrator account password" or (b) people pay me money to fix the difficult ones.

Image
https://www.kuneze.com/blog
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)


Post Reply

Return to “Administration Joomla! 2.5”