[horde] Configuration for Database on Different Server?

[Mauricio Jose T. Tecles]

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


> ----- 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

In addition, Mysql must be configured to accept the connection (my.cnf).

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
>
> -- 
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>
> -- 
> This mail was scanned by BitDefender
> For more information please visit http://www.bitdefender.com/


----- Final da mensagem de "Mauricio Jose T. Tecles"  
<mtecles at biof.ufrj.br> -----




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