Imap saslauthd produces huge no of logs & crashes

[faris <farislinux@xxxxxxxxx>]

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@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@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@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

----
Cyrus Home Page: http://cyrusimap.web.cmu.edu/
Cyrus Wiki/FAQ: http://cyrusimap.web.cmu.edu/twiki
List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html