<DIV>Arran,</DIV>
<DIV> </DIV>
<DIV>Thanks for your help as always.</DIV>
<DIV> </DIV>
<DIV>You have helped me to fix about 5 of my major issues.</DIV>
<DIV> </DIV>
<DIV>The support from you is very helpful.</DIV>
<DIV> </DIV>
<DIV>Thanks!</DIV>
<DIV> </DIV>
<DIV>Tom</DIV>
<DIV><includetail>
<DIV> </DIV>
<DIV> </DIV>
<DIV style="COLOR: #000">
<DIV style="PADDING-BOTTOM: 2px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; FONT-FAMILY: Arial Narrow; FONT-SIZE: 12px; PADDING-TOP: 2px">------------------ Original ------------------</DIV>
<DIV style="PADDING-BOTTOM: 8px; PADDING-LEFT: 8px; PADDING-RIGHT: 8px; BACKGROUND: #efefef; FONT-SIZE: 12px; PADDING-TOP: 8px">
<DIV id=menu_sender><B>From: </B> "freeradius-users"<freeradius-users-request@lists.freeradius.org>;</DIV>
<DIV><B>Date: </B> Wed, Sep 14, 2011 09:27 AM</DIV>
<DIV><B>To: </B> "freeradius-users"<freeradius-users@lists.freeradius.org>; <WBR></DIV>
<DIV></DIV>
<DIV><B>Subject: </B> Freeradius-Users Digest, Vol 77, Issue 53</DIV></DIV>
<DIV> </DIV>Send Freeradius-Users mailing list submissions to<BR>freeradius-users@lists.freeradius.org<BR><BR>To subscribe or unsubscribe via the World Wide Web, visit<BR>http://lists.freeradius.org/mailman/listinfo/freeradius-users<BR>or, via email, send a message with subject or body 'help' to<BR>freeradius-users-request@lists.freeradius.org<BR><BR>You can reach the person managing the list at<BR>freeradius-users-owner@lists.freeradius.org<BR><BR>When replying, please edit your Subject line so it is more specific<BR>than "Re: Contents of Freeradius-Users digest..."<BR><BR><BR>Today's Topics:<BR><BR> 1. Re: Quick enable/disable user account. (Arran Cudbard-Bell)<BR> 2. Re: Quick enable/disable user account. (Marinko Tarlac)<BR> 3. Re:Grant Access ( 2394263740 )<BR><BR><BR>----------------------------------------------------------------------<BR><BR>Message: 1<BR>Date: Tue, 13 Sep 2011 22:32:06 +0200<BR>From: Arran Cudbard-Bell <a.cudbardb@freeradius.org><BR>Subject: Re: Quick enable/disable user account.<BR>To: FreeRadius users mailing list<BR><freeradius-users@lists.freeradius.org><BR>Message-ID: <99359D5B-34B0-4277-BCE7-379EF2FC48F4@freeradius.org><BR>Content-Type: text/plain; charset=us-ascii<BR><BR><BR>> So what are the most proper ways to mark a user in an sql database as either active or inactive, enabled or disabled?<BR><BR><BR>It's implementation specific! FreeRADIUS gives you the tools to defined the policies, but its up to the individual administrators to decide what they should be.<BR><BR>Like Skinning Cats and Perl, there are many ways to achieve the same result.<BR><BR>-Arran<BR><BR>Arran Cudbard-Bell<BR>a.cudbardb@freeradius.org<BR><BR>RADIUS - Waging war on ignorance and apathy one Access-Challenge at a time.<BR><BR><BR><BR><BR>------------------------------<BR><BR>Message: 2<BR>Date: Tue, 13 Sep 2011 23:01:03 +0200<BR>From: Marinko Tarlac <mangia81@gmail.com><BR>Subject: Re: Quick enable/disable user account.<BR>To: FreeRadius users mailing list<BR><freeradius-users@lists.freeradius.org><BR>Message-ID: <4E6FC48F.7060201@gmail.com><BR>Content-Type: text/plain; charset=UTF-8; format=flowed<BR><BR>Imagine that you have 5 000 disabled accounts and that you constantly <BR>rejecting them over and over again...<BR><BR>Better option is to create specific group (for example disabled_accounts <BR>with specific IP Pool) and assign users to this group when you want to <BR>block them. Then you can redirect them to specific web page with <BR>"welcome" message :)<BR><BR><BR><BR>On 9/13/2011 5:59 PM, Tim Sylvester wrote:<BR>><BR>> Set Auth-Type := Reject in radcheck.<BR>><BR>> http://deployingradius.com/documents/configuration/auth_type.html<BR>><BR>> Tim<BR>><BR>> *From:*freeradius-users-bounces+tim.sylvester=networkradius.com@lists.freeradius.org <BR>> [mailto:freeradius-users-bounces+tim.sylvester=networkradius.com@lists.freeradius.org] <BR>> *On Behalf Of *2394263740<BR>> *Sent:* Tuesday, September 13, 2011 8:33 AM<BR>> *To:* freeradius-users<BR>> *Subject:* Quick enable/disable user account.<BR>><BR>> Hello,<BR>> I'm using free radius server 2.1.11 on Linux Enterprise Server 6.1.<BR>> OS: Linux Enterprise Server 6.1<BR>> Radius: free radius server 2.1.11<BR>> Database: Mysql<BR>><BR>> Sometime, I need disable a user account in mysql database. And then <BR>> enable it later on after some check complete.<BR>><BR>> Can you please advise how to toggle such status?<BR>><BR>> There're may be multiple solutions, please advise them all, so I can <BR>> choose a one most fit the needs.<BR>><BR>> Thanks!<BR>><BR>> Tom<BR>><BR>><BR>> -<BR>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<BR><BR><BR><BR>------------------------------<BR><BR>Message: 3<BR>Date: Wed, 14 Sep 2011 09:27:00 +0800<BR>From: " 2394263740 " <2394263740@qq.com><BR>Subject: Re:Grant Access<BR>To: " freeradius-users " <freeradius-users@lists.freeradius.org><BR>Message-ID: <tencent_7839F3D17E696E8063A56BF4@qq.com><BR>Content-Type: text/plain; charset="iso-8859-1"<BR><BR>Arran,<BR> <BR> I'm using PEAP. Do you have any suggestion to grant access?<BR> <BR> Thanks!<BR> <BR> <BR> ------------------ Original ------------------<BR> From: "freeradius-users"<freeradius-users-request@lists.freeradius.org>;<BR> Date: Tue, Sep 13, 2011 11:59 PM<BR> To: "freeradius-users"<freeradius-users@lists.freeradius.org>; <BR> <BR> Subject: Freeradius-Users Digest, Vol 77, Issue 50<BR><BR> <BR>Send Freeradius-Users mailing list submissions to<BR>freeradius-users@lists.freeradius.org<BR><BR>To subscribe or unsubscribe via the World Wide Web, visit<BR>http://lists.freeradius.org/mailman/listinfo/freeradius-users<BR>or, via email, send a message with subject or body 'help' to<BR>freeradius-users-request@lists.freeradius.org<BR><BR>You can reach the person managing the list at<BR>freeradius-users-owner@lists.freeradius.org<BR><BR>When replying, please edit your Subject line so it is more specific<BR>than "Re: Contents of Freeradius-Users digest..."<BR><BR><BR>Today's Topics:<BR><BR> 1. Grant Access ( 2394263740 )<BR> 2. Re: Grant Access (Arran Cudbard-Bell)<BR> 3. Quick enable/disable user account. ( 2394263740 )<BR> 4. Re: Quick enable/disable user account. (Alan DeKok)<BR> 5. Re: Quick enable/disable user account. (Arran Cudbard-Bell)<BR> 6. RE: Quick enable/disable user account. (Tim Sylvester)<BR><BR><BR>----------------------------------------------------------------------<BR><BR>Message: 1<BR>Date: Tue, 13 Sep 2011 23:07:31 +0800<BR>From: " 2394263740 " <2394263740@qq.com><BR>Subject: Grant Access<BR>To: " freeradius-users " <freeradius-users@lists.freeradius.org><BR>Message-ID: <tencent_1ABBB04B470455063AD97831@qq.com><BR>Content-Type: text/plain; charset="iso-8859-1"<BR><BR>Hello,<BR>I'm using free radius server 2.1.11 on Linux Enterprise Server 6.1.<BR>OS: Linux Enterprise Server 6.1<BR>Radius: free radius server 2.1.11<BR>Database: Mysql<BR> <BR> When the system goes wrong, I would like temporary grant all access request.<BR> <BR> Which means during the service is down, any username/password will be grant access.<BR> <BR> Can you please advise the solution?<BR> <BR> Thanks!<BR> <BR> Tom<BR>-------------- next part --------------<BR>An HTML attachment was scrubbed...<BR>URL: <https://lists.freeradius.org/pipermail/freeradius-users/attachments/20110913/89760c49/attachment.html><BR><BR>------------------------------<BR><BR>Message: 2<BR>Date: Tue, 13 Sep 2011 17:16:02 +0200<BR>From: Arran Cudbard-Bell <a.cudbardb@freeradius.org><BR>Subject: Re: Grant Access<BR>To: FreeRadius users mailing list<BR><freeradius-users@lists.freeradius.org><BR>Message-ID: <9285C1EC-7439-4652-8AEC-22FBAD42A485@freeradius.org><BR>Content-Type: text/plain; charset="iso-8859-1"<BR><BR><BR>On 13 Sep 2011, at 17:07, 2394263740 wrote:<BR><BR>> Hello,<BR>> I'm using free radius server 2.1.11 on Linux Enterprise Server 6.1.<BR>> OS: Linux Enterprise Server 6.1<BR>> Radius: free radius server 2.1.11<BR>> Database: Mysql<BR>> <BR>> When the system goes wrong, I would like temporary grant all access request.<BR>> <BR>> Which means during the service is down, any username/password will be grant access.<BR>> <BR>> Can you please advise the solution?<BR><BR>sql<BR>if(fail){<BR>update control {<BR>Auth-Type := 'Accept'<BR>}<BR>}<BR><BR>This will not work for protocols like PEAP. But should work for PAP, and CHAP.<BR><BR>-Arran<BR><BR>Arran Cudbard-Bell<BR>a.cudbardb@freeradius.org<BR><BR>RADIUS - Waging war on ignorance and apathy one Access-Challenge at a time.<BR><BR>-------------- next part --------------<BR>An HTML attachment was scrubbed...<BR>URL: <https://lists.freeradius.org/pipermail/freeradius-users/attachments/20110913/b2a99bf6/attachment.html><BR><BR>------------------------------<BR><BR>Message: 3<BR>Date: Tue, 13 Sep 2011 23:32:43 +0800<BR>From: " 2394263740 " <2394263740@qq.com><BR>Subject: Quick enable/disable user account.<BR>To: " freeradius-users " <freeradius-users@lists.freeradius.org><BR>Message-ID: <tencent_604FCE075B879FA320DD1DCF@qq.com><BR>Content-Type: text/plain; charset="iso-8859-1"<BR><BR>Hello,<BR>I'm using free radius server 2.1.11 on Linux Enterprise Server 6.1.<BR>OS: Linux Enterprise Server 6.1<BR>Radius: free radius server 2.1.11<BR>Database: Mysql<BR> <BR> <BR> <BR>Sometime, I need disable a user account in mysql database. And then enable it later on after some check complete.<BR> <BR> <BR> <BR>Can you please advise how to toggle such status?<BR> <BR> <BR> <BR>There're may be multiple solutions, please advise them all, so I can choose a one most fit the needs.<BR> <BR> <BR> <BR>Thanks!<BR> <BR> <BR> <BR>Tom<BR>-------------- next part --------------<BR>An HTML attachment was scrubbed...<BR>URL: <https://lists.freeradius.org/pipermail/freeradius-users/attachments/20110913/3f186dfc/attachment.html><BR><BR>------------------------------<BR><BR>Message: 4<BR>Date: Tue, 13 Sep 2011 17:39:48 +0200<BR>From: Alan DeKok <aland@deployingradius.com><BR>Subject: Re: Quick enable/disable user account.<BR>To: FreeRadius users mailing list<BR><freeradius-users@lists.freeradius.org><BR>Message-ID: <4E6F7944.5050204@deployingradius.com><BR>Content-Type: text/plain; charset=ISO-8859-1<BR><BR>2394263740 wrote:<BR>> Sometime, I need disable a user account in mysql database. And then<BR>> enable it later on after some check complete.<BR>> <BR>> Can you please advise how to toggle such status?<BR><BR> See the MySQL documentation for how to write to rows in MySQL.<BR><BR>> There're may be multiple solutions, please advise them all, so I can<BR>> choose a one most fit the needs.<BR><BR> Try harder.<BR><BR> Alan DeKok.<BR><BR><BR>------------------------------<BR><BR>Message: 5<BR>Date: Tue, 13 Sep 2011 17:42:54 +0200<BR>From: Arran Cudbard-Bell <a.cudbardb@freeradius.org><BR>Subject: Re: Quick enable/disable user account.<BR>To: FreeRadius users mailing list<BR><freeradius-users@lists.freeradius.org><BR>Message-ID: <AF7E673D-1735-467E-B0C8-06C49AC33E87@freeradius.org><BR>Content-Type: text/plain; charset="iso-8859-1"<BR><BR>No. You're treating this like paid support. Go and find out the answer for yourself, this is not a FeeRADIUS question.<BR><BR>-Arran<BR><BR>Arran Cudbard-Bell<BR>a.cudbardb@freeradius.org<BR><BR>RADIUS - Waging war on ignorance and apathy one Access-Challenge at a time.<BR><BR>-------------- next part --------------<BR>An HTML attachment was scrubbed...<BR>URL: <https://lists.freeradius.org/pipermail/freeradius-users/attachments/20110913/1d2cbd68/attachment.html><BR><BR>------------------------------<BR><BR>Message: 6<BR>Date: Tue, 13 Sep 2011 08:59:15 -0700<BR>From: "Tim Sylvester" <tim.sylvester@networkradius.com><BR>Subject: RE: Quick enable/disable user account.<BR>To: "'FreeRadius users mailing list'"<BR><freeradius-users@lists.freeradius.org><BR>Message-ID: <041301cc722e$1745e360$45d1aa20$@networkradius.com><BR>Content-Type: text/plain; charset="us-ascii"<BR><BR>Set Auth-Type := Reject in radcheck.<BR><BR> <BR><BR>http://deployingradius.com/documents/configuration/auth_type.html<BR><BR> <BR><BR>Tim<BR><BR> <BR><BR> <BR><BR>From:<BR>freeradius-users-bounces+tim.sylvester=networkradius.com@lists.freeradius.or<BR>g<BR>[mailto:freeradius-users-bounces+tim.sylvester=networkradius.com@lists.freer<BR>adius.org] On Behalf Of 2394263740<BR>Sent: Tuesday, September 13, 2011 8:33 AM<BR>To: freeradius-users<BR>Subject: Quick enable/disable user account.<BR><BR> <BR><BR>Hello,<BR>I'm using free radius server 2.1.11 on Linux Enterprise Server 6.1.<BR>OS: Linux Enterprise Server 6.1<BR>Radius: free radius server 2.1.11<BR>Database: Mysql<BR><BR> <BR><BR>Sometime, I need disable a user account in mysql database. And then enable<BR>it later on after some check complete.<BR><BR> <BR><BR>Can you please advise how to toggle such status?<BR><BR> <BR><BR>There're may be multiple solutions, please advise them all, so I can choose<BR>a one most fit the needs.<BR><BR> <BR><BR>Thanks!<BR><BR> <BR><BR>Tom<BR><BR>-------------- next part --------------<BR>An HTML attachment was scrubbed...<BR>URL: <https://lists.freeradius.org/pipermail/freeradius-users/attachments/20110913/044b7e97/attachment.html><BR><BR>------------------------------<BR><BR>-<BR>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<BR><BR><BR>End of Freeradius-Users Digest, Vol 77, Issue 50<BR>************************************************<BR>-------------- next part --------------<BR>An HTML attachment was scrubbed...<BR>URL: <https://lists.freeradius.org/pipermail/freeradius-users/attachments/20110914/84aacfce/attachment.html><BR><BR>------------------------------<BR><BR>-<BR>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<BR><BR><BR>End of Freeradius-Users Digest, Vol 77, Issue 53<BR>************************************************<BR></DIV></includetail></DIV>