Some customers do not have Manage Hosting button

Created:

2016-11-16 12:42:47 UTC

Modified:

2017-04-24 12:14:26 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Some customers do not have Manage Hosting button

Applicable to:

  • Plesk for Linux

Symptoms

After the migration from Plesk 9.5 to Plesk 12, some customers do not have Manage Hosting button or link in Hosting Services > Customers section.

alttext

Cause

The issue is caused by database inconsistency.

Resolution

  1. First of all take a dump of Plesk database:

    # mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa > psa_db_dump_`date +%F`.sql
  2. Find out the id of affected customer:

    mysql> select id,pname from clients where pname='customer2.tld';
    +----+---------------+
    | id | pname |
    +----+---------------+
    | 4 | customer2.tld |
    +----+---------------+
    1 row in set (0.00 sec)
  3. Set correct cl_id value for customer2.tld domain in domains table

    mysql> update domains set cl_id=4 where name='customer2.tld';
    Query OK, 0 rows affected (0.60 sec)
    Rows matched: 1 Changed: 0 Warnings: 0

    After that Manage Hosting link appears for affected customer, but it throws an error:

    Internal error: Unable to find row by field login with value user_name in smb_users table.
    Message Unable to find row by field login with value user_name in smb_users table.
    File Abstract.php
    Line 173
    Type Db_Table_Exception
  4. In order to make Manage Hosting link working it is needed to update customer's password:

    • Open the customer in Plesk;

    • Click on Change Login Info ;

    • Set a new password.

After that Manage Hosting link will function fine.

Have more questions? Submit a request
Please sign in to leave a comment.