phpmyadmin login problem

Hi all,

I have a strange problem with phpmyadmin.
If I click on 'phpmyadmin' in the tools menu then phpmyadmin defaulty logins with the user blaat@localhost. This is under every user, clients and reseller.

Strange thing also, if you click in phpmyadmin on 'logout' then the loginbox popsup!

How can I get the loginbox back the display again everytime someone opens phpmyadmin?


Thanks in advance!

 

No, all clients have that problem

 

Yes, and I installed phpmyadmin the file that I download on the ISPconfig site..

I think there should be somewhere in the config file something wrong that sets the default user to: blaat@localhost. I looked into the config.inc.php file of phpmyadmin in /home/admispconfig/ispconfig/web/phpmyadmin/

 

Have you tried that with different browsers (e.g. Firefox, IE, Seamonkey, etc.)?

 

yes ofcourse...

 

Did you modify the config.inc.php file?

What's in it right now?

 

My first lines:

$i = 0;
$i++;
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['ssl'] = false;
$cfg['Servers'][$i]['connect_type'] = 'socket';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['compress'] = FALSE;
$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = '';
$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['SignonSession'] = '';
$cfg['Servers'][$i]['SignonURL'] = '';
$cfg['Servers'][$i]['LogoutURL'] = '';
$cfg['Servers'][$i]['nopassword'] = FALSE;
$cfg['Servers'][$i]['only_db'] = '';
$cfg['Servers'][$i]['hide_db'] = '(information_schema|mysql|pmadb|test)';
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['pmadb'] = '';

$cfg['Servers'][$i]['bookmarktable'] = '';
$cfg['Servers'][$i]['relation'] = '';
$cfg['Servers'][$i]['table_info'] = '';
$cfg['Servers'][$i]['table_coords'] = '';
$cfg['Servers'][$i]['pdf_pages'] = '';
$cfg['Servers'][$i]['column_info'] = '';
$cfg['Servers'][$i]['history'] = '';
$cfg['Servers'][$i]['designer_coords'] = '';
$cfg['Servers'][$i]['verbose_check'] = TRUE;
$cfg['Servers'][$i]['AllowRoot'] = TRUE;
$cfg['Servers'][$i]['AllowDeny']['order']
= '';
$cfg['Servers'][$i]['AllowDeny']['rules']
= array();
$cfg['ServerDefault'] = 1;

$cfg['MaxDbList'] = 100;
$cfg['OBGzip'] = 'auto';
$cfg['PersistentConnections'] = FALSE;
$cfg['ForceSSL'] = FALSE;
$cfg['ExecTimeLimit'] = 300;
$cfg['MemoryLimit'] = 0;
$cfg['SkipLockedTables'] = FALSE;
$cfg['ShowSQL'] = TRUE;
$cfg['AllowUserDropDatabase'] = FALSE;
$cfg['Confirm'] = TRUE
$cfg['LoginCookieRecall'] = TRUE;
$cfg['LoginCookieValidity'] = 1800;
$cfg['LoginCookieStore'] = 0;
$cfg['LoginCookieDeleteAll'] = TRUE;
$cfg['UseDbSearch'] = TRUE;
$cfg['IgnoreMultiSubmitErrors'] = FALSE;
$cfg['VerboseMultiSubmit'] = TRUE;
$cfg['AllowArbitraryServer'] = FALSE;

 

are you doing this from your own computer or do you have different people from idfferent computers auto logging into phpmyadmin as blaat? I thought I had the same problem as you when i logged out of ispconf as admin and back in as reseller, and clicked onto the phpmyadin and it autologged me into phpmyadmin as root. If you are troubleshooting this yourself then you will ned to clear all caches and cookies. then that will "end" your phpmyadmin session and will allow you to login as a different database user. It worked for me

 

al users login with blaat@localhost and see no databases.
Only if they click on logout and login again into phpmyadmin then it works... very strange...

 

Can you try this from a different computer?

 

Falko,

Like I said all clients have this problem so on diffrent computers

 

Maybe, you can avoid all this by changing the line:

/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';

into:

/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'http';

within the phpMyAdmin configuration file config.inc.php

 

Okay this is what I did...

I installed phpmyadmin from scratch, with cookie and it works now