Imap saslauthd produces huge no of logs & crashes

[faris]

Hi,
   
  I am little bit new to cyrus and now a days my cyrus imap server crashes every day. once stop/start cyrus, services are back to normal. After checking the /var/log/messages & /var/log/imapd.log i get huge no of messages coming. donno how to trace the error. also i need to stop cyrus imap & saslauthd information coming to my /var/log/messages file as well. information is listed below. please help !
   
   
  [root at imap ~]# tail -f /var/log/messages
May 16 10:41:14 mxstore2a saslauthd[7860]: sqlLog called.
May 16 10:41:14 mxstore2a saslauthd[7860]: pam_mysql: error: sqllog set but logtable not set
May 16 10:41:14 mxstore2a saslauthd[7860]: pam_mysql: error: sqllog set but logmsgcolumn not set
May 16 10:41:14 mxstore2a saslauthd[7860]: pam_mysql: error: sqllog set but logusercolumn not set
May 16 10:41:14 mxstore2a saslauthd[7860]: pam_mysql: error: sqllog set but loghostcolumn not set
May 16 10:41:14 mxstore2a saslauthd[7860]: pam_mysql: error: sqllog set but logtimecolumn not set
May 16 10:41:14 mxstore2a saslauthd[7860]: returning 0 .
May 16 10:41:14 mxstore2a saslauthd[7860]: returning 0.
May 16 10:41:14 mxstore2a saslauthd[7860]: pam_mysql: acct_mgmt called but not implemented. Dont panic though :)
May 16 10:41:14 mxstore2a imap[7873]: login: cctrl1 [10.2.30.214] 999999999 plaintext User logged in
May 16 10:41:20 mxstore2a saslauthd[7861]: pam_sm_authenticate called.
May 16 10:41:20 mxstore2a saslauthd[7861]: dbuser changed.
May 16 10:41:20 mxstore2a saslauthd[7861]: dbpasswd changed.
May 16 10:41:20 mxstore2a saslauthd[7861]: host changed.
May 16 10:41:20 mxstore2a saslauthd[7861]: database changed.
May 16 10:41:20 mxstore2a saslauthd[7861]: table changed.
May 16 10:41:20 mxstore2a saslauthd[7861]: usercolumn changed.
May 16 10:41:20 mxstore2a saslauthd[7861]: passwdcolumn changed.
May 16 10:41:20 mxstore2a saslauthd[7861]: db_connect  called.
May 16 10:41:20 mxstore2a saslauthd[7861]: returning 0 .
May 16 10:41:20 mxstore2a saslauthd[7861]: db_checkpasswd called.
May 16 10:41:20 mxstore2a saslauthd[7861]: pam_mysql: where clause = 
May 16 10:41:20 mxstore2a saslauthd[7861]: SELECT user_pswd FROM UserInfo WHERE username='94723783294'
May 16 10:41:20 mxstore2a saslauthd[7861]: sqlLog called.
May 16 10:41:20 mxstore2a saslauthd[7861]: pam_mysql: error: sqllog set but logtable not set
May 16 10:41:20 mxstore2a saslauthd[7861]: pam_mysql: error: sqllog set but logmsgcolumn not set
May 16 10:41:20 mxstore2a saslauthd[7861]: pam_mysql: error: sqllog set but logusercolumn not set
May 16 10:41:20 mxstore2a saslauthd[7861]: pam_mysql: error: sqllog set but loghostcolumn not set
May 16 10:41:20 mxstore2a saslauthd[7861]: pam_mysql: error: sqllog set but logtimecolumn not set
May 16 10:41:20 mxstore2a saslauthd[7861]: returning 0 .

  -----------------------------------------------------------------------------
   
   
  [root at imap ~]# tail -f /var/log/imapd.log 
May 16 11:28:21 mxstore2a imap[7968]: login: cctrl1 [10.2.30.214] 94724550835 plaintext User logged in
May 16 11:28:21 mxstore2a imap[7968]: open: user 94724550835 opened INBOX
May 16 11:28:21 mxstore2a imap[7968]: open: user 94724550835 opened INBOX
May 16 11:28:21 mxstore2a imap[7968]: SQUAT failed to open index file
May 16 11:28:21 mxstore2a imap[7968]: SQUAT failed
May 16 11:28:21 mxstore2a imap[7968]: SQUAT failed to open index file
May 16 11:28:21 mxstore2a imap[7968]: SQUAT failed
May 16 11:28:21 mxstore2a imap[7968]: SQUAT failed to open index file
May 16 11:28:21 mxstore2a imap[7968]: SQUAT failed
May 16 11:28:21 mxstore2a imap[7968]: open: user 94724550835 opened INBOX.Saved Items
   
  ----------------------------------------------------------------------------------------
   
   
  [root at imap ~]# tail -f /var/log/auth.log
May 16 11:28:36 mxstore2a saslauthd[7862]: SELECT user_pswd FROM UserInfo WHERE username='94725327205'
May 16 11:28:36 mxstore2a saslauthd[7862]: sqlLog called.
May 16 11:28:36 mxstore2a saslauthd[7862]: pam_mysql: error: sqllog set but logtable not set
May 16 11:28:36 mxstore2a saslauthd[7862]: pam_mysql: error: sqllog set but logmsgcolumn not set
May 16 11:28:36 mxstore2a saslauthd[7862]: pam_mysql: error: sqllog set but logusercolumn not set
May 16 11:28:36 mxstore2a saslauthd[7862]: pam_mysql: error: sqllog set but loghostcolumn not set
May 16 11:28:36 mxstore2a saslauthd[7862]: pam_mysql: error: sqllog set but logtimecolumn not set
May 16 11:28:36 mxstore2a saslauthd[7862]: returning 0 .
May 16 11:28:36 mxstore2a saslauthd[7862]: returning 0.
May 16 11:28:36 mxstore2a saslauthd[7862]: pam_mysql: acct_mgmt called but not implemented. Dont panic though :)
May 16 11:28:55 mxstore2a saslauthd[7861]: pam_sm_authenticate called.
May 16 11:28:55 mxstore2a saslauthd[7861]: dbuser changed.
May 16 11:28:55 mxstore2a saslauthd[7861]: dbpasswd changed.
May 16 11:28:55 mxstore2a saslauthd[7861]: host changed.
May 16 11:28:55 mxstore2a saslauthd[7861]: database changed.
May 16 11:28:55 mxstore2a saslauthd[7861]: table changed.
May 16 11:28:55 mxstore2a saslauthd[7861]: usercolumn changed.
May 16 11:28:55 mxstore2a saslauthd[7861]: passwdcolumn changed.
May 16 11:28:55 mxstore2a saslauthd[7861]: db_connect  called.
May 16 11:28:55 mxstore2a saslauthd[7861]: returning 0 .

   
   
  Thanks !
   
  Faris

       
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.andrew.cmu.edu/pipermail/info-cyrus/attachments/20080516/d861933b/attachment.html