You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@spamassassin.apache.org by David Boltz <db...@cornwall.ca> on 2007/07/04 00:57:51 UTC

Mail Queue stops working


I'm having problems with my mail not getting processed properly.
This setup has been in place for years and worked without problems.
All of a sudden this weekend it stopped delivering its mail from the
incoming queue.  If I modify my MailScanner.conf file to run in debug
mode it will process a bunch of email and sends it of but it?s always
finishing with the messages below. The number of EOCD messages seems
to very with the number of email processed in that debug run.
Something else I notice is that the emails only actually get sent on
after the debug has ended.
If I run without debug as normal it seems to just start gathering in
the incoming queue.  After a while it will show the odd message go
through but it's marked as a virus and I don't believe that every
email coming in contains a virus.  I went through all the mysql
databases and repaired any tables that contained errors as well but
that didn't seem to help.
Does anyone have any clues as to how I can solve this issue?  I'm lost
here.

Starting MailScanner daemons:
         incoming sendmail: SPF milter already running
                                                           [  OK  ]
         outgoing sendmail:                                [  OK  ]
         MailScanner:       In Debugging mode, not forking...
Ignore errors about failing to find EOCD signature
format error: can't find EOCD signature
 at /usr/sbin/MailScanner line 820
format error: can't find EOCD signature
 at /usr/sbin/MailScanner line 820
commit ineffective with AutoCommit enabled at
/usr/lib/MailScanner/MailScanner/CustomFunctions/MailWatch.pm line 93,
<CLIENT> line 707.
Commmit ineffective while AutoCommit is on at
/usr/lib/MailScanner/MailScanner/CustomFunctions/MailWatch.pm line 93,
<CLIENT> line 707.
Stopping now as you are debugging me.
                                                           [  OK  ]


Re: Mail Queue stops working

Posted by "John D. Hardin" <jh...@impsec.org>.
On Tue, 3 Jul 2007, David Boltz wrote:

> Thanks for the info.  Could it be that because the debug mode
> tries to do an commit before it closes and the system is set to
> auto commit for when it's running continuously it says this?

No idea. That's why it's a wild guess.

--
 John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
 jhardin@impsec.org    FALaholic #11174     pgpk -a jhardin@impsec.org
 key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
  It there a Special Olympics for terrorists going on in the UK this
  week?                                 -- Bruce Schneier, 07/02/2007
-----------------------------------------------------------------------
 Tomorrow: The 231st anniversary of the Declaration of Independence


Re: Mail Queue stops working

Posted by David Boltz <db...@cornwall.ca>.

Thanks for the info.  Could it be that because the debug mode tries to
do an commit before it closes and the system is set to auto commit for
when it's running continuously it says this?

Regards,
Dave B..





                                                                      
             "John D.                                                 
             Hardin"                                                  
             <jhardin@impsec                                       To 
             .org>                   David Boltz <db...@cornwall.ca> 
                                                                   cc 
             2007-07-03              <us...@spamassassin.apache.org>  
             20:06                                            Subject 
                                     Re: Mail Queue stops working     
                                                                      
                                                                      
                                                                      
                                                                      
                                                                      
                                                                      




On Tue, 3 Jul 2007, David Boltz wrote:

> I went through all the mysql databases and repaired any tables
> that contained errors as well but that didn't seem to help.

> commit ineffective with AutoCommit enabled at
> /usr/lib/MailScanner/MailScanner/CustomFunctions/MailWatch.pm line
93,
> <CLIENT> line 707.

Wild-arse guess: turn off AutoCommit in mysql and see what happens?

(Note: don't hold me responsible if that erases your database... :)

--
 John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
 jhardin@impsec.org    FALaholic #11174     pgpk -a jhardin@impsec.org
 key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------

  It there a Special Olympics for terrorists going on in the UK this
  week?                                 -- Bruce Schneier, 07/02/2007
-----------------------------------------------------------------------

 Tomorrow: The 231st anniversary of the Declaration of Independence





Re: Mail Queue stops working

Posted by "John D. Hardin" <jh...@impsec.org>.
On Tue, 3 Jul 2007, David Boltz wrote:

> I went through all the mysql databases and repaired any tables
> that contained errors as well but that didn't seem to help.

> commit ineffective with AutoCommit enabled at
> /usr/lib/MailScanner/MailScanner/CustomFunctions/MailWatch.pm line 93,
> <CLIENT> line 707.

Wild-arse guess: turn off AutoCommit in mysql and see what happens?

(Note: don't hold me responsible if that erases your database... :)

--
 John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
 jhardin@impsec.org    FALaholic #11174     pgpk -a jhardin@impsec.org
 key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
  It there a Special Olympics for terrorists going on in the UK this
  week?                                 -- Bruce Schneier, 07/02/2007
-----------------------------------------------------------------------
 Tomorrow: The 231st anniversary of the Declaration of Independence