cannot send or receive mail

[Dave Filchak]

Hi folks,

Today a problem arose in my mail setup that I am trying to track down. I 
can no longer send or receive emails.

I think it has something to do with mysql but I have had little luck so 
far. Here is my systems specs:

2.6.9-34.ELsmp #1 SMP Thu Mar 9 06:23:23 GMT 2006 x86_64 x86_64 x86_64 
GNU/Linux
This is CentOS release 4.3 (Final)
This is Perl version 5.008005 (5.8.5)

This is MailScanner version 4.74.15
Module versions are:
1.00    AnyDBM_File
1.20    Archive::Zip
0.22    bignum
1.03    Carp
1.41    Compress::Zlib
1.119   Convert::BinHex
0.17    Convert::TNEF
2.121   Data::Dumper
2.27    Date::Parse
1.00    DirHandle
1.05    Fcntl
2.73    File::Basename
2.08    File::Copy
2.01    FileHandle
1.06    File::Path
0.20    File::Temp
0.78    Filesys::Df
1.35    HTML::Entities
3.56    HTML::Parser
2.37    HTML::TokeParser
1.23    IO
1.14    IO::File
1.13    IO::Pipe
2.04    Mail::Header
1.87    Math::BigInt
0.20    Math::BigRat
3.05    MIME::Base64
5.427   MIME::Decoder
5.427   MIME::Decoder::UU
5.427   MIME::Head
5.427   MIME::Parser
3.03    MIME::QuotedPrint
5.427   MIME::Tools
0.11    Net::CIDR
1.25    Net::IP
0.16    OLE::Storage_Lite
1.04    Pod::Escapes
3.05    Pod::Simple
1.08    POSIX
1.19    Scalar::Util
1.77    Socket
2.13    Storable
1.4     Sys::Hostname::Long
0.18    Sys::Syslog
1.26    Test::Pod
0.7     Test::Simple
1.9707  Time::HiRes
1.02    Time::localtime

Optional module versions are:
1.32    Archive::Tar
0.22    bignum
1.82    Business::ISBN
1.10    Business::ISBN::Data
1.08    Data::Dump
1.814   DB_File
1.13    DBD::SQLite
1.58    DBI
1.15    Digest
1.01    Digest::HMAC
2.36    Digest::MD5
2.11    Digest::SHA1
1.00    Encode::Detect
0.17008 Error
0.19    ExtUtils::CBuilder
2.18    ExtUtils::ParseXS
2.36    Getopt::Long
0.44    Inline
1.08    IO::String
1.04    IO::Zlib
2.21    IP::Country
0.22    Mail::ClamAV
3.002005        Mail::SpamAssassin
v2.004  Mail::SPF
1.999001        Mail::SPF::Query
0.2808  Module::Build
0.20    Net::CIDR::Lite
0.63    Net::DNS
0.002.2 Net::DNS::Resolver::Programmable
0.31    Net::LDAP
 4.004  NetAddr::IP
1.94    Parse::RecDescent
missing SAVI
2.64    Test::Harness
0.95    Test::Manifest
1.95    Text::Balanced
1.35    URI
0.7203  version
0.65    YAML

And before you say it, I know the OS is old but we had an application 
running on this machine that did not allow us to update. I think we 
could now so maybe I should do that. But let me finish describing the issue.

Today I started getting these in my logs:

May 19 08:29:10 rosewood MailScanner: MailScanner setting UID to postfix 
(80)
May 19 08:29:12 rosewood MailScanner: Unable to initialise database 
connection: Can't connect to local MySQL server through socket 
'/var/run/mysql.sock' (2) at 
/usr/lib/MailScanner/MailScanner/CustomFunctions/SQLBlackWhiteList.pm 
line 116
May 19 08:29:12 rosewood MailScanner: Unable to initialise database 
connection: Can't connect to local MySQL server through socket 
'/var/run/mysql.sock' (2) at 
/usr/lib/MailScanner/MailScanner/CustomFunctions/MailWatch.pm line 82
May 19 08:29:12 rosewood MailScanner: Could not use Custom Function code 
MailScanner::CustomConfig::InitMailWatchLogging, it could not be 
"eval"ed. Make sure the module is correct with perl -wc at 
/usr/lib/MailScanner/MailScanner/Config.pm line 873

When I run perl -wc perl -wc /usr/lib/MailScanner/MailScanner/Config.pm

I get:

Useless use of hash element in void context at 
/usr/lib/MailScanner/MailScanner/Config.pm line 892.
Use of implicit split to @_ is deprecated at 
/usr/lib/MailScanner/MailScanner/Config.pm line 2085.
/usr/lib/MailScanner/MailScanner/Config.pm syntax OK


and more logs:

May 19 13:16:56 rosewood postfix/trivial-rewrite[31466]: fatal: 
mysql:/etc/postfix/maps/sql-aliases.cf(0,lock|fold_fix): table lookup 
problem
May 19 13:16:56 rosewood postfix/trivial-rewrite[31467]: warning: 
connect to mysql server localhost: Can't connect to local MySQL server 
through socket '/var/run/mysql.so
ck' (2)
May 19 13:16:56 rosewood postfix/trivial-rewrite[31467]: fatal: 
mysql:/etc/postfix/maps/sql-aliases.cf(0,lock|fold_fix): table lookup 
problem
May 19 13:16:56 rosewood postfix/trivial-rewrite[31468]: warning: 
connect to mysql server localhost: Can't connect to local MySQL server 
through socket '/var/run/mysql.so
ck' (2)
May 19 13:16:56 rosewood postfix/trivial-rewrite[31468]: fatal: 
mysql:/etc/postfix/maps/sql-aliases.cf(0,lock|fold_fix): table lookup 
problem
May 19 13:16:57 rosewood postfix/cleanup[28938]: warning: premature 
end-of-input on private/rewrite socket while reading input attribute name
May 19 13:16:57 rosewood postfix/smtpd[29109]: warning: premature 
end-of-input on private/rewrite socket while reading input attribute name
May 19 13:16:57 rosewood postfix/cleanup[28938]: warning: problem 
talking to service rewrite: Connection reset by peer
May 19 13:16:57 rosewood postfix/smtpd[29109]: warning: problem talking 
to service rewrite: Success

The mysql.sock file does exist at this location with appropriate 
ownership and permissions. I have tried recreating it as well.

Upon restart of MailScanner, it seems to start but MailWatch seems to be 
dead. However, I can still not send or receive emails.

Anyone see anything that might give me a hint?

Dave