New to the list, and spent 4 hours today reading. Request: please add a list-specific search engine to the archives.
Current configuration: working qmail Maildir installation with courier-imap-1.4.3. Home directories for users under /home/mail/<domainname>/<username>. I host multiple domains. PostgreSQL mailusers table with fields: id (unique per user), uid (same for everyone), gid (same for everyone), username (i.e. 'ralph'), domainname (i.e. 'dilligaf.com'), and password. I need authpgsql or a suitable module to query the database as it exists today for the 'username'@'domainname', perhaps: "SELECT id, password, uid, gid, home, username FROM mailusers WHERE username = 'ralph' and domainname = 'dilligaf.com'; for authentication. I could find no obvious way to do this. The current query is sent to the sql server as: "SELECT id, '', password, uid, gid, home, '', '', username FROM mailusers WHERE id = '[EMAIL PROTECTED]' This obviously won't work because of the differing databases schema. I read under ~/authlib/README.authmysql.myownquery and was curious as to how to apply the patch mentioned there as it may be close to what I'm looking for. I obviously need to alter the query that courier-imap is passing to the pgsql server for authentication. Changing the database schema is not an option. If anyone can point me in the right direction, I'd greatly appreciate the help. It has been a frustrating day ;-) Thanks in advance, Bruce Cannon http://www.cimtel.net _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
