# Latest

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

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

**Page:** 1186

---

## [Current state node](https://discourse.nodered.org/t/current-state-node/19338)

<div class="topic-metadata">

**Author:** [@yabbah](https://discourse.nodered.org/u/yabbah)\
**Replies:** 1\
**Last updated:** [19 December 2019 14:43 UTC](https://discourse.nodered.org/t/current-state-node/19338 "2019-12-19T14:43:48Z")

</div>

Hi out there. I'm new to Node-Red but I try learning. I have try figure out how to check if a state is not Home or Just arrived. I have tried use a node for home assistant which is current state mode, and filter on if st…

---

## [How does a TCP out node work when it is set to listen to a port?](https://discourse.nodered.org/t/how-does-a-tcp-out-node-work-when-it-is-set-to-listen-to-a-port/14909)

<div class="topic-metadata">

**Author:** [@Gnamra](https://discourse.nodered.org/u/Gnamra)\
**Replies:** 7\
**Last updated:** [16 December 2019 17:36 UTC](https://discourse.nodered.org/t/how-does-a-tcp-out-node-work-when-it-is-set-to-listen-to-a-port/14909 "2019-12-16T17:36:08Z")

</div>

I am currently trying to understand a system designed in Node-RED. There is a "master" raspberry pi and a "slave" raspberry pi. In the "master" portion of the system, I have identified a TCP in node that points to the sl…

---

## [Extract \_Session](https://discourse.nodered.org/t/extract-session/19311)

<div class="topic-metadata">

**Author:** [@New2Node](https://discourse.nodered.org/u/New2Node)\
**Replies:** 5\
**Last updated:** [19 December 2019 13:23 UTC](https://discourse.nodered.org/t/extract-session/19311 "2019-12-19T13:23:59Z")

</div>

Hi, I'm trying to extract the msg.\_session property from Msg.payload1 and combine it with a MQTT message (Msg.payload 2) to direct the MQTT messgae to the origin TCP port. I've found that using the MQTT node changes the …

---

## [Sort Array of objects by unix timestamp](https://discourse.nodered.org/t/sort-array-of-objects-by-unix-timestamp/17016)

<div class="topic-metadata">

**Author:** [@Rtholl](https://discourse.nodered.org/u/Rtholl)\
**Replies:** 7\
**Last updated:** [19 December 2019 09:50 UTC](https://discourse.nodered.org/t/sort-array-of-objects-by-unix-timestamp/17016 "2019-12-19T09:50:39Z")

</div>

Hey guys, I'm storing sensor data in a Cloudant DB. Every document consists of the 63 sensor values and a unix timestamp. When querying all the documents from the DB, I realized that those documents are not chronologica…

---

## [Post an parsed Mail-Attachment to API](https://discourse.nodered.org/t/post-an-parsed-mail-attachment-to-api/19334)

<div class="topic-metadata">

**Author:** [@xstable](https://discourse.nodered.org/u/xstable)\
**Replies:** 0\
**Last updated:** [19 December 2019 09:17 UTC](https://discourse.nodered.org/t/post-an-parsed-mail-attachment-to-api/19334 "2019-12-19T09:17:01Z")

</div>

Hey, I've done my first steps with Node Red and got some experiences with it. But now I stuck on the Problem, that the file won't be send to the API. It seems the File-Content is missing. But let's start from the beg…

---

## [Chart.js Datalabel Plugin Implementation Problem in ui\_template](https://discourse.nodered.org/t/chart-js-datalabel-plugin-implementation-problem-in-ui-template/19332)

<div class="topic-metadata">

**Author:** [@sesenlik](https://discourse.nodered.org/u/sesenlik)\
**Replies:** 0\
**Last updated:** [19 December 2019 08:57 UTC](https://discourse.nodered.org/t/chart-js-datalabel-plugin-implementation-problem-in-ui-template/19332 "2019-12-19T08:57:32Z")

</div>

Hello everyone, What I am trying to achieve is to display the values of graph data on my bar chart. In order to do that I am using chart.js implemented on an ui\_template node. There is a chartjs plugin for displaying d…

---

## [Node-Red crashes due to memory leak](https://discourse.nodered.org/t/node-red-crashes-due-to-memory-leak/18679)

<div class="topic-metadata">

**Author:** [@Tankfuzz](https://discourse.nodered.org/u/Tankfuzz)\
**Replies:** 11\
**Last updated:** [19 December 2019 06:39 UTC](https://discourse.nodered.org/t/node-red-crashes-due-to-memory-leak/18679 "2019-12-19T06:39:35Z")

</div>

Hello! I hope I get can some help in solving this problem I have with Node-Red! Up till 3 weeks ago, I was running Node-Red V0.2.x perfectly on my Raspberry Pi4 without any problems. However, after that, the terminal I…

---

## [Am I using the right program/hardware?](https://discourse.nodered.org/t/am-i-using-the-right-program-hardware/16174)

<div class="topic-metadata">

**Author:** [@kylebritain](https://discourse.nodered.org/u/kylebritain)\
**Replies:** 25\
**Last updated:** [18 December 2019 20:07 UTC](https://discourse.nodered.org/t/am-i-using-the-right-program-hardware/16174 "2019-12-18T20:07:59Z")

</div>

Hello all! I'll get right to it. I am trying to wirelessly control under cabinet LED strips for a kitchen. There is a white strip, and a blue strip. The kitchen is separated in 2 sections so I cant wire them all to the …

---

## [HTTP REQUEST basic auth broken?](https://discourse.nodered.org/t/http-request-basic-auth-broken/19319)

<div class="topic-metadata">

**Author:** [@i8beef](https://discourse.nodered.org/u/i8beef)\
**Replies:** 0\
**Last updated:** [18 December 2019 19:51 UTC](https://discourse.nodered.org/t/http-request-basic-auth-broken/19319 "2019-12-18T19:51:19Z")

</div>

Hello. Having some odd behavior with the HTTP REQUEST node in 1.0.3 (i.e., the one that makes requests, not answers them). Basic auth doesn't seem to work, though I can easily generate a basic auth string and manually g…

---

## [RED.nodes.getNode fails to find node](https://discourse.nodered.org/t/red-nodes-getnode-fails-to-find-node/19235)

<div class="topic-metadata">

**Author:** [@magothe](https://discourse.nodered.org/u/magothe)\
**Replies:** 2\
**Last updated:** [18 December 2019 17:50 UTC](https://discourse.nodered.org/t/red-nodes-getnode-fails-to-find-node/19235 "2019-12-18T17:50:07Z")

</div>

I have two custom nodes in my flow: an "OccupancyTrigger" node, and a configuration node named "schedule". The OccupancyTrigger node uses schedule to detemine when it should be enabled. I want the schedule node to comm…

---

## [Stoping block "function"](https://discourse.nodered.org/t/stoping-block-function/19259)

<div class="topic-metadata">

**Author:** [@HDM](https://discourse.nodered.org/u/HDM)\
**Replies:** 2\
**Last updated:** [18 December 2019 15:43 UTC](https://discourse.nodered.org/t/stoping-block-function/19259 "2019-12-18T15:43:09Z")

</div>

Good afternoon I in block "function" wrote code with function "while" after start looped how to stop or delete this block "function" Thanks

---

## [Uibuilder - remove listeners for .onChange](https://discourse.nodered.org/t/uibuilder-remove-listeners-for-onchange/19212)

<div class="topic-metadata">

**Author:** [@famouspotatoes1](https://discourse.nodered.org/u/famouspotatoes1)\
**Replies:** 3\
**Last updated:** [18 December 2019 15:40 UTC](https://discourse.nodered.org/t/uibuilder-remove-listeners-for-onchange/19212 "2019-12-18T15:40:27Z")

</div>

I have been using uibuilder to create an app and first I want to say, thank you for developing this great tool! I have run into an issue where my app, which is a single page app using vue-router, is continuing to make c…

---

## [SQLite question](https://discourse.nodered.org/t/sqlite-question/2434)

<div class="topic-metadata">

**Author:** [@zubenubi](https://discourse.nodered.org/u/zubenubi)\
**Replies:** 41\
**Last updated:** [18 December 2019 14:29 UTC](https://discourse.nodered.org/t/sqlite-question/2434 "2019-12-18T14:29:09Z")

</div>

I am using node-red-node-sqlite to connect to a sqlite3 db. I need to load a sqlite extension prior to submitting a select. When I do this at the command line, it seems to work ok: select load\_extension('mod\_spatialite…

---

## [How to get value from Payload array and send by SQL?](https://discourse.nodered.org/t/how-to-get-value-from-payload-array-and-send-by-sql/19298)

<div class="topic-metadata">

**Author:** [@everton\_aparecido](https://discourse.nodered.org/u/everton_aparecido)\
**Replies:** 0\
**Last updated:** [18 December 2019 11:51 UTC](https://discourse.nodered.org/t/how-to-get-value-from-payload-array-and-send-by-sql/19298 "2019-12-18T11:51:42Z")

</div>

I have a array with some values, I need to get this and send by SQL to Postgres DataBase. Please, somebody can help me how I make this? I'm new on NODE Red World. Thank you. See the image about array and my actual flo…

---

## [Problem when trying to run node-red from sources](https://discourse.nodered.org/t/problem-when-trying-to-run-node-red-from-sources/19286)

<div class="topic-metadata">

**Author:** [@dsl400](https://discourse.nodered.org/u/dsl400)\
**Replies:** 9\
**Last updated:** [18 December 2019 11:49 UTC](https://discourse.nodered.org/t/problem-when-trying-to-run-node-red-from-sources/19286 "2019-12-18T11:49:11Z")

</div>

I ran into a bit of an issue while trying to run node-red from sources. Any help will be highly appreciated :slight\_smile: fs-ext\\fs-ext.cc(195,31): error C3861: 'fcntl': identifier not found gyp ERR! build error gyp …

---

## [Connect to remote mySQL and HTTP get fail](https://discourse.nodered.org/t/connect-to-remote-mysql-and-http-get-fail/19221)

<div class="topic-metadata">

**Author:** [@Alban\_T](https://discourse.nodered.org/u/Alban_T)\
**Replies:** 3\
**Last updated:** [18 December 2019 08:08 UTC](https://discourse.nodered.org/t/connect-to-remote-mysql-and-http-get-fail/19221 "2019-12-18T08:08:53Z")

</div>

Hi, I have 2 questions but I suspect they are related. Hopefully someone here can explain to me what is happening. I have Node Red on my Siemens IOT2040 and I want to sent data to my website (mySQL). I tried the mySQL…

---

## [Error: Pool is not a constructor](https://discourse.nodered.org/t/error-pool-is-not-a-constructor/19163)

<div class="topic-metadata">

**Author:** [@nrnoob](https://discourse.nodered.org/u/nrnoob)\
**Replies:** 7\
**Last updated:** [18 December 2019 08:14 UTC](https://discourse.nodered.org/t/error-pool-is-not-a-constructor/19163 "2019-12-18T08:14:07Z")

</div>

I am trying to use node-red-contrib-odbc which requires the node-odbc node. I am getting "TypeError: Pool is not a constructor" in this line: this.pool = new Pool(); I am pasting the contents from odbc.js for more cont…

---

## [Migrate from installed 0.19 to dockerized 1.0.3](https://discourse.nodered.org/t/migrate-from-installed-0-19-to-dockerized-1-0-3/19271)

<div class="topic-metadata">

**Author:** [@sebastian](https://discourse.nodered.org/u/sebastian)\
**Replies:** 5\
**Last updated:** [17 December 2019 22:02 UTC](https://discourse.nodered.org/t/migrate-from-installed-0-19-to-dockerized-1-0-3/19271 "2019-12-17T22:02:26Z")

</div>

Can't seem to identify my problem here. I ran NodeRed 0.19.2 so far, which I installed 2 yrs or so ago. I do not remember any details of the installation process and actually the node.js thing is also a black box to me. …

---

## [Error while installing dashboard on raspberry pi](https://discourse.nodered.org/t/error-while-installing-dashboard-on-raspberry-pi/19291)

<div class="topic-metadata">

**Author:** [@Abhi-shah](https://discourse.nodered.org/u/Abhi-shah)\
**Replies:** 1\
**Last updated:** [18 December 2019 06:19 UTC](https://discourse.nodered.org/t/error-while-installing-dashboard-on-raspberry-pi/19291 "2019-12-18T06:19:40Z")

</div>

2019-12-18T05:30:56.235Z Install : node-red-dashboard 2.19.2 2019-12-18T05:30:57.860Z npm install --no-audit --no-update-notifier --save --save-prefix="~" --production node-red-dashboard@2.19.2 2019-12-18T05:31:22.891Z…

---

## [Issues to install sqlite node on PC](https://discourse.nodered.org/t/issues-to-install-sqlite-node-on-pc/19289)

<div class="topic-metadata">

**Author:** [@NODE777](https://discourse.nodered.org/u/NODE777)\
**Replies:** 1\
**Last updated:** [18 December 2019 06:17 UTC](https://discourse.nodered.org/t/issues-to-install-sqlite-node-on-pc/19289 "2019-12-18T06:17:16Z")

</div>

Hi I have node-red running in Windows 10 PC. Running the command npm i --unsafe-perm node-red-sqlite show me following screen; I got only the node sqlitedb but not the node sqlite Any help with that? Thanks in …

---

## [Since version 1.0, Japanese inline input has become difficult to use](https://discourse.nodered.org/t/since-version-1-0-japanese-inline-input-has-become-difficult-to-use/19009)

<div class="topic-metadata">

**Author:** [@utaani](https://discourse.nodered.org/u/utaani)\
**Replies:** 10\
**Last updated:** [18 December 2019 04:37 UTC](https://discourse.nodered.org/t/since-version-1-0-japanese-inline-input-has-become-difficult-to-use/19009 "2019-12-18T04:37:42Z")

</div>

There was no problem in the version before 0.20, but it became 1.0, and it became difficult to use Japanese input with IME in the text area of ​​multi-line input. I guess it is due to the change of the library of the…

---

## [Alexa-Local node](https://discourse.nodered.org/t/alexa-local-node/16273)

<div class="topic-metadata">

**Author:** [@Jasurf](https://discourse.nodered.org/u/Jasurf)\
**Replies:** 2\
**Last updated:** [18 December 2019 02:24 UTC](https://discourse.nodered.org/t/alexa-local-node/16273 "2019-12-18T02:24:59Z")

</div>

It seems as though Amazon has blocked Alexa-Local node from working? However, I still see people downloading this node. Is it working or not? If so, what was the fix? Mine has been down for 3 weeks or so now. :frowni…

---

## [Error when installing dashboard](https://discourse.nodered.org/t/error-when-installing-dashboard/19279)

<div class="topic-metadata">

**Author:** [@henke\_321](https://discourse.nodered.org/u/henke_321)\
**Replies:** 1\
**Last updated:** [17 December 2019 23:14 UTC](https://discourse.nodered.org/t/error-when-installing-dashboard/19279 "2019-12-17T23:14:21Z")

</div>

Hi! HW Raspberry Pi 3 Model B V1,2 Image Rasbian Buster Lite I tried to install node-red-dashboard using manage palette but i it fails. Error log 0 info it worked if it ends with ok 1 verbose cli \[ 1 verbose cli …

---

## [Help: Importing data from multiple CSV to Postgres database](https://discourse.nodered.org/t/help-importing-data-from-multiple-csv-to-postgres-database/19275)

<div class="topic-metadata">

**Author:** [@everton\_aparecido](https://discourse.nodered.org/u/everton_aparecido)\
**Replies:** 0\
**Last updated:** [17 December 2019 20:35 UTC](https://discourse.nodered.org/t/help-importing-data-from-multiple-csv-to-postgres-database/19275 "2019-12-17T20:35:46Z")

</div>

Hey, I need a help. I'm developing a flow to read multiples CSV files and import the data from these files to tables in a Postgres database. However, I'm having trouble getting the values from the array and saving them…

---

## [Wifi Thermostat question](https://discourse.nodered.org/t/wifi-thermostat-question/19122)

<div class="topic-metadata">

**Author:** [@Cormad](https://discourse.nodered.org/u/Cormad)\
**Replies:** 10\
**Last updated:** [16 December 2019 20:19 UTC](https://discourse.nodered.org/t/wifi-thermostat-question/19122 "2019-12-16T20:19:37Z")

</div>

Hey All, Revived my Nodered as I have a requirement that this could assist. I just installed a VisionPro 8000 WIFI Thermostat. I would like to trend the room temperature and found the following Node node-red-contrib-t…

---

## [Use value of variable as name in push operation](https://discourse.nodered.org/t/use-value-of-variable-as-name-in-push-operation/19263)

<div class="topic-metadata">

**Author:** [@bjxevit](https://discourse.nodered.org/u/bjxevit)\
**Replies:** 2\
**Last updated:** [17 December 2019 16:26 UTC](https://discourse.nodered.org/t/use-value-of-variable-as-name-in-push-operation/19263 "2019-12-17T16:26:51Z")

</div>

Is it possible, for the push operation, to use the value of a variable and not the name of the variable, as the attribute name in the object? Example: for (i=1; i\<=5; i++) { msg.options.push({i:i}); } This create t…

---

## [Problems converting String to Buffer](https://discourse.nodered.org/t/problems-converting-string-to-buffer/19256)

<div class="topic-metadata">

**Author:** [@paloky](https://discourse.nodered.org/u/paloky)\
**Replies:** 1\
**Last updated:** [17 December 2019 14:34 UTC](https://discourse.nodered.org/t/problems-converting-string-to-buffer/19256 "2019-12-17T14:34:52Z")

</div>

Hi. I have problems converting String to Buffer array. I receive a TCP (in string mode) with this hexadecimal values "7e f4 0d 00 02 f9 ce f8 5d 14 00 00 7e". If I config TCP to "stream of Buffer" or "Single Buffer" …

---

## [Not getting notifications](https://discourse.nodered.org/t/not-getting-notifications/19248)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 1\
**Last updated:** [17 December 2019 14:32 UTC](https://discourse.nodered.org/t/not-getting-notifications/19248 "2019-12-17T14:32:06Z")

</div>

I posted to this thread: I posted here Yes, I did reply, but only because I looked. But didn't receive a notification.

---

## [Copying user files to new install](https://discourse.nodered.org/t/copying-user-files-to-new-install/17663)

<div class="topic-metadata">

**Author:** [@TheRiddler](https://discourse.nodered.org/u/TheRiddler)\
**Replies:** 9\
**Last updated:** [17 December 2019 14:27 UTC](https://discourse.nodered.org/t/copying-user-files-to-new-install/17663 "2019-12-17T14:27:22Z")

</div>

I am running a Node-RED dashboard on a Raspberry Pi that successfully pings a number of Home Automation devices over time and displays various metrics. All runs OK most of the time but occasionally the Pi craps itself a…

---

## [Cannot install node-red-contrib-oled after upgrade to buster and v1.03](https://discourse.nodered.org/t/cannot-install-node-red-contrib-oled-after-upgrade-to-buster-and-v1-03/19238)

<div class="topic-metadata">

**Author:** [@kenkoknz](https://discourse.nodered.org/u/kenkoknz)\
**Replies:** 1\
**Last updated:** [17 December 2019 12:31 UTC](https://discourse.nodered.org/t/cannot-install-node-red-contrib-oled-after-upgrade-to-buster-and-v1-03/19238 "2019-12-17T12:31:13Z")

</div>

Hi, hardware: pi 3b+ Upgrade to: Raspbian version: buster Node-red version: 1.0.3 Node.js version: 10.15.3 Now cannot install "node-red-contrib-oled" error msg: Failed to install: node-red-contrib-oled Error log …

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

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