Re: Network object error

["Billy Huddleston" <billy@nxs.net>]

Try this..

INSERT INTO networks VALUES('0','0','4','0','Default Network','Default
network','0.0.0.0/0','0','0','0','0','0','now','0','now');

Notice the extra '0' after the third element.. Small bug in the SQL script..

----- Original Message -----
From: "Delaney, Mark" <MDelaney@colt-telecom.com>
To: <northstar-general@brownkid.net>
Sent: Thursday, February 28, 2002 8:43 AM
Subject: Network object error


>
> Hi,
> I've just installed NorthStar 1.4 for the first time, I have setup various
> Owners, Devices and Locations without too many problems.  However when I
try
> to add a network I get the following SQL error message :-
>
> add_network: INSERT INTO networks
>
(name,parent,templateid,viewid,descr,label,network,masklen,owner,device,assi
> gnuser,updateuser) VALUES('Colt UK PI Space','0','4','1','Colt PI
> Space','195.110.64.0/19','+3278782464','19','1','4','0','0');
> : : ERROR: referential integrity violation - key referenced from networks
> not found in networks
>
> I have tried running the SQL directly in PSQL :-
>
> northstar=> INSERT INTO networks
>
(name,parent,templateid,viewid,descr,label,network,masklen,owner,device,assi
> gnuser,updateuser) VALUES('Colt UK PI Space','0','4','1','Colt PI
> Space','195.110.64.0/19','+3278782464','19','1','4','0','0');
> ERROR:  <unnamed> referential integrity violation - key referenced from
> networks not found in networks
>
>
> During installation the SQL:
>
>
> northstar=> INSERT INTO networks VALUES('0','0','4','Default
> Network','Default
Network','0.0.0.0/0','0','0','0','0','0','now','0','now');
> ERROR:  pg_atoi: error in "Default Network": can't parse "Default Network"
>
> wasn't liked either!
>
> Is this is known problem with 1.4, does anyone know the quick database
fix?
> Is there any documentation on how the database should be laid out?
>
>
> regards, Mark....
>
> --
> Mark Delaney, COLT Telecommunications, IP Network Engineer
> mdelaney@colt-telecom.com, Tel: +44 207 947 1654, Mob: +44 7812 366127
>
> we make business straight.forward
>
>
>
>
****************************************************************************
*********
> COLT Telecommunications
> Registered in England No. 2452736
> Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
> Tel. 020 7390 3900
>
> This message is subject to and does not create or vary any contractual
> relationship between COLT Telecommunications, its subsidiaries or
> affiliates ("COLT") and you. Internet communications are not secure
> and therefore COLT does not accept legal responsibility for the
> contents of this message.  Any view or opinions expressed are those of
> the author. The message is intended for the addressee only and its
> contents and any attached files are strictly confidential. If you have
> received it in error, please telephone the number above. Thank you.
>
****************************************************************************
*********
>