Skip to main content

Hi,

i upgraded to Centreon 21.04.9 from 21.04 and now i have the error message “ when i go on administration interface “Oops something went wrong”. I don't see where i have to look in the logs to try to find where the error came from.

Thanks for your help. 

Regards.

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 ?


Yes.


Github issue: https://github.com/centreon/centreon/issues/10445


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']
 

 


Reply