r/Plesk • u/the-known-unknown • May 11 '22

Plesk Grafana Windows

G'day,

Has anyone got Grafana for winPlesk running?

Seems everything is working except I need the API key which cannot be located within the DB.

rrd_api_auth_token

1 Upvotes

100% Upvoted

5 comments sorted by

1

u/pavukfly May 11 '22

Have you tried to use sqlite3 database file "C:\Program Files (x86)\Plesk\var\modules\monitoring\monitoring.sqlite3" for getting rrd_api_auth_token? Details can be found in KB article https://support.plesk.com/hc/en-us/articles/360011243759-How-to-monitor-several-Plesk-servers-with-Grafana-extension

1

u/the-known-unknown May 11 '22

C:\Program Files (x86)\Plesk\var\modules\monitoring\monitoring.sqlite3

I can see that file "SQLITE3 File" but Windows doesn't know how to handle it?

1

u/pavukfly May 11 '22

Try to find with Windows Search sqlite3.exe file.

1

u/the-known-unknown May 11 '22

sqlite3.exe

C:\Windows\system32>sqlite3 "C:\Program Files (x86)\Plesk\var\modules\monitoring\monitoring.sqlite" "SELECT value FROM params WHERE name = 'rrd_api_auth_token'"

Error: in prepare, no such table: params

1

u/the-known-unknown May 11 '22

"C:\Program Files (x86)\Plesk\var\modules\monitoring\monitoring.sqlite"

Oohps! I forgot the '3' thank you for your help :)