• We value your experience with Plesk during 2024
    Plesk strives to perform even better in 2025. To help us improve further, please answer a few questions about your experience with Plesk Obsidian 2024.
    Please take this short survey:

    https://pt-research.typeform.com/to/AmZvSXkx
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

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

Lexz

Basic Pleskian
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
 
Does it help if I send a debug log or something?

Code:
[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
 
Last edited:
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.
 
Unfortunately the MySQL Users passwords are not migrated...
Final step to make it work.
 
Sorry for all the updates...
I think we found te problem in the dumper.py
The version switch seems to go wrong.

Python:
 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(
 
Back
Top