Announcement

Collapse
No announcement yet.

Problème poller Could not execute query: Table 'centreon.rt_instances' doesn't exist

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problème poller Could not execute query: Table 'centreon.rt_instances' doesn't exist

    Bonjour,

    Je viens d'installer un serveur centreon (18.10.2) sur un serveur Redhat à partir des paquets.
    Cependant le poller ne fonctionne pas. En cherchant j'ai trouvé l'erreur ci-dessous présent dans les logs présent dans /var/log/centreon-broker/central-broker.log

    Centreon Broker 18.10.1 log file opened
    [1548248822] config: module applier: loading directory '/usr/share/centreon/lib/centreon-broker'
    [1548248822] info: dumper: module for Centreon Broker 18.10.1
    [1548248822] info: NEB: module for Centreon Broker 18.10.1
    [1548248822] info: stats: module for Centreon Broker 18.10.1
    [1548248822] info: BAM: module for Centreon Broker 18.10.1
    [1548248822] info: storage: module for Centreon Broker 18.10.1
    [1548248822] info: correlation: module for Centreon Broker 18.10.1
    [1548248822] info: notification: module for Centreon Broker 18.10.1
    [1548248822] info: TCP: module for Centreon Broker 18.10.1
    [1548248822] info: TLS: module for Centreon Broker 18.10.1
    [1548248822] info: TLS: loading GNU TLS version 3.3.29
    [1548248822] info: lua: module for Centreon Broker 18.10.1
    [1548248822] info: RRD: module for Centreon Broker 18.10.1
    [1548248822] info: RRD: using rrdtool 1.4.8
    [1548248822] info: SQL: module for Centreon Broker 18.10.1
    [1548248822] info: file: opening new file '/var/lib/centreon-broker//central-broker.memory.central-broker-input'
    ...
    [1548248822] info: file: opening new file '/var/lib/centreon-broker//central-broker.memory.central-broker-bam-monitoring'
    [1548248822] error: storage: could not fetch index list from data DB: could not execute query: Table 'centreon.rt_index_data' doesn't exist QMYSQL: Unable to execute query (SELECT index_id , host_id, service_id, host_name, rrd_retention, service_description, special, locked FROM rt_index_data)
    [1548248822] info: file: end of file '/var/lib/centreon-broker//central-broker.memory.central-broker-bam-monitoring' reached, erasing file
    [1548248822] error: SQL: could not get the list of outdated instances: could not execute query: Table 'centreon.rt_instances' doesn't exist QMYSQL: Unable to execute query (SELECT instance_id FROM rt_instances WHERE outdated=TRUE)
    [1548248822] error: parsing error on '/etc/centreon-broker/correlation.xml': No such file or directory
    [1548248822] info: file: opening new file '/var/lib/centreon-broker//central-broker.queue.central-broker-bam-monitoring'
    [1548248822] info: file: end of file '/var/lib/centreon-broker//central-broker.queue.central-broker-bam-monitoring' reached, erasing file
    [1548248822] info: file: opening new file '/var/lib/centreon-broker//central-broker.cache.central-broker-bam-monitoring'
    [1548248822] error: BAM: command_file parameter not set
    [1548248822] info: file: opening new file '/var/lib/centreon-broker//central-broker.cache.central-broker-cfg-broker-poller-module-1.new'
    [1548248822] info: file: opening new file '/var/lib/centreon-broker//central-broker.cache.central-broker-cfg-engine-poller-module-1.new'
    [1548248822] info: file: opening new file '/var/lib/centreon-broker//central-broker.cache.central-broker-nodeevents.new'
    Centreon Broker 18.10.1 log file closed

    Effectivement les tables ne semblent pas présentes dans la db centreon.

    Y a t-il un script de création de base que ne serait pas passé ?

    Merci



Working...
X