Change site's owner (customer)

hi guys
how can I change the already made site from one customer to another customer?

thanks

 

That's not possible yet.
You have to delete the site (also from the recycle bin) and re-create it under the other customer.

 

how about modify it directly in mysql? which records? because recreating 15 sites it is really headache

 

I'll try to make a backup and change it so at least I can go back to previous settings

 

I am looking to do the same thing.

I noticed that the previous reply was some time ago... is there an easier way yet?

I am quite comfortable in the database making modifications, but want to make sure I get everything correct (as I have 50 domains on my box and I'd hate to hose it all up).

Thanks in advance!

On a alternative note: if I delete the domain to recreate it, will it also delete the user's email and web files? If not, that will work too.

 

Tell me if I am wrong? Have I forgot something?

I just changed the owner of the site...

My notes - Changing the customer of already created site:

1) Therefore, I titled the new site on the selected customer to 'test.com';

SELECT * FROM `isp_nodes` AS a
JOIN `isp_isp_web` AS b ON a.doc_id = b.doc_id AND a.doctype_id = b.doctype_id
WHERE a.title = 'test.com'

So, now I know the wanted user/groupid
userid = 6, and groupid = 2
​

2) Change the owner for the website (table isp_nodes).

SELECT * FROM `isp_nodes` AS a WHERE a.title = 'wantedsite.com'
(found that doc_id = 19 and doctype_id = 1013)
Update is below in one sql command.

​

Change the users (table isp_isp_user).

SELECT * FROM `isp_isp_user` AS a WHERE a.user_username LIKE 'wantedsite.com_%'
(found that i have two users: doc_id = 48 and doctype_id = 1014
doc_id = 51 and doctype_id = 1014)
Update is below in one sql command.
​

And the same for domains (table isp_isp_domain):

SELECT * FROM `isp_isp_domain` AS a WHERE a.domain_domain = 'wantedsite.com'
(found that doc_id = 22 and doctype_id = 1015)

Update is below in one sql command.

​

Now check for dependecies:

website: SELECT * FROM `isp_nodes` WHERE doc_id = 19 AND doctype_id = 1013
users: SELECT * FROM `isp_nodes` WHERE doc_id IN (48,51) AND doctype_id = 1014
domains: SELECT * FROM `isp_nodes` WHERE doc_id = 22 AND doctype_id = 1015
​

And update everything:

UPDATE `isp_nodes` SET userid = 6, groupid = 2 WHERE
(doc_id = 19 and doctype_id = 1013) OR
(doc_id IN (48,51) AND doctype_id = 1014) OR
(doc_id = 22 AND doctype_id = 1015)
​

3) Show everything: SELECT * FROM `isp_dep` WHERE parent_doc_id = 19 AND parent_doctype_id = 1013
and i found out that I have and database: id = 15, doctype_id = 1029

Do not do this: UPDATE `isp_dep` SET userid = xxx WHERE parent_doc_id = xxxx
But no! This seems that has no effect! So revert... Do nothing in this table, considering the userid or groupid.

At last, I found it:
You must change the parent tree_id (easiest from hover on ispconfig tree) and doc_id (from table isp_isp_kunde):

SELECT * FROM `isp_dep` WHERE child_doc_id = 19 AND child_doctype_id = 1013
UPDATE `isp_dep` SET parent_doc_id = 4, parent_tree_id = 158 WHERE child_doc_id = 19 AND child_doctype_id = 1013
​

The problems and dilemas are:

Have I forgotten something? That will pop-up as a problem later?
Are there any changes needed in 'dns_nodes' or 'dns_dep' tables?
Nothing else to change?

NOTE: Site names, or any other data here shown is fictional (but has sense)

 

C'mon guys!

I just tought that I am stupid...
But it's more - the naming of a tool is INCREDIBLE!

I'am not MOVING SITE anywhere, just CHANGING OWNER.

This is why I did not try this function, ever!
Specially because it is in steps, and I never had a courage to go to step two!

But, for everybody:

Tools -> Move Websites
means
Tools -> Change Ownership

Anyway, YOU ARE REALLY FAST!
100% percent perfect! Just write a little more intuitive interfaces...

 

I want to move a site that was accidentally set up without being assigned to a client.

The Move Websites page shows it as not belonging to an a client, but it won't offer me any clients in the drop-down list of clients to transfer it to.

Any suggestions?

 

How did you manage to set up a web site without a client? That should not be possible. Maybe something's wrong with your database...

 

I have no idea. There is a client, but the site is not associated with him. I thought it had belonged to the client, but it seems not to now. The website is really not important: only a simple holding page. They only use the domain name for email.

I wondered if it would make sense to remove the codomain (there are two domain names) and add that as a site for the client, then make the existing site a codomain of that. But how can I copy any mail across without losing it?

 

You can't...

 

Is it possible to move the Customer, Sites or DNS zones between resellers?

 

Tools menu?

Hmmm. I'm running version 2.2.1.
In my tools menu, I don't see this option.
Will upgrading to the latest version make this option appear?

TIA,
Matt