[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: Network object error



That worked, thanks Billy!, -
though now I have another issue, when I add networks it doesn't seem to put
them into a tree, I end up with a flat networks table :-


northstar=> select * from networks;
 id | parent | templateid | viewid |          name           |      descr
|      label      |  network   | masklen | owner | device | assignuser |
assigndate       | updateuser |        upddate         
----+--------+------------+--------+-------------------------+--------------
----+-----------------+------------+---------+-------+--------+------------+
------------------------+------------+------------------------
  0 |      0 |          4 |      0 | Default Network         | Default
network  | 0.0.0.0/0       |          0 |       0 |     0 |      0 |
0 | 2002-02-28 15:22:58+00 |          0 | 2002-02-28 15:22:58+00
  7 |      0 |          4 |      1 | Colt UK PI Space        | Colt UK PI
Space | 195.110.64.0/19 | 3278782464 |      19 |     1 |      6 |          0
| 2002-02-28 15:44:16+00 |          0 | 2002-02-28 15:56:57+00
  8 |      0 |          4 |      1 | Colt UK PI Space        | Colt UK PI
Space | 213.86.0.0/16   | 3579183104 |      16 |     1 |      6 |          0
| 2002-02-28 15:52:16+00 |          0 | 2002-02-28 15:57:37+00
  9 |      0 |          4 |      1 | For /26 allocation      |
| 213.86.75.0/24  | 3579202304 |      24 |     1 |      6 |          0 |
2002-02-28 15:58:57+00 |          0 | 2002-02-28 15:58:57+00
 10 |      0 |          4 |      1 | Argyll Business Centres |
| 213.86.103.0/24 | 3579209472 |      24 |     1 |      6 |          0 |
2002-02-28 16:06:57+00 |          0 | 2002-02-28 16:06:57+00
(5 rows)

northstar=> 

I persume the 'parent' numbers should match back to the 'id' in a
parent/child relationship ?

any ideas ... or should I start digging into NorthStar.cgi?


thanks and 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




> -----Original Message-----
> From: Billy Huddleston [mailto:billy@nxs.net]
> Sent: 28 February 2002 14:05
> To: Delaney, Mark; northstar-general@brownkid.net
> Subject: Re: Network object error
> 
> 
> 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,own
> er,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,own
> er,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.
> >
> **************************************************************
> **************
> *********
> >
> 


*************************************************************************************
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.
*************************************************************************************