I am trying to install the latest version (7.11.20) SuiteCRM. PHP7.4.20, MariaDB 10.3.29, Apache 2.4.41 are installed. I see a Connection Refused error in suitecrm.log.
I have tried bind-ip address to localhost/127.0.0.1,, 0.0.0.0 but it has not worked. For the first two it gives me a connection refused error and the last two it shows that âMySQL server has gone awayâ error. I have precreated the database, database user with Grant All option, so using the âExisting userâ option. It really didnt matter if I asked the installer to create a new user, still shows the same error.
Yes, the DB user uses a password and I believe I am using it correctly. I can login to the DB using the same credentials - mysql -u -p. I am using the IP (not using 127.0.0.1 as it is not from the localhost that I am trying to connect but from another PCâs browser within the network [192.168.*. * ]). Will provide a screenshot shortly.
ERROR 2003 (HY000): Canât connect to MySQL server on â192.168.10.XXXâ (111 âConnection refusedâ).This is what I get, when I try to connect from a different VM in the network. Would really appreciate any assistance.
Hi. Thank you for the response. The gone away error was coming when the bind address is changed from 127.0.0.1 to the network IP assigned by DHCP. When I now connect from a different VM on the network, I get connection refused.
The address or port blocked in your network.
Look at the information from link @pgr wrote about
"
It is also possible to see this error if host name lookups fail (for example, if the DNS server on which your server or network relies goes down). This is because MySQL is dependent on the host system for name resolution, but has no way of knowing whether it is workingâfrom MySQLâs point of view the problem is indistinguishable from any other network timeout.
You may also see the MySQL server has gone away error if MySQL is started with the skip_networking system variable enabled.
Another networking issue that can cause this error occurs if the MySQL port (default 3306) is blocked by your firewall, thus preventing any connections at all to the MySQL server.
So I have installed SuiteCRM on my stage server without any issues. This stage server is on the same network and is running sans issues. I am now trying to perform another installation on a different VM. This would be my production instance. The only difference between both installations is that the stage is Ubuntu 18.04 and production is Ubuntu 20.04. I am even installing the same MariaDB, PHP, Apache and SuiteCRM versions that I have running on staging.
In view of the above, we can safely say that there is no issue in the DNS/network/firewall.