Applicable to:
- Plesk Onyx
Symptoms
When the subscription owner (for example johndoe) was changed to admin, the new owner is not able to see subscription's additional users (for example, johndoeuser@example.com) in the Plesk UI at the PowerUser View > Users page.
Cause
This is a Plesk bug PPPM-9282 that will be fixed in future product updates.
Resolution
There are several ways for a workaround:
- Remove the user "johndoeuser@example.com" from the customer "johndoe"
- Create the user "johndoeuser@example.com" for the admin
-
Get the list of all subscriptions which does not belong to admin:
MYSQL_LIN: mysql> select name, displayName, cl_id from domains where webspace_id=0 and cl_id <> 1;
+-------------+-------------+-------+
| name | displayName | cl_id |
+-------------+-------------+-------+
| example.com | example.com | 6 |
+-------------+-------------+-------+ -
Find the user account in
psa.smb_users
table which belongs to the required client:MYSQL_LIN: mysql> select id, login, contactName, roleId, ownerId from smb_users where ownerId=6;
+----+----------+-------------+--------+---------+
| id | login | contactName | roleId | ownerId |
+----+----------+-------------+--------+---------+
| 4 | johndoe | johndoe | 26 | 6 |
+----+----------+-------------+--------+---------+
1 row in set (0.00 sec)where "6" is "domains.cl_id" of the required user from step #3
-
Change the user owner to admin:
MYSQL_LIN: mysql> update smb_users set ownerId = 1 where id = 4;
where "4" is "smb_users.id" of the required user
-
Update the "fileSharingUsers" table in order to avoid database inconsistency:
MYSQL_LIN: mysql> insert into fileSharingUsers values ('', 4, 'johndoeuser@example.com', 'NULL');
-
Assign the user to the required role in Subscriptions > example.com > Users > User Roles or change the owner of this role from customer to admin via CLI:
# plesk bin user --update johndoeuser@example.com -owner admin
SUCCESS: User was successfully updated.Note: admin is unable to have two roles with the same name
-
Find the required user account in the "smb_users":
MYSQL_LIN: mysql> select id, login, contactName, roleId, ownerId from smb_users where ownerId=2;
+----+----------+-------------+--------+---------+
| id | login | contactName | roleId | ownerId |
+----+----------+-------------+--------+---------+
| 4 | johndoe | johndoe | 26 | 1 |
+----+----------+-------------+--------+---------+ -
Find the role name:
MYSQL_LIN: mysql> select * from smb_roles where id=26;
+----+----------+-----------+---------+----------------------+
| id | name | isBuiltIn | ownerId | isActivationRequired |
+----+----------+-----------+---------+----------------------+
| 26 | somerole | 0 | 6 | 0 |
+----+----------+-----------+---------+----------------------+where "26" is the role "id"
-
Check if admin has the role with the same name:
MYSQL_LIN: mysql> select * from smb_roles where OwnerId=1;
+----+--------------------+-----------+---------+----------------------+
| id | name | isBuiltIn | ownerId | isActivationRequired |
+----+--------------------+-----------+---------+----------------------+
| 1 | Admin | 1 | 1 | 0 |
| 2 | WebMaster | 0 | 1 | 0 |
| 3 | Application User | 0 | 1 | 0 |
| 4 | Accountant | 1 | 1 | 0 |
+----+--------------------+-----------+---------+----------------------+ -
If such role does not exist, change the owner to the admin:
MYSQL_LIN: mysql> update smb_roles set ownerId=1 where id=26;
Comments
0 comments
Please sign in to leave a comment.