create account

Starting my Adventure with the Splinterlands SPS Node Validator Software - Testing-Phase! by louis88

View this thread on: hive.blogpeakd.comecency.com
· @louis88 ·
$37.46
Starting my Adventure with the Splinterlands SPS Node Validator Software - Testing-Phase!
A few days ago I started to get more involved with the @splinterlands / @sps.dao node validator software, as some technical changes have been made to the software recently. The aim of the software is to validate all transactions for Splinterlands in connection with the $SPS and more. The software has been in development for some time but is now picking up speed as our Splinterlands DAO is investing in the development. Anyway, you probably already know this story. 

We currently have a testing / developer group of 7 people, in addition to @clayboyn as contact person for the DAO and coordinator, there are also team members and developers in the Discord group - and we are making progress. Yesterday was the day when I said - now the software is up to date, I'll rent an external virtual server at my expense and install the software. No sooner said than done - I rented a VPS from a German hoster and started with the basic configuration of the server. After installing updates and the firewall, I started with the software - it was surprisingly easy to install the software with the current Testnet data. You can find the software here: https://github.com/TheSPSDAO/SPS-Validator

![image.png](https://files.peakd.com/file/peakd-hive/louis88/23t72xDRLo32kPBq3jTGKReDp7rdd3swUhBN5g8sFsjEMK9UEtj3KD2hXCD2JGRk8kPpU.png)


Overnight, my node actually ran great and signed a block more or less every 3 seconds and wrote it to our Hive blockchain as custom_json. You can see this under my Splinterlands Node Validator account @louis.sps e.g. at https://hivehub.dev/@louis.sps
When I went to bed, I didn't think about anything else at first, because we had agreed that we would leave the servers running overnight in testnet mode so that the others could continue working and testing later. So I just let my node run - when I looked at the node this morning, it had crashed - I didn't think anything of it at first - at around 4 o'clock in the morning I noticed, according to the logs, that the connection had been interrupted. I reported this and during the course of the day I did some further research into why this had happened. And now comes the stupid part of this article.

After further research in the team, it was found that when retrieving the current PostgreSQL database, the one in my Docker container was no longer accessible - What had happened? Automatic queries and encryption from outside happened - Unfortunately, the Docker container was set in such a way that it had a well... what can I say - very weak password as the default password - and simply “postgres” as the password. Well, it was clear that it wouldn't take long for automatic scrappers from the network to scan the ports and then gain access. I ran a command according to the instructions to see what exactly is going on with the database:

`docker exec -e PGPASSWORD=postgres -it splinterlands-validator-pg-1 psql -U postgres -c "\l"`

Something like the following should actually happen:

![all fine](https://files.peakd.com/file/peakd-hive/louis88/EnyoS3HyvLcfEGMz8o3M69CnAjtsnBK9F4UcW8hHgCfLrcDrhavCBqozsRFUmBE7cfj.png)

but instead I saw the following and bang, I could already guess what had happened:

![image.png](https://files.peakd.com/file/peakd-hive/louis88/23swc1nw2MddLNrkiXwXVtzuuJn6rPmbsi1TvTavNScEYRVmHNzNytdJ4qdaPTyixiRiM.png)

You can see the line “readme_to_recover” and the line “validator” is missing. This means that the data in the database has been deleted / encrypted. Well, up to this point it's not a neck breaker, because on the one hand it's just a test system for development and help to get the software ready and on the other hand there are no important details in the database - and in the end no drama at all that everything runs in the Docker environment. You can read more details about this type of attack at https://medium.com/@border0/help-my-database-was-compromised-ec68ef15df65.

Well, I more or less wiped everything and started from scratch, blocking all incoming connections. I'll leave the box running again tonight and see if I wake up to a surprise tomorrow. But one lesson we should take away from this is the following - A) That we should not use standard passwords or connection encryption - regardless of whether we are working in a testnet / actively on it and the server / system is available to the outside world and B) that we include something like the Postgre data / user data in the .env - and that this is also in the documentation. Fortunately we noticed this today :)


![image.png](https://files.peakd.com/file/peakd-hive/louis88/23tvVyPZrpcpdxZjaaAKLcRdyqSwvD9te14rTTCwBwXC26brTRf7UjcSDU5oq3CUKGeTs.png)


### Lessons learned :)

![untitled.gif](https://media.tenor.com/8gE5vCt_XIoAAAAC/denzel-washington-relief.gif)


### FINALLY

Works ;)


![image.png](https://files.peakd.com/file/peakd-hive/louis88/Eo1uVMtCcVEqhgjiuTMgK1gVp1gJ9xPZsbg54U8nyojhAm3dhVTcUnUzxawgASD7L33.png)



--- 

<div class="pull-left"><div class="text-justify">

[![image.png](https://files.peakd.com/file/peakd-hive/louis88/23v4Zbq5TQyn3aFGQ7YcUyQJQCHhh556WQfTgmeR6EtVe1RWUURNc89oCX25ZFnUHAXww.png)](https://vote.hive.uno/@louis.witness)

##### Vote for my Hive Witness
U can vote for my Witness using Hive Keychain here:  https://vote.hive.uno/@louis.witness

</div></div>
<div class="pull-right"><div class="text-justify">


[![image.png](https://files.peakd.com/file/peakd-hive/louis88/24241zs2F4mEKWwVa9y2CkqHjUcR7Rh2EyRQEXZA5vfHdjEMnq8Ej8R4cWxT1jgAtXQHP.png)](https://primersion.com/he-witnesses)

##### Vote for my Hive Engine Witness

Vote for my Witness on Hive-Engine using Primersion Tool: https://primersion.com/he-witnesses <sup>Enter your Username and search for louis.witness</sup>
</div></div>
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 219 others
properties (23)
authorlouis88
permlinkstarting-my-adventure-with-the-splinterlands-sps-node-validator-software-testing-phase
categoryhive-13323
json_metadata{"app":"peakd/2024.12.6","format":"markdown","author":"louis88","tags":["splinterlands","development","validator","hive","community","blog","sps","dao","spt","trading"],"users":["splinterlands","sps.dao","clayboyn","louis.sps","border0","louis.witness"],"image":["https://files.peakd.com/file/peakd-hive/louis88/23swc1nw2MddLNrkiXwXVtzuuJn6rPmbsi1TvTavNScEYRVmHNzNytdJ4qdaPTyixiRiM.png","https://files.peakd.com/file/peakd-hive/louis88/23t72xDRLo32kPBq3jTGKReDp7rdd3swUhBN5g8sFsjEMK9UEtj3KD2hXCD2JGRk8kPpU.png","https://files.peakd.com/file/peakd-hive/louis88/EnyoS3HyvLcfEGMz8o3M69CnAjtsnBK9F4UcW8hHgCfLrcDrhavCBqozsRFUmBE7cfj.png","https://files.peakd.com/file/peakd-hive/louis88/23tvVyPZrpcpdxZjaaAKLcRdyqSwvD9te14rTTCwBwXC26brTRf7UjcSDU5oq3CUKGeTs.png","https://media.tenor.com/8gE5vCt_XIoAAAAC/denzel-washington-relief.gif","https://files.peakd.com/file/peakd-hive/louis88/Eo1uVMtCcVEqhgjiuTMgK1gVp1gJ9xPZsbg54U8nyojhAm3dhVTcUnUzxawgASD7L33.png","https://files.peakd.com/file/peakd-hive/louis88/23v4Zbq5TQyn3aFGQ7YcUyQJQCHhh556WQfTgmeR6EtVe1RWUURNc89oCX25ZFnUHAXww.png","https://files.peakd.com/file/peakd-hive/louis88/24241zs2F4mEKWwVa9y2CkqHjUcR7Rh2EyRQEXZA5vfHdjEMnq8Ej8R4cWxT1jgAtXQHP.png"]}
created2025-01-09 00:37:06
last_update2025-01-09 00:37:06
depth0
children14
last_payout2025-01-16 00:37:06
cashout_time1969-12-31 23:59:59
total_payout_value18.764 HBD
curator_payout_value18.700 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length5,731
author_reputation1,193,974,573,866,942
root_title"Starting my Adventure with the Splinterlands SPS Node Validator Software - Testing-Phase!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id139,838,023
net_rshares60,859,247,486,179
author_curate_reward""
vote details (283)
@bozz ·
Glad you learned that lesson now and not later on. I've been holding a node license for a while, so I am happy to hear this is finally progressing.
👍  
properties (23)
authorbozz
permlinkre-louis88-202518t195138459z
categoryhive-13323
json_metadata{"type":"comment","tags":["hive-13323","splinterlands","development","validator","hive","community","blog","sps","dao","spt","trading"],"app":"ecency/3.2.0-mobile","format":"markdown+html"}
created2025-01-09 00:51:36
last_update2025-01-09 00:51:36
depth1
children0
last_payout2025-01-16 00:51:36
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length147
author_reputation2,283,384,299,669,958
root_title"Starting my Adventure with the Splinterlands SPS Node Validator Software - Testing-Phase!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id139,838,291
net_rshares745,286,927
author_curate_reward""
vote details (1)
@danzocal ·
!PIZZA
properties (22)
authordanzocal
permlinkre-louis88-spve2u
categoryhive-13323
json_metadata{"tags":["hive-13323"],"app":"peakd/2024.12.6","image":[],"users":[]}
created2025-01-10 11:18:30
last_update2025-01-10 11:18:30
depth1
children0
last_payout2025-01-17 11:18:30
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length6
author_reputation12,432,803,008,396
root_title"Starting my Adventure with the Splinterlands SPS Node Validator Software - Testing-Phase!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id139,876,039
net_rshares0
@pizzabot ·
<center>PIZZA!


$PIZZA slices delivered:
@danzocal<sub>(5/10)</sub> tipped @louis88 


</center>
properties (22)
authorpizzabot
permlinkre-starting-my-adventure-with-the-splinterlands-sps-node-validator-software-testing-phase-20250110t111942z
categoryhive-13323
json_metadata"{"app": "pizzabot"}"
created2025-01-10 11:19:42
last_update2025-01-10 11:19:42
depth1
children0
last_payout2025-01-17 11:19:42
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length97
author_reputation7,607,470,364,234
root_title"Starting my Adventure with the Splinterlands SPS Node Validator Software - Testing-Phase!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id139,876,069
net_rshares0
@sc000 · (edited)
It's a good lesson to learn and luckily you learned it on testnet :)

I also plan to set up a node! Looking forward to it.

Which specs does to machine have that you set up? How much is it per month?
properties (22)
authorsc000
permlinkre-louis88-sptifi
categoryhive-13323
json_metadata{"tags":"hive-13323"}
created2025-01-09 10:57:18
last_update2025-01-09 10:58:27
depth1
children8
last_payout2025-01-16 10:57:18
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length199
author_reputation1,490,851,416,253
root_title"Starting my Adventure with the Splinterlands SPS Node Validator Software - Testing-Phase!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id139,848,651
net_rshares0
@louis88 ·
The Server itself is under 20 Bucks a month - and have the following specs: 4vCPU - 8 GB RAM - 160 GB Disk lokal - running Ubuntu 24.04 and costs me roughly 2 cents an hour.
👍  ,
properties (23)
authorlouis88
permlinkre-sc000-sptj1t
categoryhive-13323
json_metadata{"tags":["hive-13323"],"app":"peakd/2024.12.6"}
created2025-01-09 11:10:42
last_update2025-01-09 11:10:42
depth2
children7
last_payout2025-01-16 11:10:42
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length174
author_reputation1,193,974,573,866,942
root_title"Starting my Adventure with the Splinterlands SPS Node Validator Software - Testing-Phase!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id139,848,865
net_rshares30,959,552,833
author_curate_reward""
vote details (2)
@sc000 ·
Thanks!
properties (22)
authorsc000
permlinkre-louis88-sptlze
categoryhive-13323
json_metadata{"tags":["hive-13323"],"app":"peakd/2024.12.6","image":[],"users":[]}
created2025-01-09 12:14:03
last_update2025-01-09 12:14:03
depth3
children4
last_payout2025-01-16 12:14:03
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length7
author_reputation1,490,851,416,253
root_title"Starting my Adventure with the Splinterlands SPS Node Validator Software - Testing-Phase!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id139,849,935
net_rshares0
@stokjockey ·
@louis88
The Ladies of Splinterlands will be glad to know this info too...........

!LADY
properties (22)
authorstokjockey
permlinkspxdx5
categoryhive-13323
json_metadata{"users":["louis88"],"app":"hiveblog/0.1"}
created2025-01-11 13:10:45
last_update2025-01-11 13:10:45
depth3
children1
last_payout2025-01-18 13:10:45
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length89
author_reputation128,146,751,172,822
root_title"Starting my Adventure with the Splinterlands SPS Node Validator Software - Testing-Phase!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id139,909,027
net_rshares0
@splinterboost ·
 <center> This post has been supported by @Splinterboost with a 12% upvote! Delagate HP to Splinterboost to Earn Daily HIVE rewards for supporting the @Splinterlands community!</center> 

 <center> [ Delegate HP ](https://peakd.com/@splinterboost)  | [Join Discord](https://discord.gg/RK4ZHKmgcX) </center>
properties (22)
authorsplinterboost
permlinkstarting-my-adventure-with-the-splinterlands-sps-node-validator-software-testing-phase
categoryhive-13323
json_metadata{"app":"splinterboost/0.1"}
created2025-01-09 00:37:15
last_update2025-01-09 00:37:15
depth1
children0
last_payout2025-01-16 00:37:15
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length306
author_reputation13,837,443,986,980
root_title"Starting my Adventure with the Splinterlands SPS Node Validator Software - Testing-Phase!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id139,838,025
net_rshares0
@theiam ·
# ♦️ You got 0.01 [FELT](https://peakd.com/hive/@theiam/introducing-felt-sentiment-token-spbhj9) for sharing high vibes on Hive. 

[📋♦️ FELT Info](https://peakd.com/hive/@theiam/introducing-felt-sentiment-token-spbhj9) 
properties (22)
authortheiam
permlinkre-starting-my-adventure-with-the-splinterlands-sps-node-validator-software-testing-phase-20250413t201755z
categoryhive-13323
json_metadata"{"app": "beem/0.24.19"}"
created2025-04-13 20:17:57
last_update2025-04-13 20:17:57
depth1
children0
last_payout2025-04-20 20:17:57
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length219
author_reputation-43,402,943,638
root_title"Starting my Adventure with the Splinterlands SPS Node Validator Software - Testing-Phase!"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id142,079,405
net_rshares0