Hi,
The first section works. I am sure the other sections do also but haven't tried them yet...just from some notes I had.
SSH into the server as root and log into the psa database via the mysql client
mysql -u admin -p`cat /etc/psa/.psa.shadow` psa
You must end every MySQL command with a ; The line -> is saying that the
command is not a complete command.
Identify the client ID of the client you create in psa.
The client ID is stored in the clients table:
mysql> select * from clients;
The domain ID is stored in the domains table:
mysql> select * from domains;
Once you have the ID's, you need to do the following:
update domains set cl_id = 8 where id = 16;
(I derived the 16 by doing a select on domains and finding the 2cheer4.com domain).
Pooof... the domain is now owned by the new client.
FROM PLESK FAQ'S:
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:
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
==========================================================
FROM FORUMS:
http://forum.sw-soft.com/showthread.php?s=&threadid=17873
Please use a official Plesk CLI (/usr/local/psa/bin/domain.sh)
It is capable of correct switching domain to different client:
/usr/local/psa/bin/domain.sh -u <domain> -clogin <client_login>