Hi all ~Information about my computer OS:CentOS 5.4 AP:Nagios3.2.3 and Ndoutils-1.4b9 MySQL 5
I use the ndoutils-1.4b9/db/installdb (it’s script ) to make mysql database which is called “nagios”
mysql > use nagios;
mysql > select * from nagios_servicechecks order by end_time desc limit 1;it’ output
| servicecheck_id | instance_id | service_object_id | check_type | current_check_attempt | max_check_attempts | state | state_type | start_time | start_time_usec | end_time | end_time_usec | command_object_id | command_args | command_line | timeout | early_timeout | execution_time | latency | return_code | output | long_output | perfdata
| 110040 | 1 | 62 | 0 | 1 | 4 | 0 | 1 | 2010-12-07 23:45:37 |
unfortunate , the field named command_line was empty!
[1291736137.164615] [002.0] [pid=10799] INSERT INTO nagios_servicechecks SET instance_id=‘1’,
That’s what I need data in the command_line !
luca
December 9, 2010, 10:45am
2
try executing the query from tha mysql command line or from phpmyadmin. does it throw any errors?
Hello luka~
I queried any data in the mysql environment were nothing wrong…and there were not anything error in mysqld.log and ndo2db.debug too.
should adjusted something?
thx~