The following changes are not yet populated to all servers since update 3.2.11

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

 

how can I determine which nodes are concerned ?

 

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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

 

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.

 

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 ?

 

in the replication sql command, the value for warnvirusrecip is '' so not null and not is the enum

 

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...

 

Please, up.

 

ok. fix after the 45757...
Thanks a lot.

 

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.

 

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?