Hello Janet -
I think you have two choices:
1. change over to SessionDatabase SQL and use the DeleteQuery
2. modify the code in SessDBM.pm (sub delete) to do what you require
regards
Hugh
On Thu, 07 Sep 2000, Janet N del Mundo wrote:
> Hi Hugh,
>
> In my radius.cfg, I'm using SessionDatabase DBM. Doesn't "DeleteQuery"
> only work for SessionDatabase SQL? I put that "DeleteQuery" command in
> my config file and I get an error message:
>
> Thu Sep 7 13:35:30 2000: ERR: Unknown keyword 'DeleteQuery' in gcc.cfg
> line 84
>
> Thanks,
> Janet
>
>
> Hugh Irvine wrote:
> >
> > Hello Janet -
> >
> > The simplest thing is probably to supply your own DeleteQuery for the
> > SessionDatabase, something like this:
> >
> > DeleteQuery delete from RADONLINE where USERNAME='%n' and \
> > NASIDENTIFIER='%N' and ACCTSESSIONID=%{Acct-Session-Id}
> >
> > Please let me know how you get on.
> >
> > regards
> >
> > Hugh
> >
> > On Thu, 07 Sep 2000, Janet N del Mundo wrote:
> > > Hi everyone,
> > >
> > > Is anyone having problems with hung ISDN sessions on radwho with
> > > TotalControl HiPer DSPs?
> > >
> > > Everytime an ISDN user logs into a HiPer DSP his 2nd channel does not
> > > disconnect from radwho. I've noticed in the accounting logs that there
> > > is no 'Stop' session for the 2nd channel. Also, the Acct-Session-Id is
> > > the same for both channels. Is this right? If so, how do I update the
> > > radwho.cgi program for this?
> > >
> > > This is causing problems for our ISDN users. When a user logs in the
> > > next time around, radwho still sees that second session there and will
> > > only allow the user (1) channel.
> > >
> > > Any suggestions?
> > >
> > > Thanks,
> > > Janet
> > >
> > >
> > > Thu Aug 31 17:12:06 2000
> > > User-Name = "mikesan+static"
> > > NAS-IP-Address = 202.128.65.11
> > > Acct-Status-Type = Start
> > > -> Acct-Session-Id = "34471939"
> > > Acct-Delay-Time = 0
> > > Acct-Authentic = RADIUS
> > > Service-Type = Framed-User
> > > NAS-Port-Type = ISDN
> > > -> NAS-Port = 527
> > > Calling-Station-Id = "removed"
> > > Called-Station-Id = "removed"
> > > Framed-Protocol = PPP
> > > Framed-IP-Address = 202.128.69.13
> > > Timestamp = 967705926
> > > Request-Authenticator = Unverified
> > >
> > > Thu Aug 31 17:12:08 2000
> > > User-Name = "mikesan+static"
> > > NAS-IP-Address = 202.128.65.11
> > > Acct-Status-Type = Start
> > > -> Acct-Session-Id = "34471939"
> > > Acct-Delay-Time = 0
> > > Acct-Authentic = RADIUS
> > > Service-Type = Framed-User
> > > NAS-Port-Type = ISDN
> > > -> NAS-Port = 526
> > > Calling-Station-Id = "removed"
> > > Called-Station-Id = "removed1"
> > > Framed-Protocol = PPP
> > > Framed-IP-Address = 202.128.69.13
> > > Timestamp = 967705928
> > > Request-Authenticator = Unverified
> > >
> > > Thu Aug 31 17:12:49 2000
> > > User-Name = "mikesan+static"
> > > NAS-IP-Address = 202.128.65.11
> > > Acct-Status-Type = Stop
> > > -> Acct-Session-Id = "34471939"
> > > Acct-Delay-Time = 0
> > > Acct-Authentic = RADIUS
> > > Service-Type = Framed-User
> > > NAS-Port-Type = ISDN
> > > -> NAS-Port = 527
> > > Calling-Station-Id = "removed"
> > > Called-Station-Id = "removed"
> > > Framed-Protocol = PPP
> > > Framed-IP-Address = 202.128.69.13
> > > Acct-Session-Time = 41
> > > Acct-Terminate-Cause = User-Request
> > > Acct-Input-Octets = 1774
> > > Acct-Output-Octets = 1900
> > > Timestamp = 967705969
> > > Request-Authenticator = Unverified
> > >
> > > ===
> > > 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.
--
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.
