Defined: max_db_connections = 20 for git, im not familiar with it, but as far I remember from someone asking it is: -- git clone http://git.dbmail.eu/paul/dbmail --
Correct? > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Paul J Stevens > Sent: quinta-feira, 30 de Outubro de 2008 11:34 > To: DBMail mailinglist > Subject: Re: [Dbmail] RE: Help on new ZDB system > > > 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 _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
