Cobra Forum

Question:
Unable to access Plesk GUI : Dependent row(s) 'smb_roles.id = 1' isn't found for 'smb_users.roleId = 1'

Symptoms

• Unable to access Plesk GUI with the following error:

QuoteInternal error: Dependent row(s) 'smb_roles.id = 1' isn't found for 'smb_users.roleId = 1'.
Message Dependent row(s) 'smb_roles.id = 1' isn't found for 'smb_users.roleId = 1'.
File Abstract.php
Line 206

• Plesk has been installed recently.
• The following errors can be found in /var/log/plesk/install/autoinstaller3.log file:

Installing: psa-selinux-17.5.3-cos7.build1705170314.17.noarch [298/302]
semodule: relocation error: semodule: symbol semanage_module_info_get_version, version LIBSEMANAGE_1.1 not defined in file libsemanage.so.1 with link time reference
Cause
This is a Plesk bug with ID PPPM-6451.

Resolution
Until the bug will be fixed, apply the following workaround:

1.Log into the server via SSH.

2.Create a backup for psa database:
#plesk db dump psa > /root/psa.sql
3.Execute the commands below one by one to insert missed records in psa database:
#plesk db "INSERT INTO smb_roles VALUES (1,'Admin',1,1,0),(2,'WebMaster',0,1,0),(3,'Application User',0,1,0),(4,'Accountant',1,1,0);"

#plesk db "UPDATE smb_users SET ownerId=1;"