--S�ren Vrist wrote on 29.05.2002 14:22 +0200:
> There seems to be an error in the sql in authmysqlrc.dist: (in my
> FreeBSD4.5 ports editon of Courier-imap 1.4.3)
> > # MYSQL_SELECT_CLAUSE SELECT popbox.local_part, > #
> CONCAT('{MD5}', popbox.password_hash), \
> # domain.uid, \
> # domain.gid, \
> # popbox.clearpw, \
> # CONCAT(domain.path, '/', popbox.mbox_name), \
> # '', \
> # domain.quota, \
> # '', \
> # FROM popbox, domain \
> # WHERE popbox.local_part = '$(local_part)' \ > #
> AND popbox.domain_name = '$(domain)' \
> # AND popbox.domain_name = domain.domain_name
> #
> > You can't have an comma right before the from statement ?
> And when i looked through the source for authmysql i seemed as though
> you would get a authfailure if you don't fill something in the maildir
> field, but in this example its set to ''....Maybe its just me, i'm not
> that good a C :)))
The order listed few lines above is also bad and should be fixed...
- # username, cryptpw, uid, gid, clearpw, home, maildir, quota, fullname
+ # username, cryptpw, clearpw, gid, home, maildir, quota, fullname
Anyway, I got a split local/host scheme work with this clause:
MYSQL_SELECT_CLAUSE SELECT local,'',clear,7780,7780, \
'/relay/home/$(local_part)','.',quota,name \
FROM passwd WHERE local='$(local_part)' \
AND (domain='$(local_part)' OR domain='$(domain)')
This is used for authentification only, Users with 'Domain-POP'
should be able to simply use the name of their domain for login.
There was also a small patch necessary because authmysql died
if no hostpart was supplied at login.
A scheme which also supports catchall-delivery would look
like this: (off my head, untested)
WHERE (local='$(local_part)'AND domain='$(domain)') \
OR (local='alias' AND domain='$(local_part)')
Roland
_______________________________________________________________
Don't miss the 2002 Sprint PCS Application Developer's Conference
August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
_______________________________________________
courier-users mailing list
[EMAIL PROTECTED]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
