[horde] SQL Authentication error
meberhardt at unl.edu.ar
meberhardt at unl.edu.ar
Tue May 15 17:23:42 UTC 2018
This is the config using CustomSQL driver, same error:
$conf['auth']['params']['phptype'] = 'pgsql';
$conf['auth']['params']['hostspec'] = '****'; //db host
$conf['auth']['params']['port'] = 5433;
$conf['auth']['params']['protocol'] = 'tcp';
$conf['auth']['params']['username'] = '****'; //db user
$conf['auth']['params']['password'] = '****'; // db passwd
$conf['auth']['params']['database'] = 'mail';
$conf['auth']['params']['query_auth'] = 'SELECT * FROM mailbox WHERE
username = \L AND password = \P';
$conf['auth']['params']['query_getpw'] = 'SELECT password FROM mailbox
WHERE username=\L';
$conf['auth']['params']['query_resetpassword'] = 'UPDATE mailbox SET
password=\P WHERE username=\L';
$conf['auth']['params']['query_list'] = 'SELECT * FROM mailbox';
$conf['auth']['params']['query_exists'] = 'SELECT 1 FROM mailbox WHERE
username=\L';
$conf['auth']['params']['encryption'] = 'crypt-md5';
$conf['auth']['params']['show_encryption'] = false;
$conf['auth']['driver'] = 'customsql';
$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'] = 5;
$conf['auth']['resetpassword'] = true;
$conf['auth']['redirect_on_logout'] = false;
$conf['auth']['list_users'] = 'list';
$conf['auth']['params']['app'] = 'imp';
meberhardt at unl.edu.ar escribió:
> 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 */
> /* --------------------------------------------------------------- */
>
> --
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
/* --------------------------------------------------------------- */
/* 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