NPC Not Showing Any Data

[jcampo]

Hi,

I have installed cacti with the npc plugig on ubuntu. Everything comes up fine and the npc tab is avialible in cacti. However when I select the N2C link to import my nagios hosts into cacti there is nothing available.

So basically i have no data in cacti.

I have checked the Cacti (npc_ tables) DB and data has been populated. NDO2DB comes up fine and there is no error logs in syslog or apache.logs.

Any help would be greatly appreciated!

Thanks!

[saidln]

HAVE YOU SEEN IN THE LOG FILE "/var/log/messages" this error:

nagios ndo2db: mysql_error: 'Unknown column 'long_output' in 'field list''

i dont know why but there tables with missing fields. Just run the next sentences:

mysql -u cactiuser -p cacti

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 '' after output;
alter table npc_systemcommands add long_output TEXT NOT NULL default '' after output;

sorry for my english

[jalovic]

Thank you very much.

It has been 4 days i'm trying to resolve this issue, i looked the apache2 log, the nagios log, the ndo2db debug files, i repeated the installation from scratch many times to avoid missing something. But i've missed message log.

however I'm still having an error on importing hosts from Nagios to Cacti with N2C.

Thanks a lot saidln.

[Elian]

Try using ndoutils-1.4b7

It worked for me.

[aperezbios]

saidln, the alter table example you provided fixed this problem for me, using ndoutils-1.4b9, and I just wanted to share that with others. Thank you