There's a bug with Postgres and NAD. You may want to look into the list archives for the patch that fixes the problem.
Javier Christopher L Grundemann wrote:
Hello, I am actually having two problems. The first is with network (auto)discovery; I set up two zones and enabled Network Discovery on both with this result - every time I view either zone it says only: 'Error / No Items Found' I am using PostgreSQL-7.4.8 and PHP-4.3.9-3.9 so I do not think I need to patch. My OS is CentOS_4.2 I ran php -q autodiscovery_network.php master 5 from /opt/jffnms/ with the following result: 13:56:23 db_ping(pg) Connection to DB Restored... 13:56:24 db_ping(pg) Connection to DB Restored... 13:56:25 db_ping(pg) Connection to DB Restored... 13:56:26 db_ping(pg) Connection to DB Restored... 13:56:27 db_ping(pg) Connection to DB Restored... 13:56:27 Query Failed - table_insert(nad_networks) - insert into nad_networks (network,deep,parent,oper_status,seed,oper_status_changed,id) VALUES ('10.0.0.0/22','1','1','0','2','1136926582','') - ERROR: invalid input syntax for integer: "" 13:56:28 db_ping(pg) Connection to DB Restored... 13:56:29 db_ping(pg) Connection to DB Restored... 13:56:30 db_ping(pg) Connection to DB Restored... 13:56:31 db_ping(pg) Connection to DB Restored... 13:56:32 db_ping(pg) Connection to DB Restored... 13:56:32 Query Failed - table_insert(nad_networks) - insert into nad_networks (network,deep,parent,oper_status,seed,oper_status_changed,id) VALUES ('208.42.229.160/28','1','1','0','4','1136926587','') - ERROR: invalid input syntax for integer: "" 13:56:32 Launcher Starting. Parameters: childs: 5, Timeout: 240, item Retries: 2, Rest Time: 3 secs, Read Timeout: 3, Child Hearbeat every 5 secs. 13:56:35 Number Network Deep/Max Status Changed IDs 13:56:35 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =-=-=-=-=-=-=- 13:56:35 ITEMS Added 0 items 13:56:38 Number Network Deep/Max Status Changed IDs 13:56:38 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =-=-=-=-=-=-=- 13:56:38 Launcher Ended. Parameters: childs: 5, Timeout: 240, item Retries: 2, Rest Time: 3 secs, Read Timeout: 3, child Hearbeat every 5 secs. Total Time: 16 sec All Items were processed correctly. I also can not use the add button in the web interface to add an interface to submaps nor hosts. I do not know if the problems are related or not. Interface autodiscovery works fine on manually entered hosts. This is my first time with jffnms so it is probably my kludge but I have not found any solutions searching the list archive; any ideas? thx ~Christopher L. Grundemann WavMax ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ jffnms-users mailing list jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users
-- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Javier Szyszlican, Project Leader, JFFNMS [EMAIL PROTECTED] I hope JFFNMS or I were helpful to you, if you can, please donate at http://jffnms.org/donate ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ jffnms-users mailing list jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users