Jorge, Please update again. And set max_db_connections in your dbmail.conf
Install GIT on your development server because svn will no longer be updated as of today. Jorge Bastos wrote: > 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 > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
