PRTG PlugIn | Datasource access failing

Hello

I am new to Grafana, I learned about it recently from this blog article:

What caught my eye in grafana was the quality of the graphs vs the prtg graphs. Thus I went ahead and deployed the latest stable grafana build. UPon installing it on windows server 2012 R2 which is also running PRTG, both it and Grafana are the latest builds.

I hope that version of windows will work as there are not any system requirements documented that I was able to find.
Once I did this I went into PRTG and created a RO user for the Grafana. In the API section of PRTG you can build a custom query which I did shown below and I executed it from within PRTG, it worked just fine, this is it here:

http://172.16.18.10/api/table.xml?content=groups&output=csvtable&columns=objid,probe,group,name,downsens,partialdownsens,downacksens,upsens,warnsens,pausedsens,unusualsens,undefinedsens
&username=tothomas&passhash=2222222222

Using the Grafana & PRTG Plugin documentation I went ahead and added the plugins and dashboards needed along with setting my prtg instance as a data source, following these instructions exactly.

My implementation is identical to what is shown on the ‘edit data source’ picture from the instructions, obviously the IP Address and password are different. I tried http / https, with http auth, without http auth. So far I have NOT been able to get Grafana to connect to the data source as I would of expected.

The troubleshooting documentation is on the light side but some searching revealed the logging setting so I increased logging hoping to capture anything that can help me determine what is failing and why. I say it this way because all Grafana returns is a red bar and an exclamation point! No error verbiage at all.

Logging revealed the following after a restart, only thing I see is the table is locked…

t=2017-11-09T15:10:47-0600 lvl=info msg=“Initializing CleanUpService” logger=cleanup
t=2017-11-09T15:10:47-0600 lvl=info msg=“Initializing Alerting” logger=alerting.engine
t=2017-11-09T15:10:47-0600 lvl=info msg="Initializing Stream Manager"
t=2017-11-09T15:10:47-0600 lvl=info msg=“Initializing HTTP Server” logger=http.server address=172.16.18.10:8080 protocol=http subUrl= socket=
t=2017-11-09T15:12:14-0600 lvl=info msg=“Database table locked, sleeping then retrying” logger=sqlstore retry=0
t=2017-11-09T15:12:14-0600 lvl=info msg=“Database table locked, sleeping then retrying” logger=sqlstore retry=0
t=2017-11-09T15:12:14-0600 lvl=info msg=“Database table locked, sleeping then retrying” logger=sqlstore retry=0
t=2017-11-09T15:12:14-0600 lvl=info msg=“Database table locked, sleeping then retrying” logger=sqlstore retry=0
t=2017-11-09T15:12:14-0600 lvl=info msg=“Database table locked, sleeping then retrying” logger=sqlstore retry=1
t=2017-11-09T15:12:14-0600 lvl=info msg=“Database table locked, sleeping then retrying” logger=sqlstore retry=1
t=2017-11-09T15:12:14-0600 lvl=info msg=“Database table locked, sleeping then retrying” logger=sqlstore retry=2
t=2017-11-09T15:12:14-0600 lvl=info msg=“Request Completed” logger=context userId=1 orgId=2 uname=admin method=GET path=/login status=302 remote_addr=172.16.17.199 time_ms=539 size=24 referer=
t=2017-11-09T15:12:26-0600 lvl=info msg=“Request Completed” logger=context userId=1 orgId=2 uname=admin method=GET path=/api/datasources/proxy/1/status.json status=404 remote_addr=172.16.17.199 time_ms=743 size=4906 referer=http://bedrock:8080/datasources/edit/1

Any assistance is appreciated, thank you.

Bumping as it seems these forums are not monitored and its the only option we have for support.