Accessing Untangle PostgreSQL from Grafana

[DennisFaucher]

Hello,

I have successfully added the Untangle PostgreSQL database to Grafana as a data source and can access Untangle PostgreSQL from my Grafana server using psql. When I "Explore" the data source from Grafana, no fields are found. I also find that psql /dt returns nothing but /dt *.* returns all tables. This might be a schema issue. Any ideas? TIA.

[DennisFaucher]

I figured it out. You need to type the table name in manually when creating a new dashboard. A list of tables will not pop up. Once I typed in "reports.intrusion_prevention_events" as the table name, all other lists were populated.

[DennisFaucher]

Here is a blog post I wrote describing all the steps. Enjoy blog[dot]faucher[dot]net/2021/07/untangle-postgresql-grafana-dashboards.html