Hello Clement -
Thanks for your feedback. One question regarding your implementation - do you
see much performance degradation using the more complicated DeleteQuery? Aaron
reported a significant performance hit and I wondered what you were seeing?
many thanks
Hugh
On Mon, 19 Jun 2000, Clement wrote:
> Yes, it works well. Thank you very much.
>
> Hugh Irvine wrote:
> >
> > Hello all -
> >
> > On Thu, 15 Jun 2000, Aaron Holtz wrote:
> > > I'm not sure that is correct. If you look at the code, DeleteQuery runs
> > > right before a new session is entered into the online database. So if
> > > your query includes removing the Framed IP from the database you should be
> > > good to go. Using the ping type and changing up your DeleteQuery should
> > > keep your online database almost perfect. The only instance where things
> > > can get goofy are when a Stop packet is lost and the next user who gets
> > > the Framed IP of the lost Stop packet user has their Start packet lost.
> > > Just modify your DeleteQuery statement per Mike's previous suggestion and
> > > you should be all set.
> > >
> >
> > Aaron is correct, here is the code from SessSQL.pm:
> >
> > sub add
> > {
> > my ($self, $name, $nas_id, $nas_port, $p) = @_;
> >
> > # (Re)-connect to the database if necessary,
> > return undef
> > if !$self->reconnect;
> >
> > &main::log($main::LOG_DEBUG,
> > "$self->{Identifier} Adding session for $name, $nas_id, $nas_port
> > ");
> > # Delete any existing session on this port first: its clearly defunct
> > my $q = &Radius::Util::format_special($self->{DeleteQuery}, $p);
> > $self->do($q);
> >
> > # Now add the new one
> > $q = &Radius::Util::format_special($self->{AddQuery}, $p);
> > $self->do($q);
> > }
> >
> > As you can see, the DeleteQuery is run immediately before the new session is
> > added. I've copied this to Mike so he can add something to the documentation.
> >
> > Thanks
> >
> > Hugh
> >
> > --
> > Radiator: the most portable, flexible and configurable RADIUS server
> > anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
> > Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
> > Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
> >
> > ===
> > Archive at http://www.starport.net/~radiator/
> > Announcements on [EMAIL PROTECTED]
> > To unsubscribe, email '[EMAIL PROTECTED]' with
> > 'unsubscribe radiator' in the body of the message.
>
> --
>
> Regards,
>
> Clement
> ANS Communications P/L
> ===============================================
> Post Addr: P O Box 6626 Blacktown BC, NSW 2148
> Tel: (02) 9552 1655 Fax: (02) 9972 2633
>
> ===
> Archive at http://www.starport.net/~radiator/
> Announcements on [EMAIL PROTECTED]
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
