# General **URL:** https://discourse.nodered.org/c/general/7.md?page=251 [Latest](https://discourse.nodered.org/latest.md) · [Categories](https://discourse.nodered.org/categories.md) · [Tags](https://discourse.nodered.org/tags.md) **Page:** 252 --- ## [Synology NAS: MySQL Error: connect ECONNREFUSED 127.0.0.1:3306 - Problem solved](https://discourse.nodered.org/t/synology-nas-mysql-error-connect-econnrefused-127-0-0-1-3306-problem-solved/74814)

**Author:** [@freenr](https://discourse.nodered.org/u/freenr)\ **Replies:** 0\ **Last updated:** [6 February 2023 22:05 UTC](https://discourse.nodered.org/t/synology-nas-mysql-error-connect-econnrefused-127-0-0-1-3306-problem-solved/74814 "2023-02-06T22:05:59Z")

Hi, I have a Synology DS218. Node-red and MariaDB10 installed. It was not possible to connect to database. The solution for me was to open MariaDB from the Synology PacketCenter and enable TCP/IP. Hope this helps so… --- ## [Send error status message that arrives as malfromed JSON String](https://discourse.nodered.org/t/send-error-status-message-that-arrives-as-malfromed-json-string/74801)

**Author:** [@SurfingSpider](https://discourse.nodered.org/u/SurfingSpider)\ **Replies:** 4\ **Last updated:** [6 February 2023 21:47 UTC](https://discourse.nodered.org/t/send-error-status-message-that-arrives-as-malfromed-json-string/74801 "2023-02-06T21:47:35Z")

I have my 3d printer connected to Home assistant which I use Node Red to do some automations. I am trying to send a message with the status information from moonraker (Klipper firmware) when there is an error. I can ge… --- ## [Node-RED Docker Crash](https://discourse.nodered.org/t/node-red-docker-crash/74760)

**Author:** [@Renegade605](https://discourse.nodered.org/u/Renegade605)\ **Replies:** 10\ **Last updated:** [6 February 2023 21:24 UTC](https://discourse.nodered.org/t/node-red-docker-crash/74760 "2023-02-06T21:24:25Z")

A couple times recently I've had NR crash with this message in the logs. I can't find any information on narrowing down the cause. Please assist? Node-RED Docker container running on Unraid (custom server). --- ## [If AND Statement formatting](https://discourse.nodered.org/t/if-and-statement-formatting/74712)

**Author:** [@Bigrob55](https://discourse.nodered.org/u/Bigrob55)\ **Replies:** 9\ **Last updated:** [6 February 2023 18:56 UTC](https://discourse.nodered.org/t/if-and-statement-formatting/74712 "2023-02-06T18:56:32Z")

Greetings NodeRed Community, I cannot say that I am exactly new to using NodeRed, however while attempting to create this flow, i sure do feel like a noobie. My Goal: Create a flow within my Home Assistant instance, … --- ## [Using start time from ical event as start for flow](https://discourse.nodered.org/t/using-start-time-from-ical-event-as-start-for-flow/74783)

**Author:** [@Twiglet](https://discourse.nodered.org/u/Twiglet)\ **Replies:** 6\ **Last updated:** [6 February 2023 18:15 UTC](https://discourse.nodered.org/t/using-start-time-from-ical-event-as-start-for-flow/74783 "2023-02-06T18:15:25Z")

Hi all, new user here. Please be gentle! I'm using node-red-contrib-ical-events to get the events for the next day (1 event per day) and get the start time. I'd like to pass this to some kind of trigger node to start a … --- ## [Node-red-contrib-ui-web-push Url is called incorrectly](https://discourse.nodered.org/t/node-red-contrib-ui-web-push-url-is-called-incorrectly/74559)

**Author:** [@EIKSEU](https://discourse.nodered.org/u/EIKSEU)\ **Replies:** 9\ **Last updated:** [6 February 2023 17:37 UTC](https://discourse.nodered.org/t/node-red-contrib-ui-web-push-url-is-called-incorrectly/74559 "2023-02-06T17:37:04Z")

Hello, Thanks for the Nodered node works :+1:. My problem is that the URL is not called correctly after clicking on the received message. I have the dashboard via a reserve proxy with ssl. The URL is https://domain, but … --- ## [HTTP-Request EPROTO Failure](https://discourse.nodered.org/t/http-request-eproto-failure/74795)

**Author:** [@ShortyIT](https://discourse.nodered.org/u/ShortyIT)\ **Replies:** 1\ **Last updated:** [6 February 2023 17:24 UTC](https://discourse.nodered.org/t/http-request-eproto-failure/74795 "2023-02-06T17:24:44Z")

Hello everyone, i have the following problem: RequestError: write EPROTO 18080000:error:0A000152:SSL routines:final\_renegotiate:unsafe legacy renegotiation disabled:c:\\ws\\deps\\openssl\\openssl\\ssl\\statem\\extensions.c:92… --- ## [Cant read file on same Pi](https://discourse.nodered.org/t/cant-read-file-on-same-pi/74802)

**Author:** [@Tinbum1](https://discourse.nodered.org/u/Tinbum1)\ **Replies:** 5\ **Last updated:** [6 February 2023 17:19 UTC](https://discourse.nodered.org/t/cant-read-file-on-same-pi/74802 "2023-02-06T17:19:03Z")

I'm using Node-Red on a Raspberry Pi and I'm trying to read a file on the same Pi. I keep getting the error 'Error: ENOENT: no such file or directory, open 'home/pi/test.txt'' but the strange thing is I can write to the … --- ## [Extracting and manipulating data with node exec](https://discourse.nodered.org/t/extracting-and-manipulating-data-with-node-exec/74789)

**Author:** [@felipeneves](https://discourse.nodered.org/u/felipeneves)\ **Replies:** 4\ **Last updated:** [6 February 2023 16:34 UTC](https://discourse.nodered.org/t/extracting-and-manipulating-data-with-node-exec/74789 "2023-02-06T16:34:42Z")

Hello everyone, everything good? I'm not a programmer, I'm from the computer network area, I have a problem with a flow, I'll try to explain what it does, I want it to read the files from inside the folder c:\\fotos\\3, a… --- ## [Splitting message and reseting msg.parts.count?](https://discourse.nodered.org/t/splitting-message-and-reseting-msg-parts-count/74502)

**Author:** [@LuSochr](https://discourse.nodered.org/u/LuSochr)\ **Replies:** 10\ **Last updated:** [6 February 2023 16:30 UTC](https://discourse.nodered.org/t/splitting-message-and-reseting-msg-parts-count/74502 "2023-02-06T16:30:14Z")

Hi to All, I am new here (although I already found lot of answers here in the past). I am completely lost and after many days of searching through this forum and the internet. I have arduino with three temp sensor on my… --- ## [Calculating days and hours between two timestamps - Almost there.. Need a tweak on this!](https://discourse.nodered.org/t/calculating-days-and-hours-between-two-timestamps-almost-there-need-a-tweak-on-this/74761)

**Author:** [@Mobile\_NR\_Env](https://discourse.nodered.org/u/Mobile_NR_Env)\ **Replies:** 5\ **Last updated:** [6 February 2023 16:28 UTC](https://discourse.nodered.org/t/calculating-days-and-hours-between-two-timestamps-almost-there-need-a-tweak-on-this/74761 "2023-02-06T16:28:28Z")

Hello! So I'm calculating time between two payloads to display in a nice readable format in a function node. "X Days and X Hours" It's not quite working as anticipated. The read out of Days is incorrect. It calculate… --- ## [Send data form NODE RED to ESPEASY](https://discourse.nodered.org/t/send-data-form-node-red-to-espeasy/73377)

**Author:** [@MHagreis](https://discourse.nodered.org/u/MHagreis)\ **Replies:** 9\ **Last updated:** [6 February 2023 16:00 UTC](https://discourse.nodered.org/t/send-data-form-node-red-to-espeasy/73377 "2023-02-06T16:00:36Z")

how to send data form node red to espeasy mqtt message in format or status can some one point me in the right direction espeasy to NODE RED is easy but NODE RED to espeasy i like to send data to espeasy to change a Ne… --- ## [How to to convert received telegram voice message in a format my vto can play](https://discourse.nodered.org/t/how-to-to-convert-received-telegram-voice-message-in-a-format-my-vto-can-play/74729)

**Author:** [@morpheus8888](https://discourse.nodered.org/u/morpheus8888)\ **Replies:** 2\ **Last updated:** [6 February 2023 15:11 UTC](https://discourse.nodered.org/t/how-to-to-convert-received-telegram-voice-message-in-a-format-my-vto-can-play/74729 "2023-02-06T15:11:06Z")

Hi all, I found this flow on the net and adapted it. The part that receives the text message works perfectly, while the part that receives the audio doesn't, I wanted the audio received, in .oga format, to be directly co… --- ## [Env.get() is declared to return a string, but in subflows, it doesn't](https://discourse.nodered.org/t/env-get-is-declared-to-return-a-string-but-in-subflows-it-doesnt/74757)

**Author:** [@Putzeimer](https://discourse.nodered.org/u/Putzeimer)\ **Replies:** 9\ **Last updated:** [6 February 2023 14:23 UTC](https://discourse.nodered.org/t/env-get-is-declared-to-return-a-string-but-in-subflows-it-doesnt/74757 "2023-02-06T14:23:55Z")

Hi, a subflow has the environment variable List set to type JSON. The value of this variable is set to: \["foo","bar"\] The variable is retrieved in a function node inside the subflow via env.get(). When I hover over th… --- ## [How to download attachments in node-red-node-email](https://discourse.nodered.org/t/how-to-download-attachments-in-node-red-node-email/74693)

**Author:** [@kowts](https://discourse.nodered.org/u/kowts)\ **Replies:** 5\ **Last updated:** [6 February 2023 12:14 UTC](https://discourse.nodered.org/t/how-to-download-attachments-in-node-red-node-email/74693 "2023-02-06T12:14:17Z")

Hello everybody, I start workig with Node-RED a few weeks ago and I create a flow that is using node-red-node-email to get certain unread emails from INBOX. Can someone help me on how download the attachments (excel) f… --- ## [/GET a file and then download it through the web browser?](https://discourse.nodered.org/t/get-a-file-and-then-download-it-through-the-web-browser/74746)

**Author:** [@network\_potato](https://discourse.nodered.org/u/network_potato)\ **Replies:** 6\ **Last updated:** [6 February 2023 11:50 UTC](https://discourse.nodered.org/t/get-a-file-and-then-download-it-through-the-web-browser/74746 "2023-02-06T11:50:15Z")

I have some HTML with a link: \Download PDF\ Where example.com is my Node-RED instance with a /get-pdf http endpoint: This flow then GETs the file through another http reques… --- ## [I can't convert text to lowercase](https://discourse.nodered.org/t/i-cant-convert-text-to-lowercase/74730)

**Author:** [@cymplecy](https://discourse.nodered.org/u/cymplecy)\ **Replies:** 21\ **Last updated:** [6 February 2023 10:58 UTC](https://discourse.nodered.org/t/i-cant-convert-text-to-lowercase/74730 "2023-02-06T10:58:03Z")

Well - the gremlins are really mucking me up today Tried using Blocky node to convert payload to lowercase - get error Tried using a contrib node - got error Tried using JSONata - got error Will someone please just … --- ## [Reading data in NODE-RED on Raspberry PI3 + RadioHead (LORA) + Dragino](https://discourse.nodered.org/t/reading-data-in-node-red-on-raspberry-pi3-radiohead-lora-dragino/74780)

**Author:** [@batigolle](https://discourse.nodered.org/u/batigolle)\ **Replies:** 0\ **Last updated:** [6 February 2023 10:30 UTC](https://discourse.nodered.org/t/reading-data-in-node-red-on-raspberry-pi3-radiohead-lora-dragino/74780 "2023-02-06T10:30:57Z")

Good morning everyone I successfully installed the RadioHead library on Raspberry PI3+ equipped with a Dragino board with RFM95 module, to create a LORA receiver. After compiling and creating the RF95\_server executable… --- ## [Tuya - Nodered - Curtain-Switch](https://discourse.nodered.org/t/tuya-nodered-curtain-switch/74741)

**Author:** [@einfach112](https://discourse.nodered.org/u/einfach112)\ **Replies:** 1\ **Last updated:** [6 February 2023 08:06 UTC](https://discourse.nodered.org/t/tuya-nodered-curtain-switch/74741 "2023-02-06T08:06:09Z")

Hello i have 5 Curatin Switches. There work fine with the smart life app. i want to controll the curtain with a the Nodered Dashboard-Button. But i dont know how i can do it? have anyone a flow for me that i can impo… --- ## [Storing the logs securely](https://discourse.nodered.org/t/storing-the-logs-securely/74770)

**Author:** [@ponguru](https://discourse.nodered.org/u/ponguru)\ **Replies:** 0\ **Last updated:** [6 February 2023 07:57 UTC](https://discourse.nodered.org/t/storing-the-logs-securely/74770 "2023-02-06T07:57:37Z")

We are preparing docker image with custom node. And the custome node writes log into log file (per second). Initially we thought of using docker volumes to store the logs into share folders (volume), but this approach h… --- ## [Node-red-ffmpeg - Simple file convertion example](https://discourse.nodered.org/t/node-red-ffmpeg-simple-file-convertion-example/74651)

**Author:** [@cdacruz](https://discourse.nodered.org/u/cdacruz)\ **Replies:** 2\ **Last updated:** [6 February 2023 07:55 UTC](https://discourse.nodered.org/t/node-red-ffmpeg-simple-file-convertion-example/74651 "2023-02-06T07:55:18Z")

Hi @kevinGodell , and everyone, I'm looking for a simple file conversion example with the node-red-ffmpeg. Something like "ffmpeg -i input.mp4 output.avi" well simpliest way to do that with the ffmpeg node. Can anyone… --- ## [String handling remove newline](https://discourse.nodered.org/t/string-handling-remove-newline/74620)

**Author:** [@jspv](https://discourse.nodered.org/u/jspv)\ **Replies:** 7\ **Last updated:** [5 February 2023 22:41 UTC](https://discourse.nodered.org/t/string-handling-remove-newline/74620 "2023-02-05T22:41:43Z")