• Please be aware: Kaspersky Anti-Virus has been deprecated
    With the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

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

davidds64
Question How to upgrade MariaDB to latest version with Plesk Obsidian on Alma Linux 9
Replies
5
Views
1K
davidds64
davidds64
Daerik
Issue Error Upgrading Plesk Obsidian 18.0.63 to 18.0.64: HTTPS Error 404 - Not Found (MaxScale Repo)
Replies
6
Views
684
Daerik
Daerik
Daerik
Resolved Plesk Migrator Failing to Sync Database Records After Server Upgrade
Replies
8
Views
371
Maarten
M
Daerik
Issue Deprecated Program Name Warning After Upgrading to MariaDB 11.4
Replies
3
Views
9K
learning_curve
learning_curve
dash
  • Sticky
Question Try our new tool to upgrade your old MariaDB server from Plesk UI
2 3 4
Replies
65
Views
13K
learning_curve
learning_curve
Back
Top