Any ideia how to debug it more?
When the error about cannot get a connection from pool happens, the server
dies.
MySQL Max is:
---
set-variable = max_connections=1000
---
And a show processlist; show's me 33connections being used.
My dbmail.conf:
# $Id: dbmail.conf 1539 2004-12-27 21:41:07Z paul $
# (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]
#
# Logging via stderr/log file and syslog
#
# Logging is broken up into 8 logging levels and each level can be
indivually turned on or off.
# The Stderr/log file logs all entries to stderr or the log file.
# Syslog logging uses the facility mail and the logging level of the event
for logging.
# Syslog can then be configured to log data according to the levels.
#
# Set the log level to the sum of the values next to the levels you want to
record.
# 1 = Emergency
# 2 = Alert
# 4 = Critical
# 8 = Error
# 16 = Warning
# 32 = Notice
# 64 = Info
# 128 = Debug
#
# Examples: 0 = Nothing
# 31 = Emergency + Alert + Critical + Error + Warning
# 255 = Everything
#
FILE_LOGGING_LEVELS = 7
#
SYSLOG_LOGGING_LEVELS = 31
#TRACE_STDERR = 5
# path to find library directory
library_directory = /usr/local/lib/dbmail
# If you set this to 'yes' dbmail will check for duplicate
# messages in the relevant mailbox during delivery using
# the Message-ID header
#
suppress_duplicates = yes
# SHA1 / SHA256 / TIGER
hash_algorithm = SHA1
#
# Idle time allowed before a connection is shut off if you have not logged
in yet.
#
login_timeout = 60
driver=mysql
authdriver=sql
# Database settings
host=localhost # host for database, set to localhost if
database is om
# the same host as dbmail and you want to use a
local socket
# for connecting.
sqlport= # if you want to use TCP/IP for connecting to the
database,
# and have the database running on a non-standard
port.
sqlsocket=/var/run/mysqld/mysqld.sock # when using a local
socket connection to the database, fill
# in the path to the socket here (e.g.
/var/run/mysql.sock)
user=myuser # user to connect as to database
pass=mypwd # password for user to database
db=postfix # name of database
#table_prefix=dbmail_ # Table prefix. Defaults to "dbmail_" if not
specified.
#encoding=latin1 # MySQL connection encoding must match to table
encoding.
[EMAIL PROTECTED] # postmaster's email address.
SENDMAIL=/usr/sbin/sendmail # sendmail executable
# trace level for dbmail-util
#TRACE_LEVEL=2
encoding = utf8
default_msg_encoding = utf8
[SMTP]
SENDMAIL=/usr/sbin/sendmail # sendmail executable for forwarding mail
AUTO_NOTIFY=no
AUTO_REPLY=no
TRACE_LEVEL=1
[LMTP]
EFFECTIVE_USER=nobody # the user that dbmail-lmtpd will run as
(need to be root to bind to a port<1024)
EFFECTIVE_GROUP=nogroup # the group that dbmail-lmtpd will run as
BINDIP=* # the ipaddress the dbmail-lmtpd server has to
bind
# to, * for all adresses. Use 127.0.0.1 to only
# bind to localhost.
PORT=24 # the port number the dbmail-lmtpd server
has to bind to.
NCHILDREN=20 # default number of LMTP handlers (each is
a process)
MAXCHILDREN=20 # max. number of LMTP handlers
MINSPARECHILDREN=15
MAXSPARECHILDREN=15
MAXCONNECTS=10000 # the maximum number of connections a
default childs makes
TIMEOUT=300 # the time (s) before the dbmail-lmtpd
should shutdown a connection which is being idle.
RESOLVE_IP=no # if yes, the lmtp daemon resolves IP
numbers to DNS names in the log
#TRACE_LEVEL=2
MAX_ERRORS=500
[POP]
EFFECTIVE_USER=nobody # the user that dbmail-pop3d will run as
(need to be root to bind to a port<1024)
EFFECTIVE_GROUP=nogroup # the group that dbmail-pop3d will run as
BINDIP=* # the ipaddress the dbmail-pop3d server
has to bind to, * for all addresses
PORT=110 # the port number the dbmail-pop3d server
has to bind to.
NCHILDREN=30 # default number of POP3 handlers (each is
a process)
MAXCHILDREN=50 # mac. number of POP3 handlers
MINSPARECHILDREN=20
MAXSPARECHILDREN=20
MAXCONNECTS=10000 # the maximum number of connections a
default childs makes
TIMEOUT=600 # the time (s) before the dbmail-pop3d
should shutdown a connection which is being idle.
RESOLVE_IP=no # if yes, the pop daemon resolves IP
numbers to DNS names in the log
POP_BEFORE_SMTP=yes
#TRACE_LEVEL=2
banner = Decimal Informatica e Gestao, Lda <-> POP3 Server
[IMAP]
EFFECTIVE_USER=nobody
EFFECTIVE_GROUP=nogroup
BINDIP=*
PORT=143
NCHILDREN=30
MAXCHILDREN=40 # mac. number of IMAPD handlers
MINSPARECHILDREN=20
MAXSPARECHILDREN=20
MAXCONNECTS=10000 # the maximum number of connections a
default childs makes
TIMEOUT=400 # tava 300, hoje tinha 40000 # the time
(s) before the dbmail-imapd should shutdown a connection which is being
idle.
RESOLVE_IP=no # if yes, the imap daemon resolves IP
numbers to DNS names in the log
IMAP_BEFORE_SMTP=no
#TRACE_LEVEL=2
idle_timeout = 120
#capability = IMAP4 IMAP4rev1 AUTH=LOGIN ACL NAMESPACE CHILDREN
SORT QUOTA THREAD=ORDEREDSUBJECT UNSELECT IDLE
[SIEVE]
EFFECTIVE_USER=nobody # Root privs are used to open a port, then privs
EFFECTIVE_GROUP=nogroup # are dropped down to the user/group specified
here.
#BINDIP=192.168.1.222
BINDIP=*
PORT=2000 # Port to bind to.
NCHILDREN=10
MAXCONNECTS=1000
MAXCHILDREN=10
MINSPARECHILDREN=2
MAXSPARECHILDREN=4
#TRACE_LEVEL=2
[DELIVERY]
SIEVE=yes
SIEVE_VACATION=yes
# end of configuration file
> -----Original Message-----
> From: Jorge Bastos [mailto:[EMAIL PROTECTED]
> Sent: quinta-feira, 30 de Outubro de 2008 10:58
> To: 'DBMail mailinglist'
> Subject: RE: [Dbmail] RE: Help on new ZDB system
>
> Well Paul,
> There's something for you, in about 10m it happened:
> ---
> Oct 30 10:58:35 lira dbmail/imap4d[2528]: [0x9543498] EMERGENCY:[db]
> db_con_get(+234): can't get a database connection from the pool!
> ---
>
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> > Behalf Of Jorge Bastos
> > Sent: quinta-feira, 30 de Outubro de 2008 10:46
> > To: 'DBMail mailinglist'
> > Subject: RE: [Dbmail] RE: Help on new ZDB system
> >
> > >
> > > I meant: the IDLE problem is now fixed. Please test Outlook with
> IDLE
> > > enabled.
> >
> >
> > Ops sorry, read it wrong. Ok going to test and let you know.
> >
> >
> > _______________________________________________
> > DBmail mailing list
> > [email protected]
> > https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
