# General

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

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

**Page:** 816

---

## [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. …

---

## [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…

---

## [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" …

---

## [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 …

---

## [How to find "who" sent a message?](https://discourse.nodered.org/t/how-to-find-who-sent-a-message/19250)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 9\
**Last updated:** [17 December 2019 09:48 UTC](https://discourse.nodered.org/t/how-to-find-who-sent-a-message/19250 "2019-12-17T09:48:23Z")

</div>

I have a flow which has been working quite happily. I have done a slight edit of the flow and I am noticing that the bigtimer node keeps going to MANUAL OFF. I've put debugging on the input and I am seeing an OFF messa…

---

## [Extracting HTML data from table unable to retrieve more than headers](https://discourse.nodered.org/t/extracting-html-data-from-table-unable-to-retrieve-more-than-headers/18891)

<div class="topic-metadata">

**Author:** [@sim](https://discourse.nodered.org/u/sim)\
**Replies:** 5\
**Last updated:** [17 December 2019 08:55 UTC](https://discourse.nodered.org/t/extracting-html-data-from-table-unable-to-retrieve-more-than-headers/18891 "2019-12-17T08:55:51Z")

</div>

I am extracting data from an html file https://www.vcwatershed.net/fws/reservoir.html. I am successful in getting the "headings" but I am unable to retrieve the rest of the "tr" rows from this file. The html file and the…

---

## [Pick just one value from a MQTT message](https://discourse.nodered.org/t/pick-just-one-value-from-a-mqtt-message/18998)

<div class="topic-metadata">

**Author:** [@Quart666](https://discourse.nodered.org/u/Quart666)\
**Replies:** 25\
**Last updated:** [17 December 2019 08:40 UTC](https://discourse.nodered.org/t/pick-just-one-value-from-a-mqtt-message/18998 "2019-12-17T08:40:18Z")

</div>

Probaly simple for others but I got stuck. I have som esp8266 with tasmota 7.1 and lux meter. I want just the value to be sent to dashboard and MYSQL. The message looks like this: {"Time":"2019-12-10T15:30:16","TSL25…

---

## [Setting up Brainboxes with Node-RED](https://discourse.nodered.org/t/setting-up-brainboxes-with-node-red/19251)

<div class="topic-metadata">

**Author:** [@Unikumet](https://discourse.nodered.org/u/Unikumet)\
**Replies:** 0\
**Last updated:** [17 December 2019 08:46 UTC](https://discourse.nodered.org/t/setting-up-brainboxes-with-node-red/19251 "2019-12-17T08:46:59Z")

</div>

Hi all, I am currently working on a project which involves the use of Brainboxes to control equipment, either by giving them a digital signal to open / close, or using a analogue signal to adjust for instance a valve. F…

---

## [Node Red count problem](https://discourse.nodered.org/t/node-red-count-problem/19244)

<div class="topic-metadata">

**Author:** [@mes41](https://discourse.nodered.org/u/mes41)\
**Replies:** 1\
**Last updated:** [17 December 2019 01:06 UTC](https://discourse.nodered.org/t/node-red-count-problem/19244 "2019-12-17T01:06:43Z")

</div>

Hi, I have a question, and anybody can help me... I'm using a digital input by Raspberry to count the wrist. The count is ok and its' works. The wrists is acummulated whit a counter node and every 30 seconds, the count…

---

## [Updating Node.js to 12.13.1 LTS? \[SOLVED\]](https://discourse.nodered.org/t/updating-node-js-to-12-13-1-lts-solved/19234)

<div class="topic-metadata">

**Author:** [@CaptClaude](https://discourse.nodered.org/u/CaptClaude)\
**Replies:** 0\
**Last updated:** [16 December 2019 19:05 UTC](https://discourse.nodered.org/t/updating-node-js-to-12-13-1-lts-solved/19234 "2019-12-16T19:05:42Z")

</div>

Edit: RTFM. Per the Docs (which I thought I had read), 12.x is supported so this question is moot. I am running NR on a couple of RPIs and Macs as well as my work PC (because it's awesome). For another project, I nee…

---

## [HTTP GET /nodes fails](https://discourse.nodered.org/t/http-get-nodes-fails/19233)

<div class="topic-metadata">

**Author:** [@magothe](https://discourse.nodered.org/u/magothe)\
**Replies:** 0\
**Last updated:** [16 December 2019 19:01 UTC](https://discourse.nodered.org/t/http-get-nodes-fails/19233 "2019-12-16T19:01:44Z")

</div>

The HTTP API is failing me. /flows works fine, so doesn't seem to be a permissions issue. /nodes returns nothing. Opening the browser console shows the following errors Uncaught ReferenceError: RED is not defined at…

---

## [Dynamically creation of flows at runtime](https://discourse.nodered.org/t/dynamically-creation-of-flows-at-runtime/19223)

<div class="topic-metadata">

**Author:** [@Jasper](https://discourse.nodered.org/u/Jasper)\
**Replies:** 6\
**Last updated:** [16 December 2019 17:17 UTC](https://discourse.nodered.org/t/dynamically-creation-of-flows-at-runtime/19223 "2019-12-16T17:17:25Z")

</div>

Hello everyone, I'm new en node-red and I need create flows dynamically at runtime, it's possible? Thank you in advance

---

## [Email logged file](https://discourse.nodered.org/t/email-logged-file/19029)

<div class="topic-metadata">

**Author:** [@NPLPRS](https://discourse.nodered.org/u/NPLPRS)\
**Replies:** 6\
**Last updated:** [16 December 2019 16:03 UTC](https://discourse.nodered.org/t/email-logged-file/19029 "2019-12-16T16:03:56Z")

</div>

Hi All, I have node red collecting data from a USB serial port. The data comes in, gets a timestamp added to it and then sent onto a log file on the Raspberry Pi desktop. I would like Nodered to then automatically ema…

---

## [How to hide the editor scroll bars](https://discourse.nodered.org/t/how-to-hide-the-editor-scroll-bars/16784)

<div class="topic-metadata">

**Author:** [@ghayne](https://discourse.nodered.org/u/ghayne)\
**Replies:** 8\
**Last updated:** [16 December 2019 13:20 UTC](https://discourse.nodered.org/t/how-to-hide-the-editor-scroll-bars/16784 "2019-12-16T13:20:24Z")

</div>

I have just installed the dark theme, how do I hide the editor scroll bars?

---

## [Read data from CSV file to global variables](https://discourse.nodered.org/t/read-data-from-csv-file-to-global-variables/19224)

<div class="topic-metadata">

**Author:** [@Kundepuu](https://discourse.nodered.org/u/Kundepuu)\
**Replies:** 1\
**Last updated:** [16 December 2019 12:18 UTC](https://discourse.nodered.org/t/read-data-from-csv-file-to-global-variables/19224 "2019-12-16T12:18:41Z")

</div>

I have CSV data file and I want to read data to global variables line by line on time . Data is every 2 hours daily and I need some 30 days to read and set values to control dry aging chamber(simulate natural dry agin…

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

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