PhpMyAdmin -- problem with blowfishsecret

zilverling · 2010-07-01 20:05:59

It took me a while to get php, mysql and lighttpd working (with fast-cgi support), but I succeeded -- a nice puzzle.
But it proves harder to get rid of a persistent error on the phpMyAdmin home page:

The configuration file now needs a secret passphrase (blowfish_secret).

For some reason, phpMyAdmin is not detecting the blowfishsecret that I defined in /etc/webapps/phpmyadmin/conf.inc.php.

Relevant lines from pm config.inc.php

$cfg['blowfish_secret'] = 'mijngeheim'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
$cfg['Servers'][$i]['auth_type'] = 'cookie';

The pacman package places config.inc.php in /etc/webapps/phpmyadmin, with a link to that file being placed in in the phpMyAdmin home dir:

ls -l /usr/share/webapps/phpMyAdmin/config.inc.php
lrwxrwxrwx 1 http http 38 Jun 28 16:34 /usr/share/webapps/phpMyAdmin/config.inc.php -> /etc/webapps/phpmyadmin/config.inc.php

For the rest, phpmyadmin works fine, and as I will only use it locally to run a website test environment, I could probably just ignore the error, but that doesn't feel satisfying.

So any suggestions on how to solve this riddle are most welcome!

My setup:

MySQL

* Server: Localhost via UNIX socket
* Server version: 5.1.47
* Protocol version: 10
* User: root@localhost
* MySQL charset: UTF-8 Unicode (utf8)

Web server

* lighttpd/1.4.26
* MySQL client version: mysqlnd 5.0.7-dev - 091210 - $Revision: 294543 $
* PHP extension: mysql

phpMyAdmin

* Version information: 3.3.4

Last edited by zilverling (2010-07-01 21:22:10)

bladesuk1 · 2011-02-27 22:50:29

This is happening for me as well, although I'm using nginx instead of lighttpd.
I did find some posts elsewhere online talking about setting the owner/group of the phpMyAdmin directory to the appropriate user for the server, but that didn't work for me.
Did you ever get to the bottom of this, or is this still effectively an open issue for you?

bladesuk1 · 2011-02-27 23:07:15

actually, scrap that last message. i appear to have fixed the issue.

go to /usr/share/webapps/phpMyAdmin/ and create the config directory as suggested in the phpMyAdmin documentation. copy the config.sample.inc.php file into the new directory and call it config.inc.php.

then, go to the [phpMyAdmin server]/setup page and load and edit the config file as desired. once done, save it out, and copy the new file back out of the config directory and set the appropriate permissions.

i found i then needed to manually add in the reference to the pma_tracking table for some reason (don't know if i missed it or if it was just left out).

but once that was done, all that was required was to shut down the browser, and i restarted nginx and php-fpm for good measure, and it all came up smelling of roses.

bsujja · 2013-09-06 17:56:15

I got the same problem. I forgot to add /etc/webapps/ to the open_basedir in my php.ini. I use nginx. In the archwiki, look for instruction relating to open_basedir if you use apache or lighttp.

Last edited by bsujja (2013-09-06 17:57:06)

ewaller · 2013-09-09 16:26:31

bsujja, Welcome to Arch Linux. Note that you are responding to a 2+ year old thread. Your response is relevant; sometimes with old threads things have changed -- this does not seem to be the case here.

I will leave the thread open, but don't expect any responses; I hope the OP has solved is problem by now

Arch Linux

#1 2010-07-01 20:05:59

PhpMyAdmin -- problem with blowfishsecret

#2 2011-02-27 22:50:29

Re: PhpMyAdmin -- problem with blowfishsecret

#3 2011-02-27 23:07:15

Re: PhpMyAdmin -- problem with blowfishsecret

#4 2013-09-06 17:56:15

Re: PhpMyAdmin -- problem with blowfishsecret

#5 2013-09-09 16:26:31

Re: PhpMyAdmin -- problem with blowfishsecret

Board footer