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:

  external 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;"