libreoffice --calc file.xlsx
linux open excel
Leave a reply
Author Archives: Vitalijus Ryzakovas
mysqldump: Error 1412: Table definition has changed, please retry transaction when dumping table
Try to dump without single-transaction option with mysqldump
macos disable startup sound
sudo nvram -d SystemAudioVolume
Invalid command ‘Action’, perhaps misspelled or defined by a module not included in the server configuration
a2enmod actions
reload varnish config
TIME=$(date +%s)
varnishadm vcl.load r_$TIME /etc/varnish/default.vcl
varnishadm vcl.use r_$TIME
ERROR: package is not a legal parameter in an Ansible task or handler
apt-get install software-properties-common
apt-add-repository ppa:ansible/ansible
apt-get update
apt-get install ansible
Maldet
Maldet unique, is that it is designed around the threats faced in shared hosting environments. Maldet works by using threat data from network edge intrusion detection systems to extract malware that is actively being used in attacks and generates signatures for detection.
wget https://www.rfxn.com/downloads/maldetect-current.tar.gz
ubuntu wireguard
sudo add-apt-repository ppa:wireguard/wireguard
sudo apt install wireguard
centos 8 apache 2.4 real ip
LoadModule remoteip_module modules/mod_remoteip.so
RemoteIPHeader X-Forwarded-For
RemoteIPInternalProxy 192.168.0.0/16
mysqldump 7zip
mysqldump -h localhost --single-transaction database_name | 7z a -si backup.sql.7z
7z centos 8
dnf install epel-release
dnf install p7zip p7zip-plugins
apache http_x_forwarded_for to remote_addr
if (isset($_SERVER['HTTP_X_FORWARDED_FOR'])) {
$_SERVER['REMOTE_ADDR'] = $_SERVER['HTTP_X_FORWARDED_FOR'];
}
linux date time calculator
python -c "from datetime import date as d; print(d.today() - d(2020, 10, 24))"
41 days, 0:00:00
linux find name with uppercase
find /some/path/ | grep -v "[a-z]"
rsync keep permissions and ownership
Good just to resync files:
rsync -avz --no-perms --no-owner --no-group