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
[Courier-imap] Courier MySQL authentication issue
Hello, I have configured Courier to use a MySQL Backend, password are stored in cleartext format. When authenticating I have this strange issue wher Courier tells me: supplied password 'atest' does not match encrypted password 'atest // very strange message… # # Debug # # Apr 10 20:22:49 sd-12545 pop3d: Connection, ip=[:::123.66.xx.tt] Apr 10 20:22:49 sd-12545 authdaemond: received auth request, service=pop3, authtype=login Apr 10 20:22:49 sd-12545 authdaemond: authmysql: trying this module Apr 10 20:22:49 sd-12545 authdaemond: SQL query: SELECT username, password, , 2001, 2001, '/var/mail/', maildir, , name, FROM mailbox WHERE username = [EMAIL PROTECTED] Apr 10 20:22:49 sd-12545 authdaemond: supplied password 'atest' does not match encrypted password 'atest' Apr 10 20:22:49 sd-12545 authdaemond: authmysql: REJECT - try next module Apr 10 20:22:49 sd-12545 authdaemond: FAIL, all modules rejected I have tried to change some parameters in my configuration, without any success. It looks like Courier-Imap is expecting an encrypted passwd ?? Any help will be welcome… Gregober --- PGP ID -- 0x1BA3C2FD bsd @at@ todoo.biz P Please consider your environmental responsibility before printing this e-mail - 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