[horde] SQL Authentication error

[Michael J Rubinsky]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 9272 bytes
Desc: PGP Public Key
URL: <https://lists.horde.org/archives/horde/attachments/20180516/9bebcbd9/attachment-0002.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 821 bytes
Desc: PGP Digital Signature
URL: <https://lists.horde.org/archives/horde/attachments/20180516/9bebcbd9/attachment-0003.bin>