# General

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

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

**Page:** 706

---

## [Using msg.from (received via E-mail in node) in a SQL query](https://discourse.nodered.org/t/using-msg-from-received-via-e-mail-in-node-in-a-sql-query/30787)

<div class="topic-metadata">

**Author:** [@grant1](https://discourse.nodered.org/u/grant1)\
**Replies:** 9\
**Last updated:** [30 July 2020 06:56 UTC](https://discourse.nodered.org/t/using-msg-from-received-via-e-mail-in-node-in-a-sql-query/30787 "2020-07-30T06:56:13Z")

</div>

I have the E-mail in node working fine and can retrieve the sender's email address as msg.from (as proven with a debug node). It gets returned with quotation marks; for example: "purchasing@my\_company.com" However, my …

---

## [MSSQL from RPi to Windows](https://discourse.nodered.org/t/mssql-from-rpi-to-windows/30860)

<div class="topic-metadata">

**Author:** [@Earl](https://discourse.nodered.org/u/Earl)\
**Replies:** 4\
**Last updated:** [30 July 2020 02:16 UTC](https://discourse.nodered.org/t/mssql-from-rpi-to-windows/30860 "2020-07-30T02:16:18Z")

</div>

Hello everyone. I am having trouble with sending queries from node-red-contrib-mssql-plus coming from my Pi to an MSSQL server in windows pc. This is the error: "Login failed. The login is from an untrusted domain and …

---

## [\[solved\] Accessing N-R on pi v3.0 from within my own network](https://discourse.nodered.org/t/solved-accessing-n-r-on-pi-v3-0-from-within-my-own-network/30843)

<div class="topic-metadata">

**Author:** [@RASelkirk](https://discourse.nodered.org/u/RASelkirk)\
**Replies:** 3\
**Last updated:** [29 July 2020 20:46 UTC](https://discourse.nodered.org/t/solved-accessing-n-r-on-pi-v3-0-from-within-my-own-network/30843 "2020-07-29T20:46:25Z")

</div>

Hi All, I'd like to be able to use my phone from within my home network to access the Node-Red dashboard on my pi so I can check what the UI looks like on...an actual phone. The pi is 192.168.1.14, I'm typing http://192…

---

## [How to get all all data in all sheets using node-red-contrib-spreadsheet-in?](https://discourse.nodered.org/t/how-to-get-all-all-data-in-all-sheets-using-node-red-contrib-spreadsheet-in/30820)

<div class="topic-metadata">

**Author:** [@AK51](https://discourse.nodered.org/u/AK51)\
**Replies:** 1\
**Last updated:** [28 July 2020 12:13 UTC](https://discourse.nodered.org/t/how-to-get-all-all-data-in-all-sheets-using-node-red-contrib-spreadsheet-in/30820 "2020-07-28T12:13:00Z")

</div>

Hi. After I have downloaded the spreadsheet-in and run the built-in example, it works fine except that I need to specify the sheet name (e.g. sheet1), how can I read all data in all sheets? Thanks.

---

## [When running Python scripts, how to you set which version of Python is being used?](https://discourse.nodered.org/t/when-running-python-scripts-how-to-you-set-which-version-of-python-is-being-used/30810)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 6\
**Last updated:** [29 July 2020 16:32 UTC](https://discourse.nodered.org/t/when-running-python-scripts-how-to-you-set-which-version-of-python-is-being-used/30810 "2020-07-29T16:32:54Z")

</div>

Forgetting pythonshell, nodes seem to have (or be able to have) python code in them. How do I know which version of python they invoke?

---

## [Which is the easiest way to get the week day?](https://discourse.nodered.org/t/which-is-the-easiest-way-to-get-the-week-day/30865)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 3\
**Last updated:** [29 July 2020 16:30 UTC](https://discourse.nodered.org/t/which-is-the-easiest-way-to-get-the-week-day/30865 "2020-07-29T16:30:48Z")

</div>

I'm stuck. I have moment and simpletime. Which node gives me the weekday name? I've found msg.myday from simpletime. But can moment give me the weekday name? I don't mind using simpletime, but how things are, it wi…

---

## [Receive msg from mqtt to html](https://discourse.nodered.org/t/receive-msg-from-mqtt-to-html/30797)

<div class="topic-metadata">

**Author:** [@nati070](https://discourse.nodered.org/u/nati070)\
**Replies:** 11\
**Last updated:** [29 July 2020 16:25 UTC](https://discourse.nodered.org/t/receive-msg-from-mqtt-to-html/30797 "2020-07-29T16:25:31Z")

</div>

hi , i really glad for help i started learn nodered and i have a problem when i try to send a message from the mqtt to the html. the html web not stop loading , the problem is in idPerson node , but i dont know what i d…

---

## [Slow... (Everything)](https://discourse.nodered.org/t/slow-everything/30808)

<div class="topic-metadata">

**Author:** [@SteveMann](https://discourse.nodered.org/u/SteveMann)\
**Replies:** 29\
**Last updated:** [29 July 2020 16:20 UTC](https://discourse.nodered.org/t/slow-everything/30808 "2020-07-29T16:20:27Z")

</div>

I am working on a set of flows for an escape room controller dashboard, and I am noticing that as I edit nodes and redeploy through the day, the response keeps getting slower and slower until just double-clicking on a no…

---

## [Node-red-contrib-usbhid Can not connect 2 RFID125 Khz usb reader at same time due to same VID and PID](https://discourse.nodered.org/t/node-red-contrib-usbhid-can-not-connect-2-rfid125-khz-usb-reader-at-same-time-due-to-same-vid-and-pid/30871)

<div class="topic-metadata">

**Author:** [@tranduchau081188](https://discourse.nodered.org/u/tranduchau081188)\
**Replies:** 2\
**Last updated:** [29 July 2020 16:05 UTC](https://discourse.nodered.org/t/node-red-contrib-usbhid-can-not-connect-2-rfid125-khz-usb-reader-at-same-time-due-to-same-vid-and-pid/30871 "2020-07-29T16:05:32Z")

</div>

Dear all, I build the Pike Parking project that require 2 RFID125 Khz usb reader on Node-red and Raspi 3B. I install Node-red-contrib-usbhid however usbhid detect same VID and PID for both RFID125 Khz usb reader, only …

---

## [HELP! Node is installed and npm/Node-RED cannot uninstall it](https://discourse.nodered.org/t/help-node-is-installed-and-npm-node-red-cannot-uninstall-it/30882)

<div class="topic-metadata">

**Author:** [@tree-frog](https://discourse.nodered.org/u/tree-frog)\
**Replies:** 2\
**Last updated:** [29 July 2020 15:29 UTC](https://discourse.nodered.org/t/help-node-is-installed-and-npm-node-red-cannot-uninstall-it/30882 "2020-07-29T15:29:43Z")

</div>

What is funny is that the node actually works fine... but I cannot upgrade it correctly to have the new updates work. i probably installed this with npm in the wrong folder context... However, I'd like to see if I can …

---

## [Create and update Google Calendar events using node-red](https://discourse.nodered.org/t/create-and-update-google-calendar-events-using-node-red/4717)

<div class="topic-metadata">

**Author:** [@lukasli](https://discourse.nodered.org/u/lukasli)\
**Replies:** 8\
**Last updated:** [29 July 2020 15:26 UTC](https://discourse.nodered.org/t/create-and-update-google-calendar-events-using-node-red/4717 "2020-07-29T15:26:03Z")

</div>

Hello everyone, I am currently trying to create and update events in the Google Calendar using the node-red-contrib-google node. Here is a Link to the Node: https://flows.nodered.org/node/node-red-contrib-google The g…

---

## [ESP32 nodes and nodered flow](https://discourse.nodered.org/t/esp32-nodes-and-nodered-flow/30818)

<div class="topic-metadata">

**Author:** [@guestisp](https://discourse.nodered.org/u/guestisp)\
**Replies:** 8\
**Last updated:** [29 July 2020 14:28 UTC](https://discourse.nodered.org/t/esp32-nodes-and-nodered-flow/30818 "2020-07-29T14:28:45Z")

</div>

Hi guys! I'm new to node-red, still trying to understand if it could do the job Let's assume 5-6-7 ESP32/ESP8266 nodes. (still not sure about the firmware) I need something to "orchestrate" them, based on events acros…

---

## [Input Linux IPMI Data to InfluxDB via Node Red](https://discourse.nodered.org/t/input-linux-ipmi-data-to-influxdb-via-node-red/30852)

<div class="topic-metadata">

**Author:** [@gregoinc](https://discourse.nodered.org/u/gregoinc)\
**Replies:** 5\
**Last updated:** [29 July 2020 14:23 UTC](https://discourse.nodered.org/t/input-linux-ipmi-data-to-influxdb-via-node-red/30852 "2020-07-29T14:23:59Z")

</div>

Greetings, I have a conundrum I hope someone way smarter than me can solve :slight\_smile: I have a centos 8 linux system and I use the ipmitool application to query the onboard server IPMI board to obtain sensor inform…

---

## [Run python script on a remote raspberry pi](https://discourse.nodered.org/t/run-python-script-on-a-remote-raspberry-pi/30831)

<div class="topic-metadata">

**Author:** [@lodv](https://discourse.nodered.org/u/lodv)\
**Replies:** 6\
**Last updated:** [29 July 2020 13:47 UTC](https://discourse.nodered.org/t/run-python-script-on-a-remote-raspberry-pi/30831 "2020-07-29T13:47:36Z")

</div>

Hi, Is it possible to run a python script on Raspberry Pi remote from Raspberry Pi local (I don't know another word). The purpose is that I want to run a python script on a second Raspi when I set a switch on the local…

---

## [Node RED email node showing error](https://discourse.nodered.org/t/node-red-email-node-showing-error/30857)

<div class="topic-metadata">

**Author:** [@Sankha](https://discourse.nodered.org/u/Sankha)\
**Replies:** 1\
**Last updated:** [29 July 2020 12:28 UTC](https://discourse.nodered.org/t/node-red-email-node-showing-error/30857 "2020-07-29T12:28:12Z")

</div>

I have done everything starting from updating node and node js also enabled less security for google still my email node is showing error of greeting not received . I have used correct password and id.

---

## [Execute the command of "sudo netplan apply" by exec](https://discourse.nodered.org/t/execute-the-command-of-sudo-netplan-apply-by-exec/30849)

<div class="topic-metadata">

**Author:** [@Jhon](https://discourse.nodered.org/u/Jhon)\
**Replies:** 2\
**Last updated:** [29 July 2020 09:04 UTC](https://discourse.nodered.org/t/execute-the-command-of-sudo-netplan-apply-by-exec/30849 "2020-07-29T09:04:34Z")

</div>

Hello I use node(file) to write the ip addresses to the file of "00-snapd-config.yaml" and comfirmed it is ok. In order to enable the setting,We executed the command of "sudo netplan apply" by "exec" .The result is…

---

## [Alexa-home node bug](https://discourse.nodered.org/t/alexa-home-node-bug/30839)

<div class="topic-metadata">

**Author:** [@Ludacrysis](https://discourse.nodered.org/u/Ludacrysis)\
**Replies:** 2\
**Last updated:** [29 July 2020 07:07 UTC](https://discourse.nodered.org/t/alexa-home-node-bug/30839 "2020-07-29T07:07:48Z")

</div>

Hi folks, I'm new to node-RED and just started to do the first steps in this environment. However I already ran into some trouble with the node mentioned in the topic. I set up a controller and started it on port 8000…

---

## [MQTT is driving me crazy with inconsistent doings](https://discourse.nodered.org/t/mqtt-is-driving-me-crazy-with-inconsistent-doings/30515)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 77\
**Last updated:** [29 July 2020 05:53 UTC](https://discourse.nodered.org/t/mqtt-is-driving-me-crazy-with-inconsistent-doings/30515 "2020-07-29T05:53:49Z")

</div>

Every time I think I have it nutted out, MQTT throws another curve ball at me and just doesn't do things consistently. (Slight back story) Multiple machines controlling single device. (Sorry, it is actually becoming q…

---

## [Node for digital input in dashboard](https://discourse.nodered.org/t/node-for-digital-input-in-dashboard/30832)

<div class="topic-metadata">

**Author:** [@usmanEmder](https://discourse.nodered.org/u/usmanEmder)\
**Replies:** 4\
**Last updated:** [29 July 2020 00:12 UTC](https://discourse.nodered.org/t/node-for-digital-input-in-dashboard/30832 "2020-07-29T00:12:12Z")

</div>

I have to control the speed from dashboard. Right now I am using "Numeric" dashboard node. I can change the speed with it but it is very slow in case of some specific speed. Is there any node to control the speed value i…

---

## [Light Scheduler - Schedule not selectable](https://discourse.nodered.org/t/light-scheduler-schedule-not-selectable/30779)

<div class="topic-metadata">

**Author:** [@renecloosterman](https://discourse.nodered.org/u/renecloosterman)\
**Replies:** 6\
**Last updated:** [28 July 2020 17:58 UTC](https://discourse.nodered.org/t/light-scheduler-schedule-not-selectable/30779 "2020-07-28T17:58:47Z")

</div>

Hi, I noticed that i cannot select a scedule anymore. Normally just drag and drop active times, but now i cant select anything anymore. Tried Chrome and Edge, both same problem. Anyone else this problem? Regards, …

---

## [Disable errors? (or one specific one at least)](https://discourse.nodered.org/t/disable-errors-or-one-specific-one-at-least/30833)

<div class="topic-metadata">

**Author:** [@evane241](https://discourse.nodered.org/u/evane241)\
**Replies:** 1\
**Last updated:** [28 July 2020 17:05 UTC](https://discourse.nodered.org/t/disable-errors-or-one-specific-one-at-least/30833 "2020-07-28T17:05:39Z")

</div>

New to NodeRed but find it absolutely beautiful so far. This has been bugging me however, and I can't seem to get it to stop.. I think this is just a side-effect of selecting "a parsed JSON object" for the type of Output…

---

## [Proper way of including variable in msg.payload](https://discourse.nodered.org/t/proper-way-of-including-variable-in-msg-payload/30829)

<div class="topic-metadata">

**Author:** [@eibyer\_nr](https://discourse.nodered.org/u/eibyer_nr)\
**Replies:** 1\
**Last updated:** [28 July 2020 15:25 UTC](https://discourse.nodered.org/t/proper-way-of-including-variable-in-msg-payload/30829 "2020-07-28T15:25:11Z")

</div>

Do I have this formatted correctly? I'm using http request node to hit an endpoint with the data payload. msg.payload = \`\`{ "data": {{mac1Status}, {mac2Status}, {mac3Status}, {mac4Status}} }\`; return msg; Note: There'…

---

## [Simple read from i2c device?](https://discourse.nodered.org/t/simple-read-from-i2c-device/30830)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 0\
**Last updated:** [28 July 2020 14:48 UTC](https://discourse.nodered.org/t/simple-read-from-i2c-device/30830 "2020-07-28T14:48:59Z")

</div>

I think I am missing some thing basic here, I have si7021 sensor, the various node js modules are all very old and can't be used with NR, or so has been my experience. So, I figure why not try using i2c-bus? This senso…

---

## [Time out OPC UA Server](https://discourse.nodered.org/t/time-out-opc-ua-server/30548)

<div class="topic-metadata">

**Author:** [@roberto](https://discourse.nodered.org/u/roberto)\
**Replies:** 3\
**Last updated:** [28 July 2020 14:23 UTC](https://discourse.nodered.org/t/time-out-opc-ua-server/30548 "2020-07-28T14:23:52Z")

</div>

Hi, I get an OPC UA connection error if I try to connect to OPC UA Server: OPC UA connection error: The connection has been rejected by server, Please check that client certificate is trusted by server. Err = (Transact…

---

## [Cannot run install script](https://discourse.nodered.org/t/cannot-run-install-script/30688)

<div class="topic-metadata">

**Author:** [@mrohner](https://discourse.nodered.org/u/mrohner)\
**Replies:** 9\
**Last updated:** [28 July 2020 13:14 UTC](https://discourse.nodered.org/t/cannot-run-install-script/30688 "2020-07-28T13:14:09Z")

</div>

I try to use suggested install script: bash \<(curl -sL https://raw.githubusercontent.com/node-red/linux-installers/master/deb/update-nodejs-and-nodered) The commend returned: -sh: 8: Syntax error: "(" unexpected This…

---

## [PiFace\_LCD node - really need help understanding why things are happening](https://discourse.nodered.org/t/piface-lcd-node-really-need-help-understanding-why-things-are-happening/30803)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 14\
**Last updated:** [28 July 2020 09:53 UTC](https://discourse.nodered.org/t/piface-lcd-node-really-need-help-understanding-why-things-are-happening/30803 "2020-07-28T09:53:35Z")

</div>

This is a whole new take on my other post about PiFace CAD hat. This is more about the actual node. The node code But I have modified it for reasons I hope to explain shortly. So I am nearly making a node. But I do…

---

## [Trying to understand why PCF8574 model is trying to compile old version of epoll?](https://discourse.nodered.org/t/trying-to-understand-why-pcf8574-model-is-trying-to-compile-old-version-of-epoll/30794)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 2\
**Last updated:** [28 July 2020 02:44 UTC](https://discourse.nodered.org/t/trying-to-understand-why-pcf8574-model-is-trying-to-compile-old-version-of-epoll/30794 "2020-07-28T02:44:58Z")

</div>

I am trying to load the PCF8574 module for NR. It is ancient so not surprised I am running into issues. But one specific issue, has me... confused I guess. I explicitly loaded the latest version of the dependencies fo…

---

## [Cloning Repositories not working](https://discourse.nodered.org/t/cloning-repositories-not-working/17008)

<div class="topic-metadata">

**Author:** [@GregorR1](https://discourse.nodered.org/u/GregorR1)\
**Replies:** 1\
**Last updated:** [27 July 2020 22:28 UTC](https://discourse.nodered.org/t/cloning-repositories-not-working/17008 "2020-07-27T22:28:56Z")

</div>

Hi, I've set up node-red on my Windows machine and am now trying to clone my GitHub repositories using the projects feature. The issue I'm getting is that if I try to use the "git@github.com:username/repo" URL I'm getti…

---

## [Integer to time (HH:MM:SS)](https://discourse.nodered.org/t/integer-to-time-hhss/13424)

<div class="topic-metadata">

**Author:** [@HakanBodin](https://discourse.nodered.org/u/HakanBodin)\
**Replies:** 6\
**Last updated:** [19 July 2019 14:49 UTC](https://discourse.nodered.org/t/integer-to-time-hhss/13424 "2019-07-19T14:49:45Z")

</div>

I have an integer that I want to convert into time(HH:MM:SS) It's a countdown timer (in seconds) from 24 hours == 86400 seconds to zero, and I've tried to do this in a function block, but don't get it correct! Grateful …

---

## [When disableEditor is true, and I use a Custom Authentication Token, Node-Red Admin API method "settings" fails to work](https://discourse.nodered.org/t/when-disableeditor-is-true-and-i-use-a-custom-authentication-token-node-red-admin-api-method-settings-fails-to-work/30786)

<div class="topic-metadata">

**Author:** [@sebascarra](https://discourse.nodered.org/u/sebascarra)\
**Replies:** 0\
**Last updated:** [27 July 2020 18:50 UTC](https://discourse.nodered.org/t/when-disableeditor-is-true-and-i-use-a-custom-authentication-token-node-red-admin-api-method-settings-fails-to-work/30786 "2020-07-27T18:50:06Z")

</div>

Please take a look at the following Github issue. Any feedback is appreciated. https://github.com/node-red/node-red/issues/2662

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

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