Re: [Dbmail] logfiles problem

Fri, 19 Sep 2003 18:38:01 +0200 (CEST) 

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

Reply via email to