# Latest

**URL:** https://discourse.nodered.org/latest.md?page=1016

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

**Page:** 1017

---

## [Flow to insert into MySQL table](https://discourse.nodered.org/t/flow-to-insert-into-mysql-table/31712)

<div class="topic-metadata">

**Author:** [@thagan](https://discourse.nodered.org/u/thagan)\
**Replies:** 5\
**Last updated:** [20 August 2020 19:06 UTC](https://discourse.nodered.org/t/flow-to-insert-into-mysql-table/31712 "2020-08-20T19:06:50Z")

</div>

Hello, I currently have a flow working that inserts data from a controller device into a MSSQL table. However I need to change it to insert the data into a MySQL table. The flow is a timestamp insert every minute, it re…

---

## [Communication between Python and Offline Nodered](https://discourse.nodered.org/t/communication-between-python-and-offline-nodered/31770)

<div class="topic-metadata">

**Author:** [@Sandy](https://discourse.nodered.org/u/Sandy)\
**Replies:** 20\
**Last updated:** [20 August 2020 19:00 UTC](https://discourse.nodered.org/t/communication-between-python-and-offline-nodered/31770 "2020-08-20T19:00:45Z")

</div>

Hi all, I have downloaded offline Desktop node-red, I have python 3.6.8. I know how to send Data from python to Node-red via Cloud or server(eg\>Mqtt). I want to send data from python that is when i run the python fil…

---

## [How to get IP from bash command](https://discourse.nodered.org/t/how-to-get-ip-from-bash-command/31792)

<div class="topic-metadata">

**Author:** [@hugocoolens](https://discourse.nodered.org/u/hugocoolens)\
**Replies:** 11\
**Last updated:** [20 August 2020 18:29 UTC](https://discourse.nodered.org/t/how-to-get-ip-from-bash-command/31792 "2020-08-20T18:29:49Z")

</div>

I'm trying to get the ip-adres of the raspberry pi which my node-red server is running on (it has Rhasspy running on it too, so I'll be able to ask for it, but that is not the issue). I use this bash-command: /sbin/ip …

---

## [How to Place Multiple groups in vertical manner](https://discourse.nodered.org/t/how-to-place-multiple-groups-in-vertical-manner/31774)

<div class="topic-metadata">

**Author:** [@makram](https://discourse.nodered.org/u/makram)\
**Replies:** 3\
**Last updated:** [20 August 2020 17:18 UTC](https://discourse.nodered.org/t/how-to-place-multiple-groups-in-vertical-manner/31774 "2020-08-20T17:18:33Z")

</div>

Hi all, How can i arrange multiple groups in vertical order in TAB. As i am only able to place them using layout in horizontal manner but i want to place them in vertical manner.

---

## [Add config node at runtime](https://discourse.nodered.org/t/add-config-node-at-runtime/31767)

<div class="topic-metadata">

**Author:** [@NetHans](https://discourse.nodered.org/u/NetHans)\
**Replies:** 2\
**Last updated:** [20 August 2020 14:23 UTC](https://discourse.nodered.org/t/add-config-node-at-runtime/31767 "2020-08-20T14:23:14Z")

</div>

Hello, this link describes how a config node can be permanently defined in a node. I would like to have config nodes added at runtime. For example, to define a list of server accesses. I wanted to use the editableList …

---

## [400 No required SSL certificate was sent](https://discourse.nodered.org/t/400-no-required-ssl-certificate-was-sent/31696)

<div class="topic-metadata">

**Author:** [@rabah.tamezait](https://discourse.nodered.org/u/rabah.tamezait)\
**Replies:** 11\
**Last updated:** [20 August 2020 14:08 UTC](https://discourse.nodered.org/t/400-no-required-ssl-certificate-was-sent/31696 "2020-08-20T14:08:22Z")

</div>

Hello, I try to execute API in http request and I receive this message ""400 No required SSL certificate was sent"" please what means ?

---

## [Can't reach Nora. Token change?](https://discourse.nodered.org/t/cant-reach-nora-token-change/31788)

<div class="topic-metadata">

**Author:** [@tfmeier](https://discourse.nodered.org/u/tfmeier)\
**Replies:** 0\
**Last updated:** [20 August 2020 13:54 UTC](https://discourse.nodered.org/t/cant-reach-nora-token-change/31788 "2020-08-20T13:54:11Z")

</div>

I have used Nora now for a few months without any issues. Was making some changes to Node-RED and saw the Nora nodes in a 'not connected' state. Nothing aparent so I had a look at the Nora site and as it turned out the t…

---

## [Feature Request: Add font awesome 6?](https://discourse.nodered.org/t/feature-request-add-font-awesome-6/31743)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 2\
**Last updated:** [20 August 2020 13:47 UTC](https://discourse.nodered.org/t/feature-request-add-font-awesome-6/31743 "2020-08-20T13:47:44Z")

</div>

Feature Request: Add font awesome 6?

---

## [Serial port /dev/ttyUSB0 closed unexpectedly again](https://discourse.nodered.org/t/serial-port-dev-ttyusb0-closed-unexpectedly-again/31175)

<div class="topic-metadata">

**Author:** [@edje11](https://discourse.nodered.org/u/edje11)\
**Replies:** 16\
**Last updated:** [20 August 2020 13:02 UTC](https://discourse.nodered.org/t/serial-port-dev-ttyusb0-closed-unexpectedly-again/31175 "2020-08-20T13:02:36Z")

</div>

I have the problem with serial port closed unexpectedly again. See this topic Tried today updating NR to V1.1.2, no problems with that. However also the Serial node is update then to 0.10.3 and that gives me the problem…

---

## [Passing parameters to UI Control node in the dashboard?](https://discourse.nodered.org/t/passing-parameters-to-ui-control-node-in-the-dashboard/31732)

<div class="topic-metadata">

**Author:** [@rawdani](https://discourse.nodered.org/u/rawdani)\
**Replies:** 4\
**Last updated:** [20 August 2020 12:38 UTC](https://discourse.nodered.org/t/passing-parameters-to-ui-control-node-in-the-dashboard/31732 "2020-08-20T12:38:38Z")

</div>

Hi, I want to use the "UI Control" node to change betweens tabs through when a "change" command is fired. I need however to have the information on where the change command is coming from. To better explain, I have a b…

---

## [Send Telegram Messages to more than one receiver](https://discourse.nodered.org/t/send-telegram-messages-to-more-than-one-receiver/31689)

<div class="topic-metadata">

**Author:** [@terminus](https://discourse.nodered.org/u/terminus)\
**Replies:** 3\
**Last updated:** [20 August 2020 12:10 UTC](https://discourse.nodered.org/t/send-telegram-messages-to-more-than-one-receiver/31689 "2020-08-20T12:10:32Z")

</div>

As you might already thinking, I'm a total noob. I'm trying to get NodeRed to send a Notification to more than on Telegram ID. So I set up a function Node like this: msg.payload = { title : 'Türchen geöffnet', c…

---

## [Garage door automation](https://discourse.nodered.org/t/garage-door-automation/1543)

<div class="topic-metadata">

**Author:** [@WhiskerBiscuit](https://discourse.nodered.org/u/WhiskerBiscuit)\
**Replies:** 10\
**Last updated:** [14 July 2018 20:14 UTC](https://discourse.nodered.org/t/garage-door-automation/1543 "2018-07-14T20:14:07Z")

</div>

I’m new to using Home Assistant and someone suggested that Node Red might be able to accomplish an automation I want to create. I want my garage door to open when I approach it, however I only want this to happen if I’m…

---

## [Looking for suggestions on how to condense an array of arrays (nRF24L01 scan results)](https://discourse.nodered.org/t/looking-for-suggestions-on-how-to-condense-an-array-of-arrays-nrf24l01-scan-results/31753)

<div class="topic-metadata">

**Author:** [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Replies:** 5\
**Last updated:** [20 August 2020 11:10 UTC](https://discourse.nodered.org/t/looking-for-suggestions-on-how-to-condense-an-array-of-arrays-nrf24l01-scan-results/31753 "2020-08-20T11:10:01Z")

</div>

I'm looking for some ideas (before I go reinventing an existing solution) on how to process some data. Background: I'm playing with the nRF24L01+ transceiver and scanning the channels available. There is a program that …

---

## [Spacer suggestion](https://discourse.nodered.org/t/spacer-suggestion/13028)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 2\
**Last updated:** [20 August 2020 10:10 UTC](https://discourse.nodered.org/t/spacer-suggestion/13028 "2020-08-20T10:10:05Z")

</div>

When designing dashboards the spacer is a nice addition. But it would be nice if you could add backgrounds/colours to it. So if you have a fancy dashboard, the space isn't quite as sticky outy as it is now. See exampl…

---

## [I don't understand if the timer is working or not?](https://discourse.nodered.org/t/i-dont-understand-if-the-timer-is-working-or-not/31768)

<div class="topic-metadata">

**Author:** [@Zerg](https://discourse.nodered.org/u/Zerg)\
**Replies:** 0\
**Last updated:** [20 August 2020 09:15 UTC](https://discourse.nodered.org/t/i-dont-understand-if-the-timer-is-working-or-not/31768 "2020-08-20T09:15:06Z")

</div>

I am beginner in Node-Red and am trying to understand in this example - "Timer". https://notenoughtech.com/home-automation/a-timer-in-nodered/ I have set the time! This can be seen on the screenshot. Under the node nam…

---

## [License for company use](https://discourse.nodered.org/t/license-for-company-use/31765)

<div class="topic-metadata">

**Author:** [@elicom](https://discourse.nodered.org/u/elicom)\
**Replies:** 3\
**Last updated:** [20 August 2020 08:41 UTC](https://discourse.nodered.org/t/license-for-company-use/31765 "2020-08-20T08:41:43Z")

</div>

Hello all! I'm working for a company that is curious about Node-RED and I was reading about licenses. There is no license for Node-RED, but there might be for external flows. Is that correct? Thank you so much in advan…

---

## [MQTT messages and getting back the original message](https://discourse.nodered.org/t/mqtt-messages-and-getting-back-the-original-message/31750)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 29\
**Last updated:** [20 August 2020 08:20 UTC](https://discourse.nodered.org/t/mqtt-messages-and-getting-back-the-original-message/31750 "2020-08-20T08:20:30Z")

</div>

I am sorry, I know I have asked before, but now can't remember and when I tried to search for it here, couldn't find it. Yes, You will find it .... as quick as when you try. I don't know why that is. I am receiving a …

---

## [How to connect two UI's](https://discourse.nodered.org/t/how-to-connect-two-uis/31495)

<div class="topic-metadata">

**Author:** [@makram](https://discourse.nodered.org/u/makram)\
**Replies:** 3\
**Last updated:** [20 August 2020 08:16 UTC](https://discourse.nodered.org/t/how-to-connect-two-uis/31495 "2020-08-20T08:16:11Z")

</div>

suppose i have two flow , flow 1 & flow 2 and in flow 1 i have a button and i want to call to call my flow 2 using this button. How can i connect my switch with flow 2 so that whenever this switch is pressed the flow 2 u…

---

## [Node-red is logging messages with incorrect severity](https://discourse.nodered.org/t/node-red-is-logging-messages-with-incorrect-severity/31726)

<div class="topic-metadata">

**Author:** [@Shaquu](https://discourse.nodered.org/u/Shaquu)\
**Replies:** 1\
**Last updated:** [20 August 2020 07:27 UTC](https://discourse.nodered.org/t/node-red-is-logging-messages-with-incorrect-severity/31726 "2020-08-20T07:27:02Z")

</div>

Hi, I have noticed that node-red logs redirected to syslog are using incorrect severity. As you see some records have \[info\] in message and are under info severity. But when I triggered error (type error in function …

---

## [How do I create an object to pass to alexa.remote2](https://discourse.nodered.org/t/how-do-i-create-an-object-to-pass-to-alexa-remote2/31757)

<div class="topic-metadata">

**Author:** [@v8dave](https://discourse.nodered.org/u/v8dave)\
**Replies:** 2\
**Last updated:** [20 August 2020 07:08 UTC](https://discourse.nodered.org/t/how-do-i-create-an-object-to-pass-to-alexa-remote2/31757 "2020-08-20T07:08:09Z")

</div>

I am trying to control a device and create a generic function that can take a topic with the device name and a payload with ON or OFF but I can't seem to figure out the code for this. I am trying to pass this to an alex.…

---

## [SWITCH node not playing the game](https://discourse.nodered.org/t/switch-node-not-playing-the-game/31751)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 3\
**Last updated:** [20 August 2020 05:22 UTC](https://discourse.nodered.org/t/switch-node-not-playing-the-game/31751 "2020-08-20T05:22:43Z")

</div>

I am (again) not seeing the bigger picture. I am playing with switch nodes and it doesn't seem to be behaving. See nodes inside red boundary. This is the code: \[{"id":"426ead5c.df267c","type":"switch","z":"a1911aa3…

---

## [Need help in function format string](https://discourse.nodered.org/t/need-help-in-function-format-string/31734)

<div class="topic-metadata">

**Author:** [@great12](https://discourse.nodered.org/u/great12)\
**Replies:** 2\
**Last updated:** [20 August 2020 05:01 UTC](https://discourse.nodered.org/t/need-help-in-function-format-string/31734 "2020-08-20T05:01:48Z")

</div>

Hello there, i'm very new to node-red. I'm trying my first steps, but stuck now. i made a bash script, querying blacklist from spamhaus the output tells me, if there is an entry or not. the function is as follows v…

---

## [Is node-red causing this i2c problem](https://discourse.nodered.org/t/is-node-red-causing-this-i2c-problem/31709)

<div class="topic-metadata">

**Author:** [@Peter\_Truman](https://discourse.nodered.org/u/Peter_Truman)\
**Replies:** 3\
**Last updated:** [19 August 2020 22:52 UTC](https://discourse.nodered.org/t/is-node-red-causing-this-i2c-problem/31709 "2020-08-19T22:52:21Z")

</div>

Hi - I wonder if anyone can offer any insight into this problem? Pi 4B, Raspbian 10 (buster) From a fresh reboot i2cdetect -y 1 (see pic) Start Node-Red (and do nothing else - I don't have any i2c nodes installed) i…

---

## [Alternative to Radio buttons](https://discourse.nodered.org/t/alternative-to-radio-buttons/31746)

<div class="topic-metadata">

**Author:** [@davej](https://discourse.nodered.org/u/davej)\
**Replies:** 4\
**Last updated:** [19 August 2020 21:31 UTC](https://discourse.nodered.org/t/alternative-to-radio-buttons/31746 "2020-08-19T21:31:37Z")

</div>

Just throwing out a general question. With Radio Buttons not being available as part of standard Node Red, what are folk using as a suitable alternative? Seems like it was a decision made some years ago as not consi…

---

## [Domain pointing to online hosted node-red](https://discourse.nodered.org/t/domain-pointing-to-online-hosted-node-red/31651)

<div class="topic-metadata">

**Author:** [@JCLeuvennink](https://discourse.nodered.org/u/JCLeuvennink)\
**Replies:** 1\
**Last updated:** [19 August 2020 19:33 UTC](https://discourse.nodered.org/t/domain-pointing-to-online-hosted-node-red/31651 "2020-08-19T19:33:53Z")

</div>

I am working on a project where I want to host an online node-red dashboard that is accessible through a domain on the internet. I have an oracle cloud VM, have installed node-red, generated an SSL certificate for it us…

---

## [Passing colors to Alexa via remote2](https://discourse.nodered.org/t/passing-colors-to-alexa-via-remote2/31740)

<div class="topic-metadata">

**Author:** [@wecoyote5](https://discourse.nodered.org/u/wecoyote5)\
**Replies:** 2\
**Last updated:** [19 August 2020 19:25 UTC](https://discourse.nodered.org/t/passing-colors-to-alexa-via-remote2/31740 "2020-08-19T19:25:31Z")

</div>

Hi all, I'm converting from ST to Hubitat and Node Red. I'm using Alexa Remote 2 to access Alexa from NR. So far, knock on wood, everything has been working just fine. I have a few RGBW LED WiFi controllers from Tuya th…

---

## [Packaging Files in a Node-Red Flow](https://discourse.nodered.org/t/packaging-files-in-a-node-red-flow/31727)

<div class="topic-metadata">

**Author:** [@jennyeg](https://discourse.nodered.org/u/jennyeg)\
**Replies:** 6\
**Last updated:** [19 August 2020 17:44 UTC](https://discourse.nodered.org/t/packaging-files-in-a-node-red-flow/31727 "2020-08-19T17:44:44Z")

</div>

Hello everyone, I have created a flow that I would like to publish, however my flow relies on reading a html file and a javascript file. My file node is currently reading these files from my local machine. However, when…

---

## [Pi turn on via Node Red](https://discourse.nodered.org/t/pi-turn-on-via-node-red/31737)

<div class="topic-metadata">

**Author:** [@edwardr](https://discourse.nodered.org/u/edwardr)\
**Replies:** 3\
**Last updated:** [19 August 2020 17:07 UTC](https://discourse.nodered.org/t/pi-turn-on-via-node-red/31737 "2020-08-19T17:07:08Z")

</div>

Hi guys, New problem for you all - I\`ve been struggling with ideas for how to start up a pi if it crashes on Node Red. My concept - I have two pis, one acting as a heart beat passing a ping across. If the ping comes …

---

## [COVID-19 status by country](https://discourse.nodered.org/t/covid-19-status-by-country/28743)

<div class="topic-metadata">

**Author:** [@janvda](https://discourse.nodered.org/u/janvda)\
**Replies:** 35\
**Last updated:** [19 August 2020 15:51 UTC](https://discourse.nodered.org/t/covid-19-status-by-country/28743 "2020-08-19T15:51:18Z")

</div>

Hi, I am not really satisfied with the "COVID overviews by country" I can find on the internet. (the best one I think = https://www.worldometers.info/coronavirus/#countries ) They fail to properly reflect the current…

---

## [Raspberry pi - USB HID node error](https://discourse.nodered.org/t/raspberry-pi-usb-hid-node-error/19410)

<div class="topic-metadata">

**Author:** [@sense](https://discourse.nodered.org/u/sense)\
**Replies:** 13\
**Last updated:** [19 August 2020 15:28 UTC](https://discourse.nodered.org/t/raspberry-pi-usb-hid-node-error/19410 "2020-08-19T15:28:21Z")

</div>

Hello, been trying to install node/node-red-contrib-usbhid by following all the steps with no success. Through the Palette-Management i get the errors below (truncated) /home/pi/.cache/node-gyp/12.14.0/include/node/v8…

[Previous page](https://discourse.nodered.org/latest.md?page=1015)

[Next page](https://discourse.nodered.org/latest.md?page=1017)
