• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

Forwarded to devs Migration DB Username for more than one assignments

destan40

Basic Pleskian
TITLE:
Migration DB Username than has more then one assignments dont work
PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE:
Plesk 17.8.11, CentOS, cPanel
PROBLEM DESCRIPTION:
Problem1
I tried to localy to migrate a user from cPanel
case example:

Systemusername: user589
Databases: user579_db1, user579_db2
DB_User: user579_user
Assignments:
user579_user-> user579_db1
user579_user-> user579_db2
(One User assigned to two databases)

Problem after migrating:
user579_db1 have a assigned user=user579_user, Correct
user579_db2 have not assigned user, Not correct

Problem 2

Editing Migrated DB User Rights etc. not possible, because
Database user name is forced with beginning syntax "admin_" like:
admin_user579_user
STEPS TO REPRODUCE:
Migrating user from cpanel that have more then one databases and one user is assigned to many databases​
ACTUAL RESULT:
migrated databases have not assigned dbuser, so not usable​
EXPECTED RESULT:
assigning dbuser correctly​
ANY ADDITIONAL INFORMATION:
YOUR EXPECTATIONS FROM PLESK SERVICE TEAM:
Help with sorting out
 
Last edited:
This is Plesk limitation: it is not possible to assign one user to several databases, there are only 2 options:

1. Assign user to one db
2. Assign user to all databases
 
Back
Top