change client/owner/reseller

[jboud]

When i first started using the ISPC3 I inserted some clients through the admin user directly, so these clients don't belong to some reseller account. I've read around that there's no direct way of changing the reseller of a client, so I want to ask if the following example will serve me as a workaround.

client1 is the current owner of the domain.
reseller1 is the reseller I wish the client1 to belong to.
so I log as reseller1 and create another account for client1 called client11.
I log again as admin and change the website client owner from client1 to client11, so the website, database, dns, email move from the old client name to the new.
I delete the old client1 and hopefully it works.

Is this correct?
thx

[till]

Yes, that should work.

[Ovidiu]

I've got a similar question but the other way around:

I've got a reseller with about 10 clients who stopped paying so I was planning on deleting his reseller account which will move all his assets into the recycle bin, right?

Now most of his client know me and will contact me to rectify their problem so how do I go about enabling their assets, i.e. their client account with all sites, DBs, emails etc. without enabling the reseller account?

Basically, I need to move a client away from a reseller.

Any hints on how to perform this?

[jboud]

I would suggest the same way as I mentioned above.

Website1 belongs to Client1 which belongs to Reseller1
Create a Client2 that belongs to some other reseller (you should login as that reseller to make it easier)
Login back as an admin again and Change the owner of Website1 to Client2

I beleive that's the easiest way.

[Ovidiu]

Sounds logic but I'm sure one could change a field in the DB that holds the reseller info and simply "remove" a client from a reseller, which would be way less effort hence my question but if nobody can help me with that I guess I'm going with your solution :-)

[Ovidiu]

Nobody? No easier way?

The reason I'd love to avoid creating new clients then moving resources is that I might miss something :-(

what do I need to shift?

sites
DBs
DNS entries
email domains
email inboxes
email aliases?

anything else? what if I overlook something? will I end up with half of the resources owned by the old client and the other half by the new one?

[till]

1) Set the parent_client_id to 0 for all clients of this reseller in the "client" database table.
2) Edit the sys_user record of the reseller and remove the group ID's of all client groups from the "groups" column of the reseller.

[Ovidiu]

I can't seem to get this right:

- edited the client table, selected a client of a reseller, set his parent_client_id to 0
- edited the sys_user table selected the reseller, deleted the group of the above mentioned client from the groups column and changed the field: default_group to another one of his groups

Logged in as the reseller and he still sees the client I just tried to remove from his account.

Any other ideas?

[Ovidiu]

Am I missing something ehre? Any more instructions?

[Ovidiu]

Pretty please?