Re: [Courier-imap] autmysqlrc - service feedback
Sam wrote: 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 Which one of the three configuration options, that are described in the note on the first page of maildrop's INSTALL file, did you choose to implement? hm I am not really sure about this question. I downloaded the source an looked into the file. The error only shows up then i switch to the version whree i can use the MYSQL_SELECT_CLAUSE in authmysqlrc The system is debian etch (stable), no manual build was done. I configured maildrop in postfix I added the config files main.cf http://pastebin.ca/984100 master.cf http://pastebin.ca/984101 any hints? Marco - 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
Re: [Courier-imap] autmysqlrc - service feedback
On Thu, Apr 10, 2008 at 11:34:38PM +0200, Marco Kammerer wrote: 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. ) Have you tried authtest [EMAIL PROTECTED] ? What does it show? If it fails, do you see anything in logs if you crank up authdaemond logging? http://www.courier-mta.org/authlib/README.authdebug.html - 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
Re: [Courier-imap] autmysqlrc - service feedback
On Wed, Apr 09, 2008 at 05:03:28PM +0200, Marco Kammerer wrote: Is there also a way to determine which IP Adress the Client has. No, this information is not passed from the frontend to authdaemond. There have been a couple of patches which add the IP address to the authdaemond protocol posted over the last few years, but not accepted into the mainstream. Any policy based on IP address currently has to live at the frontend, not the authentication backend. See the couriertcpd -access option, which can set environment variables based on IP address. I believe it's possible to use this feature to set the service name, but you'll need to google/search the list archives. Regards, Brian. - 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
Re: [Courier-imap] autmysqlrc - service feedback
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
Re: [Courier-imap] autmysqlrc - service feedback
Marco Kammerer writes: 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 Which one of the three configuration options, that are described in the note on the first page of maildrop's INSTALL file, did you choose to implement? pgpidv0LbKUYf.pgp Description: PGP signature - 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
Re: [Courier-imap] autmysqlrc - service feedback
Brian Candler [EMAIL PROTECTED] wrote on Wednesday, April 09, 2008 3:27 PM On Sat, Apr 05, 2008 at 12:19:03AM +0200, Marco Kammerer wrote: # AAA not working #MYSQL_AUXOPTIONS_FIELD CONCAT(disableimap=,IF($(service)='imaps',disableimaps,disableimap),,disa blepop3=,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. Thank you very much, Brian Is there also a way to determine which IP Adress the Client has. I have now answer found regarding this question in any howto or manual. I want to get it working, that I can restrict imap access on a accounts basis (via mysql) to ip addresses. Marco - 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