Direct DB Connection for postgres fails in grafana 10.2.3 (works in 10.2.2)

[Dennisik]

After updating Grafana from version 10.1.6 to 10.2.3, there is no option to select a PSQL source in Direct DB Connection.
On versions 10.1.x everything works as it should, but on version 10.2.x it does not work.

Grafana	Zabbix	Grafana-Zabbix Plugin
10.2.3	6.4.5	4.4.1

[rohanrajnv]

I am also facing the same issue

[reldred]

Yeap. Just migrated my grafana from a standalone docker server to my new production swarm cluster which pulled a fresh grafana docker image and I've lost the ability to talk to PostGres. Keen to hear what the go is :-D

[Glafkon]

Same issue. Updating Grafana to 10.2.3 from 10.2.2 and get the error "Could not connect to given url" - if "Enable Direct DB Connection" is activating.

Grafana	Zabbix	Grafana-Zabbix Plugin
10.2.3	6.4.10	4.4.4

[javivu]

Same issue in my side.

Grafana	Zabbix	Grafana-Zabbix Plugin
10.2.3	6.4.10	4.4.4

In my case, with Grafana PostgreSQL Data Source.

[kaellego]

I have the same problem. Here my environment is

Grafana	Zabbix	Grafana-Zabbix Plugin
10.2.3	6.4.10	4.4.4

only MySQL appears, but I need the PostgreSQL Data Source

from what i understand, the datasource type in postgres plugin changed its name to grafana-postgresql-datasource. In the sqlConnector.ts file on line 34 it uses the type to determine whether to use mysql or postgres , as the default is mysql it ends up performing all queries.

it causes error 400 after the update

[GustelDE]

Same here, the PostgresDB-Data-Source shows simply not up in the list and if already selected "Could not connect to given url".

Grafana: 10.2.3
Zabbix: 6.4.10
Grafana-Zabbix Plugin: 4.3.1 and 4.4.4

[daFlo]

+1

Grafana: 10.2.3
Zabbix: 6.4.10
Grafana-Zabbix Plugin: 4.4.4

[EYEVO]

Same here

Grafana: 10.2.3
Zabbix: 6.4.10
Grafana-Zabbix Plugin: 4.4.4

[gabor]

summary of the probable cause:

• at

  grafana-zabbix/src/datasource/zabbix/connectors/sql/sqlConnector.ts

  Line 34 in dfe360b

  if (this.datasourceTypeId === supportedDatabases.postgres) {

  the code is checking if the given plugin is a postgres-plugin, by checking if it's id is postgres
• in grafana10.2.3, the id of the postgres plugin changed to grafana-postgresql-dataosource ( https://github.com/grafana/grafana/blob/d1b0e9082dce87642b3d9bd18abd9430b509c8fa/public/app/plugins/datasource/grafana-postgresql-datasource/plugin.json#L4 )

[gabor]

the fix is live in the newest zabbix release (4.4.5)