MailScanner Lint Error

[Paul Scott]

Hello Peter and Shawn,

Thank you both for your assistance.  Much appreciated.  I did everything as suggested, but still could not get the telnet test to work, whilst using the machine's internal IP address.  So I did the following:

mysql> GRANT ALL ON *.* to root@'10.1.252.219' IDENTIFIED BY 'root';
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

And lo-and-behold, I can now perform the telnet test, using the machine's IP address, as follows:

[root at fs9 etc]# telnet 10.1.252.219 3306
Trying 10.1.252.219...
Connected to 10.1.252.219.
Escape character is '^]'.
J
5.5.55D'6vs\U€h.KomT<n8g$wmysql_native_passwordConnection closed by foreign host.
[root at fs9 etc]#

However, the same connection issue occurs when I try to run the upgrade.php script:

[root at fs9 MailWatch-1.2.10]# php upgrade.php
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)
[root at fs9 MailWatch-1.2.10]#

Let me know what you think.  Thank you very much!

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 12:28 PM
To: mailscanner at lists.mailscanner.info
Subject: Re: MailScanner Lint Error

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)
> 
> 
> 
> 




-- 
MailScanner mailing list
mailscanner at lists.mailscanner.info
http://lists.mailscanner.info/mailman/listinfo/mailscanner