[BlueOnyx:08256] Re: 5106R phpMyAdmin update

[Richard Morgan]

Hi Rickard

Thanks for your thoughts... not quite the case; there is a mysql password 
well and truly set.  Although for the 'http' authentication method I 
shouldn't have added 'root'.  It's explained here: 
http://wiki.phpmyadmin.net/pma/auth_types#http

I should have also been more specific - it applies specifically to the 
Solarspeed package for phpmyadmin, so other approaches might be different 
(or maybe they are all the same but I've not seen them).

Many thanks, Richard


----- Original Message ----- 
From: "Rickard Osser" <rickard.osser at bluapp.com>
To: "BlueOnyx General Mailing List" <blueonyx at mail.blueonyx.it>
Sent: Thursday, August 25, 2011 6:06 PM
Subject: [BlueOnyx:08253] Re: 5106R phpMyAdmin update


> 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.
>>
>>
>
>
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at mail.blueonyx.it
> http://mail.blueonyx.it/mailman/listinfo/blueonyx