[horde] Configuration for Database on Different Server?

[John McIntyre]

2015-02-13 11:53 GMT+00:00 Mauricio Jose T. Tecles <mtecles at biof.ufrj.br>:

>
> ----- 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).
>
>
Hi,
I configure MySQL in the database to accept connections.  Anyway, that
'hostspec' was what I was looking for.  All looking good, I can get all
green when I run tests on kronolith.  And I can now login to my instance.

Hmm .. another issue.  I login, the calendar appears .. and then half a
second later, I'm logged out and back to the login page.... guessing some
sort of session token that I need to configure ?