Migrated Influxdb2 to Redhat 9.5 but unable to use mysql

InfluxDB 2
,
1

(posted on Slack also).
Need help here. Im trying to connect to a mySQL database from a Redhat server using a simple Flux query. The database is on a different server that is accessible from the same subnet.
I am still using Infuxdb v2.7.11. Works fine on windows but comes up with:

**failed to initialize execute state: data source did not pass url validation: no such host**

No idea what this is referring to. I thought it might be name lookup but it even does it with either localhost or the actual IP Address of the db server.
What am I missing? Is there some extra mysql driver required on Linux - admittedly I already had a Mariadb installed on Windows so may have avoided the issue on the Windows environment.
I noted that there are references to installing a go mysql module but this either doesnt work or I am doing something wrong in the installation.

Simple Flux commands are:

import "sql"

sql.from(
    driverName: "mysql",
    dataSourceName: "user:pwd@tcp(10.10.100.2:6033)/reports",
    query: "SELECT * FROM Devices",
)

It first appears at first glance to be an issue with the network connection but this is not the case as a telnet connection to the same server on the same port works.

telnet> open 10.10.100.2 6033
Trying 10.10.100.2...
Connected to 10.10.100.2.
Escape character is '^]'.

In addition to this, tcpdump shows that there is nothing exiting the server on this port when I run the Flux query

2

Have you gotten any help on slack?

If you’re open to alternatives I might suggest tryign to use Telegraf instead:

[[inputs.sql]]
  driver = "mysql"
  dsn = "user:password@tcp(10.10.100.2:6033)/reports"
  query = "SELECT * FROM Devices"
  name_suffix = "_devices"
3

Thanks for the suggestion Anais. Only 1 person has responded so far but the suggestion wasn’t the issue. I suspect it could be the environment/server as its fairly hardened and unfortunately the build is out of my control. Im not familiar with the GoLang install/environment which could be the issue, but Im going to have to plan to move away from flux anyway and for this particular issue, I think I may have found a different approach, by just using Grafana itself. I will try to install Influxdb in a test environment in the background though.