RE: Deleted network not available again?

["Hays, Kelly" <Kelly.Hays@ttuhsc.edu>]

Hitesh,
Is this bug still in 1.6? If so, I think I just exercised it. Did you ever
write the script to go thru and relink 'lost' blocks? If so where can I find
it?
Thanks,
  Kelly Hays


>-----Original Message-----
>From: Hitesh Patel [mailto:hitesh@presys.com]
>Sent: Friday, April 19, 2002 12:14 AM
>To: Adam "Tauvix" Debus; northstar-general@brownkid.net
>Subject: Re: Deleted network not available again?
>
>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>On Thursday 18 April 2002 17:24 pm, Adam \"Tauvix\" Debus wrote:
>> MySQL
>>
>
>Ah hah.. i knew MySQL was going to bite me in the a@@ sooner or later..
>ok..
>here we go
>
>Turns out that MySQL doesn't do REFERENCES right.. this is a problem that I
>never realized was there because mysql doesn't output any errors on it.  So
>I
>had to implement recursive delete functions in NorthStar to handle the
>removal in MySQL.. PITA if you ask me ;-)
>
>I've committed the changes to CVS along with some other fixes and will
>probably whip up a script to go thru and relink 'lost' blocks sometime
>tomorrow.
>
>
>> ----- Original Message -----
>> From: "Hitesh Patel" <hitesh@presys.com>
>> To: "Adam "Tauvix" Debus" <northstar@delsol.net>;
>> <northstar-general@brownkid.net>
>> Sent: Thursday, April 18, 2002 3:18 PM
>> Subject: Re: Deleted network not available again?
>>
>> > On Thursday 18 April 2002 13:42 pm, Adam \"Tauvix\" Debus wrote:
>> > > I have found a problem where if you delete a subnet, and it has
>>
>> children,
>>
>> > > that it doesn't delete the children. Look in the database for
>> > > individual
>>
>> IP
>>
>> > > addresses, or subnets, that came from that /24.
>> >
>> > I'm looking into why this is happening.  The rules in the db should
>make
>>
>> this
>>
>> > automatically happen.  Are you using MySQL or Postgres?
>> >
>> > > Thanks,
>> > >
>> > > Adam "Tauvix" Debus
>> > > Network Administrator, ReachONE Internet
>> > > adam@reachone.com
>> > >
>> > > ----- Original Message -----
>> > > From: "Cooper, Steve" <SCooper@newskies.com>
>> > > To: <northstar-general@brownkid.net>
>> > > Sent: Thursday, April 18, 2002 11:34 AM
>> > > Subject: Deleted network not available again?
>> > >
>> > > > Hi
>> > > >
>> > > > I deleted a subnet (a /24) and then tried to add it again, but now
>> > > > its not available in the 'Network Address' drop-down (after
>selecting
>> > > > the
>> > >
>> > > netmask).
>> > >
>> > > > Any ideas where to start looking?
>> > > >
>> > > > Excellent program BTW.
>> > > >
>> > > > Steven Cooper
>> > > > Senior Network Implementation Engineer
>> > > > New Skies Satellites UK Ltd
>> > > > email: scooper@newskies.com
>> >
>> > --
>> > +---------------------------------+----------------------------+
>> >
>> > | Hitesh Patel                    |  Voice: (541) 759-3126     |
>> > | Network Engineering Manager     |  Fax:   (541) 759-3214     |
>> > | Preferred Communications Inc.   |  Email: hitesh@pciwest.net |
>> >
>> > +---------------------------------+----------------------------+
>
>- --
>+---------------------------------+----------------------------+
>| Hitesh Patel                    |  Voice: (541) 759-3126     |
>| Network Engineering Manager     |  Fax:   (541) 759-3214     |
>| Preferred Communications Inc.	  |  Email: hitesh@pciwest.net |
>+---------------------------------+----------------------------+
>
>-----BEGIN PGP SIGNATURE-----
>Version: GnuPG v1.0.6 (GNU/Linux)
>Comment: For info see http://www.gnupg.org
>
>iD8DBQE8v6eGCws8KqPtd2URAhQyAJwKXfdL2CvUa0w7aX+mvBh0MJoIUACeKHel
>EAd3nzubkciOdsYO2uLKgEU=
>=l31B
>-----END PGP SIGNATURE-----