Unable to open "FTP Access" in Plesk Control panel: Service node is unknown for sysuser with id=4

Created:

2016-11-16 12:49:51 UTC

Modified:

2016-12-21 19:19:22 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to open "FTP Access" in Plesk Control panel: Service node is unknown for sysuser with id=4

Symptoms

When I open the FTP Access from the Website & Domains tab, the following error appear:

    Service node is unknown for sysuser with id=4

Cause

The issue caused by the inconsistency in the psa database.

Resolution

  1. Create a dump of the psa database:

    mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa > psa.`date "+%Y-%m-%d_%H:%M"`.sql
  2. Find sys_user with id=4:

    mysql> select * from sys_users where id=4;
    +----+---------------+----------+------------+-----------+--------------------------+------------+-------+
    | id | serviceNodeId | login | account_id | mapped_to | home | shell | quota |
    +----+---------------+----------+------------+-----------+--------------------------+------------+-------+
    | 4 | 0 | test.tld | 7 | NULL | /var/www/vhosts/test.tld | /bin/false | 0 |
    +----+---------------+----------+------------+-----------+--------------------------+------------+-------+

    mysql> select * from ServiceNodes;
    +----+-------------+-----------+-----------+-----------+------------+-------+
    | id | description | transport | ipAddress | accessKey | externalId | type |
    +----+-------------+-----------+-----------+-----------+------------+-------+
    | 1 | local | local | local | NULL | | plesk |
    +----+-------------+-----------+-----------+-----------+------------+-------+
  3. Update column serviceNodeId for sys_user with id=4:

    mysql> update sys_users set serviceNodeId=1 where id=4;
    Query OK, 1 row affected (0.03 sec)
Have more questions? Submit a request
Please sign in to leave a comment.