[horde] MySQL sessionhandler no default port

Daniel Herrero Martínez dherrero at unav.es
Mon Nov 6 02:23:17 PST 2006


Hello,

we're having trouble setting up Horde with MySQL sessions.

We don't use MySQL default port, want to use port 3307.
The problem is sessionhandler isn't getting the port value defined in our
conf.php, keeps trying to connect to port 3306.

Our config.php includes:

$conf['sql']['persistent'] = false;
$conf['sql']['hostspec'] = 'mysql-host';
$conf['sql']['username'] = 'xxxxxxxxx';
$conf['sql']['password'] = 'xxxxxxxxx';
$conf['sql']['port'] = 3307;
$conf['sql']['protocol'] = 'tcp';
$conf['sql']['database'] = 'horde';
$conf['sql']['charset'] = 'iso-8859-1';
$conf['sql']['phptype'] = 'mysql';

$conf['prefs']['params']['persistent'] = false;
$conf['prefs']['params']['hostspec'] = 'mysql-host';
$conf['prefs']['params']['username'] = 'xxxxxxxx';
$conf['prefs']['params']['password'] = 'xxxxxxxx';
$conf['prefs']['params']['port'] = 3307;
$conf['prefs']['params']['protocol'] = 'tcp';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['charset'] = 'iso-8859-1';
$conf['prefs']['params']['phptype'] = 'mysql';
$conf['prefs']['params']['table'] = 'horde_prefs';

$conf['sessionhandler']['params']['persistent'] = false;
$conf['sessionhandler']['params']['rowlocking'] = true;
$conf['sessionhandler']['params']['port'] = 3307;
$conf['sessionhandler']['params']['protocol'] = 'tcp';
$conf['sessionhandler']['params']['hostspec'] = 'mysql-host';
$conf['sessionhandler']['params']['username'] = 'xxxxxxxx';
$conf['sessionhandler']['params']['password'] = 'xxxxxxxx';
$conf['sessionhandler']['params']['database'] = 'horde';
$conf['sessionhandler']['type'] = 'mysql';


We manually checked connecting from our horde server to our MySQL on  
port 3307 with same user and password and we have no problems. Also,  
horde can access table horde_prefs in this MySQL running on port 3307.

Previous configuration of horde against MySQL on port 3306 worked perfectly.

We'?e using
horde-3.1.3
imp-h3-4.1.3
turba-h3-2.1.2
ingo-h3-1.1.1

I don't know if we are misconfiguring anything or could this be an error.
Any ideas?

Thanks!

-- 
  Daniel Herrero Martínez






----------------------------------------------------------------
Este mensaje ha sido enviado desde https://webmail.unav.es



More information about the horde mailing list