On Sun, Aug 07, 2005 at 12:31:15PM -0400, Brian Facey wrote:
> I am able to perform manual discovery using v. 0.8.2.
>
> However, I cannot automatically discover my network using PostgreSQL.
>
> Here is the error that I receive:
>
> Query Failed - table_insert(nad_networks) - insert into nad_networks
> (network, deep, parent,oper_status,seed,oper_status_changed,id) VALUES
> ('x.x.x.0/24','1','1','0','2','1123435931','') - ERROR invalid input
> syntax for interger: ""
Rightly so, '' is not a number!
But why is the code trying to insert into the database an id in the
first place?
> Please advise if this is a limitation of PostgreSQL or if JFFNMS table
> insert syntax needs to be modified (looks like id field is blank) for
> PostgreSQL.
I suspect it is a bug in JFFNMS. Usually you let the database itself
choose the id.
- Craig
--
Craig Small GnuPG:1C1B D893 1418 2AF4 45EE 95CB C76C E5AC 12CA DFA5
Eye-Net Consulting http://www.enc.com.au/ MIEE Debian developer
csmall at : enc.com.au ieee.org debian.org
-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
jffnms-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jffnms-users
