# General

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

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

**Page:** 464

---

## [Running ffmpeg in exec node not working](https://discourse.nodered.org/t/running-ffmpeg-in-exec-node-not-working/54130)

<div class="topic-metadata">

**Author:** [@Metafieldor](https://discourse.nodered.org/u/Metafieldor)\
**Replies:** 10\
**Last updated:** [23 November 2021 01:34 UTC](https://discourse.nodered.org/t/running-ffmpeg-in-exec-node-not-working/54130 "2021-11-23T01:34:53Z")

</div>

I'm trying to take snapshots of my camera's rtsp stream. Stream is working on PC which is on the same LAN network as RPi400 with home assistant and node red. There I'm unable to get it working. In node I use this code: …

---

## [Aggregate multiple async requests into a single message](https://discourse.nodered.org/t/aggregate-multiple-async-requests-into-a-single-message/54126)

<div class="topic-metadata">

**Author:** [@djsb](https://discourse.nodered.org/u/djsb)\
**Replies:** 8\
**Last updated:** [22 November 2021 22:06 UTC](https://discourse.nodered.org/t/aggregate-multiple-async-requests-into-a-single-message/54126 "2021-11-22T22:06:27Z")

</div>

Hi all, Assuming we have a Node-RED http-in endpoint that, once called, fires multiple (eg: 3) async HTTP requests to 3rd party servers, how to I aggregate the HTTP 3 responses into a single message and therefore provid…

---

## [Send msg.payload on html button](https://discourse.nodered.org/t/send-msg-payload-on-html-button/54073)

<div class="topic-metadata">

**Author:** [@fmejialo](https://discourse.nodered.org/u/fmejialo)\
**Replies:** 5\
**Last updated:** [22 November 2021 18:19 UTC](https://discourse.nodered.org/t/send-msg-payload-on-html-button/54073 "2021-11-22T18:19:20Z")

</div>

Hello, I have created a custom checkbox button, based on internet codes, that allows me to use svg images in the background, now I am trying that when changing the button from unchecked to checked it sends as a "true" m…

---

## [\[Feedback wanted\] Update to mysql node](https://discourse.nodered.org/t/feedback-wanted-update-to-mysql-node/53936)

<div class="topic-metadata">

**Author:** [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Replies:** 15\
**Last updated:** [22 November 2021 17:21 UTC](https://discourse.nodered.org/t/feedback-wanted-update-to-mysql-node/53936 "2021-11-22T17:21:46Z")

</div>

I have just updated the node-red-node-mysql node to use the more maintained mysql2 library in response to MySQL 8.0 needs new Auth mechanism · Issue #853 · node-red/node-red-nodes · GitHub - and it is on npm as node-red-…

---

## [Switches interlock HA](https://discourse.nodered.org/t/switches-interlock-ha/54120)

<div class="topic-metadata">

**Author:** [@IkaSGC](https://discourse.nodered.org/u/IkaSGC)\
**Replies:** 0\
**Last updated:** [22 November 2021 16:15 UTC](https://discourse.nodered.org/t/switches-interlock-ha/54120 "2021-11-22T16:15:32Z")

</div>

Hi, I'm a complete newcomer to NodeRed. I'm solving a problem now and I can't figure it out. These are Christmas lights. In HomeAssistant I have created two "helpers" buttons. One is "Permanent ON" and should permanently…

---

## [How to delete a context variable (wastebasket icon) with keyboard instead of mouse?](https://discourse.nodered.org/t/how-to-delete-a-context-variable-wastebasket-icon-with-keyboard-instead-of-mouse/54114)

<div class="topic-metadata">

**Author:** [@bwims](https://discourse.nodered.org/u/bwims)\
**Replies:** 1\
**Last updated:** [22 November 2021 15:05 UTC](https://discourse.nodered.org/t/how-to-delete-a-context-variable-wastebasket-icon-with-keyboard-instead-of-mouse/54114 "2021-11-22T15:05:09Z")

</div>

Hi, sometimes I want to clear a lot of context variables using the editor sidebar. Each time I click the wastebasket icon, I get the popup "Are you sure you want to delete this item?" Is there any way to do with with …

---

## [Structuring Flows](https://discourse.nodered.org/t/structuring-flows/54079)

<div class="topic-metadata">

**Author:** [@xytsrm](https://discourse.nodered.org/u/xytsrm)\
**Replies:** 17\
**Last updated:** [22 November 2021 14:50 UTC](https://discourse.nodered.org/t/structuring-flows/54079 "2021-11-22T14:50:06Z")

</div>

I'm about to structure flows in a Server/Client structure. The server flow will sent messages to various client flows. I was contemplating two mechanisms for accomplishing this: METHOD 1: Have the server send a message …

---

## [Node-red remote access is not connecting](https://discourse.nodered.org/t/node-red-remote-access-is-not-connecting/54091)

<div class="topic-metadata">

**Author:** [@aminulhaq](https://discourse.nodered.org/u/aminulhaq)\
**Replies:** 9\
**Last updated:** [22 November 2021 14:31 UTC](https://discourse.nodered.org/t/node-red-remote-access-is-not-connecting/54091 "2021-11-22T14:31:07Z")

</div>

Hi, install node-red-contrib-remote from manage pallet and did basic setting but it is not connecting with the network, i have seen on my command prompt that node-red-contrib-remote when i start flows see pic for refere…

---

## [Node Red on Arduino Portenta H7](https://discourse.nodered.org/t/node-red-on-arduino-portenta-h7/54101)

<div class="topic-metadata">

**Author:** [@miguelluhulima](https://discourse.nodered.org/u/miguelluhulima)\
**Replies:** 3\
**Last updated:** [22 November 2021 13:34 UTC](https://discourse.nodered.org/t/node-red-on-arduino-portenta-h7/54101 "2021-11-22T13:34:44Z")

</div>

is it possible to run node red on an Arduino Portenta H7?

---

## [ER\_PARSE\_ERROR in mysql node](https://discourse.nodered.org/t/er-parse-error-in-mysql-node/54099)

<div class="topic-metadata">

**Author:** [@sahsha](https://discourse.nodered.org/u/sahsha)\
**Replies:** 3\
**Last updated:** [22 November 2021 12:53 UTC](https://discourse.nodered.org/t/er-parse-error-in-mysql-node/54099 "2021-11-22T12:53:35Z")

</div>

Need help to insert query using mysql node. I'm getting error: Error: ER\_PARSE\_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use n…

---

## [Problem inserting object into template node](https://discourse.nodered.org/t/problem-inserting-object-into-template-node/54103)

<div class="topic-metadata">

**Author:** [@nerevar](https://discourse.nodered.org/u/nerevar)\
**Replies:** 2\
**Last updated:** [22 November 2021 12:44 UTC](https://discourse.nodered.org/t/problem-inserting-object-into-template-node/54103 "2021-11-22T12:44:42Z")

</div>

Hi, I'm having a problem in inserting an object to the template node (not ui\_template). I want to export charts to html, but the problem is I need to do it dynamicaly. Static example works with no problems. previously…

---

## [Alarm system using node red](https://discourse.nodered.org/t/alarm-system-using-node-red/51569)

<div class="topic-metadata">

**Author:** [@Sirhc](https://discourse.nodered.org/u/Sirhc)\
**Replies:** 5\
**Last updated:** [22 November 2021 11:27 UTC](https://discourse.nodered.org/t/alarm-system-using-node-red/51569 "2021-11-22T11:27:20Z")

</div>

Hello Just wondering if anyone has managed to install an alarm system which talks to node red? I am not interested in building my own alarm system, more so just being able to arm/disarm a type tested alarm system from a…

---

## [Msg String to object](https://discourse.nodered.org/t/msg-string-to-object/54081)

<div class="topic-metadata">

**Author:** [@Helix78](https://discourse.nodered.org/u/Helix78)\
**Replies:** 6\
**Last updated:** [22 November 2021 09:44 UTC](https://discourse.nodered.org/t/msg-string-to-object/54081 "2021-11-22T09:44:05Z")

</div>

I execute a poweshell script which produces a string output. msg : string\[4\] "307↵" I did not manage to parse it to a useable object. It seems I cannot access the plain string which comes with msg.

---

## [Getting current tab(flow) id from sidebar](https://discourse.nodered.org/t/getting-current-tab-flow-id-from-sidebar/4934)

<div class="topic-metadata">

**Author:** [@malinthasa](https://discourse.nodered.org/u/malinthasa)\
**Replies:** 7\
**Last updated:** [22 November 2021 10:20 UTC](https://discourse.nodered.org/t/getting-current-tab-flow-id-from-sidebar/4934 "2021-11-22T10:20:04Z")

</div>

Hi, Can I get the id of the opened tab (which is already deployed) from a sidebar? I am getting the flow description using flows/ endpoint but I want current flow id to filter the response from the flows/ API call. I th…

---

## [Extract string from list with a function node](https://discourse.nodered.org/t/extract-string-from-list-with-a-function-node/53967)

<div class="topic-metadata">

**Author:** [@giuliandenicola](https://discourse.nodered.org/u/giuliandenicola)\
**Replies:** 2\
**Last updated:** [22 November 2021 10:19 UTC](https://discourse.nodered.org/t/extract-string-from-list-with-a-function-node/53967 "2021-11-22T10:19:55Z")

</div>

Hi, I don't know how to search for this question that I have so I'll ask. If there already is a post about this let me know. I would like to have a nodered setup were I can have a list of items and based on the number …

---

## [Using SQL with Node-red](https://discourse.nodered.org/t/using-sql-with-node-red/54029)

<div class="topic-metadata">

**Author:** [@AndyDHill](https://discourse.nodered.org/u/AndyDHill)\
**Replies:** 5\
**Last updated:** [22 November 2021 09:55 UTC](https://discourse.nodered.org/t/using-sql-with-node-red/54029 "2021-11-22T09:55:06Z")

</div>

Have a problem where I need to read the On Change ( new rows) from an SQL table (MS SQL) I have managed to read all records. but as the table grows the response grows. Problem is I want to read a row in table (last) or…

---

## [Change node not working as expected!](https://discourse.nodered.org/t/change-node-not-working-as-expected/54011)

<div class="topic-metadata">

**Author:** [@Paul-Reed](https://discourse.nodered.org/u/Paul-Reed)\
**Replies:** 29\
**Last updated:** [22 November 2021 09:45 UTC](https://discourse.nodered.org/t/change-node-not-working-as-expected/54011 "2021-11-22T09:45:22Z")

</div>

It's been a long day, so this could be something stupid, so I'll apologise first! I have an output from a node-red-contrib-google-smarthome node; object topic: "" device\_name: "driveway alert" command: "OnOff" params:…

---

## [Worldmap and KML data](https://discourse.nodered.org/t/worldmap-and-kml-data/54076)

<div class="topic-metadata">

**Author:** [@aa0z](https://discourse.nodered.org/u/aa0z)\
**Replies:** 3\
**Last updated:** [22 November 2021 09:30 UTC](https://discourse.nodered.org/t/worldmap-and-kml-data/54076 "2021-11-22T09:30:20Z")

</div>

I'm having some trouble displaying KML data on the Worldmap. Here is my payload.command.map data. I got this data off the US census website and copied the raw KML data for Missouri. I'm probably not providing enough c…

---

## [SeeeD SenseCAP LoRaWAN CO2 Sensor function to emoncms](https://discourse.nodered.org/t/seeed-sensecap-lorawan-co2-sensor-function-to-emoncms/54014)

<div class="topic-metadata">

**Author:** [@bgrattan3](https://discourse.nodered.org/u/bgrattan3)\
**Replies:** 20\
**Last updated:** [22 November 2021 08:47 UTC](https://discourse.nodered.org/t/seeed-sensecap-lorawan-co2-sensor-function-to-emoncms/54014 "2021-11-22T08:47:02Z")

</div>

Hello, I am not a programmer and am having lots of problems getting this sensor data into my emoncms server. The sensor seems to be working correctly and sending LoRa data to my RAK7244 server/gateway. I have four LoRa …

---

## [Can't upload some values to MSSQL](https://discourse.nodered.org/t/cant-upload-some-values-to-mssql/53931)

<div class="topic-metadata">

**Author:** [@evanic14](https://discourse.nodered.org/u/evanic14)\
**Replies:** 16\
**Last updated:** [22 November 2021 08:31 UTC](https://discourse.nodered.org/t/cant-upload-some-values-to-mssql/53931 "2021-11-22T08:31:37Z")

</div>

hi, when i try to upload a value to my database I get this message in my debug window: RequestError: Could not find stored procedure 'true'. has anyone got a idea?

---

## [How to create sequential files with Advanced FTP logger?](https://discourse.nodered.org/t/how-to-create-sequential-files-with-advanced-ftp-logger/54083)

<div class="topic-metadata">

**Author:** [@WEA](https://discourse.nodered.org/u/WEA)\
**Replies:** 0\
**Last updated:** [22 November 2021 00:11 UTC](https://discourse.nodered.org/t/how-to-create-sequential-files-with-advanced-ftp-logger/54083 "2021-11-22T00:11:56Z")

</div>

How do I generate files with sequential numbers using? When the file is generated, it is fixed at zero!

---

## [Past time of the last sensor update in minutes](https://discourse.nodered.org/t/past-time-of-the-last-sensor-update-in-minutes/51517)

<div class="topic-metadata">

**Author:** [@Learn](https://discourse.nodered.org/u/Learn)\
**Replies:** 5\
**Last updated:** [21 November 2021 20:48 UTC](https://discourse.nodered.org/t/past-time-of-the-last-sensor-update-in-minutes/51517 "2021-11-21T20:48:56Z")

</div>

Hello I would like to display in the dasboard of my Zigbee sensor the past time of the last sensor update in minutes. Theoretically, I only need to send a timestamp when receiving a measured value. But how can I convert…

---

## [Call .js scripts in function node](https://discourse.nodered.org/t/call-js-scripts-in-function-node/54078)

<div class="topic-metadata">

**Author:** [@metter](https://discourse.nodered.org/u/metter)\
**Replies:** 0\
**Last updated:** [21 November 2021 19:41 UTC](https://discourse.nodered.org/t/call-js-scripts-in-function-node/54078 "2021-11-21T19:41:30Z")

</div>

I use node red for a while now, not very solid in programming yet. Now I have a principal question: I run node red in docker on a ubuntu server. I would to play around with tensorflow and found an example on github th…

---

## [FTP Download - Downloads Repeatedly](https://discourse.nodered.org/t/ftp-download-downloads-repeatedly/53876)

<div class="topic-metadata">

**Author:** [@RichdeCrep](https://discourse.nodered.org/u/RichdeCrep)\
**Replies:** 6\
**Last updated:** [21 November 2021 18:05 UTC](https://discourse.nodered.org/t/ftp-download-downloads-repeatedly/53876 "2021-11-21T18:05:18Z")

</div>

Hello, may I ask for someone to help me please. I am trying to FTP download a file from a server, using the "node-red-contrib-ftp-download" node. The file downloads, but it downloads many (continuously) times until th…

---

## [How to add a remote control to nodered](https://discourse.nodered.org/t/how-to-add-a-remote-control-to-nodered/54067)

<div class="topic-metadata">

**Author:** [@jabss](https://discourse.nodered.org/u/jabss)\
**Replies:** 1\
**Last updated:** [21 November 2021 16:43 UTC](https://discourse.nodered.org/t/how-to-add-a-remote-control-to-nodered/54067 "2021-11-21T16:43:55Z")

</div>

Hi, Not sure what am I doing wrong. This should be pretty straightforward but I'm blocked for two days now... I have IoTStack on a RPI4 with zigbee2MQTT --\> MQTT --\> NodeRed working fine. I can confirm this because I…

---

## [Svg Icon increase click area](https://discourse.nodered.org/t/svg-icon-increase-click-area/54062)

<div class="topic-metadata">

**Author:** [@edje11](https://discourse.nodered.org/u/edje11)\
**Replies:** 5\
**Last updated:** [21 November 2021 16:42 UTC](https://discourse.nodered.org/t/svg-icon-increase-click-area/54062 "2021-11-21T16:42:26Z")

</div>

Is it possible to increase the click area of an icon in the svg node? The problem now is that for example in the film icon the click event only occurs when clicking on the black lines of the icon, clicking on the grey p…

---

## [Unable to start Node-red upon boot](https://discourse.nodered.org/t/unable-to-start-node-red-upon-boot/17353)

<div class="topic-metadata">

**Author:** [@iDeeW](https://discourse.nodered.org/u/iDeeW)\
**Replies:** 88\
**Last updated:** [21 November 2021 15:03 UTC](https://discourse.nodered.org/t/unable-to-start-node-red-upon-boot/17353 "2021-11-21T15:03:21Z")

</div>

I'm trying to autorun Node-red on a laptop running Ubuntu 18.04.3 LTS Bionic. I followed below web page... "node-red" command works. But I can get Node-red to run on boot! Can anyone help me troubleshoot this, ple…

---

## [Electric Blanket Preheat Control Ideas Wanted](https://discourse.nodered.org/t/electric-blanket-preheat-control-ideas-wanted/52681)

<div class="topic-metadata">

**Author:** [@Randy](https://discourse.nodered.org/u/Randy)\
**Replies:** 11\
**Last updated:** [21 November 2021 14:49 UTC](https://discourse.nodered.org/t/electric-blanket-preheat-control-ideas-wanted/52681 "2021-11-21T14:49:50Z")

</div>

It's that time of year again when jumping into a cold bed will keep you awake for awhile. I'm looking for suggestions to send a momentary pulse to activate a relay to turn ON the controller. Then after that with a seco…

---

## [I need to read the persistent data and combine it into a single piece of text](https://discourse.nodered.org/t/i-need-to-read-the-persistent-data-and-combine-it-into-a-single-piece-of-text/54064)

<div class="topic-metadata">

**Author:** [@Cybertron](https://discourse.nodered.org/u/Cybertron)\
**Replies:** 8\
**Last updated:** [21 November 2021 14:08 UTC](https://discourse.nodered.org/t/i-need-to-read-the-persistent-data-and-combine-it-into-a-single-piece-of-text/54064 "2021-11-21T14:08:55Z")

</div>

Hello, as shown in the picture I want to read them out and arrange them into a text The format looks like this: {"a": load\_\_v data, "b": fan\_v data, "c": fan\_A data} And so on I tried a lot of things but couldn't …

---

## [Extract mqtt topic json](https://discourse.nodered.org/t/extract-mqtt-topic-json/54026)

<div class="topic-metadata">

**Author:** [@trombose009](https://discourse.nodered.org/u/trombose009)\
**Replies:** 17\
**Last updated:** [21 November 2021 08:45 UTC](https://discourse.nodered.org/t/extract-mqtt-topic-json/54026 "2021-11-21T08:45:46Z")

</div>

Hey guys, I am using node-red to extract a mqtt message to write the values into influxdb. It works very well and looks like this: let thisRoom = msg.topic.split("/")\[2\] msg.payload = \[{temp: msg.payload.temp, hum: ms…

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

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