• 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

[Solved] Cant login after updated

StopGamer

New Pleskian
PRODUCT, VERSION, MICROUPDATE, OPERATING SYSTEM, ARCHITECTURE
pp11.5.30(but tried to upgrade tp 12)
microupdate - dont remember
Centos 6.4
64x
Linux version 2.6.32-358.14.1.el6.x86_64 ([email protected]) ( gcc version 4.4.7 20120313 (Red Hat 4.4.7-3) (GCC) )

PROBLEM DESCRIPTION
Cant login to plesk panel. After login/password - white screen
STEPS TO REPRODUCE
Login
ACTUAL RESULT
white screen
EXPECTED RESULT
plesk admin panel
ANY ADDITIONAL INFORMATION
Oh...
I`ll try to describe all things done before:
1. I needed ioncube of newest version then preinstalled. So I decided to check plesk/components for update.
2. When I got into admin panel I see message about update failure and grace key. Closed
3. Used Retrive key, deleted .lock file(http://kb.odin.com/en/116189)
4. Got error about wrong IP - first my visit here was about it http://talk.plesk.com/threads/cant-run-site-500-error-server-internal-error.290883/#post-711580
(got wrong IP preinstalled from hostinger)
5. Deleted wrong IP and run update again
6. Got Error smth about inapropriate package for my Key already installed.
7. While trying to get help with it got logout, and cant login back(actual problem).
8. /var/log/sw-cp-server log:
[crit] 1132#0: *358 connect() to unix:/var/run/sw-engine.sock failed (2: No such file or directory) while connecting to upstream
9. Found this http://talk.plesk.com/threads/error-502-bad-gateway-after-upgrade-to-12.305629/#post-754654
10. Tried bootstrapper repair.
/usr/local/psa/bootstrapper/pp11.5.30-bootstrapper/bootstrapper.sh repair
Got ERROR while trying to detect MySQL service name
11. Tried next post about Mysql connector(all was okay in checks, packages installed, ). Only cant find how to recreate cache, because vz is not installed and I got lost in it and its installation

[root@treefolk ~]# rpm -i sw-mariadb-client-1.0.0-13060717.x86_64.rpm
package sw-mariadb-client-1.0.0-13060717.x86_64 is already installed
[root@treefolk ~]# /etc/init.d/sw-cp-server stop
Stopping sw-cp-serverd: [ OK ]
[root@treefolk ~]# /etc/init.d/sw-cp-server start
Starting sw-cp-serverd: [ OK ]
[root@treefolk ~]# rpm -qa | grep mysql-connector
mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
[root@treefolk ~]# /etc/init.d/sw-engine restart
Stopping sw-engine-fpm: [ OK ]
Starting sw-engine-fpm: [ OK ]

UPD:
http://kb.odin.com/en/9294
tried
# $PRODUCT_ROOT_D/admin/sbin/autoinstaller --select-product-id ppsmbe --select-release-current --reinstall-patch --install-component base
Get
ERROR: Currently installed version of product with ID 'ppsmbe' is not available from download site anymore.
Please upgrade to the next available product version to receive software updates.

UPD2:
Found this http://kb.odin.com/en/123072
But dont know how to run this in Centos
/etc/init.d/sw-engine defaults is not recognised

UPD3
Found this http://kb.odin.com/en/118757
All is correct, no changes needed

UPD4
/etc/init.d/mysqld restart
Permission denied
but
plesk db
runs well.

Until I deleted socket. Restart service.
And now with /usr/local/psa/bootstrapper/pp11.5.30-bootstrapper/bootstrapper.sh repair
I got
Trying to find psa database... version is 012000018
Previous product version is 11.5.30, but previous database
version is 012000018. In most of cases it is result of
previous upgrade try failure. Please, restore previous version
from backup, and try again or contact technical support.


DATABASE ERROR!!!
ERROR while trying to check database version

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e"DROP DATABASE psa;"
# zcat /var/lib/psa/dumps/mysql.preupgrade.11.5.30-12.0.18.20141008-074828.dump.gz | sed -n '/-- Current Database: `psa`/,/-- Current Database:*/p' | mysql -f -uadmin -p`cat /etc/psa/.psa.shadow`

trying again repair
AND I can login!

trying to update
And got error from what all is started
warning: rpmts_HdrFromFdno: Header V3 RSA/SHA1 Signature, key ID 4520afa9: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY.art.txt
Fatal error during packages installation: The GPG keys listed for the "CentOS / Red Hat Enterprise Linux 6 - atomicrocketturtle.com" repository are already installed but they are not correct for this package.
Check that the correct key URLs are configured for this repository.
YumBaseError: The GPG keys listed for the "CentOS / Red Hat Enterprise Linux 6 - atomicrocketturtle.com" repository are already installed but they are not correct for this package.
Check that the correct key URLs are configured for this repository.
Error: Failed to run the Yum utility.
The Yum utility failed to install the required packages.
Attention! Your software might be inoperable.
Please, contact product technical support.

But this is another story to start
http://kb.odin.com/en/122498
 
Last edited:
I see no attempts for using bootstrapper repair procedure.
 
What to you mean?
I wrote, that when I'm trying to use bootstrapper repair, I got:
"Error while trying to detect MySQL service name"
 
Most probably file /etc/psa/psa.conf can be corrupted. Try to fix it with

# dos2unix /etc/psa/psa.conf
 
dos2unix /etc/psa/psa.conf
dos2unix: converting file /etc/psa/psa.conf to UNIX format ...
Same error
START Bootstrapper 11.5.30 repair AT Tue Oct 7 12:14:11 CEST 2014

**** Product repair started.

===> Checking for previous installation ... found.
Started bootstrapper repair procedure. This may take a while.
Certain actions may be skipped if not applicable.

Trying to start service mysqld... mysqld (pid 1383) is running...
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 011005030
Version is OK, no need to create psa database.
Trying to backup MySQL database... Warning: Not dumping MySQL database 'atmail' as it doesn't exist
done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.11.5.30-11.5.30.20141007-121411.dump.gz
Finishing up upgrade procedures and rerunning previously failed upgrade actions...
===> Cumulative Plesk database upgrade and repair (revertable stage) has been started.
Upgrade or repair for 'core' (stage 'prep') is not required
===> Preparing Plesk database upgrade (revertable stage).
Trying to resolve hostname 'treefolk.kiev.ua' and validate its IP address... done

Trying to set psa database version to 011005030... done
===> Cumulative upgrade and repair of Plesk database (revertable stage) has been completed.
===> Cumulative Plesk upgrade and repair (final stage) has been started.
Upgrade or repair for 'core' (stage 'post') is not required
===> Preparing Plesk upgrade (final stage).
===> Cumulative upgrade and repair of Plesk (final stage) has been completed.
Trying to upgrade APS controller database... ===> Cumulative APS controller database (apsc) upgrade and repair has been started.
Upgrade or repair for 'apsc' (stage 'db') is not required
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.apsc.11.5.30-11.5.30.20141007-121414.dump.gz
===> Upgrade and repair of APS controller database has been completed.
done
Trying to upgrade and repair SpamAssassin service configuration... Upgrade or repair for 'spamassassin' (stage 'files') is not required
done
Trying to upgrade and repair Courier-IMAP services configuration (prep stage)... Upgrade or repair for 'courier_imap' (stage 'prep') is not required
done
Trying to upgrade and repair Courier-IMAP services configuration (post stage)... Upgrade or repair for 'courier_imap' (stage 'post') is not required
done
Trying to upgrade and repair Courier-IMAP services configuration (bootstrapper-post stage)... Upgrade or repair for 'courier_imap' (stage 'bootstrapper-post') is not required
done
Trying to condrestart service courier-imapd... done
Trying to condrestart service courier-imaps... done
Trying to condrestart service courier-pop3d... done
Trying to condrestart service courier-pop3s... done
Trying to upgrade and repair Horde webmail configuration... Upgrade or repair for 'horde' (stage 'files') is not required
done
Trying to upgrade and repair Firewall service configuration... Upgrade or repair for 'firewall' (stage 'post') is not required
done
Trying to start service mysqld... mysqld (pid 1383) is running...
done
Trying to establish test connection... connected
done
Trying to connect to apsc database... done
Reconfiguring mail subsystem...
Trying to execute mail_restore to synchronize mail server settings and Plesk Database... ==> Checking for: mailsrv_conf_init... ok
==> Checking for: mail_handlers_init... ok
==> Checking for: mailsrv_entities_dump... ok
==> Checking for: mail_admin_aliases... ok
==> Checking for: mail_auth_dump... ok
==> Checking for: mailman_lists_dump... ok
==> Checking for: mail_kav8_restore... ok
==> Checking for: mail_responder_restore... ok
==> Checking for: vhostidmng... not exists
==> Checking for: mail_spam_restore... ok
==> Checking for: mail_grey_restore... ok
==> Checking for: mail_mailbox_restore... ok
==> Checking for: mail_spf_restore... ok
==> Checking for: mail_dk_restore... ok
==> Checking for: mail_drweb_restore... not exists
done
Reconfiguring Apache web server...
Reconfiguring ProFTPD FTP server...
Reconfiguring AWStats web statistics...
Reconfiguring WatchDog...
Restoring SELinux contexts...
Regenerating web servers' configuration files...
Cleaning active Panel sessions...

Bootstrapper repair finished.
If problems persist, please check installer logs ('/tmp/plesk_11.5.30_repair.log' and '/tmp/plesk_11.5.30_repair_problems.log') for errors.
If you can't resolve the issue on your own, please address Parallels support.

**** Product repair completed successfully.

STOP Bootstrapper 11.5.30 repair AT Tue Oct 7 12:14:50 CEST 2014
START Bootstrapper 11.5.30 repair AT Wed Oct 8 11:13:13 CEST 2014

**** Product repair started.

===> Checking for previous installation ... found.
Started bootstrapper repair procedure. This may take a while.
Certain actions may be skipped if not applicable.


ERROR while trying to detect MySQL service name
Check the error reason(see log file: /tmp/plesk_11.5.30_repair.log), fix and try again


**** Product repair failed.

***** problem report *****
ERROR while trying to detect MySQL service name
Check the error reason(see log file: /tmp/plesk_11.5.30_repair.log), fix and try again
STOP Bootstrapper 11.5.30 repair AT Wed Oct 8 11:13:14 CEST 2014
START Bootstrapper 11.5.30 repair AT Wed Oct 8 11:13:51 CEST 2014

**** Product repair started.

===> Checking for previous installation ... found.
Started bootstrapper repair procedure. This may take a while.
Certain actions may be skipped if not applicable.


ERROR while trying to detect MySQL service name
Check the error reason(see log file: /tmp/plesk_11.5.30_repair.log), fix and try again


**** Product repair failed.

***** problem report *****
ERROR while trying to detect MySQL service name
Check the error reason(see log file: /tmp/plesk_11.5.30_repair.log), fix and try again
STOP Bootstrapper 11.5.30 repair AT Wed Oct 8 11:13:53 CEST 2014
 
Maybe plesk panel is searching for MySQL at wrong IP. Where I can configure IP for plesk panel(config file)?
 
/etc/init.d/mysqld restart
Permission denied
but
plesk db
runs well.

Until I deleted socket.

/usr/local/psa/bin/reconfigurator --autoconfigure
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Database: []
Actual: [<88.198.192.206>, <2a01:4f8:b0:7f16::2>]
Removed IPs: [] []
Added IPs: [<88.198.192.206>] [<2a01:4f8:b0:7f16::2>]
Mapping: {}
Old not remapped: []
New not used: [<88.198.192.206>, <2a01:4f8:b0:7f16::2>]
Nothing to do.

Tried to restore with service mysqld restart (and edited mysld rights to edit)

/usr/local/psa/bin/reconfigurator --autoconfigure
Database: [<2a01:4f8:b0:7f16::2>, <88.198.192.206>]
Actual: [<88.198.192.206>, <2a01:4f8:b0:7f16::2>]
Removed IPs: [] []
Added IPs: [] []
Mapping: {}
Old not remapped: []
New not used: []
Nothing to do.
 
Last edited:
Back
Top