<DIV>Hi,</DIV> <DIV> </DIV> <DIV>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 !</DIV> <DIV> </DIV> <DIV> </DIV> <DIV>[root@imap ~]# tail -f /var/log/messages<BR>May 16 10:41:14 mxstore2a saslauthd[7860]: sqlLog called.<BR>May 16 10:41:14 mxstore2a saslauthd[7860]: pam_mysql: error: sqllog set but logtable not set<BR>May 16 10:41:14 mxstore2a saslauthd[7860]: pam_mysql: error: sqllog set but logmsgcolumn not set<BR>May 16 10:41:14 mxstore2a saslauthd[7860]: pam_mysql: error: sqllog set but logusercolumn not set<BR>May 16 10:41:14 mxstore2a saslauthd[7860]:
pam_mysql: error: sqllog set but loghostcolumn not set<BR>May 16 10:41:14 mxstore2a saslauthd[7860]: pam_mysql: error: sqllog set but logtimecolumn not set<BR>May 16 10:41:14 mxstore2a saslauthd[7860]: returning 0 .<BR>May 16 10:41:14 mxstore2a saslauthd[7860]: returning 0.<BR>May 16 10:41:14 mxstore2a saslauthd[7860]: pam_mysql: acct_mgmt called but not implemented. Dont panic though :)<BR>May 16 10:41:14 mxstore2a imap[7873]: login: cctrl1 [10.2.30.214] 999999999 plaintext User logged in<BR>May 16 10:41:20 mxstore2a saslauthd[7861]: pam_sm_authenticate called.<BR>May 16 10:41:20 mxstore2a saslauthd[7861]: dbuser changed.<BR>May 16 10:41:20 mxstore2a saslauthd[7861]: dbpasswd changed.<BR>May 16 10:41:20 mxstore2a saslauthd[7861]: host changed.<BR>May 16 10:41:20 mxstore2a saslauthd[7861]: database changed.<BR>May 16 10:41:20 mxstore2a saslauthd[7861]: table changed.<BR>May 16 10:41:20 mxstore2a saslauthd[7861]: usercolumn changed.<BR>May 16 10:41:20 mxstore2a
saslauthd[7861]: passwdcolumn changed.<BR>May 16 10:41:20 mxstore2a saslauthd[7861]: db_connect called.<BR>May 16 10:41:20 mxstore2a saslauthd[7861]: returning 0 .<BR>May 16 10:41:20 mxstore2a saslauthd[7861]: db_checkpasswd called.<BR>May 16 10:41:20 mxstore2a saslauthd[7861]: pam_mysql: where clause = <BR>May 16 10:41:20 mxstore2a saslauthd[7861]: SELECT user_pswd FROM UserInfo WHERE username='94723783294'<BR>May 16 10:41:20 mxstore2a saslauthd[7861]: sqlLog called.<BR>May 16 10:41:20 mxstore2a saslauthd[7861]: pam_mysql: error: sqllog set but logtable not set<BR>May 16 10:41:20 mxstore2a saslauthd[7861]: pam_mysql: error: sqllog set but logmsgcolumn not set<BR>May 16 10:41:20 mxstore2a saslauthd[7861]: pam_mysql: error: sqllog set but logusercolumn not set<BR>May 16 10:41:20 mxstore2a saslauthd[7861]: pam_mysql: error: sqllog set but loghostcolumn not set<BR>May 16 10:41:20 mxstore2a saslauthd[7861]: pam_mysql: error: sqllog set but logtimecolumn not set<BR>May 16
10:41:20 mxstore2a saslauthd[7861]: returning 0 .<BR></DIV> <DIV>-----------------------------------------------------------------------------</DIV> <DIV> </DIV> <DIV> </DIV> <DIV>[root@imap ~]# tail -f /var/log/imapd.log <BR>May 16 11:28:21 mxstore2a imap[7968]: login: cctrl1 [10.2.30.214] 94724550835 plaintext User logged in<BR>May 16 11:28:21 mxstore2a imap[7968]: open: user 94724550835 opened INBOX<BR>May 16 11:28:21 mxstore2a imap[7968]: open: user 94724550835 opened INBOX<BR>May 16 11:28:21 mxstore2a imap[7968]: SQUAT failed to open index file<BR>May 16 11:28:21 mxstore2a imap[7968]: SQUAT failed<BR>May 16 11:28:21 mxstore2a imap[7968]: SQUAT failed to open index file<BR>May 16 11:28:21 mxstore2a imap[7968]: SQUAT failed<BR>May 16 11:28:21 mxstore2a imap[7968]: SQUAT failed to open index file<BR>May 16 11:28:21 mxstore2a imap[7968]: SQUAT failed<BR>May 16 11:28:21 mxstore2a imap[7968]: open: user 94724550835 opened INBOX.Saved Items</DIV>
<DIV> </DIV> <DIV>----------------------------------------------------------------------------------------</DIV> <DIV> </DIV> <DIV> </DIV> <DIV>[root@imap ~]# tail -f /var/log/auth.log<BR>May 16 11:28:36 mxstore2a saslauthd[7862]: SELECT user_pswd FROM UserInfo WHERE username='94725327205'<BR>May 16 11:28:36 mxstore2a saslauthd[7862]: sqlLog called.<BR>May 16 11:28:36 mxstore2a saslauthd[7862]: pam_mysql: error: sqllog set but logtable not set<BR>May 16 11:28:36 mxstore2a saslauthd[7862]: pam_mysql: error: sqllog set but logmsgcolumn not set<BR>May 16 11:28:36 mxstore2a saslauthd[7862]: pam_mysql: error: sqllog set but logusercolumn not set<BR>May 16 11:28:36 mxstore2a saslauthd[7862]: pam_mysql: error: sqllog set but loghostcolumn not set<BR>May 16 11:28:36 mxstore2a saslauthd[7862]: pam_mysql: error: sqllog set but logtimecolumn not set<BR>May 16 11:28:36 mxstore2a saslauthd[7862]: returning 0 .<BR>May 16 11:28:36 mxstore2a saslauthd[7862]: returning
0.<BR>May 16 11:28:36 mxstore2a saslauthd[7862]: pam_mysql: acct_mgmt called but not implemented. Dont panic though :)<BR>May 16 11:28:55 mxstore2a saslauthd[7861]: pam_sm_authenticate called.<BR>May 16 11:28:55 mxstore2a saslauthd[7861]: dbuser changed.<BR>May 16 11:28:55 mxstore2a saslauthd[7861]: dbpasswd changed.<BR>May 16 11:28:55 mxstore2a saslauthd[7861]: host changed.<BR>May 16 11:28:55 mxstore2a saslauthd[7861]: database changed.<BR>May 16 11:28:55 mxstore2a saslauthd[7861]: table changed.<BR>May 16 11:28:55 mxstore2a saslauthd[7861]: usercolumn changed.<BR>May 16 11:28:55 mxstore2a saslauthd[7861]: passwdcolumn changed.<BR>May 16 11:28:55 mxstore2a saslauthd[7861]: db_connect called.<BR>May 16 11:28:55 mxstore2a saslauthd[7861]: returning 0 .<BR></DIV> <DIV> </DIV> <DIV> </DIV> <DIV>Thanks !</DIV> <DIV> </DIV> <DIV>Faris</DIV><p>