Influxdb 2.1, influxql, problem to access database

InfluxDB 2
1

Hello,

Since the upgrade from 2.0 to 2.1 i have some trouble accessing database through API V1.

I can’t write with Telegraf 1.20.4, the same config i was using before send me to this :

2021-12-14T13:30:00Z E! [outputs.influxdb] E! [outputs.influxdb] Failed to write metric (will be dropped: 404 Not Found):

Telegraf output config :

[[outputs.influxdb]]
  urls = ["http://127.0.0.1:8086"]
  database = "elasticsearch"
  username = "metrics"
  password = "xxxxxxxxx"
  skip_database_creation = true
  [outputs.influxdb.tagpass]
    tag1 = [ "elasticsearch" ]

I can’t access to the database anymore with Gafana 8.3.2, the database test succeed , but it can’t see the retention policies so it failed to load mesurements list.

Event with curl, i doesn’t work anymore :
curl -k http://localhost:8086/query -u 'metrics:xxxxxx.' -d q='SHOW RETENTION POLICIES on "elasticsearch"'

My config in Influx :

 $ influx bucket list
ID                      Name            Retention       Shard group duration    Organization ID         Schema Type
1980a638df195248        elasticsearch   720h0m0s        24h0m0s                 920ba989433e2dc2        implicit

 $ influx v1 dbrp list
ID                      Database        Bucket ID               Retention Policy        Default Organization ID
089a40d43f544000        elasticsearch   1980a638df195248        default                 true    920ba989433e2dc2

$  influx v1 auth list
ID                      Description     Username        v2 User Name    v2 User ID              Permissions
089a41d411d44000                        metrics         admin           089a3d246c944000        [read:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 read:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 read:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 read:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 read:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 read:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 read:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 read:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 read:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 read:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 read:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 read:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 read:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 write:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 write:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 write:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 write:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 write:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 write:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 write:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 write:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 write:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 write:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 write:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 write:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6 write:orgs/920ba989433e2dc2/buckets/f929e76fc37151d6]

Any idea ?

2

Yes, your telegraf config:

[[outputs.influxdb]]

is for InfluxDBv1 - but you explicitly mentioned that you use InfluxDBv2 - therefore you need:

[[outputs.influxdb_v2]]

… and the configuration also differs from the v1 plugin.

3

True, I’m using the v1 API , because it is what i want to do. And the API v1 still exist in InfluxDBv2.

It was working in InfluxDB 2.0, i have problems since the update en É.B.

4

I found the reason.

There is a bug in Influx CLI 2.1, who broke the ACL creation on multiple bucket for V1 API :