# General

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

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

**Page:** 195

---

## [Help - Docker - Can't connect to MQTT](https://discourse.nodered.org/t/help-docker-cant-connect-to-mqtt/79489)

<div class="topic-metadata">

**Author:** [@spyder0552](https://discourse.nodered.org/u/spyder0552)\
**Replies:** 3\
**Last updated:** [17 July 2023 00:49 UTC](https://discourse.nodered.org/t/help-docker-cant-connect-to-mqtt/79489 "2023-07-17T00:49:08Z")

</div>

New to Docker and need some help. I have a PUBLIC mqtt server that I know works as I have numerous devices connected to it. I just created a docker container following the setup instructions in this fourm/site. I add …

---

## [Error installing DB2 node](https://discourse.nodered.org/t/error-installing-db2-node/78438)

<div class="topic-metadata">

**Author:** [@jts450](https://discourse.nodered.org/u/jts450)\
**Replies:** 4\
**Last updated:** [16 July 2023 19:26 UTC](https://discourse.nodered.org/t/error-installing-db2-node/78438 "2023-07-16T19:26:07Z")

</div>

I received an error installing this module. Any suggestions? Thank you, 369 error command failed 370 error command C:\\WINDOWS\\system32\\cmd.exe /d /s /c node installer/driverInstall.js 371 error fs.js:47 371 error …

---

## [Using split to get usable data from google bard response](https://discourse.nodered.org/t/using-split-to-get-usable-data-from-google-bard-response/79826)

<div class="topic-metadata">

**Author:** [@umtksa](https://discourse.nodered.org/u/umtksa)\
**Replies:** 10\
**Last updated:** [16 July 2023 16:15 UTC](https://discourse.nodered.org/t/using-split-to-get-usable-data-from-google-bard-response/79826 "2023-07-16T16:15:33Z")

</div>

I have a flow that use my browser cookies to make a request on google bard. I'm getting the data and I guess it's some how an incomplete json ? :face\_with\_diagonal\_mouth: \[{"id":"4d80142b28554cfd","type":"split","z":"e…

---

## [Can't handle conflicts using docker](https://discourse.nodered.org/t/cant-handle-conflicts-using-docker/78971)

<div class="topic-metadata">

**Author:** [@thalesmaoa](https://discourse.nodered.org/u/thalesmaoa)\
**Replies:** 7\
**Last updated:** [16 July 2023 15:12 UTC](https://discourse.nodered.org/t/cant-handle-conflicts-using-docker/78971 "2023-07-16T15:12:50Z")

</div>

Hello! I'm developing a project with a bitbucket repository. No problem so far. I have a friend that got involved and wanna help. I shared the repo with him but I'm getting error on with branch conflict. Expected behav…

---

## [LIRC with node-red docker](https://discourse.nodered.org/t/lirc-with-node-red-docker/79863)

<div class="topic-metadata">

**Author:** [@Hopperpop](https://discourse.nodered.org/u/Hopperpop)\
**Replies:** 0\
**Last updated:** [16 July 2023 14:27 UTC](https://discourse.nodered.org/t/lirc-with-node-red-docker/79863 "2023-07-16T14:27:13Z")

</div>

I had an old Medion X10 remote laying around, that I liked to use for controlling my home. It's a RF remote with usb receiver. I successfully installed LIRC on the host, and learned the codes for the remote. I now want t…

---

## [Operation of a slider](https://discourse.nodered.org/t/operation-of-a-slider/79857)

<div class="topic-metadata">

**Author:** [@Surfb](https://discourse.nodered.org/u/Surfb)\
**Replies:** 2\
**Last updated:** [16 July 2023 04:46 UTC](https://discourse.nodered.org/t/operation-of-a-slider/79857 "2023-07-16T04:46:05Z")

</div>

I have 4 injections, 2 for the X axis and the other 2 for the Y axis; I want that when the "up" is pressed it adds 1 and when the "down" is pressed it subtracts 1, thus with a maximum value of 100, the same for "left" an…

---

## [MySql node, how to escape queries?](https://discourse.nodered.org/t/mysql-node-how-to-escape-queries/79809)

<div class="topic-metadata">

**Author:** [@andre\_x](https://discourse.nodered.org/u/andre_x)\
**Replies:** 7\
**Last updated:** [16 July 2023 11:08 UTC](https://discourse.nodered.org/t/mysql-node-how-to-escape-queries/79809 "2023-07-16T11:08:41Z")

</div>

I'm using the node-red-node-mysql, but I need to escape the queries, mainly because the single quotes brakes the queries. How can I do that? Thanks!

---

## [Hardware Advice to run a simple data collection flow](https://discourse.nodered.org/t/hardware-advice-to-run-a-simple-data-collection-flow/79804)

<div class="topic-metadata">

**Author:** [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Replies:** 6\
**Last updated:** [16 July 2023 10:02 UTC](https://discourse.nodered.org/t/hardware-advice-to-run-a-simple-data-collection-flow/79804 "2023-07-16T10:02:32Z")

</div>

I have a very simple flow which collects and records around 30 inputs from a PLC register every minute and stores the data in a MySQL Database. The flow.json size is 50kb. The MySQL database is at 96 MB and has a years…

---

## [JSONata is true but switch node will not pass msg through](https://discourse.nodered.org/t/jsonata-is-true-but-switch-node-will-not-pass-msg-through/79855)

<div class="topic-metadata">

**Author:** [@bjzy](https://discourse.nodered.org/u/bjzy)\
**Replies:** 2\
**Last updated:** [16 July 2023 02:44 UTC](https://discourse.nodered.org/t/jsonata-is-true-but-switch-node-will-not-pass-msg-through/79855 "2023-07-16T02:44:29Z")

</div>

Hi - I'm new to Node-RED and am trying to use JSONata in a Switch node to route my msg.payload. I found this in my search and attempted to replicate it for my data. Though the JSONata Test reports True, my payload goes…

---

## [Fresh install Raspberry Pi OS and node-RED, copied old .json files, no flows](https://discourse.nodered.org/t/fresh-install-raspberry-pi-os-and-node-red-copied-old-json-files-no-flows/79845)

<div class="topic-metadata">

**Author:** [@maru](https://discourse.nodered.org/u/maru)\
**Replies:** 9\
**Last updated:** [15 July 2023 17:17 UTC](https://discourse.nodered.org/t/fresh-install-raspberry-pi-os-and-node-red-copied-old-json-files-no-flows/79845 "2023-07-15T17:17:21Z")

</div>

Hi, Had some problems with the recent Buster Lite and node-Red on a Rpi4 B, so decided to a fresh Raspberry Pi OS 64B Lite installation on a new SDCard. After the booting I installed the update/upgrade and now I can ma…

---

## [Output sequentially and randomly to 3 different nodes](https://discourse.nodered.org/t/output-sequentially-and-randomly-to-3-different-nodes/79564)

<div class="topic-metadata">

**Author:** [@usernamepasswordBS](https://discourse.nodered.org/u/usernamepasswordBS)\
**Replies:** 34\
**Last updated:** [15 July 2023 17:42 UTC](https://discourse.nodered.org/t/output-sequentially-and-randomly-to-3-different-nodes/79564 "2023-07-15T17:42:07Z")

</div>

Hi, I am looking for a few clues as to how to switch on randomly 3 relays, one by one depending on conditions and then switch them off either randomly or in the same order one by one. The project is a 3-element heater w…

---

## [Torrent File Upload With HTTP Request Node Not Working](https://discourse.nodered.org/t/torrent-file-upload-with-http-request-node-not-working/79839)

<div class="topic-metadata">

**Author:** [@boardwarp](https://discourse.nodered.org/u/boardwarp)\
**Replies:** 2\
**Last updated:** [15 July 2023 10:06 UTC](https://discourse.nodered.org/t/torrent-file-upload-with-http-request-node-not-working/79839 "2023-07-15T10:06:47Z")

</div>

I'm trying to use the File Upload using HTTP Request node info as a basis for sending a torrent file to qBittorrent using the qBittorrent Web API, but I get a Error: 'gimp-2.10.34-setup.exe.torrent' is not a valid torren…

---

## [Problem with connect to Tuya devices](https://discourse.nodered.org/t/problem-with-connect-to-tuya-devices/79840)

<div class="topic-metadata">

**Author:** [@skom](https://discourse.nodered.org/u/skom)\
**Replies:** 0\
**Last updated:** [15 July 2023 09:34 UTC](https://discourse.nodered.org/t/problem-with-connect-to-tuya-devices/79840 "2023-07-15T09:34:53Z")

</div>

I have Node Red (v3.0.2) on Raspberry Pi 4B. I want to use node-red-contrib-tuya-smart-device (v5.2.0) to read my tuya devices (from cloud, not local). After downloading ID and Key from https://eu.iot.tuya.com/ and …

---

## [How to encode enocean message](https://discourse.nodered.org/t/how-to-encode-enocean-message/79827)

<div class="topic-metadata">

**Author:** [@sepp](https://discourse.nodered.org/u/sepp)\
**Replies:** 2\
**Last updated:** [15 July 2023 04:08 UTC](https://discourse.nodered.org/t/how-to-encode-enocean-message/79827 "2023-07-15T04:08:40Z")

</div>

hi, i have an enocean temperatursensor which is sending to my node red aplication. how can i decode (extract) temperatur out from the message string and display it on dashboard? this for examle is the payload 55000a07…

---

## [Trigger node with link call](https://discourse.nodered.org/t/trigger-node-with-link-call/79830)

<div class="topic-metadata">

**Author:** [@harelabb](https://discourse.nodered.org/u/harelabb)\
**Replies:** 2\
**Last updated:** [14 July 2023 23:45 UTC](https://discourse.nodered.org/t/trigger-node-with-link-call/79830 "2023-07-14T23:45:49Z")

</div>

I have a problem with a trigger node inside a link-in/link out sequence called by a link call node. All the messages that are 'swallowed' by the trigger node to extend delay cause timeout errors. flows.json (3.2 KB) I…

---

## [Logging/saving flow events](https://discourse.nodered.org/t/logging-saving-flow-events/79834)

<div class="topic-metadata">

**Author:** [@jsprenkle](https://discourse.nodered.org/u/jsprenkle)\
**Replies:** 2\
**Last updated:** [14 July 2023 23:05 UTC](https://discourse.nodered.org/t/logging-saving-flow-events/79834 "2023-07-14T23:05:38Z")

</div>

Good evening, Newbie question: When creating a flow I see you can use a debug node, and the editor has tool tips with some data. Are the messages passed between nodes saved anywhere so we can analyze what happened?

---

## [Unable to install/update Palettes](https://discourse.nodered.org/t/unable-to-install-update-palettes/79825)

<div class="topic-metadata">

**Author:** [@Kositch](https://discourse.nodered.org/u/Kositch)\
**Replies:** 3\
**Last updated:** [14 July 2023 21:17 UTC](https://discourse.nodered.org/t/unable-to-install-update-palettes/79825 "2023-07-14T21:17:54Z")

</div>

Hi, whenever i try to update some Palettes or install new one (for example: node-red-contrib-netatmo-dashboard 1.0.0) I get this error. In node\_modules folder there is already that folder which asks that log to rename ha…

---

## [Reset SunMeter Node](https://discourse.nodered.org/t/reset-sunmeter-node/79492)

<div class="topic-metadata">

**Author:** [@Harryx99](https://discourse.nodered.org/u/Harryx99)\
**Replies:** 8\
**Last updated:** [14 July 2023 19:29 UTC](https://discourse.nodered.org/t/reset-sunmeter-node/79492 "2023-07-14T19:29:07Z")

</div>

Hello. how can I reset the SunMeter node? I like to reset the value every day mid night for instance. The "Power" can be rested by "payload 0" but I have no idea to reset "Energy".

---

## [Client.state() failed with state -2](https://discourse.nodered.org/t/client-state-failed-with-state-2/79646)

<div class="topic-metadata">

**Author:** [@gajjer](https://discourse.nodered.org/u/gajjer)\
**Replies:** 21\
**Last updated:** [14 July 2023 17:22 UTC](https://discourse.nodered.org/t/client-state-failed-with-state-2/79646 "2023-07-14T17:22:37Z")

</div>

I have an ESP32-CAM module that I want to run in my greenhouse too far away for the WiFi to reach. I added a WiFi extender that gives me a new SSID of EXISTING\_SSID\_EXT. Things work ok when I fire the module up close to …

---

## [How to set up an alexa voice command correctly in nodered](https://discourse.nodered.org/t/how-to-set-up-an-alexa-voice-command-correctly-in-nodered/79789)

<div class="topic-metadata">

**Author:** [@franz](https://discourse.nodered.org/u/franz)\
**Replies:** 5\
**Last updated:** [14 July 2023 15:24 UTC](https://discourse.nodered.org/t/how-to-set-up-an-alexa-voice-command-correctly-in-nodered/79789 "2023-07-14T15:24:24Z")

</div>

I use the node-red-contrib-alexa-remote2-applestrudel in nodered. I can get an external thermometer to read the temperature via the voice command "alexa external thermometer" but lately alexa responds with a descrip…

---

## [Counter on rising edge only](https://discourse.nodered.org/t/counter-on-rising-edge-only/79821)

<div class="topic-metadata">

**Author:** [@Smidaimene](https://discourse.nodered.org/u/Smidaimene)\
**Replies:** 2\
**Last updated:** [14 July 2023 14:54 UTC](https://discourse.nodered.org/t/counter-on-rising-edge-only/79821 "2023-07-14T14:54:18Z")

</div>

I am using rpi to calculate number of pieces I need to increment each rising edge through the rpi Then if the switch ui node is on the counter stops and if it is off it increments from the last value it stopped It ret…

---

## [Provision Configurations for Brokers, Database on startup](https://discourse.nodered.org/t/provision-configurations-for-brokers-database-on-startup/79811)

<div class="topic-metadata">

**Author:** [@Shan](https://discourse.nodered.org/u/Shan)\
**Replies:** 5\
**Last updated:** [14 July 2023 10:04 UTC](https://discourse.nodered.org/t/provision-configurations-for-brokers-database-on-startup/79811 "2023-07-14T10:04:20Z")

</div>

In Node-RED, is there a way to provision Credentials to MQTT broker or certain databases via settings or a configuration file so that they are available in Node-RED when it is brought up / Docker container is spun up? I…

---

## [How to close the DB connections created via a PostgreSQL node?](https://discourse.nodered.org/t/how-to-close-the-db-connections-created-via-a-postgresql-node/79807)

<div class="topic-metadata">

**Author:** [@radhika\_els](https://discourse.nodered.org/u/radhika_els)\
**Replies:** 3\
**Last updated:** [14 July 2023 09:25 UTC](https://discourse.nodered.org/t/how-to-close-the-db-connections-created-via-a-postgresql-node/79807 "2023-07-14T09:25:36Z")

</div>

I currently use the PostgreSQL node a lot to query my DB and display data on dashboard. With every query I make, a new DB connection has been created. In addition to this since I have set the frequency to query every 2hr…

---

## [PostgreSQL node Queue value](https://discourse.nodered.org/t/postgresql-node-queue-value/79792)

<div class="topic-metadata">

**Author:** [@Samokomo](https://discourse.nodered.org/u/Samokomo)\
**Replies:** 3\
**Last updated:** [14 July 2023 08:43 UTC](https://discourse.nodered.org/t/postgresql-node-queue-value/79792 "2023-07-14T08:43:42Z")

</div>

Hello guys, how to access value of Queue of postgres node? Or maybe a better question, how to batch import the data into postgres in nodered (array of objects) ? Thanks!

---

## [How to monitor mqtt publisher is alive](https://discourse.nodered.org/t/how-to-monitor-mqtt-publisher-is-alive/14021)

<div class="topic-metadata">

**Author:** [@Petr](https://discourse.nodered.org/u/Petr)\
**Replies:** 16\
**Last updated:** [13 July 2023 23:18 UTC](https://discourse.nodered.org/t/how-to-monitor-mqtt-publisher-is-alive/14021 "2023-07-13T23:18:36Z")

</div>

Is there a way to monitor mqtt message did not come in predefined interval? In other words, I want to monitor mqtt publisher is alive and sending messages.

---

## [Node red 3 login](https://discourse.nodered.org/t/node-red-3-login/79794)

<div class="topic-metadata">

**Author:** [@Nilpferd](https://discourse.nodered.org/u/Nilpferd)\
**Replies:** 4\
**Last updated:** [13 July 2023 16:35 UTC](https://discourse.nodered.org/t/node-red-3-login/79794 "2023-07-13T16:35:48Z")

</div>

I forgot the login - how can I reset it. regards Erwin

---

## [How do I send SMS messages via the ZTE MF286D MiFi device?](https://discourse.nodered.org/t/how-do-i-send-sms-messages-via-the-zte-mf286d-mifi-device/79773)

<div class="topic-metadata">

**Author:** [@dynamicdave](https://discourse.nodered.org/u/dynamicdave)\
**Replies:** 7\
**Last updated:** [13 July 2023 10:27 UTC](https://discourse.nodered.org/t/how-do-i-send-sms-messages-via-the-zte-mf286d-mifi-device/79773 "2023-07-13T10:27:43Z")

</div>

I'm trying to find our how to send SMS messages via the ZTE MF286D MiFi device ? I've recently purchased this device and discovered I can manually send/receive SMS messages via the user-interface web page. What I'd like…

---

## [global.set("wled",true,"storeInFile")](https://discourse.nodered.org/t/global-set-wled-true-storeinfile/79779)

<div class="topic-metadata">

**Author:** [@edstobi](https://discourse.nodered.org/u/edstobi)\
**Replies:** 7\
**Last updated:** [13 July 2023 09:05 UTC](https://discourse.nodered.org/t/global-set-wled-true-storeinfile/79779 "2023-07-13T09:05:20Z")

</div>

hello I have switched to context storage https://forum.iobroker.net/assets/uploads/files/3639\_sc1.jpg If I now look at the written value I see 2 pieces in the context overview. I assume that one is memory and the secon…

---

## [Request help why things aren't alway working](https://discourse.nodered.org/t/request-help-why-things-arent-alway-working/79782)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 1\
**Last updated:** [13 July 2023 07:05 UTC](https://discourse.nodered.org/t/request-help-why-things-arent-alway-working/79782 "2023-07-13T07:05:38Z")

</div>

Foreign node: required cronplus This is complicated and this is not the entire flow. That is just expecting too much from anyone remote to take this on completely. So I've made this which is a cut down version of th…

---

## [Remote control for Home theater with uibuilder? Anyone doing it?](https://discourse.nodered.org/t/remote-control-for-home-theater-with-uibuilder-anyone-doing-it/79614)

<div class="topic-metadata">

**Author:** [@houser](https://discourse.nodered.org/u/houser)\
**Replies:** 11\
**Last updated:** [13 July 2023 03:09 UTC](https://discourse.nodered.org/t/remote-control-for-home-theater-with-uibuilder-anyone-doing-it/79614 "2023-07-13T03:09:33Z")

</div>

Hello, I am just wondering if anyone has tried building a remote control for the browser on a mobile phone to control various devices in a home theater using NR and the ui builder node? I have searched the forum withou…

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

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