[horde] Configuration for Database on Different Server?

[Mauricio Jose T. Tecles]

----- Mensagem de John McIntyre <joh98.mac at gmail.com> ---------
    Data: Fri, 13 Feb 2015 11:23:23 +0000
      De: John McIntyre <joh98.mac at gmail.com>
Assunto: Re: [horde] Configuration for Database on Different Server?
    Para: "Mauricio Jose T. Tecles" <mtecles at biof.ufrj.br>
      Cc: horde at lists.horde.org, andreas at mauser.info


> 2015-02-13 11:13 GMT+00:00 Mauricio Jose T. Tecles <mtecles at biof.ufrj.br>:
>
>>
>> ----- Mensagem de John McIntyre <joh98.mac at gmail.com> ---------
>>    Data: Fri, 13 Feb 2015 10:45:57 +0000
>>      De: John McIntyre <joh98.mac at gmail.com>
>> Assunto: [horde] Configuration for Database on Different Server?
>>    Para: horde at lists.horde.org
>>
>>
>>
>>  Hi,
>>> My question vanished, so going on the basis that it never made it to the
>>> mailing list, I shall ask again.  :)
>>>
>>> Horde is almost working on my server, but when I try to run tests on
>>> kronolith, it cannot connect to the MySQL server, which is expected, since
>>> they are now on separate servers.  Can someone tell me where to configure
>>> the horde so that it can use a separate database server, and also a
>>> separate mail server?
>>>
>>
>> For the database, Administration -> Configuration -> Horde -> Database ->
>> $conf[sql][username], $conf[sql][password], $conf[sql][database],
>> $conf[sql][protocol] -> TCP/IP -> $conf[sql][hostspec], $conf[sql][port].
>>
>> For the mail server, if Imp is the application to handle authentication,
>> create and configure horde/imp/config/backends.local.php to use your
>> (probably) IMAP and SMTP server with secure connection (read backends.php).
>> Search about this topic on the list (there are some about it recently).
>>
>
> Hi guys,
> Thanks for that.  I've got it for the backends.php. However, I can't
> configure anything on the GUI since  there *is* no GUI running.
>

You can backup your horde/config/conf.php, copy conf.php.dist to  
conf.php and reconfigure it or edit it. See below.

> As for the php.conf, this is what mine looks like, concerning MySQL ..
>
> $conf['sql']['username'] = '***********';
> $conf['sql']['password'] = '**************';
> $conf['sql']['socket'] = '/var/lib/mysql/mysql.sock';
> $conf['sql']['protocol'] = 'unix';
> $conf['sql']['database'] = '*******';
> $conf['sql']['charset'] = 'utf-8';
> $conf['sql']['ssl'] = false;
> $conf['sql']['splitread'] = false;
> $conf['sql']['phptype'] = 'mysql';
> $conf['nosql']['phptype'] = false
>
> I tried putting the servername in there as:
>
> $conf['sql']['server'] = '192.168..etc..';
>
> No joy.

No, you are not using socket you must use TCP, try something like:

$conf['sql']['username'] = '***';
$conf['sql']['password'] = '***';
$conf['sql']['hostspec'] = 'your mysql server IP (192.168...)';
$conf['sql']['port'] = 3306;
$conf['sql']['protocol'] = 'tcp';
$conf['sql']['database'] = 'horde';
$conf['sql']['charset'] = 'utf-8';
$conf['sql']['ssl'] = true;
$conf['sql']['splitread'] = false;
$conf['sql']['phptype'] = 'mysqli';

I would try to connect to the Mysql server without security (ssl)  
first, to make things easier, than add ssl.

Mauricio

----- Final da mensagem de John McIntyre <joh98.mac at gmail.com> -----




Maurício José T. Tecles
Núcleo de Informática
Instituto de Biofísica Carlos Chagas Filho - UFRJ
mtecles at biof.ufrj.br
Tel.: (21) 3938-6526 ou 3938-6544