Puvox – Blog
  • HOMEPAGE
  • Mobile & Android
  • Browser
  • Plugin
  • Technology
  • Trading programming
  • Website
  • Windows & Software
  • WordPress

Puvox – Blog

Recent Posts

  • Debloat Windows 11/10 with debloaters
  • Configure VPS with details & LAMP
  • Necessary steps to secure your digital life
  • Add user & ssh key in Linux/Ubuntu
  • Install Redis Cache for PHP-8

Recent Comments

  • PHP-8 (zts) & Apache & Swoole/Parallel (+ WordPress) with Docker/ PhpBrew – Puvox – Blog on Install Redis Cache for PHP-8
  • Constantin on Remove (exit) “SmartImage” on Philips Monitor
  • Docker & PHP-8 (zts) & Apache & Swoole+Parallel – Puvox – Blog on Useful commands for docker (Windows)
  • Docker & phpBrew (php-7 zts) & WordPress – Puvox – Blog on PHP-8 (zts) & Apache & Swoole/Parallel (+ WordPress) with Docker/Ubuntu/PhpBrew
  • Hajra on Migrate/Redirect Blogspot without loosing SEO Rank

Archives

  • April 2022
  • December 2021
  • July 2021
  • June 2021
  • December 2020
  • October 2020
  • July 2020
  • May 2020
  • February 2020
  • January 2020
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • January 2019
  • September 2018
  • August 2018
  • June 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • May 2017
  • April 2017
  • March 2017
  • January 2017
  • December 2016
  • December 2013
  • January 2013

Categories

  • Browser
  • Coding
  • Health
  • Information & How to tutorials
  • Mobile & Android
  • Plugin
  • Technology
  • Trading programming
  • Video
  • Website
  • Windows & Software
  • WordPress

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Configure VPS with details & LAMP

  • Coding
  • Website
  • Initial setup of Ubuntu
  • LAMP stack: how-to-install-linux-apache-mysql-php-lamp-stack | how-to-install-a-lamp-stack-on-ubuntu
  • PHB-Brew: github.com/phpbrew  &  blog/docker-php-8-zts-apache-swoole-parallel & gmp install
  • LetsEncrypt: le-on-ubuntu | le-with-nginx  | (on different port: here or here)
    Setup Firewall : firewall-on-ubuntu | configure-firewall-and-change-ssh-port.md
  • After ssl , change ssh port (from 22 to your desired, i.e. 12345):
    sudo ufw allow 12345/tcp
    nano /etc/ssh/sshd_config And change port 22 to12345. Then do service ssh restart (or service sshd restart)  You might also need to amend: /etc/apache/sites-enabled && /etc/apache2/ports.conf
  • WordPress (with mysql) : do.com/wordpress-on-ubuntu
  • fail2ban : sudo apt-get install fail2ban
  • Simple Disk usage show: sudo apt install ncdu
  • disable journal: se.com/how-to-clear-journalctl
    journalctl --vacuum-size=100M
    /etc/systemd/journald.conf –> SystemMaxUse=100M
    (sudo find /var/log/journal -name "*.journal" | xargs sudo rm) && (sudo systemctl restart systemd-journald)
  • Set correct permissions for multiple users
    – to rewrite privileges after uploading files automatically: 
    */10 * * * * sudo chown -R www-data:www-data /var/www
  • [PHP]:
    – Install Redis Cache
    – Install MBstring : sudo apt-get install php-mbstring php7.0-mbstring php-gettext libapache2-mod-php7.0
  • Add user through SSH
  • Increate timeout for SSH client
  • Restrict port to specific IP:
    sudo iptables -A INPUT -p tcp -s YOURRRRRRR_IPPPPPPPPPPP -j ACCEPT
    sudo ufw allow from 123.123.123.123 to any port 22 proto tcp
  • Monitor files/folders changes : 
    inotify-hookable -w path_to_plugin -c "COMMAND_TO_EXECUTE" (i.e. "docker container restart CONTAINER_NAME") 
  • Download & unpack file: 
    wget --no-check-certificate --content-disposition https://codeload.github.com/USER/REPONAME/zip/refs/heads/master -O temp.zip && unzip -o temp.zip -d /var/www/path/folder
  • Find file:
    find . -type f -name "*John*"
  • Install & Configure mail: article1 | article2
  • Auto- Restart stopped-service : Github repo 

### MYSQL ###

  • Add/Create user:
    CREATE USER 'myuser1'@'192.168.1.123' IDENTIFIED BY 'password123';
    GRANT ALL PRIVILEGES ON dbnamee.* TO 'myuser1'@'192.168.1.123';
    FLUSH Privileges;
  • user password change : 
    ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxxxxx';
  • disable mysql-logs : se.com/delete-mysql-bin-files & se.com/disable-mysql-logging
    /etc/mysql/my.cnf - >
    [mysqld]
    max_allowed_packet = 512M
    skip-log-bin
    binlog_expire_logs_seconds=1600
    In mysql: 
    SHOW VARIABLES LIKE 'max_allowed_packet';
    SET @@global.max_allowed_packet = 16777215;
    SHOW VARIABLES LIKE 'max_allowed_packet';

December 31, 2021

Post navigation

Debloat Windows 11/10 with debloaters → ← Necessary steps to secure your digital life

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • Browser
  • Coding
  • Health
  • Information & How to tutorials
  • Mobile & Android
  • Plugin
  • Technology
  • Trading programming
  • Video
  • Website
  • Windows & Software
  • WordPress
Copyright © 2019 | Puvox Software