Hi.

I tried to get IMAP proxying to work on our two courier servers.

Current status:
Two Server share the same MySQL-database (master-/slave-setup) and are running 
courier 0.53.2 with authmysql (authlib version 0.58). I use a custom mysql 
query clause to fetch accounts from MySQL.

first of all: I know that these versions are *old*, very old. But upgrading 
courier in Gentoo is a huge Problem at the moment because newer versions 
contain some bugs and no maintainer is there at present. 
As IMAP_PROXY variables are present in my example config, I assume that this 
basically should work with 0.53.2, too.


As I learned from the docs, I have to make the last MySQL result column 
("options") contain "mailhost=foobar" with foobar replaced by the real FQDN 
of the desired IMAP server host.

My authmysql config is like that:

MYSQL_SELECT_CLAUSE SELECT \
                  * FROM courier_mailaccounts \
                  WHERE '$(service)' IN ('imap', 'pop3', 'esmtp', 'login') \
                                AND account='$(local_part)@$(domain)';


An example query result looks like that:

mysql> select * from courier_mailaccounts where 
account='[EMAIL PROTECTED]'\G

*************************** 1. row ***************************
  account: [EMAIL PROTECTED]
cryptpass: $1$SJC8YTBv$Zb1sxQiIxp04ngdabR.Fa0
clearpass: NULL
      uid: 1306
      gid: 100
  homedir: /home/hannotest
  maildir: /home/hannotest/milchtest
        a:
        b: 0
        c:
  options: mailhost=milch.schokokeks.org
1 row in set (0.01 sec)

milch.schokokeks.org is the remote courier server (identical version and 
configuration). 

Now, on the proxy server, I geht this error:

Feb 14 11:30:42 zucker imapd: Connection, ip=[::ffff:127.0.0.1]
Feb 14 11:30:42 zucker imapd: proxy enabled, but no proxy host defined for 
[EMAIL PROTECTED]
Feb 14 11:30:42 zucker imapd: chdir /home/hannotest/milchtest: No such file or 
directory


Does my mysql result line look good for this purpose? What are the typical 
errors leading to this error message? where do I have to define the "proxy 
host" with authmysql and custom select clause?

cu, Bernd

Attachment: signature.asc
Description: This is a digitally signed message part.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
courier-users mailing list
[email protected]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users

Reply via email to