mysql.jorge at decimal
Oct 30, 2008, 4:50 AM
Post #21 of 58
(3797 views)
Permalink
|
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: dbmail-bounces [at] dbmail [mailto:dbmail-bounces [at] dbmail] 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.
> > POSTMASTER=decimal [at] decimal # 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:mysql.jorge [at] decimal]
> >> 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: dbmail-bounces [at] dbmail [mailto:dbmail-bounces [at] dbmail]
> 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
> >>> DBmail [at] dbmail
> >>> https://mailman.fastxs.nl/mailman/listinfo/dbmail
> >
> > _______________________________________________
> > DBmail mailing list
> > DBmail [at] dbmail
> > 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
> DBmail [at] dbmail
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
DBmail [at] dbmail
https://mailman.fastxs.nl/mailman/listinfo/dbmail
|
1
