Forwarded to devs Plesk Migrator: not migrating Directadmin MySQL user and Databases

[Lexz]

Username: Lexz

TITLE

Plesk Migrator: not migrating Directadmin MySQL user and Databases

PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE

Plesk Obsidian 18.0.31 Centos 7 / Directadmin 1.61.5 Centos 7

PROBLEM DESCRIPTION

Good afternoon,

We are migrating two Directadmin servers to Plesk but found out that the databases and database users are not migrated. Source and Destination MariaDB: 10.2.34 / CentOS7

The log shows no errors and everything is processed successful.

Hope someone can help us with this issue.
Thank you in advance!

STEPS TO REPRODUCE

Use Plesk Migrator with SSH credentials to migrate from Directadmin subscriptions.

ACTUAL RESULT

Subscription, files and mail are migrated. Database and database user aren't. Migrator shows no errors.

EXPECTED RESULT

Migrate the subscription including the database and database-user

ANY ADDITIONAL INFORMATION



YOUR EXPECTATIONS FROM PLESK SERVICE TEAM

Confirm bug

 

[Lexz]

Does it help if I send a debug log or something?

[93m'mysqlconf' parameter is not found in '/usr/local/directadmin/conf/directadmin.conf'[0m
[91m"mysql_conf" parameter is not found in DirectAdmin config file "/usr/local/directadmin/conf/directadmin.conf"[0m
[93mCan't convert MySQL port "None" to integer, default port 3306 will be used[0m
[91mFailed to connect to DirectAdmin database with [login]@[host]:[port] "None@None:None" and password "None":
(1045, u"Access denied for user 'root'@'localhost' (using password: NO)")
Database content will not be dumped[0m

 

[Lexz]

Solved the problem!

After adding:
mysqlconf=/usr/local/directadmin/conf/mysql.conf

To:
/usr/local/directadmin/conf/directadmin.conf

The migrator works fine. Maybe it's an idea to use the configuration file directly instead of the parameter in /usr/local/directadmin/conf/directadmin.conf
Or use it as second option if variable is not found.

 

[Lexz]

Unfortunately the MySQL Users passwords are not migrated...
Final step to make it work.

 

[Lexz]

Sorry for all the updates...
I think we found te problem in the dumper.py
The version switch seems to go wrong.

 From:
        
    def _get_database_users(self, context):
        """
        :type context: context.Context
        :rtype: list | None
        """
        if "du" not in self._connections:
            return None
        owner = self._get_owner_from_context(context)
        password_field = 'Password'
    
To:
    
    def _get_database_users(self, context):
        """
        :type context: context.Context
        :rtype: list | None
        """
        if "du" not in self._connections:
            return None
        owner = self._get_owner_from_context(context)
        password_field = 'authentication_string'
        if self._connections["du_options"]["is_mysql5.7+"] is True:
            password_field = 'authentication_string'
        da_database_users = sql_to_dict(