Results 1 to 3 of 3
  1. #1
    Newbie
    Join Date
    Jul 2021
    Posts
    3

    Default Accessing Untangle PostgreSQL from Grafana

    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.
    Screen Shot 2021-07-07 at 4.17.20 PM.png
    Screen Shot 2021-07-07 at 4.18.21 PM.png

  2. #2
    Newbie
    Join Date
    Jul 2021
    Posts
    3

    Default

    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.
    Screen Shot 2021-07-09 at 2.22.53 PM.png

  3. #3
    Newbie
    Join Date
    Jul 2021
    Posts
    3

    Default

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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

SEO by vBSEO 3.6.0 PL2