主要安装ndoutils出现的问题。
启动ndoutils时出错:
/usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg
错误提示:
Support for the specified database server is either not yet supported, or was not found on your system
原因:mysql的库文件没有被加载,编译是时注意:
checking for linker flags for loadable modules... -shared
checking for mysql_config... /usr/bin/mysql_config
checking for mysql_init in -lmysqlclient... yes
MySQL library and include file(s) were found!
configure: creating ./config.status
config.status: creating Makefile
config.status: creating src/Makefile
config.status: creating docs/docbook/en-en/Makefile
config.status: creating subst
config.status: creating include/config.h
config.status: include/config.h is unchanged
alter table nagios.nagios_configfilevariablesdrop key instance_id;alter table nagios.nagios_configfilevariables add index (instance_id, configfile_id, varname);
重启naigos后还是不显示,
在看日志又出现:
localhost ndo2db-3x: mysql_error: 'Unknown column 'long_output' in 'fieldlist''
解决方法:
ALTER TABLE npc_eventhandlers ADD long_output TEXT NOT NULL DEFAULT '' AFTER output;
ALTER TABLE npc_hostchecks ADD long_output TEXT NOT NULL DEFAULT '' AFTER output;
ALTER TABLE npc_hoststatus ADD long_output TEXT NOT NULL DEFAULT '' AFTER output;
ALTER TABLE npc_notifications ADD long_output TEXT NOT NULL DEFAULT '' AFTER output;
ALTER TABLE npc_servicechecks ADD long_output TEXT NOT NULL DEFAULT '' AFTER output;
ALTER TABLE npc_servicestatus ADD long_output TEXT NOT NULL DEFAULT '' AFTER output;
ALTER TABLE npc_statehistory ADD long_output TEXT NOT NULL DEFAULT '' AFTERo utput;
ALTER TABLE npc_systemcommands ADD long_output TEXT NOT NULL DEFAULT '' AFTER output;
把以上内容写入naigos.sql
运行:
mysql -u root -p nagios < naigos.sql
输入密码:
再重启naigos。
终于出现了内容: