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
