apparently not sending or receiving emails

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

Mysql is running and I can log in and select and search tables. But, as 
you will see below, the logs indicate that there are issues connecting 
through the mysql.sock. You will also note that the path it is trying to 
connect to is /var/run/mysql.sock while the actual location is at 
/var/run/mysqld/mysql.sock

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


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