Plesk panel not working after upgrade to version 10.2

[JorgeLevy]

My Plesk Panel stoped to work after I updated to version 10.2.. Here is my scenary:

Windows 2008 R2, plesk database moved to a SQL Server 2008 R2

Steps to reproduce:
Go to https://68.168.98.41:8443/
it redirects to https://68.168.98.41:8443/smb
and finally it redirect to https://chostservices01.chostservices.com:8443/relay where the page cannot be dsiplayed

Another issue I could see:
* it looks mysql database is down, I cannot access it on the remote desktop
* ftp logins fails with error:
Status: Connecting to 68.168.98.41:21...
Status: Connection established, waiting for welcome message...
Response: 220 Microsoft FTP Service
Command: USER xxxxxxxxxxx
Response: 331 Password required for miguelangel.garcia.
Command: PASS ********
Response: 530 User cannot log in.
Error: Critical error
Error: Could not connect to server

Could you help me with this errors? or maybe on upgrade I also installed SMB, is there any way to uninstall it to check if this is the error?

Thanks in advance.

 

[JorgeLevy]

Log trying to update MySQL:

Installation started in background
Determining the packages that need to be installed.
skip package 'upgrade-assist-10.0.0.0.noarch' from component base - there is same or newer version of this package is installed (in system upgrade-assist-10.0.0.0.noarch)
skip package 'mysql-4.1.22.noarch' from component base - there is same or newer version of this package is installed (in system mysql-5.0.45.noarch)
skip package 'plesk-10.2.0.noarch' from component base - there is same or newer version of this package is installed (in system plesk-10.2.0.noarch)
skip package 'panel-10.2.0.noarch' from component base - there is same or newer version of this package is installed (in system panel-10.2.0.noarch)
skip package 'plesk-skins-10.2.0.noarch' from component base - there is same or newer version of this package is installed (in system plesk-skins-10.2.0.noarch)
skip package 'plesk-backup-10.2.0.noarch' from component base - there is same or newer version of this package is installed (in system plesk-backup-10.2.0.noarch)
skip package 'plesk-engine-10.2.0.noarch' from component base - there is same or newer version of this package is installed (in system plesk-engine-10.2.0.noarch)
skip package 'spaw-10.0.0.noarch' from component base - there is same or newer version of this package is installed (in system spaw-10.0.0.noarch)
Check package set before installation
File downloading PANEL-WIN_10.2.0/dist-msi-Microsoft-2003-i386/mysql-client.msi: was skipped because of md5 checksum match.
Starting installation of packages
upgrading MySQL server...

 

[PavelV]

Could you please send to me some information to analyze.

Autoinstaller full log. You can find it at c:\<randomlettersandnumbers>\autoinstaller3.log
Database upgrade logs located here: %plesk_dir%\admin\logs\plesklog_dbupgradeYYYMMDD.log

Please put everything in ZIP archive and send to me in private message. I'll try to check what happened.

 

[PavelV]

finally it redirect to https://chostservices01.chostservices.com:8443/relay

This occurs after installation of Customer & Business Manager. As I see you have installed Full installation during upgrade to 10.2. Now you have CBM installed. If this happened accidently, you can read the following article to resolve this:
http://kb.odin.com/en/9327

If you want to use CBM, then you need to have proper hostname that can be resolved.

it looks mysql database is down, I cannot access it on the remote desktop

Cannot access means password is incorrect? or service stopped?
Check "MySQL Server" service. Since you are using MSSQL as plesk database, mysql server that can be used by Plesk for its database is stopped. This server listens on 8306 port and service called "Plesk SQL Server". It should be stopped in your case.

ftp logins fails with error:

You have faced issue discovered here: http://forum.parallels.com/showthread.php?t=109868
Please check IP_Addresses table in Plesk database. All subscriptions are created on single IP address. IPv4 address of your server must have id=1. It maybe that right now you have IPv6 address with id=1. Then you need to swap them. Unfortunately I cannot see this in logs.
After changing IP addresses identifiers, please execute:

%plesk_dir%\admin\bin\defpackagemng.exe --get --force
%plesk_dir%\admin\bin\ftpmng.exe --reconfigure-all

I hope this can help you.

 

[JorgeLevy]

Thanks Pavel, but I'm still having issues on the 3 items...

finally it redirect to https://chostservices01.chostservices.com:8443/relay

I have disabled SSO (since I'm still not able to access the panel, this is the only action I could execute; I mean, I couldn´t remove CMB). And login page for the Panel is now accesible, but once I fill my admin credential (and any other user) on https://localhost:8443/login_up.php3 page, I´m now receiving a HTTP 500 error message.

it looks mysql database is down, I cannot access it on the remote desktop

I could verify MySQL is running under D:\Program Files (x86)\Parallels\Plesk\Databases\MySQL\ but I cannot access it with any user credentials. I tried with "admin", "administrator", "Administrator", "Admin" and with know users I'm using from one of my sites it was working before; and all the times it returns error:
ERROR 1045 (28000): Access denied for user 'administrator'@'localhost' (using pa
ssword: YES)

ftp logins fails with error:

I execute the couple of the line and everything goes ok, but server is still unaccesible...

Thanks.

 

[PavelV]

I fill my admin credential (and any other user) on https://localhost:8443/login_up.php3 page, I´m now receiving a HTTP 500 error message.

Look at %plesk_dir%\admin\logs\php_error.log to see PHP error occured.

but I cannot access it with any user credentials

We are talking about MySQL server which is used for customers. This server is connected to Plesk under credentials that are stored in table databaseservers.

"%plesk_dir%\admin\bin\dbclient.exe" --direct-sql --sql="select * from databaseservers" and see which credentials used by Plesk. If they are not working then probably you need to repair this connection. For example, you can start mysql instance without password with --skip-grant-tables option, set proper password for user 'admin' used by plesk, and then server will be connected to Plesk again. You can find useful the following article: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

I execute the couple of the line and everything goes ok, but server is still unaccesible...

Please check also the following case:
"%plesk_dir%\admin\bin\dbclient.exe" --direct-sql --sql="select * from domainservices where status IS NULL"

If there are any rows returned, please fix this:
"%plesk_dir%\admin\bin\dbclient.exe" --direct-sql --sql="update domainservices set status=0 where status IS NULL"
Then:
ftpmng.exe --reconfigure-all