分类: 系统运维
2016-01-16 14:41:24
查找报错关键字mysql_error: ‘Unknown column ‘long_output’ in ‘field list”,最后在cacti官方论坛上找到,修改如下表
[root@cacti-nagios etc]# mysql -ucacti -p123456 mysql> use cacti; mysql> alter table npc_eventhandlers add long_output TEXT NOT NULL default '' after output; mysql> alter table npc_hostchecks add long_output TEXT NOT NULL default '' after output; mysql> alter table npc_hoststatus add long_output TEXT NOT NULL default '' after output; mysql> alter table npc_notifications add long_output TEXT NOT NULL default '' after output; mysql> alter table npc_servicechecks add long_output TEXT NOT NULL default '' after output; mysql> alter table npc_servicestatus add long_output TEXT NOT NULL default '' after output; mysql> alter table npc_statehistory add long_output TEXT NOT NULL default '' after output; mysql> alter table npc_systemcommands add long_output TEXT NOT NULL default '' after output; [root@cacti-nagios ~]# /etc/init.d/nagios restart [root@cacti-nagios ~]# /etc/init.d/httpd restart