Upgrading from 11.5.30 to 12.0.18 WARNING: [MYSQL ERROR] Unable to connect database

[klfrancis]

My panel is currently working fine but when I try to upgrade I get the following error

Parallels Panel pre-upgrade checking...
WARNING: [MYSQL ERROR] Unable to connect database. The reason of problem:

I have tried restarting the server, the mysql service and resetting the admin password via the admin password but none of that seems to have helped.

In the error message there is no The reason of problem: listed it is just blank.

Does anyone have any suggestions?

Thanks

 

[IgorG]

Check output of following SQL query in mysql database:

select user,host from user where user='admin';

 

[klfrancis]

Thanks for your reply Igor. I'll check that now and report back

 

[klfrancis]

Check output of following SQL query in mysql database:

select user,host from user where user='admin';

That gives me:
ERROR 1146 <42S02>: Table 'psa.user' doesn't exist

 

[IgorG]

I meant mysql database but not psa.

 

[klfrancis]

Am I supposed to be accessing this via cmd? (Sorry I am very new to plesk and parallels)

C:\Users\Administrator>"%plesk_dir%\mysql\bin\mysql.exe" -uadmin -P8306 -p psa

is that not correct?

 

[IgorG]

Am I supposed to be accessing this via cmd? (Sorry I am very new to plesk and parallels)

C:\Users\Administrator>"%plesk_dir%\mysql\bin\mysql.exe" -uadmin -P8306 -p psa

is that not correct?

No. Correct:

C:\Users\Administrator>"%plesk_dir%\mysql\bin\mysql.exe" -uadmin -P8306 -p mysql

 

[klfrancis]

Thank you for your patience with me.

When I use this:

C:\Users\Administrator>"%plesk_dir%\mysql\bin\mysql.exe" -uadmin -P8306 - p mysql

It doesn't log me into the sql the way the psa one did I just get the following

C:\Users\Administrator>"%plesk_dir%\mysql\bin\mysql.exe" -uadmin -P8306 - p mysq
l
D:\Plesk\\mysql\bin\mysql.exe Ver 14.14 Distrib 5.5.31, for Win32 (x86)
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.


Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- ----------------------------------------
auto-rehash TRUE
auto-vertical-output FALSE
character-sets-dir (No default value)
column-type-info FALSE
comments FALSE
compress FALSE
debug-check FALSE
debug-info FALSE
database (No default value)
default-character-set auto
delimiter ;
enable-cleartext-plugin FALSE
vertical FALSE
force FALSE
named-commands FALSE
ignore-spaces FALSE
init-command (No default value)
local-infile FALSE
no-beep FALSE
host (No default value)
html FALSE
xml FALSE
line-numbers TRUE
unbuffered FALSE
column-names TRUE
sigint-ignore FALSE
port 8306
prompt mysql>
quick FALSE
raw FALSE
reconnect TRUE
shared-memory-base-name (No default value)
socket (No default value)
ssl FALSE
ssl-ca (No default value)
ssl-capath (No default value)
ssl-cert (No default value)
ssl-cipher (No default value)
ssl-key (No default value)
ssl-verify-server-cert FALSE
table FALSE
user admin
safe-updates FALSE
i-am-a-dummy FALSE
connect-timeout 0
max-allowed-packet 16777216
net-buffer-length 16384
select-limit 1000
max-join-size 1000000
secure-auth FALSE
show-warnings FALSE
plugin-dir (No default value)
default-auth (No default value)

 

[klfrancis]

I restarted cmd and it now gives me

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\Administrator>"%plesk_dir%\mysql\bin\mysql.exe" -uadmin -P8306 -p mysql

Enter password: ***********
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password:
YES)

C:\Users\Administrator>

 

[klfrancis]

I restarted my cmd and I now get

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\Administrator>"%plesk_dir%\mysql\bin\mysql.exe" -uadmin -P8306 -p mysql

Enter password: ***********
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password:
YES)

C:\Users\Administrator>

 

[IgorG]

Run

"%plesk_dir%\mysql\bin\mysql.exe" -uadmin -P8306 -p

and enter password. After login to mysql select mysql database with

mysql> use mysql;

then run

mysql> select user,host from user where user='admin';

and post output here.

Contact Support Team if you are not familiar with SQL.

 

[klfrancis]

mysql> select user,host from user where user='admin';
+-------+-----------+
| user | host |
+-------+-----------+
| admin | localhost |
+-------+-----------+
1 row in set (0.00 sec)

mysql>

 

[IgorG]

Looks good.
It seems there is other reason. Logs investigation is required. Have you tried troubleshoot it with upgrade and mysql logs? Any details?

 

[klfrancis]

The update log gives me this

Execution failed.
Command: ai.exe
Arguments: Array
(
[0] => --select-product-id
[1] => panel
[2] => --select-release-current
[3] => --upgrade-installed-components
)

Details: BUSY: Update operation was locked by another update process.


Which is confusing as we aren't running any other updates at the moment. Is there a way to check what other updates might be causing this error?

Thanks

 

[klfrancis]

This is appearing in the upgrade log on the server




[2014-06-20 09:34:13.033397] Gathering information about installed license key...
[2014-06-20 09:34:13.033397] FileFetcher: get file (~empty)/PANEL-WIN_12.0.18/keyinfo.exe
[2014-06-20 09:34:13.033397] File downloading PANEL-WIN_12.0.18/keyinfo.exe: [2014-06-20 09:34:13.407798] 10%..[2014-06-20 09:34:13.423398] 20%..[2014-06-20 09:34:13.454598] 30%..[2014-06-20 09:34:13.470198] 40%..[2014-06-20 09:34:13.501398] 50%..[2014-06-20 09:34:13.532598] 60%..[2014-06-20 09:34:13.548198] 70%..[2014-06-20 09:34:13.563798] 80%..[2014-06-20 09:34:13.594998] 90%..[2014-06-20 09:34:13.610598] 100% was finished.
[2014-06-20 09:34:18.165806] You do not need to upgrade the current license key.
[2014-06-20 09:34:18.165806] DEBUG: because 'skip_key_upgrade' appears in output of C:\b9d8468f9a18c6443be9b370db437453\parallels\PANEL-WIN_12.0.18\keyinfo.exe
[2014-06-20 09:34:18.165806] Examination added: System checking..., context=Parallels Plesk Panel 12.0.18, script=PANEL-WIN_12.0.18/examine_launcher.exe, launcher=~empty, options=--check-system
[2014-06-20 09:34:18.165806] Examination added: Parallels Panel pre-upgrade checking..., context=panel, script=PANEL-WIN_12.0.18/panel_preupgrade_checker.php_, launcher=PANEL-WIN_12.0.18/examine_launcher.exe, options=~empty
[2014-06-20 09:34:18.165806] Launching component checkers...
[2014-06-20 09:34:18.165806] FileFetcher: get file (~empty)/PANEL-WIN_12.0.18/examine_launcher.exe
[2014-06-20 09:34:18.165806] File downloading PANEL-WIN_12.0.18/examine_launcher.exe: [2014-06-20 09:34:18.540207] 10%..[2014-06-20 09:34:18.571407] 20%..[2014-06-20 09:34:18.602607] 30%..[2014-06-20 09:34:18.633807] 40%..[2014-06-20 09:34:18.665007] 50%..[2014-06-20 09:34:18.696207] 60%..[2014-06-20 09:34:18.727407] 70%..[2014-06-20 09:34:18.743007] 80%..[2014-06-20 09:34:18.774207] 90%..[2014-06-20 09:34:18.789807] 100% was finished.
[2014-06-20 09:34:18.899008] Examination executed [C:\b9d8468f9a18c6443be9b370db437453\parallels\PANEL-WIN_12.0.18\examine_launcher.exe --check-system] with code 0
Output:
~empty
Error:
~empty
[2014-06-20 09:34:18.899008] FileFetcher: get file (~empty)/PANEL-WIN_12.0.18/panel_preupgrade_checker.php_
[2014-06-20 09:34:18.899008] File downloading PANEL-WIN_12.0.18/panel_preupgrade_checker.php_: [2014-06-20 09:34:19.273408] 10%..[2014-06-20 09:34:19.289008] 20%..[2014-06-20 09:34:19.320208] 39%..[2014-06-20 09:34:19.320208] 50%..[2014-06-20 09:34:19.335808] 60%..[2014-06-20 09:34:19.335808] 70%..[2014-06-20 09:34:19.382608] 87%..[2014-06-20 09:34:19.382608] 97%..[2014-06-20 09:34:19.382608] 100% was finished.
[2014-06-20 09:34:19.382608] FileFetcher: get file (~empty)/PANEL-WIN_12.0.18/examine_launcher.exe
[2014-06-20 09:34:19.382608] File downloading PANEL-WIN_12.0.18/examine_launcher.exe: [2014-06-20 09:34:19.772609] 10%..[2014-06-20 09:34:19.803809] 20%..[2014-06-20 09:34:19.835009] 32%..[2014-06-20 09:34:19.866209] 40%..[2014-06-20 09:34:19.897409] 50%..[2014-06-20 09:34:19.928609] 60%..[2014-06-20 09:34:19.959809] 70%..[2014-06-20 09:34:19.975409] 80%..[2014-06-20 09:34:20.006610] 90%..[2014-06-20 09:34:20.022210] 100% was finished.
[2014-06-20 09:34:27.837823] Examination executed [C:\b9d8468f9a18c6443be9b370db437453\parallels\PANEL-WIN_12.0.18\examine_launcher.exe C:\b9d8468f9a18c6443be9b370db437453\parallels\PANEL-WIN_12.0.18\panel_preupgrade_checker.php_ ] with code 1
Output:


INFO: Installed Plesk version/build: 11.5.30 Windows 2008/2012 20130808.09...



INFO: STEP 0: Detect system configuration...

INFO: OS: Windows

INFO: Arch: x86_64



INFO: Validating the database password...

INFO: Result: OK



INFO: Pre-Upgrade analyzer version: 12.0.18.0...



INFO: STEP 1: Validate hostname...

INFO: Result: OK



INFO: STEP 2: Checking if the MySQL engine InnoDB is allowed...

INFO: Result: OK



INFO: STEP 3: Checking the compatibility of the installed PHP version with the webmail software...

INFO: Result: OK



INFO: STEP 4: Detecting if encrypted passwords are used...

INFO: Result: OK



INFO: STEP 5: Checking autoinstaller version...

INFO: Result: OK



INFO: STEP 6: Checking table "servers" in database "mysql"...

INFO: Result: OK



INFO: STEP 7: Checking the availability of Plesk Panel TCP ports...

INFO: Result: OK



INFO: STEP 8: Checking for available free memory for the upgrade procedure...

INFO: Result: OK



INFO: STEP 9: Checking for restriction policy...

INFO: Result: OK



INFO: STEP 10: Obtaining information about the installed antivirus...

INFO: Current Antivirus is: drweb

INFO: Result: OK



INFO: STEP 11: Detecting if Urchin is installed...

INFO: Urchin is not installed

INFO: Result: OK



INFO: STEP 12: Obtaining information about the installed administration tool for SQL Server...

INFO: Current MSSQL Web Admin is: aspsqladmin

INFO: Result: OK



INFO: STEP 13: Detecting installed ISAPI filters...

INFO: Result: OK



INFO: STEP 14: Microsoft Visual C++ Redistributable Packages...

INFO: Please read carefully article http://kb.parallels.com/en/111891, for avoiding possible problems caused by Microsoft Visual C++ Redistributable Packages.



INFO: STEP 15: Checking the iisfcgi.dll file version...

INFO: Result: OK



INFO: STEP 16: Checking for CDONTS mailroot folder...

INFO: Result: OK



INFO: STEP 17: Checking the authentication settings of the PleskControlPanel website in IIS...

INFO: Result: OK



INFO: STEP 18: Checking for accounts with empty user names...

INFO: Result: OK



Found errors: 0; Found Warnings: 1




Error:
WARNING: [MYSQL ERROR] Unable to connect database. The reason of problem:

 

[IgorG]

Found errors: 0; Found Warnings: 1

Actually it is just warning but not error. In your posts no any useful information why it is happens. So, you can try to complete upgrade with ignoring this article or contact Support Team for checking and fixing this issue directly on your server.

 

[Ryan11433]

I was having those problems "SQLSTATE[HY] [] No connection could be made because the target machine actively refused it." and it seems that some tables are corrupted that caused the MySQL service to crash. After I have repaired those tables that are corrupted even restored from table backups I stopped having those issues.

 

[klfrancis]

Thanks for all your help.

In the end after checking everything and finding nothing wrong on the server we did the upgrade ignoring the warning and everything is fine. So I guess the error message may just have been a bug??