Change MySQL Binary Log File Location To Another Directory Follow the below steps to change MySQL binary log file location to another directory. 1. Edit the log-bin variable in my.cnf file located in /etc/my.cnf to log-bin=/new/directory/path/mysql-bin . # vi /etc/my.cnf …… ……… log-bin=/new/directory/path/mysql-bin ….. ……. Save and close the file. 2. To minimize the number of moved files, purge […]
Cron Schedule Syntax A basic crontab entry looks something like this: https://crontab.guru/ – this is just an awesome site to get the entry for a specific schedule. Managing Crontab Entries Once cron is running, it checks for crontab entries in the following files every minute: The first file, /etc/crontab, is a system-generated file containing shortcut commands […]
Do not delete the files from the file system. MySQL will complain at some time in the future. Save yourself the unnecessary downtime by using PURGE BINARY LOGS command from within MySQL or Change automatic default purge expiry from 30days (default) For long term set the BIN logs to a shorter time frame 1 day mysql> SET […]
ls /var/run/mysqld/ – should show below If not sudo service mysql stop sudo service mysql start Oddly the following has happened to me, I do not know why and am not really phased. Do not be in the folder /var/run/mysqld when doing the restart this for what ever reason has ended with none of the […]
The short version that you need, the rest is nice to know but this is your bread and butter. screen (starts a new session) this is once off until you destroy it or server/system restart. CTRL+A (then release both) then press D will put the session into the back. screen -r (will reconnect you to […]
Keep System Up-To-Date An extremely crucial part of hardening any system is to ensure that it is always kept up-to-date. Doing this will keep any known bugs or vulnerabilities patched if one exists. The following commands are ways to update an Ubuntu system:apt-get update && apt-get upgrade Accounts A good place to start when dealing […]
Ubuntu The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY B53DC80D13EDEF05 GPG error: http://packages.cloud.google.com/apt google-cloud-monitoring-focal-all InRelease: The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY B53DC80D13EDEF05 i.e. for this specific key “B53DC80D13EDEF05” being reported Run the following command Executing: /tmp/apt-key-gpghome.5ZVvtULX98/gpg.1.sh –keyserver hkp://keyserver.ubuntu.com:80 –recv-keys B53DC80D13EDEF05gpg: key […]
checklist for SysAdmins This article includes a collection of commands and best practices that you can use to improve the security of your Linux servers (RHEL/CentOS) 1. Remove insecure tools (FTP, telnet, rlogin, rsh, etc.) and use only secure alternatives (SCP, SSH, sftp, rsync, etc.) When choosing data communication tools, use only the secure and […]
Recommended Steps Before Installation Before you begin, run an update on your system to ensure all packages are up-to-date to avoid any conflicts during the installation. Proceed to upgrade any outdated packages using the following command. Adding Apache Repository by Ondřej Surý Repository The first step is to import the Apache webserver to the latest […]
