LinuxQuestions.org - Network services throwing connection errors to a locally hosted Mariadb server

- Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)

- - Network services throwing connection errors to a locally hosted Mariadb server (https://www.linuxquestions.org/questions/linux-server-73/network-services-throwing-connection-errors-to-a-locally-hosted-mariadb-server-4175723112/)

Network services throwing connection errors to a locally hosted Mariadb server

Hello, for the last little while I have been getting random issues where network services running on a Proxmox host are throwing connection errors when working with a Mariadb server running in a VM on the same physical host.

Basically:

Code:

PVE (Proxmox host)

|

|---VM1 with web services 

|---VM2 with web services 

|---VM3 with MariaDB

Code:

A fatal error has occurred

Connect failed: (2002) php_network_getaddresses: getaddrinfo failed: 

Name or service not known

I experience issues with most of the web services I use but not all which is strange.. Usually, when getting an error like the one posted above, I simply hit refresh (F5) and the page loads as expected without further errors.. At first I was thinking about LOCAL firewall issues on the VM's but then things wouldn't simply get working again after a few seconds.

Strangely, SSH'ing to the MariaDB VM is working and I can confirm the VM has full network connectivity. Additionally, I cannot see traces of firewalling issues (I use pfsense).

The setup has pretty much been the same for years now so I know this is not something related to the networking setup on the Proxmox level, or pfsense config issues...

Short of posting on a database forum (if there's such a thing), how to troubleshoot this?

Code:

Server: Localhost via UNIX socket

Server version: 10.3.35-MariaDB-log - MariaDB Server

Protocol version: 10

It is not database-related: 'php_network_getaddresses: getaddrinfo failed: Name or service not known' error messages indicate DNS issues, and when they are intermittent they are a bitch to troubleshoot. Try connecting by IP or something.

I had the feeling it was network related, but I use pfsense and didnt see anything happening at the firewall level indicating an issue...

That helps me a bit I think because now I think this issue may be related to another issue I've been experiencing also when browsing the web (random DNS resolution failures where I just hit refresh and the site loads up)...

In a more general sense, I feel pfsense has lost a bit of stability in the last years (or perhaps my config has gone bad?)...