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