[sork] [passwd] problem with PostgreSQL

[Ralf Lang]

-----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-----