I have a Raspberry Pi Model 3B V1.2. You can know your model by typing in prompt :

In January 2022, the microSD card got corrupted, and Pi was not reliable anymore, after about 3 years of operation.
I bought a new microSD card but as I didn't backup, I had to reinstall all over again. Not a nice feeling.

As of 23/03/2022 I am preparing to configure the Pi to boot on an SSD.

I bought two things so far:

• Kingston A400 480GB ~30 EUR
• SATA to USB3 cable ~5 EUR

As of 28/12/2022 I red a lot, and nothing worked, until I found something that work pretty nicely.

What I have finally setup

1. Raspberry Pi is operationnal. Currently running based on the SD Card (FYI 32GB) inserted in the SD Card slot of the Pi.
    
2. Using SD Card Copier already available in Raspian, I made a clone from the SD Card to the SSD:
   
    
3. On your SSD, you should then have 2 partitions, one for boot and one for the OS.
   I formatted another SD Card (FYI 2GB) and I formatted it in FAT32.
   Then, I have made a copy of all the files that were in the boot partition of the SSD to this other 2GB SD Card.
    
4. I properly switched off the Raspberry Pi.
   I removed the SD Card 32GB from the SD slot that was previously running the system.
   I inserted the SD Card 2GB which contains all the files from the boot partition of the SSD.
   I connected another USB device: a Toshiba HDD 2 TB.
   Everything is powered with the Raspberry Pi 3 Power Supply - 2.5A (Micro USB) by CanaKit. No any USB hub to power the SSD or HDD.

I am a bit concerned about the power. So I will monitor this in the coming days using two commands:

See here for get_throttled signification.

Why KeePass?

Today, you have to remember many passwords. You need a password for a lot of websites, your e-mail account, your webserver, network logins, etc. The list is endless. Also, you should use a different password for each account, because if you would use only one password everywhere and someone gets this password, you would have a problem: the thief would have access to all of your accounts.

KeePass is a free open source password manager, which helps you to manage your passwords in a secure way. You can store all your passwords in one database, which is locked with a master key. So you only have to remember one single master key to unlock the whole database. Database files are encrypted using the best and most secure encryption algorithms currently known (AES-256, ChaCha20 and Twofish). For more information, see the features page.

Is it really free?

Yes, KeePass is really free, and more than that: it is open source (OSI certified). You can have a look at its full source code and check whether the security features are implemented correctly.

How to

How to securely store and keep your passwords in sync on your computers and mobile devices with KeePass Password Manager
How to securely store and keep your passwords in sync on your computers and mobile devices with KeePass Password Manager (page 2)

Windows

Download KeePass and keepass-sftp-sync plugin to be able to synchronise database file through sftp protocol.

Plugin Installation and Uninstallation (source)

If there are no explicit instructions how to install the plugin, follow these steps:

1. Download the plugin from the page above and unpack the ZIP file to a new folder.
2. In KeePass, click 'Tools' → 'Plugins' → button 'Open Folder'; KeePass now opens a folder called 'Plugins'.
3. Move the new folder (containing the plugin files) into the 'Plugins' folder. Restart KeePass in order to load the new plugin. To uninstall a plugin, delete the plugin files.

Starting Keepass and load Database using SFTP protocol

File > Open > Open URL...

URL example:

Android

Install Keepass2Android using Google Play Store.

Linux

Not needed for me so far so I don't know.

Information from Telegram itself : https://core.telegram.org/bots

• Create a new bot : https://core.telegram.org/bots#6-botfather
• Before adding a bot into a group conversation:

• Bot in python3 : python-telegram-bot

I have tried to use Wireguard following two guides :

1. From this forum thread, without succes: Guide: Install Wireguard On Raspberry latest releases
2. From this blog article, without succes as well: Installing and Configuring WireGuard on Raspberry Pi OS (August 2020)

This can be used as well to generate wireguard peers configurations + QR codes: Wireguard Tools

=> no successfull handshake between server (raspberry) and peers (Android and Windows 10).

Configuration

Server:

Peer 1:

Peer 2:

Troubleshooting

12/10/2020

UDP correctly forwarded

I verified UDP port was correctly forwarded by my ISP modem/router, following Test whether UDP port is open: simple UDP server and client

Server side:

Client side:

Checking if packets arrive to server

Listening on specific interface and on precise port of the server:

Here I tried two times to connect a peer to the server while pinging Wireguard server IP (192.168.99.1) from peer.

17/10/2020

Recording packets using tcpdump on both client and server sides

CLIENT: in a country potentially blocking VPN stuff
SERVER: in France, probably not blocking anything

I have generated another peer configuration. This time it is not a windows, not an android, but an openwrt router using same .
I have fixed the port in use for the wireguard client on openwrt in order to listen WAN interface on 51820.

What is observed on CLIENT openwrt side:

• Only first two captured packets were seen by SERVER side.
• These two captured packets are enough to declare successful handshake on CLIENT side.

What is observed on SERVER raspberry pi side:

• Only first two packets captured by CLIENT are seen as well on SERVER side.
• Handshake is not declared successful on SERVER side.
• Why SERVER is not seeing following packets ??? If I restart CLIENT, SERVER does not see packets for new handshake unless port used by CLIENT changes.
• Why SERVER is not seeing anything from this CLIENT packet: " 14:37:46.038821 IP 192.168.1.102.51820 > raspberry.abo.wanadoo.fr.58280: UDP, length 32 "

Trying to connect from local country

CLIENT: in a country potentially blocking VPN stuff Computer using Windows in France, probably not blocking anything
SERVER: in France, probably not blocking anything

=> It worked ! I conclude that wireguard is blocked in the country where the client is.

Interesting to read about how easy it is to block wireguard: Let's talk about obfuscation again

Shell script that will check if there is connectivity to a defined website every 60 seconds and switch ON/OFF the led :

• /usr/bin/WANLED :

Schell script to autostart the above script :

• /etc/init.d/WANLED :

Now let's make these script executable and started at startup:

Now the orange LED should be ON when there is no connectivity to Google.

FYI OpenWRT in use was : OpenWrt 19.07.2, r10947-65030d81f3

Source: LED, Start script at startup, LED on when Internet is available

Raspian buster

Windows 10

Download Chrome. Install it.

https://chromedriver.chromium.org/getting-started

https://stackoverflow.com/questions/33150351/how-do-i-install-chromedriver-on-windows-10-and-run-selenium-tests-with-chrome

Python3

It happens that NordVPN openvpn configuration files don't work anymore after a while.

I made a bash script to update the configuration easy and fast:

Then simply execute the script:

If your airsonic is stucked for some reasons such as Liquibase Update Failed and Waiting for changelog lock...

1. Stop Airsonic for sure :
   sudo service airsonic stop
2. Read logs /var/airsonic/airsonic.log :
   nano /var/airsonic/airsonic.log
3. Backup your database folder /var/airsonic/db :
   sudo cp /var/airsonic/db /var/airsonic/db_backup
4. Edit /var/airsonic/db/airsonic.script :
   sudo nano /var/airsonic/db/airsonic.script
   • remove all lines where you can find DATABASECHANGELOGLOCK by example :
     • CREATE MEMORY TABLE DATABASECHANGELOGLOCK.....
     • INSERT INTO DATABASECHANGELOGLOCK VALUES(1,TRUE,'2018-11-18 16:39:56.266000000','192.168.254.200 (192.168.254.200)')
5. Save file.
6. Start Airsonic :
   sudo service airsonic start
7. Check Airsonic status :
   sudo service airsonic status

If you wanna reset your Airsonic music server, just delete the database /var/airsonic/db ...

Source 1, 2, 3.

How to update a standalone Airsonic

• Stop the current running Airsonic:

• Go to the Airsonic folder, backup the old airsonic.war file, and download the new one. Check what is the last version: https://airsonic.github.io/download/

• Put good rights to all folder (new airsonic.war is not owned by airsonic), and verify it has been applied:

• Start updated Airsonic and restart proxy server:

Nothing too hard, basically, you need to replace the airsonic.war by the updated one.

PluXml 5.6 / CKEditor 4.7.3 modification to get handy code <div>

I modified the file /plugins/ckeditor/ckeditor/styles.js to have a much more easier way to put code in my memo.

Before:

After:

Modification to get better visual when using <kbd>

In PluxXML Administration > Parameters > Themes > Edit Theme files > /css/plucss.css I have set this for <kbd> HTML tag.

• Before : CTRL + ALT + DEL
• After : CTRL + ALT + DEL

CSS source