Hi all, I updated my panel and all my remote servers to ISPConfig 3.2.11. Since, the red notification bubble "The following changes are not yet populated to all servers" is shown with a counter to "502" and the following content but the job queue is empty. How can we fix this issue or is it a bug ? Thanks, Yannick
It's unlikely that this is related to a bug. More likely the slave nodes are unable to connect to the master to fetch the changes. Run server.sh in debug mode on one of the affected slave nodes to see why it fails: https://www.faqforge.com/linux/debugging-ispconfig-3-server-actions-in-case-of-a-failure/
ok. I found an old server that always was in the server list. After I removed it, the counter show "254" instead of "502" and I found another node that have error in the replication. Code: WARNING - Falsche Anfrage / Wrong QuerySQL-Query = REPLACE INTO `spamfilter_policy` (`id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`policy_name`,`virus_lover`,`spam_lover`,`banned_files_lover`,`bad_header_lover`,`bypass_virus_checks`,`bypass_spam_checks`,`bypass_banned_checks`,`bypass_header_checks`,`spam_modifies_subj`,`virus_quarantine_to`,`spam_quarantine_to`,`banned_quarantine_to`,`bad_header_quarantine_to`,`clean_quarantine_to`,`other_quarantine_to`,`spam_tag_level`,`spam_tag2_level`,`spam_kill_level`,`spam_dsn_cutoff_level`,`spam_quarantine_cutoff_level`,`addr_extension_virus`,`addr_extension_spam`,`addr_extension_banned`,`addr_extension_bad_header`,`warnvirusrecip`,`warnbannedrecip`,`warnbadhrecip`,`newvirus_admin`,`virus_admin`,`banned_admin`,`bad_header_admin`,`spam_admin`,`spam_subject_tag`,`spam_subject_tag2`,`message_size_limit`,`banned_rulenames`,`policyd_quota_in`,`policyd_quota_in_period`,`policyd_quota_out`,`policyd_quota_out_period`,`policyd_greylist`,`rspamd_greylisting`,`rspamd_spam_greylisting_level`,`rspamd_spam_tag_level`,`rspamd_spam_tag_method`,`rspamd_spam_kill_level`) VALUES ('2','1','0','riud','riud','r','Uncensored','Y','Y','Y','Y','N','N','N','N','N',NULL,NULL,NULL,NULL,NULL,NULL,'3.00','999.00','999.00',NULL,NULL,NULL,NULL,NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'-1','24','-1','24','N','n','999.00','999.00','rewrite_subject','999.00') -> 1265 (Data truncated for column 'warnvirusrecip' at row 1) 13.09.2023-10:13 - ERROR - Replication of datalog_id: 45752 failed. Error: (spamfilter_policy) in MySQL server: (localhost) Data truncated for column 'warnvirusrecip' at row 1 # SQL: REPLACE INTO ?? (??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??,??) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Seems as if there is an invalid value for warnvirusrecip in that record. Try to skip that record by increasing the value by 1 in the field 'updated' in the 'server' table for the affected server.
I truncated this table to force update the content but no success. I increased the updated counter but same error. On another server, describe on spamfilter_policy give: Code: | warnvirusrecip | enum('N','Y') | YES | | N | | on this server, decribe give: Code: | warnvirusrecip | enum('N','Y') | NO | | N | | Maybe a sql schema update is not correctly passed on this server. Note : The concerned node is not a mail server, only a web (with db) server.
Which table did you truncate? Truncationg tables in ISPConfig is generally not a good idea as this can halt updates for the server, also data will not get repopulated when you truncate it. You can compare the schema with the one found in install/sql/ispconfig3.sql file of the ISPConfig tar.gz file.
spamfilter_policy on the node server. `warnvirusrecip` enum('N','Y') default 'N', so that seems to be correct. I also re-insert data in the table spamfilter_policy from ispconfig.sql with no problem. So schema and existing data is not the problem. Is it possible that the data from the master (panel) could not be correctly formated ?
Ok, so the best solution is probaly to skip the record by increasing the ID, then look up the record in master database with e.g. phpmyadmin and set a valid value for this field.
On the master db : Code: MariaDB [dbispconfig]> select id,warnvirusrecip from spamfilter_policy; +----+----------------+ | id | warnvirusrecip | +----+----------------+ | 1 | N | | 2 | | | 3 | | | 4 | | | 5 | | | 6 | | | 7 | | +----+----------------+ 7 rows in set (0,000 sec) So, I update all the entry with 'N' Code: MariaDB [dbispconfig]> update spamfilter_policy set warnvirusrecip='N'; Query OK, 6 rows affected (0,001 sec) Rows matched: 7 Changed: 6 Warnings: 0 Code: MariaDB [dbispconfig]> select id,warnvirusrecip from spamfilter_policy; +----+----------------+ | id | warnvirusrecip | +----+----------------+ | 1 | N | | 2 | N | | 3 | N | | 4 | N | | 5 | N | | 6 | N | | 7 | N | +----+----------------+ 7 rows in set (0,000 sec) but the same error Code: Error: (spamfilter_policy) in MySQL server: (localhost) Data truncated for column 'warnvirusrecip' at row 1
No, it's now 45753 because I have updated the 'updated' field in the server database. but the content of the replication request seems to be similar (the value is always '') Maybe, I have try also to update the 'updated' field in the server table on the master database but same problem...
This means you have more records with the same issue in the datalog, increase the updated column by one to skip these records or set updated to max datalog_id value from sys_datalog table to skip all pending config changes (but this can cause configs to be incomplete or missing, so better skip one by one unless it are too many).
Hello, I have the same problem. It's a debian10 buster with the newest version of ispconfig. I get the following debug output: root@server:/# /usr/local/ispconfig/server/server.sh 20.09.2023-14:16 - WARNING - There is already a lockfile set, but no process running with this pid (14855). Continuing. ▒▒Link: /usr/local/ispconfig/server/mods-available/client_module.inc.phpPHP Fatal error: Uncaught Error: Class 'client_module' not found in /usr/local/ispconfig/server/lib/classes/modules.inc.php:68 Stack trace: #0 /usr/local/ispconfig/server/server.php(170): modules->loadModules('') #1 {main} thrown in /usr/local/ispconfig/server/lib/classes/modules.inc.php on line 68 something not OK with the "client_module" and I have no idea what to do now.
First, your problem differs from this thread as you do not have an issue with data in spam filter policies. It would have been better if you would have made a separate thread. Check if the client_module.inc.php on your system is identical to this one: https://git.ispconfig.org/ispconfig...p/server/mods-available/client_module.inc.php
This is the outcome of the debug because the couter on the web UI doesn't work. As the clients management too. That's why I tried to get help here. Thanks for that link, I will try. //tried to change it and still the same//
Seems it does work. It shows the number of unfinished jobs, and that is what it is supposed to do. What did you try to change? Were you able to change it? The problem seems to be in PHP, Code: Link: /usr/local/ispconfig/server/mods-available/client_module.inc.phpPHP Fatal error: Uncaught Error: Class 'client_module' not found in Have you modified any file in ISPConfig? Have you installed or uninstalled any PHP packages in the OS?
