[horde] SQL Authentication error
meberhardt at unl.edu.ar
meberhardt at unl.edu.ar
Wed May 16 18:32:37 UTC 2018
That's it, sorry.
Most of the configuration was generated with Horde's configuration
interface and saved in conf.local.php.
The app part was in conf.php
Thanks for your help!
Matias
Michael J Rubinsky <mrubinsk at horde.org> escribió:
> Quoting meberhardt at unl.edu.ar:
>
>> Thanks for your response, Michael.
>>
>> This is the auth part of our conf.php:
>>
>> $conf['auth']['params']['username'] = '****'; //db user
>> $conf['auth']['params']['password'] = '****'; //db passwd
>> $conf['auth']['params']['hostspec'] = '****'; //db host
>> $conf['auth']['params']['port'] = 5433;
>> $conf['auth']['params']['protocol'] = 'tcp';
>> $conf['auth']['params']['database'] = 'mail';
>> $conf['auth']['params']['charset'] = 'utf-8';
>> $conf['auth']['params']['splitread'] = false;
>> $conf['auth']['params']['logqueries'] = false;
>> $conf['auth']['params']['phptype'] = 'pgsql';
>> $conf['auth']['params']['driverconfig'] = 'custom';
>> $conf['auth']['params']['table'] = 'mailbox';
>> $conf['auth']['params']['username_field'] = 'username';
>> $conf['auth']['params']['password_field'] = 'password';
>> $conf['auth']['params']['encryption'] = 'crypt-md5';
>> $conf['auth']['params']['show_encryption'] = false;
>> $conf['auth']['driver'] = 'sql';
>> $conf['auth']['params']['count_bad_logins'] = true;
>> $conf['auth']['params']['login_block'] = true;
>> $conf['auth']['params']['login_block_count'] = 5;
>> $conf['auth']['params']['login_block_time'] = 10;
>> $conf['auth']['checkip'] = false;
>> $conf['auth']['resetpassword'] = true;
>> $conf['auth']['redirect_on_logout'] = false;
>> $conf['auth']['list_users'] = 'list';
>> $conf['auth']['params']['app'] = 'imp';
>
> If you are using a sql authentication driver, why are you passing
> the 'app' parameter? Did you manually edit this file or did you use
> Horde's configuration interface to generate it?
>
>
>
>> Michael J Rubinsky <mrubinsk at horde.org> escribió:
>>
>>> Quoting meberhardt at unl.edu.ar:
>>>
>>>> Hi all,
>>>>
>>>> I'm trying to configure Horde with "SQL Authentication with
>>>> custom-made queries".
>>>>
>>>> I followed this old how-to: https://wiki.horde.org/sqlauthhowto
>>>>
>>>> I've changed "hordeauth" to "full" in IMP backends and the
>>>> suggested configuration in horde/conf.php.
>>>>
>>>> Horde thows the next error:
>>>>
>>>> Uncaught exception 'Horde_Db_Exception' with message 'Could not
>>>> instantiate PDO. PDOException: SQLSTATE[08006] [7] invalid
>>>> connection option «app»
>>>> Stack trace:
>>>> #0 /usr/share/php/Horde/Db/Adapter/Pdo/Pgsql.php(88):
>>>> Horde_Db_Adapter_Pdo_Base->connect()
>>>> #1 /usr/share/php/Horde/Db/Adapter/Base.php(157):
>>>> Horde_Db_Adapter_Pdo_Pgsql->connect()
>>>> #2 /usr/share/php/Horde/Core/Factory/Db.php(189):
>>>> Horde_Db_Adapter_Base->__construct(Array)
>>>> #3 /usr/share/php/Horde/Core/Factory/Db.php(106):
>>>> Horde_Core_Factory_Db->_createDb(Array, 'c9a1e33da7b4785...')
>>>> #4 /usr/share/php/Horde/Core/Factory/Auth.php(171):
>>>> Horde_Core_Factory_Db->create('horde', 'auth')
>>>> #5 /usr/share/php/Horde/Core/Factory/Auth.php(52):
>>>> Horde_Core_Factory_Auth->_create('sql')
>>>> #6 /usr/share/php/Horde/Registry.php(2247):
>>>> Horde_Core_Factory_Auth->create()
>>>> #7 /usr/share/php/Horde/ErrorHandler.php(59):
>>>> Horde_Registry->getLogoutUrl(Array)
>>>> #8 /usr/share/horde/imp/lib/Application.php(620):
>>>> Horde_ErrorHandler::f [pid 27653 on line 48 of
>>>> "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
>>>>
>>>> What am I doing wrong?
>>>>
>>>> Software versions:
>>>> SO: Debian 9
>>>> Horde 5.2.17
>>>> Postgres client & server 9.6
>>>> PHP 7.0.27
>>>>
>>>> Thanks in advance.
>>>
>>> Can you post the full authentication configuration stanza from conf.php?
>>>
>>>>
>>>> Matías
>>>>
>>>>
>>>> /* --------------------------------------------------------------- */
>>>> /* Matías A. Eberhardt */
>>>> /* */
>>>> /* Centro de Telemática */
>>>> /* Secretaría General */
>>>> /* UNIVERSIDAD NACIONAL DEL LITORAL */
>>>> /* Pje. Martínez 2652 - S3002AAB Santa Fe - Argentina */
>>>> /* tel +54(342)455-4245 - FAX +54(342)457-1240 */
>>>> /* --------------------------------------------------------------- */
>>>>
>>>> --
>>>> Horde mailing list
>>>> Frequently Asked Questions: http://horde.org/faq/
>>>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>>>
>>>
>>>
>>> --
>>> mike
>>> The Horde Project
>>> http://www.horde.org
>>> https://www.facebook.com/hordeproject
>>> https://www.twitter.com/hordeproject
>>
>>
>>
>> /* --------------------------------------------------------------- */
>> /* Matías A. Eberhardt */
>> /* */
>> /* Centro de Telemática */
>> /* Secretaría General */
>> /* UNIVERSIDAD NACIONAL DEL LITORAL */
>> /* Pje. Martínez 2652 - S3002AAB Santa Fe - Argentina */
>> /* tel +54(342)455-4245 - FAX +54(342)457-1240 */
>> /* --------------------------------------------------------------- */
>>
>> --
>> Horde mailing list
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>
>
>
> --
> mike
> The Horde Project
> http://www.horde.org
> https://www.facebook.com/hordeproject
> https://www.twitter.com/hordeproject
/* --------------------------------------------------------------- */
/* Matías A. Eberhardt */
/* */
/* Centro de Telemática */
/* Secretaría General */
/* UNIVERSIDAD NACIONAL DEL LITORAL */
/* Pje. Martínez 2652 - S3002AAB Santa Fe - Argentina */
/* tel +54(342)455-4245 - FAX +54(342)457-1240 */
/* --------------------------------------------------------------- */
More information about the horde
mailing list