Has anyone seen this before? Client goes via Plesk to the database page, and clicks on phpMyAdmin. Up it pops. But the clicking on the database within phpMyAdmin pops up a "login box"....??? Neither the Plesk login works, or the database username/password.

This one has us beat...

1. Click on Databases

2. Click on

3. Click on PHPMYADMIN - new window opens

4. Click on under HOME

5. Login screen appears

6. Tries control panel login, and also database username/password, but neither works.

7. Gets the following message:

'Unable to set up session: There is another session with this name.'

Have you upgraded phpmyadmin by any chance?

In the newer versions there is an option on the config.inc.php file to allow authentication by login box rather than set in the config file.

We sussed it. phpMyAdmin 2.2.6 uses absolute URLs ($cfgPmaAbsoluteUri) by default, so CP's via the domains weren't working. Now we've got the variable defined on the fly using the wonders of Environment Variables to pull in the current HTTP_HOST.

Cheers

Gary

Im also using 2.2.6 now but still cant login and get everytime the wpphpadmin@localhost error.
Can you please post your solution for this?

thanks,

Ropey

Hey there,

As Gary mentioned we had to use HTTP_HOST server variable a bit. I have just summarised the changes required to make the new phpMyAdmin work with Plesk.

All modifications to config.inc.php3 .

1)

Change $cfgPmaAbsoluteUri to;

$cfgPmaAbsoluteUri = 'https://' . getenv("HTTP_HOST") . '/domains/databases/phpMyAdmin';

2) Change $cfgServers[$i]['user'] to;

$cfgServers[$i]['user'] = "$db_user";

3) Change $cfgServers[$i]['password'] to;

$cfgServers[$i]['password'] = "$db_pass";

4) Change $cfgServers[$i]['only_db'] to;

$cfgServers[$i]['only_db'] = "$db_name";

5) Ensure that the auth_type is set to 'config';

That should be about it as far as I can remember.

Hope that helps,

Stuart

If that doesn't work stick with 2.2.5