Hello,
In DSMD, existing extensions are working well.
But when i try to add some slots or when i try to add a new pool, extension is disabled and i get an error when i try to enable.
I can’t find anything on logs.
Can you help me to make it working?
Thanks.
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: SQLSTATEE01000]: Warning: 1265 Data truncated for column 'pool_activate' at row 1","options":{"exception_type":"CentreonDbException","code":11,"message":"Error while executing the prepared query: SQLSTATEE01000]: 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":i"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: SQLSTATEQ01000]: Warning: 1265 Data truncated for column 'pool_activate' at row 1","options":{"exception_type":"CentreonDbException","code":11,"message":"Error while executing the prepared query: SQLSTATEQ01000]: 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":e"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: SQLSTATEe01000]: Warning: 1265 Data truncated for column 'pool_activate' at row 1","options":{"exception_type":"CentreonDbException","code":11,"message":"Error while executing the prepared query: SQLSTATEe01000]: 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: SQLSTATEr01000]: Warning: 1265 Data truncated for column 'pool_activate' at row 1","options":{"exception_type":"CentreonDbException","code":11,"message":"Error while executing the prepared query: SQLSTATEr01000]: 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":0"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-"}}}
x2025-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":o"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: SQLSTATEn01000]: Warning: 1265 Data truncated for column 'pool_activate' at row 1","options":{"exception_type":"CentreonDbException","code":11,"message":"Error while executing the prepared query: SQLSTATEn01000]: 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":r"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.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
