# General **URL:** https://discourse.nodered.org/c/general/7.md?page=862 [Latest](https://discourse.nodered.org/latest.md) · [Categories](https://discourse.nodered.org/categories.md) · [Tags](https://discourse.nodered.org/tags.md) **Page:** 863 --- ## [Error on INSERT INTO sqlite DB](https://discourse.nodered.org/t/error-on-insert-into-sqlite-db/13872)
**Author:** [@pautorras](https://discourse.nodered.org/u/pautorras)\ **Replies:** 2\ **Last updated:** [31 July 2019 16:41 UTC](https://discourse.nodered.org/t/error-on-insert-into-sqlite-db/13872 "2019-07-31T16:41:12Z")
Hi, When I insert some var values in sqlite DB, debug console send me this kind of message: "Error: SQLITE\_ERROR: near ":12": syntax error" "Error: SQLITE\_ERROR: near ":02": syntax error" In a function i'm trying to … --- ## [How to integrate node red with wifi](https://discourse.nodered.org/t/how-to-integrate-node-red-with-wifi/13828)
**Author:** [@VIKRAMAS](https://discourse.nodered.org/u/VIKRAMAS)\ **Replies:** 7\ **Last updated:** [31 July 2019 16:24 UTC](https://discourse.nodered.org/t/how-to-integrate-node-red-with-wifi/13828 "2019-07-31T16:24:23Z")
I am having Advantech gateway. I wanted to install node-red in that which is having ubuntu OS. I wanted to make the Advantech gateway to work as wifi hotspot. And using wifimote I wanted to connect to that hostspot for… --- ## [User interface with Node RED](https://discourse.nodered.org/t/user-interface-with-node-red/13859)
**Author:** [@lymbo](https://discourse.nodered.org/u/lymbo)\ **Replies:** 3\ **Last updated:** [31 July 2019 16:17 UTC](https://discourse.nodered.org/t/user-interface-with-node-red/13859 "2019-07-31T16:17:30Z")
Hi, is it possible to integrate a webpage GUI OR electron desktop application w/user input with Node RED backend? Thanks! --- ## [Node Module Install](https://discourse.nodered.org/t/node-module-install/13857)
**Author:** [@rayy](https://discourse.nodered.org/u/rayy)\ **Replies:** 16\ **Last updated:** [31 July 2019 14:49 UTC](https://discourse.nodered.org/t/node-module-install/13857 "2019-07-31T14:49:36Z")
I'm trying to install a nodered module but it keeps on failing any ideas? --- ## [I have to start somewhere. Home automation control](https://discourse.nodered.org/t/i-have-to-start-somewhere-home-automation-control/13871)
**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\ **Replies:** 5\ **Last updated:** [31 July 2019 13:26 UTC](https://discourse.nodered.org/t/i-have-to-start-somewhere-home-automation-control/13871 "2019-07-31T13:26:47Z")
I am thinking of getting a bit of work done and getting 240v (AC/Main) stuff down/controlled. I live in "Oz" and there aren't too many options for a central system. There is a system from Clipsal called C-Bus. But th… --- ## [Help to read data using modbus tcp protocol](https://discourse.nodered.org/t/help-to-read-data-using-modbus-tcp-protocol/13837)
**Author:** [@ashish\_8284](https://discourse.nodered.org/u/ashish_8284)\ **Replies:** 1\ **Last updated:** [31 July 2019 12:36 UTC](https://discourse.nodered.org/t/help-to-read-data-using-modbus-tcp-protocol/13837 "2019-07-31T12:36:09Z")
Hi friends, i am new to nodered. i have install nodered on my windows PC. i tried to read data of ModbusTcp slave device using node-red-contrib-modbustcp node. i tried a lot but not getting success. Hardware :- Energy… --- ## [\[Announce\] Node-RED snap 0.19.5 available](https://discourse.nodered.org/t/announce-node-red-snap-0-19-5-available/4715)
**Author:** [@dceejay](https://discourse.nodered.org/u/dceejay)\ **Replies:** 9\ **Last updated:** [31 July 2019 09:20 UTC](https://discourse.nodered.org/t/announce-node-red-snap-0-19-5-available/4715 "2019-07-31T09:20:15Z")
Some of you may have spotted there was an occasional release of Node-RED over on the Ubuntu snapcraft.io store. Having now spent a day up at Canonical we now have a much more automated process in place so it should now s… --- ## [When can I not add a new node?](https://discourse.nodered.org/t/when-can-i-not-add-a-new-node/13820)
**Author:** [@usagi](https://discourse.nodered.org/u/usagi)\ **Replies:** 2\ **Last updated:** [31 July 2019 00:26 UTC](https://discourse.nodered.org/t/when-can-i-not-add-a-new-node/13820 "2019-07-31T00:26:47Z")
Nice to meet you Recently started Node-red I'm using Node-red on IBMcloud Adding new node from palette However, there are times when you can not add nodes I do not know the reason why I can not add a node What is t… --- ## [HTTP Request node memory overrun?](https://discourse.nodered.org/t/http-request-node-memory-overrun/13751)
**Author:** [@m\_elias](https://discourse.nodered.org/u/m_elias)\ **Replies:** 6\ **Last updated:** [30 July 2019 20:36 UTC](https://discourse.nodered.org/t/http-request-node-memory-overrun/13751 "2019-07-30T20:36:33Z")
I have a small flow with two HTTP request nodes and a few others. If I double click to edit the one and then click outside of the edit window, then that http request node somehow changes into a copy of the 2nd http reque… --- ## [Reading Hue Brightness values](https://discourse.nodered.org/t/reading-hue-brightness-values/13851)
**Author:** [@phreaq](https://discourse.nodered.org/u/phreaq)\ **Replies:** 6\ **Last updated:** [30 July 2019 20:22 UTC](https://discourse.nodered.org/t/reading-hue-brightness-values/13851 "2019-07-30T20:22:18Z")
Hi folks, I am trying to read the brightness level of one of my Hue Lights, and change it's color based on the value, but I'm struggling with the basics. Is anyone able to tell me what I am doing wrong with the followi… --- ## [Getting HTTP output](https://discourse.nodered.org/t/getting-http-output/13853)
**Author:** [@rayy](https://discourse.nodered.org/u/rayy)\ **Replies:** 1\ **Last updated:** [30 July 2019 17:33 UTC](https://discourse.nodered.org/t/getting-http-output/13853 "2019-07-30T17:33:59Z")
If you want to output your data to a http format do you also need an input or any other prerequisites? --- ## [MQTT: how to find what TLS/SSL version is used](https://discourse.nodered.org/t/mqtt-how-to-find-what-tls-ssl-version-is-used/13844)
**Author:** [@krambriw](https://discourse.nodered.org/u/krambriw)\ **Replies:** 10\ **Last updated:** [30 July 2019 16:35 UTC](https://discourse.nodered.org/t/mqtt-how-to-find-what-tls-ssl-version-is-used/13844 "2019-07-30T16:35:20Z")
Hello, Secure communication between clients & brokers using certificates with TLS/SSL work fine as we know But how can I find information of what version of TLS is actually used for a specific connection? In the mosqu… --- ## [Check if variable exist](https://discourse.nodered.org/t/check-if-variable-exist/13847)
**Author:** [@pablogomez](https://discourse.nodered.org/u/pablogomez)\ **Replies:** 2\ **Last updated:** [30 July 2019 15:55 UTC](https://discourse.nodered.org/t/check-if-variable-exist/13847 "2019-07-30T15:55:12Z")
How can I check if variable exist? I tried: if (global.get("NAME")===undefined) --- ## [How to load JSON by passing node flow id in node-red on initial start](https://discourse.nodered.org/t/how-to-load-json-by-passing-node-flow-id-in-node-red-on-initial-start/13826)
**Author:** [@Sohit18595](https://discourse.nodered.org/u/Sohit18595)\ **Replies:** 17\ **Last updated:** [30 July 2019 11:51 UTC](https://discourse.nodered.org/t/how-to-load-json-by-passing-node-flow-id-in-node-red-on-initial-start/13826 "2019-07-30T11:51:22Z")
I want to load JSON by passing node flow id in node-red on initial start.Please Suggest --- ## [Ideas on doing a POST to upload a file (trying to restore config.dat in ESPEasy)](https://discourse.nodered.org/t/ideas-on-doing-a-post-to-upload-a-file-trying-to-restore-config-dat-in-espeasy/13835)
**Author:** [@zenofmud](https://discourse.nodered.org/u/zenofmud)\ **Replies:** 1\ **Last updated:** [30 July 2019 11:13 UTC](https://discourse.nodered.org/t/ideas-on-doing-a-post-to-upload-a-file-trying-to-restore-config-dat-in-espeasy/13835 "2019-07-30T11:13:16Z")
I'm coding a backup/restore flow for devices using ESPEasy. The backup works great! a folder called ESPBRR is created and in it is a folder for each device found. Inside the device folder is a folder date/time stamped an… --- ## [Send/receive data via Ethernet for Lighting](https://discourse.nodered.org/t/send-receive-data-via-ethernet-for-lighting/13669)
**Author:** [@aiotea](https://discourse.nodered.org/u/aiotea)\ **Replies:** 8\ **Last updated:** [30 July 2019 09:07 UTC](https://discourse.nodered.org/t/send-receive-data-via-ethernet-for-lighting/13669 "2019-07-30T09:07:00Z")
Hi Everyone, I have a light control board that uses a Main board to send lighting signals to a Receiver board via ethernet cable. I'm trying to allow that to happen wirelessly, by putting 2 RPi's in between each board t… --- ## [Homekit-bridged + connection from outside the house](https://discourse.nodered.org/t/homekit-bridged-connection-from-outside-the-house/13038)
**Author:** [@NickB](https://discourse.nodered.org/u/NickB)\ **Replies:** 10\ **Last updated:** [30 July 2019 08:25 UTC](https://discourse.nodered.org/t/homekit-bridged-connection-from-outside-the-house/13038 "2019-07-30T08:25:06Z")
Hi, I am using homekit-bridged and this works fine when I'm on the WiFi network. Now I have a apple tv, and I should be able to just acces all my homekit devices from distance (cellular network) because the apple tv is… --- ## [Change node data type issue](https://discourse.nodered.org/t/change-node-data-type-issue/13684)
**Author:** [@georgethomas08](https://discourse.nodered.org/u/georgethomas08)\ **Replies:** 16\ **Last updated:** [30 July 2019 05:23 UTC](https://discourse.nodered.org/t/change-node-data-type-issue/13684 "2019-07-30T05:23:17Z")
Hi, I am using change node to convert two string to number, but I am getting the output in the string data type only. why is it so ? How to change string payload to number data type payload ? Please help me. Thanks in … --- ## [How To Change Line Thickness of Chart](https://discourse.nodered.org/t/how-to-change-line-thickness-of-chart/13788)
**Author:** [@mrizkywiguna](https://discourse.nodered.org/u/mrizkywiguna)\ **Replies:** 2\ **Last updated:** [30 July 2019 03:08 UTC](https://discourse.nodered.org/t/how-to-change-line-thickness-of-chart/13788 "2019-07-30T03:08:46Z")
Hi All, I've made chart with function code for custom my line chart. But i need to make the line more bigger. I've try to put syntax lineThickness on optional. But still doesn't work. Here is my code: \[ { "… --- ## [IBM Watson Sensor Support](https://discourse.nodered.org/t/ibm-watson-sensor-support/13738)
**Author:** [@rayy](https://discourse.nodered.org/u/rayy)\ **Replies:** 45\ **Last updated:** [29 July 2019 22:48 UTC](https://discourse.nodered.org/t/ibm-watson-sensor-support/13738 "2019-07-29T22:48:41Z")
I am uploading data from a range of sensors to the IBM Watson cloud and trying to build an app using this application. How do make the sensor inputs into variables and see if they exceed a certain threshold value and add… --- ## [IBM Watson Interface](https://discourse.nodered.org/t/ibm-watson-interface/13810)
**Author:** [@rayy](https://discourse.nodered.org/u/rayy)\ **Replies:** 7\ **Last updated:** [29 July 2019 21:42 UTC](https://discourse.nodered.org/t/ibm-watson-interface/13810 "2019-07-29T21:42:41Z")
I have created a node Red program that processes data sent into the program from an iot device via the cloud. Is there any way to make some kind of interface or web page etc. so i can nicely display the outputs as infor… --- ## [Static content requires auth with httpNodeAuth](https://discourse.nodered.org/t/static-content-requires-auth-with-httpnodeauth/13809)
**Author:** [@pakerfeldt](https://discourse.nodered.org/u/pakerfeldt)\ **Replies:** 0\ **Last updated:** [29 July 2019 20:55 UTC](https://discourse.nodered.org/t/static-content-requires-auth-with-httpnodeauth/13809 "2019-07-29T20:55:29Z")
I have: Moved UI to a separate root Configured a custom static folder with httpStatic Now, if I add httpNodeAuth for authentication when accessing the Dashboard, it also requires authentication for accessing static c… --- ## [Node-RED docker instance takes 18 mins to start after node install](https://discourse.nodered.org/t/node-red-docker-instance-takes-18-mins-to-start-after-node-install/13661)
**Author:** [@justinj0305](https://discourse.nodered.org/u/justinj0305)\ **Replies:** 2\ **Last updated:** [29 July 2019 16:43 UTC](https://discourse.nodered.org/t/node-red-docker-instance-takes-18-mins-to-start-after-node-install/13661 "2019-07-29T16:43:14Z")
Not sure if this is a bug specific to the Docker release or to my environment (QNAP NAS) but I've installed Node-RED 0.20.7 (Both v8 and v10 to rule out an issue with one specific version) and it works fine, starts up in… --- ## [Can the file in node read from stdin?](https://discourse.nodered.org/t/can-the-file-in-node-read-from-stdin/13698)
**Author:** [@wb666greene](https://discourse.nodered.org/u/wb666greene)\ **Replies:** 14\ **Last updated:** [29 July 2019 15:53 UTC](https://discourse.nodered.org/t/can-the-file-in-node-read-from-stdin/13698 "2019-07-29T15:53:58Z")
I assume not as windows systems don't really have stdin or stdout. But I figure its worth asking. Edit: Forgot to mention I'm using node-red on Linux for this particular use case. If file in node could read from stdi… --- ## [Help with connecting Rpi to IBM cloud](https://discourse.nodered.org/t/help-with-connecting-rpi-to-ibm-cloud/13780)
**Author:** [@Jez](https://discourse.nodered.org/u/Jez)\ **Replies:** 3\ **Last updated:** [29 July 2019 13:21 UTC](https://discourse.nodered.org/t/help-with-connecting-rpi-to-ibm-cloud/13780 "2019-07-29T13:21:59Z")
Hi all, I would like to view the dashboard running on my rpi from outside my local network without port forwarding ( I don’t know enough about the internet to set up security). So I set up an account in the IBM cloud a… --- ## [Node-red error & twilio send message to two numbers](https://discourse.nodered.org/t/node-red-error-twilio-send-message-to-two-numbers/13785)
**Author:** [@salahuiste](https://discourse.nodered.org/u/salahuiste)\ **Replies:** 1\ **Last updated:** [29 July 2019 09:17 UTC](https://discourse.nodered.org/t/node-red-error-twilio-send-message-to-two-numbers/13785 "2019-07-29T09:17:48Z")
Hello everybody , when i deploy my projet i got this message in the console but its working perfectly ? how can i solve it ? thanks in advance and also i have another question about twilio , can i send sms to multiple… --- ## [Help Processing data](https://discourse.nodered.org/t/help-processing-data/13766)
**Author:** [@rayy](https://discourse.nodered.org/u/rayy)\ **Replies:** 7\ **Last updated:** [29 July 2019 08:20 UTC](https://discourse.nodered.org/t/help-processing-data/13766 "2019-07-29T08:20:36Z")
I have mentioned this project in another forum post but I would like to dedicate a topic for this project. This is a school project and I am using a variety of sensors connected to a chip that is cloud connected to impor… --- ## [Philips Hue Brightness + Milight](https://discourse.nodered.org/t/philips-hue-brightness-milight/13518)
**Author:** [@NR-Beginner](https://discourse.nodered.org/u/NR-Beginner)\ **Replies:** 8\ **Last updated:** [28 July 2019 07:40 UTC](https://discourse.nodered.org/t/philips-hue-brightness-milight/13518 "2019-07-28T07:40:16Z")
Hello, I'm a beginner and can't go on with a flow. I have a Philips Hue motion detector, this should only start the flow at a certain brightness. In the current flow I have the following in it: Motion is detected, Payl… --- ## [Alexa, \[do something with this\] \[database query term\]](https://discourse.nodered.org/t/alexa-do-something-with-this-database-query-term/13762)
**Author:** [@OctavioMasomenos](https://discourse.nodered.org/u/OctavioMasomenos)\ **Replies:** 1\ **Last updated:** [27 July 2019 22:59 UTC](https://discourse.nodered.org/t/alexa-do-something-with-this-database-query-term/13762 "2019-07-27T22:59:40Z")
Is there a way to do this? I want to give Alexa a command that triggers a Node-RED flow, passing it a phrase to be used for a database query. As an example, if Alexa hears me say, “let’s hear some Fat Freddy’s Drop”, th… --- ## [KNX \> ABB USB Gateway connection to Node-RED PC dashboard](https://discourse.nodered.org/t/knx-abb-usb-gateway-connection-to-node-red-pc-dashboard/13757)
**Author:** [@Dudek](https://discourse.nodered.org/u/Dudek)\ **Replies:** 3\ **Last updated:** [27 July 2019 22:55 UTC](https://discourse.nodered.org/t/knx-abb-usb-gateway-connection-to-node-red-pc-dashboard/13757 "2019-07-27T22:55:07Z")
Hi, I am totally green in a NODE RED. It is my first time. I have some KNX modules and i would like to make a small visualisation on a PC with it. Some buttons/status. I saw that it is easy with KNX/IP converter but i … [Previous page](https://discourse.nodered.org/c/general/7.md?page=861) [Next page](https://discourse.nodered.org/c/general/7.md?page=863)