Menu

#2359 (ok 2.11) Authentication fails when controluser/pass is set

fixed
1
2013-06-11
2007-02-18
No

I'm using HTTP authentication and it appears I've deleted the pma user from MySQL's privilege tables.

Now, every normal login fails, but it doesn't give any indication that it fails due to the pma user.
So it keeps reasking for the normal password, which is valid.

Discussion

  • Isaac Bennetch

    Isaac Bennetch - 2007-02-20

    Logged In: YES
    user_id=835650
    Originator: NO

    > ...appears I've deleted the pma user from MySQL's privilege tables.
    Okay, so simply re-create it (directions here: http://wiki.cihar.com/pma/controluser\) -- if you don't have command-line access, temporarily change config.inc.php to auth_type config (and add your username and password in the appropriate lines). Once you've run the SQL script through phpMyAdmin's query window or tab, you can restore your existing config.inc.php settings.

    > Now, every normal login fails
    Because of how phpMyAdmin handles authentication, an invalid controluser setting can cause authentication to fail.

    > it doesn't give any indication that it fails due to the pma user.
    HTTP authentication doesn't allow phpMyAdmin to send any real error response back to the browser; 'cookie' should give a reasonable error, even though I don't think it specifically identifies the controluser as being at fault.

    Hope this helps...

     
  • Olaf van der Spek

    Logged In: YES
    user_id=30264
    Originator: YES

    > HTTP authentication doesn't allow phpMyAdmin to send any real error response back to the browser;

    Why not?
    The error message I got was very real. :)
    You can't change the layout of the password dialog, but AFAIK you can change everything else.

     
  • Sebastian Mendel

    • assigned_to: nobody --> cybot_tm
    • status: open --> open-accepted
     
  • Sebastian Mendel

    Logged In: YES
    user_id=326580
    Originator: NO

    does now display a message on main.php

     
  • Sebastian Mendel

    • priority: 5 --> 1
    • summary: Authentication fails when controluser/pass is set --> (ok 2.11) Authentication fails when controluser/pass is set
    • status: open-accepted --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2007-08-21
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed