Menu

Can't Login in as Administrator

Help
Steve
2009-04-22
2014-06-27
  • Steve

    Steve - 2009-04-22

    Well, I thought I typed everything right, but can't login as administrator.  How do I reset the administrator login name and password, both?

    Steve

     
    • Stephen Arnold

      Stephen Arnold - 2009-04-22

      1) Search these forums and you'll find a hash code for the password CHANGEME and enter it in the data using phpMyAdmin or a similar program.

      2) if you don't have users to protect, wipe out the config.php and start a new one after you drop the user tables. It will create a new one.

      3) have the system send you a temporary password with which to sign in, using the LOST PW procedure. this would be the preferred method as the others are destructive or complicated.
      --Stephen

       
    • Stephen Arnold

      Stephen Arnold - 2009-04-22
       
    • Gerry Kroll

      Gerry Kroll - 2009-04-22

      Stephen:
      That's a bit drastic.

      Steve should try the following work-around first:

      Assuming the admin userid is known, and we just have a password error, the user should try requesting a new password from the Login screen.  Enter the userid and then click "request new password". 

      PGV will send an e-mail to the address on file.  Use the password to log in and then IMMEDIATELY access the "my account" page to change the password.

      If the userid isn't known, use phpmyadmin to inspect the users table.  You should be able to determine which userid has admin rights, and then proceed as above.

      If you're not happy with the admin userid (it might be mis-spelled), log in with the "bad" ID and then access the "my account" page to change the login ID.  Alternatively, log in with the bad ID, add another Admin userid, log in with that new Admin userid, and then delete the old one from the Users list.

      Note:
      There's a site configuration option to disable "request new password".  If that's set, you'll need to manually change file "config.php".  If you can't change the file manually, post back here and we'll tell you off-line (by e-mail) what to do.

       
      • Steve

        Steve - 2009-04-23

        Well, I tried the phpmyadmin route to see if that would help - got tied up in how to configure it to look at my DB and gave up on that.  So, I went to a new route by deleting the DB entirely - I hadn't made changes from the initial load yet, so just dropped the DB and started over.  That worked and allowed me to go to the install screens and recreate the administrator.  Luckily, this time I created a second administrator account right away before leaving the install script - this time I noticed that it would not allow me to have a password less than 5 characters.  I tried logging in as the original administrator with only my 5 character password, and the couldn't log in, but could get in with my longer than 5 password on the second administrator account.  Started over again, and this time set up the original administrator account with 8 characters and all worked.

        Didn't capture every step, but looks to me that there's a bug in the install script that allows the original administrator account to set up a short password without an error message and therefore not allow you to login later with that password.

        Make sense?

         
        • Greg Roach

          Greg Roach - 2009-04-23

          <<looks to me that there's a bug in the install script that allows the original administrator account to set up a short password without an error message and therefore not allow you to login later with that password.>>

          Can you create a bug report for this.

           
      • Steve

        Steve - 2009-04-23

        Well, I tried the phpmyadmin route to see if that would help - got tied up in how to configure it to look at my DB and gave up on that.  So, I went to a new route by deleting the DB entirely - I hadn't made changes from the initial load yet, so just dropped the DB and started over.  That worked and allowed me to go to the install screens and recreate the administrator.  Luckily, this time I created a second administrator account right away before leaving the install script - this time I noticed that it would not allow me to have a password less than 5 characters.  I tried logging in as the original administrator with only my 5 character password, and the couldn't log in, but could get in with my longer than 5 password on the second administrator account.  Started over again, and this time set up the original administrator account with 8 characters and all worked.

        Didn't capture every step, but looks to me that there's a bug in the install script that allows the original administrator account to set up a short password without an error message and therefore not allow you to login later with that password.

        Make sense?

         
      • BrianJester

        BrianJester - 2014-06-27

        Gerry, thank you for the idea! I went into phpMyAdmin and seeing the user, remembered the password.

         
    • Stephen Arnold

      Stephen Arnold - 2009-04-23

      Greg
      Do we really wish to allow short passwords? or is it your intention to program a denial and advise the need for a longer password during registration? (preferred).
      -Stephen

       
      • Greg Roach

        Greg Roach - 2009-04-23

        <<Do we really wish to allow short passwords?>>

        No.

        <<is it your intention to program a denial and advise the need for a longer password during registration? (preferred).>>

        Yes.  There is already an input validation filter for passwords.  I guess it isn't being used on the initial setup.

         
  • JCM

    JCM - 2010-11-15

    I have lost my administrators status for no reason whatsoever, and find that there is no way that I can login, not even as a user.
    I have studied all the posts by others on this topic but nothing that I have tried seems to work
    I have even deleted PhPgedview from the server at my ISP and re-installed the program without avail. This is driving me arround the bend, and I hope somebody may be able to help in this regard.
    Many thanks
    Johan

     
  • Stephen Arnold

    Stephen Arnold - 2010-11-15

    First - you should not necessarily drag up an old thread and repost, unless it is precisely pertinent to your issue. Were it, this thread would have provided several means for you to resolve your issue.

    Second - Deleting and reinstalling is very drastic means, and certainly not necessary, and perhaps puts your data and user tables at risk. Better to stop and ask first.

    Johan. Not sure you have provided enough information about your issue. Can you log in, but don't have admin rights? Do you perhaps have rights under a different user? Have you examined your user tables with phpMyAdmin or an equivalent program? Do you have any users? Have you tried to have PGV send you a password? Have you examined the config.php file? Have you save a copy and then trashed the existing one, replacing it with a new one and resetting the Admin? Do you have a password of sufficient length?   Without most of these answers, we have little to base any help reply. Please re-review the thread as there exist many options discussed.
    -Stephen

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.