# Latest

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

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

**Page:** 1159

---

## [Failed to install node-red-contrib-speaker 0.1.7](https://discourse.nodered.org/t/failed-to-install-node-red-contrib-speaker-0-1-7/21650)

<div class="topic-metadata">

**Author:** [@maku12](https://discourse.nodered.org/u/maku12)\
**Replies:** 2\
**Last updated:** [13 February 2020 14:28 UTC](https://discourse.nodered.org/t/failed-to-install-node-red-contrib-speaker-0-1-7/21650 "2020-02-13T14:28:56Z")

</div>

Hi, i wanted to install the node node-red-contrib-speaker 0.1.7 but it failed, please help, below there is the log: 2020-02-13T12:17:00.480Z installieren : node-red-contrib-audiostream-to-speaker 1.0.2 2020-02-13T12:…

---

## [MQTT is not talking](https://discourse.nodered.org/t/mqtt-is-not-talking/21652)

<div class="topic-metadata">

**Author:** [@roland.lanz](https://discourse.nodered.org/u/roland.lanz)\
**Replies:** 3\
**Last updated:** [13 February 2020 14:19 UTC](https://discourse.nodered.org/t/mqtt-is-not-talking/21652 "2020-02-13T14:19:33Z")

</div>

I am a beginner and I cant get it to work. I use Home assistant and Node-Red latest version. I got two inject with Topic "light/garage\_out" and Paylod "On" / "Off" connected to one MQTT-out, Server: HA-1@192.168.1.87:18…

---

## [Node-red Nora mqtt in](https://discourse.nodered.org/t/node-red-nora-mqtt-in/21640)

<div class="topic-metadata">

**Author:** [@sniperxnl](https://discourse.nodered.org/u/sniperxnl)\
**Replies:** 6\
**Last updated:** [13 February 2020 14:14 UTC](https://discourse.nodered.org/t/node-red-nora-mqtt-in/21640 "2020-02-13T14:14:07Z")

</div>

Hi Guys, using node-red with Nora, what works awesome with google. Only what i dont get working, i want that google also see that i manual switch the lamp by mqtt So when i place a mqtt before nora node, my lamp goes c…

---

## [Nodered Math Handle](https://discourse.nodered.org/t/nodered-math-handle/21617)

<div class="topic-metadata">

**Author:** [@thalesmaoa](https://discourse.nodered.org/u/thalesmaoa)\
**Replies:** 3\
**Last updated:** [13 February 2020 14:12 UTC](https://discourse.nodered.org/t/nodered-math-handle/21617 "2020-02-13T14:12:39Z")

</div>

Hello, I've been looking over math capability inside NodeRed but can't find a suitable option. I need to perform a cumulative integral. Just want to know total energy generated during the day of PV panels. Can' t find …

---

## [Available Now: Node Red Microsoft SQL Server Storage Plugin](https://discourse.nodered.org/t/available-now-node-red-microsoft-sql-server-storage-plugin/21649)

<div class="topic-metadata">

**Author:** [@gingerhelp](https://discourse.nodered.org/u/gingerhelp)\
**Replies:** 2\
**Last updated:** [13 February 2020 13:59 UTC](https://discourse.nodered.org/t/available-now-node-red-microsoft-sql-server-storage-plugin/21649 "2020-02-13T13:59:19Z")

</div>

Hello all, I have just finished publishing a storage plugin for Microsoft SQL Server here: With this plugin you can store your flows, configuration, settings, sessions, and library into a Microsoft SQL Server databas…

---

## [\[Announce\] Dashboard Version 2.19.0, 1, 2, 3, 4](https://discourse.nodered.org/t/announce-dashboard-version-2-19-0-1-2-3-4/18502)

<div class="topic-metadata">

**Author:** [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Replies:** 7\
**Last updated:** [13 February 2020 13:16 UTC](https://discourse.nodered.org/t/announce-dashboard-version-2-19-0-1-2-3-4/18502 "2020-02-13T13:16:46Z")

</div>

I know... just like London buses - nothing for ages then two releases come along in quick succession. But thanks to a good pull request that lets the ui\_form node accept data to pre-fill it here we are... Plus a small …

---

## [I wanna ask for communication node red to PLC GE RX3i](https://discourse.nodered.org/t/i-wanna-ask-for-communication-node-red-to-plc-ge-rx3i/21633)

<div class="topic-metadata">

**Author:** [@ganggens](https://discourse.nodered.org/u/ganggens)\
**Replies:** 0\
**Last updated:** [13 February 2020 07:37 UTC](https://discourse.nodered.org/t/i-wanna-ask-for-communication-node-red-to-plc-ge-rx3i/21633 "2020-02-13T07:37:29Z")

</div>

Im newbie in here...I want to ask how i can connected PLC GE Rx3i with ethernet comunnication and i need to inject from node red to PLC output. Regards

---

## [Problema com instalar novos NODE](https://discourse.nodered.org/t/problema-com-instalar-novos-node/21647)

<div class="topic-metadata">

**Author:** [@Cristyofer](https://discourse.nodered.org/u/Cristyofer)\
**Replies:** 1\
**Last updated:** [13 February 2020 12:12 UTC](https://discourse.nodered.org/t/problema-com-instalar-novos-node/21647 "2020-02-13T12:12:08Z")

</div>

Olá, estou com dificuladade em instalar nóvos nodes dentro do ibm, não consigo instalar nenhum nod. 2020

---

## [Save an array in OPC-UA Server structure](https://discourse.nodered.org/t/save-an-array-in-opc-ua-server-structure/21648)

<div class="topic-metadata">

**Author:** [@Federica](https://discourse.nodered.org/u/Federica)\
**Replies:** 0\
**Last updated:** [13 February 2020 12:10 UTC](https://discourse.nodered.org/t/save-an-array-in-opc-ua-server-structure/21648 "2020-02-13T12:10:12Z")

</div>

Hello, I want to create an opc-ua server structure. I used the package'node-red-contrib-iiot-opcua' : I used OPC\_iiot\_Server node to create the server and OPC\_iiot\_ASO to create the folder 'Test1' and the variable 'Torq…

---

## [Node-RED google home integration](https://discourse.nodered.org/t/node-red-google-home-integration/4829)

<div class="topic-metadata">

**Author:** [@andrei-tatar](https://discourse.nodered.org/u/andrei-tatar)\
**Replies:** 354\
**Last updated:** [13 February 2020 10:02 UTC](https://discourse.nodered.org/t/node-red-google-home-integration/4829 "2020-02-13T10:02:39Z")

</div>

Hi all, I am in the process of writing a node-red google home integration service. https://developers.google.com/actions/smarthome/guides/ Something were you can add nodes (light/switch/thermostat/etc.) that appear in…

---

## [Custom node - waiting for instance to be ready](https://discourse.nodered.org/t/custom-node-waiting-for-instance-to-be-ready/14400)

<div class="topic-metadata">

**Author:** [@kolban](https://discourse.nodered.org/u/kolban)\
**Replies:** 5\
**Last updated:** [13 February 2020 07:15 UTC](https://discourse.nodered.org/t/custom-node-waiting-for-instance-to-be-ready/14400 "2020-02-13T07:15:53Z")

</div>

I've stumbled across a scenario that I think should be common but reading the docs on custom nodes I'm not seeing any obvious discussion. Imagine I am creating a new node type ... let us call it XXX. To make this work,…

---

## [How to active and deactive flow dashboard](https://discourse.nodered.org/t/how-to-active-and-deactive-flow-dashboard/21630)

<div class="topic-metadata">

**Author:** [@Artwin](https://discourse.nodered.org/u/Artwin)\
**Replies:** 4\
**Last updated:** [13 February 2020 06:07 UTC](https://discourse.nodered.org/t/how-to-active-and-deactive-flow-dashboard/21630 "2020-02-13T06:07:15Z")

</div>

Hi I'm Artwin, can you help me? I have a switch node (dashboard), when the switch is on it will bring up / activate the button and when the switch is off will eliminate / deactivate the button, is that possible? or is th…

---

## [ControlLogix to MySQL](https://discourse.nodered.org/t/controllogix-to-mysql/2284)

<div class="topic-metadata">

**Author:** [@AltaJon](https://discourse.nodered.org/u/AltaJon)\
**Replies:** 1\
**Last updated:** [13 February 2020 04:05 UTC](https://discourse.nodered.org/t/controllogix-to-mysql/2284 "2020-02-13T04:05:17Z")

</div>

The following flow is how we move our data from an Allen Bradley ControlLogix PLC to mySQL. Every time the tag for the PCCC node changes state, based off a counter in the PLC, we trigger a set of IgnitionReads. The data …

---

## [Sqlite INSERT command syntax](https://discourse.nodered.org/t/sqlite-insert-command-syntax/21471)

<div class="topic-metadata">

**Author:** [@NODE777](https://discourse.nodered.org/u/NODE777)\
**Replies:** 9\
**Last updated:** [13 February 2020 03:21 UTC](https://discourse.nodered.org/t/sqlite-insert-command-syntax/21471 "2020-02-13T03:21:57Z")

</div>

I'm founding difficulties to apply the correct syntax in regarding the INSERT command that can be seen in the following function code. msg = "(UTC, DateTime, hp,lp) values (" + msg.payload + " , " + " datetime " + ",…

---

## [Unable to delete unused config nodes](https://discourse.nodered.org/t/unable-to-delete-unused-config-nodes/21579)

<div class="topic-metadata">

**Author:** [@SteveMann](https://discourse.nodered.org/u/SteveMann)\
**Replies:** 6\
**Last updated:** [13 February 2020 03:21 UTC](https://discourse.nodered.org/t/unable-to-delete-unused-config-nodes/21579 "2020-02-13T03:21:08Z")

</div>

I deleted some unused flows and now when I hit Deploy, I get this: But none of the nodes or flows exist, (Workshop Light was ne of the deleted flows), so there's nothing to delete. I tried deleting .config.json, bu…

---

## [Delay Node - Rate Limit, but specific message priority](https://discourse.nodered.org/t/delay-node-rate-limit-but-specific-message-priority/21604)

<div class="topic-metadata">

**Author:** [@patmann03](https://discourse.nodered.org/u/patmann03)\
**Replies:** 9\
**Last updated:** [12 February 2020 22:42 UTC](https://discourse.nodered.org/t/delay-node-rate-limit-but-specific-message-priority/21604 "2020-02-12T22:42:46Z")

</div>

Not sure if this is possible or not, but I have a lighting controller that I connect and send messages over TCP. It's fairly simple, however, it doesn't handle messages well if they are sent too quickly to the controlle…

---

## [A node to query partitioned DB in cloudant](https://discourse.nodered.org/t/a-node-to-query-partitioned-db-in-cloudant/21568)

<div class="topic-metadata">

**Author:** [@etawyy](https://discourse.nodered.org/u/etawyy)\
**Replies:** 1\
**Last updated:** [12 February 2020 22:00 UTC](https://discourse.nodered.org/t/a-node-to-query-partitioned-db-in-cloudant/21568 "2020-02-12T22:00:59Z")

</div>

I have been using node-red with my IBM cloudant DBs so far. Not partitioned. No problem. With the cloudantPlus nodes. However I'd like to switch to partitioned DB now, to optimize query cost. I think I understood how …

---

## [Plot data in a dashboard chart](https://discourse.nodered.org/t/plot-data-in-a-dashboard-chart/21565)

<div class="topic-metadata">

**Author:** [@fabio](https://discourse.nodered.org/u/fabio)\
**Replies:** 10\
**Last updated:** [12 February 2020 22:00 UTC](https://discourse.nodered.org/t/plot-data-in-a-dashboard-chart/21565 "2020-02-12T22:00:43Z")

</div>

Hi,i'm a novice with nodered. I want to plot the output of my pythonshell (in the image my outputs are "media1","media2",etc..) in a chart of a dashboard. How can i do this operation?

---

## [Setting msg.something](https://discourse.nodered.org/t/setting-msg-something/21615)

<div class="topic-metadata">

**Author:** [@zunder1990](https://discourse.nodered.org/u/zunder1990)\
**Replies:** 4\
**Last updated:** [12 February 2020 20:35 UTC](https://discourse.nodered.org/t/setting-msg-something/21615 "2020-02-12T20:35:55Z")

</div>

I am working on making changes to flows that have no be changed or ran since summer if last year. Back then I had heavily made use of msg.something = something in function nodes. I am changing to make to the code but som…

---

## [Node function with 2 msg](https://discourse.nodered.org/t/node-function-with-2-msg/21605)

<div class="topic-metadata">

**Author:** [@pvklink](https://discourse.nodered.org/u/pvklink)\
**Replies:** 4\
**Last updated:** [12 February 2020 17:23 UTC](https://discourse.nodered.org/t/node-function-with-2-msg/21605 "2020-02-12T17:23:29Z")

</div>

I am playing around with node-red and want to learn more... Problem i cant solve is how to create two msg(msg1 and msg2) in a function This must be the output //input msg for function // test0: "test0" //msg1 // te…

---

## [Programmatic MQTT Subscription](https://discourse.nodered.org/t/programmatic-mqtt-subscription/21567)

<div class="topic-metadata">

**Author:** [@coffeegoat](https://discourse.nodered.org/u/coffeegoat)\
**Replies:** 16\
**Last updated:** [12 February 2020 16:34 UTC](https://discourse.nodered.org/t/programmatic-mqtt-subscription/21567 "2020-02-12T16:34:22Z")

</div>

I've been building a node-red/Raspberry Pi data collection ecosystem based on the idea of independent JSON configuration files and python scripts that are all stored within a git repo. Node red is also running within a …

---

## [Deploy failed: {"code":"unexpected\_error","message":"Cannot read property 'rev' of null"}](https://discourse.nodered.org/t/deploy-failed-code-unexpected-error-message-cannot-read-property-rev-of-null/21602)

<div class="topic-metadata">

**Author:** [@gingerhelp](https://discourse.nodered.org/u/gingerhelp)\
**Replies:** 2\
**Last updated:** [12 February 2020 15:30 UTC](https://discourse.nodered.org/t/deploy-failed-code-unexpected-error-message-cannot-read-property-rev-of-null/21602 "2020-02-12T15:30:28Z")

</div>

Hello, I am working on a storage plugin for Microsoft SQL Server inspired by this project: It was a fairly straight forward translation but I am running into a snag I was hoping somebody could point me in the right d…

---

## [Workflow File in node RED](https://discourse.nodered.org/t/workflow-file-in-node-red/21583)

<div class="topic-metadata">

**Author:** [@issa2020](https://discourse.nodered.org/u/issa2020)\
**Replies:** 4\
**Last updated:** [12 February 2020 14:37 UTC](https://discourse.nodered.org/t/workflow-file-in-node-red/21583 "2020-02-12T14:37:55Z")

</div>

Hello, i m looking for a program to create workflow, what i need : i need scan directory, if a files is putting on this directory, mail is send to user to get is validation of the files, when the user valide the file…

---

## [Trouble sending multiple records to InfluxDB via JSON](https://discourse.nodered.org/t/trouble-sending-multiple-records-to-influxdb-via-json/21562)

<div class="topic-metadata">

**Author:** [@McFeardon](https://discourse.nodered.org/u/McFeardon)\
**Replies:** 12\
**Last updated:** [12 February 2020 14:23 UTC](https://discourse.nodered.org/t/trouble-sending-multiple-records-to-influxdb-via-json/21562 "2020-02-12T14:23:52Z")

</div>

I have been working with Node Red and InfluxDB for only a couple of weeks and have run into some trouble. My PLC sends data via MQTT in CSV format, and I have successfully parsed and injected a single row of data into I…

---

## [Node-Red GUI Layout](https://discourse.nodered.org/t/node-red-gui-layout/21581)

<div class="topic-metadata">

**Author:** [@Ujjwal](https://discourse.nodered.org/u/Ujjwal)\
**Replies:** 3\
**Last updated:** [12 February 2020 10:08 UTC](https://discourse.nodered.org/t/node-red-gui-layout/21581 "2020-02-12T10:08:54Z")

</div>

Hey i was trying to build a GUI for a robot on Node-Red.... but is has a very basic layout adjustment options, its like everything in in simple row and column form and options to place buttons and video window is also v…

---

## [Connect/disconnect connected wifi network](https://discourse.nodered.org/t/connect-disconnect-connected-wifi-network/21479)

<div class="topic-metadata">

**Author:** [@Ujjwal](https://discourse.nodered.org/u/Ujjwal)\
**Replies:** 2\
**Last updated:** [12 February 2020 06:18 UTC](https://discourse.nodered.org/t/connect-disconnect-connected-wifi-network/21479 "2020-02-12T06:18:08Z")

</div>

Hello Developers, I want to connect/disconnect wifi network connected to my system, using node-red. help!!

---

## [UI-Template - cant change background color of?](https://discourse.nodered.org/t/ui-template-cant-change-background-color-of/17605)

<div class="topic-metadata">

**Author:** [@dr\_cave\_dweller](https://discourse.nodered.org/u/dr_cave_dweller)\
**Replies:** 5\
**Last updated:** [12 February 2020 03:26 UTC](https://discourse.nodered.org/t/ui-template-cant-change-background-color-of/17605 "2020-02-12T03:26:58Z")

</div>

I am trying to do something very simple but I am hitting the limits of my current ability being only 1 week into Linux, Node-Red, Raspberry Pi's and CSS. In Node-Red I want to print a number I am reading from a sensor o…

---

## [\[Solved\] Serial node not working in node-red 1.0.2](https://discourse.nodered.org/t/solved-serial-node-not-working-in-node-red-1-0-2/17800)

<div class="topic-metadata">

**Author:** [@dennishvo](https://discourse.nodered.org/u/dennishvo)\
**Replies:** 21\
**Last updated:** [11 February 2020 23:04 UTC](https://discourse.nodered.org/t/solved-serial-node-not-working-in-node-red-1-0-2/17800 "2020-02-11T23:04:27Z")

</div>

I migrated my flows from node-red 0.17.x to 1.0.2 and my serial node is now behaving strangely. When I boot up the raspberry pi (Linux version 4.19.75-v7+ (dom@buildbot) (gcc version 4.9.3 (crosstool-NG crosstool-ng-1.2…

---

## [Python function](https://discourse.nodered.org/t/python-function/21510)

<div class="topic-metadata">

**Author:** [@fabio](https://discourse.nodered.org/u/fabio)\
**Replies:** 12\
**Last updated:** [11 February 2020 22:21 UTC](https://discourse.nodered.org/t/python-function/21510 "2020-02-11T22:21:03Z")

</div>

Hi,I have been using nodered for a short time and i have a question about python function. When i insert a python function, in the debug this sentence appears: " s = s.decode(detect\_encoding(s), 'surrogatepass') File "C…

---

## [Connecting LG tv smart not give TOKEN](https://discourse.nodered.org/t/connecting-lg-tv-smart-not-give-token/21461)

<div class="topic-metadata">

**Author:** [@Cibacz](https://discourse.nodered.org/u/Cibacz)\
**Replies:** 2\
**Last updated:** [11 February 2020 21:23 UTC](https://discourse.nodered.org/t/connecting-lg-tv-smart-not-give-token/21461 "2020-02-11T21:23:46Z")

</div>

Hi, please help me, I have a problem connecting LG LG smart 3D 2014 in node red dashboards. installed lgtv, lgtv2, and other packages. when I enter an IP address, I do not get a Token. when I use an app in raspberry lgtv…

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

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