environment.outside.pressure not shown in barograph plugin

[on4ain]

system: raspberry pi 3B+ bookworm (32bits), BME280 connected thru I2C, signalK server 2.13.1, influxdb 1.8.10 , plugins signalk-barograph and signalk-barometer-trend running, no error messages in log.

barometer pressure data is written into influxdb, all data are visible in signalk data browser. also signalk barograph does show all data (barometric trend, predictions, current time, ...) EXCEPT for current barometric pressure and the graph of barometric pressure .

I am out of idea's where the problem might be. Any idea where to look ?

pressure records in database:

select value from "environment.outside.pressure"
name: environment.outside.pressure
time value

---

1736017198342000000 101303.00000000001
1736017203370000000 101296.00000000001
1736017208402000000 101302
1736017213431000000 101302
1736017218465000000 101298
1736017223493000000 101296.99999999999
1736017228517000000 101296.99999999999
1736017233546000000 101296.99999999999

[on4ain]

I have found an error message using the developer extentions in my browser, but I have no idea what this means:

Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at http://127.0.0.1:8086/query?q=select%20time,%20mean(value)%20as%20value%20from%20pressure%20where%20time%3Enow()-3h%20and%20environment=%27outside%27%20and%20id=%27205691510%27%20group%20by%20time(1m)&db=barograf. (Reason: CORS request did not succeed). Status code: (null). 30

[on4ain]

I've been investigating this further:

As you can see in my previous post, using the developper tools in the browser, I find this query that is sent to influxdb on the signalk server: in clear text it is:
select time, mean(value) as value from pressure where time>now()-3h and environment='outside' and id='205691510' group by time(1m)&db=barograf

But it returns an error as shown also in my previous post:
Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at http://127.0.0.1:8086/api/v2/query/api/v2/query?org=. (Reason: CORS request did not succeed). Status code: (null).

One of the reasons of this failing can be that the query is incorrect, so I tried to execute this query directlyn in the influxdb cli on the raspberry itself. And there it fails also !

a working version of this query is:
select time, mean(value) as value from "environment.outside.pressure" where time>now()-3h group by time(1m)

The errors in the original query are:
in my db, the measurement file is called "environment.outside.pressure", and there is no tag called 'environment'
also there is no tag 'id', but the mmsi nr is part of the tag 'context'

so there is clearly a mismatch between the query executed by the barograf plugin and the database design used by the influxdb-writer
plugin. the query uses 2 tags (id and environment) that do not exist.

[tkurki]

I see you are already debugging this with the plugin author at tkrofta/signalk-barograph-plugin#3 - I think it would be a good idea to concentrate all communications there.

The plugin is independent of the sk to influxdb plugin and not using the same way to store data in Influx, so they don't work. They could, but now they don't.