Hi Jeff,
Thanks for the input. It appears that courier is logging to my
mail.log file. MySQL is logging to mysql.log. Postfix events turn up
in both log files. However, courier authentication events only turn up
in mail.log and not in mysql.log.
I see this entry in my mail.log file when I try to authenticate
against courier imap using a telnet session.
*****************************************************
[r...@cloud1:/etc/init.d ] #:telnet cloud1 143
Trying 127.0.0.1...
Connected to cloud1.newdom.com.
Escape character is '^]'.
* OK [CAPABILITY IMAP4rev1 UIDPLUS CHILDREN NAMESPACE
THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA IDLE ACL
ACL2=UNION] Courier-IMAP ready. Copyright 1998-2008 Double Precision,
Inc. See COPYING for distribution information.
a1 LOGIN bluethundr secretPass
* BYE Temporary problem, please try again later
Connection closed by foreign host.
*****************************************************************************
This causes the following transaction in my mail.log file. As I
mentioned mysql.log doesn't show any activity.
Apr 26 18:51:16 cloud1 imapd: Connection, ip=[127.0.0.1]
Apr 26 18:51:23 cloud1 imapd: authdaemon: s_connect() failed: No such
file or directory
Apr 26 18:51:23 cloud1 imapd: LOGIN FAILED, user=bluethundr, ip=[127.0.0.1]
Apr 26 18:51:23 cloud1 imapd: authentication error: No such file or directory
**********************************************************************
However courier, postfix and mysql are running as the following output
demonstrates:
*********************************************************************
[r...@cloud1:/var/log ] #:ps -ef | grep imap
root 2794 1 0 18:31 ? 00:00:00
/usr/local/sbin/courierlogger -pid=/var/run/imapd.pid -start
-name=imapd /usr/lib/courier-imap/libexec/couriertcpd -address=0
-maxprocs=40 -maxperip=4 -nodnslookup -noidentlookup 143
/usr/lib/courier-imap/sbin/imaplogin /usr/lib/courier-imap/bin/imapd
Maildir
root 2795 2794 0 18:31 ? 00:00:00
/usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40
-maxperip=4 -nodnslookup -noidentlookup 143
/usr/lib/courier-imap/sbin/imaplogin /usr/lib/courier-imap/bin/imapd
Maildir
root 2989 2923 0 18:52 pts/4 00:00:00 grep imap
******************************************************************
[r...@cloud1:/var/log ] #:ps -ef | grep courier
root 2026 1 0 18:27 ? 00:00:00
/usr/sbin/courierlogger -pid=/var/run/courier/authdaemon/pid -start
/usr/lib/courier/authlib/authdaemond.mysql
root 2027 2026 0 18:27 ? 00:00:00
/usr/lib/courier/authlib/authdaemond.mysql
root 2043 2027 0 18:27 ? 00:00:00
/usr/lib/courier/authlib/authdaemond.mysql
root 2044 2027 0 18:27 ? 00:00:00
/usr/lib/courier/authlib/authdaemond.mysql
root 2045 2027 0 18:27 ? 00:00:00
/usr/lib/courier/authlib/authdaemond.mysql
root 2046 2027 0 18:27 ? 00:00:00
/usr/lib/courier/authlib/authdaemond.mysql
root 2047 2027 0 18:27 ? 00:00:00
/usr/lib/courier/authlib/authdaemond.mysql
daemon 2048 1 0 18:27 ? 00:00:00 /usr/bin/perl -w
/usr/sbin/couriergraph.pl -l /var/log/mail.log -d
--daemon_rrd=/var/lib/couriergraph --rrd_name=couriergraph
root 2794 1 0 18:31 ? 00:00:00
/usr/local/sbin/courierlogger -pid=/var/run/imapd.pid -start
-name=imapd /usr/lib/courier-imap/libexec/couriertcpd -address=0
-maxprocs=40 -maxperip=4 -nodnslookup -noidentlookup 143
/usr/lib/courier-imap/sbin/imaplogin /usr/lib/courier-imap/bin/imapd
Maildir
root 2795 2794 0 18:31 ? 00:00:00
/usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=40
-maxperip=4 -nodnslookup -noidentlookup 143
/usr/lib/courier-imap/sbin/imaplogin /usr/lib/courier-imap/bin/imapd
Maildir
root 2991 2923 0 18:53 pts/4 00:00:00 grep courier
*****************************************************************************
[r...@cloud1:/var/log ] #:netstat -tulpn
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address
State PID/Program name
tcp 0 0 127.0.0.1:60000 0.0.0.0:*
LISTEN 1640/postgrey.pid -
tcp 0 0 127.0.0.1:10025 0.0.0.0:*
LISTEN 2581/master
tcp 0 0 127.0.0.1:3306 0.0.0.0:*
LISTEN 2702/mysqld
tcp 0 0 0.0.0.0:143 0.0.0.0:*
LISTEN 2795/couriertcpd
tcp 0 0 0.0.0.0:80 0.0.0.0:*
LISTEN 2378/apache2
tcp 0 0 0.0.0.0:22 0.0.0.0:*
LISTEN 2294/sshd
tcp 0 0 0.0.0.0:25 0.0.0.0:*
LISTEN 2581/master
udp 0 0 0.0.0.0:68 0.0.0.0:*
1885/dhclient3
*******************************************************************************************
My authmysqlrc looks right to me:
*********************************************
MYSQL_USERNAME mail
MYSQL_PASSWORD secretPass
MYSQL_DATABASE maildb
MYSQL_USER_TABLE users
MYSQL_CRYPT_PWFIELD crypt
# MYSQL_CLEAR_PWFIELD clear
MYSQL_MAILDIR_FIELD concat(home,'/',maildir)
MYSQL_WHERE_CLAUSE enabled=1
*********************************************
I am specifying authmysql as the connection type in /etc/courier/authdaemonrc
*************************************************
authmodulelist="authmysql"
**********************************
It seems obvious to me at this point that courier imap is simply not
communicating with the mysql authentication database. I am unclear
however which steps I am missing. I would appreciate it if someone
with a higher level view of the situation than myself could help me
put these clues together.
On Mon, Apr 26, 2010 at 8:05 AM,
<courier-users-requ...@lists.sourceforge.net> wrote:
> Send courier-users mailing list submissions to
> courier-us...@lists.sourceforge.net
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.sourceforge.net/lists/listinfo/courier-users
> or, via email, send a message with subject or body 'help' to
> courier-users-requ...@lists.sourceforge.net
>
> You can reach the person managing the list at
> courier-users-ow...@lists.sourceforge.net
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of courier-users digest..."
>
> Today's Topics:
>
> 1. Re: can't get courier to authenticate (Jeff Jansen)
> 2. backscatter and mailfilter (Jeff Jansen)
> 3. Re: backscatter and mailfilter (Sam Varshavchik)
> 4. Re: backscatter and mailfilter (Jeff Jansen)
>
>
> ---------- Forwarded message ----------
> From: Jeff Jansen <jeff.jan...@kkoncepts.net>
> To: courier-us...@lists.sourceforge.net
> Date: Mon, 26 Apr 2010 09:36:07 +0800
> Subject: Re: [courier-users] can't get courier to authenticate
> Tim Dunphy <bluethu...@gmail.com> wrote on 2010-Apr-26:
>> Ideally I'd like to figure out to at least turn on courier logging so
>> that I can help diagnose this problem. But when I looked in my
>> /var/log directory I didn't see any logs pertaining to courier.
>
> Dear Tim,
>
> Courier doesn't do its own logging; it uses syslog. So check where ever your
> syslog is logging the "mail" facility to - probably /var/log/maillog or
> /var/log/mail.log or something like that depending on your OS.
>
> Then turn on logging for mysql so you can see what mysql is doing.
>
> Between courier's logs and mysql's logs, you should have a better picture of
> what's going wrong.
>
> HTH
>
> Jeff Jansen
>
>
>
>
> ---------- Forwarded message ----------
> From: Jeff Jansen <jeff.jan...@kkoncepts.net>
> To: Courier Users List <courier-users@lists.sourceforge.net>
> Date: Mon, 26 Apr 2010 15:06:39 +0800
> Subject: [courier-users] backscatter and mailfilter
> I have a user who has set a low SIZE limit with a mailfilter because of
> bandwidth limitations where they are located. So they bounce anything bigger
> than 100 KB with a message explaining that they can't accept anything larger
> and
> so please remove any photos, dancing bunny gifs, etc. and resend.
>
> Unfortunately, after they bounce a message, their address goes on the
> backscatter list and then *everything* bounces for the next couple of hours.
>
> Is there any way NOT to trigger backscatter suppression when a mailfilter has
> rejected the message? Right now the mailfilter exits with "EXITCODE=77". Is
> there an exit code that will bounce the message but doesn't trigger
> backscatter
> suppression?
>
> This is courier 0.59.0 on Ubuntu Hardy from the Ubuntu repositories.
>
> TIA
>
> Jeff Jansen
>
>
>
>
> ---------- Forwarded message ----------
> From: Sam Varshavchik <mr...@courier-mta.com>
> To: Courier Users List <courier-users@lists.sourceforge.net>
> Date: Mon, 26 Apr 2010 07:05:54 -0400
> Subject: Re: [courier-users] backscatter and mailfilter
> Jeff Jansen writes:
>
>> I have a user who has set a low SIZE limit with a mailfilter because of
>> bandwidth limitations where they are located. So they bounce anything bigger
>> than 100 KB with a message explaining that they can't accept anything larger
>> and
>> so please remove any photos, dancing bunny gifs, etc. and resend.
>>
>> Unfortunately, after they bounce a message, their address goes on the
>> backscatter list and then *everything* bounces for the next couple of hours.
>>
>> Is there any way NOT to trigger backscatter suppression when a mailfilter has
>> rejected the message? Right now the mailfilter exits with "EXITCODE=77". Is
>> there an exit code that will bounce the message but doesn't trigger
>> backscatter
>> suppression?
>>
>> This is courier 0.59.0 on Ubuntu Hardy from the Ubuntu repositories.
>
> Try an exit code of 70, this will bounce the mail without triggering
> backscatter suppression.
>
> Alternatively, use an exit code of 99. This is a temporary delivery failure,
> the mail does not get bounced but deferred, and backscatter suppression will
> also use a temporary status code, deferring the mail at the sender.
>
>
>
>
> ---------- Forwarded message ----------
> From: Jeff Jansen <jeff.jan...@kkoncepts.net>
> To: Courier Users List <courier-users@lists.sourceforge.net>
> Date: Mon, 26 Apr 2010 19:12:42 +0800
> Subject: Re: [courier-users] backscatter and mailfilter
> Sam Varshavchik <mr...@courier-mta.com> wrote on 2010-Apr-26:
>> Try an exit code of 70, this will bounce the mail without triggering
>> backscatter suppression.
>
> Thanks Sam, that's exactly what I was looking for.
>
> Jeff Jansen
>
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> courier-users mailing list
> courier-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/courier-users
>
>
------------------------------------------------------------------------------
_______________________________________________
courier-users mailing list
courier-users@lists.sourceforge.net
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
