<br><br><div class="gmail_quote">2009/5/20 Dave Filchak <span dir="ltr"><<a href="mailto:submit@zuka.net">submit@zuka.net</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi folks,<br>
<br>
Today a problem arose in my mail setup that I am trying to track down. I can no longer send or receive emails.<br>
<br>
I think it has something to do with mysql but I have had little luck so far.<br>
<br>
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<br>
<br>
Here is my systems specs:<br>
<br>
2.6.9-34.ELsmp #1 SMP Thu Mar 9 06:23:23 GMT 2006 x86_64 x86_64 x86_64 GNU/Linux<br>
This is CentOS release 4.3 (Final)<br>
This is Perl version 5.008005 (5.8.5)<br>
<br>
This is MailScanner version 4.74.15<br>
Module versions are:<br>
1.00 AnyDBM_File<br>
1.20 Archive::Zip<br>
0.22 bignum<br>
1.03 Carp<br>
1.41 Compress::Zlib<br>
1.119 Convert::BinHex<br>
0.17 Convert::TNEF<br>
2.121 Data::Dumper<br>
2.27 Date::Parse<br>
1.00 DirHandle<br>
1.05 Fcntl<br>
2.73 File::Basename<br>
2.08 File::Copy<br>
2.01 FileHandle<br>
1.06 File::Path<br>
0.20 File::Temp<br>
0.78 Filesys::Df<br>
1.35 HTML::Entities<br>
3.56 HTML::Parser<br>
2.37 HTML::TokeParser<br>
1.23 IO<br>
1.14 IO::File<br>
1.13 IO::Pipe<br>
2.04 Mail::Header<br>
1.87 Math::BigInt<br>
0.20 Math::BigRat<br>
3.05 MIME::Base64<br>
5.427 MIME::Decoder<br>
5.427 MIME::Decoder::UU<br>
5.427 MIME::Head<br>
5.427 MIME::Parser<br>
3.03 MIME::QuotedPrint<br>
5.427 MIME::Tools<br>
0.11 Net::CIDR<br>
1.25 Net::IP<br>
0.16 OLE::Storage_Lite<br>
1.04 Pod::Escapes<br>
3.05 Pod::Simple<br>
1.08 POSIX<br>
1.19 Scalar::Util<br>
1.77 Socket<br>
2.13 Storable<br>
1.4 Sys::Hostname::Long<br>
0.18 Sys::Syslog<br>
1.26 Test::Pod<br>
0.7 Test::Simple<br>
1.9707 Time::HiRes<br>
1.02 Time::localtime<br>
<br>
Optional module versions are:<br>
1.32 Archive::Tar<br>
0.22 bignum<br>
1.82 Business::ISBN<br>
1.10 Business::ISBN::Data<br>
1.08 Data::Dump<br>
1.814 DB_File<br>
1.13 DBD::SQLite<br>
1.58 DBI<br>
1.15 Digest<br>
1.01 Digest::HMAC<br>
2.36 Digest::MD5<br>
2.11 Digest::SHA1<br>
1.00 Encode::Detect<br>
0.17008 Error<br>
0.19 ExtUtils::CBuilder<br>
2.18 ExtUtils::ParseXS<br>
2.36 Getopt::Long<br>
0.44 Inline<br>
1.08 IO::String<br>
1.04 IO::Zlib<br>
2.21 IP::Country<br>
0.22 Mail::ClamAV<br>
3.002005 Mail::SpamAssassin<br>
v2.004 Mail::SPF<br>
1.999001 Mail::SPF::Query<br>
0.2808 Module::Build<br>
0.20 Net::CIDR::Lite<br>
0.63 Net::DNS<br>
0.002.2 Net::DNS::Resolver::Programmable<br>
0.31 Net::LDAP<br>
4.004 NetAddr::IP<br>
1.94 Parse::RecDescent<br>
missing SAVI<br>
2.64 Test::Harness<br>
0.95 Test::Manifest<br>
1.95 Text::Balanced<br>
1.35 URI<br>
0.7203 version<br>
0.65 YAML<br>
<br>
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.<br>
<br>
Today I started getting these in my logs:<br>
<br>
May 19 08:29:10 rosewood MailScanner: MailScanner setting UID to postfix (80)<br>
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<br>
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<br>
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<br>
<br>
When I run perl -wc perl -wc /usr/lib/MailScanner/MailScanner/Config.pm<br>
<br>
I get:<br>
<br>
Useless use of hash element in void context at /usr/lib/MailScanner/MailScanner/Config.pm line 892.<br>
Use of implicit split to @_ is deprecated at /usr/lib/MailScanner/MailScanner/Config.pm line 2085.<br>
/usr/lib/MailScanner/MailScanner/Config.pm syntax OK<br>
<br>
<br>
and more logs:<br>
<br>
May 19 13:16:56 rosewood postfix/trivial-rewrite[31466]: fatal: mysql:/etc/postfix/maps/<a href="http://sql-aliases.cf" target="_blank">sql-aliases.cf</a>(0,lock|fold_fix): table lookup problem<br>
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<br>
ck' (2)<br>
May 19 13:16:56 rosewood postfix/trivial-rewrite[31467]: fatal: mysql:/etc/postfix/maps/<a href="http://sql-aliases.cf" target="_blank">sql-aliases.cf</a>(0,lock|fold_fix): table lookup problem<br>
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<br>
ck' (2)<br>
May 19 13:16:56 rosewood postfix/trivial-rewrite[31468]: fatal: mysql:/etc/postfix/maps/<a href="http://sql-aliases.cf" target="_blank">sql-aliases.cf</a>(0,lock|fold_fix): table lookup problem<br>
May 19 13:16:57 rosewood postfix/cleanup[28938]: warning: premature end-of-input on private/rewrite socket while reading input attribute name<br>
May 19 13:16:57 rosewood postfix/smtpd[29109]: warning: premature end-of-input on private/rewrite socket while reading input attribute name<br>
May 19 13:16:57 rosewood postfix/cleanup[28938]: warning: problem talking to service rewrite: Connection reset by peer<br>
May 19 13:16:57 rosewood postfix/smtpd[29109]: warning: problem talking to service rewrite: Success<br>
<br>
<br>
Upon restart of MailScanner, it seems to start but MailWatch seems to be dead. However, I can still not send or receive emails.<br>
<br>
Anyone see anything that might give me a hint?<br>
<br>
Dave<br><font color="#888888">
<br>
<br>
<br>
<br>
<br>
-- <br>
MailScanner mailing list<br>
<a href="mailto:mailscanner@lists.mailscanner.info" target="_blank">mailscanner@lists.mailscanner.info</a><br>
<a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" target="_blank">http://lists.mailscanner.info/mailman/listinfo/mailscanner</a><br>
<br>
Before posting, read <a href="http://wiki.mailscanner.info/posting" target="_blank">http://wiki.mailscanner.info/posting</a><br>
<br>
Support MailScanner development - buy the book off the website! <br>
</font></blockquote></div><br>Dave<div><br></div><div>anything in the mysql logs? Can you connect to mysql on the command line - ie is mysql actually running?<br clear="all"><br>-- <br>Martin Hepworth<br>Oxford, UK<br>
</div>