• 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

Resolved AutoUpdate Error

J

jmackenz

New Pleskian
Execution failed.
Command: autoinstaller
Arguments: Array
(
[0] => --select-product-id
[1] => plesk
[2] => --select-release-current
[3] => --upgrade-installed-components
[4] => --include-components-from-class
[5] => vendor=parallels
[6] => --include-components-from-class
[7] => patched
)

Details: Doing restart of Plesk Installer...
File downloading products.inf3: 100% was finished.
File downloading plesk.inf3: 12%..23%..32%..40%..50%..63%..71%..86%..93%..100% was finished.
File downloading ppsmbe.inf3: 70%..100% was finished.
File downloading sitebuilder.inf3: 100% was finished.
File downloading sso.inf3: 100% was finished.
File downloading setemplates.inf3: 100% was finished.
File downloading pp-sitebuilder.inf3: 11%..29%..39%..55%..73%..81%..90%..100% was finished.
File downloading billing.inf3: 17%..28%..39%..55%..73%..81%..100% was finished.
File downloading mysql.inf3: 100% was finished.
File downloading apache.inf3: 100% was finished.
File downloading nginx.inf3: 25%..42%..86%..100% was finished.
File downloading php70.inf3: 100% was finished.
File downloading php56.inf3: 100% was finished.
File downloading php55.inf3: 100% was finished.
File downloading php54.inf3: 100% was finished.
File downloading php53.inf3: 100% was finished.
File downloading php52.inf3: 100% was finished.
File downloading pmm.inf3: 100% was finished.
Checking for installed packages...
File downloading PSA_12.5.30/plesk-12.5.30-cos7-x86_64.inf3: 12%..21%..36%..49%..69%..71%..91%..100% was finished.
Downloading extensions catalog feed...
File downloading PSA_12.5.30/plesk-patches-12.5.30-cos7-x86_64.inf3: 12%..24%..31%..45%..53%..61%..70%..82%..93%..100% was finished.
File downloading SITEBUILDER_12.5.29/sitebuilder-12.5.29-rhel7-all.inf3: 100% was finished.
File downloading NGINX_1.11.1/nginx-1.11.1-cos7-x86_64.plesk12.inf3: 100% was finished.
File downloading PHP_7.0.7/php70-7.0.7-cos7-x86_64.inf3: 100% was finished.
File downloading PHP_5.6.22/php56-5.6.22-cos7-x86_64.inf3: 82%..100% was finished.
File downloading PHP_5.5.36/php55-5.5.36-cos7-x86_64.inf3: 82%..100% was finished.
File downloading PHP_5.4.45/php54-5.4.45-cos7-x86_64.inf3: 100% was finished.
File downloading PHP_5.3.29/php53-5.3.29-cos7-x86_64.inf3: 100% was finished.
File downloading PHP_5.2.17/php52-5.2.17-cos7-x86_64.inf3: 100% was finished.
File downloading PMM_0.1.10/pmm-0.1.10-cos7-x86_64.inf3: 100% was finished.
gpg-pubkey-914bdf7e-55c05220 gpg(Plesk Team <[email protected]>)
gpg-pubkey-1eb6225b-4f341491 gpg(PEER 1 Hosting <[email protected]>)
gpg-pubkey-f4a80eb5-53a7ff4b gpg(CentOS-7 Key (CentOS 7 Official Signing Key) <[email protected]>)
Loaded plugins: fastestmirror, langpacks, priorities


Detecting installed product components.
Gathering information about the installed license key...
Launching component checkers...
File downloading PSA_12.5.30/examiners/panel_preupgrade_checker.php: 12%..27%..38%..43%..54%..63%..74%..85%..93%..100% was finished.
File downloading PSA_12.5.30/examiners/php_launcher.sh: 100% was finished.
Loaded plugins: fastestmirror, langpacks, priorities

PHP_5_2_17-dist | 2.9 kB 00:00

PHP_5_2_17-thirdparty | 2.9 kB 00:00

PHP_5_3_29-dist | 2.9 kB 00:00

PHP_5_3_29-thirdparty | 2.9 kB 00:00

PHP_5_4_45-dist | 2.9 kB 00:00

PHP_5_4_45-thirdparty | 2.9 kB 00:00

PHP_5_5-dist | 2.9 kB 00:00

PHP_5_5-thirdparty | 2.9 kB 00:00

PHP_5_6-dist | 2.9 kB 00:00

PHP_5_6-thirdparty | 2.9 kB 00:00

PHP_7_0-dist | 2.9 kB 00:00

PHP_7_0-thirdparty | 2.9 kB 00:00

PLESK_12_5_30-dist | 2.9 kB 00:00

PLESK_12_5_30-thirdparty | 2.9 kB 00:00

PMM_0.1.10-dist | 2.9 kB 00:00

PMM_0.1.10-thirdparty | 2.9 kB 00:00

SITEBUILDER_12_5_29-dist | 2.9 kB 00:00

SITEBUILDER_12_5_29-thirdparty | 2.9 kB 00:00

base | 3.6 kB 00:00

extras | 3.4 kB 00:00

updates | 3.4 kB 00:00
Loading mirror speeds from cached hostfile
* base: mirror.cisp.com
* extras: mirror.rackspace.com
* updates: mirror.rackspace.com
+ plesk-l10n
+ psa-locale-base-en-US

The following amount of disk space is required in directories:
/usr/local: 1800.00 Mb.
Total required: 1800.00 Mb, available 417356.00 Mb.

Installing packages
chsh: Shell not changed.
Changing shell for popuser.
Changing shell for mhandlers-user.
chsh: Shell not changed.
is running
Stopping sw_engine service... done
**** Product prep-install started.

===> Checking for previous installation ... found.
Create user 'psaadm' and group 'psaadm'
Checking for the group 'psaadm'...
Group 'psaadm' already exists

Checking for the user 'psaadm'...
User 'psaadm' already exists

Create group swkey-data
Checking for the group 'swkey-data'...
Group 'swkey-data' already exists

Checking for the group 'swkey-data'...
Trying to add supplementary group 'swkey-data' for user 'psaadm'... already there
Create Mail accounts
Checking for the group 'popuser'...
Group 'popuser' already exists

Checking for the user 'popuser'...
User 'popuser' already exists

Checking for the user 'mhandlers-user'...
User 'mhandlers-user' already exists

Trying to got legacy variables... done
config updated
===> Updated /etc/psa/psa.conf
Trying to save legacy variables... done
Trying to resolve hostname 'server1.montellocs.com' and validate its IP address... done


===> Checking for the necessary system accounts
Checking for the system groups and users necessary for admin server...
Checking for the group 'psaadm'...
Group 'psaadm' already exists

Checking for the user 'psaadm'...
User 'psaadm' already exists

Checking for the group 'psaserv'...
Group 'psaserv' already exists

Checking for the group 'psaserv'...
Trying to add supplementary group 'psaserv' for user 'psaadm'... already there
Checking for the group 'psacln'...
Group 'psacln' already exists
 
Hi jmackenz,

from your shortened log, the only error - message is
jmackenz said:
Execution failed.
Click to expand...

Pls. restart your auto-update process again, as for example over the command line:

/usr/local/psa/admin/sbin/autoinstaller --select-release-current --upgrade-installed-components --reinstall-patch --install-component base​
 
Checking that /usr/local/psa/bin/chrootsh registered as login shell...
/usr/local/psa/bin/chrootsh already registered as a login shell


===> Performing safe prep-install database actions


===> Upgrading database

Trying to start service mariadb... active
done
Trying to establish test connection... ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

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

ERROR while trying to establish test connection
Check the error reason(see log file: /var/log/plesk/install/plesk_12.5.30_installation.log), fix and try again

Stopping sw-cp-server (via systemctl): [ OK ]
Starting sw_engine service... done
Starting sw_cp_server service... done
Starting mysql service... already started
Starting named service... already started
Starting mailer service... already started
Starting spamfilter service... already started
Starting tomcat service... unused
Starting apache service... already started
Starting superserver service... already started
Starting sw_engine service... already started
***** problem report *****
ERROR while trying to establish test connection
Check the error reason(see log file: /var/log/plesk/install/plesk_12.5.30_installation.log), fix and try again

ERROR: An error occurred during performing of installation PREP actions (see log for details). Installation was rolled back.
Warning! Not all packages were installed.
Please check if your system services are operable.
Please resolve this issue and try installing the packages again.
If you cannot resolve the issue on your own, contact product technical support for assistance.
 
 
Thanks for the direction :)

It led to This :

[root@server1 ~]# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin mysql
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
[root@server1 ~]# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
FATAL ERROR: Upgrade failed
 
/usr/local/psa/bin/admin --show-password

Gives me the password that I currently use to login to the panel, which works fine.

How do I convert that to the hash that needs to be in that shadow file?
 
Hi jmackenz,

the answer to your question is given at "Unable to log in to Plesk: saved admin password is incorrect ( Plesk Knowledge-Base article 112492 )" :

4. Update the password for Plesk using the ch_admin_passwd utility:

# /usr/local/psa/bin/admin --show-password
password
# export PSA_PASSWORD=password
# /usr/local/psa/admin/bin/ch_admin_passwd
Click to expand...

The "ch-admin_passwd" - utility stores as well the encrypted password at "/etc/psa/.psa.shadow".
 
[root@server1 ~]# /usr/local/psa/bin/admin --show-password
displayedpass
[root@server1 ~]# export PSA_PASSWORD=displayedpass
[root@server1 ~]# /usr/local/psa/admin/bin/ch_admin_passwd
[root@server1 ~]# mysql -u admin psa
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
[root@server1 ~]# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin mysql
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)


what am I doing wrong?
 
Also attempted :

[root@server1 ~]# /usr/local/psa/bin/init_conf -u -passwd NEWPASS

SUCCESS: Completed updating administrator's information.
[root@server1 ~]# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin mysql
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
[root@server1 ~]# /usr/local/psa/bin/admin --show-password
NEWPASS
[root@server1 ~]# export PSA_PASSWORD=NEWPASS
[root@server1 ~]# /usr/local/psa/admin/bin/ch_admin_passwd
[root@server1 ~]# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin mysql
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
 
Hi jmackenz,

instead of using "mysql -u admin psa", pls. use

plesk db DATABASE_NAME​

or

mysql -uadmin -p`cat /etc/psa/.psa.shadow` DATABASE_NAME

​
Edit:

... and pls. consider to follow further suggestions from the KB - article!

Note: If you are unable to connect, enable skip-grant-tables in the /etc/my.cnf file, restart MySQL, then update the admin password:

[mysqld]
skip-grant-tables

# /etc/init.d/mysqld restart
# mysql -uadmin
mysql> UPDATE mysql.user SET Password=PASSWORD('$AES***') WHERE User='admin';

Do not forget to remove skip-grant-tables after that and restart MySQL.
Click to expand...
 
I apologize if I'm being a little slow this morning. I'm being torn in a multitude of different directions.

When you say Database_Name , I'm assuming that should be psa , correct ?
This MariaDB , is this a new replacement for MySQL in 12.5?

Code: 
Note: If you are unable to connect, enable skip-grant-tables in the /etc/my.cnf file, restart MySQL, then update the admin password:

[mysqld]
skip-grant-tables

# /etc/init.d/mysqld restart
# mysql -uadmin
mysql> UPDATE mysql.user SET Password=PASSWORD('$AES***') WHERE User='admin';

Do not forget to remove skip-grant-tables after that and restart MySQL.

In this example where it states PASSWORD I assume that should be the newpass used above? or is it literally PASSWORD.

Where It Says $AES*** is that a literal *** or am I supposed to replace it with something?

[root@server1 ~]# mysql -uadmin
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
Click to expand...


[root@server1 ~]# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 1483520
Server version: 5.5.47-MariaDB MariaDB Server

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [psa]>
Click to expand...
 
Hi jmackenz,

in your quote, you now already connected successfully to your PSA - database - pls. have another closer look :
MariaDB [psa]>
Click to expand...

Now that you already know, that the password is correctly stored in the shadow - file, pls. continue with your command:
jmackenz said:
[root@server1 ~]# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin mysql
Click to expand...
I marked in RED, what you should change, when I stated:
UFHH01 said:
instead of using "mysql -u admin psa", pls. use

plesk db DATABASE_NAME
or

mysql -uadmin -p`cat /etc/psa/.psa.shadow` DATABASE_NAME
Click to expand...

Please REPLACE "DATABASE_NAME" with the desired database, in the just quoted command, that you used, it would be:

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql​




... but if you would like to connect to your PSA - database over the command line, you certainly would use:

mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa

or

plesk db psa​



jmackenz said:
In this example where it states PASSWORD I assume that should be the newpass used above? or is it literally PASSWORD.

Where It Says $AES*** is that a literal *** or am I supposed to replace it with something?
Click to expand...

Pls. note the following things and try to use the commands to fully understand, what the commands are for:

The following command displays the admin password:

/usr/local/psa/bin/admin --show-password
​
The following command displays the ENCRYPTED admin password:

cat /etc/psa/.psa.shadow`
​
=> As you can see, the first command displays the admin password, without encryption and the second command displays the encrypted admin password, starting with "$AES".​




Edit: In addition, pls. DON'T forget the further steps from KB - article 116916 , when you successfully connected to your mysql - database :

  • Check admin privileges:

    mysql> SHOW GRANTS FOR 'admin'@'localhost'\G

  • Grant all privileges to admin if required:

    GRANT ALL ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;
    FLUSH PRIVILEGES;
Click to expand...
 
Last edited by a moderator:
Code: 
[root@server1 ~]# mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 5698
Server version: 5.5.47-MariaDB MariaDB Server

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [mysql]> UPDATE mysql.user SET Password=NEWPASS('$AEScontent') WHERE User='admin';
ERROR 1305 (42000): FUNCTION mysql.NEWPASS does not exist
MariaDB [mysql]>

Code: 
MariaDB [mysql]> SHOW GRANTS FOR 'admin'@'localhost'\G
*************************** 1. row ***************************
Grants for admin@localhost: GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' IDENTIFIED BY PASSWORD '*content' WITH GRANT OPTION
 
I am thinking that I misunderstood you.

I took it before that for Password=PASSWORD('AESContent)

That PASSWORD should be replaced with output of plain text password request and that AES content should be content of psa.shadow.
 
Hi jmackenz,

pls. change ONLY the "('$AEScontent')" - part and replace it with the content from "cat /etc/psa/.psa.shadow`".


=> UPDATE mysql.user SET Password=PASSWORD('YOUR_VERY_OWN_ENCRYPTED_PASSWORD_FOR_ADMIN-USER_ON_YOUR_SYSTEM') WHERE User='admin';
 
Thanks for the clarification.


MariaDB [mysql]> UPDATE mysql.user SET Password=PASSWORD('$AESCONTENT') WHERE User='admin';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
 
Hi jmackenz,

now pls. continue with the update/upgrade procedure again:

UFHH01 said:
Pls. restart your auto-update process again, as for example over the command line:

/usr/local/psa/admin/sbin/autoinstaller --select-release-current --upgrade-installed-components --reinstall-patch --install-component base
Click to expand...
 
[root@server1 ~]# /usr/local/psa/admin/sbin/autoinstaller --select-release-current --upgrade-installed-components --reinstall-patch --install-component base

ERROR: You specified wrong combination of options.
The options install-component and upgrade-installed-components cannot be used together.
Refer to installer's help page for details (run Plesk Installer with --help option).
Click to expand...

Running Just

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

Brings me back to :

Code: 
 Trying to start service mariadb... active
done
Trying to establish test connection... ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

To clarify, in the mariadb prompt I put

Code: 
UPDATE mysql.user SET Password=PASSWORD('12345') WHERE User='admin'

here 12345 is the output of psa.shadow ,

just wanted to make sure that the enclosing ' should remain
 
Last edited:
You must log in or register to reply here.

Similar threads

U
Resolved Can't remove Plesk under Ubuntu 20.04
Replies
1
Views
992
Peter Debik
P
B
  • Locked
Resolved Updates fail due to insufficient disk space
Replies
3
Views
1K
Peter Debik
P
R
Issue sh: gs: command not found exporting files as pdf
2
Replies
27
Views
4K
Peter Debik
P
S
Issue Sitejet Builder
Replies
0
Views
236
Sopherl
S
M
Issue Plesk Update 18.0.34 to 18.0.57 Database 'psa' not found
Replies
10
Views
847
musa.sc
M
Back
Top