(RADIATOR) Time check item
Anton Krall
akrall at intruder.com.mx
Thu Jan 16 16:37:27 CST 2003
This is another way ... Nice.. That's what I like about radiator... It
lets you do the sme thing using many methods.
I decided to go with the DB one I sent you because it will let the tech
support guys modify the plan attribs via the db..
Thx Hugh for the help.. As always!
__________________________________________________________________
Anton Krall
CEO
Intruder Consulting
Email: akrall at intruder.com.mx
Tel: (55)5233-9281
Celular: (044)55-5105-5160
ICQ#: 4979450
MSN: akrall at hotmail.com
AIM: antonkrall
Web: www.intruder.com.mx
Outside Mexico
Tel: (+52)555-233-9281
Celular: (+52)555-105-5160
%-----Original Message-----
%From: Hugh Irvine [mailto:hugh at open.com.au]
%Sent: Jueves, 16 de Enero de 2003 04:19 p.m.
%To: Anton Krall
%Cc: radiator at open.com.au
%Subject: Re: (RADIATOR) Time check item
%
%
%
%Hello Anton -
%
%I would suggest you do something like this:
%
%
%# define AuthBy clauses
%
%<AuthBy SQL>
% Identifier Normal
% DBSource dbi:mysql:radius:localhost
% DBUsername xxx
% DBAuth xxx
%
% AuthSelect select PASSWORD, CHECKATTR, REPLYATTR \
% from SUBSCRIBERS \
% where USERNAME=%0 and ACTIVE=1 and (PLAN=1 or PLAN=3 or PLAN=4)
%
% AuthColumnDef 0, User-Password, check
% AuthColumnDef 1, GENERIC, check
% AuthColumnDef 2, GENERIC, reply
%
% AddToReply Framed-Protocol = PPP,Framed-IP-Netmask =
%255.255.255.0,Ascend-Client-Primary-DNS=216.110.167.160,AscendClient-S
%econdary-DNS=200.52.66.125
%</AuthBy>
%
%<AuthBy SQL>
% Identifier Nocturno
% DBSource dbi:mysql:radius:localhost
% DBUsername xxx
% DBAuth xxxx
%
% AuthSelect select PASSWORD \
% from SUBSCRIBERS \
% where USERNAME=%0 and ACTIVE=1 and PLAN=2
%
% AuthColumnDef 0, User-Password, check
%
% AddToReply Framed-Protocol = PPP,Framed-IP-Netmask =
%255.255.255.0,Ascend-Client-Primary-DNS=216.110.167.160,Ascend-Client-S
%econdary-DNS=200.52.66.125,Session-timeout="until Time" </AuthBy>
%
%<AuthBy FILE>
% Identifier CheckUsers
% Filename %D/users.defaults
%</AuthBy>
%
%.....
%
%# define Realms or Handlers
%
%<Handler ....>
% AuthBy CheckUsers
% .....
%</Handler>
%
%.....
%
%
%Then the file "users.defaults" would look like this:
%
%# file users.defaults
%
%DEFAULT Time = "Wk0000-0800", Auth-Type = Nocturno
%
%DEFAULT Auth-Type = Normal
%
%
%Please let me know how you get on.
%
%regards
%
%Hugh
%
%
%On Friday, Jan 17, 2003, at 02:30 Australia/Melbourne, Anton Krall
%wrote:
%
%> Hi Hugh
%>
%> Right now.. I have 2 Authbys:
%>
%> <AuthBy SQL>
%> Identifier Normal
%> DBSource dbi:mysql:radius:localhost
%> DBUsername xxx
%> DBAuth xxx
%>
%> AuthSelect select PASSWORD, CHECKATTR, REPLYATTR \
%> from SUBSCRIBERS \
%> where USERNAME=%0 and ACTIVE=1 and (PLAN=1 or PLAN=3 or PLAN=4)
%>
%> AuthColumnDef 0, User-Password, check
%> AuthColumnDef 1, GENERIC, check
%> AuthColumnDef 2, GENERIC, reply
%>
%> AddToReply Framed-Protocol = PPP,Framed-IP-Netmask =
%>
%255.255.255.0,Ascend-Client-Primary-DNS=216.110.167.160,AscendClient-S
%> econdary-DNS=200.52.66.125
%> </AuthBy>
%>
%> <AuthBy SQL>
%> Identifier Nocturno
%> DBSource dbi:mysql:radius:localhost
%> DBUsername xxx
%> DBAuth xxxx
%>
%> AuthSelect select PASSWORD \
%> from SUBSCRIBERS \
%> where USERNAME=%0 and ACTIVE=1 and PLAN=2
%>
%> AuthColumnDef 0, User-Password, check
%>
%> Here is where I need the Time = "Wk0000-0800"
%>
%> AddToReply Framed-Protocol = PPP,Framed-IP-Netmask =
%>
%255.255.255.0,Ascend-Client-Primary-DNS=216.110.167.160,Ascend-Client-
%> S
%> econdary-DNS=200.52.66.125,Session-timeout="until Time"
%> </AuthBy>
%>
%> So that if a user has PLAN=2 on the SUBSCRIBERS db, he will
%be thrown
%> into AuthBy SQL Nocturno and will only be able to login between 0000
%> and 0800.
%>
%> __________________________________________________________________
%> Anton Krall
%> CEO
%> Intruder Consulting
%>
%> Email: akrall at intruder.com.mx
%> Tel: (55)5233-9281
%> Celular: (044)55-5105-5160
%> ICQ#: 4979450
%> MSN: akrall at hotmail.com
%> AIM: antonkrall
%> Web: www.intruder.com.mx
%>
%> Outside Mexico
%> Tel: (+52)555-233-9281
%> Celular: (+52)555-105-5160
%>
%>
%> %-----Original Message-----
%> %From: Hugh Irvine [mailto:hugh at open.com.au]
%> %Sent: Jueves, 16 de Enero de 2003 01:27 a.m.
%> %To: Anton Krall
%> %Cc: radiator at open.com.au
%> %Subject: Re: (RADIATOR) Time check item
%> %
%> %
%> %
%> %Hello Anton -
%> %
%> %As mentioned previously, the answer depends on what else you are
%> doing %in your configuration file and how you are going to recognise
%> and %process the radius requests. You can use Handlers or cascaded
%> AuthBy %clauses, it depends on what else is required. %
%> %Please outline your requirements in more detail and I will
%try to make
%> %a sensible suggestion.
%> %
%> %regards
%> %
%> %Hugh
%> %
%> %
%> %On Thursday, Jan 16, 2003, at 18:18 Australia/Melbourne, Anton Krall
%> %wrote:
%> %
%> %> If I needed to hard code the check into the authby so
%that the user
%> %> record (SQL) would only have username and pw?
%> %>
%> %> __________________________________________________________________
%> %> Anton Krall
%> %> CEO
%> %>
%> %>
%> %> %-----Original Message-----
%> %> %From: owner-radiator at open.com.au
%> %%[mailto:owner-radiator at open.com.au]
%> %> On Behalf Of Hugh Irvine
%> %> %Sent: Jueves, 16 de Enero de 2003 12:09 a.m.
%> %> %To: Anton Krall
%> %> %Cc: radiator at open.com.au
%> %> %Subject: Re: (RADIATOR) Time check item
%> %> %
%> %> %
%> %> %
%> %> %Hello Anton -
%> %> %
%> %> %A check item usually goes in a user record.
%> %> %
%> %> %Ie:
%> %> %
%> %> %someuser Password = xxxxxxx, Time = "Wk0000-0800"
%> %> % ......
%> %> %
%> %> %There are other possibilities depending on what else you
%> %are doing in
%> %> %your configuration file. %
%> %> %regards
%> %> %
%> %> %Hugh
%> %> %
%> %> %
%> %> %On Thursday, Jan 16, 2003, at 16:19 Australia/Melbourne, Anton
%> Krall
%> %> %wrote:
%> %> %
%> %> %> Guys.. I trying to make 2 AuthBy SQL.. one is a standard
%> %one and the
%> %> %> other is for a dialup plan called Nightly
%> %> %>
%> %> %> The 2nd one has to have a check item: Time = "Wk0000-0800"
%> %> %>
%> %> %> Thing is... where do I put the check item? I forgot :((((
%> %> %>
%> %> %> Thx for the help.
%> %> %>
%> %> %>
%> __________________________________________________________________
%> %> %> Anton Krall
%> %> %>
%> %> %>
%> %> %> ===
%> %> %> 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.
%> %> %>
%> %> %>
%> %> %
%> %> %--
%> %> %Radiator: the most portable, flexible and configurable RADIUS
%> %> %server anywhere. Available on *NIX, *BSD, Windows 95/98/2000,
%> %> %NT, MacOS X.
%> %> %-
%> %> %Nets: internetwork inventory and management - graphical,
%> %> %extensible, flexible with hardware, software, platform and
%> %> %database independence.
%> %> %
%> %> %===
%> %> %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.
%> %> %
%> %> %
%> %>
%> %>
%> %> ===
%> %> 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.
%> %>
%> %>
%> %
%> %--
%> %Radiator: the most portable, flexible and configurable RADIUS
%> %server anywhere. Available on *NIX, *BSD, Windows 95/98/2000,
%> %NT, MacOS X.
%> %-
%> %Nets: internetwork inventory and management - graphical,
%> %extensible, flexible with hardware, software, platform and
%> %database independence.
%> %
%> %
%> %
%>
%>
%>
%
%--
%Radiator: the most portable, flexible and configurable RADIUS
%server anywhere. Available on *NIX, *BSD, Windows 95/98/2000,
%NT, MacOS X.
%-
%Nets: internetwork inventory and management - graphical,
%extensible, flexible with hardware, software, platform and
%database independence.
%
%
%
===
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.
More information about the radiator
mailing list