[horde] Configuration for Database on Different Server?

[John McIntyre]

Bump ..?



2015-02-13 12:11 GMT+00:00 John McIntyre <joh98.mac at gmail.com>:

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