Article ID: 142, created on Oct 6, 2008, last review on May 4, 2014

  • Applies to:
  • Plesk 5.x

Resolution

Currently there is no feature in PSA that switches domain ownership between clients. All of the following steps are made from command line.

If a domain is going to be owned by a new client, before continuing, make sure the new client is added to PSA.

The [client id] parameter for the update query is for the new owner of the domain, and can be obtained by executing the following command while logged in as a root:

Standard build:

/usr/local/psa/mysql/bin/mysql -u admin -p`cat /etc/psa/.psa.shadow` -e "SELECT cname, pname, login, id from clients WHERE login = '[psa client login]';" psa

RPM build:

/usr/bin/mysql -u admin -p`cat /etc/psa/.psa.shadow` -e "SELECT cname, pname, login, id from clients WHERE login = '[psa client login]';" psa

This command retrieves the company name, client name, login and client id, and may be piped to a file by adding >[filename] after it. After you have retrieved client's id, execute the following command:

Standard build:

/usr/local/psa/mysql/bin/mysql -u admin -p`cat /etc/psa/.psa.shadow` -e "UPDATE domains SET cl_id = [client id] WHERE name = '[domain name]';" psa

RPM build:

/usr/bin/mysql -u admin -p`cat /etc/psa/.psa.shadow` -e "UPDATE domains SET cl_id = [client id] WHERE name = '[domain name]';" psa

This should successfully complete the transfer.

5778c2b4a3885c30396ddfa598ae90e9 29d1e90fd304f01e6420fbe60f66f838 a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF