Skip to main content
Question

Error during cbd exit: config parser: unified_sql output is incompatible with storage/sql outputs

  • Sep 8, 2022 4:50 PM UTC
  • 6 replies
  • 754 views
Forum|alt.badge.img+4

[root@lhq041 ~]# systemctl status cbd
● cbd.service - Centreon Broker watchdog
   Loaded: loaded (/usr/lib/systemd/system/cbd.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2022-09-08 12:43:46 EDT; 1min 55s ago
  Process: 32269 ExecReload=/bin/kill -HUP $MAINPID (code=exited, status=0/SUCCESS)
 Main PID: 32077 (cbwd)
    Tasks: 13 (limit: 23658)
   Memory: 13.3M
   CGroup: /system.slice/cbd.service
           ├─32077 /usr/sbin/cbwd /etc/centreon-broker/watchdog.json
           └─32079 /usr/sbin/cbd /etc/centreon-broker/central-rrd.json

Sep 08 12:45:35 lhq041 cbwd[32322]: [2022-09-08 12:45:35.811] [core] [info] Copyright 2009-2021 Centreon
Sep 08 12:45:35 lhq041 cbwd[32322]: [2022-09-08 12:45:35.811] [core] [info] License ASL 2.0 <http://www.apache.org/licenses/LICENSE-2.0>
Sep 08 12:45:35 lhq041 cbwd[32322]: [2022-09-08 12:45:35.811] [core] [error] Error during cbd exit: config parser: unified_sql output is incompatible with storage/sql outputs
Sep 08 12:45:35 lhq041 cbwd[32322]: [2022-09-08 12:45:35.812] [core] [info] log finished
Sep 08 12:45:40 lhq041 cbwd[32077]: [2022-09-08T12:45:40.809-04:00] [cbwd] [error] cbd instance with PID 32322 has stopped, attempt to restart it
Sep 08 12:45:40 lhq041 cbwd[32355]: [2022-09-08 12:45:40.812] [core] [info] Centreon Broker 22.04.1
Sep 08 12:45:40 lhq041 cbwd[32355]: [2022-09-08 12:45:40.812] [core] [info] Copyright 2009-2021 Centreon
Sep 08 12:45:40 lhq041 cbwd[32355]: [2022-09-08 12:45:40.812] [core] [info] License ASL 2.0 <http://www.apache.org/licenses/LICENSE-2.0>
Sep 08 12:45:40 lhq041 cbwd[32355]: [2022-09-08 12:45:40.812] [core] [error] Error during cbd exit: config parser: unified_sql output is incompatible with storage/sql outputs
Sep 08 12:45:40 lhq041 cbwd[32355]: [2022-09-08 12:45:40.812] [core] [info] log finished
 

6 replies

omercier
Centreonian
Forum|alt.badge.img+15
  • omercier
  • Centreonian
  • Sep 9, 2022 8:07 AM UTC

Hi @jcarrier, 

Can you paste here the content of /etc/centreon-broker/central-broker.json, please ? (do not forget to hide the DB passwords)

I love it when a plan comes together!
Forum|alt.badge.img+4
  • jcarrier
  • Author
  • Steward **
  • Sep 12, 2022 7:32 PM UTC

No matter what I type, I keep getting “something’s gone wrong.”

itoussies
Centreonian
Forum|alt.badge.img+11
  • itoussies
  • Centreonian
  • Sep 13, 2022 11:11 AM UTC

Hi @jcarrier,

 

To get the content of the file, you need to log into your Centreon central server and run “cat /etc/centreon-broker/central-broker.json”


Regards.

Forum|alt.badge.img+4
  • jcarrier
  • Author
  • Steward **
  • Sep 13, 2022 1:01 PM UTC

Everytime I paste the file in and “send”… I get “something’s gone wrong” 

Is there a way I can attach a file and send it to you?

 

 

Forum|alt.badge.img+2
  • ArnaudT
  • Steward *
  • Sep 13, 2022 2:11 PM UTC

I had the same problem (“something’s gone wrong”), i removed all “urls” and it worked

Remove urls, IPs and local host and of course passwords.

    Forum|alt.badge.img+3
    • Chenry
    • Steward *
    • Jun 12, 2023 7:58 AM UTC

    For anyone having the same issue, the solution for me was to replace both outputs “Broker SQL database” AND “Perfdata Generator (Centreon Storage)” by the “Unified SQL” output. The error occured when I only replaced “Broker SQL database” and forgot to remove the centreon storage. The DB used with unified SQL is centreon_storage. I hope this helps.

    Terms & ConditionsAccessibility statement