[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [tpop3d-discuss]auth_pgsql problem, help please
From: |
Jakob Hirsch |
Subject: |
Re: [tpop3d-discuss]auth_pgsql problem, help please |
Date: |
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)'