Differences

This shows you the differences between two versions of the page.

--- user:jan001:nig_first_steps [2020/06/26 16:03] – [Connecting all Services with influxdb (only setup shown)] jan001
+++ user:jan001:nig_first_steps [2021/08/24 17:35] (current) – external edit 127.0.0.1
@@ Line 29: / Line 29: @@
 All groups only have one admin user. Both for Node-RED and Grafana. When someone changes the password, please inform the other people in your group about it!
 </WRAP>
 === Connect node-red with influxdb ===
+  - Open the node-red URL provided in the email and log in with the provided username and password. You will now see an empty flow.
+  - We have to install some special nodes (nodes are the blocks you use for programming) for interacting with the influx database. Click on the burger-icon in the top right corner. You will find an option named "Manage palette", click it. In the palette, you can manage all plugins you currently have installed. You will now see all currently installed nodes/plugins.
+  - Click on "Install" in the top bar and search for "influxdb". You will find one named "node-red-contrib-influxdb". Click on the "Install"-button to install it.
+  - You can close the palette now. On the left side of your screen, you can find all nodes that are available to you. Scroll down until you find a node called "influxdb out". You can also search for it in the top left corner. When you found it just drag it somewhere into your flow.
+  - Now double click on the node you just dropped. Because you never used it you will have to connect to a new server. Just click on the little pen on the right side of "Server". Here you will have to type in all needed information. These are the same, nevermind the group you are in.
+    * Host: influxdb
+    * Port: 8086
+    * Database: db
+    * Username: db
+    * Password: db
+    * do **not** enable SSL
+    * Name: makeup something nice
+  - Click on save. The database is now saved in node-red and you can use it on every influxdb-node you want to. If you want to, you can delete the node we just created.
+<WRAP center round important 60%>
+The influxdb is only accessible by nodered and grafana. Don't mind the weak password and username.
+</WRAP>
 === Connect grafana with influxdb ===
+  - Open the grafana URL provided in the email and log in with the provided username and password. You will have to change your password on the first login.
+  - We just need to add the influxdb as a data source. Find the gear icon on the left side and while hovering over it select "Data Sources".
+  - Click "Add Data Source". In the first part under "Time series databases" you will then find "influxDB". Select it.
+  - You will just have to change a few things. Copy all the values provided here:
+    * HTTP
+      * URL: influxdb:8086
+    * InfluxDB Details
+      * Database: db
+      * User: db
+      * Password: db
+    * All other values can be left as default
+  - Click "Save & Test". You will see a message "Data source is working". You successfully added the influxdb.
 ==== Sample project ====
+For the sample project, we will just let nodered put some values into the influxdb and read them afterward inside of grafana. Make sure you have done the steps under "Connecting all Services with influxdb"!
+  - Node-RED Part:
+    - Open up your nodered
+    - Drag an "inject"-node into your flow.
+    - Edit it with a double-click. As a payload, we just want a number. Type in a number you want. The topic is a value that we will be sent with the value you have chosen. The nodes communicate under each other with message objects as JSON-Objects. The payload is the raw data you want to work with. The topic is just another value inside this JSON-Object. My topic is just named "testing". We also want that the value gets injected like every 5 seconds. Just for testing of course. The name property you also see is the name you can see inside the flow.
+    - Now we only need a node that sends the value to the influxdb. Drag and drop the "influxdb out"-Node into your flow. Choose your influxdb-server and name the measurement also testing. Under this name, you will later find it inside of the database. Click on Done and connect the two nodes with each other. This is your first flow.
+    - The last click on deploy in the top right corner and the node-red server is already injecting something into your database.
+  - Grafana-Part:
+    - Open up your grafana
+    - Create a new dashboard by hovering over the "plus"-icon on the left side of the screen and click "Dashboard"
+    -  Click "Add new panel". Panels are generally graphs you want to display in one dashboard. One dashboard consists of many panels.
+    - What you will see now can be a bit overwhelming at first but we will just do a little dip into it right now. To display data in our graph we have to query it from our influxdb. We will just need one query for this sample project.
+    - We just need to change one thing right now. Under query, you will find a row named "FROM". We want to show the measurement from our database from the table named testing. So click on "select measurement". There should be a drop-down where you can select from all currently existing measurements. Choose "testing".
+    - On the right side of the screen, you can change the panel title if you want. Otherwise, click on Apply in the top right corner.
+    - You now need to save the dashboard you just created. In the top right corner, you will fond a save icon. Give it some appropriate name and click "Save".
+  - You just finished the sample! You can now see the dashboard on the grafana home screen. You can click the name to display it.