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: [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 04:19 p.m. %To: Anton Krall %Cc: [EMAIL PROTECTED] %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: [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.
