# Latest **URL:** https://discourse.nodered.org/latest.md?page=1167 [Latest](https://discourse.nodered.org/latest.md) · [Categories](https://discourse.nodered.org/categories.md) · [Tags](https://discourse.nodered.org/tags.md) **Page:** 1168 --- ## [Transaction, Commit, Rollback, Mysql](https://discourse.nodered.org/t/transaction-commit-rollback-mysql/20828)
**Author:** [@glauberjnb](https://discourse.nodered.org/u/glauberjnb)\ **Replies:** 8\ **Last updated:** [28 January 2020 16:11 UTC](https://discourse.nodered.org/t/transaction-commit-rollback-mysql/20828 "2020-01-28T16:11:21Z")
Hello, How can we use transaction control in mysql by Node-red --- ## [Node Red running as a AWS Lambda function](https://discourse.nodered.org/t/node-red-running-as-a-aws-lambda-function/20929)
**Author:** [@Theos](https://discourse.nodered.org/u/Theos)\ **Replies:** 2\ **Last updated:** [28 January 2020 14:28 UTC](https://discourse.nodered.org/t/node-red-running-as-a-aws-lambda-function/20929 "2020-01-28T14:28:08Z")
Is it possible to run a node red project as a AWS Lambda function? If it is, do you mind sharing information on how to set it up? Best regards. --- ## [Azure, Node-Red and VM](https://discourse.nodered.org/t/azure-node-red-and-vm/20798)
**Author:** [@Jochen1980](https://discourse.nodered.org/u/Jochen1980)\ **Replies:** 5\ **Last updated:** [28 January 2020 12:36 UTC](https://discourse.nodered.org/t/azure-node-red-and-vm/20798 "2020-01-28T12:36:27Z")
Hello, I have a general question on how would be the best way to have an IoT Dashboard for our customers. Actually we followed the instruction on how to have nodered on an Azure VM but this VM has to be maintained. Be… --- ## [MySQL connection Error](https://discourse.nodered.org/t/mysql-connection-error/20953)
**Author:** [@Avipur](https://discourse.nodered.org/u/Avipur)\ **Replies:** 4\ **Last updated:** [28 January 2020 12:23 UTC](https://discourse.nodered.org/t/mysql-connection-error/20953 "2020-01-28T12:23:54Z")
Hi All, I am beginner to Node Red . I am trying to connect MySQL database using "node-red-node-mysql" through a simple MySQL Query . I am getting following error Error: ER\_NOT\_SUPPORTED\_AUTH\_MODE: Client does not suppo… --- ## [Dashboard turns "old" values to zero](https://discourse.nodered.org/t/dashboard-turns-old-values-to-zero/20933)
**Author:** [@manjha](https://discourse.nodered.org/u/manjha)\ **Replies:** 3\ **Last updated:** [28 January 2020 10:34 UTC](https://discourse.nodered.org/t/dashboard-turns-old-values-to-zero/20933 "2020-01-28T10:34:54Z")
I am just getting started with Dashboard, so the problem is most likely caused by a user error. For internet speedtest results I have created a set of gauges to display down- and upload speeds and ping time. This displ… --- ## [Help with trigger combination](https://discourse.nodered.org/t/help-with-trigger-combination/20914)
**Author:** [@fernmac](https://discourse.nodered.org/u/fernmac)\ **Replies:** 10\ **Last updated:** [28 January 2020 10:19 UTC](https://discourse.nodered.org/t/help-with-trigger-combination/20914 "2020-01-28T10:19:51Z")
Hello, I am very new at node red. I have been using HA for a while now and since I am not a coder, it seems like a good alternative to yaml. Anyway, I already lost a few hours trying to do something, I guess, quite simp… --- ## [Node Red crash Flow dissapeared please help](https://discourse.nodered.org/t/node-red-crash-flow-dissapeared-please-help/20946)
**Author:** [@AUsername](https://discourse.nodered.org/u/AUsername)\ **Replies:** 4\ **Last updated:** [28 January 2020 09:22 UTC](https://discourse.nodered.org/t/node-red-crash-flow-dissapeared-please-help/20946 "2020-01-28T09:22:40Z")
Hi, I have a ubuntu virtual machine running node-red v1.0.3 (a local install) I have been working on a flow for 4 months now. last night the node-red web editor crashed just as I clicked deploy after i restarted the vir… --- ## [\[Announce\] node-red-contrib-lot to control GPIO](https://discourse.nodered.org/t/announce-node-red-contrib-lot-to-control-gpio/20951)
**Author:** [@hhk7734](https://discourse.nodered.org/u/hhk7734)\ **Replies:** 0\ **Last updated:** [28 January 2020 09:00 UTC](https://discourse.nodered.org/t/announce-node-red-contrib-lot-to-control-gpio/20951 "2020-01-28T09:00:16Z")
Original GPIO control node!! So far, it supports Odroid-N2 for testing. Until v1.0.0, API may not be backward compatible even if the MAJOR version does not change. The goals Allows users to control GPIO using diagr… --- ## [Alarm from time captured in Google](https://discourse.nodered.org/t/alarm-from-time-captured-in-google/20783)
**Author:** [@slurpey](https://discourse.nodered.org/u/slurpey)\ **Replies:** 10\ **Last updated:** [28 January 2020 03:17 UTC](https://discourse.nodered.org/t/alarm-from-time-captured-in-google/20783 "2020-01-28T03:17:10Z")
In short: I have a time that comes as a spoken decimal "9.51" and I need to Convert in a time (solved below) Check time "now" and convert to 24hrs if needed (if time now is earlier than 9, then leave it as is, else, ad… --- ## [MQTT Server Connectivity from Podman](https://discourse.nodered.org/t/mqtt-server-connectivity-from-podman/20943)
**Author:** [@mattp](https://discourse.nodered.org/u/mattp)\ **Replies:** 0\ **Last updated:** [28 January 2020 01:39 UTC](https://discourse.nodered.org/t/mqtt-server-connectivity-from-podman/20943 "2020-01-28T01:39:46Z")
Hi everyone, have been tearing my hair out over this one, and wondering if anyone has seen it. I am in the process of migrating my home automation setup from Centos 7 / Docker to Centos 8 / Podman and are testing my set… --- ## [Need Text and Numeric Input help](https://discourse.nodered.org/t/need-text-and-numeric-input-help/20889)
**Author:** [@vlturner](https://discourse.nodered.org/u/vlturner)\ **Replies:** 7\ **Last updated:** [28 January 2020 00:32 UTC](https://discourse.nodered.org/t/need-text-and-numeric-input-help/20889 "2020-01-28T00:32:51Z")
I need to set my charge values that will be used to drive the automated runs. So I need to set one value to 0-100 and the other value 0-100. When I hit the run button it will open and close valves based on the count. I… --- ## [Save changes on node from sidebar](https://discourse.nodered.org/t/save-changes-on-node-from-sidebar/20818)
**Author:** [@tanya](https://discourse.nodered.org/u/tanya)\ **Replies:** 4\ **Last updated:** [28 January 2020 00:30 UTC](https://discourse.nodered.org/t/save-changes-on-node-from-sidebar/20818 "2020-01-28T00:30:33Z")
hi, i want to update on nodes from sidebar palette how can i do it? --- ## [Ok, I have to ask: What's the difference between an externally written node and a subflow?](https://discourse.nodered.org/t/ok-i-have-to-ask-whats-the-difference-between-an-externally-written-node-and-a-subflow/20938)
**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\ **Replies:** 1\ **Last updated:** [28 January 2020 00:10 UTC](https://discourse.nodered.org/t/ok-i-have-to-ask-whats-the-difference-between-an-externally-written-node-and-a-subflow/20938 "2020-01-28T00:10:29Z")
The title kind of speaks for itself. But I was just wondering what the difference is. A subflow is limited to 1 input. I'm not exactly sure a node is. Not that I have ever really seen any nodes with more than 1 input… --- ## [Using color-picker in UI Template](https://discourse.nodered.org/t/using-color-picker-in-ui-template/16764)
**Author:** [@hazymat](https://discourse.nodered.org/u/hazymat)\ **Replies:** 4\ **Last updated:** [27 January 2020 23:24 UTC](https://discourse.nodered.org/t/using-color-picker-in-ui-template/16764 "2020-01-27T23:24:18Z")
Has anyone managed to get color-picker working in a Dashboard Template node? \\ This displays … --- ## [Changes to Context Flow Variable also changes source array it was extracted from](https://discourse.nodered.org/t/changes-to-context-flow-variable-also-changes-source-array-it-was-extracted-from/17070)
**Author:** [@IanH](https://discourse.nodered.org/u/IanH)\ **Replies:** 8\ **Last updated:** [27 January 2020 23:17 UTC](https://discourse.nodered.org/t/changes-to-context-flow-variable-also-changes-source-array-it-was-extracted-from/17070 "2020-01-27T23:17:27Z")
I have found what I think is anomalous behavior (from what I expected) when changing an element in a context Flow Object Variable that was itself extracted as one object in an array of objects from a object in Context F… --- ## [Powershell payload](https://discourse.nodered.org/t/powershell-payload/19613)
**Author:** [@KevinPamu](https://discourse.nodered.org/u/KevinPamu)\ **Replies:** 4\ **Last updated:** [27 January 2020 22:14 UTC](https://discourse.nodered.org/t/powershell-payload/19613 "2020-01-27T22:14:32Z")
Hello, I am running the powershell script on a windows machine using the powershell node. https://flows.nodered.org/node/node-red-contrib-powershell I get a payload that comes back when I change the debug node to msg… --- ## [Maniuplating a msg:string so I can make it a msg.payload?](https://discourse.nodered.org/t/maniuplating-a-msg-string-so-i-can-make-it-a-msg-payload/20934)
**Author:** [@WalterWhite](https://discourse.nodered.org/u/WalterWhite)\ **Replies:** 1\ **Last updated:** [27 January 2020 21:51 UTC](https://discourse.nodered.org/t/maniuplating-a-msg-string-so-i-can-make-it-a-msg-payload/20934 "2020-01-27T21:51:18Z")
I have a payload that gets returned from a powershell node, which produces data as requested. However, the debug shows the format as msg:string I've been unsuccessful finding any documentations on how to point to this,… --- ## [What's wrong in my flow](https://discourse.nodered.org/t/whats-wrong-in-my-flow/20927)
**Author:** [@devifast](https://discourse.nodered.org/u/devifast)\ **Replies:** 1\ **Last updated:** [27 January 2020 21:00 UTC](https://discourse.nodered.org/t/whats-wrong-in-my-flow/20927 "2020-01-27T21:00:30Z")
Im verry new in node red . I can't figure out where I'm wrong in this simple flow. sorry for my bad english. \[ { "id": "db1e7864.8ec9b8", "type": "tab", "label": "Flow 1", "disabled": false, "info": "" }, { "i… --- ## [Node-Red \*CPU load\* -- wierd things going on](https://discourse.nodered.org/t/node-red-cpu-load-wierd-things-going-on/20856)
**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\ **Replies:** 18\ **Last updated:** [27 January 2020 20:44 UTC](https://discourse.nodered.org/t/node-red-cpu-load-wierd-things-going-on/20856 "2020-01-27T20:44:37Z")
(Yeah, I'm a gluten for this.) Just mentioning. If anyone knows something, I'm interested. But more so it is a statement. My system: Intel NUC I5 CPU. 15 Gig or RAM. 500 G SSD. Ubuntu 18.04 LTS. NR 1.0.3 Firefo… --- ## [Update text / gauge when load the page with latest value](https://discourse.nodered.org/t/update-text-gauge-when-load-the-page-with-latest-value/20925)
**Author:** [@lucianv](https://discourse.nodered.org/u/lucianv)\ **Replies:** 3\ **Last updated:** [27 January 2020 20:04 UTC](https://discourse.nodered.org/t/update-text-gauge-when-load-the-page-with-latest-value/20925 "2020-01-27T20:04:30Z")
Hi, I have a simple flow which is an mqtt in node which is read by a gauge and also by a function that insert into db the temp value received on the mqtt topic. If I have the page opened and mqtt receive a temp then the… --- ## [Can Bus -- Schneider PLC](https://discourse.nodered.org/t/can-bus-schneider-plc/20922)
**Author:** [@mastin\_zgz](https://discourse.nodered.org/u/mastin_zgz)\ **Replies:** 0\ **Last updated:** [27 January 2020 18:16 UTC](https://discourse.nodered.org/t/can-bus-schneider-plc/20922 "2020-01-27T18:16:16Z")
Good afternoon, I introduce myself, I am new to node red, I have a project in mind and I don't know if it would be possible to do it, so I ask for help from those who know. I have a device with Can bus connectivity, an… --- ## [How to track temperature trend](https://discourse.nodered.org/t/how-to-track-temperature-trend/20546)
**Author:** [@mobamoba](https://discourse.nodered.org/u/mobamoba)\ **Replies:** 37\ **Last updated:** [27 January 2020 17:59 UTC](https://discourse.nodered.org/t/how-to-track-temperature-trend/20546 "2020-01-27T17:59:10Z")
I can't quite figure out how to do something in Node Red so thought I'd ask here. I have a networked thermometer in my fridge and I'm trying to have Node Red send me an alert if the following two conditions are both met… --- ## [Function to convert sensor resistance to temperature](https://discourse.nodered.org/t/function-to-convert-sensor-resistance-to-temperature/20861)
**Author:** [@seattlebiker](https://discourse.nodered.org/u/seattlebiker)\ **Replies:** 14\ **Last updated:** [27 January 2020 17:12 UTC](https://discourse.nodered.org/t/function-to-convert-sensor-resistance-to-temperature/20861 "2020-01-27T17:12:07Z")
Please forgive the long and an apparent off-topic post, but I'm at my wits end trying to figure out a math function node. I have a temperature/humidity sensor from MetOne Instruments that I'm trying to come up with a fu… --- ## [\[Question\] Best way to install modules to an offline pc](https://discourse.nodered.org/t/question-best-way-to-install-modules-to-an-offline-pc/20902)
**Author:** [@Nxito](https://discourse.nodered.org/u/Nxito)\ **Replies:** 11\ **Last updated:** [27 January 2020 16:22 UTC](https://discourse.nodered.org/t/question-best-way-to-install-modules-to-an-offline-pc/20902 "2020-01-27T16:22:21Z")
Hi, to start, i'm using windows 10 : The problem is: what is the best way to install a module such as node-red-contrib-s7 (for example) on a computer without internet connection? On this offline device I have copied m… --- ## [MySQL Node - change Host Variable](https://discourse.nodered.org/t/mysql-node-change-host-variable/20903)
**Author:** [@jlb](https://discourse.nodered.org/u/jlb)\ **Replies:** 5\ **Last updated:** [27 January 2020 15:15 UTC](https://discourse.nodered.org/t/mysql-node-change-host-variable/20903 "2020-01-27T15:15:56Z")
Hello, i'm using the MySql node with the ui node for inputs and results display. I have a dropdown list filled with all the possible database to connect. How can i send the selected database from the dropdown list to t… --- ## [\[Change request\] Node size and group width select](https://discourse.nodered.org/t/change-request-node-size-and-group-width-select/20901)
**Author:** [@lsaranto](https://discourse.nodered.org/u/lsaranto)\ **Replies:** 4\ **Last updated:** [27 January 2020 15:07 UTC](https://discourse.nodered.org/t/change-request-node-size-and-group-width-select/20901 "2020-01-27T15:07:05Z")
Please make it so that the size and width select dialogs stay open until clicked. Or make them input fields. The current hover method is inconvenient and not accessible to everyone. --- ## [Simple JSON input string to LEDs on dash](https://discourse.nodered.org/t/simple-json-input-string-to-leds-on-dash/20003)
**Author:** [@deelerke](https://discourse.nodered.org/u/deelerke)\ **Replies:** 20\ **Last updated:** [27 January 2020 12:54 UTC](https://discourse.nodered.org/t/simple-json-input-string-to-leds-on-dash/20003 "2020-01-27T12:54:03Z")
hello, taking my first steps into Node-RED, I'm running into what seems a simple problem. I have an existing home automation system that outputs a JSON string with the status of every light in the house. The output loo… --- ## [How to use join node with reduce sequence mode](https://discourse.nodered.org/t/how-to-use-join-node-with-reduce-sequence-mode/20892)
**Author:** [@ab73863](https://discourse.nodered.org/u/ab73863)\ **Replies:** 2\ **Last updated:** [27 January 2020 11:35 UTC](https://discourse.nodered.org/t/how-to-use-join-node-with-reduce-sequence-mode/20892 "2020-01-27T11:35:48Z")
Hello, As part of learning node red I was trying to use the join node . I was able to use and understand the join node with automatic and manual mode option. But I am not able to understand how to use the reduce sequenc… --- ## [E-mail in node preferences](https://discourse.nodered.org/t/e-mail-in-node-preferences/20898)
**Author:** [@risquare](https://discourse.nodered.org/u/risquare)\ **Replies:** 1\ **Last updated:** [27 January 2020 08:38 UTC](https://discourse.nodered.org/t/e-mail-in-node-preferences/20898 "2020-01-27T08:38:20Z")
Trying to setup the "e-mail-in node" to pick up e-mails only that are originated by one particular sender. There is no such criteria in the menu, however there is an intriguing criteria set from msg.criteria - How do… --- ## [How to create Dashboard EXE file](https://discourse.nodered.org/t/how-to-create-dashboard-exe-file/20895)
**Author:** [@Allappamp](https://discourse.nodered.org/u/Allappamp)\ **Replies:** 1\ **Last updated:** [27 January 2020 07:20 UTC](https://discourse.nodered.org/t/how-to-create-dashboard-exe-file/20895 "2020-01-27T07:20:07Z")
hello, I have completed my node red project but i am not able to create exe file of my node red project. please tell me how to create exe file for node red ui...... [Previous page](https://discourse.nodered.org/latest.md?page=1166) [Next page](https://discourse.nodered.org/latest.md?page=1168)