I had imported tables directly in ispconfig like client, domain,ftp_user, mail domain,mail_user, shell_user,sys_group,web_domain,web_backup,web_database I had missed the sys_user table, though I have a old backup, which doesn't have all sys_user so skipped importing it. after that I run Tools->resync. The issue I am facing is when I am adding a new client - it is always adding the client to group 0 and when I navigate to limit tab - it doesn't show the template. Though I have added the limit template. also when I try to delete it asks for confirmation, but it is not deleting the client. ispconfig version is 3.2.9 and ubuntu server is 18.04
In general, it does not work if you import just some tables, as many of them depend on each other. Also, the resync tool exists to update an existing server configuration after you change some values in the database, it is not a tool to recreate a whole system from scratch just from the database. Parts of the config, like Linux system user UIDs, are stored in /etc/passwd only, so when you run resync on an empty system where you just imported some tables of another ispconfig system into the dbispconfig database, you will get different Linux UIDs. Therefore you must always copy website users and groups from passwd, shadow, group and shadow file first, but be careful to copy just the relevant web and shell users of the sites and not all users and groups.
