InfluxDB data source 405 error with SQL Query Language

grafana / grafana

The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.

https://grafana.com

GNU Affero General Public License v3.0

63.81k stars 11.94k forks source link

InfluxDB data source 405 error with SQL Query Language #82120

Open twillhorn opened 7 months ago

twillhorn commented 7 months ago

What happened?

When attempting "Save & Test" I get this error:

ERROR: flightsql: rpc error: code = Unknown desc = unexpected HTTP status code received from server: 405 (Method Not Allowed); transport: received unexpected content-type "text/html"

I am following the instructions here: https://docs.influxdata.com/influxdb/cloud-serverless/process-data/visualize/grafana/

and here: https://www.influxdata.com/blog/official-influxdb-v3-data-source-grafana-released/

What did you expect to happen?

A successful connection

Did this work before?

How do we reproduce it?

Create an InfluxDB using the tutorial e.g. /new-user-setup/python
Follow the instructions https://www.influxdata.com/blog/official-influxdb-v3-data-source-grafana-released/

Is the bug inside a dashboard panel?

No response

Environment (with versions)?

Grafana: v10.4.0-65875 (b758b91e84) OS: Mac Browser: Chrome

Grafana platform?

I use Grafana Cloud

Datasource(s)?

InfluxDB

danielvoelk commented 7 months ago

I have the same issue

keynode commented 6 months ago

Same issue, Following doc instructions:

ERROR: flightsql: rpc error: code = Unknown desc = unexpected HTTP status code received from server: 405 (Method Not Allowed); transport: received unexpected content-type "text/html"

danielvoelk commented 6 months ago

I fixed it by changing the HTTP from USA to Europe. It showed up as Europe for me, but it was actually the USA url.

yosiasz commented 6 months ago

Are you installing locally or on the cloud? share screen grab of your setup

tonypowa commented 6 months ago

hello @twillhorn

thank you for reaching out

is the issue still occurring? is it on prem or cloud? could you provide the settings in the configuration of the InfluxDB datasource within Grafana?

twillhorn commented 6 months ago

My Grafana trial expired so I cannot try to reproduce

tonypowa commented 6 months ago

thank you for the reply @twillhorn In that case let's close the issue If you encounter the same problem again, please add a comment and we will reopen

skilledboy commented 4 months ago

Hi, I have the same issue ERROR: flightsql: rpc error: code = Unknown desc = unexpected HTTP status code received from server: 405 (Method Not Allowed); transport: received unexpected content-type "text/html"