The following command can be used to check and repair all MySQL databases on a Ubuntu or Debian Linux System. I've tested the commands on Ubuntu 20.04 and Debian 10. Repair MySQL databases on Ubuntu Linux sudo mysqlcheck --defaults-file=/etc/mysql/debian.cnf --auto-repair --optimize --all-databases MySQL database repair on Debian mysqlcheck --defaults-file=/etc/mysql/debian.cnf --auto-repair --optimize --all-databases The benefit of ... Read more
I recently installed Ubuntu on my desktop computer. Everything was working fine, except that I was not able to capture screenshots using the 'Insert/Print Screen' key on my Dell keyboard. While googling the issue, I stumbled upon a workaround that solved my problem. The workaround was to create a custom keyboard shortcut. If you are ... Read more
Mostly, we have only a single display connected to computer systems. However, you can have multiple displays connected to a system. While working with more than one display, sometimes you might find yourself in a situation where-in you need to perform a display-specific task. For example, taking a screenshot. In these scenarios, you need to ... Read more
Some internet access providers have port 25 disabled in their routers to prevent spam. If you run your own email server in a data center, you might have to enable the submission port (587) in postfix to be able to send emails from your local email client to your own mail server. Enable Submission Port ... Read more
When you get the error message "system-config-firewall: command not found" on your CentOS Server while trying to configure the firewall on the shell, then the text interface version of the firewall configuration utility is missing. Install CentOS Firewall configuration tool Install it with this command: yum install system-config-firewall-tui
This short tutorial describes the steps to optimize the performance of a MySQL database with the mysqltuner script. This tool can be used for MySQL and MariaDB. Install mysqltuner The mysqltuner High-Performance MySQL Tuning Script is available as a package on Debian 10 and Ubuntu 20.04, install it with at: sudo apt install mysqltuner For ... Read more
This short guide shows you how to get a list of all installed Packages on Debian Linux. Packages on Debian get installed with the apt package installer. We will use the dpkg command, which is part of the apt toolset, to query the installed packages database. Get all installed Debian packages dpkg --get-selections As you ... Read more
Jailkit is an easy-to-use tool to create and maintain jail environments for shell users on Linux. In this guide, I will show you how to move PHP and its dependencies into the jail so that the jailed user can execute PHP scripts inside the jail on an ISPConfig server. Edit the jailkit .ini file and ... Read more
It is important to keep your Linux server up to date with security updates. Linux distributions like Ubuntu and Debian release updates on a daily basis, so keeping the system up-to-date can become a tedious task. Fortunately, there is an option to install security updates automatically. Here are the steps to enable automatic security updates ... Read more
This tutorial shows you how to solve the RoundCube webmail error message: config.inc.php was not found. on an ISPConfig Debian server that uses Nginx as the web server. Solution RoundCube webmail is accessed on an ISPConfig Nginx web server through the apps vhost. The PHP-FPM of the apps vhost is running under the user and group ... Read more