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 :)))

kind regards
S�ren Vrist, Denmark



_______________________________________________________________

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

Reply via email to