# Store msg alone without needing to have excel ,SQLite table just by topic to payload it again to node red when needed

**URL:** <https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398>\
**Category:** General\
**Created:** [5 August 2021 21:13 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398 "2021-08-05T21:13:39Z")\
**Posts on this page:** 20\
**Page:** 2

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [6 August 2021 11:08 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398/21 "2021-08-06T11:08:36Z")

</div>

> [@zenofmud](#):
>
> like you are running Node-RED on a windows machine

Paul .. that was my NR startup log as an example to show how to find the flow file being used  
(because he asked the question regarding backing up the flow file)

i think Badr is on ubuntu

@badr_al_moragab if indeed your NR is running as a service.  
show as what you get in the terminal when you run

`node-red-restart`

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [6 August 2021 12:42 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398/22 "2021-08-06T12:42:36Z")

</div>

Whoops I guess I need that second cup of coffee~  
Happy forum aniversity

---

<div class="post-metadata">

**Author:** ![badr\_al\_moragab](https://avatars.discourse-cdn.com/v4/letter/b/9fc348/32.png) [@badr\_al\_moragab](https://discourse.nodered.org/u/badr_al_moragab)\
**Post date:** [6 August 2021 20:18 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398/23 "2021-08-06T20:18:12Z")

</div>

@UnborN @zenofmud Hi. sorry for late reply. for the storing data that one was just for my windows node red. this second problem is on my ubuntu 18.04 server.  
I tried as you say to run restart-node-red command but all still same the site can not refresh.  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/f/5f4586e26ceeb6572d8f74b7593825be166ed0f3.png)

then I tried to run status command

```auto
sudo systemctl status node-red.service

```

it shows this

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/7/67650bd3887412370009e98368343c0116dfc02d.png)

```auto
Active: failed (Result: exit-code) since Sat 2021-08-07 00:19:56 +04; 17s ago

```

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [6 August 2021 20:33 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398/24 "2021-08-06T20:33:26Z")

</div>

> [@badr\_al\_moragab](#):
>
> I tried as you say to run restart-node-red command

Actually i said

> [@UnborN](#):
>
> show as what you get in the terminal when you run
> 
> `node-red-restart`

---

<div class="post-metadata">

**Author:** ![badr\_al\_moragab](https://avatars.discourse-cdn.com/v4/letter/b/9fc348/32.png) [@badr\_al\_moragab](https://discourse.nodered.org/u/badr_al_moragab)\
**Post date:** [6 August 2021 20:41 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398/26 "2021-08-06T20:41:13Z")

</div>

> [@UnborN](#):
>
> Actually i said

@UnborN it shows nothing as first picture above. when I tried to run node-red status it shows that the command befor was trying to run the node red but it failed as shown on the second picture shown above.

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [6 August 2021 21:13 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398/27 "2021-08-06T21:13:44Z")

</div>

I dont know much about unix .. but if you have installed node-red through the [official installation script](https://nodered.org/docs/getting-started/raspberrypi)

then the service would have been called `nodered.service` and not `node-red.service`

what is the result in the terminal when you run  
`node-red`

---

<div class="post-metadata">

**Author:** ![badr\_al\_moragab](https://avatars.discourse-cdn.com/v4/letter/b/9fc348/32.png) [@badr\_al\_moragab](https://discourse.nodered.org/u/badr_al_moragab)\
**Post date:** [6 August 2021 21:21 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398/28 "2021-08-06T21:21:54Z")

</div>

> [@UnborN](#):
>
> what is the result in the terminal when you run

This is the result that I got

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/2/021b7ac200bd1146b1df410d0c4cd33e6f72c06a.png)

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [6 August 2021 21:21 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398/29 "2021-08-06T21:21:56Z")

</div>

Please, never again mix multiple issues in one thread, it can waste the time of volunteers trying to help you.

---

<div class="post-metadata">

**Author:** ![badr\_al\_moragab](https://avatars.discourse-cdn.com/v4/letter/b/9fc348/32.png) [@badr\_al\_moragab](https://discourse.nodered.org/u/badr_al_moragab)\
**Post date:** [6 August 2021 21:25 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398/30 "2021-08-06T21:25:02Z")

</div>

> [@zenofmud](#):
>
> Please, never again mix multiple issues in one thread, it can waste the time of volunteers trying to help you.

@zenofmud sorry for that I thought it will not take a time. so do I need to add it as topic whether there was a topic similar to it but there is no result goes fine with me.

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [6 August 2021 21:38 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398/31 "2021-08-06T21:38:04Z")

</div>

Seems like your Node-red installation is messed up.  
Try to run the bash script ..

`bash <(curl -sL https://raw.githubusercontent.com/node-red/linux-installers/master/deb/update-nodejs-and-nodered)`

the script will do the necessary checks and re-install node-red  
if that doesnt work then open a new topic for this specific problem

---

<div class="post-metadata">

**Author:** ![badr\_al\_moragab](https://avatars.discourse-cdn.com/v4/letter/b/9fc348/32.png) [@badr\_al\_moragab](https://discourse.nodered.org/u/badr_al_moragab)\
**Post date:** [6 August 2021 21:53 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398/32 "2021-08-06T21:53:23Z")

</div>

> [@UnborN](#):
>
> the script will do the necessary checks and re-install node-red

I tried to run the command that you shared and this is the result shown  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/e/ae3c307fe6ff6ff66ed6c6e59b7d70a8f5f48667.png)

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [6 August 2021 22:00 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398/33 "2021-08-06T22:00:19Z")

</div>

ok .. the error now is a little bit more obvious .. you are running a very old version of node.js v8

run the bash script again and add `--node14` at the end to force install the newer version of nodejs

---

<div class="post-metadata">

**Author:** ![badr\_al\_moragab](https://avatars.discourse-cdn.com/v4/letter/b/9fc348/32.png) [@badr\_al\_moragab](https://discourse.nodered.org/u/badr_al_moragab)\
**Post date:** [6 August 2021 22:02 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398/34 "2021-08-06T22:02:48Z")

</div>

> [@UnborN](#):
>
> run the bash script again and add `--node14` at the end to force install the newer version of nodejs

did you mean to run it like this

```auto
bash <(curl -sL https://raw.githubusercontent.com/node-red/linux-installers/master/deb/update-nodejs-and-nodered--node14)

```

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [6 August 2021 22:07 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398/35 "2021-08-06T22:07:09Z")

</div>

nope .. the option `--node14` must be outside the bracket and with a space

```auto
bash <(curl -sL https://raw.githubusercontent.com/node-red/linux-installers/master/deb/update-nodejs-and-nodered) --node14

```

---

<div class="post-metadata">

**Author:** ![badr\_al\_moragab](https://avatars.discourse-cdn.com/v4/letter/b/9fc348/32.png) [@badr\_al\_moragab](https://discourse.nodered.org/u/badr_al_moragab)\
**Post date:** [6 August 2021 23:20 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398/36 "2021-08-06T23:20:59Z")

</div>

> [@UnborN](#):
>
> nope .. the option `--node14` must be outside the bracket and with a space
> 
> ```auto
> 
> ```

Thank you so much it works for me. it's a nice idea to upgrade node.js.  
by this way do I will lose the flows on my node red?!

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [6 August 2021 23:34 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398/37 "2021-08-06T23:34:42Z")

</div>

the script doesn't affect your flows .. but its always good practice to make a backup before each major upgrade. I usually backup the whole .node-red folder.

---

<div class="post-metadata">

**Author:** ![badr\_al\_moragab](https://avatars.discourse-cdn.com/v4/letter/b/9fc348/32.png) [@badr\_al\_moragab](https://discourse.nodered.org/u/badr_al_moragab)\
**Post date:** [6 August 2021 23:38 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398/38 "2021-08-06T23:38:39Z")

</div>

> [@UnborN](#):
>
> the script doesn't affect your flows .. but its always good practice to make a backup before each major upgrade.

yah that's right. but by this command it will stop using node-red.service and run node-red as global server. is there a way to use node-red.service.

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [6 August 2021 23:46 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398/39 "2021-08-06T23:46:20Z")

</div>

it will install it as a `nodered.service` also  
read the [documentation link](https://nodered.org/docs/getting-started/raspberrypi) i sent you and its described in detail there

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/5/454fc7d2efd2d02c5cbcacadbb004092757e3d98.png)

---

<div class="post-metadata">

**Author:** ![badr\_al\_moragab](https://avatars.discourse-cdn.com/v4/letter/b/9fc348/32.png) [@badr\_al\_moragab](https://discourse.nodered.org/u/badr_al_moragab)\
**Post date:** [7 August 2021 00:02 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398/40 "2021-08-07T00:02:32Z")

</div>

> [@UnborN](#):
>
> it will install it as a `nodered.service` also

but this way is a little bit complecated because I have many commands that I was using them but for now I can not use it like

```auto
node-red-admin hash-pw

```

also If I want to set user name and password for my node red or multiple admin also the storing files there is nothing inside setting.js file as shown in picture bellow.

```auto
sudo vi ~/.node-red/settings.js

```

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/1/d14f8037b37eda6f2158e4105a1c885f06f35455.png)

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/1/11f5496a78de9fdbab5f37c8238eeb5ff3ed39fd.png)

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [7 August 2021 00:45 UTC](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398/41 "2021-08-07T00:45:21Z")

</div>

The command has changed in the new versions to `node-red admin hash-pw`

#### [Generating the password hash](https://nodered.org/docs/user-guide/runtime/securing-node-red#generating-the-password-hash)

the developers of Node-red spent countless hours writing the detailed articles in the User Guide  
even documenting changes from older versions.

Most of the information is already there .. You just need to do a little research 🧐

[Previous page](https://discourse.nodered.org/t/store-msg-alone-without-needing-to-have-excel-sqlite-table-just-by-topic-to-payload-it-again-to-node-red-when-needed/49398.md?page=1)