1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

sys User Problems

Discussion in 'Plesk for Linux - 8.x and Older' started by Jasper_Grimbo, Dec 19, 2006.

  1. Jasper_Grimbo

    Jasper_Grimbo Guest

    After a update from a subdomain i get a error.
    and now i can't go to the Domain window.

    The Plesk system is 8.1.0 with the newest updates.

    The Mysql psa database show me that the sysuser row haven't a user for the system. But a manuel edit have no result.

    what can i do ?
    it this a bug ?

         [I]ERRORPleskFatalException [/I

    Unable to create SysUser objectSysUserunable to selectno such row in the table

    : /usr/local/psa/admin/plib/class.DomainControlForm.php:174
    ->assign(object of type BsDomain)
    1: /usr/local/psa/admin/htdocs/domains/dom_ctrl.php3:147

    Thanks Jasper
  2. Nataliya Zagr

    Nataliya Zagr Regular Pleskian

    Apr 14, 2009
    Likes Received:
    Hello, Jasper

    To solve the issue, please, follow the steps:

    1) The sys_users record for the domain is missing. You need to find the SysUser id:
    mysql> select id from domains where name='domain.tld';

    2) Find the sysuser id (sys_user_id) for the mentioned domain:
    mysql> select * from hosting where dom_id=533

    3) Add the record into accounts table with the next to latest id:
    Find the latest id:
    mysql> select * from accounts order by id desc limit 3;
    Insert the record:
    mysql> insert into accounts values (latest_id,'plain','password');

    Note! you need to replace the latest_id with the id +1 you got at the previous query

    4) Add the values to the sys_users table:

    mysql> insert into sys_users values (v1,'login',v2,'/usr/local/psa/home/vhosts/domain.tld','/bin/false',0);

    where v1 is the sys_user_id you found at the (2) step
    v2 is the latest id you have inserted at the (3) step

    This will recreate the missing user.
    Please, note that it is highly recommended to backup the psa database befory and changes performed.