Disk is full

Billy A. Pumphrey bpumphrey at WoodMacLaw.com
Fri Jan 13 15:59:54 GMT 2006


Snip

I am not out of the water quite yet.  My MailWatch is not working
correctly now.  If I should move this to the mailwatch list, please say
so.  This happened because of the full disk I would assume, as it worked
before then.

When I go to the web page for mailwatch I get:

Error executing query: 

Can't open file: 'maillog.MYI' (errno: 145)

SQL:

 SELECT
  COUNT(*) AS processed,
  SUM(
   CASE WHEN (
    (virusinfected=0 OR virusinfected IS NULL)
    AND (nameinfected=0 OR nameinfected IS NULL)
    AND (otherinfected=0 OR otherinfected IS NULL)
    AND (isspam=0 OR isspam IS NULL)
    AND (ishighspam=0 OR ishighspam IS NULL)
    AND (ismcp=0 OR ismcp IS NULL)
    AND (ishighmcp=0 OR ishighmcp IS NULL)
   ) THEN 1 ELSE 0 END
  ) AS clean,
  ROUND((
   SUM(
    CASE WHEN (
     (virusinfected=0 OR virusinfected IS NULL)
     AND (nameinfected=0 OR nameinfected IS NULL)
     AND (otherinfected=0 OR otherinfected IS NULL)
     AND (isspam=0 OR isspam IS NULL)
     AND (ishighspam=0 OR ishighspam IS NULL)
     AND (ismcp=0 OR ismcp IS NULL)
     AND (ishighmcp=0 OR ishighmcp IS NULL)
    ) THEN 1 ELSE 0 END
   )/COUNT(*))*100,1
  ) AS cleanpercent,
  SUM(
   CASE WHEN 
    virusinfected>0
   THEN 1 ELSE 0 END
  ) AS viruses,
  ROUND((
   SUM(


MailScanner seems to start ok:
[root at WoodenMS log]# tail -f /var/log/maillog
Jan 13 10:52:07 WoodenMS MailScanner[3969]: Read 188 hostnames from the
phishing
 whitelist
Jan 13 10:52:07 WoodenMS MailScanner[3969]: Config: calling custom init
function
 SQLBlacklist
Jan 13 10:52:07 WoodenMS MailScanner[3969]: Starting up SQL Blacklist
Jan 13 10:52:07 WoodenMS MailScanner[3969]: Read 2 blacklist entries
Jan 13 10:52:07 WoodenMS MailScanner[3969]: Config: calling custom init
function
 MailWatchLogging
Jan 13 10:52:07 WoodenMS MailScanner[3969]: Started SQL Logging child
Jan 13 10:52:07 WoodenMS MailScanner[3969]: Config: calling custom init
function
 SQLWhitelist
Jan 13 10:52:07 WoodenMS MailScanner[3969]: Starting up SQL Whitelist
Jan 13 10:52:07 WoodenMS MailScanner[3969]: Read 4 whitelist entries
Jan 13 10:52:08 WoodenMS MailScanner[3969]: Enabling SpamAssassin
auto-whitelist
 functionality...
Jan 13 10:52:17 WoodenMS MailScanner[3988]: MailScanner E-Mail Virus
Scanner ver
sion 4.43.8 starting...
Jan 13 10:52:18 WoodenMS MailScanner[3988]: Read 188 hostnames from the
phishing
 whitelist
Jan 13 10:52:18 WoodenMS MailScanner[3988]: Config: calling custom init
function
 SQLBlacklist
Jan 13 10:52:18 WoodenMS MailScanner[3988]: Starting up SQL Blacklist
Jan 13 10:52:18 WoodenMS MailScanner[3988]: Read 2 blacklist entries
Jan 13 10:52:18 WoodenMS MailScanner[3988]: Config: calling custom init
function
 MailWatchLogging
Jan 13 10:52:18 WoodenMS MailScanner[3988]: Started SQL Logging child
Jan 13 10:52:18 WoodenMS MailScanner[3988]: Config: calling custom init
function
 SQLWhitelist
Jan 13 10:52:18 WoodenMS MailScanner[3988]: Starting up SQL Whitelist
Jan 13 10:52:18 WoodenMS MailScanner[3988]: Read 4 whitelist entries
Jan 13 10:52:19 WoodenMS MailScanner[3988]: Enabling SpamAssassin
auto-whitelist
 functionality...
Jan 13 10:52:24 WoodenMS MailScanner[3969]: Using locktype = posix
Jan 13 10:52:24 WoodenMS MailScanner[3969]: Creating hardcoded
struct_flock subr
outine for linux (Linux-type)
Jan 13 10:52:28 WoodenMS MailScanner[3995]: MailScanner E-Mail Virus
Scanner ver
sion 4.43.8 starting...
Jan 13 10:52:29 WoodenMS MailScanner[3995]: Read 188 hostnames from the
phishing
 whitelist
Jan 13 10:52:29 WoodenMS MailScanner[3995]: Config: calling custom init
function
 SQLBlacklist
Jan 13 10:52:29 WoodenMS MailScanner[3995]: Starting up SQL Blacklist
Jan 13 10:52:29 WoodenMS MailScanner[3995]: Read 2 blacklist entries
Jan 13 10:52:29 WoodenMS MailScanner[3995]: Config: calling custom init
function
 MailWatchLogging
Jan 13 10:52:29 WoodenMS MailScanner[3995]: Started SQL Logging child
Jan 13 10:52:29 WoodenMS MailScanner[3995]: Config: calling custom init
function
 SQLWhitelist
Jan 13 10:52:29 WoodenMS MailScanner[3995]: Starting up SQL Whitelist
Jan 13 10:52:29 WoodenMS MailScanner[3995]: Read 4 whitelist entries
Jan 13 10:52:30 WoodenMS MailScanner[3988]: Using locktype = posix
Jan 13 10:52:30 WoodenMS MailScanner[3988]: Creating hardcoded
struct_flock subr
outine for linux (Linux-type)
Jan 13 10:52:31 WoodenMS MailScanner[3995]: Enabling SpamAssassin
auto-whitelist
 functionality...
Jan 13 10:52:39 WoodenMS MailScanner[4012]: MailScanner E-Mail Virus
Scanner ver
sion 4.43.8 starting...
Jan 13 10:52:40 WoodenMS MailScanner[4012]: Read 188 hostnames from the
phishing
 whitelist
Jan 13 10:52:40 WoodenMS MailScanner[4012]: Config: calling custom init
function
 SQLBlacklist
Jan 13 10:52:40 WoodenMS MailScanner[4012]: Starting up SQL Blacklist
Jan 13 10:52:40 WoodenMS MailScanner[4012]: Read 2 blacklist entries
Jan 13 10:52:40 WoodenMS MailScanner[4012]: Config: calling custom init
function
 MailWatchLogging
Jan 13 10:52:40 WoodenMS MailScanner[4012]: Started SQL Logging child
Jan 13 10:52:40 WoodenMS MailScanner[4012]: Config: calling custom init
function
 SQLWhitelist
Jan 13 10:52:40 WoodenMS MailScanner[4012]: Starting up SQL Whitelist
Jan 13 10:52:40 WoodenMS MailScanner[4012]: Read 4 whitelist entries
Jan 13 10:52:41 WoodenMS MailScanner[3995]: Using locktype = posix
Jan 13 10:52:41 WoodenMS MailScanner[3995]: Creating hardcoded
struct_flock subr
outine for linux (Linux-type)
Jan 13 10:52:42 WoodenMS MailScanner[4012]: Enabling SpamAssassin
auto-whitelist
 functionality...



My Versions:

CentOS		4
MailScanner 		4.40.11
PHP 			4.3.9
Sendmail 		8.13.4
MailWatch		1.0.1
MySQL		mysql Ver 14.7 Distrib 4.1.10a, for redhat-linux-gnu
(i686)
Apache		2.0
ClamAV		0.87.1
Spamassassin		3.0.4
Bitdefender		7.0.1-3.linux-gcc29x.i586
			Created	/var/bdc/infected /var/bdc/suspected
			Installed in dir /opt/bdc
			Quarantine dir /var/bdc
			Update - Update bit defender


More information about the MailScanner mailing list