# General

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

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

**Page:** 334

---

## [How to connect DB node to a local server?](https://discourse.nodered.org/t/how-to-connect-db-node-to-a-local-server/66648)

<div class="topic-metadata">

**Author:** [@mykerinos1](https://discourse.nodered.org/u/mykerinos1)\
**Replies:** 2\
**Last updated:** [19 August 2022 12:00 UTC](https://discourse.nodered.org/t/how-to-connect-db-node-to-a-local-server/66648 "2022-08-19T12:00:59Z")

</div>

Hello. i moved my database on my local server sinology. I don't know how to set DB node. because nodered is on a raspberry and database is with an other ip. So if i set localhost it doesnt work. if i set server ip like h…

---

## [SQLite data into PDF report](https://discourse.nodered.org/t/sqlite-data-into-pdf-report/65782)

<div class="topic-metadata">

**Author:** [@SplitSecComp](https://discourse.nodered.org/u/SplitSecComp)\
**Replies:** 35\
**Last updated:** [19 August 2022 10:45 UTC](https://discourse.nodered.org/t/sqlite-data-into-pdf-report/65782 "2022-08-19T10:45:21Z")

</div>

Hi. I want to display SQLite data in a PDF report in a table format. I can get the PDF file to work as well as the table in in the PDF file with PDFMake. I can also get the SQL data out of the data basis with queries. H…

---

## [Flow's env variable not updated or lost](https://discourse.nodered.org/t/flows-env-variable-not-updated-or-lost/66641)

<div class="topic-metadata">

**Author:** [@Barbudor](https://discourse.nodered.org/u/Barbudor)\
**Replies:** 2\
**Last updated:** [19 August 2022 09:54 UTC](https://discourse.nodered.org/t/flows-env-variable-not-updated-or-lost/66641 "2022-08-19T09:54:01Z")

</div>

Hello, I store global parameters for my flow such as a user credential, API server URL, alarm destination emails... into flows' environment variables. I have standard subflows that are re-used in many flows that can get…

---

## [Syntax error in settings.js while using configuration from the official documentation](https://discourse.nodered.org/t/syntax-error-in-settings-js-while-using-configuration-from-the-official-documentation/66655)

<div class="topic-metadata">

**Author:** [@Marcom-UR](https://discourse.nodered.org/u/Marcom-UR)\
**Replies:** 2\
**Last updated:** [19 August 2022 09:37 UTC](https://discourse.nodered.org/t/syntax-error-in-settings-js-while-using-configuration-from-the-official-documentation/66655 "2022-08-19T09:37:27Z")

</div>

Hi, does somebody know what could be the reason for this problem? I have not seen anybody else encounter the same thing for testing im using this settings.js configuration: adminAuth: { type: "credentials", use…

---

## [Http request with dynamic credentials](https://discourse.nodered.org/t/http-request-with-dynamic-credentials/66644)

<div class="topic-metadata">

**Author:** [@plouc](https://discourse.nodered.org/u/plouc)\
**Replies:** 5\
**Last updated:** [19 August 2022 09:24 UTC](https://discourse.nodered.org/t/http-request-with-dynamic-credentials/66644 "2022-08-19T09:24:17Z")

</div>

Hello everyone! I'm building in node-red a central controller for various audio/video equipment. they have a web interface, so an easy way to control them is to use the node http-request. This works great, however som…

---

## [Hue Dimmer stop sending informations](https://discourse.nodered.org/t/hue-dimmer-stop-sending-informations/66635)

<div class="topic-metadata">

**Author:** [@NH04121986](https://discourse.nodered.org/u/NH04121986)\
**Replies:** 0\
**Last updated:** [19 August 2022 04:18 UTC](https://discourse.nodered.org/t/hue-dimmer-stop-sending-informations/66635 "2022-08-19T04:18:05Z")

</div>

Hi guys. I have a SmartHome based on Apple HomeKit and started weeks ago to bring everything into Node-Red. So I‘m a newbie. Most of the thongs are running quite well, but I got problems with my Hue Dimmer V1. I did a …

---

## [Creating a Lookup Table with double digits](https://discourse.nodered.org/t/creating-a-lookup-table-with-double-digits/66623)

<div class="topic-metadata">

**Author:** [@Jaime\_G](https://discourse.nodered.org/u/Jaime_G)\
**Replies:** 5\
**Last updated:** [19 August 2022 00:04 UTC](https://discourse.nodered.org/t/creating-a-lookup-table-with-double-digits/66623 "2022-08-19T00:04:13Z")

</div>

Hi community! I've been using a look up function that I've created for some time now and it's been working well,,,, until today that I ran into a scenario that has double digits. When I inject the value 1 through 9 …

---

## [Connection to socket.io websocket for updates, how?](https://discourse.nodered.org/t/connection-to-socket-io-websocket-for-updates-how/15482)

<div class="topic-metadata">

**Author:** [@swiftnesses](https://discourse.nodered.org/u/swiftnesses)\
**Replies:** 14\
**Last updated:** [18 August 2022 23:09 UTC](https://discourse.nodered.org/t/connection-to-socket-io-websocket-for-updates-how/15482 "2022-08-18T23:09:59Z")

</div>

Good day, I'm looking for a way to connect to a simple socket.io websocket to receive real time events, an example can be found here: https://ws.moodo.co:9090 (view-source). How can I best achieve this in Node Red?

---

## [How to use msg.payload of a function into javascript?](https://discourse.nodered.org/t/how-to-use-msg-payload-of-a-function-into-javascript/66626)

<div class="topic-metadata">

**Author:** [@Macko](https://discourse.nodered.org/u/Macko)\
**Replies:** 5\
**Last updated:** [18 August 2022 22:55 UTC](https://discourse.nodered.org/t/how-to-use-msg-payload-of-a-function-into-javascript/66626 "2022-08-18T22:55:14Z")

</div>

I have a function that pulls information from a database, I've even saved it to a global variable. The problem is that I don't know how to use this value in javascript, I have tried with global.get() but the console giv…

---

## [OPC xml client ItemName/ItemPath](https://discourse.nodered.org/t/opc-xml-client-itemname-itempath/65707)

<div class="topic-metadata">

**Author:** [@Neligan](https://discourse.nodered.org/u/Neligan)\
**Replies:** 4\
**Last updated:** [18 August 2022 21:32 UTC](https://discourse.nodered.org/t/opc-xml-client-itemname-itempath/65707 "2022-08-18T21:32:27Z")

</div>

hi, i'm trying to use opcxml supflow (opcxml subflow (flow) - Node-RED) and have some problems to read the variables of a SIMOTION D445\_2 (Siemens). With an external Client there are no Problems to get the Values. But sp…

---

## [Read out the waste calendar](https://discourse.nodered.org/t/read-out-the-waste-calendar/66488)

<div class="topic-metadata">

**Author:** [@Wurmi](https://discourse.nodered.org/u/Wurmi)\
**Replies:** 31\
**Last updated:** [18 August 2022 18:53 UTC](https://discourse.nodered.org/t/read-out-the-waste-calendar/66488 "2022-08-18T18:53:07Z")

</div>

Hi guys, i have tried to read out this page per http request "Bad Schallerbach - GEM2GO WEB - Zentrum - Bürger\<br\>service - Abfall & Entsorgung - Abfalltermine" But the information about the schedule is not included i…

---

## [I have to ping every 5 - 10 second a device to see if it is online or offline (i don't know the ip)](https://discourse.nodered.org/t/i-have-to-ping-every-5-10-second-a-device-to-see-if-it-is-online-or-offline-i-dont-know-the-ip/65878)

<div class="topic-metadata">

**Author:** [@Manupaolas](https://discourse.nodered.org/u/Manupaolas)\
**Replies:** 36\
**Last updated:** [18 August 2022 18:01 UTC](https://discourse.nodered.org/t/i-have-to-ping-every-5-10-second-a-device-to-see-if-it-is-online-or-offline-i-dont-know-the-ip/65878 "2022-08-18T18:01:41Z")

</div>

Ok, the title may be confusing or not, but i have my PC that currently is in an appartment connected to the internet with a mobile router, so the IP is always changing, i've tried several methods, that kinda worked but n…

---

## [Impossible to launch Puppeteer on Raspberry](https://discourse.nodered.org/t/impossible-to-launch-puppeteer-on-raspberry/66591)

<div class="topic-metadata">

**Author:** [@MichelTruelle](https://discourse.nodered.org/u/MichelTruelle)\
**Replies:** 12\
**Last updated:** [18 August 2022 16:21 UTC](https://discourse.nodered.org/t/impossible-to-launch-puppeteer-on-raspberry/66591 "2022-08-18T16:21:57Z")

</div>

I have an issue when I try to launch puppeteer with my Raspberry using node-red. I am using the node-red-contrib-puppeteer-new library and this error code appears : Error: Failed to launch the browser process! /home/pi/…

---

## [Sun position - Azimuth at a certain Altitude](https://discourse.nodered.org/t/sun-position-azimuth-at-a-certain-altitude/66592)

<div class="topic-metadata">

**Author:** [@Nilpferd](https://discourse.nodered.org/u/Nilpferd)\
**Replies:** 1\
**Last updated:** [18 August 2022 15:51 UTC](https://discourse.nodered.org/t/sun-position-azimuth-at-a-certain-altitude/66592 "2022-08-18T15:51:47Z")

</div>

With the nodes sunposition and within-time I can detect in the morning when the altitude == 15 degrees and write down the time (with simpletime) to the dashboard. My problem is that at this time I also want to get the a…

---

## [Node-red-node-sqlite installation error](https://discourse.nodered.org/t/node-red-node-sqlite-installation-error/66617)

<div class="topic-metadata">

**Author:** [@FabioT](https://discourse.nodered.org/u/FabioT)\
**Replies:** 4\
**Last updated:** [18 August 2022 15:35 UTC](https://discourse.nodered.org/t/node-red-node-sqlite-installation-error/66617 "2022-08-18T15:35:44Z")

</div>

Hi All, I'm trying to install node-red-node-sqlite module in my device. I'm working with ND 2.0.6 version, v12.22.5 nodejs version. Trying to install that module, the installation fails with the following log file: -…

---

## [How to check if data is running through a node (CANbus in this case)](https://discourse.nodered.org/t/how-to-check-if-data-is-running-through-a-node-canbus-in-this-case/66614)

<div class="topic-metadata">

**Author:** [@Kymc0](https://discourse.nodered.org/u/Kymc0)\
**Replies:** 2\
**Last updated:** [18 August 2022 15:14 UTC](https://discourse.nodered.org/t/how-to-check-if-data-is-running-through-a-node-canbus-in-this-case/66614 "2022-08-18T15:14:02Z")

</div>

Hi all, This will be my first post so I'll try to do everything by the book. I'm working on a project that will make a conversion from canbus to modbus TCP. I'm almost finished but I was wondering about one thing. Wou…

---

## [Node-red-node-sqlite install error](https://discourse.nodered.org/t/node-red-node-sqlite-install-error/66603)

<div class="topic-metadata">

**Author:** [@FabioT](https://discourse.nodered.org/u/FabioT)\
**Replies:** 8\
**Last updated:** [18 August 2022 15:09 UTC](https://discourse.nodered.org/t/node-red-node-sqlite-install-error/66603 "2022-08-18T15:09:47Z")

</div>

Hi All, I'm working with node-red v 2.0.6 and node-js v12.22.5. I'm trying to install node-red-node-sqlite (v1.0.3) but an error occours everytime. The error is always the same, see attached log file. Can anyone help …

---

## [String vs Object with CronPlus](https://discourse.nodered.org/t/string-vs-object-with-cronplus/66556)

<div class="topic-metadata">

**Author:** [@alex88](https://discourse.nodered.org/u/alex88)\
**Replies:** 7\
**Last updated:** [18 August 2022 14:57 UTC](https://discourse.nodered.org/t/string-vs-object-with-cronplus/66556 "2022-08-18T14:57:17Z")

</div>

Hi All, I have a cron-plus node that gets sunset and sunrise time and stores it into a global variable. It has been causing me issues for months now, every time I stop and start the NR service I have to manually re-run…

---

## [Handles to indiviudal nodes](https://discourse.nodered.org/t/handles-to-indiviudal-nodes/66601)

<div class="topic-metadata">

**Author:** [@magnusso](https://discourse.nodered.org/u/magnusso)\
**Replies:** 7\
**Last updated:** [18 August 2022 14:37 UTC](https://discourse.nodered.org/t/handles-to-indiviudal-nodes/66601 "2022-08-18T14:37:38Z")

</div>

Is there some way to access all nodes of type ui-switch from inside a function node. i.e. can one query all nodes and filter out the nodes of the type ui-switch?

---

## [Nodes update - SELF\_SIGNED\_CERT\_IN\_CHAIN error](https://discourse.nodered.org/t/nodes-update-self-signed-cert-in-chain-error/66609)

<div class="topic-metadata">

**Author:** [@FabioT](https://discourse.nodered.org/u/FabioT)\
**Replies:** 0\
**Last updated:** [18 August 2022 13:04 UTC](https://discourse.nodered.org/t/nodes-update-self-signed-cert-in-chain-error/66609 "2022-08-18T13:04:30Z")

</div>

Hi All, trying to update node-red nodes from "Manage palette", I have everytime, for all nodes I try to update, an error that says "err SELF\_SIGNED\_CERT\_IN\_CHAIN". Here below the complete log: 2022-08-18T12:59:23.275Z…

---

## [How can I log in on a website that requires authentication with node-red](https://discourse.nodered.org/t/how-can-i-log-in-on-a-website-that-requires-authentication-with-node-red/66606)

<div class="topic-metadata">

**Author:** [@raymondh](https://discourse.nodered.org/u/raymondh)\
**Replies:** 4\
**Last updated:** [18 August 2022 12:46 UTC](https://discourse.nodered.org/t/how-can-i-log-in-on-a-website-that-requires-authentication-with-node-red/66606 "2022-08-18T12:46:31Z")

</div>

Hi there. I'm complete noob when it comes to Node-Red, but i do have a background in Java and C#, my HTML is mediocre at best. So background out of the way, here it is: I am trying to log into a website that i need to …

---

## [Editor Won't Load on Screen - Monaco Error](https://discourse.nodered.org/t/editor-wont-load-on-screen-monaco-error/66574)

<div class="topic-metadata">

**Author:** [@dudleyjosh](https://discourse.nodered.org/u/dudleyjosh)\
**Replies:** 7\
**Last updated:** [18 August 2022 12:34 UTC](https://discourse.nodered.org/t/editor-wont-load-on-screen-monaco-error/66574 "2022-08-18T12:34:28Z")

</div>

I just updated a Raspberry Pi to Node-RED v3.0.2 (from 2.2.0) and the editor won't load (just a blank screen as seen in the image below) and when I check the console I see the following error: Uncaught ReferenceError: m…

---

## [Get/Set data from a Home Assistant device from another device](https://discourse.nodered.org/t/get-set-data-from-a-home-assistant-device-from-another-device/66577)

<div class="topic-metadata">

**Author:** [@GaryK4](https://discourse.nodered.org/u/GaryK4)\
**Replies:** 5\
**Last updated:** [18 August 2022 12:30 UTC](https://discourse.nodered.org/t/get-set-data-from-a-home-assistant-device-from-another-device/66577 "2022-08-18T12:30:26Z")

</div>

I just starting using Home Assistant os on a Raspberry Pi. I installed NR on that RPI. I have another RPI that is running a Java display app that communicates with Universal Devices devices and displays the status and ha…

---

## [I am new to Node-RED and I am trying to load the csv file from windows in my Node-RED but the file is not found](https://discourse.nodered.org/t/i-am-new-to-node-red-and-i-am-trying-to-load-the-csv-file-from-windows-in-my-node-red-but-the-file-is-not-found/66058)

<div class="topic-metadata">

**Author:** [@beenodbaneeya](https://discourse.nodered.org/u/beenodbaneeya)\
**Replies:** 19\
**Last updated:** [18 August 2022 09:57 UTC](https://discourse.nodered.org/t/i-am-new-to-node-red-and-i-am-trying-to-load-the-csv-file-from-windows-in-my-node-red-but-the-file-is-not-found/66058 "2022-08-18T09:57:21Z")

</div>

Error: ENOENT: no such file or directory I am using Node.JS version :v16.14.0 and Node-RED version: v2.2.2

---

## [Node RED don´t start](https://discourse.nodered.org/t/node-red-don-t-start/66561)

<div class="topic-metadata">

**Author:** [@joal91](https://discourse.nodered.org/u/joal91)\
**Replies:** 7\
**Last updated:** [18 August 2022 09:30 UTC](https://discourse.nodered.org/t/node-red-don-t-start/66561 "2022-08-18T09:30:19Z")

</div>

Hello, sorry I'm new to node red and I'm not getting the program to start, could you help C:\\Users\\jose\_\>node-red 17 Aug 11:12:11 - \[info\] Welcome to Node-RED 17 Aug 11:12:11 - \[info\] Node-RED version: v3.0.2 17 Aug …

---

## [How to access Docker Secrets in Node-RED Container](https://discourse.nodered.org/t/how-to-access-docker-secrets-in-node-red-container/66330)

<div class="topic-metadata">

**Author:** [@kitkat159](https://discourse.nodered.org/u/kitkat159)\
**Replies:** 7\
**Last updated:** [18 August 2022 09:15 UTC](https://discourse.nodered.org/t/how-to-access-docker-secrets-in-node-red-container/66330 "2022-08-18T09:15:28Z")

</div>

Hey everyone! I am running Node-RED under Docker and for development I am setting some credentials for an external server as environment variables. However, in production use I want to set these credentials Docker Secre…

---

## [How to reset time](https://discourse.nodered.org/t/how-to-reset-time/66441)

<div class="topic-metadata">

**Author:** [@kelvin](https://discourse.nodered.org/u/kelvin)\
**Replies:** 18\
**Last updated:** [18 August 2022 09:05 UTC](https://discourse.nodered.org/t/how-to-reset-time/66441 "2022-08-18T09:05:56Z")

</div>

Hi Everyone, I'm here for asking how to i reset the time? Examples: when i inject a timestamp from 8 a.m to 5 p.m and the debug will give me Singapore time and the date. When after 5 p.m will auto reset the time, will…

---

## [JS Noob - does not understand error of monaco editor](https://discourse.nodered.org/t/js-noob-does-not-understand-error-of-monaco-editor/66576)

<div class="topic-metadata">

**Author:** [@mickym2](https://discourse.nodered.org/u/mickym2)\
**Replies:** 2\
**Last updated:** [18 August 2022 09:05 UTC](https://discourse.nodered.org/t/js-noob-does-not-understand-error-of-monaco-editor/66576 "2022-08-18T09:05:15Z")

</div>

I have the following code: client.reverse(msg.payload).then((/\*\* @type {any} \*/ output) =\> { msg.payload = output; node.send(msg); node.done(); }).catch((/\*\* @type {{ name: any; message: any; }} \*/ err) =\> …

---

## [DCF time form KNX to adjust time in Node Red](https://discourse.nodered.org/t/dcf-time-form-knx-to-adjust-time-in-node-red/66419)

<div class="topic-metadata">

**Author:** [@Nilpferd](https://discourse.nodered.org/u/Nilpferd)\
**Replies:** 12\
**Last updated:** [18 August 2022 09:04 UTC](https://discourse.nodered.org/t/dcf-time-form-knx-to-adjust-time-in-node-red/66419 "2022-08-18T09:04:01Z")

</div>

In KNX I get the date/time from a DCF Receiver . This date/time I want to use in Node Red to adjust both sysem to exactly the same time. How to impement the time in the Node Red system time? Erwin

---

## [Inject Node - dev](https://discourse.nodered.org/t/inject-node-dev/66568)

<div class="topic-metadata">

**Author:** [@dougle03](https://discourse.nodered.org/u/dougle03)\
**Replies:** 6\
**Last updated:** [18 August 2022 08:07 UTC](https://discourse.nodered.org/t/inject-node-dev/66568 "2022-08-18T08:07:47Z")

</div>

Hi, Does anyone, with way more skill than me, fancy forking the inject node, and making the specific option accept a variable rather than a fixed value. Would this even be possible? Reason: I want to be able to refe…

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

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