>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
