Greetings, i have an ispconfig with 4 servers : web, db,mail and dns with debian 11. I am trying to add asecond dns server in the cluater with debian 12. After the installation i got this error : Replication of datalog_id: 12 failed. Error: (client) in MySQL server: (localhost) Unknown column 'limit_xmpp_webpresence' in 'field list' # SQL: REPLACE INTO ?? (??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?). I am trying to find the table name to add this column with no success. Any help would be appreciable . TY
There is no database field limit_xmpp_webpresence in current ISPConfig versions. is it possible that you installed a third-party xmpp plugin that created this field or that you extended ISPConfig yourself and added that field? In that case, you must add the same modifications on the new system as swell.
Does your master server has the field limit_xmpp_webpresence in the client database table in dbispconfig database?
As a workaround, create a field limit_xmpp_webpresence of type int, or if that does not work, use varchar. It should not matter much which column type it is as long as the value that get stored there fits, so varchar is ok as it's not used in the code later, but the replicate statement will work then.
The field limit_<something> suggests that it contains a value to limit a resource for a service within ISPConfig. Personally I don't know this exact field as well and it also doesn't exist in this form in the current ISPConfig codebase/SQL schema. So, I've got no idea how you - I suppose unintentionally (or not) - added this field. If you don't use XMPP then I would suggest to remove this field. Check all the client(_*) tables for presence of this column and drop it, also across the slaves in case you don't need it anymore. btw is this a fresh server multi-server setup, or is this one aged? I think you should manually consolidate the datalog records that contain this data and delete them, so that they not gonna get replicated anymore. If your multi-server setup is pretty old it may take some time to clean these records up, which also depends how you approach this situation. Best is to also have a look at the sys_datalog table on your master server I'm not sure if till agrees with that, but I think I would delete the datalog records that contains this orphaned data. The only thing that you should not do is to delete ALL datalog records! Just don't do that!
I have resolved the problem. It seems that all servers in the cluster mush have the same version of OS. The other servers all have debian 11 but the last server had debian 12. I make another VM with debian 11 and the installation goes smoothly. Thank you very much
