Re: Deleted network not available again?

[Hitesh Patel <hitesh@presys.com>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thursday 23 May 2002 05:43 pm, Hays, Kelly wrote:
> 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?

Yes, the bug is still in 1.6, however, the 1.7 release takes care of the 
problem automatically based on the database system your running.  I just 
started working on the database verify script and will hopefully commit it 
tomorrow night.  

The script will go thru and check the integrity of a number of things in the 
database and allow you to choose whether to automatically fix most errors 
(mostly by re-linking to the root of the tree) or just print what is wrong.

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

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

iD8DBQE87XTtCws8KqPtd2URAh8XAJ472fSCFweNCZO4EBNIENQpPqi5cgCeLso+
c6CtS3QGsXlX2OkPXHQ0FAU=
=YKpc
-----END PGP SIGNATURE-----