Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: daniel on December 03, 2008, 02:21:09 AM

Title: smeserver-phpmyadmin-mulituser 2.11.3-3 fails
Post by: daniel on December 03, 2008, 02:21:09 AM
After upgrading my phpmyadmin-multiuser to 2.11.3-3 I can no longer go to https://domainname.com/phpmyadmin.  I get this error:

Existing configuration file (./config.inc.php) is not readable.

I see no problem in the messages.log and I'm not sure where this config.inc.php is located.  I have to yum remove smeserver-phpmyadmin-multiuser and then reinstall my older version smeserver-phpmyadmin-mulituser.2.1-1 that I had saved. 

Is anyone else having this issue?
Title: Re: smeserver-phpmyadmin-mulituser 2.11.3-3 fails
Post by: David Harper on December 03, 2008, 03:51:48 AM
Sounds like you should raise a bug. Try using rpm -e instead of yum remove, as yum sometimes uninstalls dependencies that are still needed for core system functions.
Title: Re: smeserver-phpmyadmin-mulituser 2.11.3-3 fails
Post by: daniel on December 03, 2008, 08:55:09 PM
Found the answers to my problems with the upgrade.  Its a two fold approach.

First the permission needs changed on the file config.inc.php.  Its currently set to root:apache.  From a root login type
chown root:www /usr/share/phpmyadmin/config.inc.php
and that will fix the permission. 

The next problem I had was it asked for a blowfish secret.  Living in a landlocked state, I personally don't know any blowfishes to ask them their secret, so I looked in another version of config.inc.php and found the blowfish secret needs to be some big long continuous string of numbers symbols and characters.  Once I inputted that, I was able to login and use phpmyadmin for multiusers.

Title: Re: smeserver-phpmyadmin-mulituser 2.11.3-3 fails
Post by: cactus on December 03, 2008, 11:30:39 PM
Found the answers to my problems with the upgrade.  Its a two fold approach.

First the permission needs changed on the file config.inc.php.  Its currently set to root:apache.  From a root login type
chown root:www /usr/share/phpmyadmin/config.inc.php
and that will fix the permission. 

The next problem I had was it asked for a blowfish secret.  Living in a landlocked state, I personally don't know any blowfishes to ask them their secret, so I looked in another version of config.inc.php and found the blowfish secret needs to be some big long continuous string of numbers symbols and characters.  Once I inputted that, I was able to login and use phpmyadmin for multiusers.
Please raise a bug for each item.
Title: Re: smeserver-phpmyadmin-mulituser 2.11.3-3 fails
Post by: mrshark on December 18, 2008, 10:46:16 AM
chown root:www /usr/share/phpmyadmin/config.inc.php
expand-template /usr/share/phpmyadmin/config.inc.php

problem solved...
Title: Re: smeserver-phpmyadmin-mulituser 2.11.3-3 fails
Post by: smeghead on January 17, 2009, 08:15:17 AM
The above info is only half right.

Resetting the file perm is correct, so run:

chown root:www /usr/share/phpmyadmin/config.inc.php

to fix.

The blowfish issue needs to be fixed by editing the config.in.php file as it is not templated within SME.

Open the file in the editor of your choice & you'll see this towards the top of the file:

/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

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

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

As the Servers auth_type is set to 'cookie' the cookie needs to be encrypted on the local w/s.  This is done by using a text string (any text string up to 46 chars) as the basis for this encryption.  This text string is the blowfish_secret; type the text string you want to use in between the two single quotes on this line:

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


For example:

$cfg['blowfish_secret'] = 'sME serVer & contribS.org'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

Sorted!
Title: Re: smeserver-phpmyadmin-mulituser 2.11.3-3 fails
Post by: cactus on January 17, 2009, 08:40:15 AM
Please raise a bug for each item.
Like stated earlier, report this to the bugtracker as this will not be fixed when it stays in the forums.