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: [EMAIL PROTECTED]
Tel: (55)5233-9281
Celular: (044)55-5105-5160
ICQ#: 4979450
MSN: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
%Sent: Jueves, 16 de Enero de 2003 01:27 a.m.
%To: Anton Krall
%Cc: [EMAIL PROTECTED]
%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: [EMAIL PROTECTED]
%%[mailto:[EMAIL PROTECTED]]
%> On Behalf Of Hugh Irvine
%> %Sent: Jueves, 16 de Enero de 2003 12:09 a.m.
%> %To: Anton Krall
%> %Cc: [EMAIL PROTECTED]
%> %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 [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. 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 [EMAIL PROTECTED]
%> %To unsubscribe, email '[EMAIL PROTECTED]' with
%> %'unsubscribe radiator' in the body of the message.
%> %
%> %
%>
%>
%> ===
%> Archive at http://www.open.com.au/archives/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. 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.