juliusloman / grafana-restsql-datasource Goto Github PK

When i try to add datasource i get error in grafana

Failure
Could not connect to datasourceundefined

tomcat logs

192.168.0.3 - - [21/Aug/2016:04:48:03 +0600] "GET /restsql-0.8.11URI_RESOURCE HTTP/1.1" 404 1021

Hi,

I’m trying to get some metrics from the restsql mysql demo database “sakila”, but without success. I'm using restsql v0.8.11 and grafana v4.0

What I’ve done so far:

• Created a simple test query against the “actor” table. That table has a TIMESTAMP field (“last_update”), and a SMALLINT UNSIGNED field (“id”) so I guess it should work for showing up in grafana.
• Defined a restsql datasource in grafana. I correctly see all my defined restsql queries and corresponding fields.
• Created a singlestat panel, graph panel and table panel but none of them were showing any datapoints. I checked the URL that was using grafana (e.g: /restsql/res/Test?metricTimestamp=%3E=2006-01-01T12:53:38.190&metricTimestamp=%3C=2007-01-01T12:53:38.000) and it was answering some JSON like this:
  { "actors": [ { "id": 1, "first_name": "PENELOPE", "surname": "GUINESS", "metricTimestamp": "2006-02-15 04:34:33.0" }, { "id": 2, "first_name": "NICK", "surname": "WAHLBERG", "metricTimestamp": "2006-02-15 04:34:33.0" }, { "id": 3, "first_name": "ED", "surname": "CHASE", "metricTimestamp": "2006-02-15 04:34:33.0" } ] }

Any help would be appreciated.
Thanks.