[sork] [passwd] problem with PostgreSQL

Georgi Naplatanov gosho at oles.biz
Mon Feb 6 09:32:40 UTC 2012


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


More information about the sork mailing list