Cacti NPC still will not render any data

[ljernstadt]

This is being logged to the system log.
Cacti can resolve the MySql server, and I tried just using the address, but not sure where NPC is grabbing the host name now.


[Sat Oct 10 09:55:53 2009] [error] [client ] PHP Fatal error:
Uncaught exception 'Doctrine_Connection_Exception' with message 'PDO Connection Error:
SQLSTATE[HY000] [2005] Unknown MySQL server host ''mysql.XXXXXX.com'' (1)'
in /var/www/html/cacti/plugins/npc/lib/Doctrine/Connection.php:
471\nStack trace:\n#0 /var/www/html/cacti/plugins/npc/lib/Doctrine/Connection/Mysql.php(101):
Doctrine_Connection->connect()\n#1 /var/www/html/cacti/plugins/npc/lib/Doctrine/Connection.php(1009):
Doctrine_Connection_Mysql->connect()\n#2 /var/www/html/cacti/plugins/npc/lib/Doctrine/Query/Abstract.php(986):
Doctrine_Connection->execute('SELECT n.servic...', Array)\n#3 /var/www/html/cacti/plugins/npc/lib/Doctrine/Query/Abstract.php(1030): Doctrine_Query_Abstract->_execute(Array)\n#4 /var/www/html/cacti/plugins/npc/controllers/servicegroups.php(335): Doctrine_Query_Abstract->execute(Array, 3)\n#5 /var/www/html/cacti/plugins/npc/controllers/servicegroups.php(352): NpcServicegroupsController->getServicegroups()\n#6 /var/www/html/cacti/plugins/npc/controllers/servicegroups.php(122): NpcServicegroupsCon in /var/www/html/cacti/plugins/npc/lib/Doctrine/Connection.php on line 471, referer: http://hq-cacti4/cacti/plugins/npc/npc. ... drawLayout


This firebug was with a host set to a down status.
The database had the correct information.

Firebug
http://XXXXXXXX/cacti/plugins/npc/npc.p ... me&start=0

Respose is empty

[ljernstadt]

I meant for this to be a reply to the plugin thread. but
in reading the last post there

Well, I finally got things working...

Missed the part about not creating a nagios database for ndoutils so wasn't sure why I wasn't seeing anything.

Changed to using cacti's database and things started working.

Though wondering why localhost doesn't show up in the hosts/services list, currently it's the only thing being monitored by nagios.

I am wondering if this could be part of my problem.
I am using nagiosql as a configuration front end. It is using a database named nagios for its info, but ndo2db is pointed to the cacti database.