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