Author Archives: Vitalijus Ryzakovas

install keepalive 2 ubuntu

add-apt-repository ppa:hnakamur/keepalived upstream repository: https://github.com/acassen/keepalived deb source repository: https://github.com/hnakamur/keepalived-deb More info: https://launchpad.net/~hnakamur/+archive/ubuntu/keepalived Press [ENTER] to continue or ctrl-c to cancel adding it

gpg: keyring `/tmp/tmprfmnb5nq/secring.gpg' created gpg: keyring `/tmp/tmprfmnb5nq/pubring.gpg' created gpg: requesting key 1017341E from hkp server keyserver.ubuntu.com gpg: /tmp/tmprfmnb5nq/trustdb.gpg: trustdb created gpg: key 1017341E: public key "Launchpad PPA for Hiroaki Nakamura" imported gpg: Total number processed: 1 gpg: imported: 1 (RSA: 1) OK

server certificate verification failed. CAfile: /etc/ssl/certs/ca-certificates.crt CRLfile: none

Leave a reply

mv -v /usr/share/ca-certificates/mozilla/DST_Root_CA_X3.crt /tmp/ '/usr/share/ca-certificates/mozilla/DST_Root_CA_X3.crt' -> '/tmp/DST_Root_CA_X3.crt'


update-ca-certificates

Updating certificates in /etc/ssl/certs...

W: /usr/share/ca-certificates/mozilla/DST_Root_CA_X3.crt not found, but listed in /etc/ca-certificates.conf.

0 added, 0 removed; done.

Running hooks in /etc/ca-certificates/update.d...

done.

apt update

sed leave only 1000 last lines

Leave a reply

instead sed use tail: tail -n 1000 file.log | sponge file.log

ubuntu iptables remove all rules

Leave a reply

iptables allow all:

iptables -P INPUT ACCEPT && iptables -P FORWARD ACCEPT && iptables -P OUTPUT ACCEPT && iptables -t nat -F && iptables -t mangle -F && iptables -F && iptables -X && iptables-save > /etc/iptables/rules.v4

mysql extract table from dump

Leave a reply

sed -n -e '/DROP TABLE.*`my_table`/,/UNLOCK TABLES/p' mydump.sql > table.sql


make sure table is correct:

egrep -h "DROP TABLE|CREATE TABLE" table.sql

DROP TABLE IF EXISTS `my_table`; CREATE TABLE `my_table` (

bash pass array as command line argument

Leave a reply

domains=(domain1.com domain2.com domain3.com) printf ' -d %s' ${domains[*]} | xargs certbot --apache

it runs such command: certbot --apache -d domain1.com -d domain2.com -d domain3.com

bash grep after match line to array

Leave a reply

alias_Domains=(`grep -m1 -oP '(?<=ServerAlias ).*' /etc/apache2/sites-enabled/website.conf`)

postfix status=deferred (TLS is required, but was not offered by host

Leave a reply

vim /etc/postfix/master.cf


amavis unix - - - - 2 smtp

  -o smtp_tls_security_level=none

127.0.0.1:10025 inet n - - - - smtpd -o smtp_tls_security_level=none

grep in the matched file

Leave a reply

grep -ril word1 /some/path/to/search | xargs grep -i word2

mysql kill select longer than

Leave a reply

pt-kill --kill-busy-commands=Query --run-time 1m --interval 1 --each-busy-time 30s --print --match-info "(select|SELECT)" --group-by=fingerprint

System clock synchronized: no

Leave a reply

timedatectl | grep sync
System clock synchronized: no

sed -i 's/NTP\=/NTP=ntp.ubuntu.com/g' /etc/systemd/timesyncd.conf ; systemctl daemon-reload ; timedatectl set-ntp off ; timedatectl set-ntp on ; timedatectl | grep sync System clock synchronized: yes

Unbound

Leave a reply

Unbound is a free, open-source, recursive, and validating DNS caching server. It uses DNS-over-TLS and DNS-over-HTTPS to encrypt connections between clients. Compared to Bind9, Unbound is lightweight and extremely fast.

ubuntu install keydb

Leave a reply

echo "deb https://download.keydb.dev/open-source-dist $(lsb_release -sc) main" | sudo tee /etc/apt/sources.list.d/keydb.list wget -O /etc/apt/trusted.gpg.d/keydb.gpg https://download.keydb.dev/open-source-dist/keyring.gpg apt update apt install keydb

EOF ssh

Leave a reply

paste from input to remote server
ssh server_ip "cat - >> /tmp/some_file.txt" << "EOF" 
> asasas
> asasas
> asasas
> EOF

wireguard remove key

Leave a reply

wg set wg0 peer public_key remove
wg-quick save wg0; wg-quick down wg0; wg-quick up wg0;

Server 24/7

I am Vitalijus Ryzakovas. This is my LINUX/UNIX blog.

Author Archives: Vitalijus Ryzakovas

install keepalive 2 ubuntu

server certificate verification failed. CAfile: /etc/ssl/certs/ca-certificates.crt CRLfile: none

sed leave only 1000 last lines

ubuntu iptables remove all rules

mysql extract table from dump

bash pass array as command line argument

bash grep after match line to array

postfix status=deferred (TLS is required, but was not offered by host

grep in the matched file

mysql kill select longer than

System clock synchronized: no

Unbound

ubuntu install keydb

EOF ssh

wireguard remove key