Joomla Administrator Login

Solved/Closed
AquitaineOnLine Posted messages 1 Status Membre -  
 hden95 -
This morning I connected normally to the administrator section of my site. This evening when I got back from work, I couldn't log in, my site works fine, I can log in from the site to post a news article, but as soon as I switch to admin, I can't anymore. I have 2 different logins. Same issue.
The response is please enter your password. It doesn't even tell me that my login is incorrect.
I need help
Thank you
Configuration: Windows XP Firefox 1.5.0.11

30 réponses

  • 1
  • 2
jef
 
To avoid reinstalling everything for a password issue, a useful solution is to reset the SuperAdmin password via an SQL query in phpMyAdmin (SQL tab, execute the query):

REPLACE INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES (62, 'Administrator', 'admin', 'admin@toto.com This email is protected from bots that collect emails, your browser must accept Javascript to view it', '5f4dcc3b5aa765d61d8327deb882cf99', 'Super Administrator', 0, 1, 25, '2005-11-22 00:31:11', '2005-11-26 22:05:38', '', 'editor=');

You will be able to access your site’s administration again with the login: admin and password: password
found on www.joomlafacile.com ;-)
25
e-euzenot
 
Hello,

Thank you very much, it saved me from a reinstall. Have you heard of a "sentinel" patch and what is its effectiveness?

Best regards - Gérard -
0
Thor > e-euzenot
 
The Sentinelle plugin for Joomla 1.57 is out! It offers automated front-end protection
link => https://forum.joomla.fr
0
tristan
 
Hello Jef,

I lost my administrator password in Joomla (I must have made a wrong move while managing users in Joomla)

I tried your method via my MySQL database (I am using Joomla 1.5)
in the table jos_users, I click on SQL and enter the code you provided:

REPLACE INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES (62, 'Administrator', 'admin', 'monadressemail@free.fr', '5f4dcc3b5aa765d61d8327deb882cf99', 'Super Administrator', 0, 1, 25, '2005-11-22 00:31:11', '2005-11-26 22:05:38', '', 'editor=');

I then try to log in to Joomla using:

login: admin
password: password

and I'm still getting this error message:

* JAuthentication::__construct: Could not load authentication libraries.
* The username and password do not match

The site is online and functioning but I no longer have any admin rights on it :'( http://www.info2d3d.info/joomla/fr/ (Joomla test site)

I recently upgraded to Joomla 1.5 because I was hacked in version 1.0 by sniper38 :(

I hope I won't have to do everything all over again; it represents quite a significant amount of work.

Do you think you can help me?

Huge thanks in advance!!!!

Tristan
0
Thor > tristan
 
Look at your _plugins table and Authentication - Joomla must have the published field value set to 1; it's very likely that you are unable to log in because the published value is set to 0.
0
Débutant > Thor
 
I have the same password issue, but I'm a beginner and don't know where this table is. Can you tell me, in simple terms, what I need to do and where to find the information? Thank you.
0
Datawolf
 
The cleanest way, in my opinion, is as follows:

UPDATE `le_user`.`jos_users` SET `password` = MD5( 'plain_password' ) WHERE `jos_users`.`id` =xx LIMIT 1 ;
6
info2d3d
 
Thank you, you just saved me from having to redo everything !!!!!!!!!!

Big thanks, really very nice!

If you ever need a little 3D animation, just let me know!!!

Thanks again

Tristan
3
tarinz
 
Read, I have the same issue. Did you resolve yours? If so, how?

Thank you
+
1
SpOoOx.tk
 
Hello everyone, I also had the same problem but I solved it by reinstalling Joomla 8-:
1
Biriss
 
Hello friends, I have the same problem. Of course, I first tried all the suggested manipulations, but still nothing; they are stubborn and won't let me pass!

I'm at my wit's end, especially since this issue only happens locally. I wonder what it will do once it's transmitted to the server ;) !

Is there anything else like a fix? Can I completely delete the Admin entry and try something else by creating a new user? Does the issue still stem from the activation/deactivation of the authentication plugin?

Are there any bugs that lead to this distress on Joomla?
1
loris
 
Hello,

knowing a similar problem, having tried the request indicated in the discussion, I still can't reconnect to the administrator interface of my Joomla 1.5 site.

I also tried changing the password by modifying the admin account (changing the password using the md5 function) but nothing works. I also tried the recovery script, but nothing works; when I try to log in, I always end up on the same message

"You cannot access the administration of this site."


I'm really despairing, I admit that I don't know the origin of my problem which has happened to me before but which recovery successfully allowed me to regain control of my website. But this time, it doesn't work.
Could someone help me or inform me on the reasons for these failures?

Thank you in advance, I would sincerely appreciate it.
0
FlorianG
 
Thank you Jef, Thor, and info2D3D for taking the time to explain the procedure clearly. It really helped me out! ;-)
1
dael
 
Hello,

In facing the same issue, I would like to bring this subject back to attention.

Just a quick reminder:
I am working locally, unable to connect to the back office, entering the correct login (or even the wrong one), and nothing happens except for a refresh.
Everything was working fine before, and the site hosted by Free is also functioning.

Have you found a solution?

Thank you in advance!
1
snooky147
 
Hello,
you need to go to the database administration (accessible by logging in to your host):
- click on the table "jos_users" or "prefixetable_users" if the prefix was changed during installation
- click on the display tab => you should see all the members
- click on the pencil to modify the desired member
- then change in the usertype line which should be 'Regitred', set it to "Super Administrator" while respecting uppercase / lowercase
- do not touch anything else!!
There you go, that should do it.
1
eritukol
 
Thanks a lot, dude, I hadn’t thought of that!
0
Tof
 
Wouuuaaah !!! So cool !!
In the end, I activated all the "published" options:

Authentication - Joomla
Authentication - LDAP
Authentication - GMail
Authentication - OpenID

But it still didn't work (and it no longer displayed the incorrect password message but wouldn't log in).

So I also activated the "published" option for User - Joomla!

And then the miracle happened. lol

Right or wrong, I assumed that "1" corresponds to active and "0" to inactive

Anyway, I detailed it well so that if others have the problem, this might be their solution...

THANK YOU for everything, I can continue my site without starting over and I've also learned some basics of mysql
1
VESTIAIRE
 
Hello,

I’m an intern at an association, and I need to update my website. The problem is that I need to log into the backend as an administrator. So far, so good, but when I tried to log in, it was impossible!!! Password error, so I did some research and everything. But I don’t understand anything at all. I don’t even know how to access the database or how to set the 1... Especially since I didn’t create the site, I’m just a beginner and this is the first time I’m doing this =S.

Thank you in advance.
0
Sami
 
I had the same problem, you need to go to your database then jos_plugin + display and activate Authentication - Joomla by setting (1) to published.
Good luck.
0
osiris
 
Good evening,

I have the same problem!

Can someone help me please?

I don't want to reinstall everything and start the work all over again!

Thank you in advance.

Best regards
0
tarinz
 
<translation>Hi Osiris, can you elaborate on your issue?</translation>
0
Aldo27370 Posted messages 1 Status Membre
 
Hello,
I have the same problem that just appeared.
I tried all the (4) methods described (Recover, Jos_users, Php My Admin, ...) nothing works!!!
I'm starting to wonder if there is a solution to my problem...
I enter my login + password, but nothing happens, just a simple "refresh".
I have several accounts on this site, and all the accounts are doing this!!??
Is there a solution? I am on Joomla 1.5.8, and if I upgrade to 1.5.9 will it solve my issue?
Thank you for your valuable advice.
Aldo
0
cop20003
 
You need to connect to PHP MY ADMIN

then go to the table Jos.USER, in the password field (old encrypted password) replace it with the new password and then in function, set MD5 to encrypt the new password.

There you go, the solution works for me, it comes from a computer engineer, but I still don't understand why Joomla creates this bug that keeps coming back. Personally, this isn't the first time I've been unable to log into my admin and have to perform the workaround.
This shows how Joomla is certainly a powerful tool, so powerful that vulnerabilities are perpetually created, whether intentionally or not...
Yet with the number of people working on it to make it evolve, I don't understand why Joomla is so unstable and vulnerable.
Maybe one day we will see a truly stable and secure version appear.

I have been hacked twice for your information... Joomla will never replace a true site that is personally coded.
0
snooky147 > cop20003
 
In any case, to avoid this kind of problem, make regular backups of your database. If the data doesn't change too much, once a week; otherwise, every day (it takes 2 minutes!) by going into SQL admin, selecting your database and clicking "export" then "execute". The SQL text will appear, select all (CTRL+A) and paste that into WordPad, name it bdd15mars2009.txt and that's it! On the day there is a problem, we run an SQL query, paste the text back, and everything runs smoothly.
0
CH > snooky147
 
It's a bad idea to save in a WordPad. I had the bad experience of ending up with half of the data. To get around this, you need to export to a compressed file. Then there are no issues.
0
Alvinou > cop20003
 
Thank you very much, man, this tweak was helpful to me, I had been pondering the question for 3 hours
Don't hesitate to come and take a look at blogdavidhallyday.com
Alvin
0
Ennick
 
Thank you Thank you and Thank you :)
0
kiyuubi
 
the problem is solved with me I just logged in with the following identifier
username: admin (not with your name)
password: your normal password
so log in with admin as the username.
0
Click
 
Thank you, same for me :)
0
Bassem
 
A big thank you, it saved me after a day of trying...
0
Mich
 
YES
A big thank you for this post because I was pulling my hair out thinking my installation was messed up!
0
beheliod Posted messages 5 Status Membre
 
Hello.
I just spent the whole afternoon working on my site and suddenly I can no longer log in as either admin or a regular user.
Huge panic!!!
I just read the post carefully but I'm afraid to click in phpmyadmin.
I accessed the configuration.php file that I retrieved using filezilla but it doesn't seem very promising.
Can you guide me step by step please???
My host is 1&1 and the version used is Joomla_1.5.9
Thanks in advance.
Best regards.
0
beheliod Posted messages 5 Status Membre
 
I forgot to mention that I have an active connection on one of my browsers...
1. I'm unable to disconnect from it
2. Therefore, I can still modify the content of the site.
Best regards.
0
pgu64
 
Hello everyone
I am homeless because I can't access the admin part of my site
I first tried to run this query found on a forum


REPLACE INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES (62, 'Administrator', 'admin', 'admin@toto.com This email is protected from email harvesting bots, your browser needs to accept Javascript to see it', '5f4dcc3b5aa765d61d8327deb882cf99', 'Super Administrator', 0, 1, 25, '2005-11-22 00:31:11', '2005-11-26 22:05:38', '', 'editor=');

the admin access password does not work ..

then I try to change the password directly in the user table but I can't encrypt it in MD5??
where can I perform this operation

Thank you for your help
0
Peter_P > pgu64
 
Hello,

You can recreate your password by following this method

http://demo.conceptoulouse.fr/accueil/item/94-recuperer-votre-mot-de-passe-admin-joomla-15.html
0
phil92
 
I'm calling for help, I also have the blank page issue when I want to log in as admin.
I've tried and checked all the tips described in this post in vain and it's still the same.
My setup: I'm local with Apache.

I do have the admin login page appearing on the screen, but when I click the login button, a blank page appears instead of the normal admin page containing the control panel.
NB:
The last action I took before getting to this catastrophe was a test from the site part of creating a new user (mod_loggin module)
The site part is still functioning.
I don't want to start everything over

If you have any ideas...
Thanks
0
hihihou
 
Has anyone managed to solve the problem, please?
0
alexxxxxxx
 
Hello,
following the installation of Joomla and not being able to access it, I created a user and deleted the admin from the SQL database.
How can I make the user I created a super admin?

Thank you in advance,
Best regards, Alex
0
  • 1
  • 2