Trouble after migrating to multi server setup

Hi
I just completed changing my ISPconfig setup from 1 server + 3 mirror dns servers, to setup:
controlpanel + main db
webserver1
mailserver1
mailserver2
dns1
dns2-3 mirrors of 1
Webmail server
Most things work well but I can not change sites every site comes with the error Please select a valid Server. Server ID must be > 0.
I also noted that even though I wanted webservers to have local database there is no site data in the webservers local database so i really have no idea how they work or how to set up an new web since it does error in contol panel and to my knowledge all

 

Servers were migrated using ISPconfig Migration tool, control panel first and then web, DNS and mail to their destinations.

 

It is enabled see table
Server
Name Mail Web DNS File DB
controlpanel No Yes No Yes Yes -- contol panel, master SQL
WEB1 No Yes No Yes Yes -- Main webserver
Mail1 Yes Yes No Yes Yes -- main mailsever
Mail2 Yes Yes No Yes Yes -- mirror of mail1
DNS1 No Nc Yes No Yes -- main DNS
DNS2 No No Yes No Yes -- mirror of dns1
DNS3 No No Yes No Yes -- mirror of dns1
DNS4 No No Yes No Yes -- mirror of dns1
Webmail No Yes No Yes Yes
WEB2 No Yes No Yes Yes -- mirror of WEB1

Database on web1 does not have site databases according to web1 phpmyadmin, still all sites are working and are configured to use localhost database.
If any change is made in websites on save we get this error Please select a valid Server. Server ID must be > 0.
Regards Stefan

 

Hi
I'm sorry how the table turned out but all servers seem to have yes in the right places.
I checked Server ID column in ispconfig database and it had 0 in every record maybe that is the culprit, I have how ever no idea if or how it would be sensible to change it.
Or does this belong in different thread?

 

Hi
Sorry fort the late reply, server_ID is 0 on all imported webs in controlpanels localhost - dbispconfig - web_domain
My main web server is server_ID 2, do you think that it is advisable to change the 0 to 2 on the imported web sites ?

 

I did a test and it seems to work, now it just forming the Query to fix the table, and figure out where to create the data base for all to work.

 

It seems to have gone wrong in Migration but changing sever_id fixed it, now I can manage web sites again.

 

Now since all sites claim to reside on the web server none of them reaches database since it does not replicate from control panel master database, how can I fix that, it should do that according to my understanding when using multi server setup.
Or do I need to export all db from min SQL to the webserver ?

 

This is ok form outside I got to figure out how to fix my internal network nating, sorry

 

data bases are still non exsistent on web servers SQL database server, they are on the control panels SQL DB server, I ho ever can't figure out how websites are serving the WordPress sites that reside on the web server and have their database host configured as localhost.
All webs on webserver show up from local networks with no data base connection but are ok coming from outside, there must be some logic in this that I'm missing.
Checked DBs using cli to be shure.

 

Hi, it has been quite eventful since my last post, once I resynced all tables dissappeared from both servers and all sites down.
I fortunately had them available few days old backup.
Since all CMS are set up for database host = locahost I read them into the web servers dbserver with out them coming up, once I read them into control panel dbserver they came in.
This is fully unrational behavior and frankly should not work this way.
I'm almost up again so once I get fully up I will have to figure out how it all works.

 

Hi
I'm finally operational for most part, I however can't get contol panel to create databases on web-server for webs, so I have to create the db in phpMyAdmin, db user seems to be OK, and now at least for new webs they are using web servers database server.
That leaves only creating database on other server left.
I also am not quite sure if all client databases have to exist on the main Database server on control panel server, I'm somewhat reluctant to have extra data that is possibly not current lying around where it does not belong.

 

Now it seems to be impossible to generate Let's encrypt certificate for web sites nothing happens on either server they only check own certificates acme log has no other requests.

 

Found out that SNI tick was missing in Web servers settings > web > SSL certificates are no generated