R3 certificate expired error (seen on older mac connecting to Debian 10 server)

/etc/ca-certificates.conf
->
Set 2 certs for removal by adding “!” in front of their lines:
!mozilla/DST_Root_CA_X3.crt
!mozilla/ISRG_Root_X1.crt

(This can be done with GUI: dpkg-reconfigure ca-certificates)

Then run certificates update:
update-ca-certificates

Posted in Uncategorized | Leave a comment

Grant all privileges including granting option, to a mysql user

GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost' WITH GRANT OPTION;

or

GRANT ALL PRIVILEGES ON * . * TO 'newuser' WITH GRANT OPTION;

then

FLUSH PRIVILEGES;

Posted in Uncategorized | Leave a comment

Quickly add GPG public key for Debian repository

For example to add the gpg key for the Jitsy repository:

wget -qO - https://download.jitsi.org/jitsi-key.gpg.key | apt-key add -

Posted in Uncategorized | Leave a comment

Unban IP banned with Fail2ban

For example, unban the IP xxx.xxx.xxx.xxx that has been banned from sshd:
fail2ban-client set sshd unbanip xxx.xxx.xxx.xxx

You can list the banned IP (basically firewall rules) with:
iptables -L
-> Look for the chain names, for example “Chain f2b-sshd” is holding list of banned IPs from sshd. (Chain f2b-postfix-sasl, Chain f2b-dovecot, Chain f2b-pure-ftpd…)

Posted in Uncategorized | Leave a comment

Kill a bash script running in the background

kill ps -aux | grep sqs2.sh | grep -v grep | awk '{ print $2 }' && killall inotifywait

Line above, after kill is `, wrapping till }`

Posted in Uncategorized | Leave a comment

Raspberry Pi / NetworkManager – No DNS resolution issue

edit following line in /etc/nsswitch.conf:

hosts: files mdns4_minimal [NOTFOUND=return] resolve [!UNAVAIL=return] dns
->
hosts: files dns mdns4_minimal [NOTFOUND=return] resolve [!UNAVAIL=return]

Posted in Uncategorized | Leave a comment

Cryptpad – CSP error for “Sheets”

This is coming from security settings in nginx (to modify at own risk…)

Have

set $scriptSrc  "'self' 'unsafe-eval' 'unsafe-inline' resource: ${main_domain}";
Posted in Uncategorized | Leave a comment

Thunderbird wraping lines

Thunderbird adds linebreaks by default at 72 characters per line.
These are not visible from Thunderbird, but someone looking at your emails from gmail mobile, will see the linebreaks. It looks messy and makes it painful to read.

To remove this, go to Edit>Preferences or Tools>Options> and at end of page “Config Editor”.

Search for variable “mailnews.wraplength” and set the value to “0”.
(As reference, default is 72)

Posted in Uncategorized | Leave a comment

Linux terminal / Prevent screen flashing when using tab

edit /etc/screenrc :

vbell on
vbell_msg ''
termcapinfo *  vb=:

Posted in Uncategorized | Leave a comment

Linux networking – Setup with command line

nmtui
Posted in Uncategorized | Leave a comment