Questions tagged [influxdb-2]

More information here https://v2.docs.influxdata.com/v2.0/. Version 2 uses a new query language called Flux and it is also reactive in nature.

289 questions
0
votes
0 answers

how do I get solver the failed to create remote connection "remote" in local InfluxDB: 404 Not Found: path not found in influxdb 2?

I am try to create a remote connection from my OSS to my cloud in order to replica a bucket from local to the cloud. however I'm stock in the "influx remote create" below the command and flags 'm parsing: influx remote create --name remote --org-id…
Ranger
  • 11
  • 1
0
votes
0 answers

token required after fresh install of InfluxDB 2.6.1 in GKE

Trying to do a fresh install/deploy of gcr.io/cloud-marketplace/google/influxdb2:latest (2.6.1) into a GKE cluster. Using the CLI (influx setup) to configure the initital user, pwd and token. All runs fine, no errors and I can confirm user, pwd and…
cjt
  • 273
  • 4
  • 8
0
votes
0 answers

Flux query to get the average per 15 minutes for the last 30 day

I have an influxDB bucket called my_data It has the energy consumption (EDC) values as field The measurement is called my_portal The tag is serialNumber The data is stored every 15 minutes via Mqtt I want to write a flux query to get the average…
MarioBe
  • 101
  • 1
  • 4
0
votes
0 answers

Data Subscriptions in Infux V2.X

In Influx V1.8 there are subscriptions, that are sending all the data to a specified target. I want to send all the incoming Data to an Azure Event-Hub. Subscriptions in V1.8 worked great for this, but i don't know how to do it in Influx V2.6, as…
bastie
  • 11
  • 1
0
votes
0 answers

Issue while storing data to Influxdb using telegragh configuration with custom timestamp

I am trying to implement a small datalogger using Influxdb v2.7, Telegraf v1.26, and Grafana v9.4. The data is in JSON format and it is fetched from the mosquitto mqtt server using Telegraf. I am trying to store data with a custom timestamp given in…
0
votes
0 answers

InfluxDB - ExceptionPKIX path building failed: unable to find valid certification path to requested target

We are trying to use a self-signed certificate to update data to an influx db over TLS. I can log into the Influx console with https by by adding these parameters to the xml for the service: --tls-cert "certs/cert.crt" --tls-key…
Jack BeNimble
  • 35,733
  • 41
  • 130
  • 213
0
votes
1 answer

Missing CSV Export button in Influxdb 2.7 Data Explorer

I recently upgraded my Influxdb instance from 2.61 to 2.7, but the CSV export button in the Data Explorer is no longer displayed. I didn't see anything in the changelog, and I wasn't able to find it relocated to somewhere else. Has this feature…
Kristofer
  • 361
  • 5
  • 14
0
votes
1 answer

Influxdb2 influx grafana word cloud from multiple results

I am getting into influxdb2 and flux currently. My playground is, to scrape a public website and be able to visualize the words on the website in a word cloud in Grafana. This works, but when my range selection in Grafana results in multiple…
moestly
  • 1,681
  • 15
  • 19
0
votes
0 answers

telegraf on windows, influxdb

i'm new to telegraf and influxdb, and I tried multiple things. So what I try to achieve, is to monitor 2 windows-based servers where I wanna have the metrics stored on a rock pi where debian 11 is used as os. for testing purpose, I used my personal…
kevekop
  • 3
  • 2
0
votes
0 answers

influxDB: range makes all data disappear

I'm mapping my data into a single day -- today -- so that I can see busy and quiet times of the day. mapToDay = (tables=<-) => tables |> drop(columns: ["_start", "_stop"]) |> map(fn: (r) => ({r with _time: date.add(d: duration(v: string(v:…
Richard Barraclough
  • 2,625
  • 3
  • 36
  • 54
0
votes
0 answers

flux query: adding range() makes rows disappear

I'm using this function to map data into a single day so that, for exampe, I can see busy and quiet times of the day. (This is a bit of a hack because the charts in InfluxDB UI require the x-axis to be a timestamp.) import "date" mapToDay =…
Richard Barraclough
  • 2,625
  • 3
  • 36
  • 54
0
votes
1 answer

fields and field values are not pushed into influxdb 2.0 bucket

Here a dataframe for stock XYZ: timestamp open high low close volume timestamp 2021-02-04 04:21:00 2021-02-04 04:21:00 1.41 1.41 …
David
  • 13
  • 5
0
votes
0 answers

Why schema is not available for influx db OSS but for Influx Cloud

As per this, bucket is supported from Influx 2.0.0+ But schema is available for only Influx cloud as per this document It says that it's not available in OSS V 2.3. Is it available in 2.6 version and how to add that?
Gibbs
  • 21,904
  • 13
  • 74
  • 138
0
votes
0 answers

Pivot issue in influxdb2.x

Why I am getting below error while querying influx2.2 using pivot operator. I could not understand the error and its fix. /home/ravi> influx query 'from(bucket:"RIC-Test") |> range(start: 0) |> pivot(rowKey:["_time"], columnKey: ["_field"],…
0
votes
0 answers

InfluxDB: Getting the error "ERR: 404 unauthorized: unauthorized access" while trying to access users or databases

I am trying to access the users or databases in influxdb 2.6 but when I run the command show users, I get the below error message in cmd. (ERR: 404 Unauthorized: unauthorized access) [Error]: https://i.stack.imgur.com/DF9ig.png Can you please help…
Ash
  • 3
  • 3