mshulman
mshulman
PostsComments
SKSignal K
Created by LinnJS on 4/5/2024 in #questions
Help setting up influxdb2 with signalk
This is strange. The signalk plugin started showing unauthorized errors. I went to the influxdb web page and it took me through first time setup. I created a new organization and user and API key, and created a new grafana connection. Strange that the server reset itself, somehow?
10 replies
SKSignal K
Created by LinnJS on 4/5/2024 in #questions
Help setting up influxdb2 with signalk
summary: Flux is better than InfluxSQL because I can see all of my data, but there's no point-and-click query builder in Grafana, but there is one in InfluxDB Data Explorer. Then I used Gemini to modify the Flux query to convert from Meters to Feet, and ended up with this: 
from(bucket: "abientot")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "environment.depth.belowTransducer")
  |> filter(fn: (r) => r["_field"] == "value")
  |> aggregateWindow(every: 15s, fn: mean, createEmpty: false)
  |> map(fn: (r) => ({r with _value: r._value * 3.28084}))  // Conversion
  |> yield(name: "mean")
from(bucket: "abientot")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "environment.depth.belowTransducer")
  |> filter(fn: (r) => r["_field"] == "value")
  |> aggregateWindow(every: 15s, fn: mean, createEmpty: false)
  |> map(fn: (r) => ({r with _value: r._value * 3.28084}))  // Conversion
  |> yield(name: "mean")
10 replies
SKSignal K
Created by LinnJS on 4/5/2024 in #questions
Help setting up influxdb2 with signalk
Ok. So I changed my Grafana dashboard from the InfluxSQL version the Flux version, and now it's working. But I don't get the nice query builder, so I used this query instead. (This query came from the Influx Data Explorer): from(bucket: "abientot") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "environment.depth.belowTransducer") |> filter(fn: (r) => r["_field"] == "value") |> aggregateWindow(every: 15s, fn: mean, createEmpty: false) |> yield(name: "mean")
10 replies
SKSignal K
Created by LinnJS on 4/5/2024 in #questions
Help setting up influxdb2 with signalk
welp, this is odd. In the influx explorer, I can see all the data. But in grafana, I can only see data up to the upgrade.
10 replies
SKSignal K
Created by LinnJS on 4/5/2024 in #questions
Help setting up influxdb2 with signalk
In grafana, if I look for "last 5 minutes", I get 'no data'. I've tried both "default" and "autogen"
10 replies
SKSignal K
Created by LinnJS on 4/5/2024 in #questions
Help setting up influxdb2 with signalk
Do I have to do something to tell the signalk-to-influxdb2 plugin to write data?
10 replies
SKSignal K
Created by LinnJS on 4/5/2024 in #questions
Help setting up influxdb2 with signalk
When I restart, I see this in the SignalK log, but no indication that it's actually writing data back out: Jul 22 17:27:23 2024-07-23T00:27:23.967Z signalk-to-influxdb2 getDailyLogData Jul 22 17:27:23 2024-07-23T00:27:23.970Z signalk-to-influxdb2 select first(lat) as lat, first(lon) as lon from "navigation.position" where "context" = 'vessels.urn:mrn:signalk:uuid:ee0c6d7c-a873-4794-ba66-1a54ffbb80a7' and time >= '2024-07-22T00:00:00Z' and time <= '2024-07-22T17:27:23.968Z' group by time(60000ms) Jul 22 17:27:24 signalk-server running at 0.0.0.0:[object Object] Jul 22 17:27:24 2024-07-23T00:27:24.120Z signalk-to-influxdb2 0
10 replies
SKSignal K
Created by LinnJS on 4/5/2024 in #questions
Help setting up influxdb2 with signalk
I had an influx 1.8 db that was working, and I upgraded it to 2.7. I also upgraded the signalk plugin, including the API key. When the plugin runs, it successfully executes this SELECT statement with no errors, but it never writes the location or other data to the database. My grafana database visualizatioin stop at the time I did the upgrade. 2024-07-23T00:24:27.707034Z info Executing query {"log_id": "0qZDg6FG000", "service": "query", "query": "SELECT first(lat) AS lat, first(lon) AS lon FROM abientot.autogen."navigation.position" WHERE context = 'vessels.urn:mrn:signalk:uuid:ee0c6d7c-a873-4794-ba66-1a54ffbb80a7' AND time >= '2024-07-22T00:00:00Z' AND time <= '2024-07-22T17:24:27.694Z' GROUP BY time(1m)"}
10 replies
SKSignal K
Created by mshulman on 6/3/2024 in #sensors
mshulman - Does anyone have a CAN to USB device...
Are you saying that Intel micro PC with Ubuntu won't run signalK, or that the CAN to USB adapter won't work?
9 replies
SKSignal K
Created by mshulman on 6/3/2024 in #sensors
mshulman - Does anyone have a CAN to USB device...
I am using an Intel micro PC running Ubuntu
9 replies
SKSignal K
Created by mshulman on 6/3/2024 in #sensors
mshulman - Does anyone have a CAN to USB device...
https://www.amazon.com/dp/B0CFVP3PBJ?psc=1&ref=ppx_yo2ov_dt_b_product_details
9 replies
SKSignal K
Created by Raffaele Montella on 4/7/2024 in #questions
Subscription to server status
@Raffaele Montella what features does your QT6 browser offer? I don't see a list of features in your repo's readme.
5 replies
SKSignal K
Created by mshulman on 3/7/2024 in #wilhelmsk
mshulman - @Scott Bender hi Scott, I'm having t...
Friendly ping?
2 replies
SKSignal K
Created by mshulman on 3/7/2024 in #wilhelmsk
mshulman - @Scott Bender hi Scott, I'm having t...
Scott?
2 replies
SKSignal K
Created by mshulman on 3/9/2024 in #questions
How important is galvanic isolation?
Thank you all! I think I'm going to get a NMEA-to-ethernet gateway, like the Yacht Devices, and use cabled ethernet to my ship's wifi, and then a small computer and power it from 12V with a buck converter, maybe like this: https://www.amazon.com/CyberGeek-A1-Desktop-Computer-3-4GHz/dp/B0CNZJ6C2P/ref=sr_1_2_sspa I'd hate to bring down my autopilot.
16 replies