Using top, I found the idle time percentage fluatuates between 94% to
99%. The cpu is a humble PII-300. Both the Radiator and MySQL runs on
the same box. The Deletequeue statement is defined as:
delete from RADONLINE where (NASIDENTIFIER='%N' and
NASPORT=0%{NAS-Port}) or (FRAMEDIPADDRESS = '%{Fram
ed-IP-Address}' and USERNAME <> '%n')
I believe this should entertain MPPP problems as well.
Hugh Irvine wrote:
>
> 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.
--
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.
