apparently not sending or receiving emails

Martin Hepworth maxsec at gmail.com
Wed May 20 08:54:30 IST 2009


2009/5/20 Dave Filchak <submit at zuka.net>

> 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
>
>
>
>
>
> --
> MailScanner mailing list
> mailscanner at lists.mailscanner.info
> http://lists.mailscanner.info/mailman/listinfo/mailscanner
>
> Before posting, read http://wiki.mailscanner.info/posting
>
> Support MailScanner development - buy the book off the website!
>

Dave
anything in the mysql logs? Can you connect to mysql on the command line -
ie is mysql actually running?

-- 
Martin Hepworth
Oxford, UK
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.mailscanner.info/pipermail/mailscanner/attachments/20090520/b30baf18/attachment-0001.html


More information about the MailScanner mailing list