On Fri, May 16, 2008 at 12:06 PM, faris <farislinux@xxxxxxxxx> wrote: > 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 ! If restarting imapd solve your problem, this is probably related to cyrus, but I dont see anything wrong here. See below for further details. Whats is your problem ? What does mean "crashes" ? Doe you have a cyrmaster.log or any log about cyrmaster process ? > > > [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 You have set sqllog to True but dont have created the required SQL table. Set it to False or create the table! > 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 Their is nothing wrong with that > 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 > -- Alain Spineux aspineux gmail com May the sources be with you ---- 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
