View original (French)

Joomla Administrator Login

Solved/Closed
AquitaineOnLine Posted messages 1 Status Member -  
 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 answers

  • 1
  • 2
  1. 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
    1. 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
    2. Thor > e-euzenot
       
      The Sentinelle plugin for Joomla 1.57 is out! It offers automated front-end protection
      link => https://forum.joomla.fr
      0
    3. 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
    4. 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
    5. 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
  2. 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
  3. 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
  4. tarinz
     
    Read, I have the same issue. Did you resolve yours? If so, how?

    Thank you
    +
    1
  6. SpOoOx.tk
     
    Hello everyone, I also had the same problem but I solved it by reinstalling Joomla 8-:
    1
  7. 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
    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
  8. FlorianG
     
    Thank you Jef, Thor, and info2D3D for taking the time to explain the procedure clearly. It really helped me out! ;-)
    1
  9. 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
  10. 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
    1. eritukol
       
      Thanks a lot, dude, I hadn’t thought of that!
      0
  11. 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
    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
    2. 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
  12. 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
  13. tarinz
     
    <translation>Hi Osiris, can you elaborate on your issue?</translation>
    0
  14. Aldo27370 Posted messages 1 Status Member
     
    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
    1. 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
      1. 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
      2. 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
      3. 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
  16. 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
    1. Click
       
      Thank you, same for me :)
      0
    2. Bassem
       
      A big thank you, it saved me after a day of trying...
      0
    3. Mich
       
      YES
      A big thank you for this post because I was pulling my hair out thinking my installation was messed up!
      0
  17. beheliod Posted messages 5 Status Member
     
    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
  18. beheliod Posted messages 5 Status Member
     
    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
    1. 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
      1. 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
  19. 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
  20. hihihou
     
    Has anyone managed to solve the problem, please?
    0
  21. 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