Internal error after entering license key: Dependent row(s) 'smb_roles.id = 1' isn't found for 'smb_users.roleId = 1'

Created:

2017-06-09 13:46:32 UTC

Modified:

2017-08-08 13:15:16 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Internal error after entering license key: Dependent row(s) 'smb_roles.id = 1' isn't found for 'smb_users.roleId = 1'

Symptoms

  • After installing Plesk Web Admin and entering license key, the following error message appears after login attempt:

    Internal 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
    Type Exception
    
  • During Plesk installation Apache could not be started with the following error:

    file: /usr/local/psa/admin/plib/Service/Driver/Web/Server/Apache.php
    line: 108
    code: 0
    Can not restart web server: Jun 09 16:00:13 example.com httpd[7249]: (13)Permission denied: AH00072: make_sock: could not bind to address [::]:7080
    Jun 09 16:00:13 example.com httpd[7249]: (13)Permission denied: AH00072: make_sock: could not bind to address 0.0.0.0:7080
  • The following errors can be found in /var/log/plesk/install/autoinstaller3.log:

    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
    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 Plesk bug with ID PPPM-6451 which is planned to be fixed in future Plesk updates. The issue is caused by the fact that libsemanage package is not updated to the latest version before installation.

Resolution

In order to fix the issue after installation perform the following:

  1. Insert the following values to psa database:

    # plesk db
    mysql> INSERT INTO `smb_roles` VALUES (1,'Admin',1,1),(2,'WebMaster',0,1),(3,'Application User',0,1),(4,'Accountant',1,1);
    mysql> UPDATE smb_users SET ownerId=1;
  2. Install psa-selinux package and SELinux policy for Plesk once again:

    # rpm -Uvh --force http://autoinstall.plesk.com/PSA_17.5.3/extras-rpm-CentOS-7-x86_64/opt/selinux/psa-selinux-17.5.3-cos7.build1705170314.17.noarch.rpm
    # semodule -v -i /usr/local/psa/etc/plesk.pp
Have more questions? Submit a request
Please sign in to leave a comment.