# General

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

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

**Page:** 811

---

## [MySQL statement help](https://discourse.nodered.org/t/mysql-statement-help/19923)

<div class="topic-metadata">

**Author:** [@Mark\_Ellis](https://discourse.nodered.org/u/Mark_Ellis)\
**Replies:** 8\
**Last updated:** [5 January 2020 12:16 UTC](https://discourse.nodered.org/t/mysql-statement-help/19923 "2020-01-05T12:16:36Z")

</div>

Can some help me with this sql statement which i want to insert into a function node, i would like also to use variables inplace 1 @ State and LRoom1 @ Device, but not yet. msg.topic="UPDATE MultiSenser SET State = 1 WH…

---

## [Happy New Year (well maybe for some) ... A security warning](https://discourse.nodered.org/t/happy-new-year-well-maybe-for-some-a-security-warning/19793)

<div class="topic-metadata">

**Author:** [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Replies:** 21\
**Last updated:** [5 January 2020 09:33 UTC](https://discourse.nodered.org/t/happy-new-year-well-maybe-for-some-a-security-warning/19793 "2020-01-05T09:33:31Z")

</div>

Hi all and happy New Year. With a view to keeping things and people happy, an obligatory security warning to remind everyone that Node-RED is now global and people (including the bad people) are aware of it. So please …

---

## [HTTP - Extracting Specific Information](https://discourse.nodered.org/t/http-extracting-specific-information/19879)

<div class="topic-metadata">

**Author:** [@war1000](https://discourse.nodered.org/u/war1000)\
**Replies:** 6\
**Last updated:** [5 January 2020 03:41 UTC](https://discourse.nodered.org/t/http-extracting-specific-information/19879 "2020-01-05T03:41:51Z")

</div>

Hi Everyone, I am somewhat new to Node-Red but I am leaning a lot. I use it for Hassio automation. One of the things I want to do is extract some information from a website to use in a notification automation. The url…

---

## [Newbie help - If/Then](https://discourse.nodered.org/t/newbie-help-if-then/19913)

<div class="topic-metadata">

**Author:** [@mikewoodld](https://discourse.nodered.org/u/mikewoodld)\
**Replies:** 1\
**Last updated:** [4 January 2020 21:56 UTC](https://discourse.nodered.org/t/newbie-help-if-then/19913 "2020-01-04T21:56:28Z")

</div>

Wondering if I can simplify my project just a bit. Right now, I have two different flows that take HTTP IN and then execute a shell script on the server: I'm wondering if it would instead be possible to have a singl…

---

## [A change in parodyme for flow construction and the \`GATE\` node](https://discourse.nodered.org/t/a-change-in-parodyme-for-flow-construction-and-the-gate-node/19892)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 2\
**Last updated:** [4 January 2020 21:33 UTC](https://discourse.nodered.org/t/a-change-in-parodyme-for-flow-construction-and-the-gate-node/19892 "2020-01-04T21:33:18Z")

</div>

I admit I am still learning some of the existing nodes. When I got into NR a bit further I was wanting a way to control if a message could pass a point. By default there is no obvious way of doing this with the supplie…

---

## [Failed to start NODE-RED graphical event wiring tool](https://discourse.nodered.org/t/failed-to-start-node-red-graphical-event-wiring-tool/19911)

<div class="topic-metadata">

**Author:** [@mikewoodld](https://discourse.nodered.org/u/mikewoodld)\
**Replies:** 1\
**Last updated:** [4 January 2020 19:04 UTC](https://discourse.nodered.org/t/failed-to-start-node-red-graphical-event-wiring-tool/19911 "2020-01-04T19:04:27Z")

</div>

Hi all, looking for some guidance here: I can start node-red manually using node-red and it works properly - but I am not able to use it as a service. I suspect this has something to do with nvm as the above error say…

---

## [Install NodeRED under separate user on RaspberryPi?](https://discourse.nodered.org/t/install-nodered-under-separate-user-on-raspberrypi/19728)

<div class="topic-metadata">

**Author:** [@gunter](https://discourse.nodered.org/u/gunter)\
**Replies:** 22\
**Last updated:** [4 January 2020 18:22 UTC](https://discourse.nodered.org/t/install-nodered-under-separate-user-on-raspberrypi/19728 "2020-01-04T18:22:54Z")

</div>

Hello there, I gifted myself a Raspberry Pi 4 for Christmas in order to set it up with all the wonderful home automation and IoT stuff like NodeRED, mqtt, influxDB, grafana, etc. This shall actually not only be a test s…

---

## [Node red to use onboard pi 3+ bluetooth](https://discourse.nodered.org/t/node-red-to-use-onboard-pi-3-bluetooth/13562)

<div class="topic-metadata">

**Author:** [@thomaslc66](https://discourse.nodered.org/u/thomaslc66)\
**Replies:** 5\
**Last updated:** [4 January 2020 17:23 UTC](https://discourse.nodered.org/t/node-red-to-use-onboard-pi-3-bluetooth/13562 "2020-01-04T17:23:10Z")

</div>

Hello everybody, It's been a day now, that i'm reading on github on other forum, including this one to find a way to do a simple thing. I want to use node-red and the inboard bluetooth of the raspberry pi 3+ to send da…

---

## [Node-RED and Mopidy (with Snap)](https://discourse.nodered.org/t/node-red-and-mopidy-with-snap/19872)

<div class="topic-metadata">

**Author:** [@phreaq](https://discourse.nodered.org/u/phreaq)\
**Replies:** 5\
**Last updated:** [4 January 2020 16:24 UTC](https://discourse.nodered.org/t/node-red-and-mopidy-with-snap/19872 "2020-01-04T16:24:22Z")

</div>

Has anyone got Node-RED working with Mopidy? I tried using https://www.npmjs.com/package/node-red-contrib-mopidy, but I'm not sure how to actually get audio playing on my GH devices.

---

## [Simple-weekly-scheduler How to drop events](https://discourse.nodered.org/t/simple-weekly-scheduler-how-to-drop-events/19876)

<div class="topic-metadata">

**Author:** [@edje11](https://discourse.nodered.org/u/edje11)\
**Replies:** 6\
**Last updated:** [4 January 2020 16:06 UTC](https://discourse.nodered.org/t/simple-weekly-scheduler-how-to-drop-events/19876 "2020-01-04T16:06:37Z")

</div>

Sorry for the stupid question, but I don't understand how to add an event to node-red-contrib-simple-weekly-scheduler . On the webpage the say Events are scheduled by dragging out periods of time on a calendar style int…

---

## [Overlay HTTP Request over MQTT Pub and Sub](https://discourse.nodered.org/t/overlay-http-request-over-mqtt-pub-and-sub/19758)

<div class="topic-metadata">

**Author:** [@cmisztur](https://discourse.nodered.org/u/cmisztur)\
**Replies:** 4\
**Last updated:** [4 January 2020 12:32 UTC](https://discourse.nodered.org/t/overlay-http-request-over-mqtt-pub-and-sub/19758 "2020-01-04T12:32:15Z")

</div>

Hello. What I am trying to accomplish is expose an HTTP endpoint for user to issue POST. Posted data gets manipulated and published to MQTT broker. Once broker processes message it publishes a message with an error co…

---

## [Darksky API Does not Respond with Temperature](https://discourse.nodered.org/t/darksky-api-does-not-respond-with-temperature/19891)

<div class="topic-metadata">

**Author:** [@JCB2277](https://discourse.nodered.org/u/JCB2277)\
**Replies:** 2\
**Last updated:** [4 January 2020 10:16 UTC](https://discourse.nodered.org/t/darksky-api-does-not-respond-with-temperature/19891 "2020-01-04T10:16:24Z")

</div>

The Darksky node does not return the current temperature - all the other info is in the api response and fairly easy to parse out but I had to add hardware to my project for current temperature - would much rather get fr…

---

## [Cannot connect to google “auth worked but profile fetching failed” error](https://discourse.nodered.org/t/cannot-connect-to-google-auth-worked-but-profile-fetching-failed-error/17916)

<div class="topic-metadata">

**Author:** [@Timzoet](https://discourse.nodered.org/u/Timzoet)\
**Replies:** 3\
**Last updated:** [4 January 2020 10:19 UTC](https://discourse.nodered.org/t/cannot-connect-to-google-auth-worked-but-profile-fetching-failed-error/17916 "2020-01-04T10:19:28Z")

</div>

Hi i want to connect to my google calendar so i tried to use the node-red-node-google module but when I try to authenticate with google I get the error message: auth worked but profile fetching failed. I have already goo…

---

## [Can't receive XMPP messages (but sending works)](https://discourse.nodered.org/t/cant-receive-xmpp-messages-but-sending-works/19874)

<div class="topic-metadata">

**Author:** [@eboettn](https://discourse.nodered.org/u/eboettn)\
**Replies:** 10\
**Last updated:** [3 January 2020 23:22 UTC](https://discourse.nodered.org/t/cant-receive-xmpp-messages-but-sending-works/19874 "2020-01-03T23:22:35Z")

</div>

Greetings! I am using the xmpp node in hopes of being able to receive xmpp messages. I run an openfire xmpp server at home and everything runs fine outside of node-red. All clients receive messages and all clients can u…

---

## [Find value in array similar to SQL?](https://discourse.nodered.org/t/find-value-in-array-similar-to-sql/19684)

<div class="topic-metadata">

**Author:** [@Gombol](https://discourse.nodered.org/u/Gombol)\
**Replies:** 7\
**Last updated:** [3 January 2020 23:12 UTC](https://discourse.nodered.org/t/find-value-in-array-similar-to-sql/19684 "2020-01-03T23:12:18Z")

</div>

Hi, in T-SQL it is possible to query the occurance of a specific value in an array of values like this: case when 27 in (12,13,16,17,18) then .... Is there something similar in Node-Red ? I know there are arrays but …

---

## [Change Button Colour in a Function](https://discourse.nodered.org/t/change-button-colour-in-a-function/19836)

<div class="topic-metadata">

**Author:** [@Mario](https://discourse.nodered.org/u/Mario)\
**Replies:** 7\
**Last updated:** [3 January 2020 22:01 UTC](https://discourse.nodered.org/t/change-button-colour-in-a-function/19836 "2020-01-03T22:01:52Z")

</div>

Hello, I have a function in which the status of an output is displayed. Now I want to change the color of the button depending on the status. For example, if the output is open, color red, if it is closed, it is green. I…

---

## [Node-Red and Mosquitto MQTT Encryption Clarification](https://discourse.nodered.org/t/node-red-and-mosquitto-mqtt-encryption-clarification/472)

<div class="topic-metadata">

**Author:** [@RyanStJohn](https://discourse.nodered.org/u/RyanStJohn)\
**Replies:** 9\
**Last updated:** [3 January 2020 14:46 UTC](https://discourse.nodered.org/t/node-red-and-mosquitto-mqtt-encryption-clarification/472 "2020-01-03T14:46:41Z")

</div>

I am running a Mosquitto MQTT that is using TLSV1. I have generated the following files: ca.crt ca.key ca.srl server.crt server.csr server.key I am able to use just “ca.crt” with MQTT.FX in order to publish and subscr…

---

## [Node Red with VISA library](https://discourse.nodered.org/t/node-red-with-visa-library/19868)

<div class="topic-metadata">

**Author:** [@marcambou](https://discourse.nodered.org/u/marcambou)\
**Replies:** 2\
**Last updated:** [3 January 2020 14:11 UTC](https://discourse.nodered.org/t/node-red-with-visa-library/19868 "2020-01-03T14:11:56Z")

</div>

Hello, I would like to control some instrument using VISA protocol (like PyVISA), how can I do it with node red ? Is there already a library ? thanks !

---

## [Grab details from password protected website](https://discourse.nodered.org/t/grab-details-from-password-protected-website/19832)

<div class="topic-metadata">

**Author:** [@ebnerjoh](https://discourse.nodered.org/u/ebnerjoh)\
**Replies:** 6\
**Last updated:** [2 January 2020 18:36 UTC](https://discourse.nodered.org/t/grab-details-from-password-protected-website/19832 "2020-01-02T18:36:19Z")

</div>

Hi, I have a DataLogger for my Solar System and I want to extract values from the internal Webserver of the solar heating system. It is a system from ta.co.at (UVR1611) and as Datalogger I am using the CMI from the sam…

---

## [How to manage serial port disconnection](https://discourse.nodered.org/t/how-to-manage-serial-port-disconnection/14592)

<div class="topic-metadata">

**Author:** [@Charlotte](https://discourse.nodered.org/u/Charlotte)\
**Replies:** 17\
**Last updated:** [3 January 2020 03:17 UTC](https://discourse.nodered.org/t/how-to-manage-serial-port-disconnection/14592 "2020-01-03T03:17:49Z")

</div>

Hello, I'm using Node-red on a Raspberry Pi 3B+ with Raspbian Stretch. I'm also using UUgear 7-port USB hub. I connected RS232 devices with node-red-node-serialport, using the serial request node. For easier device m…

---

## [Converting Unix Time thru Moment](https://discourse.nodered.org/t/converting-unix-time-thru-moment/19840)

<div class="topic-metadata">

**Author:** [@chucksteele](https://discourse.nodered.org/u/chucksteele)\
**Replies:** 2\
**Last updated:** [3 January 2020 01:38 UTC](https://discourse.nodered.org/t/converting-unix-time-thru-moment/19840 "2020-01-03T01:38:19Z")

</div>

I am grabbing the sunrise (payload.daily.data\[0\].sunriseTime) and sunset (payload.daily.data\[0\].sunsetTime) times from the DarkSky node. As its Unix time, I multiply it by 1000, then convert it using two Moment nodes, wh…

---

## [More weird things happening with SUBFLOWS](https://discourse.nodered.org/t/more-weird-things-happening-with-subflows/19842)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 0\
**Last updated:** [2 January 2020 23:06 UTC](https://discourse.nodered.org/t/more-weird-things-happening-with-subflows/19842 "2020-01-02T23:06:56Z")

</div>

Slightly following up from this thread: One problem found That is/was a problem. At the time I was using FF as my browser. It is the latest - AFAIK. 70.1 or something. NR is 1.0.3 Anyway, I am working on a project…

---

## [Install NR using the Script does not work](https://discourse.nodered.org/t/install-nr-using-the-script-does-not-work/19807)

<div class="topic-metadata">

**Author:** [@Golonder](https://discourse.nodered.org/u/Golonder)\
**Replies:** 25\
**Last updated:** [2 January 2020 17:10 UTC](https://discourse.nodered.org/t/install-nr-using-the-script-does-not-work/19807 "2020-01-02T17:10:32Z")

</div>

Hi, I have a brand-new Raspi 4 with Raspbian Buster running and want to install Node-Red now. Unfortunately the script bash \<(curl -sL https://raw.githubusercontent.com/node-red/linux-installers/master/deb/update-node…

---

## [Login External website from node-red](https://discourse.nodered.org/t/login-external-website-from-node-red/19829)

<div class="topic-metadata">

**Author:** [@Josuech](https://discourse.nodered.org/u/Josuech)\
**Replies:** 1\
**Last updated:** [2 January 2020 17:03 UTC](https://discourse.nodered.org/t/login-external-website-from-node-red/19829 "2020-01-02T17:03:53Z")

</div>

Hi world. I need login external website to GET a JSON with data from sensors and instruments

---

## [NPM does not support Node.js v10.15.2](https://discourse.nodered.org/t/npm-does-not-support-node-js-v10-15-2/19810)

<div class="topic-metadata">

**Author:** [@Golonder](https://discourse.nodered.org/u/Golonder)\
**Replies:** 9\
**Last updated:** [2 January 2020 15:42 UTC](https://discourse.nodered.org/t/npm-does-not-support-node-js-v10-15-2/19810 "2020-01-02T15:42:17Z")

</div>

Hi, after installing node-red and npm on my raspi I get an NPM support error. Currently I am running NPM 5.8.0 and Node 10.15.2 If I try to upgrade to a newer NPM using pi@raspberrypi:~ $ sudo npm install npm@latest …

---

## [Python3 script handling](https://discourse.nodered.org/t/python3-script-handling/19796)

<div class="topic-metadata">

**Author:** [@WhiteLion](https://discourse.nodered.org/u/WhiteLion)\
**Replies:** 2\
**Last updated:** [2 January 2020 15:02 UTC](https://discourse.nodered.org/t/python3-script-handling/19796 "2020-01-02T15:02:57Z")

</div>

I want to execute this line / python3 script: "phython3 /home/pi/MFRC522-python/read2.py" the script runs in a loop an prints a line where I want grab information from. It works nice in terminal but I cannot get it to…

---

## [Delay node with delect flush manual or timeout](https://discourse.nodered.org/t/delay-node-with-delect-flush-manual-or-timeout/19824)

<div class="topic-metadata">

**Author:** [@tinamore](https://discourse.nodered.org/u/tinamore)\
**Replies:** 0\
**Last updated:** [2 January 2020 14:51 UTC](https://discourse.nodered.org/t/delay-node-with-delect-flush-manual-or-timeout/19824 "2020-01-02T14:51:17Z")

</div>

Hi I have flow: I set delay node in 10s, if have mqtt out reponse mqtt then i send flush \[Delay node\] for \[http reponse node\] immediately, but timeout 10s then Also http response with body timeout But I can not de…

---

## [Load flows incompatibility between admin API and editor import/export](https://discourse.nodered.org/t/load-flows-incompatibility-between-admin-api-and-editor-import-export/19817)

<div class="topic-metadata">

**Author:** [@gbrito](https://discourse.nodered.org/u/gbrito)\
**Replies:** 2\
**Last updated:** [2 January 2020 12:39 UTC](https://discourse.nodered.org/t/load-flows-incompatibility-between-admin-api-and-editor-import-export/19817 "2020-01-02T12:39:15Z")

</div>

Hi, I noticed that if i export a flow using the editor export, if i try to load the flow using the admin HTTP API (or the runtime API directly) it fails. Also, vice-versa, that is if I use the get/flow:id call with the …

---

## [How to upgrade Node-Red?](https://discourse.nodered.org/t/how-to-upgrade-node-red/6374)

<div class="topic-metadata">

**Author:** [@SteveMann](https://discourse.nodered.org/u/SteveMann)\
**Replies:** 22\
**Last updated:** [2 January 2020 10:16 UTC](https://discourse.nodered.org/t/how-to-upgrade-node-red/6374 "2020-01-02T10:16:56Z")

</div>

How do I upgrade Node-Red, and what will the upgrade likely break? I have two installations of Node-Red, one on Raspian (NR Version 0.17.5) and one on Hass.io (NR Version 0.19.5) and I just realized that the Range node …

---

## [Node-RED Modbus error](https://discourse.nodered.org/t/node-red-modbus-error/19808)

<div class="topic-metadata">

**Author:** [@Unikumet](https://discourse.nodered.org/u/Unikumet)\
**Replies:** 1\
**Last updated:** [2 January 2020 08:34 UTC](https://discourse.nodered.org/t/node-red-modbus-error/19808 "2020-01-02T08:34:41Z")

</div>

Hi, I'm having issues deploying Node-RED after installing the latest Modbus package. I get up the error message: \[modbus-write:e5900382.831fd\] TypeError: Cannot read property 'registerForModbus' of null Command promp…

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

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