Some customers do not have Manage Hosting button

Refers to:

  • Plesk for Linux

Created:

2016-11-16 12:42:47 UTC

Modified:

2016-12-21 19:02:13 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Some customers do not have Manage Hosting button

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.