(RADIATOR) Needs expet's opinion

[MJ]

High Hugh,
The objective is that radiator checks that the requested user is valid or
expired even he has entered correct username and password. The user will not
enter the expiry date but the radiator should verify it from the database,
is it possible?

Thanks,
MJ
----- Original Message ----- 
From: "Hugh Irvine" <hugh at open.com.au>
To: "MJ" <php at cyberia.net.sa>
Cc: <radiator at open.com.au>
Sent: Wednesday, August 04, 2004 11:26 AM
Subject: Re: (RADIATOR) Needs expet's opinion


>
> Hello MJ -
>
> You would do something like this:
>
> # Modification start
>          AuthSelect select password, expiration, replyattr from
> subscribers \
>          where username=%0
>          AuthColumnDef 0, User-Password, check
>          AuthColumnDef 1, Expiration, check
>          AuthColumnDef 2, GENERIC, reply
> # Modification End
>
> See section 13.1.4 in the Radiator 3.9 reference manual
> ("doc/ref.html") and the examples in the "goodies" directory.
>
> regards
>
> Hugh
>
>
>
> On 3 Aug 2004, at 20:55, MJ wrote:
>
> > Hugh,
> > I need Radiator to check expiry date also along with password during
> > authentication, how we can achieve this task.
> >
> > Thanks,
> > MJ
> > ----- Original Message -----
> > From: "Hugh Irvine" <hugh at open.com.au>
> > To: "MJ" <php at cyberia.net.sa>
> > Cc: <radiator at open.com.au>
> > Sent: Tuesday, August 03, 2004 3:32 AM
> > Subject: Re: (RADIATOR) Needs expet's opinion
> >
> >
> >
> > Hello MJ -
> >
> > Your configuration file looks fine.
> >
> > regards
> >
> > Hugh
> >
> >
> > On 2 Aug 2004, at 18:12, MJ wrote:
> >
> >> Hi,
> >> We are about to buy Radiator and put it in production, I have tested
> >> the functionality with following cfg file and it seems that it is
> >> working fine but I want to have an expert's opinion on the config
> >> before I put it in the production, basically it is a slightly modified
> >> version of goodies/sql.cfg. At the moment our objective is
> >> authenticate the user from Oracle database running on remote server,
> >> send some cisco-avpair as reply attribute and generate CDRs in the
> >> same Oracle database.
> >>
> >> sql.cfg is attached with this message, sample record from subscribers
> >> table is as follows
> >>
> >> USERNAME: poolb at 64.cyberia.net.sa
> >> PASSWORD: 1234
> >> REPLYATTR: cisco-avpair="ip:addr-pool=cyberia" ,
> >> cisco-avpair="lcp:interface-config#1=rate-limit output 512000 7500
> >> 7500 conform-action continue exceed-action drop",
> >>
> >>
> >> Please suggest if we are missing some thing, or if it can be improved.
> >>
> >> Thanks,
> >> MJ
> >>
> >>
> >>
> >>
> >>
> >> <sql.cfg>
> >
> > NB: have you included a copy of your configuration file (no secrets),
> > together with a trace 4 debug showing what is happening?
> >
> > -- 
> > Radiator: the most portable, flexible and configurable RADIUS server
> > anywhere. Available on *NIX, *BSD, Windows, MacOS X.
> > -
> > Nets: internetwork inventory and management - graphical, extensible,
> > flexible with hardware, software, platform and database independence.
> > -
> > CATool: Private Certificate Authority for Unix and Unix-like systems.
> >
> > --
> > Archive at http://www.open.com.au/archives/radiator/
> > Announcements on radiator-announce at open.com.au
> > To unsubscribe, email 'majordomo at open.com.au' with
> > 'unsubscribe radiator' in the body of the message.
> >
> >
>
> NB: have you included a copy of your configuration file (no secrets),
> together with a trace 4 debug showing what is happening?
>
> -- 
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. Available on *NIX, *BSD, Windows, MacOS X.
> -
> Nets: internetwork inventory and management - graphical, extensible,
> flexible with hardware, software, platform and database independence.
> -
> CATool: Private Certificate Authority for Unix and Unix-like systems.
>
>


--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.