Submitted by moja on Thu, 09/22/2016 - 11:56
When migrating backups created in DirectAdmin 1.50.1, they successfully import but have this error:
Failed to migrate virtual server : SQL set password for 'dbuser'@'localhost' = '*B1DFB503E89D3BEDEAB2386570D000510B9E3162&references_priv' failed : Password hash should be a 41-digit hexadecimal number
As a result the mysql passwords need recreating.
I can provide sample backups as required.
Status:
Closed (fixed)
Comments
Submitted by moja on Thu, 09/22/2016 - 11:58 Comment #1
Submitted by andreychek on Thu, 09/22/2016 - 12:04 Comment #2
Howdy -- Jamie may have some additional questions for you, but just to ensure he has all the information he needs --
What MySQL version is it that you're migrating both to and from?
And what distro/version are you using on your new server?
Submitted by JamieCameron on Thu, 09/22/2016 - 22:03 Comment #3
Yeah, this could be due to a MySQL version mismatch. Directadmin's backups contain only the hashed password .... but the hashing format isn't consistent across all MySQL releases.
Submitted by moja on Fri, 09/23/2016 - 10:17 Comment #4
Sorry I didn't see these replies before. Versions were the same actually, MariaDB 10.1 on both. Also Centos 7x64 on both too.
This isn't an issue for me anymore as we are not rolling Virtualmin out anymore, happy to work with you to resolve this for the greater good though :)
Submitted by JamieCameron on Fri, 09/23/2016 - 18:54 Comment #5
If I could get a copy of the problem backup file, that would be really useful.
Submitted by malkaduhimi on Sun, 06/11/2017 - 09:49 Comment #6
I have added a pull request to fix this issue: https://github.com/virtualmin/virtualmin-gpl/pull/6
Submitted by JamieCameron on Sun, 06/11/2017 - 12:25 Comment #7
Thanks, I have applied your patch and will include it in the next Virtualmin.
Submitted by JamieCameron on Sun, 06/11/2017 - 12:25 Comment #8
Submitted by IssueBot on Sun, 06/25/2017 - 12:30 Comment #9
Automatically closed - issue fixed for 2 weeks with no activity.