Imap saslauthd produces huge no of logs & crashe

[Alain Spineux]

On Fri, May 16, 2008 at 12:06 PM, faris <farislinux at yahoo.com> 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 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

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

Their is nothing wrong with that


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