This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Save the data detected by the openplotter to avoid losing it at every reboot
#1
I'm looking for ways to save the data detected by openplotters to avoid losing them at every reboot.
Looking for other experiences I did these tests:

1 - Attempt to use influxDB with ui_chart of Node-RED
install InfluxDB from official repository by following this guide: https://www.vincenzov.net/taccuino/Raspb...rafana.htm
I can write the database but I can not read the data with node-red ui_chart

2 - Attempt with dashDB It does not install on openplotters
I followed this guide with code example:
https://internet-of-things.blog/en/how-t...dashboard/

3 - Attempt with influx + grafena (As done by PaddyB http://forum.openmarine.net/showthread.php?tid=1420)
grafena does not start, I think for the conflict of the door (it uses 3000 equal to signalK) and I could not change it.
(I followed these instructions: https://stackoverflow.com/questions/2830...afana-port)

4 -? Someone talks about the possibility of using MQTT data but I do not know if it can be as efficient as a database and I do not know how to do it.
I ask if the developers of Openplotter think to support in the future a system to save data in order to experiment in the same direction.

Or I ask if others have experiences and can report practical examples of code.

Thank Smile
Reply
#2
(2018-09-09, 07:12 AM)kste Wrote: 3 - Attempt with influx + grafena (As done by PaddyB http://forum.openmarine.net/showthread.php?tid=1420)
grafena does not start, I think for the conflict of the door (it uses 3000 equal to signalK) and I could not change it.
(I followed these instructions: https://stackoverflow.com/questions/2830...afana-port)

grafana change port /etc/grafana/grafana.ini

'
#################################### Server ####################################
[server]
# Protocol (http, https, socket)
;protocol = http

# The ip address to bind to, empty will bind to all interfaces
;http_addr =

# The http port  to use
http_port = 3001
'
Reply
#3
Thank you e-sailing,
However, I was more attracted to the idea of continuing to read the graphs with ui_chart (solution 1), if I use grafana I will have some data in the dashboard of Node RED and others in the grafana interface.
Reply
#4
Signal K server’s InfluxDb plugin can write all your data to InfluxDb (or you can pick the items that you want to write), no Node-Red flows needed.

I personally really like Grafana with its responsive layout and flexible time selection.


Sent from my iPhone using Tapatalk
Reply
#5
I set the port but grafana does not start. Syslog says:
Sep 11 20:03:16 berry1 grafana-server[393]: Inconsistency detected by ld.so: dl-lookup.c: 971: _dl_setup_hash: Assertion `(bitmask_nwords & (bitmask_nwords - 1)) == 0' failed!
Reply
#6
I try to follow my path, summary:
1 - I can write the battery volt on influxdb
2 - I can read the data from influxdb
3 - I am not able to write a function to pass data in the format that ui_chart likes.
Huh
Can someone help me?
Reply
#7
You could use chronograf to view the data in influxdb, much more flexible than node red grqphs.

https://www.influxdata.com/time-series-p...hronograf/

Sent from my SM-T813 using Tapatalk
Reply
#8
(2018-09-13, 04:20 PM)PaddyB Wrote: You could use chronograf to view the data in influxdb, much more flexible than node red grqphs.

https://www.influxdata.com/time-series-p...hronograf/

Sent from my SM-T813 using Tapatalk

Yes, thanks, I have already installed Chronograf but it seems to me more a tool of control and administration.

I have already created a dashboard with node-red quite complete and I would like to keep it and continue to improve it, but eliminating the loss of data history in case I have to restart openplotter.

I can create static data to be passed to ui_chart but I do not have the skills to format an array coming from a query.
Reply
#9
(2018-09-13, 06:19 PM)kste Wrote: Yes, thanks, I have already installed Chronograf but it seems to me more a tool of control and administration.

Chronograf is actually very powerful for potting data, create dashboards with live data or plots, handy feature is plotting data from say a day before over current. Zoom is good, enter various default times or enter your own dates/times.

[Image: psg8k6W.jpg]

Sent from my SM-T813 using Tapatalk
Reply
#10
(2018-09-13, 06:27 PM)PaddyB Wrote: Chronograf is actually very powerful for potting data, create dashboards with live data or plots, handy feature is plotting data from say a day before over current. Zoom is good, enter various default times or enter your own dates/times.

Shy
Great, you made me discover the dashboard of chronogrf, really interesting to be able to quickly create graphs and store them.

However, my interest in resolving the visualization on the node-red graph remains...
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)