[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: courier-imap auth
--- Michael Devogelaere <michael.devogelaere@xxxxxxxxxx> wrote:
> On Thu, Dec 19, 2002 at 03:43:31PM -0600, Alex Howansky wrote:
> > > Does your suggestion work with the PostgreSQL Courier-IMAP module
> as well?
> > Ah shoot, sorry, I was thinking of two different machines -- one
> with UW-IMAP
> > and PgSQL, and the other with Courier and MySQL. Oops. Nevermind.
> You should create a VIEW in postgres, which creates a table looking
> like the
> table courier-imap expects.
> CREATE VIEW imap AS (
> SELECT passwd.uid,
> (passwd.login || '@' ||
> passwd.virtual_host) AS id
> FROM passwd
I ended up patching the authpgsql module in Courier-IMAP to allow for
user defined SELECT and UPDATE queries from the config file like the
MySQL module. The patch was summitted to the Sam who wrote Courier.
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.