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 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] Courier MySQL authentication issue
On Thu, Apr 10, 2008 at 08:35:19PM +0200, bsd wrote: > 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… It gives a very accurate message. Almost certainly you have a mistake in your authmysqlrc, but if you don't post it, how can we help you? > 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]" and the order of columns is: username, cryptpw, clearpw, uid, gid, home, maildir, quota, fullname, options So, my guess is that in authmysqlrc you've said that your 'password' column contains an encrypted password (MYSQL_CRYPT_PWFIELD). You need to tell it that this column contains a plaintext password (MYSQL_CLEAR_PWFIELD) - 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
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