taosdata / grafanaplugin Goto Github PK

支持对超级表的distinct函数

grafana插件列表搜不到 TdEngine

Currently the datasource has one implementation client side that uses the Grafana datasource proxy, i.e. http://<host>/api/datasources/proxy/<ds identifier>/sql to fetch data. It also has a backend implementation which seems to only be used for supporting Grafana Alerting. Grafana also had this setup for built-in datasources, but most have now migrated to use the backend implementation from client side, i.e. /api/ds/query, and for Grafana Alerting.

Some customers have raised concerns regarding performance and loading a lot of data using this datasource and would like to be able to use Grafana Enterprise Query Caching, but it's currently not supported.

By making your datasource extend the DataSourceWithBackend instead of DataSourceApi it will support Grafana Enterprise Query Caching. Using DataSourceWithBackend will out of the box use /api/ds/query to fetch data, see example.

grafana:10.3
tdengine:2.6
grafanaplugin:3.4.7

apiVersion: 1

datasources:
- name: TDengine
  type: tdengine-datasource
  access: proxy
  orgId: 1
#   # <string> url
  url: "http://localhost:6041"
  basicAuth: true
  isDefault: true
  secureJsonData:
    url: "http://localhost:6041"
    basicAuth: "XXXXXXXXXXXXX"
  version: 1
  editable: false

我想直接用 select 语句查询几条记录, 然后将记录的各个字段展示为一个 table, 但是我不知道这个地方应该怎么处理
我看各种示例都是取的各种平均值, 最大值等等数据, 并没有将字段展示出来的示例, 所以特此求助

Hello!

I hope you are doing well!

We are a security research team. Our tool automatically detected a vulnerability in this repository. We want to disclose it responsibly. GitHub has a feature called Private vulnerability reporting, which enables security research to privately disclose a vulnerability. Unfortunately, it is not enabled for this repository.

Can you enable it, so that we can report it?

Thanks in advance!

PS: you can read about how to enable private vulnerability reporting here: https://docs.github.com/en/code-security/security-advisories/repository-security-advisories/configuring-private-vulnerability-reporting-for-a-repository

https://www.taosdata.com/blog/2019/07/10/192.html

在分类汇总数据，metric的情况下，diff函数有意义，建议支持

Hello, in the process of using Table pannel, I found that the time series to columns mode of table transform was selected, and a part of data was lost, but there was no problem switching to time series to rows. Since I need to display multiple columns of data, I use the time series to columns mode.

The version of grafana I used was 6.7.3
The version of tdengine I used was 2.0.8.2

测试使用api构建一个自动化流程的时候，mysql等数据源可以做到自动连接，但是tdengine必须要手动输入用户名密码。同时可以显示URL，但实际点击测试error502，需要重新手动输入URL
post /api/datasources
{

"name": "tdengine-datasource",
"type": "tdengine-datasource",
"url": "http://tdengine-openiiot-shimu.openiiot-shimu.svc.cluster.local:6041",
"access": "proxy",
"basicAuth": true,
"basicAuthUser": "root",
"isDefault": true,
"secureJsonData": {
    "basicAuthPassword": "taosdata"
         }       

}

• 插件版本：3.3.0
• TDEngine 版本：2.6.0.32
• 现象：TDinsight 70% 的图表数据不会展示，回滚到 3.2.8 可正常展示

异常现象
升级插件并导入图表，其中有 70% 以上的图表无法展示

grafana-cli plugins install tdengine-datasource 3.3.0

后进行回滚，图表正常展示

grafana-cli plugins install tdengine-datasource 3.2.8

Error: tsdb.HandleRequest() error Could not find executor for data source type: taosdata-tdengine-datasource
Can we support alerting with tdengine？

Object
request:Object
url:"api/datasources/proxy/1/sql"
data:"select last(first_ep) from .cluster_info group by first_ep;"
method:"POST"
hideFromInspector:false
response:Object
code:9728
desc:"syntax error near ".cluster_info group by first_ep;""

grafana插件支持自定义查询变量（使用 taos 的SQL语言）

1.granfa接入tdengine-datasource添加数据源报404

2.curl http://:6041/metrics可以看到相关指标，log库也是有数据的

3.grafana后台报错如下

When latest version grafana load "taosdata/grafanaplugin" in volume like: - ./grafana/plugins/:/var/lib/grafana/plugins/
and restart grafana services by "docker-compose restart grafana", I entry website and find wrong log in datasource, like:
"Unsigned plugins were found during plugin initialization. Grafana Labs cannot guarantee the integrity of these plugins. We recommend only using signed plugins.
The following plugins are disabled and not shown in the list below:

taosdata-tdengine-datasource

Missing signature"

And, fllowing is image info:
docker image:
prom/prometheus v2.1.0 c8ecf7c719c1 3 years ago 112MB
grafana/grafana latest c6e5c4f48cf9 2 weeks ago 213MB
Could you sign this plugin ? Thanks!

Unexpected token '<' Evaluating http://prod.iotn2n.com:3000/public/app/plugins/datasource/tdengine/module Loading app/plugins/datasource/tdengine/module
Data Source Error

Following instruction on the github, i am able to download the plugin but not able to unzip it to the grafana plugin directory

tdengine-datasource-3.1.1.zip 100%[====================================================>] 27.90M 35.4MB/s in 0.8s

2021-11-16 17:28:02 (35.4 MB/s) - ‘tdengine-datasource-3.1.1.zip’ saved [29256274/29256274]

(base) vibhu@vibhu-Opti-1-UB20:~$ sudo unzip tdengine-datasource-$GF_VERSION.zip /var/lib/grafana/plugins/
Archive: tdengine-datasource-3.1.1.zip
caution: filename not matched: /var/lib/grafana/plugins/

Also tried to manually copy the zip file over to plugins directory and change the options in /etc/grafana/grafana.ini

enable_alpha = true
allow_loading_unsigned_plugins = taosdata-tdengine-datasource

Now the Grafana server is not starting

 Loaded: loaded (/lib/systemd/system/grafana-server.service; enabled; vendor preset: enabled)
 Active: failed (Result: exit-code) since Tue 2021-11-16 18:04:55 PST; 3min 17s ago
   Docs: http://docs.grafana.org
Process: 2202 ExecStart=/usr/sbin/grafana-server --config=${CONF_FILE} --pidfile=${PID_FILE_DIR}/grafana-server.pid --packaging=deb cfg:default.paths.logs=${LOG_DIR} cfg:default.paths.data=${DATA_D} cfg:default.paths.plugins=${PLUGINS_DIR} cfg:default.paths.provisioning=${PROVISIONING_CFG_DIR} 

Main PID: 2202 (code=exited, status=1/FAILURE)cfg:default.paths.plugins=${PLUGINS_DIR} cfg:default.paths.provisioning=${PROVISIONING_CFG_DIR} (code=exited, status=1/FAILURE)

Nov 16 18:04:55 vibhu-Opti-1-UB20 systemd[1]: grafana-server.service: Scheduled restart job, restart counter is at 5.
Nov 16 18:04:55 vibhu-Opti-1-UB20 systemd[1]: Stopped Grafana instance.
Nov 16 18:04:55 vibhu-Opti-1-UB20 systemd[1]: grafana-server.service: Start request repeated too quickly.
Nov 16 18:04:55 vibhu-Opti-1-UB20 systemd[1]: grafana-server.service: Failed with result 'exit-code'.
Nov 16 18:04:55 vibhu-Opti-1-UB20 systemd[1]: Failed to start Grafana instance.

new dashboard/Edit Panel的界面报错，sql语句执行是ok的，但是不显示图

grafana version:grafana-8.0.4-1.x86_64.rpm
grafanaplugin from: TDengine-server-2.1.3.2-Linux-x64.tar.gz

when disable a query sql, the result also refresh at current panel.

环境：
taos -V：version: 2.4.0.12
grafana：v8.4.5
grafanaplugin: 3.1.4

tailf log文件有如下打印

04/12 09:08:38.451084 00001405 MND WARN show type:show grants is not support
04/12 09:08:43.167526 00001327 MND dnode:1, set to offline state, access seq:2178 last seq:2174 laststat:0
04/12 09:08:43.712848 00002479 TSC ERROR 0x3, HB, total dnode:1, online dnode:0
04/12 09:08:44.087486 00001365 RPC ERROR DND-S (nil) read error, leftLen:1734700592 retLen:-1 FD:0x7f30f0062e50

请问是什么原因，谢谢

As both Grafana and Taos support data streaming it would be amazing to have streaming functionality for the Grafana-plugin.

While I have no experience developing Grafana plugins, I can take a look at implementing this if someone could give me a few pointers how this could be integrated into the existing codebase of this plugin.

• TDengine查询出数据如下
  
• 在 Prometheus 数据源配置展示图可在 legend 中配置 {{city}} 从而使展示中每行数据名称为城市名，对应值为查询出的 cnt。类似数据展示如下
  
• TDengine 展示如下，如何让左侧的显示为城市名称？
  

查看了文档中内容，暂未发现可以实现此操作方式。
望解答，感谢~

My TDengine graph works fine, but alert rule can not run. I got this detail error message "tsdb.HandleRequest() error Could not find executor for data source type: tdengine-datasource".

version info：
system 14.04.1-Ubuntu,
grafana v7.3.5,
grafanaplugin 3.1.3

现象：

猜测原因：
最新版本的 tdengien system 应该是关键词，导致无法 as。

解决方案：
把 as system 改成另一个名字；

select _wstart as ts, last(cpu_engine) as taosd, last(cpu_system) as system2 from $database.dnodes_info where dnode_ep='$fqdn' and ts >= $from and ts <= $to interval($interval) fill(null)

在alert rules中SQL查询结果是非时序数据时结果显示还是Graph且显示No data（已确定是有结果），设置Format new col为”Table“结果一样，正常效果应该是当结果是非时序数据时下面的结果显示应该是使用Table而不是Graph.

Ubuntu 20.04
Grafana 8.2.4
Taosdb client version 2.2.1.3

Here are my data points aggregated over various days when data was collected
Here is the number of data points for a sensor on a specific date

So in grafana i expect i get a line of data on all these dates, when it executes "select ts,gryx_angle from gpsLogger.upboardberry1 WHERE ts > '2021-08-16T07:00:00.000Z' and ts < '2021-11-24T07:59:59.000Z';"

What I am observing is that only the data for 8/16/2021 is returned, even when I set grafana to return a large number of points.

I think there is certainly an issue as same thing happens with single day, it's just returning first 10K rows

looks like only first 10k rows are returned

hello,

grafana version:6.7.3/7.2.0
Tdengine verison:2.0.8.2

What should I do?

Grafana Version: 7.1.5
TDengine Version: 3.0.3.0
TDengine Datasource 3.3.1

如下图，所有的图表都是空的

使用的如下json
https://grafana.com/grafana/dashboards/15146-multiple-tdengines-monitoring/

请问TDengine Datasource Plugin 的版本是否正确？到底是什么原因导致的

第一个变量cha查询不到值时，第二个变量查询就会报错，然后dashboard就会卡死，所以希望查不到值是可以设置默认值

Can not manage to get the data source to work with Grafana v9.2.0; using root and taos data and confirmed that it is working from the command line taos -uroot -ptaosdata and the hostname is in the DNS and working properly. This is just an experiment in one machine.

see any SQL that can return Resultset such as:

• [[timestamp1, metric_name,value1], [timestamp2,metric_name, value2], ... ]

grafana8.4.4 alert 提示Alert rule Result Error,windows操作系统，tdengine-datasource插件是最新的 3.1.4

请问是tdengine-datasource插件的BUG吗 还是grafana的版本问题？

全新安装grafana8.0及以上版本会有unified alert告警可以使用。告警配置完成后测试语句会一直报错，而且保存后告警无效。
以为是float格式的数据无效，换用int型的数据也不行。

抓取6041的包可以看到有正常回复

之前提过的issue，不知道是不是提错地方了
taosdata/TDengine#8072

when add tdengine datasource and save after installing tdengine plugin for grafana, it shows "TDengine Data source is not working, reason: undefined"
Grafana version: 9.3.6
tdengine plugin version: 3.2.8