To enable and set up the slow query log in MariaDB, you need to modify the configuration file my.cnf and restart the MariaDB service. Here are the steps to enable the slow query log in MariaDB: Open the my.cnf configuration file: sudo nano /etc/my.cnf Add the following lines to the configuration file: [mysqld] slow_query_log = … Read more

To run sudo without a password prompt on CentOS Linux, you can edit the /etc/sudoers file. Here’s the process: Open the /etc/sudoers file using the visudo command: sudo visudo Add the following line at the end of the file, replacing username with the name of the user who should not be prompted for a password: … Read more

The process to reload or restart php-fpm depends on the operating system and the version of php-fpm you are using. Here are some common methods for reloading or restarting php-fpm: For php-fpm 5 and 6: To reload the service: sudo service php5-fpm reload or sudo service php6-fpm reload To restart the service: sudo service php5-fpm … Read more

Setting up MariaDB Master-Slave replication with SSL on Ubuntu Linux involves the following steps: Install MariaDB on both the master and the slave servers. On the master server, open the MariaDB configuration file: sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf Add the following lines to the file: server-id = 1 log_bin = /var/log/mysql/mariadb-bin.log bind-address = <master_server_ip> Save and close … Read more

To flush the DNS forwarder cache in pfSense, you can follow these steps: Log in to the pfSense web interface. Navigate to Services > DNS Forwarder. Click the “Clear Cache” button located at the top of the page. The DNS forwarder cache is now cleared and any changes to the DNS records will be immediately … Read more

To increase the maximum upload size to 100 MB in PHP running on Apache, you can follow these steps: Open the PHP configuration file: sudo nano /etc/php/7.x/apache2/php.ini Change the following values: upload_max_filesize = 100M post_max_size = 100M Save and close the file. Restart Apache: sudo systemctl restart apache2 The maximum upload size has now been … Read more

You can use LXD (Linux containers) in a shell script to create a virtual machine (VM) when a cloud instance launches by following these steps: Install LXD: sudo apt-get update sudo apt-get install lxd Initialize LXD: sudo lxd init Create a new container: sudo lxc launch ubuntu:18.04 <container_name> Create a shell script to launch the … Read more

To disable the fast mirror plugin in a CentOS Linux server, you can follow these steps: Open the Yum configuration file: sudo nano /etc/yum/pluginconf.d/fastestmirror.conf Change the enabled setting to 0: [main] enabled=0 Save and close the file. Update the Yum cache: sudo yum makecache The fast mirror plugin is now disabled, and Yum will no … Read more

To install GoAccess web log analyzer with Nginx on Linux or Unix, you can follow these steps: Install GoAccess: sudo apt-get update sudo apt-get install goaccess Install Nginx: sudo apt-get update sudo apt-get install nginx Configure Nginx to log access data: Edit Nginx’s nginx.conf file and add the following log format to the http block: … Read more

You can run multiple commands as sudo by separating the commands with a semicolon (;) or by using a shell script. Using semicolon: sudo command1 ; sudo command2 ; sudo command3 Using a shell script: Create a shell script with the commands you want to run, make it executable and then run it with sudo: … Read more