Re: Deleted network not available again?

["Adam \"Tauvix\" Debus" <northstar@delsol.net>]

Hi Hitesh,

    I just pulled down the new CVS and installed the perl modules. I'm still
having the problem where if I delete a network and don't delete the children
first, it doesn't delete the children. Again, I'm using mysql. What module
does that section of code work out of? I have the day off tomorrow, so I'll
probably take a look at it, just to see what I can see :)

Thanks,

Adam "Tauvix" Debus
Network Administrator, ReachONE Internet
adam@reachone.com

----- Original Message -----
From: "Hitesh Patel" <hitesh@presys.com>
To: "Adam "Tauvix" Debus" <northstar@delsol.net>;
<northstar-general@brownkid.net>
Sent: Thursday, April 18, 2002 10:13 PM
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-----
>
>