Re: error referential integrity

[Hitesh Patel <hitesh@presys.com>]

On Friday 12 July 2002 10:16 am, Tony Mesias wrote:
> Got everything installed and everything, but when I try to add a network I
> get the following:
>
>       add_address_range: INSERT INTO networks
>      
> (name,parent,templateid,viewid,status,descr,label,network,masklen,owner,dev
>ice,location,priority,assignuser,updateuser)
>
>       VALUES('VLAN350 MLM NOC
>
>       
Net','0','4','1','1','','57.8.194.0/24','956875264','24','1','4','3','5','0','0');:
>       : ERROR: referential integrity violation - key referenced from
>
>       networks not found in networks
> Please contact the site administrator for more details.
> NorthStar:/usr/NorthStar/lib/dbutil.lib:41
>

Hmm.. looks like the default network didn't get put into the database... try 
executing this SQL (it might word wrap so be sure to paste it as one line)

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


-- 
+---------------------------------+----------------------------+
| Hitesh Patel                    |  Lead Developer            |
| hitesh@presys.com               |  NorthStar                 |
+---------------------------------+----------------------------+
| NorthStar: http://www.brownkid.net/NorthStar/                |
| PGP Key:   http://www.brownkid.net/pgpkey.asc                |
+--------------------------------------------------------------+