Disable ONLY_FULL_GROUP_BY in Mysql on Ubuntu 16

Recently I ran a command in mysql that resulted in this error: mysql: [ERROR] unknown variable 'sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' So I had to add a line to the mysql config file. In Ubuntu 16: # nano /etc/mysql/mysql.conf.d/mysqld.cnf Add the following line under mysqld [mysqld] sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" Restart mysql: # systemctl restartRead More…

Stress Test CentOS with Stress

First, you need to download the file using Wget and then install it using RPM on your system to enable the EPEL repository. RHEL/CentOS 7 64 Bit # wget http://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm # rpm -ivh epel-release-latest-7.noarch.rpm ## RHEL/CentOS 6 64-Bit ## # wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm # rpm -ivh epel-release-6-8.noarch.rpm Check the installation #Read More…

Set up Sendgrid on Plesk

This is used to set up Sendgrid in Plesk for Azure email functionality. Set up a sendgrid account and set up the first email: ¬†Ssh to the Azure server and make the following modifications: Find your Postfix config file, typically /etc/postfix/main.cf, and add the following: smtp_sasl_auth_enable = yes smtp_sasl_password_maps =Read More…

Check CPU Type

Here is how to check the CPU type in CentOS: # dmidecode –type processor Output: # dmidecode 2.12 SMBIOS 2.7 present. Handle 0x0004, DMI type 4, 42 bytes Processor Information Socket Designation: CPU 1 Type: Central Processor Family: Xeon Manufacturer: Intel ID: D7 06 02 00 FF FB EB BFRead More…