{"id":4699,"date":"2023-03-17T17:36:49","date_gmt":"2023-03-17T17:36:49","guid":{"rendered":"https:\/\/open-boat-projects.org\/?page_id=4699"},"modified":"2024-05-17T15:18:16","modified_gmt":"2024-05-17T15:18:16","slug":"datenintegration-in-grafana","status":"publish","type":"page","link":"https:\/\/open-boat-projects.org\/en\/datenintegration-in-grafana\/","title":{"rendered":"Data integration in Grafana"},"content":{"rendered":"<p>To display sensor data of the <a href=\"https:\/\/open-boat-projects.org\/en\/lora-bootsmonitor\/\">LoRa boat monitors<\/a> Several services are required in Grafana running in a Docker environment. LoRa boat monitor data located at TTN V3 is webhook to Telegraf service. Telegraf decrypts the received JSON information and stores the sensor data in an Influx-DB database. Grafana has access to this database and can display the sensor data via predefined pages.<\/p>\n<p>The flow of configuration for data integration in Grafana looks like this:<\/p>\n<ul>\n<li>Set up webhook for Telegraf at TTN V3<\/li>\n<li>Checking the webhook functionality<\/li>\n<li>Representation of the sensor data in Grafana<\/li>\n<\/ul>\n<h2>Set up webhook at TTN V3<\/h2>\n<p>At this point the webhook for Telegraf at TTN V3 is set up. The webhook forwards the incoming data from the boat monitor at TTN V3 directly to the telegraph service every time.<\/p>\n<p>Next, we switch to TTN V3 and log into the console there:<\/p>\n<p><a href=\"https:\/\/eu1.cloud.thethings.network\/console\/\" target=\"_blank\" rel=\"noopener\">https:\/\/eu1.cloud.thethings.network\/console\/<\/a><\/p>\n<p>Then we pass <strong>Applications<\/strong> to our created application <strong>LoRa Boat Monitoring<\/strong> and click in the left selection area<strong> integrations<\/strong> on.<\/p>\n<p><a href=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3793 size-medium\" src=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_1-300x178.png\" alt=\"\" width=\"300\" height=\"178\" srcset=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_1-300x178.png 300w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_1-1024x607.png 1024w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_1-768x455.png 768w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_1-18x12.png 18w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_1.png 1487w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Fig.: Integrations<\/p>\n<p>If we click left in the selection area <strong>webhook<\/strong> Clicking takes us to a page where we can create a new webhook with the right blue button <strong>Add Webhook<\/strong> can create.<\/p>\n<p><a href=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3794 size-medium\" src=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_2-300x169.png\" alt=\"\" width=\"300\" height=\"169\" srcset=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_2-300x169.png 300w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_2-1024x578.png 1024w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_2-768x433.png 768w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_2-18x10.png 18w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_2.png 1505w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Fig.: Create webhook<\/p>\n<p>On the page that opens, we choose at the top <strong>Custom webhook<\/strong> and then enter the following data in the configuration page:<\/p>\n<p><a href=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3804 size-medium\" src=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_3-300x172.png\" alt=\"\" width=\"300\" height=\"172\" srcset=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_3-300x172.png 300w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_3-1024x587.png 1024w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_3-768x440.png 768w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_3-18x10.png 18w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Webhook_3.png 1498w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Fig.: Configure webhook<\/p>\n<p>For the <strong>Webhook ID<\/strong> we assign a meaningful name, such as <em><strong>telegraph<\/strong><\/em>. Pay attention to lower case and only use hyphens. As <strong>BaseURL<\/strong> use<em><strong>: http:\/\/norbert-walter.dnshome.de:8080 <\/strong><\/em>The <strong>webhook format<\/strong> must up <em><strong>JSON<\/strong><\/em> stand. Under <strong>Enabled event types <\/strong>got to <strong>Uplink message<\/strong> be activated and <em><strong>\/telegraph<\/strong><\/em> be entered. All other fields remain empty.<\/p>\n<p>Finally, the data entered is saved using the button <strong>Add webhook<\/strong> saved. In the end everything should look like this. the webhook is now set up.<\/p>\n<p><a href=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Webhook_Telegraf.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4703 size-medium\" src=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Webhook_Telegraf-300x216.png\" alt=\"\" width=\"300\" height=\"216\" srcset=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Webhook_Telegraf-300x216.png 300w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Webhook_Telegraf-1024x738.png 1024w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Webhook_Telegraf-768x553.png 768w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Webhook_Telegraf-18x12.png 18w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Webhook_Telegraf.png 1058w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Fig.: Completed webhook<\/p>\n<h2>Checking the webhook functionality<\/h2>\n<p>As soon as data from the LoRa boat monitor arrives at TTN V3, this data should appear on the page <strong>End Devices <\/strong>be visible under the respective device. Under <strong>live data<\/strong> the incoming telegrams are listed.<\/p>\n<p><a href=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Device_Live_Data.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3809 size-medium\" src=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Device_Live_Data-300x154.png\" alt=\"\" width=\"300\" height=\"154\" srcset=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Device_Live_Data-300x154.png 300w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Device_Live_Data-1024x524.png 1024w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Device_Live_Data-768x393.png 768w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Device_Live_Data-18x9.png 18w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/11\/Device_Live_Data.png 1480w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Fig.: Device Live Data (currently without data)<\/p>\n<p>When data arrives from the LoRa boot monitor, then the status of the webhook for Telegraf should be from <em><strong>pending<\/strong><\/em> on <em><strong>Healthy<\/strong><\/em> switch and be marked with a blue dot.<\/p>\n<p><a href=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Webhook_Status.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4705 size-medium\" src=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Webhook_Status-300x133.png\" alt=\"\" width=\"300\" height=\"133\" srcset=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Webhook_Status-300x133.png 300w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Webhook_Status-1024x456.png 1024w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Webhook_Status-768x342.png 768w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Webhook_Status-18x8.png 18w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Webhook_Status.png 1225w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Fig: Webhook Status<\/p>\n<p>This completes the configuration of the webhook.<\/p>\n<h2>Representation of the sensor data in Grafana<\/h2>\n<p>Grafana is a web-based universal tool for displaying data from various data sources. <strong>Open Boat Projects<\/strong> provides server services with which Grafana can be used free of charge and without data limits. Anyone who has their data forwarded to the Open Boat Projects servers via the webhook can use this service. The data retention period is one year. Older data is automatically deleted. Only you can access your data via the unique device EUI. Grafana allows you to create dashboards with different display elements. Grafana is a powerful tool and offers a huge library of predefined display elements. A separate component library was created for the LoRa boat monitor, creating a finished dashboard that users can use.<\/p>\n<h3>Log in<\/h3>\n<p>The Grafana page is accessed at: <a href=\"https:\/\/norbert-walter.dnshome.de\/\" target=\"_blank\" rel=\"noopener\">https:\/\/norbert-walter.dnshome.de\/<\/a><\/p>\n<p>Guest access has been set up for users, which does not require any special prior registration. As soon as the webhook is functional and sends data to Telegram, the sensor data is written to the InfluxDB database and can be displayed by Grafana. No further configuration in Grafana is necessary. Sign in with the following data:<\/p>\n<p><strong>Username: guest<\/strong><\/p>\n<p><strong>Password: loragast<\/strong><\/p>\n<p>You will then go directly to the dashboard with the data display.<\/p>\n<p><a href=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Grafana_Dashboard.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4709\" src=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Grafana_Dashboard-300x189.png\" alt=\"\" width=\"500\" height=\"315\" srcset=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Grafana_Dashboard-300x189.png 300w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Grafana_Dashboard-1024x645.png 1024w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Grafana_Dashboard-768x484.png 768w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Grafana_Dashboard-18x12.png 18w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Grafana_Dashboard.png 1230w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p>Fig.: Grafana dashboard for the LoRa boat monitor<\/p>\n<p>In order to see the data of your LoRa boat monitor, you have to go to the upper left under <strong>Device_EUI<\/strong> enter the Device EUI of your device. This information can be found at TTN V3 <strong>End devices<\/strong> in the <strong>Applications<\/strong>.<\/p>\n<p><a href=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Device_EUI.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4706 size-medium\" src=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Device_EUI-300x179.png\" alt=\"\" width=\"300\" height=\"179\" srcset=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Device_EUI-300x179.png 300w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Device_EUI-1024x611.png 1024w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Device_EUI-768x458.png 768w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Device_EUI-18x12.png 18w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Device_EUI.png 1228w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Fig. Device EUI<\/p>\n<p>If you don&#039;t want to enter the device EUI every time, create a bookmark in your web browser that is structured as follows. Change the Device EUI to your value. So you always have easy access to your data from the LoRa boat monitor.<\/p>\n<p><strong>https:\/\/norbert-walter.dnshome.de\/d\/vZPaGIK4z\/boat-monitoring?orgId=8&amp;refresh=30s&amp;var-Device_EUI=<span style=\"color: #ff0000;\">eu-0123456789012345<\/span>&amp;from=now-6h&amp;to=now<\/strong><\/p>\n<h3>demo system<\/h3>\n<p>To get an overview of the functionality offered by Grafana, you can do this <a href=\"https:\/\/norbert-walter.dnshome.de\/d\/vZPaGIK4z\/boat-monitoring?orgId=8&amp;refresh=30s&amp;var-Device_EUI=eui-00bfce253ab09ff3&amp;from=now-6h&amp;to=now&amp;kiosk\" target=\"_blank\" rel=\"noopener\">Demo system with live data<\/a> of a LoRa boat monitor. You can register with the following data:<\/p>\n<p><strong>Username: guest<\/strong><\/p>\n<p><strong>Password: loragast<\/strong><\/p>\n<h3>presentation of the information<\/h3>\n<p>The Grafana dashboard is divided into different areas. The following information can be called up in this way:<\/p>\n<ul>\n<li>quick overview<\/li>\n<li>battery information<\/li>\n<li>environmental data<\/li>\n<li>tank levels<\/li>\n<li>States of the alarm input and the relay<\/li>\n<li>position data<\/li>\n<li>Live camera image from a web camera<\/li>\n<li>Information on LoRa data transmission<\/li>\n<\/ul>\n<p>In addition to numerical values, diagrams with time progressions can also be displayed.<\/p>\n<p><a href=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Batterie_Data.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4721\" src=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Batterie_Data-300x191.png\" alt=\"\" width=\"500\" height=\"318\" srcset=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Batterie_Data-300x191.png 300w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Batterie_Data-1024x652.png 1024w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Batterie_Data-768x489.png 768w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Batterie_Data-18x12.png 18w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Batterie_Data.png 1232w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p>Fig.: Battery information<\/p>\n<p>Location coordinates can be displayed on a map and the course of a route can be displayed historically over different periods of time.<\/p>\n<p><a href=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Position.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4720\" src=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Position-300x188.png\" alt=\"\" width=\"500\" height=\"313\" srcset=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Position-300x188.png 300w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Position-1024x640.png 1024w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Position-768x480.png 768w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Position-18x12.png 18w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Position.png 1235w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p>Fig.: Position data<\/p>\n<p>It is also possible to watch the boat via a web camera if you have access to an internet-enabled camera. In order for this to work, the video stream must be available unencrypted on the Internet via a URL.<\/p>\n<p><a href=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Camera_Video_Stream.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4724\" src=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Camera_Video_Stream-300x189.png\" alt=\"\" width=\"500\" height=\"315\" srcset=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Camera_Video_Stream-300x189.png 300w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Camera_Video_Stream-1024x645.png 1024w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Camera_Video_Stream-768x484.png 768w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Camera_Video_Stream-18x12.png 18w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Camera_Video_Stream.png 1231w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p>Fig. Live video stream<\/p>\n<p>Information on the quality of the LoRa data transmission is also recorded. This can be used to localize some communication problems. The <strong>R<\/strong>received <strong>S<\/strong>signal <strong>S<\/strong>strength <strong>I<\/strong>ndicator (RSSI) is an indicator for the reception field strength of wireless communication applications. The S<span class=\"ILfuVd\" lang=\"de\"><span class=\"hgKElc\">NR is that <b>signal to noise ratio<\/b> (English: signal to noise ratio) and indicates the strength of the signal relative to the background noise.<\/span><\/span><\/p>\n<p><a href=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/LoRa_Data.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4719\" src=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/LoRa_Data-300x189.png\" alt=\"\" width=\"500\" height=\"315\" srcset=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/LoRa_Data-300x189.png 300w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/LoRa_Data-1024x646.png 1024w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/LoRa_Data-768x484.png 768w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/LoRa_Data-18x12.png 18w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/LoRa_Data.png 1234w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p>Fig.: Information on LoRa data transmission<\/p>\n<p>In the upper area you will find controls on the right with which you can change the time base and the update rates.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4722 size-full\" src=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Grafana_Update_Settings.png\" alt=\"\" width=\"488\" height=\"53\" srcset=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Grafana_Update_Settings.png 488w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Grafana_Update_Settings-300x33.png 300w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Grafana_Update_Settings-18x2.png 18w\" sizes=\"auto, (max-width: 488px) 100vw, 488px\" \/><\/p>\n<p>Fig. Controls<\/p>\n<h3>share information with others<\/h3>\n<p>If you wish, you can share all of the information on Grafana with other people. Then use the link below and customize yours <strong>Device EUI<\/strong> accordingly.<\/p>\n<p><strong>https:\/\/norbert-walter.dnshome.de\/d\/vZPaGIK4z\/boat-monitoring?orgId=8&amp;refresh=30s&amp;var-Device_EUI=<span style=\"color: #ff0000;\">eu-0123456789012345<\/span>&amp;from=now-6h&amp;to=now&amp;kiosk<\/strong><\/p>\n<p>On the other hand, if you only want to share your current position on a map with others, use this link:<\/p>\n<p><strong>https:\/\/norbert-walter.dnshome.de\/d\/vZPaGIK4z\/boat-monitoring?orgId=8&amp;refresh=30s&amp;var-Device_EUI=<span style=\"color: #ff0000;\">eu-0123456789012345<\/span>&amp;from=now-6h&amp;to=now&amp;viewPanel=81&amp;kiosk<\/strong><\/p>\n<p>The location history for the last 6 hours is displayed. Then send the links to your friends via email or messenger service. Please note, however, that the link is permanently valid and can be used without a time limit.<\/p>\n<p><a href=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Geo-Position.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4729\" src=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Geo-Position-300x181.png\" alt=\"\" width=\"500\" height=\"302\" srcset=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Geo-Position-300x181.png 300w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Geo-Position-1024x619.png 1024w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Geo-Position-768x465.png 768w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Geo-Position-18x12.png 18w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/Geo-Position.png 1230w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p>Fig.: Sharing a position with others<\/p>\n<h3>Change pages yourself and set up notifications<\/h3>\n<p>If you prefer an individual design of the Grafana pages with notifications in the event of limit violations, you can contact us via the <a href=\"https:\/\/open-boat-projects.org\/en\/kontakt\/\">contact form<\/a> notify. We will then set up your own area in Grafana in which you have write access and can create your own pages.<\/p>\n<h3>donations<\/h3>\n<p>The provision of server services is free for users. However, the operation is associated with costs. These mainly include the hardware acquisition costs and ongoing electricity and internet costs for the server. The server services are currently installed on a Dell micro PC in a Docker environment under TrueNAS Scale. The server is based in Germany and is permanently connected to the Internet via DSL access. There is currently no backup strategy for data in the event of a power failure or disruption. Therefore, back up the data at regular intervals. In the case of higher usage, we want to move the server services directly to the Internet to a provider in the future and also set up a sensible backup solution. <span style=\"color: #ff0000;\">Please note that we cannot assume any liability for your data or any damage caused by unusability.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2741\" src=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/01\/Dell_Optiplex_7050-300x211.jpg\" alt=\"\" width=\"300\" height=\"211\" srcset=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/01\/Dell_Optiplex_7050-300x211.jpg 300w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/01\/Dell_Optiplex_7050-1024x721.jpg 1024w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/01\/Dell_Optiplex_7050-768x541.jpg 768w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/01\/Dell_Optiplex_7050-18x12.jpg 18w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2022\/01\/Dell_Optiplex_7050.jpg 1118w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>Fig. Dell Optiplex 7040 i5-6600T 2.7G Hz, 16 GB RAM, 128 GB SSD, 4x USB3.1, 2x HDMI, WiFi, 15W<\/p>\n<p><a href=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/TrueNAS_Scale.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4743 size-medium\" src=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/TrueNAS_Scale-300x159.png\" alt=\"\" width=\"300\" height=\"159\" srcset=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/TrueNAS_Scale-300x159.png 300w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/TrueNAS_Scale-1024x544.png 1024w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/TrueNAS_Scale-768x408.png 768w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/TrueNAS_Scale-18x10.png 18w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2023\/03\/TrueNAS_Scale.png 1537w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Fig.: TrueNAS Scale<\/p>\n<p><em><strong>If you use the service regularly and find it useful, we would appreciate a regular small donation. This enables us to make the service permanently available to the general public.<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.paypal.com\/cgi-bin\/webscr?cmd=_s-xclick&amp;hosted_button_id=5QZJZBM252F2L\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1730 size-full\" src=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2021\/08\/Donate.gif\" alt=\"\" width=\"92\" height=\"47\" srcset=\"https:\/\/open-boat-projects.org\/wp-content\/uploads\/2021\/08\/Donate.gif 92w, https:\/\/open-boat-projects.org\/wp-content\/uploads\/2021\/08\/Donate-18x9.gif 18w\" sizes=\"auto, (max-width: 92px) 100vw, 92px\" \/><\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>To display sensor data from the LoRa boat monitor in Grafana, several services running in a Docker environment are required. The LoRa boat monitor data located at TTN V3 is transmitted to the Telegraf service via webhook. Telegraf decrypts the received JSON information and stores the sensor data in an Influx-DB database. Grafana has access to this database and\u2026 <a href=\"https:\/\/open-boat-projects.org\/en\/datenintegration-in-grafana\/\" class=\"more-link\">Read more <span class=\"screen-reader-text\">Data integration in Grafana<\/span><\/a><\/p>","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[41,37],"tags":[],"class_list":["post-4699","page","type-page","status-publish","hentry","category-opendata","category-projects"],"_links":{"self":[{"href":"https:\/\/open-boat-projects.org\/en\/wp-json\/wp\/v2\/pages\/4699","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/open-boat-projects.org\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/open-boat-projects.org\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/open-boat-projects.org\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/open-boat-projects.org\/en\/wp-json\/wp\/v2\/comments?post=4699"}],"version-history":[{"count":34,"href":"https:\/\/open-boat-projects.org\/en\/wp-json\/wp\/v2\/pages\/4699\/revisions"}],"predecessor-version":[{"id":5415,"href":"https:\/\/open-boat-projects.org\/en\/wp-json\/wp\/v2\/pages\/4699\/revisions\/5415"}],"wp:attachment":[{"href":"https:\/\/open-boat-projects.org\/en\/wp-json\/wp\/v2\/media?parent=4699"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/open-boat-projects.org\/en\/wp-json\/wp\/v2\/categories?post=4699"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/open-boat-projects.org\/en\/wp-json\/wp\/v2\/tags?post=4699"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}