Re: courier-imap auth

[Caffeinate The World <mochaexpress@xxxxxxxxx>]

--- Alex Howansky <alex@xxxxxxxxxxxx> wrote:
> > has anyone modified courier-imap pgsql module to work with
> qmail-sql?
> > the table schema are so similiar.
> 
> Yah, it's a snap, you don't have to mod any code, just the
> authmysqlrc file.
> 
> Here's what I used:
> 
> MYSQL_SELECT_CLAUSE select userid, password, '', uid, gid, home, '.',
> quota, ''
> from users where userid = '$(local_part)' and domain = '$(domain)'
> and enabled
> and (start <= now() or start is null) and (stop >= now() or stop is
> null)
> 
> I think that's the one, anyway. There should be other example in the
> archives
> for this list.

Does your suggestion work with the PostgreSQL Courier-IMAP module as well?

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com