[BlueOnyx:08253] Re: 5106R phpMyAdmin update

[Rickard Osser]

Hi Richard,

that doesn't fix it, it just shows us that your mysql doesn't have a
password set for root. Which is why the original code doesn't work.

The root mysql password has to be the same as logging on to the machine.

Best regards,
Rickard

On Thu, 2011-08-25 at 16:56 +0100, Richard Morgan wrote:
> Hi... just in case anyone else is experience a problem where phpmyadmin 
> authertication fails, there is a simple solution (in case uninstall and 
> reinstall doesn't do it):
> 
> su -
> pico /usr/share/phpMyAdmin/config.inc.php
> 
> The config file looked like this:
> 
> $cfg['Servers'][$i]['auth_type']        = 'signon';
> $cfg['Servers'][$i]['SignonSession'] = 'SignonSession';
> $cfg['Servers'][$i]['SignonURL']     = '/base/phpmyadmin/index.php';
> //$cfg['Servers'][$i]['auth_type']      = 'http';    // Authentication 
> method (config, http or cookie based)?
> $cfg['Servers'][$i]['user']                 = '';      // MySQL user
> $cfg['Servers'][$i]['password']        = '';          // MySQL password 
> (only needed
>                                                       // with 'config' 
> auth_type)
> 
> By moving the comments around and providing a user of 'root' it seems to 
> work absolutely fine.  My end result was:
> 
> //$cfg['Servers'][$i]['auth_type']        = 'signon';
> //$cfg['Servers'][$i]['SignonSession'] = 'SignonSession';
> //$cfg['Servers'][$i]['SignonURL']     = '/base/phpmyadmin/index.php';
> $cfg['Servers'][$i]['auth_type']          = 'http';    // Authentication 
> method (config, http or cookie based)?
> $cfg['Servers'][$i]['user']                   = 'root';      // MySQL user
> $cfg['Servers'][$i]['password']          = '';          // MySQL password 
> (only needed
>                                                         // with 'config' 
> auth_type)
> 
> Hope it helps someone.
> 
> Richard
> 
> 
> ----- Original Message ----- 
> From: Michael Stauber
> To: BlueOnyx General Mailing List
> Sent: Wednesday, August 24, 2011 2:02 AM
> Subject: [BlueOnyx:08229] Re: 5106R phpMyAdmin update
> 
> 
> Hi Richard,
> 
> 
> > I don't know if this is an issue effecting anyone else, but I'm unable to
> > get to phpMyAdmin (solarspeed) from http://ip/phpmyadmin as it's
> > redirecting to http://ip/base/phpmyadmin.php instead.  I thought it was
> > fixed by uninstalling and reinstalling but it wasn't.
> 
> 
> Yeah, am looking into it now. The issue is a bit weird. Uninstalling and 
> reinstalling the PKG fixed it for some people, but I'm also just looking at 
> a case like yours where a reinstall of the PKG doesn't fix it. Haven't yet 
> figured out what's wrong, but I'll see what I can do.
> 
>