• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Issue After MariaDB 10.1 Upgrade Plesk Login not available

F

fab5freddie

Basic Pleskian
Hi folks,

I've got a Cloud Server with Plesk Onyx 17.0.17 on CentOS 7

I have to install a Magento Shop v.2.1. But that's not possible because the database server which is installed out of the box with CentOS 7 is mysql v.5.5.

So I did the following steps to upgrade the database server:

01. I removed watchdog because deactivating wasn't possible
02. I copied the password from /etc/psa/.psa.shadow to my clipboard
03. I made a mysql dump from all databases - mysqldump -u admin -p'.psa.shadow' --all-databases > /tmp/all-database.sql
04. I created an actual repository on https://downloads.mariadb.org/mariadb/repositories
05. touch /etc/yum.repos.d/MariaDB.repo
06. vi /etc/yum.repos.d/MariaDB.repo
07. I inserted the created repository from step 4 into MariaDB.repo
08. yum -y update
09. systemctl stop mariadb
10. yum remove mariadb-server mariadb mariadb-libs
11. yum clean all
12. yum -y install MariaDB-server MariaDB-client
13. systemctl start mysql
14. systemctl enable mysql
15. mysql_upgrade -uadmin -p'.psa.shadow'
16. mysql -V
17. mysql -u admin -p'.psa.shadow' < /tmp/all-database.sql

After successfull MariaDB 10.1 Upgrade I wanted to login to Plesk Onyx to install watchdog. But sometimes I get a 403 Error which means to me that there should be a rights problem and sometimes (like now) the Plesk Login Site is not available at all.

What did I do wrong? Any suggestions?

I'm very grateful for any help I can get. Any help is appreciated.

Thanks in advance
Regards fab5freddie
 
More related details/error messages from /var/log/sw-cp-server/error_log and /var/log/sw-cp-server/sw-engine.log is required.

Also

# plesk repair installation

would be useful here.
 
after step 16 I get a 403 error and the following message by using: cat /var/log/sw-cp-server/error_log
Code: 
server:/$ cat /var/log/sw-cp-server/error_log
2017/01/10 05:19:08 [crit] 1193#0: *2 connect() to unix:/var/run/sw-engine.sock failed (2: No such file or directory) while connecting to upstream, client: client-ip, server: , request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/var/run/sw-engine.sock:", host: "server-ip:8443"
2017/01/10 05:33:18 [error] 1193#0: *66 directory index of "/usr/local/psa/admin/htdocs/" is forbidden, client: client-ip, server: , request: "GET / HTTP/1.1", host: "server-ip:8443"

after step 16 I get the following message by using: cat /var/log/sw-cp-server/sw-engine.log
Code: 
server:/$ cat /var/log/sw-cp-server/sw-engine.log
[10-Jan-2017 05:18:14] NOTICE: fpm is running, pid 1048
[10-Jan-2017 05:18:14] NOTICE: ready to handle connections
[10-Jan-2017 05:18:14] NOTICE: systemd monitor interval set to 10000ms
[10-Jan-2017 05:18:36] NOTICE: Terminating ...
[10-Jan-2017 05:18:36] NOTICE: exiting, bye-bye!
[10-Jan-2017 05:19:09] NOTICE: fpm is running, pid 1073
[10-Jan-2017 05:19:09] NOTICE: ready to handle connections
[10-Jan-2017 05:19:09] NOTICE: systemd monitor interval set to 10000ms
[10-Jan-2017 05:29:41] NOTICE: Terminating ...
[10-Jan-2017 05:29:41] NOTICE: exiting, bye-bye!


after step 17 I still get a 403 error and the following message by using: cat /var/log/sw-cp-server/error_log
Code: 
server:/$ cat /var/log/sw-cp-server/error_log
2017/01/10 05:19:08 [crit] 1193#0: *2 connect() to unix:/var/run/sw-engine.sock failed (2: No such file or directory) while connecting to upstream, client: client-ip, server: , request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/var/run/sw-engine.sock:", host: "server-ip:8443"
2017/01/10 05:33:18 [error] 1193#0: *66 directory index of "/usr/local/psa/admin/htdocs/" is forbidden, client: client-ip, server: , request: "GET / HTTP/1.1", host: "server-ip:8443"
2017/01/10 05:44:48 [error] 1193#0: *68 directory index of "/usr/local/psa/admin/htdocs/" is forbidden, client: client-ip, server: , request: "GET / HTTP/1.1", host: "server-ip:8443"
2017/01/10 05:44:49 [error] 1193#0: *68 open() "/usr/local/psa/admin/htdocs/favicon.ico" failed (2: No such file or directory), client: client-ip, server: , request: "GET /favicon.ico HTTP/1.1", host: "server-ip:8443", referrer: "https://server-ip:8443/"
2017/01/10 05:44:51 [error] 1193#0: *68 directory index of "/usr/local/psa/admin/htdocs/" is forbidden, client: client-ip, server: , request: "GET / HTTP/1.1", host: "server-ip:8443"
2017/01/10 05:44:52 [error] 1193#0: *68 directory index of "/usr/local/psa/admin/htdocs/" is forbidden, client: client-ip, server: , request: "GET / HTTP/1.1", host: "server-ip:8443"
2017/01/10 05:44:53 [error] 1193#0: *68 directory index of "/usr/local/psa/admin/htdocs/" is forbidden, client: client-ip, server: , request: "GET / HTTP/1.1", host: "server-ip:8443"
2017/01/10 05:44:55 [error] 1193#0: *68 directory index of "/usr/local/psa/admin/htdocs/" is forbidden, client: client-ip, server: , request: "GET / HTTP/1.1", host: "server-ip:8443"

after step 17 I get the following message by using: cat /var/log/sw-cp-server/sw-engine.log
Code: 
server:/$ cat /var/log/sw-cp-server/sw-engine.log
[10-Jan-2017 05:18:14] NOTICE: fpm is running, pid 1048
[10-Jan-2017 05:18:14] NOTICE: ready to handle connections
[10-Jan-2017 05:18:14] NOTICE: systemd monitor interval set to 10000ms
[10-Jan-2017 05:18:36] NOTICE: Terminating ...
[10-Jan-2017 05:18:36] NOTICE: exiting, bye-bye!
[10-Jan-2017 05:19:09] NOTICE: fpm is running, pid 1073
[10-Jan-2017 05:19:09] NOTICE: ready to handle connections
[10-Jan-2017 05:19:09] NOTICE: systemd monitor interval set to 10000ms
[10-Jan-2017 05:29:41] NOTICE: Terminating ...
[10-Jan-2017 05:29:41] NOTICE: exiting, bye-bye!
 
Have you tried

# plesk repair installation

?

Command

# plesk installer --select-release-current --reinstall-patch --upgrade-installed-components

also may help.
 
It doesn't matter which command of both I use, nothing happens.
No error or response appears in the command line.

Do I have to install this plesk repair utility?
 
fab5freddie said:
It doesn't matter which command of both I use, nothing happens.
No error or response appears in the command line.
Click to expand...
Looks like you copy-paste it from my message with # symbol in your command line. Symbol # is sign of root account in command line. You have it already if you are root.
 
Ok, my fault, sorry. I copied the hash tag, too.
When I type in your commands without the hash tag, I get "command not found".
 
Code: 
server:/$ /usr/local/psa/bin/repair --installation
-bash: /usr/local/psa/bin/repair: No such file or directory
 
fab5freddie said:
$
Click to expand...
Looks like you are not root. repair utility is a part of plesk-core package:

# rpm -qf /usr/local/psa/bin/repair
plesk-core-17.0.17-cos7.build1700161028.14.x86_64

Have you tried to run (as root!!!) command

# /usr/local/psa/admin/sbin/autoinstaller --select-release-current --reinstall-patch --upgrade-installed-components

?
 
IgorG said:
# /usr/local/psa/admin/sbin/autoinstaller --select-release-current --reinstall-patch --upgrade-installed-components
Click to expand...
This command worked and the plesk login site appears. But now I can't login with my credentials.
The following message appears: "You used a wrong username or password"
 
Now I have changed the Plesk password on the shell and tried to login.
Now appears the next error message. Can I fix it by using the command line?

Code: 
ERROR: require_once(): Failed opening required 'modules/firewall/FwConfigurator.php' (include_path='/usr/local/psa/admin/plib:/usr/local/psa/admin/externals') (HomeController.php:79)
 
Have you started repair installation as I wrote before?
 
Yes, I started
Code: 
server:~$ plesk repair installation

Reconfiguring the Plesk installation

Started bootstrapper repair procedure. This may take a while.
Certain actions may be skipped if not applicable.

 Finishing up upgrade procedures and rerunning previously failed upgrade actions...
===> Cumulative APS controller database (apsc) upgrade and repair has been started.
===> Cumulative upgrade and repair of APS controller database has been completed.
===> Cumulative APS controller upgrade and repair (final stage) has been started.
===> Cumulative upgrade and repair of APS controller (final stage) has been completed.
===> Cumulative Plesk database upgrade and repair (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).
===> Cumulative upgrade and repair of Plesk database (revertable stage) has been completed.
===> Plesk database scheme upgrade has been started.
Applying migrations from: /usr/local/psa/bootstrapper/pp17.0.17-bootstrapper/migrations/
===> Plesk database scheme upgrade has been completed.
===> Cumulative Plesk upgrade and repair (final stage) has been started.
===> Preparing Plesk upgrade (final stage).
===> Cumulative upgrade and repair of Plesk (final stage) has been completed.
 Reconfiguring mail subsystem...
 Reconfiguring Apache web server...
 Reconfiguring ProFTPD FTP server...
===> Configuring ProFTPD server
 Reconfiguring AWStats web statistics...
 Reconfiguring WatchDog...
 Restoring SELinux contexts...
 Reconfiguring SSL ciphers and protocols...
 Regenerating web servers' configuration files...
 Cleaning active Panel sessions...

Bootstrapper repair finished.
If problems persist, please check installer logs ('/var/log/plesk/install/plesk_17.0.17_repair.log' and '/var/log/plesk/install/plesk_17.0.17_repair_problems.log') for errors.
If you can't resolve the issue on your own, please address Parallels support.
 
I think Plesk will have to have a button to set a mariadb update to version 10
:p maybe next update Plesk :p
 
You must log in or register to reply here.

Similar threads

dash
  • Sticky
Question Try our new tool to upgrade your old MariaDB server from Plesk UI
2 3
Replies
45
Views
5K
VNick
V
Amadex
Resolved Problems with MariaDB update on CloudLinux 8
Replies
3
Views
2K
Nikolay
Nikolay
I
Issue maria DB update plesk 18.0.50
Replies
10
Views
3K
Maarten.
M
akira9000
Resolved Upgrading MariaDB from 10.1 to 10.5
Replies
4
Views
2K
akira9000
akira9000
E
After using Plesk to upgrade Mariadb from 10.5 to 10.11 Wordpress and other apps can no longer connect to 'localhost'
Replies
2
Views
629
Peter Debik
P
Back
Top