Cyrus and mysql

[Vernon A. Fort]

I think I have figured this out - it appears to be with PAM.  I have the
imap modules - prior to any postings configured as optional instead of
required.
  Since I change both lines to required, I have seen no failures with
the exception of normal auth failures (bad or null password or a bad
account id).

Thanks for all the replies...!!

Vernon

--------------------------------
Vernon A. Fort (Andy)
Provident Solutions LLC.
(615) 406-5540 http://www.provident-solutions.com
 

>>-----Original Message-----
>>From: owner-info-cyrus at lists.andrew.cmu.edu [mailto:owner-info-
>>cyrus at lists.andrew.cmu.edu] On Behalf Of Vernon A. Fort
>>Sent: Tuesday, September 17, 2002 1:04 PM
>>To: info-cyrus at lists.andrew.cmu.edu
>>Subject: RE: Cyrus and mysql
>>
>>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