Re: Deleted network not available again?

[Hitesh Patel <hitesh@presys.com>]

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