Question Upgrade MySQL + Install Elasticsearch + PHP libraries

[BNB]

Hi,

I am using Plesk Onyx v17.0.17 on CentOS 7 and I am quite new to command line but I need a few configurations done:

1) My MySQL is showing 5.5 and I would like to upgrade it to 5.6.
I wasn't able to following the instructions here because I have no idea how to point "4. Add MariaDB repository".

2) I also need to install elasticsearch 2.3.4 - it really needs to be this version. Any idea on how to accomplish this?

3) I need to install the following PHP libraries on PHP 5.6: mcrypt, gd, intl, mbstring, pdo, pdo_mysql, exif, apcu/apc
How can I do this?

If I can do any of the above from Plesk itself (without using command line), I would prefer as I am not too familiar with ssh. However, if it is as simple as following instructions and commands on SSH, I guess I can do this.

Any help is really appreciated.

Thank you all.

 

[IgorG]

All these points should be done only in command line interface, no way to do it through Plesk UI.
Instructions are pretty simple and discussed on this forum many times, just use powerful forum search engine.
It is very difficult to give you exact step-by-step instructions because there are many different conditions, factors, specific configurations, installed or not installed necessary packages can be on your server, etc.
Therefore, if you are not familiar enough with Linux command line operation, I would suggest you hire experienced Linux expert for performing this configuration or contact Plesk Support Team.

 

[BNB]

Thank you Igor.

At this moment, all I need is to upgrade MySQL. It says I have MySQL 5.5 but I need to have either MySQL 5.6 or MariaDB 10.0.27

Is there a quick tutorial to have this upgraded either through Plesk UI or through SSH?

Thank you

 

[Maxime Grimler]

Hello

Maybe you could try follow this link
How to upgrade MySQL 5.5 to 5.6/5.7 on Linux

I'm running on CentOS 6 and I upgraded well on Mysql 5.7

If you need any help feel free to ask

 

[BNB]

Hi Maxime,

Unfortunately I get stuck on step 4 (on CentOS 7) with the following:

E325: ATTENTION

Found a swap file by the name "/etc/yum.repos.d/.MariaDB10.repo.swp"

owned by: root dated: Sat May 13 09:30:12 2017

file name: /etc/yum.repos.d/MariaDB10.repo

modified: YES

user name: root host name: marketing.middlelinks.com

process ID: 24631

While opening file "/etc/yum.repos.d/MariaDB10.repo"


(1) Another program may be editing the same file. If this is the case,

be careful not to end up with two different instances of the same

file when making changes. Quit, or continue with caution.

(2) An edit session for this file crashed.

If this is the case, use ":recover" or "vim -r /etc/yum.repos.d/MariaDB10.repo"

to recover the changes (see ":help recovery").

If you did this already, delete the swap file "/etc/yum.repos.d/.MariaDB10.repo.

swp"

to avoid this message.

"/etc/yum.repos.d/MariaDB10.repo" [New File]

Press ENTER or type command to continue

 

[Maxime Grimler]

Did you already tried to edit this file (not today but another day) and your session crashed ?

Can you try to type

ps -p 24631

It will display what is actually used by the prcoessus written in the error message

Regards

 

[BNB]

The result is:

PID TTY TIME CMD

And, at the moment, all my websites are not working after running these steps.

 

[Maxime Grimler]

Then do the recovery and continue the steps

vim -r /etc/yum.repos.d/MariaDB10.repo

 

[BNB]

Hi Maxime,

That gives me the following error:

[root@marketing ~]# vim -r /etc/yum.repos.d/MariaDB10.repo
-bash: vim: command not found

 

[Maxime Grimler]

Try without the m

vi -r /etc/yum.repos.d/MariaDB10.repo

 

[BNB]

I get these results now: Swap files found: Using specified name: 1. .MariaDB10.repo.swn owned by: root dated: Tue May 16 16:26:50 2017 file name: /etc/yum.repos.d/MariaDB10.repo modified: YES user name: root host name: marketing.middlelinks.com process ID: 23519 2. .MariaDB10.repo.swo owned by: root dated: Tue May 16 16:33:21 2017 file name...

Moreover, I can not even access Plesk UI anymore and I get this error at the 8443 port: Screen Shot on 2017-05-16 at 19:36:30.png

 

[Maxime Grimler]

2 - normal as your mysql service is stop

Without any access to the server it's a bit hard to help you
Maybe you can contact the chat from Plesk Support (Contact support via chat - Plesk) they are really fast to answer and help and they will fix it for you in a couple of minutes