# General

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

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

**Page:** 627

---

## [Temperature and epoch data from mysql and showing line chart problem](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751)

<div class="topic-metadata">

**Author:** [@mac5562](https://discourse.nodered.org/u/mac5562)\
**Replies:** 18\
**Last updated:** [7 January 2021 22:07 UTC](https://discourse.nodered.org/t/temperature-and-epoch-data-from-mysql-and-showing-line-chart-problem/38751 "2021-01-07T22:07:57Z")

</div>

Hi I fetching temperature and date(epoch) data from mysql database and i showing that on a line chart. My problem is, on x-axis showing just the raw epoch data i unable the showind normal date. As you can see the y-ax…

---

## [On off switch loop](https://discourse.nodered.org/t/on-off-switch-loop/38540)

<div class="topic-metadata">

**Author:** [@raz](https://discourse.nodered.org/u/raz)\
**Replies:** 11\
**Last updated:** [7 January 2021 22:04 UTC](https://discourse.nodered.org/t/on-off-switch-loop/38540 "2021-01-07T22:04:37Z")

</div>

Hello. Total noob here. I want to make an automation for a fogger. -1 slider for on in hours minutes seconds -2 slider for off in hours minutes seconds i have managed to do one with no UI using trigger and delay nod…

---

## [How do I make an Alarm Table?](https://discourse.nodered.org/t/how-do-i-make-an-alarm-table/38718)

<div class="topic-metadata">

**Author:** [@traderjoe](https://discourse.nodered.org/u/traderjoe)\
**Replies:** 2\
**Last updated:** [7 January 2021 20:56 UTC](https://discourse.nodered.org/t/how-do-i-make-an-alarm-table/38718 "2021-01-07T20:56:02Z")

</div>

How do I make an alarm table like this? I have a modbus read reading a bunch of coils. Each coil is an alarm. As certain alarms become active/de-active, the messages will appear/disappear in the alarm table. Is the…

---

## [Many Arduinos on serial ports with node-red (raspberry pi 4)](https://discourse.nodered.org/t/many-arduinos-on-serial-ports-with-node-red-raspberry-pi-4/38725)

<div class="topic-metadata">

**Author:** [@niwre001](https://discourse.nodered.org/u/niwre001)\
**Replies:** 1\
**Last updated:** [7 January 2021 20:34 UTC](https://discourse.nodered.org/t/many-arduinos-on-serial-ports-with-node-red-raspberry-pi-4/38725 "2021-01-07T20:34:10Z")

</div>

Hi there, have several Ardinos in different places and would like e.g. temp values ​​on node-red to each created serial interfaces (/dev/ttyUSB0). How should I configure the serial interfaces in node-red. Kind regards …

---

## [Unable to Connect to Mosquitto Broker](https://discourse.nodered.org/t/unable-to-connect-to-mosquitto-broker/38736)

<div class="topic-metadata">

**Author:** [@quentinP](https://discourse.nodered.org/u/quentinP)\
**Replies:** 2\
**Last updated:** [7 January 2021 19:33 UTC](https://discourse.nodered.org/t/unable-to-connect-to-mosquitto-broker/38736 "2021-01-07T19:33:18Z")

</div>

I'm trying to connect Node-RED (which is running on an Azure Web-App) to my mosquitto broker (v.3.1.1, which is running on and Azure Virtual Machine running Ubuntu v18.04.1). I am able to pub and sub on localhost with 2 …

---

## [Remove in-use palette](https://discourse.nodered.org/t/remove-in-use-palette/38546)

<div class="topic-metadata">

**Author:** [@Jme2](https://discourse.nodered.org/u/Jme2)\
**Replies:** 2\
**Last updated:** [7 January 2021 18:05 UTC](https://discourse.nodered.org/t/remove-in-use-palette/38546 "2021-01-07T18:05:48Z")

</div>

Hey everyone, I just started using node-red on raspbian, and I wanted to remove a xiaomi palette that I used in a flow. One of nodes (13) of the palette is always in use (xiaomi-gateway-config) and I cannot remove it b…

---

## [Upload Arduino sketch binary via Node-Red usb?](https://discourse.nodered.org/t/upload-arduino-sketch-binary-via-node-red-usb/38554)

<div class="topic-metadata">

**Author:** [@m\_elias](https://discourse.nodered.org/u/m_elias)\
**Replies:** 13\
**Last updated:** [7 January 2021 17:44 UTC](https://discourse.nodered.org/t/upload-arduino-sketch-binary-via-node-red-usb/38554 "2021-01-07T17:44:21Z")

</div>

I have an Arduino Uno connected via usb to my oPi One running Node-Red 1.2.6. The Arduino runs a modified Firmata example sketch and I use node-red-node-arduino to send/receive data to/from the Arduino etc. Is it difficu…

---

## [Subflow importing, problem with link in & link out](https://discourse.nodered.org/t/subflow-importing-problem-with-link-in-link-out/38728)

<div class="topic-metadata">

**Author:** [@Tombcat](https://discourse.nodered.org/u/Tombcat)\
**Replies:** 4\
**Last updated:** [7 January 2021 17:20 UTC](https://discourse.nodered.org/t/subflow-importing-problem-with-link-in-link-out/38728 "2021-01-07T17:20:31Z")

</div>

Hello, I tried to import flow with the subflow that already exists in my flow instance by selecting option "import copy", that resulted in "link in" & "link out" were not connected to anything. As i understand this can…

---

## [Convert Flow from MySQL to PostgreSQL](https://discourse.nodered.org/t/convert-flow-from-mysql-to-postgresql/38730)

<div class="topic-metadata">

**Author:** [@Trocergian](https://discourse.nodered.org/u/Trocergian)\
**Replies:** 0\
**Last updated:** [7 January 2021 17:12 UTC](https://discourse.nodered.org/t/convert-flow-from-mysql-to-postgresql/38730 "2021-01-07T17:12:59Z")

</div>

I'm trying to convert this flow from using a MySQL database over to a PostgreSQL database and not having much luck. Full disclosure: I didn't create the MySQL flow so much as copied it from a "How to " book. I did have …

---

## [Unable to enable "Projects" in Windows V 1.2.7](https://discourse.nodered.org/t/unable-to-enable-projects-in-windows-v-1-2-7/38710)

<div class="topic-metadata">

**Author:** [@BobW](https://discourse.nodered.org/u/BobW)\
**Replies:** 5\
**Last updated:** [7 January 2021 14:17 UTC](https://discourse.nodered.org/t/unable-to-enable-projects-in-windows-v-1-2-7/38710 "2021-01-07T14:17:11Z")

</div>

I am running node red V 1.2.7 on a Windows 10 PC. I followed the instructions for editing the settings.js file to enable Projects. However, when I reboot node red and start my browser, I do not see Projects appearing …

---

## [Update an individual flow configuration](https://discourse.nodered.org/t/update-an-individual-flow-configuration/38662)

<div class="topic-metadata">

**Author:** [@ridha](https://discourse.nodered.org/u/ridha)\
**Replies:** 2\
**Last updated:** [7 January 2021 13:42 UTC](https://discourse.nodered.org/t/update-an-individual-flow-configuration/38662 "2021-01-07T13:42:59Z")

</div>

Hi, I'd like to update my flow remotely using the API . my issue is how I can get the changes to put it in a request body. Thanks

---

## [Zigbee2tasmota variables and ways to extract them from msg.payload](https://discourse.nodered.org/t/zigbee2tasmota-variables-and-ways-to-extract-them-from-msg-payload/38685)

<div class="topic-metadata">

**Author:** [@gr1nch](https://discourse.nodered.org/u/gr1nch)\
**Replies:** 3\
**Last updated:** [7 January 2021 13:27 UTC](https://discourse.nodered.org/t/zigbee2tasmota-variables-and-ways-to-extract-them-from-msg-payload/38685 "2021-01-07T13:27:53Z")

</div>

Looking at the list of key/values I'm now able to extract from msg.payload via zigbee2tasmota and MQTT, I thought it might be useful to share them in jsonata format (for extraction) and for others to share theirs as well…

---

## [Are MQTT nodes allowed in Subflows?](https://discourse.nodered.org/t/are-mqtt-nodes-allowed-in-subflows/38690)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 8\
**Last updated:** [7 January 2021 11:42 UTC](https://discourse.nodered.org/t/are-mqtt-nodes-allowed-in-subflows/38690 "2021-01-07T11:42:02Z")

</div>

Sorry, gotta ask to be sure. I'm on a bit of a binge just now and am really playing with sub-flows. I shall try it and see, but would like to be sure of my findings.

---

## [Production server with no admin login?](https://discourse.nodered.org/t/production-server-with-no-admin-login/17331)

<div class="topic-metadata">

**Author:** [@petercutting](https://discourse.nodered.org/u/petercutting)\
**Replies:** 12\
**Last updated:** [7 January 2021 10:44 UTC](https://discourse.nodered.org/t/production-server-with-no-admin-login/17331 "2021-01-07T10:44:54Z")

</div>

I am new to NR. developed a simple flow on an RPI. I want to expose it to the internet. But I need to harden my env first. Tried to lock down Admin login using npm install node-red-auth-github but that crashed. So my ne…

---

## [This is a new error which is happening a fair bit](https://discourse.nodered.org/t/this-is-a-new-error-which-is-happening-a-fair-bit/38700)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 2\
**Last updated:** [7 January 2021 10:26 UTC](https://discourse.nodered.org/t/this-is-a-new-error-which-is-happening-a-fair-bit/38700 "2021-01-07T10:26:33Z")

</div>

This one is popping up a fair amount recently. {"message":"Error: spawn ENOMEM","source":{"id":"3ca1bd56.5515aa","type":"ping","name":"Ping","count":1},"stack":"Error: spawn ENOMEM\\n at ChildProcess.spawn (internal/c…

---

## [Trademark registration](https://discourse.nodered.org/t/trademark-registration/38704)

<div class="topic-metadata">

**Author:** [@jacks1122](https://discourse.nodered.org/u/jacks1122)\
**Replies:** 1\
**Last updated:** [7 January 2021 10:01 UTC](https://discourse.nodered.org/t/trademark-registration/38704 "2021-01-07T10:01:44Z")

</div>

How Do I Choose a Trademark Class and Description /?

---

## [How can I get the Node name and passing it to a notification](https://discourse.nodered.org/t/how-can-i-get-the-node-name-and-passing-it-to-a-notification/38668)

<div class="topic-metadata">

**Author:** [@soruam](https://discourse.nodered.org/u/soruam)\
**Replies:** 10\
**Last updated:** [7 January 2021 09:57 UTC](https://discourse.nodered.org/t/how-can-i-get-the-node-name-and-passing-it-to-a-notification/38668 "2021-01-07T09:57:18Z")

</div>

Good morning, I am new in this so be patient if I am not using the correct words. I am trying to get notification from several sensors about their battery levels. The picture below shows my flow, which it is working a…

---

## [Communication through tcp/ip to Aubobot](https://discourse.nodered.org/t/communication-through-tcp-ip-to-aubobot/38125)

<div class="topic-metadata">

**Author:** [@jadelu](https://discourse.nodered.org/u/jadelu)\
**Replies:** 16\
**Last updated:** [7 January 2021 09:14 UTC](https://discourse.nodered.org/t/communication-through-tcp-ip-to-aubobot/38125 "2021-01-07T09:14:35Z")

</div>

I'm currently connecting from node-red to Aubobot through tcp in node. But after I connected them, it will show an intermittent state of the connection. Does anyone encounter this before?

---

## [Help with sub-flow and status part](https://discourse.nodered.org/t/help-with-sub-flow-and-status-part/38689)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 4\
**Last updated:** [7 January 2021 07:59 UTC](https://discourse.nodered.org/t/help-with-sub-flow-and-status-part/38689 "2021-01-07T07:59:18Z")

</div>

Yeah, sorry folks. I am seeing weird things happening. Basic flow. You will need to set global.Shutdown\_temperature to 75 for it to work. Picture of flow: Idea: inputs: "test" for testing purposes. 0 - (or low …

---

## [Checking on how to get \*context\* from a subflow](https://discourse.nodered.org/t/checking-on-how-to-get-context-from-a-subflow/38698)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 4\
**Last updated:** [7 January 2021 07:22 UTC](https://discourse.nodered.org/t/checking-on-how-to-get-context-from-a-subflow/38698 "2021-01-07T07:22:21Z")

</div>

Sorry for asking - again. But I am stuck. In a function node. This is the code that works: var x = flow.get("$parent.name"); var y = global.get("something"); msg.payload = x + " " + y; My question is why the inconsi…

---

## [How to import Data from Django and Display on node-red?](https://discourse.nodered.org/t/how-to-import-data-from-django-and-display-on-node-red/38633)

<div class="topic-metadata">

**Author:** [@rpr](https://discourse.nodered.org/u/rpr)\
**Replies:** 3\
**Last updated:** [7 January 2021 06:10 UTC](https://discourse.nodered.org/t/how-to-import-data-from-django-and-display-on-node-red/38633 "2021-01-07T06:10:33Z")

</div>

I have a UID Database in Django(phpmyadmin). So if i give any UID in Node-red, I want to receive details like Name, Details, email, etc from Django Database(phpmyadmin) and display on Node-red Dashboard. Presently ever…

---

## [Pull down menu to select delay?](https://discourse.nodered.org/t/pull-down-menu-to-select-delay/38640)

<div class="topic-metadata">

**Author:** [@spawnreaper](https://discourse.nodered.org/u/spawnreaper)\
**Replies:** 12\
**Last updated:** [6 January 2021 22:51 UTC](https://discourse.nodered.org/t/pull-down-menu-to-select-delay/38640 "2021-01-06T22:51:43Z")

</div>

I am very new at node-red, So I still have to learn a lot. The topics that touch on the subject I don't really understand. What I am trying to create: First select time on a pull down menu on the dashboard with option…

---

## [Submit button won't show update on multiple browsers](https://discourse.nodered.org/t/submit-button-wont-show-update-on-multiple-browsers/38671)

<div class="topic-metadata">

**Author:** [@Vinnyvangogo](https://discourse.nodered.org/u/Vinnyvangogo)\
**Replies:** 6\
**Last updated:** [6 January 2021 22:10 UTC](https://discourse.nodered.org/t/submit-button-wont-show-update-on-multiple-browsers/38671 "2021-01-06T22:10:04Z")

</div>

I am trying to make a simple comment box for people on different computers to leave messages. When I submit a new comment the update shows on the local screen but not on a second computer. I am not sure what is wrong. Th…

---

## [Web page - Is this something to worry about?](https://discourse.nodered.org/t/web-page-is-this-something-to-worry-about/38610)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 12\
**Last updated:** [6 January 2021 21:24 UTC](https://discourse.nodered.org/t/web-page-is-this-something-to-worry-about/38610 "2021-01-06T21:24:57Z")

</div>

Today I just got up and when I tried to load the page I see this: Error: EIO: i/o error, stat '/usr/lib/node\_modules/node-red/node\_modules/@node-red/editor-client/public/ui/index.html' There is more to come - an error …

---

## [Passing colors to Teckin (tuya) RGB bulbs from Google](https://discourse.nodered.org/t/passing-colors-to-teckin-tuya-rgb-bulbs-from-google/38664)

<div class="topic-metadata">

**Author:** [@blacjoker](https://discourse.nodered.org/u/blacjoker)\
**Replies:** 1\
**Last updated:** [6 January 2021 20:53 UTC](https://discourse.nodered.org/t/passing-colors-to-teckin-tuya-rgb-bulbs-from-google/38664 "2021-01-06T20:53:59Z")

</div>

I have been trying to send data from a virtual bulb I created using node-red-contrib-nora but I can't seem to get anything across. Nora is sending this out: { "payload":{ "online":true, "on":false, …

---

## [How to insert a "variable string" into "FILENAME" topic of "FILE IN" node?](https://discourse.nodered.org/t/how-to-insert-a-variable-string-into-filename-topic-of-file-in-node/38672)

<div class="topic-metadata">

**Author:** [@luks](https://discourse.nodered.org/u/luks)\
**Replies:** 2\
**Last updated:** [6 January 2021 18:59 UTC](https://discourse.nodered.org/t/how-to-insert-a-variable-string-into-filename-topic-of-file-in-node/38672 "2021-01-06T18:59:58Z")

</div>

Hello, I'm working with a machine that uses different programms according to the production. Each programm has its own file and the machine says what programm is running thru an ".ini" file. I'm reading this .ini and ge…

---

## [Can't install node-red-contrib-zigbee](https://discourse.nodered.org/t/cant-install-node-red-contrib-zigbee/38660)

<div class="topic-metadata">

**Author:** [@Tehn](https://discourse.nodered.org/u/Tehn)\
**Replies:** 8\
**Last updated:** [6 January 2021 18:26 UTC](https://discourse.nodered.org/t/cant-install-node-red-contrib-zigbee/38660 "2021-01-06T18:26:58Z")

</div>

I just started using node red. Using the manage pallete it doesn't download. It gives me the same error when i load the npm code into powershell. Doe anyone know how to fix this?

---

## [HTTP request with variable date in address](https://discourse.nodered.org/t/http-request-with-variable-date-in-address/38478)

<div class="topic-metadata">

**Author:** [@archipelag0](https://discourse.nodered.org/u/archipelag0)\
**Replies:** 7\
**Last updated:** [6 January 2021 18:10 UTC](https://discourse.nodered.org/t/http-request-with-variable-date-in-address/38478 "2021-01-06T18:10:04Z")

</div>

Hello, I'd like to send consecutive JSON/http requests and write the data to separate tabs on a Google Docs spreadsheet. The historic data is stored on a server as day by day entries - I think in JSON format - and each…

---

## [Getting past 'get\_entities' node with No Results](https://discourse.nodered.org/t/getting-past-get-entities-node-with-no-results/38632)

<div class="topic-metadata">

**Author:** [@nappyjim](https://discourse.nodered.org/u/nappyjim)\
**Replies:** 1\
**Last updated:** [6 January 2021 14:47 UTC](https://discourse.nodered.org/t/getting-past-get-entities-node-with-no-results/38632 "2021-01-06T14:47:28Z")

</div>

How would I get the flow to continue past the get\_entities node? Even though no lights are on, I want it to continue so that “night mode green” gets set. \[{"id":"8fb537a8.828378","type":"tab","label":"Flow 3","disable…

---

## [Function tried to send a message of type number - But a number is what I want](https://discourse.nodered.org/t/function-tried-to-send-a-message-of-type-number-but-a-number-is-what-i-want/38658)

<div class="topic-metadata">

**Author:** [@stee\_vo](https://discourse.nodered.org/u/stee_vo)\
**Replies:** 4\
**Last updated:** [6 January 2021 14:36 UTC](https://discourse.nodered.org/t/function-tried-to-send-a-message-of-type-number-but-a-number-is-what-i-want/38658 "2021-01-06T14:36:46Z")

</div>

So I have a function connected to a MySQL database selecting a certain column from a table, the colums are numbers, either 0 or 1. I know I can get the values, but now I want to send them into some toggle nodes that resp…

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

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