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

Reply via email to