Restore Error - password to be altered, but using an old password format

[ger64]

Hello readers,

I have a question

What I did:
- In Admin Level I make a backup with: Admin Backup/Transfer
- I restore a "test03.reseller.user.tar.gz"

I get the mesage:
- An error occurred during the restore.
- See please below for what I did.

Settings:
Server Settings - Max Username Length: 30

Apache 2.4.46
DirectAdmin 1.61.5
Exim 4.94
MySQL 8.0.21
Named 9.9.4
sshd Running
dovecot 2.3.13 (89f716dc2)
pure-ftpd 1.0.49
Php: 7.4.15
mysql: 8.0
mariadb: 10.4
mysql_inst: mysql
mysql_force_compile: no

- - -

What I did en try:

I made a new mysql database with:
Name: test03_name1
User: test03_user1

Afhter backup - In user_user_databaseuser2.conf:

db_collation=CATALOG_NAME=def&DEFAULT_CHARACTER_SET_NAME=utf8mb4&DEFAULT_COLLATION_NAME=utf8mb4_0900_ai_ci&DEFAULT_ENCRYPTION=NO&SCHEMA_NAME=test03_name1&SQL_PATH=
test03=alter_priv=Y&alter_routine_priv=Y&create_priv=Y&create_routine_priv=Y&create_tmp_table_priv=Y&create_view_priv=Y&delete_priv=Y&drop_priv=Y&event_priv=Y&execute_priv=Y&grant_priv=N&index_priv=Y&insert_priv=Y&lock_tables_priv=Y&passwd=$A$005$eC9a#,n~~iYgED#2eONEDS1qBtxWDvXlJ2GtYO7yKWJYtgl/W1MXdaN.Ao0&references_priv=Y&select_priv=Y&show_view_priv=Y&trigger_priv=Y&update_priv=Y
test03_user1=alter_priv=Y&alter_routine_priv=Y&create_priv=Y&create_routine_priv=Y&create_tmp_table_priv=Y&create_view_priv=Y&delete_priv=Y&drop_priv=Y&event_priv=Y&execute_priv=Y&grant_priv=N&index_priv=Y&insert_priv=Y&lock_tables_priv=Y&passwd=$A$005$[F%%^i3[r>+DkZ Yz9d2ka87/sbDHfvIcY7Qfbemq5EijaFmRHYRtfzYl8FJrj7&references_priv=Y&select_priv=Y&show_view_priv=Y&trigger_priv=Y&update_priv=Y
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Afther Restore: An error occurred during the restore.

User test03_user1@localhost password to be altered, but using an old password format
Recommend re-saving their password to save with the newer format.
User test03@localhost password to be altered, but using an old password format
Recommend re-saving their password to save with the newer format.
User test03@localhost password to be altered, but using an old password format
Recommend re-saving their password to save with the newer format.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

What did I try?

- I have re-installed mysql
- I have "re-saving their password to save with the newer format".
- Backup-ed again en Restored again, but still the same problem.

With some users (when I restore) I have not this problem.
These users are old and theire paswords in the .conf are with: lock_tables_priv=Y&passwd=*BA0ED37E2 etc
I have made them before upgrade mysql from 5.7 to 8.0

So I think, maybe bcause I upgraded mysql from 5.7 to 8.0?

When I delete the database at this user, bakup en restore, everything goes well.
So the problem must be related to the mysql.

I found to set: default-authentication-plugin=mysql_native_password in etc/my.cnf

Will it solve the problems (with the older and new user accounts?

Who know's where i can search more to solve this issue?

Thanks

 

[Active8]

hmm lot of work i have faced similar problem
i did on the old server
1. generate a new password for the user/reseller
2. make new backup en did an new restore on the new server

if this fails because of your database
1 generate a new database password
2 add new password in de config file of your program
3 generate new backup en import on the new server

 

[ger64]

Thanks

Active8​