# General

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

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

**Page:** 770

---

## [Azure Container Instance - Node-Red flow file location](https://discourse.nodered.org/t/azure-container-instance-node-red-flow-file-location/18469)

<div class="topic-metadata">

**Author:** [@saramcc](https://discourse.nodered.org/u/saramcc)\
**Replies:** 1\
**Last updated:** [7 April 2020 22:28 UTC](https://discourse.nodered.org/t/azure-container-instance-node-red-flow-file-location/18469 "2020-04-07T22:28:29Z")

</div>

I have created an Azure Container Instance that pulls a custom node-red docker image. This image has a custom flow file (qcflow.json) located in folder 'data' at the root level. The container instance appears to start …

---

## [Ramp-thermostat operational questions and clarification](https://discourse.nodered.org/t/ramp-thermostat-operational-questions-and-clarification/24414)

<div class="topic-metadata">

**Author:** [@shel](https://discourse.nodered.org/u/shel)\
**Replies:** 7\
**Last updated:** [7 April 2020 20:57 UTC](https://discourse.nodered.org/t/ramp-thermostat-operational-questions-and-clarification/24414 "2020-04-07T20:57:44Z")

</div>

Installed the node-red-contrib-ramp-thermostat and programmed it several weeks ago. I have several text boxes on the outputs to monitor what the outputs are actually doing. In watching these over the course of several da…

---

## [Broken dependency after migration](https://discourse.nodered.org/t/broken-dependency-after-migration/24425)

<div class="topic-metadata">

**Author:** [@SeRiusRod](https://discourse.nodered.org/u/SeRiusRod)\
**Replies:** 2\
**Last updated:** [7 April 2020 20:49 UTC](https://discourse.nodered.org/t/broken-dependency-after-migration/24425 "2020-04-07T20:49:18Z")

</div>

Today I had to migrate my IOT VM from a AMD64 system to a ARMv7. I ran it on a photon+docker host and now is installed in a Raspbian+docker in a raspberry. I simply moved the node-red docker volume with all it's content…

---

## [HTTP endpoint securing methods Between external sites and Node-Red](https://discourse.nodered.org/t/http-endpoint-securing-methods-between-external-sites-and-node-red/24426)

<div class="topic-metadata">

**Author:** [@mrSidX](https://discourse.nodered.org/u/mrSidX)\
**Replies:** 0\
**Last updated:** [7 April 2020 20:14 UTC](https://discourse.nodered.org/t/http-endpoint-securing-methods-between-external-sites-and-node-red/24426 "2020-04-07T20:14:53Z")

</div>

I've got a NR backend wrapped with a Wordpress site that manages individual users. Anyone keen on securing NR http endpoints between these two realms? I'm looking into 0Auth or similar JWT, but can't seem to wrangle Wo…

---

## [Using emails from customers as SQL queries](https://discourse.nodered.org/t/using-emails-from-customers-as-sql-queries/24264)

<div class="topic-metadata">

**Author:** [@grant1](https://discourse.nodered.org/u/grant1)\
**Replies:** 2\
**Last updated:** [7 April 2020 20:13 UTC](https://discourse.nodered.org/t/using-emails-from-customers-as-sql-queries/24264 "2020-04-07T20:13:07Z")

</div>

I am brainstorming some ideas to make some things at work a bit easier. One thing that happens every day is we get emails from customers asking "Which of my parts are ready?". We have a locally hosted SQL database that…

---

## [Neopixel - no output, example?](https://discourse.nodered.org/t/neopixel-no-output-example/24276)

<div class="topic-metadata">

**Author:** [@RogierQ](https://discourse.nodered.org/u/RogierQ)\
**Replies:** 13\
**Last updated:** [7 April 2020 20:01 UTC](https://discourse.nodered.org/t/neopixel-no-output-example/24276 "2020-04-07T20:01:40Z")

</div>

Hi! I am trying to get a neopixel cirkel running with node red. But no output at all. done all needed steps in the readme file and connected to pin 12, gpio 18 Can somebody help me with a working example or test file…

---

## [How to access microphone (node-red-contrib-browser-utils)](https://discourse.nodered.org/t/how-to-access-microphone-node-red-contrib-browser-utils/24399)

<div class="topic-metadata">

**Author:** [@lingzhongli](https://discourse.nodered.org/u/lingzhongli)\
**Replies:** 12\
**Last updated:** [7 April 2020 18:48 UTC](https://discourse.nodered.org/t/how-to-access-microphone-node-red-contrib-browser-utils/24399 "2020-04-07T18:48:03Z")

</div>

I want use node-red-contrib-browser-utils microphone, but i cannot allow the microphone in site setting... HOW CAN I SOLVE THIS PROBLEM??

---

## ["Error: SQLITE\_ERROR: no such column: undefined"](https://discourse.nodered.org/t/error-sqlite-error-no-such-column-undefined/24383)

<div class="topic-metadata">

**Author:** [@ScheepersJohan](https://discourse.nodered.org/u/ScheepersJohan)\
**Replies:** 18\
**Last updated:** [7 April 2020 17:30 UTC](https://discourse.nodered.org/t/error-sqlite-error-no-such-column-undefined/24383 "2020-04-07T17:30:16Z")

</div>

Hi, My sqlite put this error out - "Error: SQLITE\_ERROR: no such column: undefined" Statement to sqlite - topic: "INSERT INTO sensor\_data (id,device,value,epoch) VALUES ('28-02131a935aa','watertemp',20.3,158624731691…

---

## [Convert anolog input to string](https://discourse.nodered.org/t/convert-anolog-input-to-string/24407)

<div class="topic-metadata">

**Author:** [@Pac8](https://discourse.nodered.org/u/Pac8)\
**Replies:** 2\
**Last updated:** [7 April 2020 16:01 UTC](https://discourse.nodered.org/t/convert-anolog-input-to-string/24407 "2020-04-07T16:01:36Z")

</div>

Hi All. I have anolog input signal from analogue input pin for an Intel Galileo or Edison board. I am reading this on a gauge which is correct but i want to convert the numeric reading to send to the csv node. Just won…

---

## [Worldmap heatmap layer](https://discourse.nodered.org/t/worldmap-heatmap-layer/18042)

<div class="topic-metadata">

**Author:** [@Dyce](https://discourse.nodered.org/u/Dyce)\
**Replies:** 1\
**Last updated:** [7 April 2020 14:51 UTC](https://discourse.nodered.org/t/worldmap-heatmap-layer/18042 "2020-04-07T14:51:37Z")

</div>

Hello, I need to display quality of air on map. Best option I found was using worldmap node with heatmap layer. So far I was able to do it like shown below: The problem is, opacity of the color scales with intensity.…

---

## [Video doorbell implementation](https://discourse.nodered.org/t/video-doorbell-implementation/24344)

<div class="topic-metadata">

**Author:** [@KoenH](https://discourse.nodered.org/u/KoenH)\
**Replies:** 1\
**Last updated:** [7 April 2020 14:12 UTC](https://discourse.nodered.org/t/video-doorbell-implementation/24344 "2020-04-07T14:12:08Z")

</div>

Hello, I'm looking for a video doorbell that I can couple to node red to switch some lights when someone rings. I found an implementation for 'ring doorbell', but I'm wondering if there are no alternatives. Also when …

---

## [Excessive CPU usage when accessing Node Red (editor) on (separate PC) in chrome, ff, opera etc](https://discourse.nodered.org/t/excessive-cpu-usage-when-accessing-node-red-editor-on-separate-pc-in-chrome-ff-opera-etc/24396)

<div class="topic-metadata">

**Author:** [@LTDS](https://discourse.nodered.org/u/LTDS)\
**Replies:** 15\
**Last updated:** [7 April 2020 13:39 UTC](https://discourse.nodered.org/t/excessive-cpu-usage-when-accessing-node-red-editor-on-separate-pc-in-chrome-ff-opera-etc/24396 "2020-04-07T13:39:40Z")

</div>

Hi there ! I'm facing a pretty big issue here. I have Node Red installed on a few RPi and a Qnap NAS. They are all working in a network and the NAS instance is the main one. For quite some time I've noticed that when I …

---

## [Exec node, how to send \[enter\]?](https://discourse.nodered.org/t/exec-node-how-to-send-enter/24394)

<div class="topic-metadata">

**Author:** [@SammyG](https://discourse.nodered.org/u/SammyG)\
**Replies:** 9\
**Last updated:** [7 April 2020 13:15 UTC](https://discourse.nodered.org/t/exec-node-how-to-send-enter/24394 "2020-04-07T13:15:44Z")

</div>

Hi, i run node-red on a IOT2000 module from Siemens. I need to mount a shared folder from windows. It works if I do it with Putty (command promp). I send: mount.cifs //192.168.1.58/Share /Recepten –o user=Iedereen …

---

## [Mangle MQTT Messages](https://discourse.nodered.org/t/mangle-mqtt-messages/24380)

<div class="topic-metadata">

**Author:** [@itsgottabered](https://discourse.nodered.org/u/itsgottabered)\
**Replies:** 7\
**Last updated:** [7 April 2020 11:28 UTC](https://discourse.nodered.org/t/mangle-mqtt-messages/24380 "2020-04-07T11:28:57Z")

</div>

Hi all, I am struggling to figure out a solution to my problem and I've looked through the forum and googled in general but I can't find the exact thing I need. I have a power meter which has an internal MQTT broker an…

---

## [Custom node disappears from the flow library](https://discourse.nodered.org/t/custom-node-disappears-from-the-flow-library/24373)

<div class="topic-metadata">

**Author:** [@anversoft](https://discourse.nodered.org/u/anversoft)\
**Replies:** 2\
**Last updated:** [7 April 2020 09:38 UTC](https://discourse.nodered.org/t/custom-node-disappears-from-the-flow-library/24373 "2020-04-07T09:38:01Z")

</div>

Yesterday I updated my package: node-red-contrib-advanced-ftp from version 1.1.0 to 2.0.1, after 4-5 hours the package had not yet appeared on the flow library. I clicked on "request refresh" and since then my node has c…

---

## [Count down function](https://discourse.nodered.org/t/count-down-function/24348)

<div class="topic-metadata">

**Author:** [@koos147](https://discourse.nodered.org/u/koos147)\
**Replies:** 8\
**Last updated:** [7 April 2020 08:33 UTC](https://discourse.nodered.org/t/count-down-function/24348 "2020-04-07T08:33:03Z")

</div>

Good day, I expect that i made a realy simple mistake. The idea is that when a message arrive the output count down. var i = 10; while (i \>= 5) { msg.payload=i; node.send(msg); i--; } Expected output 10 9 8 7 6 5 …

---

## [Custom Node Error missing types](https://discourse.nodered.org/t/custom-node-error-missing-types/24379)

<div class="topic-metadata">

**Author:** [@Iliyas](https://discourse.nodered.org/u/Iliyas)\
**Replies:** 1\
**Last updated:** [7 April 2020 07:34 UTC](https://discourse.nodered.org/t/custom-node-error-missing-types/24379 "2020-04-07T07:34:25Z")

</div>

Hello All, I have created a custom node and I have deployed it successfully it is working fine but now I have some done some changes in my node.js code and I have replaced my previous custom node code with this code but…

---

## [External Cloudant intermittent error 401](https://discourse.nodered.org/t/external-cloudant-intermittent-error-401/23255)

<div class="topic-metadata">

**Author:** [@piptan](https://discourse.nodered.org/u/piptan)\
**Replies:** 1\
**Last updated:** [7 April 2020 07:28 UTC](https://discourse.nodered.org/t/external-cloudant-intermittent-error-401/23255 "2020-04-07T07:28:46Z")

</div>

Hi, I can successfully access external Cloudant DB from my node. But, from time to time, I receive error "couch returned 401". All I have to do to fix this is to go to External Cloudant server properties 's edit page an…

---

## [Error al intentar instalar libreria nodo modbus tcp](https://discourse.nodered.org/t/error-al-intentar-instalar-libreria-nodo-modbus-tcp/24362)

<div class="topic-metadata">

**Author:** [@JulianTN](https://discourse.nodered.org/u/JulianTN)\
**Replies:** 0\
**Last updated:** [6 April 2020 23:15 UTC](https://discourse.nodered.org/t/error-al-intentar-instalar-libreria-nodo-modbus-tcp/24362 "2020-04-06T23:15:57Z")

</div>

Hola, soy un poco nuevo en lo que es Node-RED. estoy intentando generar un servidor para la herramienta de Schneider, Augmented Operator Advisor. Abro el editor de node-red desde el manager de AOA, intento instalar la …

---

## [Get events from google calendar](https://discourse.nodered.org/t/get-events-from-google-calendar/4830)

<div class="topic-metadata">

**Author:** [@Xenobiologist](https://discourse.nodered.org/u/Xenobiologist)\
**Replies:** 21\
**Last updated:** [6 April 2020 22:13 UTC](https://discourse.nodered.org/t/get-events-from-google-calendar/4830 "2020-04-06T22:13:34Z")

</div>

Hello, I would like to get a list of events between two dates (start /end) or all events for the next (3 / 7) days. I'm currently using # node-red-node-google 0.1.4 My problem is, that these nodes only provide the opt…

---

## [Ignore same message within 5 seconds](https://discourse.nodered.org/t/ignore-same-message-within-5-seconds/24274)

<div class="topic-metadata">

**Author:** [@cymplecy](https://discourse.nodered.org/u/cymplecy)\
**Replies:** 16\
**Last updated:** [6 April 2020 20:57 UTC](https://discourse.nodered.org/t/ignore-same-message-within-5-seconds/24274 "2020-04-06T20:57:10Z")

</div>

I'm trying to come up with a method of ignoring short term duplicate messages But this little idea doesn't quite seem to work in the way I want it to i.e use RBE to block repeats but reset it 5 secs after a message com…

---

## ["Error: unable to verify the first certificate"](https://discourse.nodered.org/t/error-unable-to-verify-the-first-certificate/24345)

<div class="topic-metadata">

**Author:** [@boesh](https://discourse.nodered.org/u/boesh)\
**Replies:** 0\
**Last updated:** [6 April 2020 18:50 UTC](https://discourse.nodered.org/t/error-unable-to-verify-the-first-certificate/24345 "2020-04-06T18:50:12Z")

</div>

Hi, I'm new to Node-RED and I'm trying and doing some easy first steps. I have solar-edge node installed using the right site-ID and API-ID but get stuck with the following error "Error: unable to verify the first cer…

---

## [Dashboard admin page](https://discourse.nodered.org/t/dashboard-admin-page/24327)

<div class="topic-metadata">

**Author:** [@Beefy\_carrot](https://discourse.nodered.org/u/Beefy_carrot)\
**Replies:** 3\
**Last updated:** [6 April 2020 20:11 UTC](https://discourse.nodered.org/t/dashboard-admin-page/24327 "2020-04-06T20:11:19Z")

</div>

Hi! i want to make a UI with admin functions( add sensor, delete sensor, set sensor meta data rules) and having a page for view of data. does the node-red dashboard have limitiations for interacting with the nodes and va…

---

## [Node-red slowly](https://discourse.nodered.org/t/node-red-slowly/24342)

<div class="topic-metadata">

**Author:** [@Folgore](https://discourse.nodered.org/u/Folgore)\
**Replies:** 4\
**Last updated:** [6 April 2020 19:22 UTC](https://discourse.nodered.org/t/node-red-slowly/24342 "2020-04-06T19:22:33Z")

</div>

Hi , I am crazy and I know, but i have a problem with my flow.... I want read an array json (now with 903 element) to put in a 80 chart. I have first start with a for...but the dashboard lost the communication, I have m…

---

## [Search Array and output Boolean](https://discourse.nodered.org/t/search-array-and-output-boolean/24341)

<div class="topic-metadata">

**Author:** [@nadamson](https://discourse.nodered.org/u/nadamson)\
**Replies:** 4\
**Last updated:** [6 April 2020 18:47 UTC](https://discourse.nodered.org/t/search-array-and-output-boolean/24341 "2020-04-06T18:47:43Z")

</div>

Hello All, I have an array that I would like to be able to search for certain strings. Here is an example of the array output in the Debug window. \["LA","NJ","NJ-NJ","NJ-NJ","NJ-NJ","NJ-NJ","MS1","WA"\] Then I would l…

---

## ["Rate detection" - can it be done "easily"?](https://discourse.nodered.org/t/rate-detection-can-it-be-done-easily/24188)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 9\
**Last updated:** [6 April 2020 17:50 UTC](https://discourse.nodered.org/t/rate-detection-can-it-be-done-easily/24188 "2020-04-06T17:50:45Z")

</div>

Sort of from my other post about finding the error, The problem is still a bit unknown to what happened. It is now possible it was on another machine and the error handling parts of the flow went into overdrive. :fro…

---

## [I can't install a palette](https://discourse.nodered.org/t/i-cant-install-a-palette/24339)

<div class="topic-metadata">

**Author:** [@oceane](https://discourse.nodered.org/u/oceane)\
**Replies:** 0\
**Last updated:** [6 April 2020 17:25 UTC](https://discourse.nodered.org/t/i-cant-install-a-palette/24339 "2020-04-06T17:25:42Z")

</div>

Hello, i want to install the palette : node-red-node-sqlite. I tried to install it by terminal or by Node-red directly My log : C:\\Users\\perri\\AppData\\Roaming\\npm\\node\_modules\\node-red\>npm install node-red-node-sqlite …

---

## [Java to JSON conversion](https://discourse.nodered.org/t/java-to-json-conversion/24332)

<div class="topic-metadata">

**Author:** [@makowski13](https://discourse.nodered.org/u/makowski13)\
**Replies:** 4\
**Last updated:** [6 April 2020 17:15 UTC](https://discourse.nodered.org/t/java-to-json-conversion/24332 "2020-04-06T17:15:47Z")

</div>

I imported a java code and received an JSON array error, can anyone help?

---

## [\[Feedback Needed\] Russian language translation](https://discourse.nodered.org/t/feedback-needed-russian-language-translation/21280)

<div class="topic-metadata">

**Author:** [@7dir](https://discourse.nodered.org/u/7dir)\
**Replies:** 7\
**Last updated:** [6 April 2020 17:14 UTC](https://discourse.nodered.org/t/feedback-needed-russian-language-translation/21280 "2020-04-06T17:14:23Z")

</div>

Hello! My name is Michael. I\`m from Russia. I took interest in the node-red. I\`d like to localize node-red on the Russian Market. I\`ll send Pull Request. Could you give me your consent or some comment.

---

## [Fatal error Unable to import automationhat python library](https://discourse.nodered.org/t/fatal-error-unable-to-import-automationhat-python-library/24326)

<div class="topic-metadata">

**Author:** [@drikos\_pag](https://discourse.nodered.org/u/drikos_pag)\
**Replies:** 1\
**Last updated:** [6 April 2020 15:47 UTC](https://discourse.nodered.org/t/fatal-error-unable-to-import-automationhat-python-library/24326 "2020-04-06T15:47:32Z")

</div>

Hello to everybody, I would like to give me your help regarding one issue that I have. I have installed the node red to my Mac and when I tried to start today the node-red I have the following error: 6 Apr 18:05:59 - …

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

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