Dashboard not loading data.

[TheTechnologyStudio]

I installed the dashboard and the data source connections and configured the dashboard according to the instructions. I have also tested and made sure the postgresql datasource can connect to the database and it can.

My dashboards are still not loading any data.

[dinger1986]

Is the url right?

[dinger1986]

What do the errors show?

[TheTechnologyStudio]

Oh permissions error, Status: 500. Message: db query error: pq: permission denied for table agents_agent

[dinger1986]

So db user doesn't have permissions. Check the troubleshooting steps

[TheTechnologyStudio]

it is working now. Thank you!

[dinger1986]

Just needed to reset the dbreader password?

[TheTechnologyStudio]

Just needed to reset the dbreader password?

No i ran these commands:

GRANT CONNECT ON DATABASE tacticalrmm TO dbreader; GRANT USAGE ON SCHEMA public to dbreader; GRANT SELECT ON ALL TABLES IN SCHEMA public TO dbreader; ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO dbreader; quit

but instead of dbreader i changed it to the user i already had, Grafana.

[TheTechnologyStudio]

im used to mariadb not postgres . this is my first time with postgres

[dinger1986]

Your using mariadb with tactical?

[TheTechnologyStudio]

No, but i've never interacted with postgres prior to this

[dinger1986]

Ah lol. Cool. Please close this if you are all done. I'd imagine dbreader is created as well so maybe want to delete that user so you don't have users who aren't being used

[TheTechnologyStudio]

btw, importing agentdash-v2.json throws this error: Import failed JSON -> JS Serialization failed: Bad escaped character in JSON at position 54622

and client dash: Import failed JSON -> JS Serialization failed: Bad escaped character in JSON at position 41444

[TheTechnologyStudio]

the rest seems to work fine.

[dinger1986]

You can copy and paste the json directly if that works

[TheTechnologyStudio]

will try that.

[TheTechnologyStudio]

json validator threw this error:

Error: Parse error on line 1310: ...true, "rawSql": "SELECT \n count( ----------------------^ Expecting 'STRING', 'NUMBER', 'NULL', 'TRUE', 'FALSE', '{', '[', got 'undefined'

[dinger1986]

The dashboards have been provided by others sorry don't know what's wrong with it

[TheTechnologyStudio]

Okay, Thank you for trying at least. I will play around with it. and il let u know if i fix it.

[dinger1986]

Ok no problems

[TheTechnologyStudio]

Hey Dinger, Can you update both agentdash-v2 with https://pastebin.com/F53ZHZEs and clientdash with https://pastebin.com/fv8W94hv

These are working copies of both scripts.

[dinger1986]

Please PR the changes

[TheTechnologyStudio]

All i did was pull old versions of the scripts. The one before the latest commit. You are the one listed as creating the scripts I listed above before the one person overwrote that script with some changes.

[dinger1986]

lol sorry, I didnt check them, Ill revert them then, thanks!

[dinger1986]

I have added as v3 and v1 so leaving the ones working as I think they fix something else that didnt work.

Thanks for your help!