Re: courier-imap auth

[Alex Howansky <alex@xxxxxxxxxxxx>]

> 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.

-- 
Alex Howansky
Wankwood Associates
http://www.wankwood.com/