cannot send or receive mail

Scott Silva ssilva at sgvwater.com
Tue May 19 23:28:14 IST 2009


on 5-19-2009 3:11 PM Dave Filchak spake the following:
> 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
> 
If you stop mysql, does the socket file go away?
If not you have a dead socket file. Delete it and restart mysql and see if it
comes back.

Otherwise it sounds like one of the databases might be corrupt.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 258 bytes
Desc: OpenPGP digital signature
Url : http://lists.mailscanner.info/pipermail/mailscanner/attachments/20090519/34f13db8/signature.bin


More information about the MailScanner mailing list