we have grafana in the cloud and im trying to figure out how to get sw data into grafana for dashboards. our sw is not availably publically on the internet. I tried to do the Grafana Private data Source setup, however my sql database isnst on my sw box its external to it.. anyone ever done this ?
Top Replies
-
mesverrum Has a great post here: (+) Connecting to the SWIS API with Grafana - DevOps Forum - DevOps Discourse - THWACK . This may not be your exact situation but may be helpful. -
I'll also mention that the Grafana PDC doesn't have to be on the same box, it can be set up to essentially act as a proxy within your environment so it can reach anything that the server you run the PDC…
Parents
-
-
-
-
-
I must not be very smart. YOURSERVER:17774/.../Query this string for health checks fails no matter if i do 17774 or 17778. however the pdc metric log indicates success
im consistently seeing this type of error in grafana
error while performing the infinity query. requested URL is not allowed. To allow this URL, update the datasource config Security -> Allowed Hosts section
(Trace ID: 0270a3d37b52b3ba334187140078d4ca)ive tried all flavors of this url below. ensuring that in the authentication tab has it on the allowed hosts, the security tab has it on the allowed hosts, and the health check tab has this explicitly YOURSERVER:17774/.../Query
When i click to save and test, it says successful. However im trying to build a dashboard per your instructions. and no matter what query i have selected from your github pags.. i always get the error above.
on the dashbaord page i am selecting URL and backend but it fails no mater what. so i tried all the URLS below as a test and they fail.
https://YOURSERVER:17774/SolarWinds/InformationService/v3/Json/Query
https://YOURSERVER:17774/
https://YOURSERVER:17774/SolarWinds/InformationService/v3/Json/Query?
-
In the dashboard itself you don't have to specify a URL, that part was a bit confusing for me the first time. Basically you are already inheriting the base url from the data source config, and since pretty much all operations we would use for a dashboard are aimed at the same url i just leave it blank. I expect you are getting complaints about an invalid url when you do the dashboard because it sounds like stacking the same info on both parts.
url set inside the data source, i also set this exact same one in my allowed hosts section.
myserver:17774/SolarWinds/InformationService/v3/Json/Query
for my health check i do
myserver:17774/SolarWinds/InformationService/v3/Json/Query?query=SELECT+TOP+1+Uri+FROM+Orion.Pollers
url left bank inside my dashboard panel and the query passed into the key:value params
-
-
No Data