[sork] [passwd] problem with PostgreSQL

[Georgi Naplatanov]

Hi Ralf.

I created a ticket - http://bugs.horde.org/ticket/10963.

 > Do you have the php-pdo driver for postgres installed? Does postgres
 > work for you for the rest of the horde setup?

Yes, pdo driver for PostgreSQL is installed, I can see that with 
phpinfo(). The rest of Horde seem to work without problems.

 > Do you use a git checkout or the recent pear release of passwd?

I installed recent pear release with :

pear install -a -B horde/passwd

Best regards
Georgi

On 02/06/2012 11:44 AM, Ralf Lang wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Am 06.02.2012 10:32, schrieb Georgi Naplatanov:
>> Hi.
>>
>> I tried to configure Passwd 4.0 with PostfixAdmin on PostgreSQL,
>> but without success.
>>
>> The Passwd message when I try to change my password is "Password
>> module is not properly configured" and the error in syslog is :
>>
>> HORDE: [passwd] Could not instantiate PDO with DSN
>> "pgsql:port=5432;encryption=plain;table=mailbox;user_col=username;pass_col=password;query_lookup=SELECT
>>
>>
> password FROM mailbox WHERE username = %u and active =
>> 1;query_modify=UPDATE mailbox SET password = %p WHERE username =
>> %u;host=127.0.0.1;dbname=postfix".  PDOException: SQLSTATE[08006]
>> [7] invalid connection option "encryption" [pid 24188 on line 100
>> of "/var/www/horde4/passwd/lib/Factory/Driver.php"]
>>
>> My backends.php is:
>>
>> $backends['postfixadmin'] = array ( 'disabled' =>  false, 'name' =>
>> 'Postfix Admin server', 'preferred' =>  '', 'policy' =>  array(
>> 'minLength' =>  6, 'maxLength' =>  20, 'minNumeric' =>  1, ), 'driver'
>> =>  'Sql', 'params' =>  array( 'phptype' =>  'pgsql', 'hostspec' =>
>> '127.0.0.1', 'protocol'   =>  'tcp', 'port'  =>  '5432', 'charset' =>
>> 'utf-8', 'username' =>  'postfix', 'password' =>  'password',
>> 'database' =>  'postfix', 'encryption' =>  'plain', 'table' =>
>> 'mailbox', 'user_col' =>  'username', 'pass_col' =>  'password',
>> 'show_encryption' =>  false, // The following two settings allow you
>> to specify custom queries for // lookup and modify functions if
>> special functions need to be // performed.  In places where a
>> username or a password needs to be // used, refer to this
>> placeholder reference: //    %d ->  gets substituted with the
>> domain //    %u ->  gets substituted with the user //    %U ->  gets
>> substituted with the user without a domain part //    %p ->  gets
>> substituted with the plaintext password //    %e ->  gets
>> substituted with the encrypted password // 'query_lookup' =>
>> 'SELECT password FROM mailbox WHERE username = %u and active = 1',
>> 'query_modify' =>  'UPDATE mailbox SET password = %p WHERE username
>> = %u' ) );
>>
>> I don't know what to do, help me please.
>>
>> Best regards Georgi
>
> Do you have the php-pdo driver for postgres installed? Does postgres
> work for you for the rest of the horde setup?
> Do you use a git checkout or the recent pear release of passwd?
> Please open a ticket on bugs.horde.org, I will look at it by wednesday.
>
> - --
> Ralf Lang
> Linux Consultant / Developer
> Tel.: +49-170-6381563
> Mail: lang at b1-systems.de
>
> B1 Systems GmbH
> Osterfeldstra�e 7 / 85088 Vohburg / http://www.b1-systems.de
> GF: Ralph Dehner / Unternehmenssitz: Vohburg / AG: Ingolstadt,HRB 3537
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.18 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iEYEARECAAYFAk8voPMACgkQCs1dsHJ/X7A80QCgxw4kGiHnL9d92qu6dK4ZsqLZ
> 0PEAoKKyfWgrnEDM4cRPeCFYzoptGr5b
> =QNMv
> -----END PGP SIGNATURE-----