Hi, I have nearly all my configuration parameters for exim in a postgresql database. That is for example, the local domains, email adresses and some tables for spamcheck with spamassassin. Also spamassassin itself stores its configuration, auto-whitelist and bayesdb in a database.
Now I tried to test my spamfilter with 150 spammails. When doing this postgresql rejects a lot of connections because of its maximum connection limit. This connection limit is set to 100 concurrent connections, so I am quite sure that this shouldn't happen. spamassassin opens no more than 5 processes and therefore should not open more than five connections to the database. How does exim do this? I bounced all 150 spam messages all at once to one address. Does exim process these mails in parallel? The postgresql log for 1 mail looks like this: 2005-05-19 10:29:10 [19298] LOG: connection received: host=[local] port= 2005-05-19 10:29:10 [19298] LOG: connection authorized: user=mail database=soutdb 2005-05-19 10:29:15 [19301] LOG: connection received: host=[local] port= 2005-05-19 10:29:15 [19301] LOG: connection authorized: user=mail database=soutdb 2005-05-19 10:29:15 [19303] LOG: connection received: host=[local] port= 2005-05-19 10:29:15 [19303] LOG: connection authorized: user=mail database=soutdb 2005-05-19 10:29:15 [19308] LOG: connection received: host=[local] port= 2005-05-19 10:29:15 [19308] LOG: connection authorized: user=spamassassin database=spamassassin 2005-05-19 10:29:15 [19309] LOG: connection received: host=[local] port= 2005-05-19 10:29:15 [19309] LOG: connection authorized: user=spamassassin database=spamassassin 2005-05-19 10:29:15 [19310] LOG: connection received: host=[local] port= 2005-05-19 10:29:15 [19310] LOG: connection authorized: user=spamassassin database=spamassassin 2005-05-19 10:29:22 [19313] LOG: connection received: host=[local] port= 2005-05-19 10:29:22 [19313] LOG: connection authorized: user=spamassassin database=spamassassin 2005-05-19 10:29:22 [19314] LOG: connection received: host=[local] port= 2005-05-19 10:29:22 [19314] LOG: connection authorized: user=spamassassin database=spamassassin 2005-05-19 10:29:22 [19317] LOG: connection received: host=[local] port= 2005-05-19 10:29:22 [19317] LOG: connection authorized: user=mail database=soutdb 2005-05-19 10:29:22 [19318] LOG: connection received: host=[local] port= 2005-05-19 10:29:22 [19318] LOG: connection authorized: user=mail database=soutdb 2005-05-19 10:29:22 [19320] LOG: connection received: host=[local] port= 2005-05-19 10:29:22 [19320] LOG: connection authorized: user=mail database=soutdb connections to soutdb are done by exim, connections to spamassassin are done by spamassassin. Any idea why the connection limit is hit? Regards Marco -- ## List details at http://www.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://www.exim.org/eximwiki/
