[horde] SQL Authentication error

[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';



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