Influxdb v1 compatibility 501

InfluxDB 2
,
1

I am trying to use v1 compatibility mode against an influx cloud instance and I get a 501 for /query. I have followed all instructions listed here InfluxDB 1.x compatibility API | InfluxDB Cloud Documentation to query with a token. I know that my token is correct as I can use it against other endpoints. Additionally if I change my token I get a 401. This implies I have a correct token getting passed the auth, but then I get a 501 from query endpoint.

curl -v --get "https://us-east-1-1.aws.cloud2.influxdata.com/query" \
  --header "Authorization: Token <token>" \
  --header 'Content-type: application/json' \
  --data-urlencode "db=metrics" \
  --data-urlencode "q=SELECT * FROM cpu_usage"

results in

< HTTP/2 501 
< date: Tue, 04 Apr 2023 23:49:56 GMT
< content-type: application/json; charset=utf-8
< content-length: 54
< request-id: bd76494b5aae2bf4757fdc20c522aefb
< trace-id: 59d15201432bbc1d
< trace-sampled: false
< vary: Accept-Encoding
< x-platform-error-code: not implemented
< x-request-id: bd76494b5aae2bf4757fdc20c522aefb
< strict-transport-security: max-age=15724800; includeSubDomains
< x-influxdb-request-id: bd76494b5aae2bf4757fdc20c522aefb
< x-influxdb-build: Cloud

I have confirmed the metrics dbrp is setup

influx v1 dbrp list                                                                         
ID			Database	Bucket ID		Retention Policy	Default	Organization ID
0afe7de4228aa000	metrics		<removed>	default-rp		true	<removed>

also of note, if I use the cli with v1 shell, I get a 501 with every query as well

2

Hello @connr,
If you’re using InfluxDB Cloud I recommend just querying with SQL directly (now supported in InfluxDB Cloud).
Would that solve your problems?

Or do you need to use the V1 compatibility for something specific?

3

Hey there!
Just ran into this post here since I’m facing the same issue. A little more context:

I had to migrate to Cloud instance eu-central-1-1.aws.cloud2. Now the new cloud and database architecture does not seem to support InfluxQL in Grafana any longer. In my previous cloud instance I was able to run Grafana with InfluxQL by running through the docs around DRBP mapping and token based authentication in Grafana. Same thing now gives me error 501. Like mentioned by connr, changing the token shows error 401…

Two reasons for me to stay with InfluxQL are:

  1. I have a quite large on-prem Raspberry Setup of Influx&Grafana, my cloud instance is supposed to give me a lightweight solution accessible from everywhere, 30 days data retention is fine for that. So I don’t want to re-create all dashboards in another query language. I used to copy/paste the json statements from one instance to the other for all panels with just minor adjustments on the datapoint names,…

  2. I was unable to install the FlightSQL plugin in my Grafana cloud instance, telling me that my Grafana (cloud) version isn’t compatible with the plugin (or vice versa).

Please check if there’s a possibility to implement InfluxQL for the new instances. Or if not, does that mean InfluxQL is a dead end now?

Thanks and have a good day!