[horde] How to connect to mysql DB remotely

[John Bravo]

Quoting Etienne Goyer <etienne.goyer at linuxquebec.com>:

> JBRAVO at forbin.qc.edu wrote:
> > 
> > Hi all,
> > 
> >   I have browsed the net but no luck, does anyone know how to set up horde
> to
> > remotely connect too mysql db on another server? In horde.php, I changed
> > $conf['prefs']['params']['hostspec'] = '192.168.5.250';
> > but still no luck. Any help at all would be great thanks alot.
> 
> Check the port params too.  Default is not good, IIRC.
> 
I added the port and within horde.log it said Failure to connect to
horde at 192.168.5.250 but still won't work?
-------
$conf['prefs']['params']['phptype'] = 'mysql';
$conf['prefs']['params']['hostspec'] = '192.168.5.250';
$conf['prefs']['params']['port'] = '3306';
$conf['prefs']['params']['username'] = 'horde';
$conf['prefs']['params']['password'] = '*****';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table'] = 'horde_prefs';
-------