<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
font-size:10.0pt;
font-family:"Courier New";}
tt
{mso-style-priority:99;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Consolas",serif;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hello,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">While trying to get this all working again, I decided to install MailWatch, and after a long and ardous installation process, finally got it to mostly work, but have found (using phpMyAdmin), that nothing is getting written to the database
tables, and I cannot login to the MailWatch interface. So there seems to be a MySQL database connection issue, but for the life of me, I cannot figure it out.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I tried running the upgrade.php script again to see if it would reveal anything, and here is the output:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">[root@fs9 MailWatch-1.2.10]# php upgrade.php<o:p></o:p></p>
<p class="MsoNormal">Error: Database connection failed: it is possible that the database is overloaded or otherwise not running properly; contact the system administrator if the problem persists (dbconnecterror99_plain)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">So, I checked the status, and it is running okay:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">[root@fs9 MailWatch-1.2.10]# service mysqld status<o:p></o:p></p>
<p class="MsoNormal">mysqld (pid 12946) is running...<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Tried restarting it, and then ran upgrade.php again, and received the same error.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Any ideas as to where I can start looking to get this working? Thank you very much!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Sincerely,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="470" style="width:352.5pt">
<tbody>
<tr>
<td width="10" valign="top" style="width:7.5pt;padding:0in 7.5pt 0in 0in">
<p class="MsoNormal"><img width="67" height="48" style="width:.6979in;height:.5in" id="_x0000_i1027" src="https://d36urhup7zbd7q.cloudfront.net/9e4f2f04-230b-48c6-8181-fde14e22749e/NewLogo.format_png.resize_200x.png#logo" alt="photo"><o:p></o:p></p>
</td>
<td valign="top" style="border:none;border-right:solid #45668E 1.0pt;padding:0in 0in 0in 0in">
</td>
<td valign="top" style="padding:0in 7.5pt 0in 7.5pt">
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#646464">Paul Scott</span></b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#646464"><br>
Engineer, Eden USA, Incorporated <o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="470" style="width:352.5pt">
<tbody>
<tr>
<td style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:9.0pt;color:#8D8D8D"><a href="tel:866.501.3336"><span style="font-family:"Arial",sans-serif;color:#8D8D8D">866.501.3336</span></a>
</span><span style="font-size:9.0pt;color:#45668E">|</span><span style="font-size:9.0pt;color:#8D8D8D">
<a href="tel:951.505.6967"><span style="font-family:"Arial",sans-serif;color:#8D8D8D">951.505.6967</span></a>
</span><span style="font-size:9.0pt;color:#45668E">|</span><span style="font-size:9.0pt;color:#8D8D8D">
<a href="mailto:sales@edenusa.com"><span style="font-family:"Arial",sans-serif;color:#8D8D8D">sales@edenusa.com</span></a>
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:9.0pt;color:#8D8D8D"><a href="https://www.edenusa.com/" target="_blank"><span style="font-family:"Arial",sans-serif;color:#8D8D8D">https://www.edenusa.com</span></a></span>
<o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#646464;display:none"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td style="padding:7.5pt 0in 0in 0in"></td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> MailScanner <mailscanner-bounces+sales=edenusa.com@lists.mailscanner.info>
<b>On Behalf Of </b>Shawn Iverson via MailScanner<br>
<b>Sent:</b> Tuesday, August 11, 2020 2:30 AM<br>
<b>To:</b> mailscanner@lists.mailscanner.info<br>
<b>Cc:</b> Shawn Iverson <shawniverson@summitgrid.com><br>
<b>Subject:</b> Re: MailScanner Lint Error<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p><tt><span style="font-size:10.0pt">Are you running sendmail? If so...</span></tt><o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="line-height:14.25pt;background:#1E1E1E"><span style="font-size:10.5pt;font-family:"Courier New";color:#D4D4D4">chkconfig sendmail off<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="line-height:14.25pt;background:#1E1E1E"><span style="font-size:10.5pt;font-family:"Courier New";color:#D4D4D4">chkconfig sm-client off<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="line-height:14.25pt;background:#1E1E1E"><span style="font-size:10.5pt;font-family:"Courier New";color:#D4D4D4">chkconfig ms-sendmail on<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="line-height:14.25pt;background:#1E1E1E"><span style="font-size:10.5pt;font-family:"Courier New";color:#D4D4D4">service ms-sendmail start<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="line-height:14.25pt;background:#1E1E1E"><span style="font-size:10.5pt;font-family:"Courier New";color:#D4D4D4"><o:p> </o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal">On 8/10/20 9:02 PM, Paul Scott wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">Oh, and the running OS is CentOS 6. Sorry, I should have put that in the email.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Thank you!<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="470" style="width:352.5pt">
<tbody>
<tr>
<td width="10" valign="top" style="width:7.5pt;padding:0in 7.5pt 0in 0in">
<p class="MsoNormal"><img border="0" width="67" height="48" style="width:.6979in;height:.5in" id="_x0000_i1026" src="https://d36urhup7zbd7q.cloudfront.net/9e4f2f04-230b-48c6-8181-fde14e22749e/NewLogo.format_png.resize_200x.png#logo" alt="photo"><o:p></o:p></p>
</td>
<td valign="top" style="border:none;border-right:solid #45668E 1.0pt;padding:0in 0in 0in 0in">
</td>
<td valign="top" style="padding:0in 7.5pt 0in 7.5pt">
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#646464">Paul Scott</span></b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#646464"><br>
Engineer, Eden USA, Incorporated </span><o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="470" style="width:352.5pt">
<tbody>
<tr>
<td style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:9.0pt;color:#8D8D8D"><a href="tel:866.501.3336"><span style="font-family:"Arial",sans-serif;color:#8D8D8D">866.501.3336</span></a>
</span><span style="font-size:9.0pt;color:#45668E">|</span><span style="font-size:9.0pt;color:#8D8D8D">
<a href="tel:951.505.6967"><span style="font-family:"Arial",sans-serif;color:#8D8D8D">951.505.6967</span></a>
</span><span style="font-size:9.0pt;color:#45668E">|</span><span style="font-size:9.0pt;color:#8D8D8D">
<a href="mailto:sales@edenusa.com"><span style="font-family:"Arial",sans-serif;color:#8D8D8D">sales@edenusa.com</span></a>
</span><o:p></o:p></p>
</td>
</tr>
<tr>
<td style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:9.0pt;color:#8D8D8D"><a href="https://www.edenusa.com/" target="_blank"><span style="font-family:"Arial",sans-serif;color:#8D8D8D">https://www.edenusa.com</span></a></span>
<o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#646464"> </span><o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td style="padding:7.5pt 0in 0in 0in"></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="color:black"> </span><o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> MailScanner <a href="mailto:mailscanner-bounces+sales=edenusa.com@lists.mailscanner.info">
<mailscanner-bounces+sales=edenusa.com@lists.mailscanner.info></a> <b>On Behalf Of
</b>L.P.H. van Belle via MailScanner<br>
<b>Sent:</b> Monday, August 10, 2020 12:54 PM<br>
<b>To:</b> <a href="mailto:mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.info</a><br>
<b>Cc:</b> L.P.H. van Belle <a href="mailto:belle@bazuin.nl"><belle@bazuin.nl></a><br>
<b>Subject:</b> Re: MailScanner Lint Error<o:p></o:p></p>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<p class="MsoNormal">I don't know your running os, but on debian, running su-update is done as the user running the service.<o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">i suspect wrong rights somewhere.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">i had it myself, also due running sa-update as root. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">I hope it helps.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Greetz,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Louis<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<p class="MsoNormal">Op 10 aug. 2020 21:08 schreef Paul Scott <<a href="mailto:sales@edenusa.com">sales@edenusa.com</a>>:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<p style="margin-bottom:12.0pt"> <br>
<br>
Hello MailScanner folks and friends: <br>
<br>
<br>
<br>
I continue to hammer away at trying to get MailScanner working again. I managed to get the install to run without error, but I still do not see MailScanner actively processing any SPAM at all in the “maillog” log file. It only shows its startup messages,
and that’s it. The process ID remains running, but MailScanner is effectively dead (doesn’t do any work). I also did successfully use CPAN to upgrade Spam Assassin to the very latest version, just now.
<br>
<br>
<br>
<br>
[root@fs9 log]# spamassassin -V <br>
<br>
SpamAssassin version 3.4.4 <br>
<br>
running on Perl version 5.10.1 <br>
<br>
[root@fs9 log]# <br>
<br>
<br>
<br>
<br>
<br>
After that, I tried MailScanner –lint, and had some issues, which I fixed, until I now have this result:
<br>
<br>
<br>
<br>
[root@fs9 ~]# MailScanner --lint <br>
<br>
Trying to setlogsock(unix) <br>
<br>
<br>
<br>
Reading configuration file /etc/MailScanner/MailScanner.conf <br>
<br>
Reading configuration file /etc/MailScanner/conf.d/README <br>
<br>
Read 1500 hostnames from the phishing whitelist <br>
<br>
Read 7949 hostnames from the phishing blacklists <br>
<br>
<br>
<br>
Checking version numbers... <br>
<br>
Version number in MailScanner.conf (5.3.3) is correct. <br>
<br>
<br>
<br>
Your envelope_sender_header in spamassassin.conf is correct. <br>
<br>
<br>
<br>
Checking for SpamAssassin errors (if you use it)... <br>
<br>
Using SpamAssassin results cache <br>
<br>
Connected to SpamAssassin cache database <br>
<br>
config: registryboundaries: no tlds defined, need to run sa-update <br>
<br>
SpamAssassin reported no errors. <br>
<br>
Auto: Found virus scanners: clamd <br>
<br>
Using locktype = flock <br>
<br>
MailScanner.conf says "Virus Scanners = auto" <br>
<br>
Found these virus scanners installed: clamd <br>
<br>
=========================================================================== <br>
<br>
Filename Checks: Windows/DOS Executable (1 eicar.com) <br>
<br>
Other Checks: Found 1 problems <br>
<br>
Virus and Content Scanning: Starting <br>
<br>
Clamd::INFECTED:: Win.Test.EICAR_HDB-1 :: ./1/eicar.com <br>
<br>
Virus Scanning: Clamd found 2 infections <br>
<br>
Infected message 1 came from 10.1.1.1 <br>
<br>
Virus Scanning: Found 2 viruses <br>
<br>
=========================================================================== <br>
<br>
Virus Scanner test reports: <br>
<br>
Clamd said "eicar.com was infected: Win.Test.EICAR_HDB-1" <br>
<br>
<br>
<br>
If any of your virus scanners (clamd) <br>
<br>
are not listed there, you should check that they are installed correctly <br>
<br>
and that MailScanner is finding them correctly via its virus.scanners.conf. <br>
<br>
<br>
<br>
I don’t know what this error means, or how to fix it—I did run “sa-update”, and it did not fix it:
<br>
<br>
config: registryboundaries: no tlds defined, need to run sa-update <br>
<br>
<br>
<br>
Can you please let me know how to fix this? <br>
<br>
<br>
<br>
<br>
<br>
Also, of interest, I read in the spamassassin.conf that there is a Processing.db, that is in the /var/spool/MailScanner/incoming folder, and to clear it, you delete it, and it should be recreated when MailScanner is restarted, it will be recreated. I tried
that, but it did NOT get recreated, not sure why. Any ideas? <br>
<br>
<br>
<br>
The bottom line here is that MailScanner is not doing what it should be doing, and that is scanning incoming mail. I am having a great deal of trouble figure this out. Please help. Thank you very much!
<br>
<br>
<br>
<br>
Sincerely, <br>
<br>
<br>
<br>
<br>
<br>
Paul Scott <br>
Engineer, Eden USA, Incorporated <br>
<br>
866.501.3336 | 951.505.6967 | <a href="mailto:sales@edenusa.com">sales@edenusa.com</a>
<br>
<br>
<a href="https://www.edenusa.com">https://www.edenusa.com</a> <br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></p>
<pre><o:p> </o:p></pre>
<pre><o:p> </o:p></pre>
</blockquote>
<div>
<p class="MsoNormal">-- <br>
<img border="0" width="190" height="96" style="width:1.9791in;height:1.0in" id="_x0000_i1025" src="http://mailserver.summitgrid.org/logo_text_sig.png"><br>
Shawn Iverson<br>
<a href="mailto:shawniverson@summitgrid.com">shawniverson@summitgrid.com</a><o:p></o:p></p>
</div>
</div>
</body>
</html>