Nothing in the ndologs directory. import_ndologs is definitely
running. The only errors in opsviewd.log are a ton of:
[2010/06/08 15:07:00] [ndoutils_configdumpend] [FATAL] DBD::mysql::db
do failed: Unknown column 'k.all_hosts' in 'where clause' [for
Statement "
INSERT INTO opsview_viewports_temporary
SELECT
k.id,
k.name,
ohs.hostname,
ohs.servicename,
ohs.host_object_id,
ohs.service_object_id
FROM
opsview.keywords as k,
opsview.keywordservicechecks as ksc,
opsview.servicechecks as sc,
runtime.opsview_host_services ohs
WHERE
k.id = ksc.keywordid
AND ksc.servicecheckid = sc.id
AND (ohs.servicename = sc.name || ohs.servicename like concat(sc.name,': %') )
AND k.all_hosts = 1
"]
[2010/06/08 15:07:11] [ndoutils_configdumpend] [INFO] End
This is interesting... the host shows up in runtime.nagios_hosts but
does NOT in runtime.opsview_hosts
mysql> select * from nagios_hosts where display_name like 'oracle%'\G
*************************** 1. row ***************************
host_id: 2720
instance_id: 1
config_type: 1
host_object_id: 3176
alias: oracleapps-vip
display_name: oracleapps-vip
address: oracleapps.mydomain.com
check_command_object_id: 0
check_command_args:
eventhandler_command_object_id: 0
eventhandler_command_args:
notification_timeperiod_object_id: 62
check_timeperiod_object_id: 62
failure_prediction_options:
check_interval: 0
retry_interval: 1
max_check_attempts: 2
first_notification_delay: 0
notification_interval: 15
notify_on_down: 1
notify_on_unreachable: 0
notify_on_recovery: 1
notify_on_flapping: 0
notify_on_downtime: 0
stalk_on_up: 0
stalk_on_down: 0
stalk_on_unreachable: 0
flap_detection_enabled: 1
flap_detection_on_up: 1
flap_detection_on_down: 1
flap_detection_on_unreachable: 1
low_flap_threshold: 0
high_flap_threshold: 0
process_performance_data: 1
freshness_checks_enabled: 0
freshness_threshold: 0
passive_checks_enabled: 1
event_handler_enabled: 0
active_checks_enabled: 1
retain_status_information: 1
retain_nonstatus_information: 1
notifications_enabled: 1
obsess_over_host: 0
failure_prediction_enabled: 1
notes:
notes_url:
action_url: /info/host/621
icon_image: website.png
icon_image_alt: SYMBOL - Web Site
vrml_image: website.png
statusmap_image: website.png
have_2d_coords: 0
x_2d: -1
y_2d: 0
have_3d_coords: 0
x_3d: 0
y_3d: 0
z_3d: 0
1 row in set (0.00 sec)
mysql> select * from opsview_hosts where name like 'oracle%';
Empty set (0.00 sec)
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users
