Unable to connect to MySQL source using Private Data Connector

  • What Grafana version and what operating system are you using?
    Grafana Cloud 10.3

  • What are you trying to achieve?
    Use the MySQL Data Source with a DB that is in a private network, with the help of Grafana Private Data Connector.

  • How are you trying to achieve it?
    PDC agent has been setup and is online, test successful from Grafana Cloud side.

MySQL data source is configured with valid database credentials, triple checked and tested from my local machine.

  • What happened?
    When running the test in the Data source configured with the PDC, two errors are shown

There was an error when testing this data source, please check PDC agent logs.

[sqleng.connectionError] failed to connect to server - Please try again. If the issue persists please open a support ticket that notes the time in UTC.

No logs occur on the PDC agent.

  • What did you expect to happen?
    The Data source should have been able to connect to the private database successfully.

  • Can you copy/paste the configuration(s) that you are having problems with?
    N/A

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    Above.

  • Did you follow any online instructions? If so, what is the URL?
    I followed the instructions in the PDC screen. PDC docs are here Private data source connect (PDC) | Grafana Cloud documentation

1 Like

Hi @connorhsm, could you please explain how you deploy the pdc agent, which installation method you used like kubernetes or docker and also what are the checks i need to do to achieve the agent connection. I refer the official documentaton in grafana for PDC but i am not clear, so I am asking. It would be really helpful if you also provide me the deployment file you used to deploy the pdc-agent image.

1 Like

Hello did you solve this?
I am using windows binary.
but the datasource is not connecting, but different error than yours
image

It says check pdc logs, but dont know where to look exactly: the command promt where i launched the pdc binary gives this starter logs, but no error logs after failed to connect local mysql datasource.

pdc.exe -token <token created from pdc config page> -cluster prod-ap-south-0 -gcloud-hosted-grafana-id 744478 -ssh-flag='-o PermitRemoteOpen=localhost:3306'
level=info caller=main.go:109 ts=2024-03-01T12:32:21.168871+06:00 msg="PDC agent info" version=v0.0.23 commit=881abe89f842ec98b27d6bfc7371c8333c07d669 date=2023-12-18T13:52:47Z sshversion="OpenSSH_for_Windows_8.1p1, LibreSSL 3.0.2\r" os=windows arch=amd64
level=info caller=ssh.go:109 ts=2024-03-01T12:32:21.1697119+06:00 msg="starting ssh client"
level=info caller=keymanager.go:53 ts=2024-03-01T12:32:21.1697119+06:00 msg="starting key manager"
level=info caller=keymanager.go:179 ts=2024-03-01T12:32:21.1702594+06:00 msg="found existing valid certificate"
level=info caller=keymanager.go:192 ts=2024-03-01T12:32:21.1707646+06:00 msg="found valid grafana_pdc_known_hosts"
level=info caller=ssh.go:276 ts=2024-03-01T12:32:23.0818954+06:00 msg="Allocated port 1234 for remote forward to socks:0"
level=info caller=ssh.go:276 ts=2024-03-01T12:32:23.2494344+06:00 msg="This is Grafana Private Datasource Connect!\n"

Enable -log.level=debug for pdc agent first.