CODEWITHSUNDEEP
phpmyadmincpanelgeoip
Ninja Neil
Ninja Neil

Reputation: 21

phpMyAdmin no longer automatically logging in

I'm not sure if this is what caused it to stop logging in automatically, but the last thing I did was install the GeoIP library and install/compiled it with "pecl install geoip".

phpMyAdmin resides in /usr/local/cpanel/base/3rdparty/phpMyAdmin/ on my CentOS release 5.8 (Final) server.

Here is the contents of my config.inc.php. I edited my blowfish_secret and also took out most of the code that was commented out:

<?php

$cfg['blowfish_secret'] = 'XXXXXXXXXXXXXXXXX'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/*
 * Servers configuration
 */
$i = 0;

/*
 * First server
 */
$i++;
/* Authentication type */
//cpanel:$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['auth_type'] = 'cpanel';

/* Server parameters */
//cpanel:$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
// cPanel case 56677
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/*
 * phpMyAdmin configuration storage settings.
 */
// cPanel case 5760
$cfg['UserprefsDisallow'] = array(
    'ShowCreateDb',
    'SuggestDBName',
    'Export/quick_export_onserver',
    'Export/quick_export_onserver_overwrite',
    'Export/onserver',
    'Export/onserver_overwrite',
);

/*
 * End of servers configuration
 */

/*
 * Directories for saving/loading files from server
 */
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

// cpanel: cases 36079, 36080, 36144
$cfg['ShowChgPassword'] = false;
$cfg['ShowCreateDb'] = false;
$cfg['SuggestDBName'] = false;
$cfg['AllowUserDropDatabase'] = false;

?>

I've read that changing the cPanel password and syncing it to the mysql database would solve this issue but it worked fine all along with different passwords on each and I would prefer to keep it that way for security reasons.

Anyone have any idea why this happened and/or how to get back the auto-login functionality from withing cPanel?

Upvotes: 2

Views: 2296

Answers (1)

Citizen Kepler
Citizen Kepler

Reputation: 456

I believe that when you modified the blowfish cookie secret you broke the authicaticion connectivity between cPAnel/WHM and PhpMyAdmin. If you have a backup of the configuration file, I recommend restoring that. Otherwise you can resolve this issue by reinstalling PhpMyAdmin with the following commands.

Backup current PhpMyAdmin

mv -v  /usr/local/cpanel/base/3rdparty/phpMyAdmin{,.backup.`date +%F.%T`}

Reinstall PhpMyAdmin

/usr/local/cpanel/bin/updatephpmyadmin --force

Upvotes: 0

Related Questions