Announcement

Collapse
No announcement yet.

CENTREON 2.8.17 missing Database Tables

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

  • CENTREON 2.8.17 missing Database Tables

    Hello Everyone!

    We are using CENTREON 2.8.17 and encountered an issue with our Database (centreon). 56 of the database tables went missing / corrupted after a failed backup and we are trying to figure out how to repair the tables with minimal risk.

    The last backup that we have with the complete tables was way back in April and we have added dozens of new services and hosts since.

    Some information about our environment:

    *we are not using traps
    *we are not using host service relation and we have not created any service groups
    *the table that we are most concerned about is the Service Table if that contain all our Service Templates?
    mod_ppm_discovery_category
    mod_ppm_discovery_validator
    mod_ppm_discovery_validator_argument
    mod_ppm_host_service_relation
    mod_ppm_icons
    mod_ppm_information_url
    mod_ppm_pluginpack
    mod_ppm_pluginpack_command
    mod_ppm_pluginpack_dependency
    mod_ppm_pluginpack_host
    mod_ppm_pluginpack_service
    mod_ppm_resultset_tpl
    modules_informations
    nagios_macro
    nagios_server
    ns_host_relation
    ods_view_details
    on_demand_macro_command
    on_demand_macro_host
    on_demand_macro_service
    options
    poller_command_relations
    service
    service_categories
    service_categories_relation
    servicegroup
    servicegroup_relation
    session
    timeperiod
    timeperiod_exceptions
    timeperiod_exclude_relations
    timeperiod_include_relations
    timezone
    topology
    topology_JS
    traps
    traps_group
    traps_group_relation
    traps_matching_properties
    traps_preexec
    traps_service_relation
    traps_vendor
    view_img
    view_img_dir
    view_img_dir_relation
    virtual_metrics
    widget_models
    widget_parameters
    widget_parameters_field_type
    widget_parameters_multiple_options
    widget_parameters_range
    widget_preferences
    widget_views
    widgets
    ws_token
    Some of our questions are:

    1. Is there a way to repair the tables without having to revert to the old backup?
    2. Can we just copy the missing tables from the old backup and leave the rest intact?

    Thank you very much and we appreciate any help or information you can share regarding this.

Working...
X