Joomla Administrator Login
Solved/Closed
AquitaineOnLine
Posted messages
1
Status
Membre
-
hden95 -
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
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
Suivant
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 ;-)
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 ;-)
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 ;
UPDATE `le_user`.`jos_users` SET `password` = MD5( 'plain_password' ) WHERE `jos_users`.`id` =xx LIMIT 1 ;
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
Big thanks, really very nice!
If you ever need a little 3D animation, just let me know!!!
Thanks again
Tristan
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?
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?
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.
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.
Thank you Jef, Thor, and info2D3D for taking the time to explain the procedure clearly. It really helped me out! ;-)
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!
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!
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.
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.
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
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
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.
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.
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
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
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
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
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.
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.
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.
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.
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.
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.
1. I'm unable to disconnect from it
2. Therefore, I can still modify the content of the site.
Best regards.
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
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
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
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
- 1
- 2
Suivant
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 -
link => https://forum.joomla.fr
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