LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 03-16-2023, 02:13 PM   #1
lpallard
Senior Member
 
Registered: Nov 2008
Posts: 1,044

Rep: Reputation: Disabled
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

Last edited by lpallard; 03-16-2023 at 02:17 PM.
 
Old 03-18-2023, 04:10 AM   #2
lvm_
Member
 
Registered: Jul 2020
Posts: 487

Rep: Reputation: 162Reputation: 162
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.

Last edited by lvm_; 03-19-2023 at 02:03 AM.
 
Old 03-18-2023, 11:23 AM   #3
lpallard
Senior Member
 
Registered: Nov 2008
Posts: 1,044

Original Poster
Rep: Reputation: Disabled
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?)...
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: KDE Participating in Google Summer of Code 2019, MariaDB Releasing New Open-Source MariaDB Enterprise Server, CentOS Celebrates 15th B LXer Syndicated Linux News 0 02-28-2019 06:50 AM
Can't access my locally hosted demo website from few (not all) another computers on the same network puneet1000 Linux - Networking 6 06-28-2017 05:20 AM
Move Slackware guest from a Slackware hosted Virtualbox to Windows hosted Virtualbox? damgar Slackware 1 08-07-2012 11:28 PM
[SOLVED] PHP File hosted locally in /var/www/html shows blank in browser Licera Linux - Software 13 11-18-2011 08:49 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 02:35 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration