>Brian Candler wrote on April 09, 2008 3:27 PM > >> # AAA not working >> #MYSQL_AUXOPTIONS_FIELD >> CONCAT("disableimap=",IF($(service)='imaps',disableimaps,disableimap),",disablepop3=",disablepop3,",disablewebmail=",disablewebmail) > ... >> the thing is that mysql gets in the line AAA the -> $(service) not as >> variable (imap or imaps), because i see it in the mysql.log > > According to the documentation in authmysqlrc, $(service) only expands > within MYSQL_SELECT_CLAUSE, not MYSQL_AUXOPTIONS_FIELD > > Since MYSQL_SELECT_CLAUSE is a superset of all the other functionality, > you > should be able to rewrite your requirements as one big MYSQL_SELECT_CLAUSE > instead of using the other individual settings. > thanks it worked out. i changed my config from see below
the login via imap and pop is working, but maildrop stopped to work together this is the error message in /var/log/mail.log pr 10 23:24:37 ms1 postfix/pipe[14203]: B77C9CE8147: to=<[EMAIL PROTECTED]>, relay=maildrop, delay=706, delays=706/0/0/0.02, dsn=4.3.0, status=deferred (temporary failure. Command output: /usr/bin/maildrop: Temporary authentication failure. ) I found no way to get maildrop back to work Marco Here is the config from MYSQL_SERVER 127.0.0.1 MYSQL_USERNAME mailadmin MYSQL_PASSWORD yomanyo MYSQL_PORT 0 MYSQL_DATABASE mailserver MYSQL_USER_TABLE users MYSQL_CRYPT_PWFIELD password MYSQL_UID_FIELD 5000 MYSQL_GID_FIELD 5000 MYSQL_LOGIN_FIELD email MYSQL_HOME_FIELD "/home/vmail" MYSQL_MAILDIR_FIELD CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') MYSQL_WHERE_CLAUSE userdisabled='0' MYSQL_QUOTA_FIELD quota MYSQL_AUXOPTIONS_FIELD CONCAT("disableimap=",disableimap,",disablepop3=",disablepop3,",disablewebmail=",disablewebmail) to MYSQL_SERVER 127.0.0.1 MYSQL_USERNAME mailadmin MYSQL_PASSWORD yomanyo MYSQL_PORT 0 MYSQL_DATABASE mailserver MYSQL_SELECT_CLAUSE \ SELECT \ email,\ password,\ "",\ 5000,\ 5000,\ "/home/vmail",\ CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'),\ quota,\ "",\ CONCAT("disableimap=",IF("$(service)"="imaps",disableimaps,disableimap),",disablepop3=",IF("$(service)"="pop3s",disablepop3s,disablepop3),",disablewebmail=",disablewebmail)\ FROM users \ WHERE email = '$(local_part)@$(domain)' \ AND (userdisabled='0') ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Courier-imap mailing list Courier-imap@lists.sourceforge.net Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-imap