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:[EMAIL PROTECTED]] >>Sent: Tuesday, September 17, 2002 11:49 AM >>To: Vernon A. Fort >>Cc: [EMAIL PROTECTED] >>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