Find all packages available
rmadison sudo
Install a specific version
sudo apt install sudo=1.8.31-1ubuntu1.2
2022/02/24
Ubuntu installed a fixed version of package
2021/12/28
NET::ERR_CERT_INVALID – Dockerfile docker-unifi-controller
There’s a secret passphrase built into the error page. Just make sure the page is selected (click anywhere on the screen), and just type thisisunsafe.
2021/12/23
Plejd2mqtt
git clone https://github.com/thomasloven/plejd2mqtt.git
sudo docker build -t plejd2mqtt .
docker-compose.yamlversion: "3"
services:
plejd2mqtt:
image: plejd2mqtt:latest
restart: always
volumes:
- /var/run/dbus:/var/run/dbus
environment:
PLEJD_SITE: xxxxx
PLEJD_USERNAME: xxxx
PLEJD_PASSWORD: xxxx
MQTT_BROKER: mqtt://mqtt
2021/11/10
Change PHP version
sudo update-alternatives --config php
There are 4 choices for the alternative php (providing /usr/bin/php).
Selection Path Priority Status
------------------------------------------------------------
* 0 /usr/bin/php8.0 80 auto mode
1 /usr/bin/php7.2 72 manual mode
2 /usr/bin/php7.3 73 manual mode
3 /usr/bin/php7.4 74 manual mode
4 /usr/bin/php8.0 80 manual mode
Press <enter> to keep the current choice[*], or type selection number:
2021/11/09
Move files in directory based on year
for i in `ls -lrt | grep “2015”| awk ‘{print $9}’ `; do mv -f $i* /new/Archives.2015/; done
2021/10/27
Update MYSQL database in Docker
docker run --rm -ti -v <full patch to db-files>:/var/lib/mysql mysql:5.7 bash
You’ll see a command prompt inside the MySQL container. Run the following command:
mysqld_safe --skip-grant-tables &
MySQL will start up. Wait 10 seconds or so for that to happen, and then run the following. Note you won’t see a command prompt, so just type away and it will work!
mysql_upgrade2021/09/13
NextCloud maintenance:mode
sudo docker exec -u www-data -it nextcloud /bin/bash or
sudo docker exec -u www-data -it nextcloud /bin/bash php /var/www/nextcloud/occ maintenance:mode –off
sudo docker exec –user www-data -it nextcloud /bin/bash
php occ maintenance:repair
2021/07/26
Cpanel Eximstats corrupt database
Error:
DBD::SQLite::st execute failed: database disk image is malformed at /usr/local/cpanel/Cpanel/EximStats/SpamCheck.pm line 388.
Solution:
mv /var/cpanel/eximstats_db.sqlite3 /var/cpanel/eximstats_db.sqlite.old
/scripts/restartsrv_tailwatchd
/scripts/import_exim_data /var/log/exim_mainlog
2021/06/23
Longhorn MountVolume.SetUp failed for volume “mysql-5721” : rpc error: code = Internal desc = mount failed: exit status 32 Mounting command: mount Mounting arguments: -t ext4 -o defaults /dev/longhorn/mysql-5721 /var/lib/kubelet/pods/9db5f7a0-d6dd-426d-89b1-bb7abf6a0ac4/volumes/kubernetes.io~csi/mysql-5721/mount Output: mount: /var/lib/kubelet/pods/9db5f7a0-d6dd-426d-89b1-bb7abf6a0ac4/volumes/kubernetes.io~csi/mysql-5721/mount: /dev/longhorn/mysql-5721 already mounted or mount point busy.
When there is problem to mount a Longhorn device this bug can be a good start: https://github.com/longhorn/longhorn/issues/1210
Solution for me was add
blacklist {
devnode "^sd[a-z0-9]+"
}
to /etc/multipath.conf and restart
service multipathd restart
2021/03/15
Add SSL-cert to Java keystore on Ubuntu
Download cert in Chrome on MAC
- Open a new TextEdit document.
- In TextEdit, click Format | Make Plain Text.
- Arrange windows so that the TextEdit window and the Chrome window are both visible.
- In Chrome, click the icon to the left of the URL in the address bar.
- In the dropdown list, click Certificate.
- Hold down Option and drag from the large certificate icon to the body of the TextEdit document. Note: If you did not follow the steps above in exactly the order stated, you may need to first single-click within the Chrome window so that TextEdit doesn’t become hidden when you Option-click.
- Save the TextEdit document with a .pem extension.
Import cert to keystore
sudo keytool -import -alias <hostname> -keystore /usr/lib/jvm/java-1.8.0-openjdk-amd64/jre/lib/security/cacerts -file public.crt
Default password for Java keystore is “changeit”.