# Latest

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

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

**Page:** 1122

---

## [Get coordinates of a satellite from http request](https://discourse.nodered.org/t/get-coordinates-of-a-satellite-from-http-request/24441)

<div class="topic-metadata">

**Author:** [@JustSeen](https://discourse.nodered.org/u/JustSeen)\
**Replies:** 31\
**Last updated:** [8 April 2020 11:51 UTC](https://discourse.nodered.org/t/get-coordinates-of-a-satellite-from-http-request/24441 "2020-04-08T11:51:44Z")

</div>

Hi, I want to retrieve the coordinates of a satellite, so I can display it. However, I retrieve the TLE data via an HTTP request. But I can't put it in the right format for the TLE function to convert the TLE data in…

---

## [Error in connection with mariadb](https://discourse.nodered.org/t/error-in-connection-with-mariadb/24273)

<div class="topic-metadata">

**Author:** [@phil1](https://discourse.nodered.org/u/phil1)\
**Replies:** 7\
**Last updated:** [8 April 2020 10:50 UTC](https://discourse.nodered.org/t/error-in-connection-with-mariadb/24273 "2020-04-08T10:50:13Z")

</div>

Hello, I am trying in a simple projet (like a beginner...) to connect node-red to a database with mariadb (under raspberry pi) I have already create the base under Mariadb and i can access it sous mariadb (root + Passw…

---

## [Node-Red on Qnap working, but not Alexa](https://discourse.nodered.org/t/node-red-on-qnap-working-but-not-alexa/24455)

<div class="topic-metadata">

**Author:** [@c4yolli](https://discourse.nodered.org/u/c4yolli)\
**Replies:** 0\
**Last updated:** [8 April 2020 10:34 UTC](https://discourse.nodered.org/t/node-red-on-qnap-working-but-not-alexa/24455 "2020-04-08T10:34:01Z")

</div>

Hi, has anyone already run node-red/alexa on qnap? I am using Qnap with Container-Station (Docker) and Node-Red 1.0.4 as Image. Node-Red is working. Now, i try to setup Alexa. I tried nearly all Flows out there. Nothin…

---

## [Modbus Flex Connector Example](https://discourse.nodered.org/t/modbus-flex-connector-example/24447)

<div class="topic-metadata">

**Author:** [@bdbell](https://discourse.nodered.org/u/bdbell)\
**Replies:** 0\
**Last updated:** [8 April 2020 09:55 UTC](https://discourse.nodered.org/t/modbus-flex-connector-example/24447 "2020-04-08T09:55:43Z")

</div>

Does anyone have a working example of Modbus Flex Connector with the ability to dynamically connect to both TCP and SERIAL devices (using the most recent version of NR and node-red-contrib-modbus)? I have looked at MODS…

---

## [Multiple Users Multiple devices - Thoughts](https://discourse.nodered.org/t/multiple-users-multiple-devices-thoughts/24423)

<div class="topic-metadata">

**Author:** [@nksky](https://discourse.nodered.org/u/nksky)\
**Replies:** 6\
**Last updated:** [8 April 2020 08:13 UTC](https://discourse.nodered.org/t/multiple-users-multiple-devices-thoughts/24423 "2020-04-08T08:13:42Z")

</div>

Thinking out loud here, any input welcome.... I'm trialing a prototype heat measuring system, Basically, each user has two Pi3's, each with a temp sensor, one with a relay. I have 1 Node-red flow, that compares temps an…

---

## [Set time function on dashboard](https://discourse.nodered.org/t/set-time-function-on-dashboard/24008)

<div class="topic-metadata">

**Author:** [@lalo](https://discourse.nodered.org/u/lalo)\
**Replies:** 44\
**Last updated:** [8 April 2020 07:43 UTC](https://discourse.nodered.org/t/set-time-function-on-dashboard/24008 "2020-04-08T07:43:54Z")

</div>

Hi, i'm trying to make a function to select an hour to turn off the lights at 19:00 the only method that i used before is a delay but i was looking and i found the get mydate get hour, there is way to use a function like…

---

## [Blink security camera](https://discourse.nodered.org/t/blink-security-camera/24398)

<div class="topic-metadata">

**Author:** [@drumstick77](https://discourse.nodered.org/u/drumstick77)\
**Replies:** 1\
**Last updated:** [8 April 2020 06:59 UTC](https://discourse.nodered.org/t/blink-security-camera/24398 "2020-04-08T06:59:21Z")

</div>

Hi All, Just wondering if anyone knows or has got a working node-red palette for blink security camera? thanks

---

## [seeking out assist on thermostat common sense - counting instances over/underneath a value.](https://discourse.nodered.org/t/seeking-out-assist-on-thermostat-common-sense-counting-instances-over-underneath-a-value/24250)

<div class="topic-metadata">

**Author:** [@JorgeDamien](https://discourse.nodered.org/u/JorgeDamien)\
**Replies:** 3\
**Last updated:** [8 April 2020 05:22 UTC](https://discourse.nodered.org/t/seeking-out-assist-on-thermostat-common-sense-counting-instances-over-underneath-a-value/24250 "2020-04-08T05:22:40Z")

</div>

I think this is likely a stupid question, but I'm looking at a few counter nodes and I'm not exactly getting from them what I thought I would. Basically I have a flow now that checks the temperature from a Zigbee device…

---

## [How to write programme use javascirpt with continuous command](https://discourse.nodered.org/t/how-to-write-programme-use-javascirpt-with-continuous-command/24432)

<div class="topic-metadata">

**Author:** [@Jhon](https://discourse.nodered.org/u/Jhon)\
**Replies:** 0\
**Last updated:** [8 April 2020 02:53 UTC](https://discourse.nodered.org/t/how-to-write-programme-use-javascirpt-with-continuous-command/24432 "2020-04-08T02:53:44Z")

</div>

Hello I am using TCP Request to send an receive the message to/ from anybus bolt. whatevey use telnet ,At command of anybus and putty,I can write multiline command then send them to the anybus bolt and receive correc…

---

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

---

## [Connection lost in Raspberry PI Zero W](https://discourse.nodered.org/t/connection-lost-in-raspberry-pi-zero-w/24307)

<div class="topic-metadata">

**Author:** [@XiaoBin](https://discourse.nodered.org/u/XiaoBin)\
**Replies:** 16\
**Last updated:** [7 April 2020 19:57 UTC](https://discourse.nodered.org/t/connection-lost-in-raspberry-pi-zero-w/24307 "2020-04-07T19:57:18Z")

</div>

Hello Guys I am working on large node-red project in Raspberry PI Zero W. That project contains over 1900 nodes and MQTT communication with C application. But I see connection lost almost of time. Also I have many 't…

---

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

---

## [Energy Consumption raspberry pi 4](https://discourse.nodered.org/t/energy-consumption-raspberry-pi-4/24365)

<div class="topic-metadata">

**Author:** [@ezequiel\_barros](https://discourse.nodered.org/u/ezequiel_barros)\
**Replies:** 13\
**Last updated:** [7 April 2020 15:17 UTC](https://discourse.nodered.org/t/energy-consumption-raspberry-pi-4/24365 "2020-04-07T15:17:38Z")

</div>

Good night people Good night people I wonder if there is some way to monitor the power consumption of the raspberry pi 4, and it is possible to place this information on my dash board thanks

---

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

---

## [Use Admin API with adminAuth type strategy](https://discourse.nodered.org/t/use-admin-api-with-adminauth-type-strategy/21719)

<div class="topic-metadata">

**Author:** [@gmerciel](https://discourse.nodered.org/u/gmerciel)\
**Replies:** 4\
**Last updated:** [7 April 2020 13:05 UTC](https://discourse.nodered.org/t/use-admin-api-with-adminauth-type-strategy/21719 "2020-04-07T13:05:06Z")

</div>

Hi, I would like to use strategy authorization for editor web ui, so I can use my OpenID Connect provider to define users and permissions, but at the same time, I need to be able to use the admin api, which only seems to…

---

## [Inject MySQL datas to slider](https://discourse.nodered.org/t/inject-mysql-datas-to-slider/24390)

<div class="topic-metadata">

**Author:** [@cheun](https://discourse.nodered.org/u/cheun)\
**Replies:** 2\
**Last updated:** [7 April 2020 12:41 UTC](https://discourse.nodered.org/t/inject-mysql-datas-to-slider/24390 "2020-04-07T12:41:00Z")

</div>

Hello, I'm trying to set a slider position from a MySQL database. I tested on a gauge and it works well but despite all my tests the slider remains at 0. Can someone explain to me where I made a mistake? Thanks for y…

---

## [Dropdown weird behaviour](https://discourse.nodered.org/t/dropdown-weird-behaviour/24162)

<div class="topic-metadata">

**Author:** [@Sep](https://discourse.nodered.org/u/Sep)\
**Replies:** 1\
**Last updated:** [7 April 2020 11:36 UTC](https://discourse.nodered.org/t/dropdown-weird-behaviour/24162 "2020-04-07T11:36:27Z")

</div>

Hi, I'm experiencing a quite weird behaviour of the dropdown list node. I simply added 3 options (1,2,3) and deployed it on a Group. What happens is that when displaying it, it shows 1,2,3 on a row... If pressing F5 …

---

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

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

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