I have installed phpMyAdmin on my server and am very happy with everything - setup was a breeze and runs very well.
I have changed the auth type to be 'http' which displays the network dialog with a username/password requesting you to log into the system.
Basically what I want to do is this:
I have a system that already authenticates a user from the mysql.user table. What I want to do is pass the username and password I have for this user from the session and automatically log them into phpMyAdmin.
If these credentials are missing then display the dialog.
I have gotten part of the way there in that I encrypt and URL encode the username/password and decrypt/decode them in the appropriate place ($PHP_MY_ADMIN_HOME/libraries/auth/http.lib.inc.php) and can read these values. When I put these values into $PHP_AUTH_USER and $PHP_AUTH_PW (the variables needed to auth against) it still pops up a dialog.
$user = decrypt($_REQUEST['usr']);
$pass = decrypt($_REQUEST['pwd']);
$PHP_AUTH_USER = $user;
$PHP_AUTH_PW = $pass;
However.... If I hard code the values to these variables i.e.
$user = 'timmy';
$pass = 'tigger';
$PHP_AUTH_USER = $user;
$PHP_AUTH_PW = $pass;
This works perfectly. What would be the difference? Why hard coded variables == good, dynamic variables != good?
Thanks for any advice/suggestions.
V.