DNS settings are not visible for a user

Created:

2016-12-12 03:40:27 UTC

Modified:

2017-08-08 13:30:36 UTC

0

Was this article helpful?


Have more questions?

Submit a request

DNS settings are not visible for a user

Applicable to:

  • Plesk 12.5 for Windows

Symptoms

A newly created user cannot see DNS Settings in hosting panel.The user role is granted "manage DNS" permission, but this permission is set to false in subscription properties:

mysql> SELECT `Permissions`.* FROM `Permissions` AS `Permissions` WHERE (`id` = '4') and permission='manage_dns';
+----+------------+-------+

| id | permission | value |
+----+------------+-------+

| 4 | manage_dns | false |
+----+------------+-------+

Cause

Plesk database inconsistency.

Resolution

  1. Define the domain ID:

    mysql> select id from domains where name='example.com';
    +----+
    | id |
    +----+
    | 2 |
    +----+
    1 row in set (0.00 sec)
  2. Define the subscription ID:

    mysql> select id from Subscriptions where object_id=2 and object_type='domain';
    +----+
    | id |
    +----+
    | 2 |
    +----+
    1 row in set (0.00 sec)
  3. Define permissions ID:

    mysql> select * from SubscriptionProperties where name='permissionsId' and subscription_id=2;
    +-----------------+---------------+-------+
    | subscription_id | name | value |
    +-----------------+---------------+-------+
    | 2 | permissionsId | 4 |
    +-----------------+---------------+-------+
    1 row in set (0.00 sec)
  4. Check the manage_dns permission:

    mysql>  SELECT `Permissions`.* FROM `Permissions` AS `Permissions` WHERE (`id` = '4') and permission='manage_dns';
    +----+------------+-------+
    | id | permission | value |
    +----+------------+-------+
    | 4 | manage_dns | true |
    +----+------------+-------+
    1 row in set (0.00 sec)
  5. Set the permission to true :

    mysql> update Permissions set value='true' where permission='manage_dns' and id=4;
Have more questions? Submit a request
Please sign in to leave a comment.