[Tickets #10963] problem with PostgreSQL

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/10963
------------------------------------------------------------------------------
  Ticket             | 10963
  Created By         | gosho at oles.biz
  Summary            | problem with PostgreSQL
  Queue              | Passwd
  Version            | 4.0
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


gosho at oles.biz (2012-02-06 10:00) wrote:

Hi.

I tried to configure Passwd 4.0 with PostfixAdmin on PostgreSQL, but  
without success.
My environment is Debian 6 (Squeeze) AMD64, PHP 5.3.3, PostgreSQL 8.4.  
pear - from the distribution.

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