April Lorenzen wrote: > My problem continues - maybe its something I did wrong in dbmail.conf? > (imap stanza pasted below) > > I have a server with sendmail, squirrelmail, imapproxy and dbmail, a > separate postgresql server dedicated just as a mail store, and another > www / cf server which runs a lot of queries of the dbmail tables. > > What seems to happen over a period of many hours, is that a lot of > dbmail-imap processes build up and hang around... then the postgresql > server makes connections from my cold fusion server wait.... if I > restart dbmail then the pg server seems to be cleared of a blockage > and finishes the sql queries from the cf server. > > I recently installed dbmail on yet another server which has very > minimal use - and from this I see the default settings for NCHILDREN, > MAXCHILDREN and MAXCONNECTS. I edited the "problem" dbmail server > dbmail.conf to match tonight in hopes it will help. Unfortunately I do > not comprehend what all the settings do. My postgresql guy just says > we are looking forward to when dbmail does database connetion > pooling....
That won't happen anytime soon. My first priority is getting 2.2 out of the door, and shared database connects are on the list for 2.4 at the earliest. > MAXCHILDREN line for the IMAP stanza was completely > missing until tonight. In which case it will default to something high. > > Any comments appreciated: > > [IMAP] > EFFECTIVE_USER=dbmail > EFFECTIVE_GROUP=dbmail > BINDIP=* > PORT=143 > NCHILDREN=5 NCHILDREN is the minimum number of child processes started up and kept running. > MAXCHILDREN=200 MAXCHILDREN is the ceiling. > MAXCONNECTS=10000 # the maximum number of connections > a default childs makes After handling MAXCONNECTS a child will exit, after which the pool manager starts a new process to replace it. If you suspect memory leaks in the dbmail code set this very low. > TIMEOUT=300 # the time (s) before the > dbmail-imapd should shutdown a connection which is being idle. You have to play with this one. Php's imap driver doesn't like disconnects very much. > RESOLVE_IP=no # if yes, the imap daemon resolves > IP numbers to DNS names in the log > IMAP_BEFORE_SMTP=yes > MINSPARECHILDREN=4 > MAXSPARECHILDREN=8 The number of idle processes will be kept MINSPARECHILDREN <= idle processes <= MAXSPARECHILDREN. Of course MINSPARECHILDREN can never be lower than NCHILDREN, and MAXSPARECHILDREN can never be higher than MAXCHILDREN. If you set them too low or too high, they will be set to something saner. > MAXCHILDREN=200 > TRACE_LEVEL=0 That is *very* low. You won't be getting any logging from your dbmail services. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
