# General

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

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

**Page:** 459

---

## [SQlite error with node red on Docker](https://discourse.nodered.org/t/sqlite-error-with-node-red-on-docker/54618)

<div class="topic-metadata">

**Author:** [@TROJAN053](https://discourse.nodered.org/u/TROJAN053)\
**Replies:** 5\
**Last updated:** [2 December 2021 10:52 UTC](https://discourse.nodered.org/t/sqlite-error-with-node-red-on-docker/54618 "2021-12-02T10:52:18Z")

</div>

Hi, I am using SQlite to keep some data, where as while passing my query as topic an error is appearing saying ' Error: SQLITE\_ERROR: no such table: History\_Stop'. I am using a windows 10 system and node red is running …

---

## [How to run command line after installing the node-red with snap](https://discourse.nodered.org/t/how-to-run-command-line-after-installing-the-node-red-with-snap/54614)

<div class="topic-metadata">

**Author:** [@yang](https://discourse.nodered.org/u/yang)\
**Replies:** 4\
**Last updated:** [2 December 2021 09:11 UTC](https://discourse.nodered.org/t/how-to-run-command-line-after-installing-the-node-red-with-snap/54614 "2021-12-02T09:11:55Z")

</div>

hello, everyone I installed the nodered on ubuntu 18.04 with snap, now I want to enable the HTTPS Access and the Username/password based authentication, it takes me much time to find the setting.js file, at last, I foun…

---

## [Code function to collect data from mqtt](https://discourse.nodered.org/t/code-function-to-collect-data-from-mqtt/54588)

<div class="topic-metadata">

**Author:** [@huuthang911](https://discourse.nodered.org/u/huuthang911)\
**Replies:** 4\
**Last updated:** [2 December 2021 08:34 UTC](https://discourse.nodered.org/t/code-function-to-collect-data-from-mqtt/54588 "2021-12-02T08:34:31Z")

</div>

Hi folks, I have 3 topics in MQTT. I want to use the data of these topics but I don't know how to write code in the function node. Can you suggest to me the code to declare variables in the function node.

---

## [Getting session of TCP Connection without direct connection to the node](https://discourse.nodered.org/t/getting-session-of-tcp-connection-without-direct-connection-to-the-node/54452)

<div class="topic-metadata">

**Author:** [@ChristianOvesen](https://discourse.nodered.org/u/ChristianOvesen)\
**Replies:** 4\
**Last updated:** [2 December 2021 07:35 UTC](https://discourse.nodered.org/t/getting-session-of-tcp-connection-without-direct-connection-to-the-node/54452 "2021-12-02T07:35:50Z")

</div>

Hello, I am fairly new to node-red and I have run into an issue. So I have a TCP connection that sends nothing until it has received an initiation message, then it will begin sending constantly and won't need other messa…

---

## [I am having trouble opening excel files when using the Excel Sheets node](https://discourse.nodered.org/t/i-am-having-trouble-opening-excel-files-when-using-the-excel-sheets-node/54430)

<div class="topic-metadata">

**Author:** [@Aaron1](https://discourse.nodered.org/u/Aaron1)\
**Replies:** 9\
**Last updated:** [2 December 2021 05:28 UTC](https://discourse.nodered.org/t/i-am-having-trouble-opening-excel-files-when-using-the-excel-sheets-node/54430 "2021-12-02T05:28:00Z")

</div>

I tried to use The Excel Sheets node to write data, but it couldn't be opened after writing. I don't know what the problem is, please help me solve it or give me an example, thank you

---

## [Help wanted with flow intended to turn lights off and on based on sun elevation](https://discourse.nodered.org/t/help-wanted-with-flow-intended-to-turn-lights-off-and-on-based-on-sun-elevation/54616)

<div class="topic-metadata">

**Author:** [@thromer](https://discourse.nodered.org/u/thromer)\
**Replies:** 2\
**Last updated:** [2 December 2021 05:22 UTC](https://discourse.nodered.org/t/help-wanted-with-flow-intended-to-turn-lights-off-and-on-based-on-sun-elevation/54616 "2021-12-02T05:22:02Z")

</div>

I'm new to Node-Red and I think there is something about flows or RBEs that I don't understand, and need some help figuring out. As the subject suggests, I expect this flow to turn the lights off when the sun goes above…

---

## [Can I skip undefined in array in a function node?](https://discourse.nodered.org/t/can-i-skip-undefined-in-array-in-a-function-node/54594)

<div class="topic-metadata">

**Author:** [@Nice\_to\_have](https://discourse.nodered.org/u/Nice_to_have)\
**Replies:** 9\
**Last updated:** [1 December 2021 22:22 UTC](https://discourse.nodered.org/t/can-i-skip-undefined-in-array-in-a-function-node/54594 "2021-12-01T22:22:30Z")

</div>

Good day everyone, I come up with a hobby project which for sure is keeping me active on this forum. Searching for, and learning a lot from, other forum entries. I have searched the forum for topics that might tell me…

---

## [How can I listen to an External REQUEST (POST)?](https://discourse.nodered.org/t/how-can-i-listen-to-an-external-request-post/54599)

<div class="topic-metadata">

**Author:** [@elvissouza](https://discourse.nodered.org/u/elvissouza)\
**Replies:** 2\
**Last updated:** [1 December 2021 19:57 UTC](https://discourse.nodered.org/t/how-can-i-listen-to-an-external-request-post/54599 "2021-12-01T19:57:46Z")

</div>

First sorry for my English grammar. So I don't know if it's possible to listen to an external request in my case a POST I have two Node-Red one that is in the CLOUD and another LOCAL. When requesting a POST on Node-RE…

---

## [Problem running SQL stored procedure](https://discourse.nodered.org/t/problem-running-sql-stored-procedure/54542)

<div class="topic-metadata">

**Author:** [@GregHNZ](https://discourse.nodered.org/u/GregHNZ)\
**Replies:** 2\
**Last updated:** [1 December 2021 19:18 UTC](https://discourse.nodered.org/t/problem-running-sql-stored-procedure/54542 "2021-12-01T19:18:54Z")

</div>

Using node-red-contrib-mssql-plus to connect to SQL server Have got Select query running but getting an error when trying to execute a stored procedure, failing with error Could not find stored procedure ''. Both …

---

## [Sunset / sunrise give other values in dashboard then in debug window](https://discourse.nodered.org/t/sunset-sunrise-give-other-values-in-dashboard-then-in-debug-window/54575)

<div class="topic-metadata">

**Author:** [@Leo](https://discourse.nodered.org/u/Leo)\
**Replies:** 2\
**Last updated:** [1 December 2021 17:50 UTC](https://discourse.nodered.org/t/sunset-sunrise-give-other-values-in-dashboard-then-in-debug-window/54575 "2021-12-01T17:50:50Z")

</div>

Hi, I'm new with node-red and I'm struggling with sunset / sunrise from openweathermap. I getting sunset / sunrise from openweathermap and via a function node, I convert the epoch to a more readable format (just our da…

---

## [Where can I find an explanation of the most basic terms like "node" "flow" deploying" "LTS" "npm-module](https://discourse.nodered.org/t/where-can-i-find-an-explanation-of-the-most-basic-terms-like-node-flow-deploying-lts-npm-module/54569)

<div class="topic-metadata">

**Author:** [@StefanL38](https://discourse.nodered.org/u/StefanL38)\
**Replies:** 6\
**Last updated:** [1 December 2021 16:11 UTC](https://discourse.nodered.org/t/where-can-i-find-an-explanation-of-the-most-basic-terms-like-node-flow-deploying-lts-npm-module/54569 "2021-12-01T16:11:47Z")

</div>

Hello everybody, I started to read at Creating your first node the text starts with Nodes get created when a flow is deployed.. oopps ! as a newcomer I ask myself what is a "node"? what is a "flow"? how do I "…

---

## [Localtime instead of UTC](https://discourse.nodered.org/t/localtime-instead-of-utc/54585)

<div class="topic-metadata">

**Author:** [@saalty](https://discourse.nodered.org/u/saalty)\
**Replies:** 2\
**Last updated:** [1 December 2021 16:11 UTC](https://discourse.nodered.org/t/localtime-instead-of-utc/54585 "2021-12-01T16:11:30Z")

</div>

Hello all! I have problem with timezone in Node-Red. I read a lot about this issue but cannot find the solution yet. I use opcda-read node to read out data from OPC DA server. This node gives an object about the data in…

---

## [Exec node with "timedatectl" call started to return a buffer instead of string](https://discourse.nodered.org/t/exec-node-with-timedatectl-call-started-to-return-a-buffer-instead-of-string/54553)

<div class="topic-metadata">

**Author:** [@janedoe123](https://discourse.nodered.org/u/janedoe123)\
**Replies:** 11\
**Last updated:** [1 December 2021 16:01 UTC](https://discourse.nodered.org/t/exec-node-with-timedatectl-call-started-to-return-a-buffer-instead-of-string/54553 "2021-12-01T16:01:09Z")

</div>

Hi all, I'm facing a super weird issue. I'm using an exec node with a "timedatectl" call, but suddenly it started to return a buffer instead of string. Because of that, I can't use any JSONata expression anymore since …

---

## [Problem with node-red-contrib-google-calendar](https://discourse.nodered.org/t/problem-with-node-red-contrib-google-calendar/54467)

<div class="topic-metadata">

**Author:** [@WernerM96](https://discourse.nodered.org/u/WernerM96)\
**Replies:** 1\
**Last updated:** [1 December 2021 15:59 UTC](https://discourse.nodered.org/t/problem-with-node-red-contrib-google-calendar/54467 "2021-12-01T15:59:40Z")

</div>

Hey, i have a problem with the node-red-contrib-google-calendar. I would like to get some events of the current day with this function: const startDate = new Date(); const endDate = new Date(); endDate.setHours(22); …

---

## [Change static IP address from dashboard](https://discourse.nodered.org/t/change-static-ip-address-from-dashboard/54531)

<div class="topic-metadata">

**Author:** [@traderjoe](https://discourse.nodered.org/u/traderjoe)\
**Replies:** 10\
**Last updated:** [1 December 2021 14:13 UTC](https://discourse.nodered.org/t/change-static-ip-address-from-dashboard/54531 "2021-12-01T14:13:57Z")

</div>

I'm trying to change the static IP address of my PI from a node red dashboard. I found this link https://flows.nodered.org/flow/520df02be955b412ddb89bcbf70cce34 \[{"id":"2d2bd18e.3e4abe","type":"tab","label":"IP Settin…

---

## [Use of environment variables to set editor user name and password](https://discourse.nodered.org/t/use-of-environment-variables-to-set-editor-user-name-and-password/54345)

<div class="topic-metadata">

**Author:** [@hammoaj](https://discourse.nodered.org/u/hammoaj)\
**Replies:** 9\
**Last updated:** [1 December 2021 13:39 UTC](https://discourse.nodered.org/t/use-of-environment-variables-to-set-editor-user-name-and-password/54345 "2021-12-01T13:39:14Z")

</div>

Has the option to use NODE\_RED\_USERNAME and NODE\_RED\_PASSWORD to set an admin login for the editor been removed? It works in NR 1.x, but apparently not in NR 2.x. Thanks

---

## [Expected ':' and instead saw '+' in function node](https://discourse.nodered.org/t/expected-and-instead-saw-in-function-node/54571)

<div class="topic-metadata">

**Author:** [@Nice\_to\_have](https://discourse.nodered.org/u/Nice_to_have)\
**Replies:** 1\
**Last updated:** [1 December 2021 13:08 UTC](https://discourse.nodered.org/t/expected-and-instead-saw-in-function-node/54571 "2021-12-01T13:08:43Z")

</div>

I am using a function node to query MYSQL. How ever, the function node says: Expected ':' and instead saw '+ msg.topic = { "INSERT or REPLACE INTO RANDOMNUM VALUES ( " + msg.payload\[0\].mmsi + "," + msg.payload\[0\].ch…

---

## [Mustache notation](https://discourse.nodered.org/t/mustache-notation/54558)

<div class="topic-metadata">

**Author:** [@bombjackit](https://discourse.nodered.org/u/bombjackit)\
**Replies:** 2\
**Last updated:** [1 December 2021 12:29 UTC](https://discourse.nodered.org/t/mustache-notation/54558 "2021-12-01T12:29:51Z")

</div>

Hello to everybody, working with nodered I have discovered the mustache notation that is a great simplification, but I have some problem with a particular type of data. I have this payload\["Ox.V.fVar\_5"\] : what is the c…

---

## ["Error: Cannot set headers after they are sent to the client"](https://discourse.nodered.org/t/error-cannot-set-headers-after-they-are-sent-to-the-client/54527)

<div class="topic-metadata">

**Author:** [@wjr1506](https://discourse.nodered.org/u/wjr1506)\
**Replies:** 4\
**Last updated:** [1 December 2021 12:22 UTC](https://discourse.nodered.org/t/error-cannot-set-headers-after-they-are-sent-to-the-client/54527 "2021-12-01T12:22:25Z")

</div>

Hello everyone! I have a question, is there any way to loop a flow that has an http node? I'm trying to integrate a chatbot created in Watson Assistan into instagram. As I didn't find a specific node for sending messag…

---

## [Node-RED on docker causes regular CPU spikes](https://discourse.nodered.org/t/node-red-on-docker-causes-regular-cpu-spikes/54112)

<div class="topic-metadata">

**Author:** [@blagae](https://discourse.nodered.org/u/blagae)\
**Replies:** 17\
**Last updated:** [1 December 2021 10:30 UTC](https://discourse.nodered.org/t/node-red-on-docker-causes-regular-cpu-spikes/54112 "2021-12-01T10:30:09Z")

</div>

Docker is running on a relatively low-end Linux system with dual-core processor of type Intel Celeron N3350 and 4GB of memory. About 15 microservice containers run together, communicating with each other and to the outsi…

---

## [\[Challenge\]Solve Advent of Code puzzles without using function nodes](https://discourse.nodered.org/t/challenge-solve-advent-of-code-puzzles-without-using-function-nodes/54556)

<div class="topic-metadata">

**Author:** [@cymplecy](https://discourse.nodered.org/u/cymplecy)\
**Replies:** 0\
**Last updated:** [1 December 2021 09:56 UTC](https://discourse.nodered.org/t/challenge-solve-advent-of-code-puzzles-without-using-function-nodes/54556 "2021-12-01T09:56:37Z")

</div>

..or JSONata etc :slight\_smile: I'm doing them using Snap! but it would be fun to see how far into this years puzzles they could be done before code needed https://adventofcode.com

---

## [Node not deleting entirely](https://discourse.nodered.org/t/node-not-deleting-entirely/54482)

<div class="topic-metadata">

**Author:** [@lesmar96](https://discourse.nodered.org/u/lesmar96)\
**Replies:** 15\
**Last updated:** [1 December 2021 09:46 UTC](https://discourse.nodered.org/t/node-not-deleting-entirely/54482 "2021-12-01T09:46:58Z")

</div>

I have a small flow running that I had previously being pushing some data to ubidots via the ubidots-out node. I have quit using ubidots so I deleted the node from my flow. It no longer shows up in my flow anywhere, but…

---

## [Consistency on Chart Colors With Live Data](https://discourse.nodered.org/t/consistency-on-chart-colors-with-live-data/54530)

<div class="topic-metadata">

**Author:** [@aa0z](https://discourse.nodered.org/u/aa0z)\
**Replies:** 3\
**Last updated:** [1 December 2021 09:45 UTC](https://discourse.nodered.org/t/consistency-on-chart-colors-with-live-data/54530 "2021-12-01T09:45:31Z")

</div>

I've got quite a few charts & bar graphs in my dashboard that populate with live data. Being a newbie to charts and populating them with live data, no matter at the time interval the data gets pushed to a chart node, ho…

---

## [Multiple Projects running at once](https://discourse.nodered.org/t/multiple-projects-running-at-once/54545)

<div class="topic-metadata">

**Author:** [@notscottsmith](https://discourse.nodered.org/u/notscottsmith)\
**Replies:** 1\
**Last updated:** [1 December 2021 08:09 UTC](https://discourse.nodered.org/t/multiple-projects-running-at-once/54545 "2021-12-01T08:09:06Z")

</div>

I've got Node Red v2 running with multiple instances to handle simultaneous projects. I've got a reverse proxy (traefik) sitting in front of it to handle the url component so that it's same except for the uri. I did read…

---

## [Node-red-contrib-influxdb function to pass a specific time query](https://discourse.nodered.org/t/node-red-contrib-influxdb-function-to-pass-a-specific-time-query/54414)

<div class="topic-metadata">

**Author:** [@adgardo](https://discourse.nodered.org/u/adgardo)\
**Replies:** 12\
**Last updated:** [1 December 2021 07:45 UTC](https://discourse.nodered.org/t/node-red-contrib-influxdb-function-to-pass-a-specific-time-query/54414 "2021-12-01T07:45:51Z")

</div>

Hello, I'm new to Node-RED and javascript... hope you can help! I want to perform a influxdb query between two specitic timestamps: boot, and now (being now the moment at which GPIO 21 turns to 0). I don't manage to c…

---

## [Problem with string.includes inside a function node](https://discourse.nodered.org/t/problem-with-string-includes-inside-a-function-node/54523)

<div class="topic-metadata">

**Author:** [@OriolFM](https://discourse.nodered.org/u/OriolFM)\
**Replies:** 2\
**Last updated:** [1 December 2021 07:43 UTC](https://discourse.nodered.org/t/problem-with-string-includes-inside-a-function-node/54523 "2021-12-01T07:43:24Z")

</div>

I have a function where I read a series of OPC-UA nodes from a machine. The OPC-UA node returns a message where msg.payload is an array of objects where the value, type of the variable and the timestamp are located. It …

---

## [Entity value pulse to another entity](https://discourse.nodered.org/t/entity-value-pulse-to-another-entity/54491)

<div class="topic-metadata">

**Author:** [@Waydercy](https://discourse.nodered.org/u/Waydercy)\
**Replies:** 5\
**Last updated:** [1 December 2021 07:09 UTC](https://discourse.nodered.org/t/entity-value-pulse-to-another-entity/54491 "2021-12-01T07:09:57Z")

</div>

I am trying to set up lighting "zones" with individual switches with a master switch "All Lights". Note: All switches are an a entity node within node red where a toggle switch from the HA dashboard changes the states o…

---

## [How to use node-red-contrib-syno](https://discourse.nodered.org/t/how-to-use-node-red-contrib-syno/54548)

<div class="topic-metadata">

**Author:** [@UweG](https://discourse.nodered.org/u/UweG)\
**Replies:** 0\
**Last updated:** [1 December 2021 06:06 UTC](https://discourse.nodered.org/t/how-to-use-node-red-contrib-syno/54548 "2021-12-01T06:06:50Z")

</div>

Has anybody an example to upload/download files to a Synology NAS with NodeRed? I try to use the node-red-contrib-syno (DS File) but there is no explanation and i didn't found anything in the web.

---

## [Problem with usbcamera (gray output)](https://discourse.nodered.org/t/problem-with-usbcamera-gray-output/54536)

<div class="topic-metadata">

**Author:** [@pjarafue](https://discourse.nodered.org/u/pjarafue)\
**Replies:** 1\
**Last updated:** [30 November 2021 23:06 UTC](https://discourse.nodered.org/t/problem-with-usbcamera-gray-output/54536 "2021-11-30T23:06:12Z")

</div>

Hi everyone!! I have a problem with usbcamera node when image is generate , the result is a gray image without picture. I use Ubuntu 20.04, in windows don't have the problem. the camera is work ok with app cheese. …

---

## [Scaling node? (scale != range)](https://discourse.nodered.org/t/scaling-node-scale-range/54532)

<div class="topic-metadata">

**Author:** [@hobbes1069](https://discourse.nodered.org/u/hobbes1069)\
**Replies:** 3\
**Last updated:** [30 November 2021 22:30 UTC](https://discourse.nodered.org/t/scaling-node-scale-range/54532 "2021-11-30T22:30:21Z")

</div>

I'm sure someone has created one, I've already seen it done as a subflow, but I was surprised to not find a single search return for "scaling" in the palatte manager. It wouldn't need to be installed by default or anyth…

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

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