Skip to main content
Question

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

  • September 8, 2022
  • 6 replies
  • 701 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+13
  • Centreonian
  • 277 replies
  • September 9, 2022

Hi @jcarrier

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


Forum|alt.badge.img+4
  • Author
  • Steward **
  • 26 replies
  • September 12, 2022

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


itoussies
Centreonian
Forum|alt.badge.img+11
  • Centreonian
  • 134 replies
  • September 13, 2022

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
  • Author
  • Steward **
  • 26 replies
  • September 13, 2022

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
  • Steward *
  • 12 replies
  • September 13, 2022

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
  • Steward *
  • 10 replies
  • June 12, 2023

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.