#2924 phpmyadmin, load balancer and memcache

[Vincent Alloo]

Hi,
I have an issue on my ubuntu 8.04LTS setup with phpmyadmin and memcache in a web farm.
The session are not created/read OK, I can't login if I have more than 1 web server in the farm.
My others PHP applications using PHP sessions are working fine with multiple servers. I'm using the latest version of PHP5/apache/MySQL/Memcache and phpmyadmin from the ubuntu repo.
Can you help me to debug this issue?
The message I have is:
#1045 - Access denied for user 'L ±µ:¨Ýv'@'192.168.1.3'

I have cleaned my cookies, but it doesn't fix the problem.
I have the same behaviour with hardware Cisco load balancer and LVM softwqre load balancer.

Thanks for your help.

Vincent.

[Herman van Rink]

Could it be the the config var $cfg['blowfish_secret'] in config.inc.php is different among the machines?

[Vincent Alloo]

config.inc.php is the same on all the servers (NFS). But I do not have this variable defined in my config.inc.php

[Herman van Rink]

from http://www.phpmyadmin.net/documentation/#cfg_blowfish_secret
"Since version 3.1.0 phpMyAdmin can generate this on the fly, but it makes a bit weaker security as this generated secret is stored in session and furthermore it makes impossible to recall user name from cookie."

Ubuntu seems to make use of this by leaving the option empty. I guess this works fine in a single host environment, but for you poses a problem. Adding the option to your config should solve this.

[Vincent Alloo]

Waouh, it fixes the problem. Thanks a lot.