Announcement

Collapse
No announcement yet.

Database 'oreon' : Schema Creation - Critical

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

  • Database 'oreon' : Schema Creation - Critical

    Oreon users,

    so far my installation has been sucessfull untill setup tries to complete the titled task when i get this error output below

    any help appreciated
    Regards
    Mark


    [code]
    Database : Connection OK
    Database ’oreon’ : Creation OK
    Database ’oreon’ : Users Management OK
    Database ’oreon’ : Schema Creation CRITICAL
    CREATE TABLE `cfg_cgi` ( `cgi_id` int(11) NOT NULL auto_increment, `cgi_name` varchar(255) default NULL, `main_config_file` varchar(255) default NULL, `physical_html_path` varchar(255) default NULL, `url_html_path` varchar(255) default NULL, `nagios_check_command` varchar(255) default NULL, `use_authentication` enum('0','1') default NULL, `default_user_name` varchar(255) default NULL, `authorized_for_system_information` text, `authorized_for_system_commands` text, `authorized_for_configuration_information` text, `authorized_for_all_hosts` text, `authorized_for_all_host_commands` text, `authorized_for_all_services` text, `authorized_for_all_service_commands` text, `statusmap_background_image` varchar(255) default NULL, `default_statusmap_layout` enum('0','1','2','3','4','5','6') default '2', `statuswrl_include` varchar(255) default NULL, `default_statuswrl_layout` enum('0','1','2','3','4') default '2', `refresh_rate` int(11) default NULL, `host_unreachable_sound` varchar(255) default NULL, `host_down_sound` varchar(255) default NULL, `service_critical_sound` varchar(255) default NULL, `service_warning_sound` varchar(255) default NULL, `service_unknown_sound` varchar(255) default NULL, `ping_syntax` text, `cgi_comment` text, `cgi_activate` enum('0','1') default NULL, PRIMARY KEY (`cgi_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `cfg_nagios` ( `nagios_id` int(11) NOT NULL auto_increment, `nagios_name` varchar(255) default NULL, `log_file` varchar(255) default NULL, `cfg_dir` varchar(255) default NULL, `object_cache_file` varchar(255) default NULL, `temp_file` varchar(255) default NULL, `status_file` varchar(255) default NULL, `p1_file` varchar(255) default NULL, `aggregate_status_updates` enum('0','1','2') default NULL, `status_update_interval` int(11) default NULL, `nagios_user` varchar(255) default NULL, `nagios_group` varchar(255) default NULL, `enable_notifications` enum('0','1','2') default NULL, `execute_service_checks` enum('0','1','2') default NULL, `accept_passive_service_checks` enum('0','1','2') default NULL, `execute_host_checks` enum('0','1','2') default NULL, `accept_passive_host_checks` enum('0','1','2') default NULL, `enable_event_handlers` enum('0','1','2') default NULL, `log_rotation_method` varchar(255) default NULL, `log_archive_path` varchar(255) default NULL, `check_external_commands` enum('0','1','2') default NULL, `command_check_interval` varchar(255) default NULL, `command_file` varchar(255) default NULL, `downtime_file` varchar(255) default NULL, `comment_file` varchar(255) default NULL, `lock_file` varchar(255) default NULL, `retain_state_information` enum('0','1','2') default NULL, `state_retention_file` varchar(255) default NULL, `retention_update_interval` int(11) default NULL, `use_retained_program_state` enum('0','1','2') default NULL, `use_retained_scheduling_info` enum('0','1','2') default NULL, `use_syslog` enum('0','1','2') default NULL, `log_notifications` enum('0','1','2') default NULL, `log_service_retries` enum('0','1','2') default NULL, `log_host_retries` enum('0','1','2') default NULL, `log_event_handlers` enum('0','1','2') default NULL, `log_initial_states` enum('0','1','2') default NULL, `log_external_commands` enum('0','1','2') default NULL, `log_passive_service_checks` enum('0','1','2') default NULL, `log_passive_checks` enum('0','1','2') default NULL, `global_host_event_handler` int(11) default NULL, `global_service_event_handler` int(11) default NULL, `sleep_time` VARCHAR(10) default NULL, `inter_check_delay_method` varchar(255) default NULL, `service_inter_check_delay_method` varchar(255) default NULL, `host_inter_check_delay_method` varchar(255) default NULL, `service_interleave_factor` varchar(255) default NULL, `max_concurrent_checks` int(11) default NULL, `max_service_check_spread` int(11) default NULL, `max_host_check_spread` int(11) default NULL, `service_reaper_frequency` int(11) default NULL, `interval_length` int(11) default NULL, `auto_reschedule_checks` enum('0','1','2') default NULL, `auto_rescheduling_interval` int(11) default NULL, `auto_rescheduling_window` int(11) default NULL, `use_agressive_host_checking` enum('0','1','2') default NULL, `enable_flap_detection` enum('0','1','2') default NULL, `low_service_flap_threshold` varchar(255) default NULL, `high_service_flap_threshold` varchar(255) default NULL, `low_host_flap_threshold` varchar(255) default NULL, `high_host_flap_threshold` varchar(255) default NULL, `soft_state_dependencies` enum('0','1','2') default NULL, `service_check_timeout` int(11) default NULL, `host_check_timeout` int(11) default NULL, `event_handler_timeout` int(11) default NULL, `notification_timeout` int(11) default NULL, `ocsp_timeout` int(11) default NULL, `ochp_timeout` int(11) default NULL, `perfdata_timeout` int(11) default NULL, `obsess_over_services` enum('0','1','2') default NULL, `ocsp_command` int(11) default NULL, `obsess_over_hosts` enum('0','1','2') default NULL, `ochp_command` int(11) default NULL, `process_performance_data` enum('0','1','2') default NULL, `host_perfdata_command` int(11) default NULL, `service_perfdata_command` int(11) default NULL, `host_perfdata_file` varchar(255) default NULL, `service_perfdata_file` varchar(255) default NULL, `host_perfdata_file_template` text, `service_perfdata_file_template` text, `host_perfdata_file_mode` enum('a','w','2') default NULL, `service_perfdata_file_mode` enum('a','w','2') default NULL, `host_perfdata_file_processing_interval` int(11) default NULL, `service_perfdata_file_processing_interval` int(11) default NULL, `host_perfdata_file_processing_command` int(11) default NULL, `service_perfdata_file_processing_command` int(11) default NULL, `check_for_orphaned_services` enum('0','1','2') default NULL, `check_service_freshness` enum('0','1','2') default NULL, `service_freshness_check_interval` int(11) default NULL, `freshness_check_interval` int(11) default NULL, `check_host_freshness` enum('0','1','2') default NULL, `host_freshness_check_interval` int(11) default NULL, `date_format` varchar(255) default NULL, `illegal_object_name_chars` varchar(255) default NULL, `illegal_macro_output_chars` varchar(255) default NULL, `use_regexp_matching` enum('0','1','2') default NULL, `use_true_regexp_matching` enum('0','1','2') default NULL, `admin_email` varchar(255) default NULL, `admin_pager` varchar(255) default NULL, `nagios_comment` text, `nagios_activate` enum('0','1') default NULL, PRIMARY KEY (`nagios_id`), KEY `cmd1_index` (`global_host_event_handler`), KEY `cmd2_index` (`global_service_event_handler`), KEY `cmd3_index` (`ocsp_command`), KEY `cmd4_index` (`ochp_command`), KEY `cmd5_index` (`host_perfdata_command`), KEY `cmd6_index` (`service_perfdata_command`), KEY `cmd7_index` (`host_perfdata_file_processing_command`), KEY `cmd8_index` (`service_perfdata_file_processing_command`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `cfg_perfparse` ( `perfparse_id` int(11) NOT NULL auto_increment, `perfparse_name` varchar(255) default NULL, `Server_Port` int(11) default NULL, `Service_Log` varchar(255) default NULL, `Service_Log_Position_Mark_Path` varchar(255) default NULL, `Error_Log` varchar(255) default NULL, `Error_Log_Rotate` enum('0','1') default '1', `Error_Log_Keep_N_Days` int(11) default NULL, `Drop_File` varchar(255) default NULL, `Drop_File_Rotate` enum('0','1') default '1', `Drop_File_Keep_N_Days` int(11) default NULL, `Lock_File` varchar(255) default NULL, `Show_Status_Bar` enum('0','1') default '1', `Do_Report` enum('0','1') default '1', `Default_user_permissions_Policy` enum('1','2','3') default '1', `Default_user_permissions_Host_groups` enum('1','2','3') default '1', `Default_user_permissions_Summary` enum('1','2','3') default '1', `Output_Log_File` enum('0','1') default '1', `Output_Log_Filename` varchar(255) default NULL, `Output_Log_Rotate` enum('0','1') default '1', `Output_Log_Keep_N_Days` int(11) default NULL, `Use_Storage_Socket_Output` enum('0','1') default '1', `Storage_Socket_Output_Host_Name` varchar(255) default NULL, `Storage_Socket_Output_Port` int(11) default NULL, `Use_Storage_Mysql` enum('0','1') default '1', `No_Raw_Data` enum('0','1') default '1', `No_Bin_Data` enum('0','1') default '1', `DB_User` varchar(255) default NULL, `DB_Pass` varchar(255) default NULL, `DB_Name` varchar(255) default NULL, `DB_Host` varchar(255) default NULL, `Dummy_Hostname` varchar(255) default NULL, `Storage_Modules_Load` varchar(255) default NULL, `perfparse_comment` text, `perfparse_activate` enum('0','1') default NULL, PRIMARY KEY (`perfparse_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `cfg_resource` ( `resource_id` int(11) NOT NULL auto_increment, `resource_name` varchar(255) default NULL, `resource_line` varchar(255) default NULL, `resource_comment` varchar(255) default NULL, `resource_activate` enum('0','1') default NULL, PRIMARY KEY (`resource_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `command` ( `command_id` int(11) NOT NULL auto_increment, `command_name` varchar(200) default NULL, `command_line` text, `command_example` varchar(254) default NULL, `command_type` tinyint(4) default NULL, PRIMARY KEY (`command_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `contact` ( `contact_id` int(11) NOT NULL auto_increment, `timeperiod_tp_id` int(11) default NULL, `timeperiod_tp_id2` int(11) default NULL, `contact_name` varchar(200) default NULL, `contact_alias` varchar(200) default NULL, `contact_passwd` varchar(255) default NULL, `contact_lang` varchar(255) default NULL, `contact_host_notification_options` varchar(200) default NULL, `contact_service_notification_options` varchar(200) default NULL, `contact_email` varchar(200) default NULL, `contact_pager` varchar(200) default NULL, `contact_comment` text, `contact_oreon` enum('0','1') default NULL, `contact_admin` enum('0','1') default '0', `contact_type_msg` enum('txt','html','pdf') default 'txt', `contact_activate` enum('0','1') default NULL, `contact_auth_type` varchar(255) default '', `contact_ldap_dn` varchar(255) default NULL, PRIMARY KEY (`contact_id`), KEY `name_index` (`contact_name`), KEY `alias_index` (`contact_alias`), KEY `tp1_index` (`timeperiod_tp_id`), KEY `tp2_index` (`timeperiod_tp_id2`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `contact_hostcommands_relation` ( `chr_id` int(11) NOT NULL auto_increment, `contact_contact_id` int(11) default NULL, `command_command_id` int(11) default NULL, PRIMARY KEY (`chr_id`), KEY `contact_index` (`contact_contact_id`), KEY `command_index` (`command_command_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `contact_servicecommands_relation` ( `csc_id` int(11) NOT NULL auto_increment, `contact_contact_id` int(11) default NULL, `command_command_id` int(11) default NULL, PRIMARY KEY (`csc_id`), KEY `contact_index` (`contact_contact_id`), KEY `command_index` (`command_command_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `contactgroup` ( `cg_id` int(11) NOT NULL auto_increment, `cg_name` varchar(200) default NULL, `cg_alias` varchar(200) default NULL, `cg_comment` text, `cg_activate` enum('0','1') default NULL, PRIMARY KEY (`cg_id`), KEY `name_index` (`cg_name`), KEY `alias_index` (`cg_alias`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `contactgroup_contact_relation` ( `cgr_id` int(11) NOT NULL auto_increment, `contact_contact_id` int(11) default NULL, `contactgroup_cg_id` int(11) default NULL, PRIMARY KEY (`cgr_id`), KEY `contact_index` (`contact_contact_id`), KEY `contactgroup_index` (`contactgroup_cg_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `contactgroup_host_relation` ( `cghr_id` int(11) NOT NULL auto_increment, `host_host_id` int(11) default NULL, `contactgroup_cg_id` int(11) default NULL, PRIMARY KEY (`cghr_id`), KEY `host_index` (`host_host_id`), KEY `contactgroup_index` (`contactgroup_cg_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `contactgroup_hostgroup_relation` ( `cghgr_id` int(11) NOT NULL auto_increment, `contactgroup_cg_id` int(11) default NULL, `hostgroup_hg_id` int(11) default NULL, PRIMARY KEY (`cghgr_id`), KEY `contactgroup_index` (`contactgroup_cg_id`), KEY `hostgroup_index` (`hostgroup_hg_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `contactgroup_service_relation` ( `cgsr_id` int(11) NOT NULL auto_increment, `contactgroup_cg_id` int(11) default NULL, `service_service_id` int(11) default NULL, PRIMARY KEY (`cgsr_id`), KEY `contactgroup_index` (`contactgroup_cg_id`), KEY `service_index` (`service_service_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `contactgroup_servicegroup_relation` ( `cgsgr_id` int(11) NOT NULL auto_increment, `servicegroup_sg_id` int(11) default NULL, `contactgroup_cg_id` int(11) default NULL, PRIMARY KEY (`cgsgr_id`), KEY `servicegroup_index` (`servicegroup_sg_id`), KEY `contactgroup_index` (`contactgroup_cg_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `cron_operation` ( `id` int(11) NOT NULL auto_increment, `name` varchar(254) default NULL, `command` varchar(254) default NULL, `time_launch` varchar(254) default NULL, `last_modification` int(11) default '0', `system` enum('0','1') default NULL, `module` enum('0','1') default NULL, `activate` enum('0','1') default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `dependency` ( `dep_id` int(11) NOT NULL auto_increment, `dep_name` varchar(255) default NULL, `dep_description` varchar(255) default NULL, `inherits_parent` enum('0','1') default NULL, `execution_failure_criteria` varchar(255) default NULL, `notification_failure_criteria` varchar(255) default NULL, `dep_comment` text, PRIMARY KEY (`dep_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `dependency_hostChild_relation` ( `dhcr_id` int(11) NOT NULL auto_increment, `dependency_dep_id` int(11) default NULL, `host_host_id` int(11) default NULL, PRIMARY KEY (`dhcr_id`), KEY `dependency_index` (`dependency_dep_id`), KEY `host_index` (`host_host_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `dependency_hostParent_relation` ( `dhpr_id` int(11) NOT NULL auto_increment, `dependency_dep_id` int(11) default NULL, `host_host_id` int(11) default NULL, PRIMARY KEY (`dhpr_id`), KEY `dependency_index` (`dependency_dep_id`), KEY `host_index` (`host_host_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `dependency_hostgroupChild_relation` ( `dhgcr_id` int(11) NOT NULL auto_increment, `dependency_dep_id` int(11) default NULL, `hostgroup_hg_id` int(11) default NULL, PRIMARY KEY (`dhgcr_id`), KEY `dependency_index` (`dependency_dep_id`), KEY `hostgroup_index` (`hostgroup_hg_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `dependency_hostgroupParent_relation` ( `dhgpr_id` int(11) NOT NULL auto_increment, `dependency_dep_id` int(11) default NULL, `hostgroup_hg_id` int(11) default NULL, PRIMARY KEY (`dhgpr_id`), KEY `dependency_index` (`dependency_dep_id`), KEY `hostgroup_index` (`hostgroup_hg_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `dependency_metaserviceChild_relation` ( `dmscr_id` int(11) NOT NULL auto_increment, `dependency_dep_id` int(11) default NULL, `meta_service_meta_id` int(11) default NULL, PRIMARY KEY (`dmscr_id`), KEY `dependency_index` (`dependency_dep_id`), KEY `meta_service_index` (`meta_service_meta_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `dependency_metaserviceParent_relation` ( `dmspr_id` int(11) NOT NULL auto_increment, `dependency_dep_id` int(11) default NULL, `meta_service_meta_id` int(11) default NULL, PRIMARY KEY (`dmspr_id`), KEY `dependency_index` (`dependency_dep_id`), KEY `meta_service_index` (`meta_service_meta_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `dependency_serviceChild_relation` ( `dscr_id` int(11) NOT NULL auto_increment, `dependency_dep_id` int(11) default NULL, `service_service_id` int(11) default NULL, `host_host_id` int(11) default NULL, PRIMARY KEY (`dscr_id`), KEY `dependency_index` (`dependency_dep_id`), KEY `service_index` (`service_service_id`), KEY `host_index` (`host_host_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `dependency_serviceParent_relation` ( `dspr_id` int(11) NOT NULL auto_increment, `dependency_dep_id` int(11) default NULL, `service_service_id` int(11) default NULL, `host_host_id` int(11) default NULL, PRIMARY KEY (`dspr_id`), KEY `dependency_index` (`dependency_dep_id`), KEY `service_index` (`service_service_id`), KEY `host_index` (`host_host_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `dependency_servicegroupChild_relation` ( `dsgcr_id` int(11) NOT NULL auto_increment, `dependency_dep_id` int(11) default NULL, `servicegroup_sg_id` int(11) default NULL, PRIMARY KEY (`dsgcr_id`), KEY `dependency_index` (`dependency_dep_id`), KEY `sg_index` (`servicegroup_sg_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `dependency_servicegroupParent_relation` ( `dsgpr_id` int(11) NOT NULL auto_increment, `dependency_dep_id` int(11) default NULL, `servicegroup_sg_id` int(11) default NULL, PRIMARY KEY (`dsgpr_id`), KEY `dependency_index` (`dependency_dep_id`), KEY `sg_index` (`servicegroup_sg_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `downtime` ( `downtime_id` int(11) NOT NULL auto_increment, `host_id` int(11) NOT NULL default '0', `service_id` int(11) default NULL, `entry_time` timestamp NOT NULL default '0000-00-00 00:00:00', `author` varchar(254) NOT NULL default '', `comment` varchar(254) NOT NULL default '', `start_time` varchar(15) NOT NULL default '', `end_time` varchar(15) NOT NULL default '', `fixed` enum('0','1') NOT NULL default '0', `duration` int(11) NOT NULL default '0', `deleted` enum('0','1') NOT NULL default '0', PRIMARY KEY (`downtime_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `escalation` ( `esc_id` int(11) NOT NULL auto_increment, `esc_name` varchar(255) default NULL, `first_notification` int(11) default NULL, `last_notification` int(11) default NULL, `notification_interval` int(11) default NULL, `escalation_period` int(11) default NULL, `escalation_options1` varchar(255) default NULL, `escalation_options2` varchar(255) default NULL, `esc_comment` text, PRIMARY KEY (`esc_id`), KEY `period_index` (`escalation_period`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `escalation_contactgroup_relation` ( `ecgr_id` int(11) NOT NULL auto_increment, `escalation_esc_id` int(11) default NULL, `contactgroup_cg_id` int(11) default NULL, PRIMARY KEY (`ecgr_id`), KEY `escalation_index` (`escalation_esc_id`), KEY `cg_index` (`contactgroup_cg_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `escalation_host_relation` ( `ehr_id` int(11) NOT NULL auto_increment, `escalation_esc_id` int(11) default NULL, `host_host_id` int(11) default NULL, PRIMARY KEY (`ehr_id`), KEY `escalation_index` (`escalation_esc_id`), KEY `host_index` (`host_host_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `escalation_hostgroup_relation` ( `ehgr_id` int(11) NOT NULL auto_increment, `escalation_esc_id` int(11) default NULL, `hostgroup_hg_id` int(11) default NULL, PRIMARY KEY (`ehgr_id`), KEY `escalation_index` (`escalation_esc_id`), KEY `hg_index` (`hostgroup_hg_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `escalation_meta_service_relation` ( `emsr_id` int(11) NOT NULL auto_increment, `escalation_esc_id` int(11) default NULL, `meta_service_meta_id` int(11) default NULL, PRIMARY KEY (`emsr_id`), KEY `escalation_index` (`escalation_esc_id`), KEY `meta_service_index` (`meta_service_meta_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `escalation_service_relation` ( `esr_id` int(11) NOT NULL auto_increment, `escalation_esc_id` int(11) default NULL, `service_service_id` int(11) default NULL, `host_host_id` int(11) default NULL, PRIMARY KEY (`esr_id`), KEY `escalation_index` (`escalation_esc_id`), KEY `service_index` (`service_service_id`), KEY `host_index` (`host_host_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `extended_host_information` ( `ehi_id` int(11) NOT NULL auto_increment, `host_host_id` int(11) default NULL, `ehi_notes` varchar(200) default NULL, `ehi_notes_url` varchar(200) default NULL, `ehi_action_url` varchar(200) default NULL, `ehi_icon_image` varchar(200) default NULL, `ehi_icon_image_alt` varchar(200) default NULL, `ehi_vrml_image` varchar(200) default NULL, `ehi_statusmap_image` varchar(200) default NULL, `ehi_2d_coords` varchar(200) default NULL, `ehi_3d_coords` varchar(200) default NULL, `country_id` int(11) unsigned default NULL, `city_id` int(11) unsigned default NULL, PRIMARY KEY (`ehi_id`), KEY `host_index` (`host_host_id`), KEY `country_index` (`country_id`), KEY `city_index` (`city_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `extended_service_information` ( `esi_id` int(11) NOT NULL auto_increment, `service_service_id` int(11) default NULL, `esi_notes` varchar(200) default NULL, `esi_notes_url` varchar(200) default NULL, `esi_action_url` varchar(200) default NULL, `esi_icon_image` varchar(200) default NULL, `esi_icon_image_alt` varchar(200) default NULL, `graph_id` int(11) default NULL, PRIMARY KEY (`esi_id`), KEY `service_index` (`service_service_id`), KEY `graph_index` (`graph_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `general_opt` ( `gopt_id` int(11) NOT NULL auto_increment, `nagios_path` varchar(255) default NULL, `nagios_path_bin` varchar(255) default NULL, `nagios_path_img` varchar(255) default NULL, `nagios_path_plugins` varchar(255) default NULL, `nagios_version` enum('1','2','3') default NULL, `snmp_community` varchar(255) default NULL, `snmp_version` varchar(255) default NULL, `snmp_trapd_used` enum('0','1') default NULL, `snmp_trapd_path_daemon` varchar(255) default NULL, `snmp_trapd_path_conf` varchar(255) default NULL, `mailer_path_bin` varchar(255) default NULL, `rrdtool_path_bin` varchar(255) default NULL, `rrdtool_version` varchar(255) default NULL, `oreon_path` varchar(255) default NULL, `oreon_web_path` varchar(255) default NULL, `oreon_rrdbase_path` varchar(255) default NULL, `oreon_refresh` int(11) default NULL, `color_up` varchar(50) default NULL, `color_down` varchar(50) default NULL, `color_unreachable` varchar(50) default NULL, `color_ok` varchar(50) default NULL, `color_warning` varchar(50) default NULL, `color_critical` varchar(50) default NULL, `color_pending` varchar(50) default NULL, `color_unknown` varchar(50) default NULL, `session_expire` int(11) default NULL, `perfparse_installed` enum('0','1') default NULL, `graph_preferencies` int(11) default '0', `maxViewMonitoring` int(11) NOT NULL default '50', `maxViewConfiguration` int(11) NOT NULL default '20', `template` varchar(254) default 'Basic', `ldap_host` varchar(254) default NULL, `ldap_port` varchar(5) default '389', `ldap_base_dn` varchar(254) default NULL, `ldap_login_attrib` varchar(254) default 'dn', `ldap_ssl` enum('0','1') default NULL, `ldap_auth_enable` enum('0','1') default NULL, PRIMARY KEY (`gopt_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `giv_components` ( `compo_id` int(11) NOT NULL auto_increment, `ds_order` int(11) default NULL, `graph_id` int(11) default NULL, `compot_compo_id` int(11) default NULL, `pp_metric_id` int(11) default NULL, PRIMARY KEY (`compo_id`), KEY `graph_index` (`graph_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `giv_components_template` ( `compo_id` int(11) NOT NULL auto_increment, `name` varchar(255) default NULL, `ds_order` int(11) default NULL, `ds_name` varchar(200) default NULL, `ds_legend` varchar(200) default NULL, `ds_color_line` varchar(255) default NULL, `ds_color_area` varchar(255) default NULL, `ds_filled` enum('0','1') default NULL, `ds_max` enum('0','1') default NULL, `ds_min` enum('0','1') default NULL, `ds_average` enum('0','1') default NULL, `ds_last` enum('0','1') default NULL, `ds_tickness` int(11) default NULL, `ds_transparency` varchar(254) default NULL, `ds_invert` enum('0','1') default NULL, `default_tpl1` enum('0','1') default NULL, `default_tpl2` enum('0','1') default NULL, `comment` text, PRIMARY KEY (`compo_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `giv_graphT_componentT_relation` ( `ggcr_id` int(11) NOT NULL auto_increment, `gg_graph_id` int(11) default NULL, `gc_compo_id` int(11) default NULL, PRIMARY KEY (`ggcr_id`), KEY `graph_index` (`gg_graph_id`), KEY `compo_index` (`gc_compo_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `giv_graphs` ( `graph_id` int(11) NOT NULL auto_increment, `name` varchar(200) default NULL, `grapht_graph_id` int(11) default NULL, `comment` text, PRIMARY KEY (`graph_id`), KEY `graph_template_index` (`grapht_graph_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `giv_graphs_template` ( `graph_id` int(11) NOT NULL auto_increment, `name` varchar(200) default NULL, `title` varchar(50) default NULL, `img_format` varchar(4) default NULL, `vertical_label` varchar(200) default NULL, `period` int(11) default NULL, `step` int(11) default NULL, `width` int(11) default NULL, `height` int(11) default NULL, `lower_limit` FLOAT default NULL, `upper_limit` FLOAT default NULL, `bg_grid_color` varchar(200) default NULL, `bg_color` varchar(200) default NULL, `police_color` varchar(200) default NULL, `grid_main_color` varchar(200) default NULL, `grid_sec_color` varchar(200) default NULL, `contour_cub_color` varchar(200) default NULL, `col_arrow` varchar(200) default NULL, `col_top` varchar(200) default NULL, `col_bot` varchar(200) default NULL, `default_tpl1` enum('0','1') default NULL, `default_tpl2` enum('0','1') default NULL, `stacked` enum('0','1') default NULL, `comment` text, PRIMARY KEY (`graph_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `host` ( `host_id` int(11) NOT NULL auto_increment, `host_template_model_htm_id` int(11) default NULL, `command_command_id` int(11) default NULL, `timeperiod_tp_id` int(11) default NULL, `timeperiod_tp_id2` int(11) default NULL, `purge_policy_id` int(11) default NULL, `command_command_id2` int(11) default NULL, ` command_command_id_arg2` text, `host_name` varchar(200) default NULL, `host_alias` varchar(200) default NULL, `host_address` varchar(255) default NULL, `host_max_check_attempts` int(11) default NULL, `host_check_interval` int(11) default NULL, `host_active_checks_enabled` enum('0','1','2') default NULL, `host_passive_checks_enabled` enum('0','1','2') default NULL, `host_checks_enabled` enum('0','1','2') default NULL, `host_obsess_over_host` enum('0','1','2') default NULL, `host_check_freshness` enum('0','1','2') default NULL, `host_freshness_threshold` int(11) default NULL, `host_event_handler_enabled` enum('0','1','2') default NULL, `host_low_flap_threshold` int(11) default NULL, `host_high_flap_threshold` int(11) default NULL, `host_flap_detection_enabled` enum('0','1','2') default NULL, `host_process_perf_data` enum('0','1','2') default NULL, `host_retain_status_information` enum('0','1','2') default NULL, `host_retain_nonstatus_information` enum('0','1','2') default NULL, `host_notification_interval` int(11) default NULL, `host_notification_options` varchar(200) default NULL, `host_notifications_enabled` enum('0','1','2') default NULL, `host_stalking_options` varchar(200) default NULL, `host_snmp_community` varchar(255) default NULL, `host_snmp_version` varchar(255) default NULL, `host_comment` text, `host_register` enum('0','1') default NULL, `host_activate` enum('0','1') default '1', PRIMARY KEY (`host_id`), KEY `htm_index` (`host_template_model_htm_id`), KEY `cmd1_index` (`command_command_id`), KEY `cmd2_index` (`command_command_id2`), KEY `tp1_index` (`timeperiod_tp_id`), KEY `tp2_index` (`timeperiod_tp_id2`), KEY `name_index` (`host_name`), KEY `alias_index` (`host_alias`), KEY `purge_index` (`purge_policy_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `host_hostparent_relation` ( `hhr_id` int(11) NOT NULL auto_increment, `host_parent_hp_id` int(11) default NULL, `host_host_id` int(11) default NULL, PRIMARY KEY (`hhr_id`), KEY `host1_index` (`host_parent_hp_id`), KEY `host2_index` (`host_host_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `host_service_relation` ( `hsr_id` int(11) NOT NULL auto_increment, `hostgroup_hg_id` int(11) default NULL, `host_host_id` int(11) default NULL, `servicegroup_sg_id` int(11) default NULL, `service_service_id` int(11) default NULL, PRIMARY KEY (`hsr_id`), KEY `hostgroup_index` (`hostgroup_hg_id`), KEY `host_index` (`host_host_id`), KEY `servicegroup_index` (`servicegroup_sg_id`), KEY `service_index` (`service_service_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `hostgroup` ( `hg_id` int(11) NOT NULL auto_increment, `hg_name` varchar(200) default NULL, `hg_alias` varchar(200) default NULL, `country_id` int(10) unsigned default NULL, `city_id` int(10) unsigned default NULL, `hg_comment` text, `hg_activate` enum('0','1') NOT NULL default '1', PRIMARY KEY (`hg_id`), KEY `name_index` (`hg_name`), KEY `alias_index` (`hg_alias`), KEY `country_index` (`country_id`), KEY `city_index` (`city_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `hostgroup_relation` ( `hgr_id` int(11) NOT NULL auto_increment, `hostgroup_hg_id` int(11) default NULL, `host_host_id` int(11) default NULL, PRIMARY KEY (`hgr_id`), KEY `hostgroup_index` (`hostgroup_hg_id`), KEY `host_index` (`host_host_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `inventory_index` ( `id` int(11) NOT NULL auto_increment, `host_id` int(11) default NULL, `name` varchar(254) default NULL, `contact` varchar(254) default NULL, `description` text, `location` varchar(254) default NULL, `manufacturer` varchar(254) default NULL, `serial_number` varchar(254) default NULL, `os` text, `os_revision` varchar(254) default NULL, `type_ressources` int(11) default NULL, PRIMARY KEY (`id`), UNIQUE KEY `host_id` (`host_id`), KEY `manufacturer_index` (`type_ressources`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `inventory_log` ( `id` int(11) NOT NULL auto_increment, `host_id` int(11) default NULL, `type` varchar(20) default NULL, `replaced_value` text, `value` text, `ctime` int(11) default NULL, PRIMARY KEY (`id`), KEY `host_id` (`host_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `inventory_mac_address` ( `id` int(11) NOT NULL auto_increment, `mac_address_begin` varchar(8) default NULL, `manufacturer` int(11) default NULL, PRIMARY KEY (`id`), KEY `manufacturer` (`manufacturer`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `inventory_manufacturer` ( `id` int(11) NOT NULL auto_increment, `name` varchar(254) default NULL, `alias` varchar(254) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `lca_define` ( `lca_id` int(11) NOT NULL auto_increment, `lca_name` varchar(255) default NULL, `lca_comment` text, `lca_hg_childs` enum('0','1') default NULL, `lca_activate` enum('0','1') default NULL, PRIMARY KEY (`lca_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `lca_define_contactgroup_relation` ( `ldcgr_id` int(11) NOT NULL auto_increment, `lca_define_lca_id` int(11) default NULL, `contactgroup_cg_id` int(11) default NULL, PRIMARY KEY (`ldcgr_id`), KEY `lca_index` (`lca_define_lca_id`), KEY `cg_index` (`contactgroup_cg_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `lca_define_host_relation` ( `ldhr_id` int(11) NOT NULL auto_increment, `lca_define_lca_id` int(11) default NULL, `host_host_id` int(11) default NULL, PRIMARY KEY (`ldhr_id`), KEY `lca_index` (`lca_define_lca_id`), KEY `host_index` (`host_host_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `lca_define_hostgroup_relation` ( `ldhgr_id` int(11) NOT NULL auto_increment, `lca_define_lca_id` int(11) default NULL, `hostgroup_hg_id` int(11) default NULL, PRIMARY KEY (`ldhgr_id`), KEY `lca_index` (`lca_define_lca_id`), KEY `hg_index` (`hostgroup_hg_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `lca_define_servicegroup_relation` ( `ldsgr_id` int(11) NOT NULL auto_increment, `lca_define_lca_id` int(11) default NULL, `servicegroup_sg_id` int(11) default NULL, PRIMARY KEY (`ldsgr_id`), KEY `lca_index` (`lca_define_lca_id`), KEY `sg_index` (`servicegroup_sg_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `lca_define_topology_relation` ( `ldtr_id` int(11) NOT NULL auto_increment, `lca_define_lca_id` int(11) default NULL, `topology_topology_id` int(11) default NULL, PRIMARY KEY (`ldtr_id`), KEY `lca_index` (`lca_define_lca_id`), KEY `topology_index` (`topology_topology_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `log_archive_file_name` ( `id_log_file` int(11) NOT NULL auto_increment, `file_name` varchar(200) default NULL, `date` int(11) default NULL, PRIMARY KEY (`id_log_file`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `log_archive_host` ( `log_id` int(11) NOT NULL auto_increment, `host_id` int(11) default NULL, `UPTimeScheduled` int(11) default NULL, `UPTimeUnScheduled` int(11) default NULL, `DOWNTimeScheduled` int(11) default NULL, `DOWNTimeUnScheduled` int(11) default NULL, `UNREACHABLETimeScheduled` int(11) default NULL, `UNREACHABLETimeUnScheduled` int(11) default NULL, `UNDETERMINATETimeScheduled` int(11) default NULL, `UNDETERMINATETimeUnScheduled` int(11) default NULL, `date_end` int(11) default NULL, `date_start` int(11) default NULL, PRIMARY KEY (`log_id`), KEY `host_index` (`host_id`), KEY `date_end_index` (`date_end`), KEY `date_start_index` (`date_start`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `log_archive_service` ( `log_id` int(11) NOT NULL auto_increment, `host_id` int(11) NOT NULL default '0', `service_id` int(11) NOT NULL default '0', `OKTimeScheduled` int(11) NOT NULL default '0', `OKTimeUnScheduled` int(11) NOT NULL default '0', `WARNINGTimeScheduled` int(11) NOT NULL default '0', `WARNINGTimeUnScheduled` int(11) NOT NULL default '0', `UNKNOWNTimeScheduled` int(11) NOT NULL default '0', `UNKNOWNTimeUnScheduled` int(11) NOT NULL default '0', `CRITICALTimeScheduled` int(11) NOT NULL default '0', `CRITICALTimeUnScheduled` int(11) NOT NULL default '0', `UNDETERMINATETimeScheduled` int(11) NOT NULL default '0', `UNDETERMINATETimeUnScheduled` int(11) NOT NULL default '0', `date_start` int(11) default NULL, `date_end` int(11) default NULL, PRIMARY KEY (`log_id`), KEY `host_index` (`host_id`), KEY `service_index` (`service_id`), KEY `date_end_index` (`date_end`), KEY `date_start_index` (`date_start`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `meta_contactgroup_relation` ( `mcr_id` int(11) NOT NULL auto_increment, `meta_id` int(11) default NULL, `cg_cg_id` int(11) default NULL, PRIMARY KEY (`mcr_id`), KEY `meta_index` (`meta_id`), KEY `cg_index` (`cg_cg_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `meta_service` ( `meta_id` int(11) NOT NULL auto_increment, `meta_name` varchar(254) default NULL, `check_period` int(11) default NULL, `max_check_attempts` int(11) default NULL, `normal_check_interval` int(11) default NULL, `retry_check_interval` int(11) default NULL, `notification_interval` int(11) default NULL, `notification_period` int(11) default NULL, `notification_options` varchar(255) default NULL, `notifications_enabled` enum('0','1','2') default NULL, `calcul_type` enum('SOM','AVE','MIN','MAX') default NULL, `meta_select_mode` enum('1','2') default '1', `regexp_str` varchar(254) default NULL, `metric` varchar(255) default NULL, `warning` varchar(254) default NULL, `critical` varchar(254) default NULL, `graph_id` int(11) default NULL, `meta_comment` text, `meta_activate` enum('0','1') default NULL, PRIMARY KEY (`meta_id`), KEY `name_index` (`meta_name`), KEY `check_period_index` (`check_period`), KEY `notification_period_index` (`notification_period`), KEY `graph_index` (`graph_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `meta_service_relation` ( `msr_id` int(11) NOT NULL auto_increment, `meta_id` int(11) default NULL, `host_id` int(11) default NULL, `metric_id` int(11) default NULL, `msr_comment` text, `activate` enum('0','1') default NULL, PRIMARY KEY (`msr_id`), KEY `meta_index` (`meta_id`), KEY `metric_index` (`metric_id`), KEY `host_index` (`host_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `nagios_macro` ( `macro_id` int(11) NOT NULL auto_increment, `macro_name` varchar(255) default NULL, PRIMARY KEY (`macro_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `nagios_server` ( `id` int(11) NOT NULL auto_increment, `name` varchar(40) default NULL, `last_restart` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `purge_policy` ( `purge_policy_id` int(11) NOT NULL auto_increment, `purge_policy_name` varchar(255) default NULL, `purge_policy_alias` varchar(255) default NULL, `purge_policy_retention` int(11) default NULL, `purge_policy_raw` enum('0','1') default '0', `purge_policy_bin` enum('0','1') default '0', `purge_policy_metric` enum('0','1') default '0', `purge_policy_service` enum('0','1') default '0', `purge_policy_host` enum('0','1') default '0', `purge_policy_comment` text, PRIMARY KEY (`purge_policy_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `reporting_diff_email` ( `rtde_id` int(11) NOT NULL auto_increment, `email` varchar(255) default NULL, `format` enum('1','2') default '2', `comment` text, `activate` enum('0','1') default NULL, PRIMARY KEY (`rtde_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `reporting_diff_list` ( `rtdl_id` int(11) NOT NULL auto_increment, `name` varchar(255) default NULL, `description` varchar(255) default NULL, `tp_id` int(11) default NULL, `activate` enum('0','1') default NULL, `comment` text, PRIMARY KEY (`rtdl_id`), KEY `timeperiod_index` (`tp_id`), KEY `name_index` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `reporting_email_list_relation` ( `rtelr_id` int(11) NOT NULL auto_increment, `rtdl_id` int(11) default NULL, `rtde_id` int(11) default NULL, `oreon_contact` enum('0','1') default '0', PRIMARY KEY (`rtelr_id`), KEY `list_index` (`rtdl_id`), KEY `email_index` (`rtde_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `service` ( `service_id` int(11) NOT NULL auto_increment, `service_template_model_stm_id` int(11) default NULL, `command_command_id` int(11) default NULL, `timeperiod_tp_id` int(11) default NULL, `command_command_id2` int(11) default NULL, `timeperiod_tp_id2` int(11) default NULL, `purge_policy_id` int(11) default NULL, `service_description` varchar(200) default NULL, `service_is_volatile` enum('0','1','2') default '2', `service_max_check_attempts` int(11) default NULL, `service_normal_check_interval` int(11) default NULL, `service_retry_check_interval` int(11) default NULL, `service_active_checks_enabled` enum('0','1','2') default '2', `service_passive_checks_enabled` enum('0','1','2') default '2', `service_parallelize_check` enum('0','1','2') default '2', `service_obsess_over_service` enum('0','1','2') default '2', `service_check_freshness` enum('0','1','2') default '2', `service_freshness_threshold` int(11) default NULL, `service_event_handler_enabled` enum('0','1','2') default '2', `service_low_flap_threshold` int(11) default NULL, `service_high_flap_threshold` int(11) default NULL, `service_flap_detection_enabled` enum('0','1','2') default '2', `service_process_perf_data` enum('0','1','2') default '2', `service_retain_status_information` enum('0','1','2') default '2', `service_retain_nonstatus_information` enum('0','1','2') default '2', `service_notification_interval` int(11) default NULL, `service_notification_options` varchar(200) default NULL, `service_notifications_enabled` enum('0','1','2') default '2', `service_stalking_options` varchar(200) default NULL, `service_comment` text, `command_command_id_arg` text, `command_command_id_arg2` text, `service_register` enum('0','1') NOT NULL default '0', `service_activate` enum('0','1') NOT NULL default '1', PRIMARY KEY (`service_id`), KEY `stm_index` (`service_template_model_stm_id`), KEY `cmd1_index` (`command_command_id`), KEY `cmd2_index` (`command_command_id2`), KEY `tp1_index` (`timeperiod_tp_id`), KEY `tp2_index` (`timeperiod_tp_id2`), KEY `description_index` (`service_description`), KEY `purge_index` (`purge_policy_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `servicegroup` ( `sg_id` int(11) NOT NULL auto_increment, `sg_name` varchar(200) default NULL, `sg_alias` varchar(200) default NULL, `country_id` int(10) unsigned default NULL, `city_id` int(10) unsigned default NULL, `sg_comment` text, `sg_activate` enum('0','1') NOT NULL default '1', PRIMARY KEY (`sg_id`), KEY `name_index` (`sg_name`), KEY `alias_index` (`sg_alias`), KEY `country_index` (`country_id`), KEY `city_index` (`city_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `servicegroup_relation` ( `sgr_id` int(11) NOT NULL auto_increment, `service_service_id` int(11) default NULL, `servicegroup_sg_id` int(11) default NULL, PRIMARY KEY (`sgr_id`), KEY `service_index` (`service_service_id`), KEY `servicegroup_index` (`servicegroup_sg_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `session` ( `id` int(11) NOT NULL auto_increment, `session_id` varchar(40) default NULL, `user_id` int(11) default NULL, `current_page` int(11) default NULL, `last_reload` int(11) default NULL, `ip_address` varchar(16) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `timeperiod` ( `tp_id` int(11) NOT NULL auto_increment, `tp_name` varchar(200) default NULL, `tp_alias` varchar(200) default NULL, `tp_sunday` varchar(200) default NULL, `tp_monday` varchar(200) default NULL, `tp_tuesday` varchar(200) default NULL, `tp_wednesday` varchar(200) default NULL, `tp_thursday` varchar(200) default NULL, `tp_friday` varchar(200) default NULL, `tp_saturday` varchar(200) default NULL, PRIMARY KEY (`tp_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `topology` ( `topology_id` int(11) NOT NULL auto_increment, `topology_name` varchar(255) default NULL, `topology_icone` varchar(255) default NULL, `topology_parent` int(11) default NULL, `topology_page` int(11) default NULL, `topology_order` int(11) default NULL, `topology_group` int(11) default NULL, `topology_url` varchar(255) default NULL, `topology_url_opt` varchar(255) default NULL, `topology_popup` enum('0','1') default NULL, `topology_modules` enum('0','1') default NULL, `topology_show` enum('0','1') default '1', PRIMARY KEY (`topology_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `traps` ( `traps_id` int(11) NOT NULL auto_increment, `traps_name` varchar(255) default NULL, `traps_oid` varchar(255) default NULL, `traps_handler` varchar(255) default NULL, `traps_args` varchar(255) default NULL, `traps_comments` varchar(255) default NULL, UNIQUE KEY `traps_name` (`traps_name`), KEY `traps_id` (`traps_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `traps_service_relation` ( `tsr_id` int(11) NOT NULL auto_increment, `traps_id` int(11) default NULL, `service_id` int(11) default NULL, PRIMARY KEY (`tsr_id`), KEY `service_index` (`service_id`), KEY `traps_index` (`traps_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `view_city` ( `city_id` int(10) unsigned NOT NULL auto_increment, `country_id` int(11) unsigned default NULL, `city_name` varchar(255) default NULL, `city_zipcode` smallint(6) default NULL, `city_lat` varchar(255) default NULL, `city_long` varchar(255) default NULL, `city_date` int(11) default NULL, PRIMARY KEY (`city_id`), KEY `name_index` (`city_name`), KEY `country_index` (`country_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `view_country` ( `country_id` int(10) unsigned NOT NULL auto_increment, `country_name` varchar(255) default NULL, `country_alias` varchar(255) default NULL, PRIMARY KEY (`country_id`), KEY `name_index` (`country_name`), KEY `alias_index` (`country_alias`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    CREATE TABLE `view_map` ( `map_id` int(11) NOT NULL auto_increment, `map_name` varchar(255) default NULL, `map_description` varchar(255) default NULL, `map_path` varchar(255) default NULL, `map_comment` text, PRIMARY KEY (`map_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    ->No database selected
    ALTER TABLE `cfg_nagios` ADD CONSTRAINT `cfg_nagios_ibfk_1` FOREIGN KEY (`global_host_event_handler`) REFERENCES `command` (`command_id`) ON DELETE SET NULL, ADD CONSTRAINT `cfg_nagios_ibfk_2` FOREIGN KEY (`global_service_event_handler`) REFERENCES `command` (`command_id`) ON DELETE SET NULL, ADD CONSTRAINT `cfg_nagios_ibfk_3` FOREIGN KEY (`ocsp_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL, ADD CONSTRAINT `cfg_nagios_ibfk_4` FOREIGN KEY (`ochp_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL, ADD CONSTRAINT `cfg_nagios_ibfk_5` FOREIGN KEY (`host_perfdata_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL, ADD CONSTRAINT `cfg_nagios_ibfk_6` FOREIGN KEY (`service_perfdata_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL, ADD CONSTRAINT `cfg_nagios_ibfk_7` FOREIGN KEY (`service_perfdata_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL, ADD CONSTRAINT `cfg_nagios_ibfk_8` FOREIGN KEY (`host_perfdata_file_processing_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL, ADD CONSTRAINT `cfg_nagios_ibfk_9` FOREIGN KEY (`service_perfdata_file_processing_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL;
    ->No database selected
    ALTER TABLE `contact` ADD CONSTRAINT `contact_ibfk_1` FOREIGN KEY (`timeperiod_tp_id`) REFERENCES `timeperiod` (`tp_id`) ON DELETE SET NULL, ADD CONSTRAINT `contact_ibfk_2` FOREIGN KEY (`timeperiod_tp_id2`) REFERENCES `timeperiod` (`tp_id`) ON DELETE SET NULL;
    ->No database selected
    ALTER TABLE `contact_hostcommands_relation` ADD CONSTRAINT `contact_hostcommands_relation_ibfk_1` FOREIGN KEY (`contact_contact_id`) REFERENCES `contact` (`contact_id`) ON DELETE CASCADE, ADD CONSTRAINT `contact_hostcommands_relation_ibfk_2` FOREIGN KEY (`command_command_id`) REFERENCES `command` (`command_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `contact_servicecommands_relation` ADD CONSTRAINT `contact_servicecommands_relation_ibfk_1` FOREIGN KEY (`contact_contact_id`) REFERENCES `contact` (`contact_id`) ON DELETE CASCADE, ADD CONSTRAINT `contact_servicecommands_relation_ibfk_2` FOREIGN KEY (`command_command_id`) REFERENCES `command` (`command_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `contactgroup_contact_relation` ADD CONSTRAINT `contactgroup_contact_relation_ibfk_1` FOREIGN KEY (`contact_contact_id`) REFERENCES `contact` (`contact_id`) ON DELETE CASCADE, ADD CONSTRAINT `contactgroup_contact_relation_ibfk_2` FOREIGN KEY (`contactgroup_cg_id`) REFERENCES `contactgroup` (`cg_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `contactgroup_host_relation` ADD CONSTRAINT `contactgroup_host_relation_ibfk_1` FOREIGN KEY (`host_host_id`) REFERENCES `host` (`host_id`) ON DELETE CASCADE, ADD CONSTRAINT `contactgroup_host_relation_ibfk_2` FOREIGN KEY (`contactgroup_cg_id`) REFERENCES `contactgroup` (`cg_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `contactgroup_hostgroup_relation` ADD CONSTRAINT `contactgroup_hostgroup_relation_ibfk_1` FOREIGN KEY (`contactgroup_cg_id`) REFERENCES `contactgroup` (`cg_id`) ON DELETE CASCADE, ADD CONSTRAINT `contactgroup_hostgroup_relation_ibfk_2` FOREIGN KEY (`hostgroup_hg_id`) REFERENCES `hostgroup` (`hg_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `contactgroup_service_relation` ADD CONSTRAINT `contactgroup_service_relation_ibfk_1` FOREIGN KEY (`contactgroup_cg_id`) REFERENCES `contactgroup` (`cg_id`) ON DELETE CASCADE, ADD CONSTRAINT `contactgroup_service_relation_ibfk_2` FOREIGN KEY (`service_service_id`) REFERENCES `service` (`service_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `contactgroup_servicegroup_relation` ADD CONSTRAINT `contactgroup_servicegroup_relation_ibfk_1` FOREIGN KEY (`contactgroup_cg_id`) REFERENCES `contactgroup` (`cg_id`) ON DELETE CASCADE, ADD CONSTRAINT `contactgroup_servicegroup_relation_ibfk_2` FOREIGN KEY (`servicegroup_sg_id`) REFERENCES `servicegroup` (`sg_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `dependency_hostChild_relation` ADD CONSTRAINT `dependency_hostChild_relation_ibfk_1` FOREIGN KEY (`dependency_dep_id`) REFERENCES `dependency` (`dep_id`) ON DELETE CASCADE, ADD CONSTRAINT `dependency_hostChild_relation_ibfk_2` FOREIGN KEY (`host_host_id`) REFERENCES `host` (`host_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `dependency_hostParent_relation` ADD CONSTRAINT `dependency_hostParent_relation_ibfk_1` FOREIGN KEY (`dependency_dep_id`) REFERENCES `dependency` (`dep_id`) ON DELETE CASCADE, ADD CONSTRAINT `dependency_hostParent_relation_ibfk_2` FOREIGN KEY (`host_host_id`) REFERENCES `host` (`host_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `dependency_hostgroupChild_relation` ADD CONSTRAINT `dependency_hostgroupChild_relation_ibfk_1` FOREIGN KEY (`dependency_dep_id`) REFERENCES `dependency` (`dep_id`) ON DELETE CASCADE, ADD CONSTRAINT `dependency_hostgroupChild_relation_ibfk_2` FOREIGN KEY (`hostgroup_hg_id`) REFERENCES `hostgroup` (`hg_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `dependency_hostgroupParent_relation` ADD CONSTRAINT `dependency_hostgroupParent_relation_ibfk_1` FOREIGN KEY (`dependency_dep_id`) REFERENCES `dependency` (`dep_id`) ON DELETE CASCADE, ADD CONSTRAINT `dependency_hostgroupParent_relation_ibfk_2` FOREIGN KEY (`hostgroup_hg_id`) REFERENCES `hostgroup` (`hg_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `dependency_metaserviceChild_relation` ADD CONSTRAINT `dependency_metaserviceChild_relation_ibfk_1` FOREIGN KEY (`dependency_dep_id`) REFERENCES `dependency` (`dep_id`) ON DELETE CASCADE, ADD CONSTRAINT `dependency_metaserviceChild_relation_ibfk_2` FOREIGN KEY (`meta_service_meta_id`) REFERENCES `meta_service` (`meta_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `dependency_metaserviceParent_relation` ADD CONSTRAINT `dependency_metaserviceParent_relation_ibfk_1` FOREIGN KEY (`dependency_dep_id`) REFERENCES `dependency` (`dep_id`) ON DELETE CASCADE, ADD CONSTRAINT `dependency_metaserviceParent_relation_ibfk_2` FOREIGN KEY (`meta_service_meta_id`) REFERENCES `meta_service` (`meta_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `dependency_serviceChild_relation` ADD CONSTRAINT `dependency_serviceChild_relation_ibfk_1` FOREIGN KEY (`dependency_dep_id`) REFERENCES `dependency` (`dep_id`) ON DELETE CASCADE, ADD CONSTRAINT `dependency_serviceChild_relation_ibfk_2` FOREIGN KEY (`service_service_id`) REFERENCES `service` (`service_id`) ON DELETE CASCADE, ADD CONSTRAINT `dependency_serviceChild_relation_ibfk_3` FOREIGN KEY (`host_host_id`) REFERENCES `host` (`host_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `dependency_serviceParent_relation` ADD CONSTRAINT `dependency_serviceParent_relation_ibfk_1` FOREIGN KEY (`dependency_dep_id`) REFERENCES `dependency` (`dep_id`) ON DELETE CASCADE, ADD CONSTRAINT `dependency_serviceParent_relation_ibfk_2` FOREIGN KEY (`service_service_id`) REFERENCES `service` (`service_id`) ON DELETE CASCADE, ADD CONSTRAINT `dependency_serviceParent_relation_ibfk_3` FOREIGN KEY (`host_host_id`) REFERENCES `host` (`host_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `dependency_servicegroupChild_relation` ADD CONSTRAINT `dependency_servicegroupChild_relation_ibfk_1` FOREIGN KEY (`dependency_dep_id`) REFERENCES `dependency` (`dep_id`) ON DELETE CASCADE, ADD CONSTRAINT `dependency_servicegroupChild_relation_ibfk_2` FOREIGN KEY (`servicegroup_sg_id`) REFERENCES `servicegroup` (`sg_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `dependency_servicegroupParent_relation` ADD CONSTRAINT `dependency_servicegroupParent_relation_ibfk_1` FOREIGN KEY (`dependency_dep_id`) REFERENCES `dependency` (`dep_id`) ON DELETE CASCADE, ADD CONSTRAINT `dependency_servicegroupParent_relation_ibfk_2` FOREIGN KEY (`servicegroup_sg_id`) REFERENCES `servicegroup` (`sg_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `escalation` ADD CONSTRAINT `escalation_ibfk_1` FOREIGN KEY (`escalation_period`) REFERENCES `timeperiod` (`tp_id`) ON DELETE SET NULL;
    ->No database selected
    ALTER TABLE `escalation_contactgroup_relation` ADD CONSTRAINT `escalation_contactgroup_relation_ibfk_1` FOREIGN KEY (`escalation_esc_id`) REFERENCES `escalation` (`esc_id`) ON DELETE CASCADE, ADD CONSTRAINT `escalation_contactgroup_relation_ibfk_2` FOREIGN KEY (`contactgroup_cg_id`) REFERENCES `contactgroup` (`cg_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `escalation_host_relation` ADD CONSTRAINT `escalation_host_relation_ibfk_1` FOREIGN KEY (`escalation_esc_id`) REFERENCES `escalation` (`esc_id`) ON DELETE CASCADE, ADD CONSTRAINT `escalation_host_relation_ibfk_2` FOREIGN KEY (`host_host_id`) REFERENCES `host` (`host_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `escalation_hostgroup_relation` ADD CONSTRAINT `escalation_hostgroup_relation_ibfk_1` FOREIGN KEY (`escalation_esc_id`) REFERENCES `escalation` (`esc_id`) ON DELETE CASCADE, ADD CONSTRAINT `escalation_hostgroup_relation_ibfk_2` FOREIGN KEY (`hostgroup_hg_id`) REFERENCES `hostgroup` (`hg_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `escalation_meta_service_relation` ADD CONSTRAINT `escalation_meta_service_relation_ibfk_1` FOREIGN KEY (`escalation_esc_id`) REFERENCES `escalation` (`esc_id`) ON DELETE CASCADE, ADD CONSTRAINT `escalation_meta_service_relation_ibfk_2` FOREIGN KEY (`meta_service_meta_id`) REFERENCES `meta_service` (`meta_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `escalation_service_relation` ADD CONSTRAINT `escalation_service_relation_ibfk_1` FOREIGN KEY (`escalation_esc_id`) REFERENCES `escalation` (`esc_id`) ON DELETE CASCADE, ADD CONSTRAINT `escalation_service_relation_ibfk_2` FOREIGN KEY (`service_service_id`) REFERENCES `service` (`service_id`) ON DELETE CASCADE, ADD CONSTRAINT `escalation_service_relation_ibfk_3` FOREIGN KEY (`host_host_id`) REFERENCES `host` (`host_id`) ON DELETE CASCADE;
    ->No database selected
    ALTER TABLE `extended_host_information` ADD CONSTRAINT `extended_host_information_ibfk_1` FOREIGN KEY (`host_host_id`) REFERENCES `host` (`host_id`) ON DELETE CASCADE, ADD CONSTRAINT `extende

  • #2
    Seems there is a bug in sql script.
    It say "no databse selected".

    Hope a developper could answer you :wink:
    Intel(R) Xeon(TM) CPU 3.4GHz - MemTotal : 1034476 kB
    Centreon 2.4.1 - Nagios 3.2.1 - Nagios Plugins 1.4.15 - Manubulon Plugins tuné
    Fedora Core 5 - 2.6.20-1.2320

    Comment


    • #3
      Hi,

      could you give us more informations ? Oreon version ? php4 or php5 ? mysql version ? OS ? tanks
      StatusMap Module - NDO Tools Module - ImportCSV Module - SNMP-UI Module - PDFReports Module
      Dons Paypal

      Comment


      • #4
        Originally posted by wistof
        Hi,

        could you give us more informations ? Oreon version ? php4 or php5 ? mysql version ? OS ? tanks
        php= 5.1.6
        mysql = 5.0.22
        OS= Fedora Core 5


        hope this may be of some help

        Comment


        • #5
          anyone have any ideas on this?? :?

          cheers

          mark

          Comment

          Working...
          X