ubuntu 14.04 with mariaDB 10, apache 2.4 with plesk 12.1.20

ubuntu 14.04 with mariaDB 10, apache 2.4 with plesk 12.1.20

install ubuntu 12.04 with plesk 11 or 12. on a dedicated server, depends on you dedicated host.

Step 1
===================================================

Time to upgrade dist 12.04 to 14.04

always use
$ apt-get update
$ apt-get upgrade


$ sudo apt-get install update-manager-core
$ sudo do-release-upgrade



step 2
=========================================================

This should be fine

Time to move on. Why not install plesk 12.1.20?


download1.parallels.com/Plesk/PP12/paral...inux-change-log.html

$ wget autoinstall.plesk.com/plesk-installer
$ chmod +x ./plesk-installer
$ ./plesk-installer --all-versions

And choose your favorite version?


Step 3
===================================================
unfortunately you have to configure apache 2.4.7 first! So let take action.


Apache 2.2 to 2.4 changes:

$ apachectl -k restart

first error
apache2: Syntax error on line 140 of /etc/apache2/apache2.conf:

go to your ftp client and search for

/etc/apache2/mods-available/fcgid.load and change

LoadModule fcgid_module /usr/lib/apache2/modules/mod_fcgid.so
into

# LoadModule fcgid_module /usr/lib/apache2/modules/mod_fcgid.so


do the same for jk.load and ssl.load



$ apachectl -k restart

now you got the following error:

AH00526: Syntax error on line 17 of /etc/apache2/conf-enabled/php5-cgi.conf:

read httpd.apache.org/docs/2.4/upgrading.html

and change

Order deny,allow
Deny from all

into

Require all denied


Then you have to remove /etc/apache2/mods-enabled/dir.conf


$ apachectl -k start

apache should be running now.

$ apache2 -v

to see apache/2.4.7

$ apt-get update
$ apt-get upgrade

$ apt-get autoremove


Step 4
======================================================

upgrade mysql 5.5 to 5.6 just upgrade not install!

download dev.mysql.com/downloads/repo/apt/

file mysql-apt-config_0.3.3-2ubuntu14.04 and upload this in the root of your server trough a ftp client


$ sudo dpkg -i mysql-apt-config_0.3.3-2ubuntu14.04_all.deb
$ sudo apt-get update
$ sudo apt-get install mysql-server

To see what is installed

if you are using Debian / Ubuntu Linux, type the following command:

$ dpkg --list | egrep \'mysql-(server|client)\'

ii mysql-client 5.6.24-1ubuntu12.04 MySQL Client meta package depending on latest version
ii mysql-server 5.6.24-1ubuntu12.04 MySQL Server meta package depending on latest version
rc mysql-server-5.5 5.5.41-0ubuntu0.12.04.1 MySQL database server binaries and system database setup


ii means \'It should be installed and it is installed\' whereas
rc means \'It\'s removed/uninstalled but it\'s configuration files are still there

so the config file of mysql-server-5.5 is still there


$ sudo apt-get purge mysql-server-5.5
$ sudo service mysql start

Now you got

ii mysql-client 5.6.24-1ubuntu12.04 MySQL Client meta package depending on latest version
ii mysql-server 5.6.24-1ubuntu12.04 MySQL Server meta package depending on latest version


Now the mysql is up to date.

$ sudo apt-get update
$ sudo apt-get upgrade


step 6

=========================================================

Time to upgrade mariadb-server

Before doing drop-in replacement ensure that version of MariaDB server you are about to install is either the same (preferable) as current MySQL version, or higher. After installing a drop-in replacement you may optionally execute following command to notify Panel that MySQL component was updated:

$ plesk sbin packagemng --set-dirty-flag


sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
sudo add-apt-repository \'deb ftp.nluug.nl/db/mariadb/repo/10.0/ubuntu trusty main\'


Once the key is imported and the repository added you can install MariaDB with:

$ sudo apt-get update
$ sudo apt-get install mariadb-server ! now you got an error


if you got:
The following packages have unmet dependencies:
mariadb-server : Depends: mariadb-server-10.0


use this:

devblog.plesk.com/2013/08/mariadb-installation-guide/

depending on your OS and selected MariaDB version, execute one of the following commands.If you are on Debian 7 or Ubuntu 12.04 (then the only possible MariaDB version is 10.0), run:

$ env DEBIAN_FRONTEND=noninteractive apt-get -o OrderList::Score::Immediate=1000 \\
install mariadb-server mysql-common libmariadbclient18


Try

$ dpkg -l | grep -i maria

but! mariaDB is not complete installed. Use

$ apt-get update
$ apt-get upgrade

7 files where changed and follow the instructions on the sceen.
can take a wile...

Try again

$ dpkg -l | grep -i mysql


step 7
==========================================================

So let\'s look what we have installed!


apt-cache policy libmysqlclient18
apt-cache policy mariadb-server
apt-cache policy mysql-common
apt-cache policy mysql-client


use:

$ /etc/init.d/mysql status

* /usr/bin/mysqladmin Ver 9.1 Distrib 10.0.17-MariaDB, for debian-linux-gnu on x86_64
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Server version 10.0.17-MariaDB-1~precise-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 19 min 59 sec

Threads: 1 Questions: 1304 Slow queries: 0 Opens: 477 Flush tables: 1 Open tables: 330 Queries per second avg: 1.087


Enjoy your ubuntu 14.04 with mariaDB 10, apache 2.4.7 and plesk 12.1.20 !





Some errors you can get:


Error1:
===============================

ERROR while trying to upgrade APSC SQL database from 11.1.0

The apsc.aps_application_resource table is absent from the apsc database.

use:

/usr/local/psa/bootstrapper/ppxx.x.x-bootstrapper/bootstrapper.sh repair



Error2:
===============================

** Table \'apsc.aps_application_resource\' doesn\'t exist

use:

Do you have file /usr/local/psa/bootstrapper/ppxx.xx.x-bootstrapper/db/apsc_mysql_db.sql ?
If yes - try to create apsc database with it.

** while trying to execute SQL query, the query was: CREATE INDEX ownerId_idx ON smb_users (ownerId)



Error3:
===============================
/opt/psa/admin/bin/webmailmng: error while loading shared libraries: libmariadb.so.1: cannot open shared object file: No such file or directory


[root@ ~]# ldd /usr/sbin/postconf
linux-vdso.so.1 => (0x00007fff6cdfe000)
libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x00007fdbb1e9d000)
libpcre.so.0 => /lib64/libpcre.so.0 (0x00007fdbb1c71000)
libmysqlclient.so.16 => not found

use:

~# echo \'/usr/lib64/mysql\' >> /etc/ld.so.conf.d/mysqlclient.conf
~# echo \'/usr/lib64/sw\' >> /etc/ld.so.conf.d/sw_libs.conf
~# echo \'/usr/lib/sw\' >> /etc/ld.so.conf.d/sw_libs.conf
~# echo \'/usr/lib/libboost-plesk-1.55.0/\' >> /etc/ld.so.conf.d/sw_libs.conf
~# ldconfig -v



Error4:
===============================

dpkg: error processing /var/cache/apt/archives/libmysqlclient18_5.5.33a+maria-1~raring_amd64.deb (--unpack):
libmysqlclient18:amd64 5.5.33a+maria-1~raring (Multi-Arch: no) is not co-installable with libmysqlclient18 which has multiple installed instances

Open /var/lib/dpkg/status search for a line with Package: libmysqlclient18 and remove block of text till lines \"Original-Maintainer: ...\" this text block could appear couple times there, remove all appearances. after that run apt-get -f install

Such \"hack\" helped with some other libs also, whenyou are sure that you have installed correct version of library or you have a PPA with needed version, but apt-get does not see it. Try do the same manual cache clean for this lib.


Error5:
===============================

You may think the process is completed, but it is not. Always, Always check the error log. Have you checked your MySQL error log today?

just upgrade the mysql database but how?


If you can\'t find the root password use this


$ sudo mysqlcheck -udebian-sys-maint -p --all-databases --check-upgrade --auto-repair
$ sudo mysql_upgrade -udebian-sys-maint -p

You can find the password and user /etc/mysql/debian.cnf