# General

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

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

**Page:** 528

---

## [High availability login/auth issue](https://discourse.nodered.org/t/high-availability-login-auth-issue/48023)

<div class="topic-metadata">

**Author:** [@bubus](https://discourse.nodered.org/u/bubus)\
**Replies:** 3\
**Last updated:** [5 July 2021 07:29 UTC](https://discourse.nodered.org/t/high-availability-login-auth-issue/48023 "2021-07-05T07:29:37Z")

</div>

Hello, I have node-red hosted on openshift with high avalibilty (2 pods parallel) and i have issue with login: When i access node-red directly and login everything works fine. The problem is when i want to login this …

---

## [.git/Object file is corrupt](https://discourse.nodered.org/t/git-object-file-is-corrupt/47997)

<div class="topic-metadata">

**Author:** [@pranavthakkar](https://discourse.nodered.org/u/pranavthakkar)\
**Replies:** 14\
**Last updated:** [5 July 2021 07:14 UTC](https://discourse.nodered.org/t/git-object-file-is-corrupt/47997 "2021-07-05T07:14:20Z")

</div>

I started NR in the virtual box after some time. and After creating flow when I try to deploy I got this error. What can be done? Error: error: object file .git/objects/4d/b2a0367fbacc3376b2a2d94b6f65fc5bccf95d is empty…

---

## [Min, Max & Avg in single message](https://discourse.nodered.org/t/min-max-avg-in-single-message/48033)

<div class="topic-metadata">

**Author:** [@dmac101](https://discourse.nodered.org/u/dmac101)\
**Replies:** 4\
**Last updated:** [5 July 2021 06:30 UTC](https://discourse.nodered.org/t/min-max-avg-in-single-message/48033 "2021-07-05T06:30:57Z")

</div>

Hi All, I am working on a project that involves monitoring and logging analogue data using MCP3008. To save logging every second, I plan to use the calculate node to provide minimum, maximum and average over a 1 minute t…

---

## [About a5=a0+a1+a2+a3+a4?](https://discourse.nodered.org/t/about-a5-a0-a1-a2-a3-a4/48028)

<div class="topic-metadata">

**Author:** [@jlian168](https://discourse.nodered.org/u/jlian168)\
**Replies:** 2\
**Last updated:** [5 July 2021 06:14 UTC](https://discourse.nodered.org/t/about-a5-a0-a1-a2-a3-a4/48028 "2021-07-05T06:14:36Z")

</div>

Dear All : var a0=0xCD; var a1=0x64; var a2=0x01; var a3=0x04; var a4=0x00; a5=a0+a1+a2+a3+a4; msg.payload=a5; return msg; Why in debug window its show NaN? Thank u.

---

## [Stupid beginner question about repeated flows/ intervals](https://discourse.nodered.org/t/stupid-beginner-question-about-repeated-flows-intervals/47869)

<div class="topic-metadata">

**Author:** [@kavemang](https://discourse.nodered.org/u/kavemang)\
**Replies:** 13\
**Last updated:** [4 July 2021 22:41 UTC](https://discourse.nodered.org/t/stupid-beginner-question-about-repeated-flows-intervals/47869 "2021-07-04T22:41:52Z")

</div>

Hi folks, I have a mildy goofy setup where I find myself passing certain sensor values from Smartthings to home assistant. I have my flow setup 1:1 ST sensor -\> HA entity ST sensor -\> HA entity ST sensor -\> HA entity …

---

## [Node-red-contrib-open-protocol full or half duplex](https://discourse.nodered.org/t/node-red-contrib-open-protocol-full-or-half-duplex/48019)

<div class="topic-metadata">

**Author:** [@DamianAdams](https://discourse.nodered.org/u/DamianAdams)\
**Replies:** 1\
**Last updated:** [4 July 2021 21:46 UTC](https://discourse.nodered.org/t/node-red-contrib-open-protocol-full-or-half-duplex/48019 "2021-07-04T21:46:00Z")

</div>

Hi, I have been having problems with the node-red-contrib-open-protocol dropping last tightening rundown being dropped by the tooling for type 6000 tools, Atlas is telling me the comms must be full-duplex not half-duplex…

---

## [SIMPLE way to restart flows within Node-Red](https://discourse.nodered.org/t/simple-way-to-restart-flows-within-node-red/47989)

<div class="topic-metadata">

**Author:** [@RonMa](https://discourse.nodered.org/u/RonMa)\
**Replies:** 16\
**Last updated:** [4 July 2021 20:07 UTC](https://discourse.nodered.org/t/simple-way-to-restart-flows-within-node-red/47989 "2021-07-04T20:07:40Z")

</div>

Latest since making use of the Alexa integration, I found that some flows just ain't quite stable working and, unfortunately, need to be restarted regularly. Therefore I´m looking for an easy way, how to restart all and/…

---

## [Download ui-table command](https://discourse.nodered.org/t/download-ui-table-command/47991)

<div class="topic-metadata">

**Author:** [@trust](https://discourse.nodered.org/u/trust)\
**Replies:** 2\
**Last updated:** [4 July 2021 18:23 UTC](https://discourse.nodered.org/t/download-ui-table-command/47991 "2021-07-04T18:23:57Z")

</div>

ui-table seems like an incredibly powerful way to interact with data. I've got it reading from my various databases, and want to be able to modify cells in the table, then send a command to download the table to a csv fi…

---

## [Function to check input and output](https://discourse.nodered.org/t/function-to-check-input-and-output/48011)

<div class="topic-metadata">

**Author:** [@sfedo](https://discourse.nodered.org/u/sfedo)\
**Replies:** 4\
**Last updated:** [4 July 2021 16:39 UTC](https://discourse.nodered.org/t/function-to-check-input-and-output/48011 "2021-07-04T16:39:53Z")

</div>

Hello guys, I'm using mqtt to send data to arduino. I use ui\_switch to set my device on and off, and after arduino received my message, it send another message to confirm. With this message I set the ui switch to on and…

---

## [Example flow: Actionable notification iOS](https://discourse.nodered.org/t/example-flow-actionable-notification-ios/48013)

<div class="topic-metadata">

**Author:** [@dmertens](https://discourse.nodered.org/u/dmertens)\
**Replies:** 0\
**Last updated:** [4 July 2021 15:46 UTC](https://discourse.nodered.org/t/example-flow-actionable-notification-ios/48013 "2021-07-04T15:46:41Z")

</div>

Hi, Someone, an example for an actionable notification flow (iOS) Thanks!

---

## [SQLite node syntax error but sqlitebrowser works](https://discourse.nodered.org/t/sqlite-node-syntax-error-but-sqlitebrowser-works/47350)

<div class="topic-metadata">

**Author:** [@mune](https://discourse.nodered.org/u/mune)\
**Replies:** 24\
**Last updated:** [3 July 2021 17:45 UTC](https://discourse.nodered.org/t/sqlite-node-syntax-error-but-sqlitebrowser-works/47350 "2021-07-03T17:45:02Z")

</div>

Hi guys, I have an issue that is driving me crazy. In two words: I have a SQLite node that raises a syntax error but the same SQL query works in sqlitebrowser or in the sqlite's cli. nodered version is 1.2.3 sqlite ver…

---

## [Reading files into ui-table](https://discourse.nodered.org/t/reading-files-into-ui-table/47960)

<div class="topic-metadata">

**Author:** [@trust](https://discourse.nodered.org/u/trust)\
**Replies:** 3\
**Last updated:** [3 July 2021 16:02 UTC](https://discourse.nodered.org/t/reading-files-into-ui-table/47960 "2021-07-03T16:02:22Z")

</div>

Newbie so still trying to understand the system. I've tried using the example data from ui-table written into files and used file reader to input to ui-table - it creates a blank table. The examples using inject work fi…

---

## [MQTT store in mysql](https://discourse.nodered.org/t/mqtt-store-in-mysql/47978)

<div class="topic-metadata">

**Author:** [@Apoki21](https://discourse.nodered.org/u/Apoki21)\
**Replies:** 4\
**Last updated:** [3 July 2021 15:50 UTC](https://discourse.nodered.org/t/mqtt-store-in-mysql/47978 "2021-07-03T15:50:55Z")

</div>

Hello Guys, I need help correct my code, i fail store data on mysql this my flow: this my function code: msg.topic = msg.payload var tag1 = msg.payload.P1-basic/L1\_N\_Voltage(V) var tag2 = msg.payloadP1-basic/L1\_L…

---

## [error on start of node-red](https://discourse.nodered.org/t/error-on-start-of-node-red/20447)

<div class="topic-metadata">

**Author:** [@yordi](https://discourse.nodered.org/u/yordi)\
**Replies:** 2\
**Last updated:** [3 July 2021 15:42 UTC](https://discourse.nodered.org/t/error-on-start-of-node-red/20447 "2021-07-03T15:42:12Z")

</div>

node-red : File C:\\Users\\me\\AppData\\Roaming\\npm\\node-red.ps1 cannot be loaded because running scripts is disabled on this system. For more information, see about\_Execution\_Policies at https:/go.microsoft.com/fwlink/?Lin…

---

## [Dynamically change the ip of the connection config MSSQL](https://discourse.nodered.org/t/dynamically-change-the-ip-of-the-connection-config-mssql/47886)

<div class="topic-metadata">

**Author:** [@tuki\_1990](https://discourse.nodered.org/u/tuki_1990)\
**Replies:** 10\
**Last updated:** [3 July 2021 14:03 UTC](https://discourse.nodered.org/t/dynamically-change-the-ip-of-the-connection-config-mssql/47886 "2021-07-03T14:03:01Z")

</div>

Hello! i'm starting with node-Red and i have a trouble with it. I'm using MSSQL node from: node-red-contrib-mssql-plus. and i want to change dinamically the ip of the connection with a flow variable it is possible? th…

---

## [How to connect bluemix cloud based node red to node red](https://discourse.nodered.org/t/how-to-connect-bluemix-cloud-based-node-red-to-node-red/47974)

<div class="topic-metadata">

**Author:** [@ddevz](https://discourse.nodered.org/u/ddevz)\
**Replies:** 0\
**Last updated:** [3 July 2021 12:34 UTC](https://discourse.nodered.org/t/how-to-connect-bluemix-cloud-based-node-red-to-node-red/47974 "2021-07-03T12:34:14Z")

</div>

I want to connect my node red to cloud based bluemix node red. I tried MQTT protocol to connect these two platforms. but it did not work. can any one help me?

---

## [Paradox mg5050 alarm to node red and homekit](https://discourse.nodered.org/t/paradox-mg5050-alarm-to-node-red-and-homekit/47972)

<div class="topic-metadata">

**Author:** [@dietsm](https://discourse.nodered.org/u/dietsm)\
**Replies:** 0\
**Last updated:** [3 July 2021 10:38 UTC](https://discourse.nodered.org/t/paradox-mg5050-alarm-to-node-red-and-homekit/47972 "2021-07-03T10:38:23Z")

</div>

Hi - newbie on node red. I have my whole KNX and sonoff's working well in node red and would like to integrate my paradox alarm into my system onto homekit. Can anyone help me with this. I looked at PAI on github but to …

---

## [Local File Context Stores Load](https://discourse.nodered.org/t/local-file-context-stores-load/47968)

<div class="topic-metadata">

**Author:** [@Soloam](https://discourse.nodered.org/u/Soloam)\
**Replies:** 2\
**Last updated:** [3 July 2021 10:04 UTC](https://discourse.nodered.org/t/local-file-context-stores-load/47968 "2021-07-03T10:04:50Z")

</div>

Hello, I have a question regarding Local File Context Stores. When are the values loaded into memory? From what I understand the values are stored in memory and saved to file every 30s. When nodered starts is Local File…

---

## [Problem using more nodes/expanding nodes (currently 47 nodes)](https://discourse.nodered.org/t/problem-using-more-nodes-expanding-nodes-currently-47-nodes/47961)

<div class="topic-metadata">

**Author:** [@jenssen](https://discourse.nodered.org/u/jenssen)\
**Replies:** 5\
**Last updated:** [3 July 2021 09:45 UTC](https://discourse.nodered.org/t/problem-using-more-nodes-expanding-nodes-currently-47-nodes/47961 "2021-07-03T09:45:58Z")

</div>

Hello, I am using Node Red for a year now, without any problems. I have about 12 flows, since I am working on my latest flow I receive the message "Deploy failed: no response from server", when I deploy the configuratio…

---

## [Joining TCP stream of buffer messages; output without '44'](https://discourse.nodered.org/t/joining-tcp-stream-of-buffer-messages-output-without-44/47957)

<div class="topic-metadata">

**Author:** [@adharyanto](https://discourse.nodered.org/u/adharyanto)\
**Replies:** 1\
**Last updated:** [3 July 2021 06:39 UTC](https://discourse.nodered.org/t/joining-tcp-stream-of-buffer-messages-output-without-44/47957 "2021-07-03T06:39:05Z")

</div>

Hi, In my Node-RED flow, I have a "tcp in" node to receive a stream of some incoming buffer messages. I use "join" node to combine these incoming buffer messages to make them into a single buffer message. But there is …

---

## [How can press button then delay 5S that can press again?](https://discourse.nodered.org/t/how-can-press-button-then-delay-5s-that-can-press-again/47925)

<div class="topic-metadata">

**Author:** [@jlian168](https://discourse.nodered.org/u/jlian168)\
**Replies:** 4\
**Last updated:** [3 July 2021 04:07 UTC](https://discourse.nodered.org/t/how-can-press-button-then-delay-5s-that-can-press-again/47925 "2021-07-03T04:07:01Z")

</div>

Dear All : Look at pic and below : How to do press button then delay 5S that can press again? Or in 5S press button is ignore? The delay node can turn 180 degree? And how? Thank u?

---

## [No0b NR user just joining in](https://discourse.nodered.org/t/no0b-nr-user-just-joining-in/47385)

<div class="topic-metadata">

**Author:** [@Gunner](https://discourse.nodered.org/u/Gunner)\
**Replies:** 14\
**Last updated:** [3 July 2021 04:02 UTC](https://discourse.nodered.org/t/no0b-nr-user-just-joining-in/47385 "2021-07-03T04:02:20Z")

</div>

Hello all. I finally decided to try out Node-Red... I am so new that I can't even tell you which version, but probably whatever is current at the date of this post, as I followed the official install directions for RPi …

---

## [Put it all together](https://discourse.nodered.org/t/put-it-all-together/47936)

<div class="topic-metadata">

**Author:** [@Trev1951](https://discourse.nodered.org/u/Trev1951)\
**Replies:** 25\
**Last updated:** [3 July 2021 03:31 UTC](https://discourse.nodered.org/t/put-it-all-together/47936 "2021-07-03T03:31:19Z")

</div>

I am trying to get a wi-fi mini ESP8266 sorted so at the end I can control it from any computer/ipad/iphone in my house. But as any newbe knows there are a lot of moving parts. Thats ok and I have worked thru most of the…

---

## [Why Node-Red is great](https://discourse.nodered.org/t/why-node-red-is-great/47942)

<div class="topic-metadata">

**Author:** [@Trev1951](https://discourse.nodered.org/u/Trev1951)\
**Replies:** 4\
**Last updated:** [3 July 2021 03:18 UTC](https://discourse.nodered.org/t/why-node-red-is-great/47942 "2021-07-03T03:18:33Z")

</div>

Simple answer IOT. I am new to a lot of this techno-stuff but I can see the benefits. Most people just buy a device, read the instructions (probably connect to something on their IPhone) and hopefully it works. But some…

---

## [Font color in List Node](https://discourse.nodered.org/t/font-color-in-list-node/47917)

<div class="topic-metadata">

**Author:** [@dsplitz](https://discourse.nodered.org/u/dsplitz)\
**Replies:** 2\
**Last updated:** [3 July 2021 02:49 UTC](https://discourse.nodered.org/t/font-color-in-list-node/47917 "2021-07-03T02:49:18Z")

</div>

I'm using a function node to send an array of data to a list node. My goal is for the description color to change based on the value. Here's my function node code: var array = flow.get('DevStat') var combo = \[{}\] va…

---

## [Trying to send text to LCD over i2c contrib](https://discourse.nodered.org/t/trying-to-send-text-to-lcd-over-i2c-contrib/47873)

<div class="topic-metadata">

**Author:** [@Gunner](https://discourse.nodered.org/u/Gunner)\
**Replies:** 76\
**Last updated:** [3 July 2021 01:46 UTC](https://discourse.nodered.org/t/trying-to-send-text-to-lcd-over-i2c-contrib/47873 "2021-07-03T01:46:17Z")

</div>

While pointing out the search options for another member looking to write to an LCD, I decided to try it myself. I setup a Sainsmart 2004 LCD with I2C backpack onto my RPi. Tested it with some Python code... yes, my se…

---

## [MQTT To ASCII over TCP/IP](https://discourse.nodered.org/t/mqtt-to-ascii-over-tcp-ip/46438)

<div class="topic-metadata">

**Author:** [@vaughan.mcd](https://discourse.nodered.org/u/vaughan.mcd)\
**Replies:** 30\
**Last updated:** [2 July 2021 23:29 UTC](https://discourse.nodered.org/t/mqtt-to-ascii-over-tcp-ip/46438 "2021-07-02T23:29:28Z")

</div>

HI I reaching out to get some help with setting up formatting on the a send and receive node for a device The device communicates through an IP connection using an ASCII protocol. protocol will allow control and monito…

---

## [Assistance with Flow](https://discourse.nodered.org/t/assistance-with-flow/47899)

<div class="topic-metadata">

**Author:** [@MikeyD](https://discourse.nodered.org/u/MikeyD)\
**Replies:** 15\
**Last updated:** [2 July 2021 09:15 UTC](https://discourse.nodered.org/t/assistance-with-flow/47899 "2021-07-02T09:15:35Z")

</div>

As a non-programmer, I'm struggling with a simple flow and would really appreciate some help. I have a sensor that (through MQTT) causes a msg to be sent when a window is opened. I want to create this: If the window …

---

## [Problem with using Smart-Nora in node-red](https://discourse.nodered.org/t/problem-with-using-smart-nora-in-node-red/47893)

<div class="topic-metadata">

**Author:** [@ttlooser](https://discourse.nodered.org/u/ttlooser)\
**Replies:** 2\
**Last updated:** [2 July 2021 21:25 UTC](https://discourse.nodered.org/t/problem-with-using-smart-nora-in-node-red/47893 "2021-07-02T21:25:23Z")

</div>

Hi, I have a problem with using Smart-Nora with node-red and google home: 1.When I add example sensor node: \[{"id":"cf8038ff.4d2598","type":"noraf-sensor","z":"68061750.490f48","devicename":"Sensor","roomhint":"","nam…

---

## [SQL communication TLS/SSL encryption and error self\_signed\_cert\_in\_chain solution](https://discourse.nodered.org/t/sql-communication-tls-ssl-encryption-and-error-self-signed-cert-in-chain-solution/47954)

<div class="topic-metadata">

**Author:** [@Nikolay](https://discourse.nodered.org/u/Nikolay)\
**Replies:** 0\
**Last updated:** [2 July 2021 21:08 UTC](https://discourse.nodered.org/t/sql-communication-tls-ssl-encryption-and-error-self-signed-cert-in-chain-solution/47954 "2021-07-02T21:08:47Z")

</div>

I was using the node-red-contrib-stackhero-mysql as I wanted secure SSL connection to a mariadb 10.x. The first issue was that on Debian/Ubuntu a custom SSL library is used for Mariadb and not the openssl library and it …

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

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