[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