Cyrus and mysql

[Vernon A. Fort]

Thanks for the replies!!!!

  I can walk around cyrus/postfix and linux fairly well, but I'm new to
mysql - a little quick direction on modifying the logging would help a
great deal!!
  The server has ~8,500 email accounts of which ~3500 are active so at
any one time there could be from 30 to 800 online.  The auth errors are
random.  There are two perl scripts (with perl-DBI) running every 15
mins to provide automatic administration (adding accounts and altering
the quotas).  I thought these scripts were the issue but I disabled both
for a day and still saw the errors - either only take ~60 seconds to
run.

  I also have the following in the /etc/my.cnf file
	[mysqld]
	set-variable=max_connections=256

  How can you tell the number of active connection or a history of
active connections over a period of time?

  SO, I think it's with mysql or cyrus-imap or saslauthd. Can one of you
tell me how to set the logging on mysql?!?

Vernon

--------------------------------
Vernon A. Fort (Andy)
Provident Solutions LLC.
(615) 406-5540 http://www.provident-solutions.com
 
>>-----Original Message-----
>>From: Simon Loader [mailto:simon at surf.org.uk]
>>Sent: Tuesday, September 17, 2002 11:49 AM
>>To: Vernon A. Fort
>>Cc: info-cyrus at lists.andrew.cmu.edu
>>Subject: Re: Cyrus and mysql
>>
>>At 11:50 Tuesday 17/09/2002, Scott Russell wrote:
>>>On Tue, Sep 17, 2002 at 09:59:17AM -0500, Vernon A. Fort wrote:
>>> > Hello all,
>>> >   I am having issues with Cyrus-imap (2.1.5) and cyrus-sasl
(2.1.5)
>>> > using the pam_mysql (0.4.5).  It is working well 'Most' of the
time.
>>> > Three to four times per day, we start having auth failures.  I
stop
>>and
>>> > start cyrus-imap - problem fixed.  I'm not sure where to look, but
>>here
>>> > are
>>> > my configs:
>>>
>>>Nothing obvious relating to this problem is listed. Have you looked
at
>>>the mysql error logs yet? Also I think PAM will log auth messags so
>>>you can see what's going on. Try checking syslog.conf and turning up
>>>the logging levels a bit.
>>
>>Just an idea , but have you checked the mysql server to see
>>how many clients are connected , prehaps you are reaching a limit ??
>>
>>--
>>Simon Loader