MailScanner Lint Error

[Peter H. Lemieux]

Most MySQL configurations default to listening only on localhost for 
security reasons.  You have to insert a "bind-address=0.0.0.0" directive 
in my.cnf to make it listen on all interfaces.

Peter

On 8/23/20 3:14 PM, Paul Scott wrote:
> Hello Peter,
> 
> Thank you very much for your email!
> 
> I tried your suggestion, and this is what came back:
> 
> [root at fs9 MailWatch-1.2.10]# telnet localhost 3306
> Trying ::1...
> telnet: connect to address ::1: Connection refused
> Trying 127.0.0.1...
> Connected to localhost.
> Escape character is '^]'.
> J
> 5.5.55;xm:wi*€]];O[Z57Rv!9mysql_native_passwordConnection closed by foreign host.
> [root at fs9 MailWatch-1.2.10]#
> 
> So, I do get connected via the localhost address, BUT...if I try the server's actual IP address, this is what I get:
> 
> [root at fs9 MailWatch-1.2.10]# telnet 10.1.252.245 3306
> Trying 10.1.252.245...
> Connected to 10.1.252.245.
> Escape character is '^]'.
> THost 'edenusa-fs9.edenhosting.net' is not allowed to connect to this MySQL serverConnection closed by foreign host.
> [root at fs9 MailWatch-1.2.10]#
> 
> So maybe that's the issue?
> 
> Sincerely,
> 
> Paul Scott
> Engineer, Eden USA, Incorporated
> 866.501.3336 | 951.505.6967 | sales at edenusa.com
> https://www.edenusa.com
> 
> 
> 
> 
> 
> -----Original Message-----
> From: MailScanner <mailscanner-bounces+sales=edenusa.com at lists.mailscanner.info> On Behalf Of Peter H. Lemieux
> Sent: Sunday, August 23, 2020 11:37 AM
> To: mailscanner at lists.mailscanner.info
> Subject: Re: MailScanner Lint Error
> 
> What happens if you run "telnet localhost 3306"?  Do you see
> 
> Trying 127.0.0.1...
> Connected to localhost.
> Escape character is '^]'.
> 
> I don't use MailWatch, but does it connect to MySQL via a socket
> (typically /var/lib/mysql/mysql.sock) or via TCP on port 3306?
> 
> Peter
> 
> 
> On 8/23/20 2:15 PM, Paul Scott wrote:
> 
>> 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)
> 
> 
> 
>