Articles in this section

Unable to Login or manage subscription in Plesk: Unable to find row by field login with value username in the smb_users table

Plesk for Linux kb: technical ABT: Group B

Applicable to:

  • Plesk for Linux

Symptoms

  • Unable to login at Plesk with user admin. The following error is shown:

    CONFIG_TEXT: Unable to find row by field login with value admin in smb_users table.

  • Unable to manage a subscription at Plesk > Subscriptions > example.com. The following error is shown:

    CONFIG_TEXT: Unable to find row by field login with value username in the smb_users table

  • The following MySQL query gives an empty output:

    CONFIG_TEXT: mysql> SELECT smb_users.* FROM smb_users WHERE (login = 'admin');
    Empty set (0.01 sec)

Cause

Database inconsistency: User information is not recorded in psa database.

Resolution

In case Plesk 'admin' user is affected and Plesk user interface is available:
  1. Log into Plesk;
  2. Go to My Profile (left-hand side) > Profile & Preferences;
  3. Click OK:

    admin.PNG

In case Plesk 'admin' user is affected but Plesk login is unavailable:
  1. Log in to the server through SSH;
  2. Execute:

    # /usr/local/psa/bin/init_conf -u -name Admin

In case a customer is affected:
  1. Log into Plesk;
  2. Go to Customers > jdoe > Add description.
  3. Modify the description with any changes. Revert the changes if required:

    customer.PNG

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.