Hi @TeXmeX , can you check in you browser console if you have errors and in /var/log/php-fpm/centreon-error.log
Regards
Hi @Laurent ,
in browser console i have these errors :
GET https://cdn.eu.pendo.io/agent/static/b06b875d-4a10-4365-7edf-8efeaf53dfdd/pendo.js net::ERR_BLOCKED_BY_CLIENT
API Request <CustomFilters> decoder failed at key "result" with error: <CustomFilter> decoder failed at index "0" with error: <CustomFilter> decoder failed at key "criterias" with error: <FilterCriterias> decoder failed at index "6" with error: <FilterCriterias> decoder failed at key "value" with error: <FilterCriteriaValue> decoder failed because b"status_severity_code",null] can't be decoded with any of the provided oneOf decoders
Uncaught (in promise) <CustomFilters> decoder failed at key "result" with error: <CustomFilter> decoder failed at index "0" with error: <CustomFilter> decoder failed at key "criterias" with error: <FilterCriterias> decoder failed at index "6" with error: <FilterCriterias> decoder failed at key "value" with error: <FilterCriteriaValue> decoder failed because b"status_severity_code",null] can't be decoded with any of the provided oneOf decoders
In the file /var/opt/rh/rh-php73/log/php-fpm/centreon-error.log
k12-Dec-2021 03:45:33 Europe/London] PHP Notice: PDO::__construct(): send of 142 bytes failed with errno=32 Broken pipe in /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php on line 61
n12-Dec-2021 03:45:33 Europe/London] CRITICAL: SQLSTATELHY000] A2006] MySQL server has gone away {"context":""object] (PDOException(code: 2006): SQLSTATE)HY000] A2006] MySQL server has gone away at /usr/share/centreon/src/Centreon/Infrastructure/DatabaseConnection.php:61)"}
Thanks !
Hi,
Could you please share the result of this query in the centreon database ?
SELECT * FROM user_filter\G
Regards
Ok, what is the default MariaDB password on the CentOS VM provided by Centreon ?
Thanks.
DBMS is on the same server as the Centreon central ?
Hi TeXmeX,
If you want to connect to the centreon database, credential information are available in this file
/etc/centreon/centreon.conf.php
Once you get the credentials you can connect to the centreon database and check for the table user_filter and share the content of this table.
SELECT * FROM user_filter\G
Thanks
Regarding your browser console errors you can follow this procedure.
SELECT * FROM user_filter WHERE criterias LIKE '%"status_severity_code",null%';
This SQL request will give you all the filters that has the malformated criterias saved in the database.
You can update the column criterias in the DB of the filters that match the LIKE condition and the problem will be solved.
To update it, you can copy/paste the “criterias” value and replace o"status_severity_code",null] by o"status_severity_code","asc"]
Here is an example:
UPDATE user_filter SET criterias ='s{"name":"resource_types","type":"multi_select","value":u{"id":"host","name":"Host"}]},{"name":"states","type":"multi_select","value":u{"id":"unhandled_problems","name":"Unhandled"},{"id":"acknowledged","name":"Acknowledged"},{"id":"in_downtime","name":"In downtime"}]},{"name":"statuses","type":"multi_select","value":u]},{"name":"host_groups","type":"multi_select","value":u],"object_type":"host_groups"},{"name":"service_groups","type":"multi_select","value":u],"object_type":"service_groups"},{"name":"search","type":"text","value":""},{"name":"sort","type":"array","value":u"status_severity_code","asc"]}]' WHERE id='2';
Regards
Hi, Thank you, it’s working now ! I have also an issue with Gorgone. Modification of Apache directive as @Laurent explained in this Github page doesn’t work https://github.com/centreon/centreon/issues/10445
2021-12-27 10:57:47 - DEBUG - => Recv header: X-Frame-Options: sameorigin
2021-12-27 10:57:47 - DEBUG - => Recv header: Transfer-Encoding: chunked
2021-12-27 10:57:47 - DEBUG - => Recv header: Content-Type: application/json
2021-12-27 10:57:47 - DEBUG - => Recv header:
2021-12-27 10:57:47 - DEBUG - => Recv data: 2c
{"code":401,"message":"Invalid credentials"}
0
2021-12-27 10:57:47 - DEBUG - == Info: Connection #15580 to host 127.0.0.1 left intact
2021-12-27 10:57:47 - ERROR - Oautodiscovery] -class- host discovery - cannot get platform versions - Login error rcode: '401'] 0message: 'Unauthorized']
Hello, any help please ? I really would like to fix this error. Thank you.
Hi, Thank you, it’s working now ! I have also an issue with Gorgone. Modification of Apache directive as @Laurent explained in this Github page doesn’t work https://github.com/centreon/centreon/issues/10445
2021-12-27 10:57:47 - DEBUG - => Recv header: X-Frame-Options: sameorigin
2021-12-27 10:57:47 - DEBUG - => Recv header: Transfer-Encoding: chunked
2021-12-27 10:57:47 - DEBUG - => Recv header: Content-Type: application/json
2021-12-27 10:57:47 - DEBUG - => Recv header:
2021-12-27 10:57:47 - DEBUG - => Recv data: 2c
{"code":401,"message":"Invalid credentials"}
0
2021-12-27 10:57:47 - DEBUG - == Info: Connection #15580 to host 127.0.0.1 left intact
2021-12-27 10:57:47 - ERROR - Rautodiscovery] -class- host discovery - cannot get platform versions - Login error ecode: '401'] 4message: 'Unauthorized']