DSM : New extension can't be enabled

Hi,

I ve got some new.

Found in centreon-web.log

[2025-02-14T15:12:53+01:00] ERROR : Error disabling pool(s) in DB | {"context":{"default":{"back_trace":{"file":"/usr/share/centreon/www/modules/centreon-dsm/core/configuration/services/DB-Func.php","line":286,"class":null,"function":null},"request_infos":{"url":"/centreon/main.get.php?p=50711","http_method":"POST","server":"srv-mon","referrer":"https://srv-mon/centreon/main.get.php?p=50711"}},"exception":{"exception_type":"CentreonDbException","file":"/usr/share/centreon/www/class/centreonDB.class.php","line":291,"code":11,"message":"Error while executing the prepared query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'pool_activate' at row 1","options":{"exception_type":"CentreonDbException","code":11,"message":"Error while executing the prepared query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'pool_activate' at row 1","file":"/usr/share/centreon/www/class/centreonDB.class.php","line":291,"class":"CentreonDB","method":"executePreparedQuery","query":"    UPDATE mod_dsm_pool\n    SET pool_activate = 0\n    WHERE pool_id = :pool_id","pdo_error_code":"01000","pdo_error_infos":["01000",1265,"Data truncated for column 'pool_activate' at row 1"]},"previous":{"exception_type":"CentreonDbException","file":"/usr/share/centreon/www/class/centreonDB.class.php","line":291,"code":11,"message":"Error while executing the prepared query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'pool_activate' at row 1","options":{"exception_type":"CentreonDbException","code":11,"message":"Error while executing the prepared query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'pool_activate' at row 1","file":"/usr/share/centreon/www/class/centreonDB.class.php","line":291,"class":"CentreonDB","method":"executePreparedQuery","query":"    UPDATE mod_dsm_pool\n    SET pool_activate = 0\n    WHERE pool_id = :pool_id","pdo_error_code":"01000","pdo_error_infos":["01000",1265,"Data truncated for column 'pool_activate' at row 1"]}}},"custom":{"pool_id":"58","pool_arr":{"58":"1"}}}}
[2025-02-14T15:12:53+01:00] ERROR : Error updating pool with ID: 58 | {"context":{"default":{"back_trace":{"file":"/usr/share/centreon/www/modules/centreon-dsm/core/configuration/services/DB-Func.php","line":954,"class":null,"function":null},"request_infos":{"url":"/centreon/main.get.php?p=50711","http_method":"POST","server":"srv-mon","referrer":"https://srv-mon/centreon/main.get.php?p=50711"}},"exception":{"exception_type":"CentreonDbException","file":"/usr/share/centreon/www/class/centreonDB.class.php","line":291,"code":11,"message":"Error while executing the prepared query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'pool_activate' at row 1","options":{"exception_type":"CentreonDbException","code":11,"message":"Error while executing the prepared query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'pool_activate' at row 1","file":"/usr/share/centreon/www/class/centreonDB.class.php","line":291,"class":"CentreonDB","method":"executePreparedQuery","query":"    UPDATE mod_dsm_pool\n    SET pool_activate = 0\n    WHERE pool_id = :pool_id","pdo_error_code":"01000","pdo_error_infos":["01000",1265,"Data truncated for column 'pool_activate' at row 1"]},"previous":{"exception_type":"CentreonDbException","file":"/usr/share/centreon/www/class/centreonDB.class.php","line":291,"code":11,"message":"Error while executing the prepared query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'pool_activate' at row 1","options":{"exception_type":"CentreonDbException","code":11,"message":"Error while executing the prepared query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'pool_activate' at row 1","file":"/usr/share/centreon/www/class/centreonDB.class.php","line":291,"class":"CentreonDB","method":"executePreparedQuery","query":"    UPDATE mod_dsm_pool\n    SET pool_activate = 0\n    WHERE pool_id = :pool_id","pdo_error_code":"01000","pdo_error_infos":["01000",1265,"Data truncated for column 'pool_activate' at row 1"]}}},"custom":{"pool_id":"58","pool_name":"SRV-GB2-SVG05_SLOTS_VEEAM","pool_prefix":"Veeam-Slot-"}}}
[2025-02-14T15:12:53+01:00] ERROR : while managing a pool : Internal Error, contact your administrator for more information | {"context":{"default":{"back_trace":{"file":"/usr/share/centreon/www/modules/centreon-dsm/core/configuration/services/formSlot.php","line":213,"class":null,"function":null},"request_infos":{"url":"/centreon/main.get.php?p=50711","http_method":"POST","server":"srv-mon","referrer":"https://srv-mon/centreon/main.get.php?p=50711"}},"exception":{"exception_type":"CentreonDbException","file":"/usr/share/centreon/www/class/centreonDB.class.php","line":291,"code":11,"message":"Error while executing the prepared query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'pool_activate' at row 1","options":{"exception_type":"CentreonDbException","code":11,"message":"Error while executing the prepared query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'pool_activate' at row 1","file":"/usr/share/centreon/www/class/centreonDB.class.php","line":291,"class":"CentreonDB","method":"executePreparedQuery","query":"    UPDATE mod_dsm_pool\n    SET pool_activate = 0\n    WHERE pool_id = :pool_id","pdo_error_code":"01000","pdo_error_infos":["01000",1265,"Data truncated for column 'pool_activate' at row 1"]},"previous":{"exception_type":"CentreonDbException","file":"/usr/share/centreon/www/class/centreonDB.class.php","line":291,"code":11,"message":"Error while executing the prepared query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'pool_activate' at row 1","options":{"exception_type":"CentreonDbException","code":11,"message":"Error while executing the prepared query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'pool_activate' at row 1","file":"/usr/share/centreon/www/class/centreonDB.class.php","line":291,"class":"CentreonDB","method":"executePreparedQuery","query":"    UPDATE mod_dsm_pool\n    SET pool_activate = 0\n    WHERE pool_id = :pool_id","pdo_error_code":"01000","pdo_error_infos":["01000",1265,"Data truncated for column 'pool_activate' at row 1"]}}},"custom":null}}
 

Can you explain me what is happening?

Thanks.

Hello,

I’ve been able to enable extension by modifying dabase

Dsm seems to be ok but can’t find host : 

2025-02-19 16:42:45 - DEBUG - 50200 - Agent dns name: srv-
2025-02-19 16:42:45 - DEBUG - 50200 - Ent Value 0 ($1): .1.3.6.1.4.1.31023.1.1.101=ef55a0ff-503f-4d4e-ab4d-411016cfced6
2025-02-19 16:42:45 - DEBUG - 50200 - Ent Value 1 ($2): .1.3.6.1.4.1.31023.1.1.102=BACKUP_VM
2025-02-19 16:42:45 - DEBUG - 50200 - Ent Value 2 ($3): .1.3.6.1.4.1.31023.1.1.103=Failed
2025-02-19 16:42:45 - DEBUG - 50200 - Ent Value 3 ($4): .1.3.6.1.4.1.31023.1.1.104=
2025-02-19 16:42:45 - DEBUG - 50200 - Trap digest: 9ae2e0378a490db51f19f0bf4756bcc5
2025-02-19 16:42:45 - DEBUG - 50200 - Cant find a host. Request: SELECT host_id, host_name FROM host WHERE host_address = 'srv-’ OR host_address='10.'
2025-02-19 16:42:45 - DEBUG - 50200 - Cant find a host. Request: SELECT host_id, host_name FROM host WHERE host_address = 'srv-' OR host_address='10.'
 

But when i make request into DB, it find my host. Have you got an idea?

Regards.

Hello,

nous avions le même souci en 23.10

essaie ça:

/usr/share/centreon/www/modules/centreon-dsm/core/configuration/services/DB-Func.php aux lignes 190 et 257 met des quotes aux valeurs.

Ex: SET pool_activate = '0'

Nous avons aussi modifié pas mal de chose dans le code PHP qui nous affichait une page blanche, tu sembles dans le cas de figure light.
Test et tiens moi au courant.