How to connect grafana to influxdbv2 by InfluxQL method

Taipq2 · 2020-12-28T08:36:29.869Z

Hi everyone,
First, sorry about my english
I have just installed Grafana v7.3.6 and Influxdb v2.0.3
I am trying connect data source on grafana to influxdb server by InfluxQL method but it giving error bad request.
I already followed this page but it can’t be work!

docs.influxdata.com

Use Grafana with InfluxDB OSS | InfluxDB OSS 2.6 Documentation

Use Grafana to visualize data from your InfluxDB instance.

I know I can connect by Flux method (I tried and success) but i want to InfluxQL method
Please help me if you have same error. Thanks everybody.

Brian_Gibson · 2020-12-28T19:28:41.906Z

As I understand it, you cannot connect Grafana 7 with Influx 2.0 OSS using influxql. Only Flux. Which has caused me to start a crash course on Flux in the past week.

There are other versions of Influx that do work. I believe you have to map a database to a bucket, inside of InfluxDB.

Taipq2 · 2020-12-29T07:44:55.883Z

HI @Brian_Gibson
I mapped bucket to database but still not work

Taipq2 · 2020-12-29T07:46:33.335Z

@Brian_Gibson,
I map unmapped bucket as Query data with InfluxQL | InfluxDB OSS 2.0 Documentation

Brian_Gibson · 2020-12-29T14:40:44.614Z

Are you using Influx 2.0 OSS?

Ruij · 2020-12-29T19:29:55.272Z

Anyone got it working ?
I am also using grafana 7.3.6 with influxdb 2.0.3 and I have the same problem.
Even following the link: Creating InfluxQL Datasource to InfluxDB v2 returns Unauthorized(401) or InfluxDB Error: Bad Request · Issue #29372 · grafana/grafana · GitHub I am not able to understand what the mean with "This should contain the value: “Token {token}”
thanks

Taipq2 · 2020-12-30T02:17:46.367Z

Yes, I’m using influxdb v2.0.3

Ruij · 2020-12-31T12:45:07.400Z

Hi, as i am a newbie on this can you help me with the steps needed to put it working ?
I have installed the influxdb v2.0.3 and created an Organization and a Bucket, how should I map unmapped bucket, is there any rule to name the database or can it be anything ?
I dis also installed Grafana 7.3.6, How did you configure the data source, where did you configure the token ?
thanks in advance, if would be great if you could help me.

Taipq2 · 2021-01-04T01:44:55.041Z

Hi,
If you choose Flux method, configure like this

image665×741 34.7 KB

Ruij · 2021-01-04T12:36:28.057Z

Hi, thanks for your answer, using Flux I am able to connect, what I am not able to do is to connect with InfluxQL. were you able to make it work ?
thanks again.

vshaev · 2021-01-04T12:51:49.689Z

Sorry for my English.
Yesterday I spent half a day with this. Unfortunately, the documentation on this is poor.
We have to get information piece by piece. Here’s my experience.
1.Match is required as specified here https://docs.influxdata.com/influxdb/v2.0/query-data/influxql/#map-unmapped-buckets
2. create a source https://docs.influxdata.com/influxdb/v2.0/tools/grafana/
In addition, what is in this manual must be added according to this instruction -
https://github.com/grafana/grafana/issues/29372#issuecomment-733717988
Please note, the token is in the format - Token mytoken. That is, before the token itself, write the word - Token
Good luck

Ruij · 2021-01-04T16:31:17.398Z

Hi, my english is not good also,
Anyway, thanks for your help, but I would like to ask you if the database and retention policy that must be created, document of point 1:

influx v1 dbrp create
–db example-db
–rp example-rp \

needs to be something special or just a name that you decide to use, the same for retention policy.

Regards, thanks again.

Taipq2 · 2021-01-05T01:40:05.886Z

Hi, Unfortunately that is my issue too.

Taipq2 · 2021-01-05T02:23:41.642Z

Hi,
Like you said, it’s work for me i can connect from grafana to influxdbv2.0.3 by influxQL method.
Here is my configure data source on grafana

image697×434 19.5 KB

image960×580 31.6 KB

But in the end I can not query to database of influxdbv2.0.3 with error

Datasource is fine but cannot query to it ?. Can you help me ? many tks

Taipq2 · 2021-01-05T02:37:22.736Z

When I change database to name of database instead of 7d6d9c07e47e2257 it’s work totaly. There is no more error not excuted from influxdb

vshaev · 2021-01-05T08:56:34.300Z

Here is my complete code for creating the mapping -

influx v1 dbrp create \
–db mydb \
–rp autogen \
–bucket-id 123456789 \
–default \
–org myorg \
–token mytoken

mydb - the database to which I create a connection in Grafana
autogen - retention policy. To be honest, I set this parameter intuitively.
123456789 - is the ID of the mydb database specified above. It can be found in the interface, item “Data - Buckets”
myorg - organization name
token - token

Ruij · 2021-01-05T10:15:44.490Z

Thank you very much for your help, I have it running now.

singhswat · 2021-01-30T12:37:39.603Z

I’m using cloud so how do I connect? What url should I enter that it understand the connection path?
Thanks for the help

JBrdy · 2021-02-07T09:26:34.247Z

Hello everyone,
I dare to ask for a summary ? I can’t do it.

You have to add the Influx token in “Custom HTTP Headers” but what’s this “user” thing? It’s a notion that isn’t really there anymore with InfluxDB 2, isn’t it ?

And you have to use the bucket ID ? really ?

Thanks,

singhswat · 2021-02-13T19:39:08.429Z

@JBrdy Are you trying to connect Grafana and Influx Cloud?