[horde] MySQL sessionhandler no default port

[Daniel Herrero Martínez]

Solved. For information, if anyone has the same problem:

Instead of using this to define port:
$conf['sessionhandler']['params']['hostspec'] = 'mysql-host';
$conf['sessionhandler']['params']['port'] = 3307;

I've set it up this way:
$conf['sessionhandler']['params']['hostspec'] = 'mysql-host:3307';

because in th file  lib/Horde/SessionHandler/mysql.php
there's no use of the parameter conf['sessionhandler']['params']['port'].

Up the Horde!




Daniel Herrero Martínez escribió:
> 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
>
> --Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>
>

-- 
 Daniel Herrero Martínez
-------------------------
 Universidad de Navarra
 Servicios Informáticos
 - Área de sistemas -
Tel: 948 425600 Ext.2809
 http://www.unav.es/SI