Koozali.org: home of the SME Server

smeserver-phpmyadmin-mulituser 2.11.3-3 fails

Offline daniel

  • ****
  • 146
  • +0/-0
  • Platinum Sponsor
    • http://www.charton-mgmt.com
smeserver-phpmyadmin-mulituser 2.11.3-3 fails
« 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?

Offline David Harper

  • *
  • 653
  • +0/-0
  • Watch this space
    • Workgroup Technology Solutions
Re: smeserver-phpmyadmin-mulituser 2.11.3-3 fails
« Reply #1 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.

Offline daniel

  • ****
  • 146
  • +0/-0
  • Platinum Sponsor
    • http://www.charton-mgmt.com
Re: smeserver-phpmyadmin-mulituser 2.11.3-3 fails
« Reply #2 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.


Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: smeserver-phpmyadmin-mulituser 2.11.3-3 fails
« Reply #3 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.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline mrshark

  • *
  • 19
  • +0/-0
Re: smeserver-phpmyadmin-mulituser 2.11.3-3 fails
« Reply #4 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...

Offline smeghead

  • *
  • 563
  • +0/-0
Re: smeserver-phpmyadmin-mulituser 2.11.3-3 fails
« Reply #5 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!
« Last Edit: January 17, 2009, 08:18:43 AM by smeghead »
..................

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: smeserver-phpmyadmin-mulituser 2.11.3-3 fails
« Reply #6 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.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)