Tickets :: Comment on [#10963] problem with PostgreSQL

* Your Email Address
* Spam protection	Enter the letters below: .___.. . ..__ .__ \| \|\/\| \|[__)[__) \| \| \|\__\|\| \\|
Comment	> 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' > ) > );
Attachment
Watch this ticket

Saved Queries