Unable to upgrade/install Plesk on Ubuntu/Debian: the following packages have unmet dependencies

Install Plesk on Ubuntu. Running the plesk installer results in failure. Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following packages have unmet […]

Read More

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 restart mysql

Read More

Install Apache, Mysql and PHP on Ubuntu 14.04

How to install Apache, MySQL and PHP on Ubuntu 14.04 Update # sudo apt-get update Apache # sudo apt-get install apache2 Install MySQL # sudo apt-get install mysql-server php5-mysql # sudo mysql_install_db # mysql_secure_installation Install PHP # sudo apt-get install php5 libapache2-mod-php5 php5-mcrypt Restart Server # sudo /etc/init.d/apache2 restart Check Apache Open a web browser […]

Read More

Plesk autoinstaller GPG error on Ubuntu 14.04 Trusty

Getting error for Plesk auto installer on Ubuntu 12 Trusty: Reading package lists… W: GPG error: http://autoinstall.plesk.com trusty InRelease: The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY 227C38D6AF741DEB W: GPG error: http://autoinstall.plesk.com trusty InRelease: The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY 227C38D6AF741DEB […]

Read More