Working on terminal but not in grafana [MariaDB]

Grafana Time Series Panel
1

Hy guys :wink: using grafana to check my proxmox machine and it’s working very well. Thanks to everybody that created this awesome tool. I was trying to expand grafana to another areas like the weather from my hometown. here is the problem :

I’m using mariadb has database and if i do this in terminal:
SELECT data , tempmini ,tempmax FROM tempo;
it works :
±--------------------±---------±--------+
| data | tempmini | tempmax |
±--------------------±---------±--------+
| 2019-06-12 01:50:28 | 7 | 20 |
±--------------------±---------±--------+
but i can’t do this on grafana.
i use this query on grafana:
’
SELECT
data as “time”,
tempmax,
tempmini
FROM tempo
’
But doesn’t show any type of data but i can see the tables on query inspector…

Query that i use to create the database:

CREATE TABLE tempo (

id INT NOT NULL AUTO_INCREMENT,

data DATETIME,

precipitacao INT,

tempmini INT,

tempmax INT,

classveloventviseu INT,

PRIMARY KEY (id)

);

Can anyone please find me a solution?

2

Which panel are you using?

3

I’m using Graph and tried Table … None worked

4

can you share the output from the query inspector?

5 
{
  "xhrStatus": "complete",
  "request": {
    "method": "POST",
    "url": "api/tsdb/query",
    "data": {
      "from": "1560490197973",
      "to": "1560511797973",
      "queries": [
        {
          "refId": "A",
          "intervalMs": 60000,
          "maxDataPoints": 720,
          "datasourceId": 3,
          "rawSql": "SELECT\n  data AS \"time\",\n  tempmax AS \"tempmax\",\n  tempmini AS \"tempmini\"\nFROM tempo\nWHERE\n  $__timeFilter(data)\nORDER BY data",
          "format": "time_series"
        }
      ]
    }
  },
  "response": {
    "results": {
      "A": {
        "refId": "A",
        "meta": {
          "rowCount": 0,
          "sql": "SELECT\n  data AS \"time\",\n  tempmax AS \"tempmax\",\n  tempmini AS \"tempmini\"\nFROM tempo\nWHERE\n  data BETWEEN FROM_UNIXTIME(1560490197) AND FROM_UNIXTIME(1560511797)\nORDER BY data"
        },
        "series": null,
        "tables": null
      }
    }
  }
}

Here it is… @bkgann

6

Does the above query return anything from commandline?