Hello, As for the logging, you can adjust how much dbmail sends to your syslog server by setting the levels in dbmail.conf (yes, 0 and 1 are valid) - you can also adjust what level syslog writes to the disk by editing /etc/syslog.conf.
As for the multiple connects, I've seen something similar when a client has multiple mail accounts, it makes multiple pop3 connections to check each one - but I don't think I've seen the same account being checked by multiple times by simultaneous connections. Try grabbing the latest cvs code (for dbmail 1.x) and see if that fixes it. ---- Original Message ---- From: RG IT-solutions <[email protected]> To: [email protected] Subject: [Dbmail] logfiles problem Sent: Fri, 19 Sep 2003 12:55:28 +0200 > hello everybody! > > > if got a problem with my 1.1 installation! > (system: debian on a p700 2g ram, 240 g hd on raid 5 (4discs) using > mysql and postfix) > > everything worked fine since i upgraded to 1.1 (i'm using dbmail since > 12.01 and version 1.0rc2) > > now my logfiles are growing each day to aprox. 30-50 MB (mail.info and > error) ... everything is locked > and there are some interesting things inside those logs: > > we've got an inner-mailserver (dbmail is used outside the lan, as an > productionsystem with aprox. 150 users) > wich is collecting all emails for a spezified domain (r-3.at). this > server conncets every 2 min to the > dbmail-server, looks after new mail and disconnects .... BUT > > he does not one connect for each user, he does several connects for > each user (connect - diconnect) in > just some seconds ??!???! ... and not only this server does that, every > client comming to the dbmail-server > does that. (the inner-mailserver is installed and clean - i just saw it > over there best and used it here just for > an example!) > > so: > every client connects several times (per second) to the dbmailserver --- > please why ? > (and theirefore the logfiles grow) > the logfiles grow also, because every parsing off the dbmail.conf - file > is logged - EVERY .... > everytime a new email comes in, the dbmail.conf gets parsed and this > "parsing" is logged > > 1. Is there a possibility to set this behavior off ??? > (is there a TRACE_LEVEL 0 or 1 or so .. just to logg every incoming > mail and every incoming connect - and not each action taken by dbmail?) > 2. Why does every client several connects and disconnects per second ...???? > (the clients are mozilla, outlook, and so on from different clients and > installation, but everybody does the same?!) > > > since this, my system hangs because a big ammount of sql-commands to the > mysql (and logs!!!!!!) > > > > here my dbmail.conf: > > ****************************************************************************************** > # $Id: dbmail.conf,v 1.98 2003/01/13 10:31:46 roel Exp $ > # (c) 2000-2002 IC&S, The Netherlands > # > # Configuration file for DBMAIL > # This configuration file needs to be run through dbmail-config to be > effective > # after that, changes are effective inmediatly > > [DBMAIL] > host=localhost > user=XXXXXl > pass=XXXXX > db=dbmail > TRACE_LEVEL=2 > > [SMTP] > SENDMAIL=/usr/bin/mail > [EMAIL PROTECTED] > [EMAIL PROTECTED] > AUTO_NOTIFY=no > AUTO_REPLY=no > TRACE_LEVEL=2 > > [POP] > EFFECTIVE_USER=root > EFFECTIVE_GROUP=root > BINDIP=* # need inside and outside > monitoring/listening > PORT=110 > NCHILDREN=5 > MAXCHILDREN=50 > MAXCONNECTS=5000 > TIMEOUT=600 > RESOLVE_IP=no > POP_BEFORE_SMTP=yes > TRACE_LEVEL=2 > > [IMAP] > EFFECTIVE_USER=root > EFFECTIVE_GROUP=root > BINDIP=* > PORT=143 > NCHILDREN=10 > MAXCONNECTS=5000 > TIMEOUT=1800 > RESOLVE_IP=no > IMAP_BEFORE_SMTP=yes > TRACE_LEVEL=2 > > # end of configuration file > > > ****************************************************************************************** > > > > and here a short exampel from my logs ... (IPs, passwords, usernames or > sensitiv data have been overwritten!) > > ****************************************************************************************** > > here are some of those "several-connects - entries": > > Sep 19 12:38:45 rgits dbmail/pop3d[635]: pop3(): user [EMAIL PROTECTED] > logged in > [messages=0, octets=0] > Sep 19 12:38:45 rgits dbmail/pop3d[635]: pop3_handle_connection(): user > [EMAIL PROTECTED] logging out [messages=0, o > Sep 19 12:38:45 rgits dbmail/pop3d[631]: PerformChildTask(): incoming > connection from [IP-ADDRESS] > Sep 19 12:38:45 rgits dbmail/pop3d[631]: pop3(): user [EMAIL PROTECTED] > logged in > [messages=0, octets=0] > Sep 19 12:38:45 rgits dbmail/pop3d[631]: pop3_handle_connection(): user > [EMAIL PROTECTED] logging out [messages=0, oc > Sep 19 12:38:45 rgits dbmail/pop3d[636]: PerformChildTask(): incoming > connection from [IP-ADDRESS] > Sep 19 12:38:45 rgits dbmail/pop3d[636]: pop3(): user [EMAIL PROTECTED] > logged in > [messages=0, octets=0] > Sep 19 12:38:45 rgits dbmail/pop3d[636]: pop3_handle_connection(): user > [EMAIL PROTECTED] logging out [messages=0, oc > Sep 19 12:38:45 rgits dbmail/pop3d[629]: PerformChildTask(): incoming > connection from [IP-ADDRESS] > Sep 19 12:38:45 rgits dbmail/pop3d[629]: pop3(): user [EMAIL PROTECTED] > logged in > [messages=0, octets=0] > Sep 19 12:38:45 rgits dbmail/pop3d[629]: pop3_handle_connection(): user > [EMAIL PROTECTED] logging out [messages=0, o > Sep 19 12:38:45 rgits dbmail/pop3d[630]: PerformChildTask(): incoming > connection from [IP-ADDRESS] > Sep 19 12:38:45 rgits dbmail/pop3d[630]: pop3(): user [EMAIL PROTECTED] > logged in > [messages=0, octets=0] > Sep 19 12:38:45 rgits dbmail/pop3d[630]: pop3_handle_connection(): user > [EMAIL PROTECTED] logging out [messages=0, oc > Sep 19 12:38:45 rgits dbmail/pop3d[635]: PerformChildTask(): incoming > connection from [IP-ADDRESS] > Sep 19 12:38:45 rgits dbmail/pop3d[635]: pop3(): user [EMAIL PROTECTED] > logged in > [messages=0, octets=0] > Sep 19 12:38:45 rgits dbmail/pop3d[635]: pop3_handle_connection(): user > [EMAIL PROTECTED] logging out [messages=0, oct > Sep 19 12:38:45 rgits dbmail/pop3d[631]: PerformChildTask(): incoming > connection from [IP-ADDRESS] > Sep 19 12:38:46 rgits dbmail/pop3d[631]: pop3(): user [EMAIL PROTECTED] > logged > in [messages=0, octets=0] > Sep 19 12:38:46 rgits dbmail/pop3d[631]: pop3_handle_connection(): user > [EMAIL PROTECTED] logging out [messages=0, > Sep 19 12:38:46 rgits dbmail/pop3d[636]: PerformChildTask(): incoming > connection from [IP-ADDRESS] > Sep 19 12:38:46 rgits dbmail/pop3d[636]: pop3(): user [EMAIL PROTECTED] > logged > in [messages=0, octets=0] > Sep 19 12:38:46 rgits dbmail/pop3d[636]: pop3_handle_connection(): user > [EMAIL PROTECTED] logging out [messages=0, > Sep 19 12:38:46 rgits dbmail/pop3d[629]: PerformChildTask(): incoming > connection from [IP-ADDRESS] > Sep 19 12:38:46 rgits dbmail/pop3d[629]: pop3(): user [EMAIL PROTECTED] > logged > in [messages=0, octets=0] > Sep 19 12:38:46 rgits dbmail/pop3d[629]: pop3_handle_connection(): user > [EMAIL PROTECTED] logging out [messages=0, > Sep 19 12:38:46 rgits dbmail/pop3d[630]: PerformChildTask(): incoming > connection from [IP-ADDRESS] > Sep 19 12:38:46 rgits dbmail/pop3d[630]: pop3(): user [EMAIL PROTECTED] > logged > in [messages=0, octets=0] > Sep 19 12:38:46 rgits dbmail/pop3d[630]: pop3_handle_connection(): user > [EMAIL PROTECTED] logging out [messages=0, > Sep 19 12:38:46 rgits dbmail/pop3d[635]: PerformChildTask(): incoming > connection from [IP-ADDRESS] > Sep 19 12:38:46 rgits dbmail/pop3d[635]: pop3(): user [EMAIL PROTECTED] > logged > in [messages=0, octets=0] > Sep 19 12:38:46 rgits dbmail/pop3d[635]: pop3_handle_connection(): user > [EMAIL PROTECTED] logging out [messages=0, > Sep 19 12:38:46 rgits dbmail/pop3d[631]: PerformChildTask(): incoming > connection from [IP-ADDRESS] > Sep 19 12:38:46 rgits dbmail/pop3d[631]: pop3(): user [EMAIL PROTECTED] > logged > in [messages=0, octets=0] > Sep 19 12:38:46 rgits dbmail/pop3d[631]: pop3_handle_connection(): user > [EMAIL PROTECTED] logging out [messages=0, > Sep 19 12:38:46 rgits dbmail/pop3d[636]: PerformChildTask(): incoming > connection from [IP-ADDRESS] > Sep 19 12:38:46 rgits dbmail/pop3d[636]: pop3(): user [EMAIL PROTECTED] > logged > in [messages=0, octets=0] > Sep 19 12:38:46 rgits dbmail/pop3d[636]: pop3_handle_connection(): user > [EMAIL PROTECTED] logging out [messages=0, > Sep 19 12:38:46 rgits dbmail/pop3d[629]: PerformChildTask(): incoming > connection from [IP-ADDRESS] > Sep 19 12:38:47 rgits dbmail/pop3d[629]: pop3(): user [EMAIL PROTECTED] > logged > in [messages=0, octets=0] > Sep 19 12:38:47 rgits dbmail/pop3d[629]: pop3_handle_connection(): user > [EMAIL PROTECTED] logging out [messages=0, > Sep 19 12:38:47 rgits dbmail/pop3d[630]: PerformChildTask(): incoming > connection from [IP-ADDRESS] > Sep 19 12:38:47 rgits dbmail/pop3d[630]: pop3(): user [EMAIL PROTECTED] > logged > in [messages=0, octets=0] > Sep 19 12:38:47 rgits dbmail/pop3d[630]: pop3_handle_connection(): user > [EMAIL PROTECTED] logging out [messages=0, > Sep 19 12:38:47 rgits dbmail/pop3d[635]: PerformChildTask(): incoming > connection from [IP-ADDRESS] > Sep 19 12:38:47 rgits dbmail/pop3d[635]: pop3(): user [EMAIL PROTECTED] > logged > in [messages=0, octets=0] > Sep 19 12:38:47 rgits dbmail/pop3d[635]: pop3_handle_connection(): user > [EMAIL PROTECTED] logging out [messages=0, > Sep 19 12:38:47 rgits dbmail/pop3d[631]: PerformChildTask(): incoming > connection from [IP-ADDRESS] > Sep 19 12:38:47 rgits dbmail/pop3d[631]: pop3(): user [EMAIL PROTECTED] > logged > in [messages=0, octets=0] > Sep 19 12:38:47 rgits dbmail/pop3d[631]: pop3_handle_connection(): user > [EMAIL PROTECTED] logging out [messages=0, > Sep 19 12:38:47 rgits dbmail/pop3d[636]: PerformChildTask(): incoming > connection from [IP-ADDRESS] > Sep 19 12:38:47 rgits dbmail/pop3d[636]: pop3(): user [EMAIL PROTECTED] > logged > in [messages=0, octets=0] > Sep 19 12:38:47 rgits dbmail/pop3d[636]: pop3_handle_connection(): user > [EMAIL PROTECTED] logging out [messages=0, > > .... or some of the "everything-logging-entries" .... > > Sep 19 12:36:37 rgits postfix/cleanup[3445]: 1FE36108811B: > message-id=<[EMAIL PROTECTED] .......cutoff > Sep 19 12:36:37 rgits postfix/qmgr[780]: 1FE36108811B: from=<[EMAIL > PROTECTED]>, > size=6936, nrcpt=1 (queue a ....... cutoff > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): starting procedure > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): found [DBMAIL] tag > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): no value > specified for service item []. > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): item [host] value > [localhost] added > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): item [user] value > [XXXXX] added > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): item [pass] value > [XXXXX] added > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): item [db] value > [dbmail] added > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): no value > specified for service item []. > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): item > [TRACE_LEVEL] value [2] added > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): service [DBMAIL] > added > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): config for > [DBMAIL] read, found [5] items > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): starting procedure > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): found [SMTP] tag > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): item [SENDMAIL] > value [/usr/bin/mail] added > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): item > [DBMAIL_FROM_ADDRESS] value [EMAIL PROTECTED] added > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): item [POSTMASTER] > value [EMAIL PROTECTED] added > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): item > [AUTO_NOTIFY] value [no] added > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): item [AUTO_REPLY] > value [no] added > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): item > [TRACE_LEVEL] value [2] added > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): service [SMTP] added > Sep 19 12:36:37 rgits dbmail/smtp[3450]: ReadConfig(): config for [SMTP] > read, found [6] items > Sep 19 12:36:37 rgits dbmail/smtp[3450]: GetConfigValue(): searching > value for config item [trace_level] > Sep 19 12:36:37 rgits dbmail/smtp[3450]: GetConfigValue(): found value [2] > Sep 19 12:36:37 rgits postfix/smtpd[3444]: disconnect from > line-xyzABC[IP-ADDRESS] > Sep 19 12:36:37 rgits dbmail/smtp[3450]: insert_messages(): message > id=44423, size=6720 is inserted > > *********************************************************************************************************************** > > thanx for reading this all, and further for helping .. ;-) > (and sorry for my bad english ...) > > robert galovic > > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- End Original Message -- -- Jesse Norell jesse (at) kci.net
