[tpop3d-discuss]auth_pgsql problem, help please

Jakob Hirsch jh at plonk.de
Sun, 13 Jun 2004 17:12:41 +0200


Svetozar Dimitrov Marinov wrote:

just read README.auth_mysql, the password things apply to pgsql also, I
think.
in short: you have to specify the type of password you want to use, or use
the default md5. so, if you like to use plaintext passwords, put a
{plaintext} in front of them or modify your sql-query so tpop get's the
password in this format, like this:

> auth-pgsql-pass-query: select mbox_path, CONCACT('{plaintext}',password),
>  tpop3d_user,mbox_type from mbox where username = '$(user)'