Hello
I use a very simple InfluxDB 1.8.10 on my old Raspberry Pi 3B+ to collect my watermeter data.
The DB “wasserzaehler” has only time
and kubikmeter
as values.
They are written with the ESP32 project GitHub - jomjol/AI-on-the-edge-device: Easy to use device for connecting "old" measuring units (water, power, gas, ...) to the digital world
But the meter cannot be read at the moment (waterdrops everywhere) and I want to insert my own readings in the database.
Now I first tried something like this inside of my rasp (via ssh):
curl -i -XPOST ‘``http://localhost:8086/write?db=wasserzaehler’`` --data-binary 'kubikmeter=2.643'
here I get a missing fields error, but on:
curl -i -XPOST ‘``http://localhost:8086/write?db=wasserzaehler’`` --data-binary ‘kubikmeter value=2.643’
I got a 204 No content, which should be fine, but the value is not in the db
When I do in the influxdb:
SELECT * FROM zaehlerstand WHERE kubikmeter > 2
I get nothing (my values are all under 2).
Also when I directly try to put values in the influx with:
INSERT kubikmeter=2.643
or
INSERT time=’2025-09-07T07:03:00Z’ kubikmeter=2.643
neither I find this value in the db.
But now I have weird series:
SHOW series
key
—
kubikmeter
time=’2025-09-07T07:03:00Z’
zaehlerstand
I added series instead of values
And in theses series indeed the entered values are present.
So in the end (by making these errors) I found that I can curl this:
curl -i -XPOST ``http://192.168.0.160:8086/write?db=wasserzaehler`` --data-binary ‘zaehlerstand kubikmeter=2.677’
where 192.168.0.160 is the IP from my rasp in my local network.
And this enters the value 2.677 into the zaehlerstand series
But how can I drop now the wrong series kubikmeter
and time=’2025-09-07T07:03:00Z’
from my database?
DROP series kubikmeter
Doesnt obviusly work (missing from or where). In the help DROP SERIES it is not clear to me and I fear to delete my good series.
Thanks for help
frank