Hello, Yes, use TRACE_LEVEL. But update to the latest cvs code - at some point there were some things fixed with hard-coded debug levels, so even when you turned TRACE_LEVEL down, it didn't have the desired effect (though the logs you show are probably proper level 2 logs .. says who logged in from where, etc.).
jn ---- Original Message ---- From: RG IT-solutions <[email protected]> To: [email protected] Subject: Re: [Dbmail] logfiles problem Sent: Fri, 19 Sep 2003 18:37:59 +0200 > Hi Jesse ... > > > Thanx for your help ... the logproblem would be fixed > but wich command should i put in the dbmail.conf, > is it the TRACE_LEVEL para, or an other ... ? > > > robert > > > > Jesse Norell wrote: > > >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 > > > > > >_______________________________________________ > >Dbmail mailing list > >[email protected] > >https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > > > -- End Original Message -- -- Jesse Norell jesse (at) kci.net
