Re: [passwd] problem with PostgreSQL

-----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=3D5432;encryption=3Dplain;table=3Dmailbox;user_col=3Dusername=
;pass_col=3Dpassword;query_lookup=3DSELECT
>
> =

password FROM mailbox WHERE username =3D %u and active =3D
> 1;query_modify=3DUPDATE mailbox SET password =3D %p WHERE username =3D =

> %u;host=3D127.0.0.1;dbname=3Dpostfix".  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'] =3D array ( 'disabled' =3D> false, 'name' =3D>
> 'Postfix Admin server', 'preferred' =3D> '', 'policy' =3D> array( =

> 'minLength' =3D> 6, 'maxLength' =3D> 20, 'minNumeric' =3D> 1, ), 'driver'
> =3D> 'Sql', 'params' =3D> array( 'phptype' =3D> 'pgsql', 'hostspec' =3D>
> '127.0.0.1', 'protocol'   =3D> 'tcp', 'port'  =3D> '5432', 'charset' =3D>
> 'utf-8', 'username' =3D> 'postfix', 'password' =3D> 'password', =

> 'database' =3D> 'postfix', 'encryption' =3D> 'plain', 'table' =3D>
> 'mailbox', 'user_col' =3D> 'username', 'pass_col' =3D> 'password', =

> 'show_encryption' =3D> 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' =3D>
> 'SELECT password FROM mailbox WHERE username =3D %u and active =3D 1', =

> 'query_modify' =3D> 'UPDATE mailbox SET password =3D %p WHERE username
> =3D %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: [email protected]

B1 Systems GmbH
Osterfeldstra=DFe 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
=3DQNMv
-----END PGP SIGNATURE-----
-- =

Sork mailing list - Join the hunt: http://horde.org/bounties/#sork
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: [email protected]