Hi, I have a problem with changing website owner. I have a resseller (name AA) who create client (AAB). Client AAB on his account create 2 sites: - site one: site+db+ftpaccount - site two: site + ftpaccount How to migrate all resources from AAB to client (name C)? Client C was created by admin. When I (Admin) try to change owner for sites, then sites are visible on client C account but.... client AAB see his sites too. Question is: how to move all sites, db, ftp accounts from AAB to C. Finaly I want to delete AAB account. ISP version: ISPConfig 3.1.13 in multiserver config.
Try resync after you have reassign the websites. I think it will fix the access issue after it finished with the resync.
Alternative way is to create the websites,databases and FTP-accounts etc. for client C, and then move the files from AAB to C and dump and import the databases.
ISPConfig currently changes only the 'owner' of the site, which is the group (sys_grouo), and not the creator (sys_user), which is the user. Therefore the 'old' creator has still access to the site. We should definitely change that in the future.
Hi, thank you for all reply. Migration with moving file is time-consuming process. Resync after changing owner does not resolve problem. Have you an info, where in mysql change data? (sys_group), (sys_user), but it is not all.
hmm. but what about path to directory on server and change owner to file? When I change sys_user, owner for file will be changed?
The only thing that does not get changed is the ID of the creator of the site within the ispconfig database. This ID is not used in any paths and it is not used for any file ownerships.
Hi, In client table, I dont have sys_user column: sys_userid | int(11) unsigned | NO | | 0 | | | sys_groupid | int(11) unsigned | NO | | 0 | | | sys_perm_user | varchar(5) | YES | | NULL | | | sys_perm_group | varchar(5) | YES | | NULL | | | sys_perm_other | varchar(5) | YES | | NULL Why sys_userid are not unique? MariaDB [dbispconfig]> select sys_userid, client_id ,sys_groupid, username from client; +------------+-----------+-------------+-------------+ | sys_userid | client_id | sys_groupid | username | +------------+-----------+-------------+-------------+ | 13 | 11 | 0 | A | | 5 | 5 | 5 | AAB | | 1 | 3 | 1 | B| | 1 | 4 | 1 | G | | 5 | 7 | 5 | F | | 5 | 8 | 5 | E | | 1 | 9 | 1 | D | | 1 | 10 | 1 | C | +------------+-----------+-------------+-------------+ Which value I need to change?
This is issue not about the client table, the client table does not has to be altered. You have to alter the record of the items that shall not be accessible like the website in the web_domain table and the column is sys_userid.
