# General

**URL:** https://discourse.nodered.org/c/general/7.md?page=485

[Latest](https://discourse.nodered.org/latest.md) · [Categories](https://discourse.nodered.org/categories.md) · [Tags](https://discourse.nodered.org/tags.md)

**Page:** 486

---

## [How to create secure certificates using Let's Encrypt & How to use them](https://discourse.nodered.org/t/how-to-create-secure-certificates-using-lets-encrypt-how-to-use-them/4309)

<div class="topic-metadata">

**Author:** [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Replies:** 0\
**Last updated:** [26 October 2018 08:30 UTC](https://discourse.nodered.org/t/how-to-create-secure-certificates-using-lets-encrypt-how-to-use-them/4309 "2018-10-26T08:30:57Z")

</div>

Hi all, if you've followed any of the security threads recently, you may have seen that I was trying to get a new blog post finised - well it isn't really finished but as there are many questions at the moment, I thought…

---

## [Problem with video feed](https://discourse.nodered.org/t/problem-with-video-feed/51230)

<div class="topic-metadata">

**Author:** [@Lupin\_III](https://discourse.nodered.org/u/Lupin_III)\
**Replies:** 14\
**Last updated:** [8 October 2021 23:40 UTC](https://discourse.nodered.org/t/problem-with-video-feed/51230 "2021-10-08T23:40:03Z")

</div>

Hi to all, thanks again for the great job you're doing and for sharing it. Using the ffmpeg-spawn node I even need to have a base64 string. I tryed to convert the output with the relative base64 node, but it's not recog…

---

## [Weather temperature feed to hue bulb colour](https://discourse.nodered.org/t/weather-temperature-feed-to-hue-bulb-colour/52023)

<div class="topic-metadata">

**Author:** [@Richard238](https://discourse.nodered.org/u/Richard238)\
**Replies:** 1\
**Last updated:** [8 October 2021 20:46 UTC](https://discourse.nodered.org/t/weather-temperature-feed-to-hue-bulb-colour/52023 "2021-10-08T20:46:01Z")

</div>

I have open weather map showing a temperature gauge on my dashboard, brilliant! How do I get a hue bulb to respond to the temperature figure deg C., and change colour accordingly? Thank you.

---

## [Websocket problems when IP changes](https://discourse.nodered.org/t/websocket-problems-when-ip-changes/51746)

<div class="topic-metadata">

**Author:** [@rucksman007](https://discourse.nodered.org/u/rucksman007)\
**Replies:** 1\
**Last updated:** [8 October 2021 16:53 UTC](https://discourse.nodered.org/t/websocket-problems-when-ip-changes/51746 "2021-10-08T16:53:51Z")

</div>

I am struggling with the websocket node. I am running a self hosted instance of Gotify server (comparable to Pushover, but selfhosted; https://gotify.net/) in a Docker container. To reveice incoming messages via the Goti…

---

## [Are Hue Wall Switch modules supported?](https://discourse.nodered.org/t/are-hue-wall-switch-modules-supported/51880)

<div class="topic-metadata">

**Author:** [@iowahansen](https://discourse.nodered.org/u/iowahansen)\
**Replies:** 9\
**Last updated:** [8 October 2021 15:11 UTC](https://discourse.nodered.org/t/are-hue-wall-switch-modules-supported/51880 "2021-10-08T15:11:56Z")

</div>

Hello, I'm trying to configure a Philips Hue wall switch module in my dashboard, but I don't seem to be able to add them as "Hue Switch" in my dashboard as it does not appear in the device dropdown. Are they not suppor…

---

## [Raspberry diff IP number then router](https://discourse.nodered.org/t/raspberry-diff-ip-number-then-router/52016)

<div class="topic-metadata">

**Author:** [@Erik1](https://discourse.nodered.org/u/Erik1)\
**Replies:** 8\
**Last updated:** [8 October 2021 14:42 UTC](https://discourse.nodered.org/t/raspberry-diff-ip-number-then-router/52016 "2021-10-08T14:42:47Z")

</div>

raspberry diff pings a IP number then my router . I can login to my dasboard but not in the NOD I had a power cut inbetween. anyone an idea what to do ? im an Uber noob so help or just ignore me to death …

---

## [Communicating to BLE device and node-red](https://discourse.nodered.org/t/communicating-to-ble-device-and-node-red/51997)

<div class="topic-metadata">

**Author:** [@jasonlodder](https://discourse.nodered.org/u/jasonlodder)\
**Replies:** 2\
**Last updated:** [8 October 2021 11:10 UTC](https://discourse.nodered.org/t/communicating-to-ble-device-and-node-red/51997 "2021-10-08T11:10:39Z")

</div>

I have been using raspberry pi and node-red for a while now and was considering to use my raspberry pi zero w as a hotspot to communicate with my polar heart rate monitor to display the information. I have played a bit …

---

## [Maths stuff not working between machines](https://discourse.nodered.org/t/maths-stuff-not-working-between-machines/52009)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 5\
**Last updated:** [8 October 2021 09:19 UTC](https://discourse.nodered.org/t/maths-stuff-not-working-between-machines/52009 "2021-10-08T09:19:16Z")

</div>

This is weird. Forgetting previous stuff here is the problem I now am seeing/have. This code: counter = counter + 1; context.set("COUNTER",counter); node.warn("TOTAL is " + total); total = total + x; node.warn("TOTA…

---

## [Only the first 200](https://discourse.nodered.org/t/only-the-first-200/51953)

<div class="topic-metadata">

**Author:** [@madmax](https://discourse.nodered.org/u/madmax)\
**Replies:** 5\
**Last updated:** [8 October 2021 06:02 UTC](https://discourse.nodered.org/t/only-the-first-200/51953 "2021-10-08T06:02:51Z")

</div>

Hello! I have a CSV file with 20000 lines. Is there a possibility and that only the first 200 will be taken over?

---

## [Assistance with running local js script for MyQ](https://discourse.nodered.org/t/assistance-with-running-local-js-script-for-myq/51991)

<div class="topic-metadata">

**Author:** [@k5map](https://discourse.nodered.org/u/k5map)\
**Replies:** 1\
**Last updated:** [8 October 2021 02:27 UTC](https://discourse.nodered.org/t/assistance-with-running-local-js-script-for-myq/51991 "2021-10-08T02:27:17Z")

</div>

Because the current MyQ node is not working, I'm looking to switch to "Plan B" but would appreciate confirmation that my idea is viable. The idea is to install the hjdjd MyQ API (link) on the NR RPi, then use the EXEC n…

---

## [Create data in postgres](https://discourse.nodered.org/t/create-data-in-postgres/45063)

<div class="topic-metadata">

**Author:** [@grandautism](https://discourse.nodered.org/u/grandautism)\
**Replies:** 15\
**Last updated:** [8 October 2021 01:45 UTC](https://discourse.nodered.org/t/create-data-in-postgres/45063 "2021-10-08T01:45:28Z")

</div>

hello, I am using the node red for the first time, I try to stock data in postgresql. I currently need to find a solution, but nothing works, can you tell me what i do wrong ? function insert:

---

## [Exec node calling python running pulse audio getting 'connection refused](https://discourse.nodered.org/t/exec-node-calling-python-running-pulse-audio-getting-connection-refused/51174)

<div class="topic-metadata">

**Author:** [@Kanjo](https://discourse.nodered.org/u/Kanjo)\
**Replies:** 22\
**Last updated:** [7 October 2021 19:35 UTC](https://discourse.nodered.org/t/exec-node-calling-python-running-pulse-audio-getting-connection-refused/51174 "2021-10-07T19:35:19Z")

</div>

\[ADMIN: moved from another thread because it is a new issue\] Okay but after running the program and executing the python script, it gives me this new error saying this: What went wrong?

---

## [Accessing Inverter HID interface via NodeRed](https://discourse.nodered.org/t/accessing-inverter-hid-interface-via-nodered/51671)

<div class="topic-metadata">

**Author:** [@eddee54455](https://discourse.nodered.org/u/eddee54455)\
**Replies:** 6\
**Last updated:** [7 October 2021 17:25 UTC](https://discourse.nodered.org/t/accessing-inverter-hid-interface-via-nodered/51671 "2021-10-07T17:25:59Z")

</div>

Good day, Learned Fellows! I am busy doing the final touches to my inverter comms routines and have run into a snag.. Currently I access the unit via a USB-\>Serial adaptor, but wish to access it direct through its HID …

---

## [Error log system](https://discourse.nodered.org/t/error-log-system/51978)

<div class="topic-metadata">

**Author:** [@sefaguntepe](https://discourse.nodered.org/u/sefaguntepe)\
**Replies:** 0\
**Last updated:** [7 October 2021 16:54 UTC](https://discourse.nodered.org/t/error-log-system/51978 "2021-10-07T16:54:52Z")

</div>

Hello, I want to record the errors in a table or excel file on the "dashboard" as in the attachment. I have 15 "flows". sample:

---

## [Help for dealing with repetitive values](https://discourse.nodered.org/t/help-for-dealing-with-repetitive-values/51922)

<div class="topic-metadata">

**Author:** [@viixiv](https://discourse.nodered.org/u/viixiv)\
**Replies:** 4\
**Last updated:** [7 October 2021 16:40 UTC](https://discourse.nodered.org/t/help-for-dealing-with-repetitive-values/51922 "2021-10-07T16:40:09Z")

</div>

Hi all I hope if anyone can help me with this problem. I recently started to experiment with Node-red; however, my progress is currently limited by my lack of experience in JS. I currently have a sensor that outputs th…

---

## [Global variable for bearer token](https://discourse.nodered.org/t/global-variable-for-bearer-token/51943)

<div class="topic-metadata">

**Author:** [@humphrysr](https://discourse.nodered.org/u/humphrysr)\
**Replies:** 1\
**Last updated:** [7 October 2021 16:02 UTC](https://discourse.nodered.org/t/global-variable-for-bearer-token/51943 "2021-10-07T16:02:47Z")

</div>

Is there a global var that can be used to take a bearer token and used to populate the token value in the HTTP token value text box? Basically one token, and 4-5 HTTP request nodes. thank you

---

## [Editor Log-in/Log-out and questions regarding users](https://discourse.nodered.org/t/editor-log-in-log-out-and-questions-regarding-users/51920)

<div class="topic-metadata">

**Author:** [@tree-frog](https://discourse.nodered.org/u/tree-frog)\
**Replies:** 6\
**Last updated:** [7 October 2021 15:59 UTC](https://discourse.nodered.org/t/editor-log-in-log-out-and-questions-regarding-users/51920 "2021-10-07T15:59:59Z")

</div>

Dear Sirs: When Logging into Nod-RED editor, I noticed if I do not log out, and just close the browser, I'm still logged in. When I open up the URL again it was logged in still. Is there anything I can do to force t…

---

## [Failed to load resource: Unacceptable TLS certificate](https://discourse.nodered.org/t/failed-to-load-resource-unacceptable-tls-certificate/51947)

<div class="topic-metadata">

**Author:** [@serardica](https://discourse.nodered.org/u/serardica)\
**Replies:** 2\
**Last updated:** [7 October 2021 15:16 UTC](https://discourse.nodered.org/t/failed-to-load-resource-unacceptable-tls-certificate/51947 "2021-10-07T15:16:47Z")

</div>

I was trying to use the Node-RED editor into the Internal Web Browser of eclipse, everything was going well until I go to "Manage palette" to install a new node, when I get a "Failed to load node catalogue" message, i…

---

## [Cannot GET /zigbee2mqtt/showMap](https://discourse.nodered.org/t/cannot-get-zigbee2mqtt-showmap/51890)

<div class="topic-metadata">

**Author:** [@edje11](https://discourse.nodered.org/u/edje11)\
**Replies:** 15\
**Last updated:** [7 October 2021 14:15 UTC](https://discourse.nodered.org/t/cannot-get-zigbee2mqtt-showmap/51890 "2021-10-07T14:15:46Z")

</div>

I'm using node-red-contrib-zigbee2mqtt for my Zigbee devices, works all great. In the Zigbee bridge node there's a tab with the option to generate a map of my Zigbee network, this works also great. However on this tab …

---

## [Saving CSV Data](https://discourse.nodered.org/t/saving-csv-data/51888)

<div class="topic-metadata">

**Author:** [@skyover99](https://discourse.nodered.org/u/skyover99)\
**Replies:** 8\
**Last updated:** [7 October 2021 13:50 UTC](https://discourse.nodered.org/t/saving-csv-data/51888 "2021-10-07T13:50:53Z")

</div>

Hey, I think I only have a small problem. Nevertheless, I do not know what to do. I have made a flow wich create files to an ftp File and name them by some parts of the payload. The saving process works, but i can not o…

---

## [Naïve global.set question](https://discourse.nodered.org/t/naive-global-set-question/51970)

<div class="topic-metadata">

**Author:** [@tony1](https://discourse.nodered.org/u/tony1)\
**Replies:** 2\
**Last updated:** [7 October 2021 13:02 UTC](https://discourse.nodered.org/t/naive-global-set-question/51970 "2021-10-07T13:02:50Z")

</div>

I was wondering how to use global.set properly. It seems like changing the properties of an object brought in by global.get immediately propagates to the global object, without needing to global.set, because global.get p…

---

## [Need help for alarm notification via email](https://discourse.nodered.org/t/need-help-for-alarm-notification-via-email/51961)

<div class="topic-metadata">

**Author:** [@KrishnanRavichandran](https://discourse.nodered.org/u/KrishnanRavichandran)\
**Replies:** 2\
**Last updated:** [7 October 2021 12:43 UTC](https://discourse.nodered.org/t/need-help-for-alarm-notification-via-email/51961 "2021-10-07T12:43:25Z")

</div>

I read sensor data from a Hardware every second and plot it on the Dashboard. I am trying to set up an alarm notification when I do not receive inputs from my sensors for a period of time say 10 seconds. \[{"id":"6ee…

---

## [LoRaWAN Downlink Confirmed Data](https://discourse.nodered.org/t/lorawan-downlink-confirmed-data/51918)

<div class="topic-metadata">

**Author:** [@Ryoyo123](https://discourse.nodered.org/u/Ryoyo123)\
**Replies:** 3\
**Last updated:** [7 October 2021 12:09 UTC](https://discourse.nodered.org/t/lorawan-downlink-confirmed-data/51918 "2021-10-07T12:09:14Z")

</div>

I have a question about how to change the header of a LoRaWAN packet. The upper 3 bits of "MHDR" in the packet header indicate the message type. If bit # 7, 6, 5 is set to "101", it will be "Downlink Confirmed Data". I…

---

## [Buffer parser specyfication from msg](https://discourse.nodered.org/t/buffer-parser-specyfication-from-msg/51962)

<div class="topic-metadata">

**Author:** [@ketpa](https://discourse.nodered.org/u/ketpa)\
**Replies:** 1\
**Last updated:** [7 October 2021 11:06 UTC](https://discourse.nodered.org/t/buffer-parser-specyfication-from-msg/51962 "2021-10-07T11:06:12Z")

</div>

I try use buffer parser with specyfications from msg.settings Specyfications are the same, but values not \[{"id":"30016563.f4d772","type":"function","z":"15ff44a1.77852b","name":"","func":"var o={\\n options: {\\n …

---

## [Node-red crash after mistake in modbus server](https://discourse.nodered.org/t/node-red-crash-after-mistake-in-modbus-server/51950)

<div class="topic-metadata">

**Author:** [@pautorras](https://discourse.nodered.org/u/pautorras)\
**Replies:** 4\
**Last updated:** [7 October 2021 09:46 UTC](https://discourse.nodered.org/t/node-red-crash-after-mistake-in-modbus-server/51950 "2021-10-07T09:46:40Z")

</div>

Hi, yesterday in a test with modbus server, I lost connection with node-red server. Now I'm not able to make any change because node-red crash after a start. How can I solve it?

---

## [Payload to SQL query](https://discourse.nodered.org/t/payload-to-sql-query/51959)

<div class="topic-metadata">

**Author:** [@tombost](https://discourse.nodered.org/u/tombost)\
**Replies:** 2\
**Last updated:** [7 October 2021 09:40 UTC](https://discourse.nodered.org/t/payload-to-sql-query/51959 "2021-10-07T09:40:36Z")

</div>

Hello, I have a big payload with 400 data like this : How can I convert this payload to have a query like this: insert into data1 values ('DB1.DI0','1','ok'), ('DB1.DI4','2','ok'), ('DB1.DI8','3','ok'), ('DB1.DI12',…

---

## [Boolean true should equal string true (or better)](https://discourse.nodered.org/t/boolean-true-should-equal-string-true-or-better/12395)

<div class="topic-metadata">

**Author:** [@michaelblight](https://discourse.nodered.org/u/michaelblight)\
**Replies:** 8\
**Last updated:** [6 October 2021 21:25 UTC](https://discourse.nodered.org/t/boolean-true-should-equal-string-true-or-better/12395 "2021-10-06T21:25:22Z")

</div>

I sort of expect to be able to compare to true. So I code a switch node with "==" and look for a boolean type that I can set to true. I don't find one, so I reluctantly match with the string "true". My fairly complex flo…

---

## [Node-red-contrib-ui-svg create table by input message](https://discourse.nodered.org/t/node-red-contrib-ui-svg-create-table-by-input-message/51004)

<div class="topic-metadata">

**Author:** [@samuelbras](https://discourse.nodered.org/u/samuelbras)\
**Replies:** 10\
**Last updated:** [6 October 2021 21:39 UTC](https://discourse.nodered.org/t/node-red-contrib-ui-svg-create-table-by-input-message/51004 "2021-10-06T21:39:12Z")

</div>

Good Morning. I need to organize the goals in a table, and mark goals made and goals left to do. Is there any way to create a table with the goals, without being everything manually? I get the task by input. Is ther…

---

## [MQTT data loss at reconnection](https://discourse.nodered.org/t/mqtt-data-loss-at-reconnection/2593)

<div class="topic-metadata">

**Author:** [@mdresf](https://discourse.nodered.org/u/mdresf)\
**Replies:** 19\
**Last updated:** [6 October 2021 19:50 UTC](https://discourse.nodered.org/t/mqtt-data-loss-at-reconnection/2593 "2021-10-06T19:50:58Z")

</div>

Hi everybody, I have a problem with mqqt node (publish). The flow is simple: I inject a timestamp (converted in date time format) every 1 second into the MQTT publish node (QOS =2 and Retain on server =True) and into d…

---

## [Rate limiting for notifications?](https://discourse.nodered.org/t/rate-limiting-for-notifications/51929)

<div class="topic-metadata">

**Author:** [@daxliniere](https://discourse.nodered.org/u/daxliniere)\
**Replies:** 10\
**Last updated:** [6 October 2021 17:18 UTC](https://discourse.nodered.org/t/rate-limiting-for-notifications/51929 "2021-10-06T17:18:15Z")

</div>

Hey gang, I'm working on a flow that sends me a notification when my 3D printer job is almost finished. This is determined by an http-request every 30 seconds and a threshold of 98%. The problem I'm encountering is tha…

[Previous page](https://discourse.nodered.org/c/general/7.md?page=484)

[Next page](https://discourse.nodered.org/c/general/7.md?page=486)