Menu

User list inoperative

Paul Blair
2009-09-04
2013-05-30
  • Paul Blair

    Paul Blair - 2009-09-04

    PGV 4.2.2, in place for about a week, working as expected.

    Today, login refused  with my u/n, p/w (Unable to authenticate...) so I tried as someone else. Same problem. Checked all the usual things (cookies, CAPS lock, etc) - no go.

    So I built a parallel universe, populated it, all went OK. Transferred my old user list over, previous problem reappeared. So the user table seemed to be the problem.

    Looking at it (I can read it in phpMyAdmin), and I have some extra files to read data without logging in with PGV which work OK.  There seemed to be no signs of tampering anywhere.

    I have no idea what went wrong - this is just a general heads up.

    Paul
    Australia

     
    • Greg Roach

      Greg Roach - 2009-09-04

      What happens if you try to create a new user (via the registration page?)

      (You may need to use phpMyAdmin to set the approved_by_admin and user_approved_self columns to Y/Yes, since you can't log in as admin to verify the user.

       
    • Paul Blair

      Paul Blair - 2009-09-04

      I can't get past the login page.

      Is there a back door?

      Paul
      Australia

       
    • Stephen Arnold

      Stephen Arnold - 2009-09-04

      Paul
      This belongs in the Help Forum, but there are plenty of threads with provide the instructions on how to access your database and set your password to a dummy (usually CHANGEME)

      Also, there are threads which discuss your ability to back up and then delete the USER table and set your config.php to FALSE for configured and then the system will ask you to set up an admin account. If you have other users, then you could then use a SQL backup to restore your users from the backup.
      -stephen

       
    • Paul Blair

      Paul Blair - 2009-09-04

      Thanks, Stephen. I wasn't looking for help, just providing a heads up. A quick overall rebuild was the fastest and most positive solution.

      However, on a personal level, I am curious about why it happened.

      Paul
      Australia

       

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.