itday.org.ua

1. to /etc/sysctl.conf need to add
fs.file-max = 100000

8. now you can update the table_open_cache and open_files_limit in my.cnf and restart mariadb again if need.

cron:
01 00 * * * /bin/sh /scripts/do.backup.sh

#!/bin/bash
echo "[`date`] => Backup has been started" >> /var/log/backup.log
echo "---------->>>>>> Started: `date` < <<<<<----------------"
rm -Rf /var/www/local_copy/*
df -h
rm -f /root/grouplist.file
rm -f /root/dblist.file
## +locations
echo "---------->>>>>> + locations < <<<<<----------------"
mkdir -p /var/www/local_copy
mkdir -p /var/www/local_copy/for_backups
mkdir -p /var/www/local_copy/`date +%d.%m.%Y`
mkdir -p /var/www/local_copy/`date +%d.%m.%Y`/mysql
mkdir -p /var/www/local_copy/`date +%d.%m.%Y`/users
mkdir -p /var/www/local_copy/`date +%d.%m.%Y`/emails
## +mysqldump
echo "---------->>>>>> + mysqldump < <<<<<----------------"
mysql -e "SHOW DATABASES;" | tr -d "| " | grep -v Database|grep -v "performance_schema\|mysql\|information_schema" >> /root/dblist.file
for i in `cat /root/dblist.file`;do mysqldump --single-transaction -f --databases "$i" >> /var/www/local_copy/for_backups/"$i".sql && zip -r /var/www/local_copy/`date +%d.%m.%Y`/mysql/"$i".zip /var/www/local_copy/for_backups/"$i".sql && rm -f /var/www/local_copy/for_backups/"$i".sql;done
echo "---------->>>>>> + /system < <<<<<----------------"
zip -rq --symlinks /var/www/local_copy/`date +%d.%m.%Y`/etc.zip /etc
zip -rq --symlinks /var/www/local_copy/`date +%d.%m.%Y`/mgr5.zip /usr/local/mgr5
zip -rq --symlinks /var/www/local_copy/`date +%d.%m.%Y`/cron.zip /var/spool/cron
echo "---------->>>>>> + move system files < <<<<<----------------"
rsync -a -e "ssh -i /root/.ssh/key_name" /var/www/local_copy/`date +%d.%m.%Y` key_name@server_ip:/home/key_name/backups/
echo "---------->>>>>> + users < <<<<<----------------"
ls /var/www/|grep -v "php-\|html\|httpd-logs\|httpd-cert\|cgi-bin\|webalizer\|local_copy\|grandmother"|sed '1d' >> /root/grouplist.file
for i in `cat /root/grouplist.file`;do zip -rq --symlinks /var/www/local_copy/`date +%d.%m.%Y`/"$i".zip /var/www/"$i" && rsync -a -e "ssh -i /root/.ssh/key_name" /var/www/local_copy/`date +%d.%m.%Y`/"$i".zip key_name@server_ip:/home/key_name/backups/`date +%d.%m.%Y`/users/ && rm -f /var/www/local_copy/`date +%d.%m.%Y`/"$i".zip;done
rm -Rf /var/www/local_copy/`date +%d.%m.%Y`
rm -f /root/dblist.file
df -h
echo "[`date`] ==> Backup has been completed" >> /var/log/backup.log
cd /var/www/httpd-logs/ && ls -alh |grep G|awk {'print $9'}|xargs rm -fv
echo "---------->>>>>>Backups Completed: `date` < <<<<<----------------"

mkdir -pv ~/.ssh;ssh-keygen -t rsa -b 2048 -C "$(whoami)@$(hostname)-$(date -I)" -f ~/.ssh/"$(whoami)"
chmod 600 ~/.ssh/"$(whoami)".pub
ssh-copy-id -i ~/.ssh/"$(whoami)".pub user_name@server_ip
ssh -i ~/.ssh/"$(whoami)" user_name@server_ip

or manually add it to host under user:

mkdir -pv /home/key_name/.ssh/ && nano /home/key_name/.ssh/authorized_keys && chown -Rv key_name:key_name /home/key_name/.ssh

chmod -v g-w /var/www/*/data && chmod -v 700 /var/www/*/data/.ssh && chmod -v 644 /var/www/*/data/.ssh/authorized_keys

1 apt-get update; apt-get upgrade
2 apt-get install -y mariadb-server htop rsync mc nano vim
3 mysql_secure_installation
4 echo "update user set plugin='' where User='root'; flush privileges;" | mysql -u root -p mysql
5 apt-get install -y phpmyadmin
6 nano /etc/mysql/mariadb.conf.d/50-server.cnf (need to comment line bind-address)
7 /etc/init.d/mysql restart

for package in $(rpm -qa); do yum reinstall -y $package; done

yum package-cleanup

file: rootpanel.css
line #23
changes
old: display:inline-block; height:29px;
new: display:inline-block; height:29px;

file: /var/www/rbill/data/www/_roottpl/default_web/___pagesHeader.inc.php
too many changes, need to keep it as is.

CloudFlare Flexible SSL -> plugin for WP
Really Simple SSL -> plugin for WP
SSL Insecure Content Fixer -> on CF side

iptables -n -L --line-numbers|grep 8.8.8.8
iptables -D INPUT 610

dd if=/dev/zero of=/swapfile bs=1014 count=4194304
chown root:root /swapfile
chmod 0600 /swapfile
mkswap /swapfile
swapon /swapfile