# General

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

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

**Page:** 753

---

## [Write OPC UA Variables to MySQL](https://discourse.nodered.org/t/write-opc-ua-variables-to-mysql/25820)

<div class="topic-metadata">

**Author:** [@jrlion](https://discourse.nodered.org/u/jrlion)\
**Replies:** 10\
**Last updated:** [8 May 2020 11:36 UTC](https://discourse.nodered.org/t/write-opc-ua-variables-to-mysql/25820 "2020-05-08T11:36:48Z")

</div>

Hello Forum, I'm currently doing a project on reading out OPC UA Signals and writing them into a MySQL Database. There have been already a lot of threads helping me with writing a single variable into MySQL but right no…

---

## [How to delete the spacing of the last word in the output from speech to text?](https://discourse.nodered.org/t/how-to-delete-the-spacing-of-the-last-word-in-the-output-from-speech-to-text/26299)

<div class="topic-metadata">

**Author:** [@lingzhongli](https://discourse.nodered.org/u/lingzhongli)\
**Replies:** 1\
**Last updated:** [8 May 2020 10:04 UTC](https://discourse.nodered.org/t/how-to-delete-the-spacing-of-the-last-word-in-the-output-from-speech-to-text/26299 "2020-05-08T10:04:33Z")

</div>

it have the way to delete the spacing at the last of "hello"? i dont want it have spacing after the last word

---

## [Server of IP changes automatically changes in mqtt in and out](https://discourse.nodered.org/t/server-of-ip-changes-automatically-changes-in-mqtt-in-and-out/26297)

<div class="topic-metadata">

**Author:** [@saeed1](https://discourse.nodered.org/u/saeed1)\
**Replies:** 2\
**Last updated:** [8 May 2020 09:37 UTC](https://discourse.nodered.org/t/server-of-ip-changes-automatically-changes-in-mqtt-in-and-out/26297 "2020-05-08T09:37:13Z")

</div>

Hi, Sentek1 is mqtt in node. I want to write localhost as server. Sentek2 is mqtt out node. I want to write another IP like 192.168.1.22 as server Unfortunately, when i adjust the mqtt out node and i write the IP in…

---

## [Inject node bug - interval option issue](https://discourse.nodered.org/t/inject-node-bug-interval-option-issue/26294)

<div class="topic-metadata">

**Author:** [@ch4mploo](https://discourse.nodered.org/u/ch4mploo)\
**Replies:** 4\
**Last updated:** [8 May 2020 09:19 UTC](https://discourse.nodered.org/t/inject-node-bug-interval-option-issue/26294 "2020-05-08T09:19:31Z")

</div>

I have been trying out the inject node interval option. However, when I was configuring it, I found out that there is no text box for me to enter the amount of time interval I would like to set. The picture shows the nod…

---

## [Nodemcu/Tasmota/Node Red/Mqtt for temp](https://discourse.nodered.org/t/nodemcu-tasmota-node-red-mqtt-for-temp/26292)

<div class="topic-metadata">

**Author:** [@mjdula](https://discourse.nodered.org/u/mjdula)\
**Replies:** 1\
**Last updated:** [8 May 2020 07:27 UTC](https://discourse.nodered.org/t/nodemcu-tasmota-node-red-mqtt-for-temp/26292 "2020-05-08T07:27:01Z")

</div>

Hey Guys, Need help. Im using a Nodemcu with Tasmota installed to send a DS18B20 temp probe data to node red. I have been able to have the info come into node red but the payload isn't broken up. I want to be able to us…

---

## [4 digiLED Display TM1637 to GPIO](https://discourse.nodered.org/t/4-digiled-display-tm1637-to-gpio/26232)

<div class="topic-metadata">

**Author:** [@wmarcel](https://discourse.nodered.org/u/wmarcel)\
**Replies:** 3\
**Last updated:** [8 May 2020 06:55 UTC](https://discourse.nodered.org/t/4-digiled-display-tm1637-to-gpio/26232 "2020-05-08T06:55:23Z")

</div>

Hello everybody. I would like to expand my control from the terrarium with two 7 segment displays TM1637. The temperature should be on one side and the humidity on the other. Both values ​​are already in Node Red via …

---

## [Options missing in palette manager](https://discourse.nodered.org/t/options-missing-in-palette-manager/26276)

<div class="topic-metadata">

**Author:** [@LosinIt](https://discourse.nodered.org/u/LosinIt)\
**Replies:** 4\
**Last updated:** [7 May 2020 23:28 UTC](https://discourse.nodered.org/t/options-missing-in-palette-manager/26276 "2020-05-07T23:28:31Z")

</div>

I tried to use the palette manager to update the dashboard a while ago and found I only have a disable option. I read here that it is likely that npm is not available so I checked the startup in the logs and there is …

---

## [PLC Offline \>\< Online](https://discourse.nodered.org/t/plc-offline-online/26252)

<div class="topic-metadata">

**Author:** [@rromele](https://discourse.nodered.org/u/rromele)\
**Replies:** 3\
**Last updated:** [7 May 2020 22:41 UTC](https://discourse.nodered.org/t/plc-offline-online/26252 "2020-05-07T22:41:09Z")

</div>

Hi, when the plc is offline the flow stops, instead I would like to write the number "-1" in the following nodes, how could I do this? Thanks very much for your help.

---

## [Projects/git how go back to older project state?](https://discourse.nodered.org/t/projects-git-how-go-back-to-older-project-state/26217)

<div class="topic-metadata">

**Author:** [@nosebaer](https://discourse.nodered.org/u/nosebaer)\
**Replies:** 7\
**Last updated:** [7 May 2020 17:59 UTC](https://discourse.nodered.org/t/projects-git-how-go-back-to-older-project-state/26217 "2020-05-07T17:59:42Z")

</div>

I was now able to configure projects/github thanks the help of @Colin: /enable-projects-for-using-github-is-not-working Now I have the question: how can I go back to an older state of my project with projects/git state…

---

## [How can i test azure connection?](https://discourse.nodered.org/t/how-can-i-test-azure-connection/26094)

<div class="topic-metadata">

**Author:** [@Beefy\_carrot](https://discourse.nodered.org/u/Beefy_carrot)\
**Replies:** 6\
**Last updated:** [7 May 2020 17:43 UTC](https://discourse.nodered.org/t/how-can-i-test-azure-connection/26094 "2020-05-07T17:43:49Z")

</div>

I want to test if i have a connection to azure. how can i do that ?

---

## [Loop conditions](https://discourse.nodered.org/t/loop-conditions/26253)

<div class="topic-metadata">

**Author:** [@Marty1982](https://discourse.nodered.org/u/Marty1982)\
**Replies:** 2\
**Last updated:** [7 May 2020 17:16 UTC](https://discourse.nodered.org/t/loop-conditions/26253 "2020-05-07T17:16:19Z")

</div>

Hi all! I have a simple condition check nodes. The chain is like this: suncalc --\> switch --\> sonoff http on or off --\> function to send me a telegram message The chains works ok but it is working in a repeating loo…

---

## [How can I check whether a value is a certain timeabove the value of another variable?](https://discourse.nodered.org/t/how-can-i-check-whether-a-value-is-a-certain-timeabove-the-value-of-another-variable/26249)

<div class="topic-metadata">

**Author:** [@Kiwi\_gamer01](https://discourse.nodered.org/u/Kiwi_gamer01)\
**Replies:** 4\
**Last updated:** [7 May 2020 16:15 UTC](https://discourse.nodered.org/t/how-can-i-check-whether-a-value-is-a-certain-timeabove-the-value-of-another-variable/26249 "2020-05-07T16:15:26Z")

</div>

How can I check whether a value (e.g. from one variable) is a certain time (e.g. 15 minutes) above the value of another variable?

---

## [Node Red, Docker on Synology does not honor the timezone, always selects UTC no matter what](https://discourse.nodered.org/t/node-red-docker-on-synology-does-not-honor-the-timezone-always-selects-utc-no-matter-what/14860)

<div class="topic-metadata">

**Author:** [@pseudonoob](https://discourse.nodered.org/u/pseudonoob)\
**Replies:** 5\
**Last updated:** [7 May 2020 16:00 UTC](https://discourse.nodered.org/t/node-red-docker-on-synology-does-not-honor-the-timezone-always-selects-utc-no-matter-what/14860 "2020-05-07T16:00:50Z")

</div>

Running on the latest version of Synology as of today, which has Docker and docker compose updated to very recent versions, this is what's in my compose file: nodered: container\_name: nodered restart: always …

---

## [How to track down Uncaught Exception](https://discourse.nodered.org/t/how-to-track-down-uncaught-exception/26229)

<div class="topic-metadata">

**Author:** [@Dave](https://discourse.nodered.org/u/Dave)\
**Replies:** 7\
**Last updated:** [7 May 2020 13:03 UTC](https://discourse.nodered.org/t/how-to-track-down-uncaught-exception/26229 "2020-05-07T13:03:13Z")

</div>

note\* this issue is intermittent, over the last days its happens perhaps 3 times out of maybe 100 deploys. I noticed instead of Deploying when I press the Deploy button on the editor, Node-Red restarts, first I thought …

---

## [Help with storing and recalling light states](https://discourse.nodered.org/t/help-with-storing-and-recalling-light-states/26243)

<div class="topic-metadata">

**Author:** [@ellnic](https://discourse.nodered.org/u/ellnic)\
**Replies:** 0\
**Last updated:** [7 May 2020 14:35 UTC](https://discourse.nodered.org/t/help-with-storing-and-recalling-light-states/26243 "2020-05-07T14:35:39Z")

</div>

Hello all :slight\_smile: I hope you are all keeping well in these difficult times. I am trying to figure out the best way to stop flows from interfering with lights if they have been manually turned on. I have several …

---

## [How to divide 2 values from 2 separate messages](https://discourse.nodered.org/t/how-to-divide-2-values-from-2-separate-messages/26233)

<div class="topic-metadata">

**Author:** [@jfehl](https://discourse.nodered.org/u/jfehl)\
**Replies:** 3\
**Last updated:** [7 May 2020 14:05 UTC](https://discourse.nodered.org/t/how-to-divide-2-values-from-2-separate-messages/26233 "2020-05-07T14:05:59Z")

</div>

I am trying to do some very simple division of two values and continue to get a 'NULL' result. I believe this is due to different data types. (Int and Float) I have previously converted one of these data types from M…

---

## [Disappearing Flow](https://discourse.nodered.org/t/disappearing-flow/26238)

<div class="topic-metadata">

**Author:** [@FlangeMonkey](https://discourse.nodered.org/u/FlangeMonkey)\
**Replies:** 4\
**Last updated:** [7 May 2020 13:07 UTC](https://discourse.nodered.org/t/disappearing-flow/26238 "2020-05-07T13:07:50Z")

</div>

Hi Guys, I have a flow I was working on yesterday disappear on me today. When I search for its label, it isn't in the flows.json file, but if I go under "configuration" I see components within the "On all flows" I was …

---

## [Preventing multiple inputs/triggers](https://discourse.nodered.org/t/preventing-multiple-inputs-triggers/26221)

<div class="topic-metadata">

**Author:** [@haskle](https://discourse.nodered.org/u/haskle)\
**Replies:** 2\
**Last updated:** [7 May 2020 09:31 UTC](https://discourse.nodered.org/t/preventing-multiple-inputs-triggers/26221 "2020-05-07T09:31:04Z")

</div>

First time user, so please be gentle :stuck\_out\_tongue\_winking\_eye: How best to pass the first instance of a message on to the next node, then ignore subsequent messages for a set time period? My solar pv panels send a…

---

## [Enable projects for using github is not working](https://discourse.nodered.org/t/enable-projects-for-using-github-is-not-working/26191)

<div class="topic-metadata">

**Author:** [@nosebaer](https://discourse.nodered.org/u/nosebaer)\
**Replies:** 2\
**Last updated:** [7 May 2020 08:22 UTC](https://discourse.nodered.org/t/enable-projects-for-using-github-is-not-working/26191 "2020-05-07T08:22:02Z")

</div>

I want to use GitHub within Node-Red and configured the file settings.js in this way: }, editorTheme: { projects: { enabled: true } } } After stopping and starting node-red i see th…

---

## [How can be runtime monitoring be done on Node Red?](https://discourse.nodered.org/t/how-can-be-runtime-monitoring-be-done-on-node-red/26209)

<div class="topic-metadata">

**Author:** [@red\_arrowhead](https://discourse.nodered.org/u/red_arrowhead)\
**Replies:** 14\
**Last updated:** [7 May 2020 07:35 UTC](https://discourse.nodered.org/t/how-can-be-runtime-monitoring-be-done-on-node-red/26209 "2020-05-07T07:35:27Z")

</div>

I have multiple workflows created in the Node-Red window. But how can the execution of multiple workflows be monitored? That is runtime monitoring? Currently while developing I can check to go to each workflow separately…

---

## [Set time + add timer for X-hrs + notify](https://discourse.nodered.org/t/set-time-add-timer-for-x-hrs-notify/26199)

<div class="topic-metadata">

**Author:** [@CaptainSweatpants](https://discourse.nodered.org/u/CaptainSweatpants)\
**Replies:** 2\
**Last updated:** [7 May 2020 07:19 UTC](https://discourse.nodered.org/t/set-time-add-timer-for-x-hrs-notify/26199 "2020-05-07T07:19:48Z")

</div>

Super new to HA and Node Red; so far I love it and I’m so glad to be moving away from my previous “Alexa” limitations. With that said, I’ve done some searching and can’t seem to find the complete answer to this. I’m ma…

---

## [Storing data into node-red](https://discourse.nodered.org/t/storing-data-into-node-red/26112)

<div class="topic-metadata">

**Author:** [@akhtar321h](https://discourse.nodered.org/u/akhtar321h)\
**Replies:** 19\
**Last updated:** [7 May 2020 06:17 UTC](https://discourse.nodered.org/t/storing-data-into-node-red/26112 "2020-05-07T06:17:15Z")

</div>

Hello Everybody, I am doing one project, in which I am accessing some data from the device and i need to send that data on the server or any other machine through mqtt protocol, but if server or target machine is not av…

---

## [Using the Sharp IR distance sensor?](https://discourse.nodered.org/t/using-the-sharp-ir-distance-sensor/26203)

<div class="topic-metadata">

**Author:** [@Cmilian](https://discourse.nodered.org/u/Cmilian)\
**Replies:** 1\
**Last updated:** [7 May 2020 03:16 UTC](https://discourse.nodered.org/t/using-the-sharp-ir-distance-sensor/26203 "2020-05-07T03:16:35Z")

</div>

Does anyone have experience using the Sharp IR distance sensor? I am trying to get distance data from one thru a raspberry pi to display on a data field on the Blynk app. New to Node Red. Any help will be most appreciat…

---

## [Change Node: Is there a simple solution or should I stick with function node](https://discourse.nodered.org/t/change-node-is-there-a-simple-solution-or-should-i-stick-with-function-node/26195)

<div class="topic-metadata">

**Author:** [@tmichaeltx](https://discourse.nodered.org/u/tmichaeltx)\
**Replies:** 2\
**Last updated:** [6 May 2020 23:07 UTC](https://discourse.nodered.org/t/change-node-is-there-a-simple-solution-or-should-i-stick-with-function-node/26195 "2020-05-06T23:07:35Z")

</div>

In my msg object, I have a payload and another key named globalsource. I want to take the payload and put it into a global variable named global.(contents of msg.globalsource). This is simple enough in a function node: …

---

## [Node-Red Freezes](https://discourse.nodered.org/t/node-red-freezes/26035)

<div class="topic-metadata">

**Author:** [@n61ab](https://discourse.nodered.org/u/n61ab)\
**Replies:** 8\
**Last updated:** [6 May 2020 21:21 UTC](https://discourse.nodered.org/t/node-red-freezes/26035 "2020-05-06T21:21:36Z")

</div>

I am trying to use an “ina-sensor” node to read the volts/amps from an INA219 sensor from ada-fruit. This sensor works on the I2C bus. When I add the sensor, my Node-Red fails after a few hours. I re-booted the Raspbe…

---

## [Use the node red dashboard from any machine through a VPN network](https://discourse.nodered.org/t/use-the-node-red-dashboard-from-any-machine-through-a-vpn-network/26136)

<div class="topic-metadata">

**Author:** [@Joaovitor](https://discourse.nodered.org/u/Joaovitor)\
**Replies:** 10\
**Last updated:** [6 May 2020 20:57 UTC](https://discourse.nodered.org/t/use-the-node-red-dashboard-from-any-machine-through-a-vpn-network/26136 "2020-05-06T20:57:20Z")

</div>

I have been involved in an iot project using node red executed on a local host. One of the problems with this is that I can only access the dashboard through my machine within the local network. I was thinking and I tho…

---

## [NR not receiving MQTT](https://discourse.nodered.org/t/nr-not-receiving-mqtt/26183)

<div class="topic-metadata">

**Author:** [@jayballz](https://discourse.nodered.org/u/jayballz)\
**Replies:** 8\
**Last updated:** [6 May 2020 19:57 UTC](https://discourse.nodered.org/t/nr-not-receiving-mqtt/26183 "2020-05-06T19:57:19Z")

</div>

Hi friends, today NR stopped receiving mqtt-messages from localhost:1883 (mosquitto without any fancy settings) after i reinstalled NR since i had some issues with Git and stuff (that's another topic). I checked with M…

---

## [Long command in multiple lines](https://discourse.nodered.org/t/long-command-in-multiple-lines/26190)

<div class="topic-metadata">

**Author:** [@RogierQ](https://discourse.nodered.org/u/RogierQ)\
**Replies:** 2\
**Last updated:** [6 May 2020 19:51 UTC](https://discourse.nodered.org/t/long-command-in-multiple-lines/26190 "2020-05-06T19:51:36Z")

</div>

I asked this question long time ago but cannot find it again... having a long sql command that i want to write in multiple lines like: msg.topic = "SELECT id, firstname, lastname FROM MyGuests" as: msg.topic=" SEL…

---

## [Using Node-RED with Angular](https://discourse.nodered.org/t/using-node-red-with-angular/26166)

<div class="topic-metadata">

**Author:** [@dhpatel177](https://discourse.nodered.org/u/dhpatel177)\
**Replies:** 4\
**Last updated:** [6 May 2020 19:49 UTC](https://discourse.nodered.org/t/using-node-red-with-angular/26166 "2020-05-06T19:49:00Z")

</div>

---

## [Deploy node-RED with dashboard on Azure?](https://discourse.nodered.org/t/deploy-node-red-with-dashboard-on-azure/26181)

<div class="topic-metadata">

**Author:** [@ricardojosegomezulmk](https://discourse.nodered.org/u/ricardojosegomezulmk)\
**Replies:** 1\
**Last updated:** [6 May 2020 19:45 UTC](https://discourse.nodered.org/t/deploy-node-red-with-dashboard-on-azure/26181 "2020-05-06T19:45:08Z")

</div>

I have developed a node-RED app with a dashboard. Now I would like to host it for colleagues in Azure. I understand I can put together a docker image or use a ubuntu vm, install node-red and my flows. but how can I a…

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

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