# General

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

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

**Page:** 828

---

## [OTA Updates via LoRa (TTN) with ESP32/ESP8266](https://discourse.nodered.org/t/ota-updates-via-lora-ttn-with-esp32-esp8266/17837)

<div class="topic-metadata">

**Author:** [@Faze91](https://discourse.nodered.org/u/Faze91)\
**Replies:** 2\
**Last updated:** [12 November 2019 19:18 UTC](https://discourse.nodered.org/t/ota-updates-via-lora-ttn-with-esp32-esp8266/17837 "2019-11-12T19:18:39Z")

</div>

How can I do an OTA update with node-red via LoRa (over The Things Network) with an ESP32? This topic does not help me: https://discourse.nodered.org/t/does-node-red-supports-over-the-air-ota-update/4674 I can already …

---

## [Combine messages in different subflows](https://discourse.nodered.org/t/combine-messages-in-different-subflows/17650)

<div class="topic-metadata">

**Author:** [@pvanklink](https://discourse.nodered.org/u/pvanklink)\
**Replies:** 7\
**Last updated:** [12 November 2019 18:07 UTC](https://discourse.nodered.org/t/combine-messages-in-different-subflows/17650 "2019-11-12T18:07:01Z")

</div>

Hi, i made a ping flow that works great. Each ping sends a message to domoticz and domoticz puts a device on or off ... No problems in the existing flow. I want to send one message for all my pings and not xxxx messa…

---

## [Google Oauth2 Config](https://discourse.nodered.org/t/google-oauth2-config/13798)

<div class="topic-metadata">

**Author:** [@danleighton](https://discourse.nodered.org/u/danleighton)\
**Replies:** 6\
**Last updated:** [12 November 2019 17:32 UTC](https://discourse.nodered.org/t/google-oauth2-config/13798 "2019-11-12T17:32:43Z")

</div>

I am currently trying to configure the discovery api using the https://github.com/pckhib/node-red-contrib-google-oauth2 node. Everything is working just fine, until I try to use the Dynamic (msg.operation) functionality…

---

## [Safely inject SQL](https://discourse.nodered.org/t/safely-inject-sql/17831)

<div class="topic-metadata">

**Author:** [@Meng](https://discourse.nodered.org/u/Meng)\
**Replies:** 4\
**Last updated:** [12 November 2019 14:35 UTC](https://discourse.nodered.org/t/safely-inject-sql/17831 "2019-11-12T14:35:17Z")

</div>

How do I safely inject SQL queries in node red. I want to start with: function addPost(body, username) { return db.query( INSERT INTO posts (body, username) VALUES (?, ?) , \[body, username\], ); } H…

---

## [Stored Variables vs messages](https://discourse.nodered.org/t/stored-variables-vs-messages/17835)

<div class="topic-metadata">

**Author:** [@mudwalker](https://discourse.nodered.org/u/mudwalker)\
**Replies:** 3\
**Last updated:** [12 November 2019 14:22 UTC](https://discourse.nodered.org/t/stored-variables-vs-messages/17835 "2019-11-12T14:22:31Z")

</div>

Hi, I am after some advice/help. I have searched various terms and can't find what I am looking for, probably using wrong terms, but here goes! Does passing messages between nodes cost any extra resources, or is it be…

---

## [Http request problem](https://discourse.nodered.org/t/http-request-problem/17791)

<div class="topic-metadata">

**Author:** [@tzeeth](https://discourse.nodered.org/u/tzeeth)\
**Replies:** 5\
**Last updated:** [12 November 2019 08:57 UTC](https://discourse.nodered.org/t/http-request-problem/17791 "2019-11-12T08:57:35Z")

</div>

Hi Node-Red community, I have a problem that I do not find how to solve it. I am getting some variables from my server joining them into a msg.payload and then trying to send via HTTP request but the server does not res…

---

## [Printing an array to node-red text dashboard node](https://discourse.nodered.org/t/printing-an-array-to-node-red-text-dashboard-node/17801)

<div class="topic-metadata">

**Author:** [@redlop](https://discourse.nodered.org/u/redlop)\
**Replies:** 20\
**Last updated:** [12 November 2019 07:56 UTC](https://discourse.nodered.org/t/printing-an-array-to-node-red-text-dashboard-node/17801 "2019-11-12T07:56:33Z")

</div>

Hi. Im currently working on a project that scans for networks, as of now i've made it print the networks all at the same time. My problem is that I can't send the data into node-red via text node. It gives me an error th…

---

## [Manage Palette Is Missing](https://discourse.nodered.org/t/manage-palette-is-missing/11876)

<div class="topic-metadata">

**Author:** [@tarihoran20](https://discourse.nodered.org/u/tarihoran20)\
**Replies:** 29\
**Last updated:** [12 November 2019 06:08 UTC](https://discourse.nodered.org/t/manage-palette-is-missing/11876 "2019-11-12T06:08:59Z")

</div>

Hi, i'm new in node-red. a few days ago i want to install some palette but can't find the option "Manage Palette" on the menu. does anybody know how to solved the problem ? thank you

---

## [Human readable time to mysql](https://discourse.nodered.org/t/human-readable-time-to-mysql/17689)

<div class="topic-metadata">

**Author:** [@moment](https://discourse.nodered.org/u/moment)\
**Replies:** 10\
**Last updated:** [11 November 2019 22:18 UTC](https://discourse.nodered.org/t/human-readable-time-to-mysql/17689 "2019-11-11T22:18:14Z")

</div>

i'm using interval node and inserting data to mysql ,everything works if i insert the time in milliseconds... i want to insert it directly into human readable form, the interval node outputs the human readable as 1m 30…

---

## [Node-red ne démarre plus](https://discourse.nodered.org/t/node-red-ne-demarre-plus/17794)

<div class="topic-metadata">

**Author:** [@antoine](https://discourse.nodered.org/u/antoine)\
**Replies:** 10\
**Last updated:** [11 November 2019 21:06 UTC](https://discourse.nodered.org/t/node-red-ne-demarre-plus/17794 "2019-11-11T21:06:28Z")

</div>

bonjour, Node-red ne démarre plus. node-red-log:

---

## [Need help temporary payload](https://discourse.nodered.org/t/need-help-temporary-payload/17803)

<div class="topic-metadata">

**Author:** [@m\_elias](https://discourse.nodered.org/u/m_elias)\
**Replies:** 1\
**Last updated:** [11 November 2019 21:05 UTC](https://discourse.nodered.org/t/need-help-temporary-payload/17803 "2019-11-11T21:05:46Z")

</div>

I have a TCP input node triggering a flow once per second with data from a load cell weigh scale. I'd like to output that payload to a TCP output node (remote display) continuously except when certain conditions are met …

---

## [Sun Events Node](https://discourse.nodered.org/t/sun-events-node/17615)

<div class="topic-metadata">

**Author:** [@budlyte](https://discourse.nodered.org/u/budlyte)\
**Replies:** 2\
**Last updated:** [11 November 2019 18:23 UTC](https://discourse.nodered.org/t/sun-events-node/17615 "2019-11-11T18:23:22Z")

</div>

running hassio node red 5.0.3. sun events node has been working to turn lights on at sunset for at least a year. After updating to 5.0.3 no sun events are generated. Also noted that when node red starts it shows all e…

---

## [Capture complete msg to a global.property](https://discourse.nodered.org/t/capture-complete-msg-to-a-global-property/3168)

<div class="topic-metadata">

**Author:** [@cymplecy](https://discourse.nodered.org/u/cymplecy)\
**Replies:** 13\
**Last updated:** [11 November 2019 16:52 UTC](https://discourse.nodered.org/t/capture-complete-msg-to-a-global-property/3168 "2019-11-11T16:52:47Z")

</div>

I feel this is dead simpe but my minds gone blank I want to capture a complete msg object to re-use it for debugging purposes in another flow So I thought - lets send it to global.whole And then I thought - em - how …

---

## [Need help with Delay node](https://discourse.nodered.org/t/need-help-with-delay-node/17798)

<div class="topic-metadata">

**Author:** [@birdbrain2734](https://discourse.nodered.org/u/birdbrain2734)\
**Replies:** 3\
**Last updated:** [11 November 2019 15:20 UTC](https://discourse.nodered.org/t/need-help-with-delay-node/17798 "2019-11-11T15:20:23Z")

</div>

I have searched through the forum but have not found what I am after. I want to read a CSV, parse it and use its data to simulate a sequence of activities to a time-series database. Each line of the CSV includes a dela…

---

## [Node-Red buffer](https://discourse.nodered.org/t/node-red-buffer/17727)

<div class="topic-metadata">

**Author:** [@New2Node](https://discourse.nodered.org/u/New2Node)\
**Replies:** 4\
**Last updated:** [11 November 2019 13:27 UTC](https://discourse.nodered.org/t/node-red-buffer/17727 "2019-11-11T13:27:29Z")

</div>

Hi, I’m new to Node-Red so I’m just working my way through all the various nodes. I want to use Node-Red to read an Electricity meter which uses IEC 62056-21 protocol. I have the meter connected over RS232, if I use the…

---

## [Mot de passe qui ne marche pas](https://discourse.nodered.org/t/mot-de-passe-qui-ne-marche-pas/17757)

<div class="topic-metadata">

**Author:** [@antoine](https://discourse.nodered.org/u/antoine)\
**Replies:** 7\
**Last updated:** [11 November 2019 11:38 UTC](https://discourse.nodered.org/t/mot-de-passe-qui-ne-marche-pas/17757 "2019-11-11T11:38:34Z")

</div>

Bonjour, J'ai parmetrer le fichier settings.js pour mettre un utilisateur et un mot de passe mais cela ne marche pas quand je veut me connecter. Pouvez-vous M'aider Merci.

---

## [Send Array with serial out](https://discourse.nodered.org/t/send-array-with-serial-out/17558)

<div class="topic-metadata">

**Author:** [@alpha9](https://discourse.nodered.org/u/alpha9)\
**Replies:** 2\
**Last updated:** [11 November 2019 09:56 UTC](https://discourse.nodered.org/t/send-array-with-serial-out/17558 "2019-11-11T09:56:46Z")

</div>

Hello everyone I'm trying to send a buffer or array, created in a function-block, with the serial-out-block. The problem now is, that the array is sent within the message.payload information. So the array-information a…

---

## [How to display list of files in current date](https://discourse.nodered.org/t/how-to-display-list-of-files-in-current-date/17764)

<div class="topic-metadata">

**Author:** [@clique](https://discourse.nodered.org/u/clique)\
**Replies:** 2\
**Last updated:** [11 November 2019 08:36 UTC](https://discourse.nodered.org/t/how-to-display-list-of-files-in-current-date/17764 "2019-11-11T08:36:35Z")

</div>

Hi. I want to ask how can I display list of files in current date ??

---

## [Iobroker node red, failed to open vchiq instance](https://discourse.nodered.org/t/iobroker-node-red-failed-to-open-vchiq-instance/17759)

<div class="topic-metadata">

**Author:** [@maku12](https://discourse.nodered.org/u/maku12)\
**Replies:** 1\
**Last updated:** [11 November 2019 08:33 UTC](https://discourse.nodered.org/t/iobroker-node-red-failed-to-open-vchiq-instance/17759 "2019-11-11T08:33:57Z")

</div>

Hi, I'm using raspbian strech lite and running a node red instance in iobroker. When i try an exec node with a simple raspistill command I get following error: failed to open vchiq instance manyThanks for help

---

## [Insert Query in postgre not working](https://discourse.nodered.org/t/insert-query-in-postgre-not-working/17779)

<div class="topic-metadata">

**Author:** [@pranavthakkar](https://discourse.nodered.org/u/pranavthakkar)\
**Replies:** 9\
**Last updated:** [11 November 2019 07:38 UTC](https://discourse.nodered.org/t/insert-query-in-postgre-not-working/17779 "2019-11-11T07:38:07Z")

</div>

Hello there , Greetings ! I' working on Postgresql and I want to insert the query into it but it is not inserting into it. This is syntax of query This is flow, and this is pgadmin table

---

## [Need help in writing Multiple message outputs to a columns in single excel file](https://discourse.nodered.org/t/need-help-in-writing-multiple-message-outputs-to-a-columns-in-single-excel-file/17766)

<div class="topic-metadata">

**Author:** [@farishsn](https://discourse.nodered.org/u/farishsn)\
**Replies:** 2\
**Last updated:** [11 November 2019 05:16 UTC](https://discourse.nodered.org/t/need-help-in-writing-multiple-message-outputs-to-a-columns-in-single-excel-file/17766 "2019-11-11T05:16:13Z")

</div>

Hi guys Please help me to write multiple outputs to columns in an excel file. What I'm trying to do is get stock market data of a company and its changes with respect to time in to an excel file. I don't know how to wri…

---

## [Settings.js corrupted](https://discourse.nodered.org/t/settings-js-corrupted/17755)

<div class="topic-metadata">

**Author:** [@antoine](https://discourse.nodered.org/u/antoine)\
**Replies:** 2\
**Last updated:** [10 November 2019 20:54 UTC](https://discourse.nodered.org/t/settings-js-corrupted/17755 "2019-11-10T20:54:24Z")

</div>

Bonjour, mon fichier settings.js comporte beaucoup d'erreurs et empèche node red de démarrer . Quelqu'un en a un vierge a me passer s'il vous plait. merci d'avance.

---

## [\[Solved\] Join several object messages to one object message?](https://discourse.nodered.org/t/solved-join-several-object-messages-to-one-object-message/17745)

<div class="topic-metadata">

**Author:** [@skom](https://discourse.nodered.org/u/skom)\
**Replies:** 4\
**Last updated:** [10 November 2019 20:52 UTC](https://discourse.nodered.org/t/solved-join-several-object-messages-to-one-object-message/17745 "2019-11-10T20:52:51Z")

</div>

I have several messages of type {msg: Object object value1: "v1" value2: "v2" value3: "v3" value4: "v4" \_msgid: "xxxx"} and I would like to combine them into one array msg \[0\]: value1: " v1 "value2:" v2 "value3:" v3 "val…

---

## [Access my dashboard from the Internet](https://discourse.nodered.org/t/access-my-dashboard-from-the-internet/17746)

<div class="topic-metadata">

**Author:** [@oscaha](https://discourse.nodered.org/u/oscaha)\
**Replies:** 2\
**Last updated:** [10 November 2019 20:24 UTC](https://discourse.nodered.org/t/access-my-dashboard-from-the-internet/17746 "2019-11-10T20:24:45Z")

</div>

Hi everybody. Thanks for your attention. I'm beginner in node red .I've made a project and I can monitor and control my system from a local dashboard.I want now to access to my dashboard over the internet (not only by…

---

## [Help with email Node](https://discourse.nodered.org/t/help-with-email-node/17748)

<div class="topic-metadata">

**Author:** [@DillonW](https://discourse.nodered.org/u/DillonW)\
**Replies:** 4\
**Last updated:** [10 November 2019 20:10 UTC](https://discourse.nodered.org/t/help-with-email-node/17748 "2019-11-10T20:10:25Z")

</div>

Hi, I am trying to use the email nodes, but I'm having trouble using the USERID and password settings required. Does this use the Node-Red application username and the google's password? I'm getting the following error, …

---

## [Problem with install DHT plugin on win10](https://discourse.nodered.org/t/problem-with-install-dht-plugin-on-win10/17715)

<div class="topic-metadata">

**Author:** [@ZdendaB](https://discourse.nodered.org/u/ZdendaB)\
**Replies:** 6\
**Last updated:** [10 November 2019 18:55 UTC](https://discourse.nodered.org/t/problem-with-install-dht-plugin-on-win10/17715 "2019-11-10T18:55:33Z")

</div>

Hello , i dont install DHT plugins . If i run install from pallete in node-red so it appears this error. please help

---

## [HTTP request in node-Red](https://discourse.nodered.org/t/http-request-in-node-red/17749)

<div class="topic-metadata">

**Author:** [@osstynd](https://discourse.nodered.org/u/osstynd)\
**Replies:** 6\
**Last updated:** [10 November 2019 17:33 UTC](https://discourse.nodered.org/t/http-request-in-node-red/17749 "2019-11-10T17:33:46Z")

</div>

Hi, I am having a very simple issue. I am trying to check upon the status of my Daikin Aircon. When I enter the following in a Chrome web browser: 10.10.10.50/aircon/get\_sensor\_info I get following response: ret=OK…

---

## [toLocaleString not working h24 - Italy](https://discourse.nodered.org/t/tolocalestring-not-working-h24-italy/13134)

<div class="topic-metadata">

**Author:** [@Lupin\_III](https://discourse.nodered.org/u/Lupin_III)\
**Replies:** 7\
**Last updated:** [10 November 2019 17:29 UTC](https://discourse.nodered.org/t/tolocalestring-not-working-h24-italy/13134 "2019-11-10T17:29:37Z")

</div>

Hi, I'm running node-red V0.20.6 on a raspberry pi 3 with stretch. My country is Italy. I need to have date like "2019-07-11 22:15:36". For this I used in a function node the toLocaleString() command . Running the flow …

---

## [Set value over http-request](https://discourse.nodered.org/t/set-value-over-http-request/17723)

<div class="topic-metadata">

**Author:** [@easyE4](https://discourse.nodered.org/u/easyE4)\
**Replies:** 7\
**Last updated:** [10 November 2019 10:14 UTC](https://discourse.nodered.org/t/set-value-over-http-request/17723 "2019-11-10T10:14:29Z")

</div>

Hi guys, if I use this http-request behind an slider-node everything working fine. If I use a this this function-code to make the url it doesn't work. I don't know why, because in other functions like this it w…

---

## [Docker mosquitto.conf](https://discourse.nodered.org/t/docker-mosquitto-conf/17712)

<div class="topic-metadata">

**Author:** [@M-a-r-k](https://discourse.nodered.org/u/M-a-r-k)\
**Replies:** 3\
**Last updated:** [10 November 2019 01:05 UTC](https://discourse.nodered.org/t/docker-mosquitto-conf/17712 "2019-11-10T01:05:03Z")

</div>

Does anyone know how to edit and save the mosquitto.conf file in docker. i need to run docker as stjohnjohnson/smartthings-mqtt-bridge wont run in raspbian RPi4 on it own, well i cant get it to run anyway, been on this f…

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

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