(RADIATOR) Time check item

[Anton Krall]

Hugh

I came up with this idea.. What do you think:

Create a new table on the radius db called radiusattribs. Inside the
table make columns named plan, attribs

So that you can use the authselect on the authby like this:

AuthSelect select PASSWORD, radiusattribs.ATTRIBS from SUBSCRIBERS,
RADIUSATTRIBS where USERNAME=%0 and ACTIVE=1 and PLAN=2 and
SUBSCRIBERS.PLAN=RADIUSATTRIBS=PLAN 

The output would be the pw and the attribs for that plan.. All as check
items.. 

And in the authby, put the sessiontime as:

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"

What do you think?? 


__________________________________________________________________
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.
%
%
%


===
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.