Re: Deleted network not available again?

[Hitesh Patel <hitesh@presys.com>]

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

On Tuesday 23 April 2002 07:02 pm, Adam \"Tauvix\" Debus wrote:
> 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 :)
>

The code works fine on my side... If you look in Network.pm under the DelNet 
function you'll see a section of code that checks to see if you using mysql 
(by looking at the DatabaseDriver directive in the config file) and then 
either does a normal delete or calls RecursiveDelete (Util.pm) with a table 
name and the id of the network to be deleted.  I'm adding some debugging 
calls to that section of code right now and that will probably help trace 
down where your specific problem is.  I should have it checked in later 
tonight.

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

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

iD8DBQE8xfq8Cws8KqPtd2URAjlVAJ0eHtS3HyzQih1xmPy7M5IoD8S6HQCfWEwC
kOOLl/IQ6xAvk03tPTc3CEk=
=3Ivb
-----END PGP SIGNATURE-----