<DIV><includetail>Arran,</includetail></DIV>
<DIV></:includetail> </DIV>
<DIV>Thanks a lot again.</:includetail></DIV>
<DIV></:includetail> </DIV>
<DIV>It works.</:includetail></DIV>
<DIV></:includetail> </DIV>
<DIV>As what you advised,</:includetail></DIV>
<DIV></:includetail> </DIV>
<DIV>1. edit </:includetail>/usr/local/etc/raddb/sites-available/default, uncomment below sql line.</:includetail></DIV>
<DIV>post-auth {</:includetail></DIV>
<DIV>......<BR>#sql<BR>......</:includetail></DIV>
<DIV>}</:includetail></DIV>
<DIV>2. edit </:includetail>/usr/local/etc/raddb/sql/mysql/dialup.conf</:includetail></DIV>
<DIV>updae postauth_query defination.</:includetail></DIV>
<DIV></:includetail> </DIV>
<DIV>Very busy these days. So reply late.</:includetail></DIV>
<DIV></:includetail> </DIV>
<DIV>Tom</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> Fri, Sep 2, 2011 06:11 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 5</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. How to update a MySql table after successfully WIFI<BR> authentication? ( 2394263740 )<BR> 2. Re: How to update a MySql table after successfully WIFI<BR> authentication? (Arran Cudbard-Bell)<BR> 3. Re: Example configuration that proxy PEAP MSCHAPv2 to an IAS<BR> server (Jacob Dawson)<BR> 4. Using encrypted passwords in users file (sundoo)<BR> 5. cisco 3825 authentication error (Dom)<BR> 6. Re: Using encrypted passwords in users file (Paul Bartell)<BR> 7. Re: Pre release of 2.1.12 (Alan Buxey)<BR><BR><BR>----------------------------------------------------------------------<BR><BR>Message: 1<BR>Date: Thu, 1 Sep 2011 22:29:11 +0800<BR>From: " 2394263740 " <2394263740@qq.com><BR>Subject: How to update a MySql table after successfully WIFI<BR>authentication?<BR>To: " freeradius-users " <freeradius-users@lists.freeradius.org><BR>Message-ID: <tencent_3B36E2AF6F7D0370683C1EB1@qq.com><BR>Content-Type: text/plain; charset="iso-8859-1"<BR><BR>Hello,<BR> <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> I got a WIFI network, using one radius server.<BR> <BR> The whole thing works fine.<BR> <BR> I got a requirement, which is, after each successful WIFI connection, one record need be added into connectionlog table.<BR> <BR> CREATE TABLE connectionlog (<BR> radacctid bigint(21) NOT NULL auto_increment,<BR> acctsessionid varchar(64) NOT NULL default '',<BR> acctuniqueid varchar(32) NOT NULL default '',<BR> username varchar(64) NOT NULL default '',<BR> groupname varchar(64) NOT NULL default '',<BR> realm varchar(64) default '',<BR> nasipaddress varchar(15) NOT NULL default '',<BR> nasportid varchar(15) default NULL,<BR> nasporttype varchar(32) default NULL,<BR> acctstarttime datetime NULL default NULL,<BR> acctstoptime datetime NULL default NULL,<BR> acctsessiontime int(12) default NULL,<BR> acctauthentic varchar(32) default NULL,<BR> connectinfo_start varchar(50) default NULL,<BR> connectinfo_stop varchar(50) default NULL,<BR> acctinputoctets bigint(20) default NULL,<BR> acctoutputoctets bigint(20) default NULL,<BR> calledstationid varchar(50) NOT NULL default '',<BR> callingstationid varchar(50) NOT NULL default '',<BR> acctterminatecause varchar(32) NOT NULL default '',<BR> servicetype varchar(32) default NULL,<BR> framedprotocol varchar(32) default NULL,<BR> framedipaddress varchar(15) NOT NULL default '',<BR> acctstartdelay int(12) default NULL,<BR> acctstopdelay int(12) default NULL,<BR> xascendsessionsvrkey varchar(10) default NULL,<BR> PRIMARY KEY (radacctid),<BR> KEY username (username),<BR> KEY framedipaddress (framedipaddress),<BR> KEY acctsessionid (acctsessionid),<BR> KEY acctsessiontime (acctsessiontime),<BR> KEY acctuniqueid (acctuniqueid),<BR> KEY acctstarttime (acctstarttime),<BR> KEY acctstoptime (acctstoptime),<BR> KEY nasipaddress (nasipaddress)<BR>) ;<BR><BR> Can you please kindly advise how to do this?<BR> <BR> Which file should be edited?<BR> <BR> Where is the context to put in the script?<BR> <BR> What is the script?<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/20110901/440326d6/attachment.html><BR><BR>------------------------------<BR><BR>Message: 2<BR>Date: Thu, 1 Sep 2011 16:36:40 +0200<BR>From: Arran Cudbard-Bell <a.cudbardb@freeradius.org><BR>Subject: Re: How to update a MySql table after successfully WIFI<BR>authentication?<BR>To: FreeRadius users mailing list<BR><freeradius-users@lists.freeradius.org><BR>Message-ID: <C781BD59-4F30-48C4-B6CC-FF4790379DE1@freeradius.org><BR>Content-Type: text/plain; charset=iso-8859-1<BR><BR>Look in raddb/sql/mysql/dialup.conf<BR><BR>The postauth query is the one you need to edit.<BR><BR>Then uncomment the 'sql' module in <BR><BR>raddb/sites-available/default<BR><BR>post-auth {<BR><BR>}<BR><BR>-Arran<BR><BR>Arran Cudbard-Bell<BR>a.cudbardb@freeradius.org<BR><BR>RADIUS - Half the complexity of Diameter<BR><BR><BR><BR>------------------------------<BR><BR>Message: 3<BR>Date: Thu, 1 Sep 2011 10:40:18 -0400<BR>From: Jacob Dawson <dawson@vt.edu><BR>Subject: Re: Example configuration that proxy PEAP MSCHAPv2 to an IAS<BR>server<BR>To: FreeRadius users mailing list<BR><freeradius-users@lists.freeradius.org><BR>Message-ID: <14B9C69C-CB59-4CA7-9F5B-39CD6C81404C@vt.edu><BR>Content-Type: text/plain; charset=us-ascii<BR><BR>It's largely successful, but as I mentioned in my note to this group from the 29th, I've run into problems with Windows clients having a disagreement with FreeRADIUS about the final stages of the PEAP-MSCHAPv2 conversation, after IAS has authenticated them successfully.<BR><BR>- Jacob<BR><BR>On 31 Aug 2011, at 16:32, Alan DeKok wrote:<BR><BR>> <BR>> It really should work... it works for my tests.<BR>> <BR>> Alan DeKok.<BR>> -<BR>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<BR><BR><BR><BR><BR>------------------------------<BR><BR>Message: 4<BR>Date: Thu, 1 Sep 2011 08:57:14 -0700 (PDT)<BR>From: sundoo <sandu_nastas@yahoo.com><BR>Subject: Using encrypted passwords in users file<BR>To: freeradius-users@lists.freeradius.org<BR>Message-ID: <1314892634927-4758890.post@n5.nabble.com><BR>Content-Type: text/plain; charset=us-ascii<BR><BR>Hello, I'm new to FreeRadius and to linux. Maybe this question will sound<BR>stupid, but I really need you help.<BR>I have a server running freeradius. <BR>These are some outputs of the configuration: <BR><BR>*etc/freeradius/radiusd.conf*<BR># passwd = /etc/passwd<BR> shadow = /etc/shadow<BR># group = /etc/group<BR><BR><BR>*/etc/freeradius/users*<BR>test1 Auth-Type := Crypt-Local, User-Password :=<BR>"$1$NzW2iwkn$ygDcJgb4WhAEqQYfySFkj/"<BR> Service-Type = Administrative-User,<BR> Cajun-Service-Type := 3,<BR><BR>*/etc/shadow*<BR>test1:$1$cnEh49V6$Q.68mw.3P5rgmsfhbo/iC1:15217:0:99999:7:::<BR><BR><BR>I would like to change the password for the user test1. But in the users<BR>file I see only the encrypted password. Where is the original password<BR>stored ? <BR><BR>How do I change it ? <BR><BR>Thanks a lot for your help.<BR><BR>--<BR>View this message in context: http://freeradius.1045715.n5.nabble.com/Using-encrypted-passwords-in-users-file-tp4758890p4758890.html<BR>Sent from the FreeRadius - User mailing list archive at Nabble.com.<BR><BR><BR>------------------------------<BR><BR>Message: 5<BR>Date: Thu, 01 Sep 2011 15:45:02 -0400<BR>From: Dom <dversace@tekcorner.ca><BR>Subject: cisco 3825 authentication error<BR>To: freeradius-users@lists.freeradius.org<BR>Message-ID: <4E5FE0BE.8010800@tekcorner.ca><BR>Content-Type: text/plain; charset=ISO-8859-1; format=flowed<BR><BR>I am trying to terminate vpdn sessions through our cisco 3825 using <BR>freeradius. I am new to this whole process and I was hoping to get some <BR>assistance with the missing configuration.<BR><BR>Below is the error message I am receiving when trying to authenticate <BR>via the router.<BR><BR>rad_recv: Access-Request packet from host 64.34.66.5 port 1645, id=19, <BR>length=135<BR> Framed-Protocol = PPP<BR> User-Name = "aewais@domain.com"<BR> User-Password = "password"<BR> Calling-Station-Id = "bas203300000455"<BR> Connect-Info = "1000000000"<BR> NAS-Port-Type = Virtual<BR> NAS-Port = 532<BR> NAS-Port-Id = "Uniq-Sess-ID532"<BR> Service-Type = Framed-User<BR> NAS-IP-Address = 64.34.66.5<BR># Executing section authorize from file <BR>/etc/freeradius/sites-enabled/default<BR>+- entering group authorize {...}<BR>++[preprocess] returns ok<BR>++[chap] returns noop<BR>++[mschap] returns noop<BR>++[digest] returns noop<BR>[suffix] Looking up realm "domain.com" for User-Name = "aewais@domain.com"<BR>[suffix] No such realm "domain.com"<BR>++[suffix] returns noop<BR>[eap] No EAP-Message, not doing EAP<BR>++[eap] returns noop<BR>[files] users: Matched entry DEFAULT at line 172<BR>++[files] returns ok<BR>++[expiration] returns noop<BR>++[logintime] returns noop<BR>[pap] WARNING! No "known good" password found for the user. <BR>Authentication may fail because of this.<BR>++[pap] returns noop<BR>ERROR: No authenticate method (Auth-Type) found for the request: <BR>Rejecting the user<BR>Failed to authenticate the user.<BR>Using Post-Auth-Type Reject<BR># Executing group from file /etc/freeradius/sites-enabled/default<BR>+- entering group REJECT {...}<BR>[attr_filter.access_reject] expand: %{User-Name} -> aewais@domain.com<BR> attr_filter: Matched entry DEFAULT at line 11<BR>++[attr_filter.access_reject] returns updated<BR>Delaying reject of request 0 for 1 seconds<BR>Going to the next request<BR>Waking up in 0.9 seconds.<BR>Sending delayed reject for request 0<BR>Sending Access-Reject of id 19 to 64.34.66.5 port 1645<BR>Waking up in 4.9 seconds.<BR>Cleaning up request 0 ID 19 with timestamp +381<BR>Ready to process requests.<BR><BR><BR><BR><BR><BR>------------------------------<BR><BR>Message: 6<BR>Date: Thu, 1 Sep 2011 14:54:29 -0700<BR>From: Paul Bartell <paul.bartell@gmail.com><BR>Subject: Re: Using encrypted passwords in users file<BR>To: FreeRadius users mailing list<BR><freeradius-users@lists.freeradius.org><BR>Message-ID:<BR><CAHXqhmh49eNKABTpwmv0Rb1+UX7WPMaN4UB0RQKiiGVSuGoDzg@mail.gmail.com><BR>Content-Type: text/plain; charset=ISO-8859-1<BR><BR>that is the hashed password. You can change it by generating a hash of<BR>your new password... you would probably use crypt(3) to do that... The<BR>original password was never stored in cleartext form. You could store<BR>a cleartext password if you really wanted to, but that is less than<BR>secure.<BR><BR>On Thu, Sep 1, 2011 at 8:57 AM, sundoo <sandu_nastas@yahoo.com> wrote:<BR>><BR>> Hello, I'm new to FreeRadius and to linux. Maybe this question will sound<BR>> stupid, but I really need you help.<BR>> I have a server running freeradius.<BR>> These are some outputs of the configuration:<BR>><BR>> *etc/freeradius/radiusd.conf*<BR>> # passwd = /etc/passwd<BR>> ?shadow = /etc/shadow<BR>> # group = /etc/group<BR>><BR>><BR>> */etc/freeradius/users*<BR>> test1 Auth-Type := Crypt-Local, User-Password :=<BR>> "$1$NzW2iwkn$ygDcJgb4WhAEqQYfySFkj/"<BR>> ? ? ? ?Service-Type = Administrative-User,<BR>> ? ? ? ?Cajun-Service-Type := 3,<BR>><BR>> */etc/shadow*<BR>> test1:$1$cnEh49V6$Q.68mw.3P5rgmsfhbo/iC1:15217:0:99999:7:::<BR>><BR>><BR>> I would like to change the password for the user test1. But in the users<BR>> file I see only the encrypted password. Where is the original password<BR>> stored ?<BR>><BR>> How do I change it ?<BR>><BR>> Thanks a lot for your help.<BR>><BR>> --<BR>> View this message in context: http://freeradius.1045715.n5.nabble.com/Using-encrypted-passwords-in-users-file-tp4758890p4758890.html<BR>> Sent from the FreeRadius - User mailing list archive at Nabble.com.<BR>> -<BR>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<BR><BR><BR><BR>--<BR>Random quote of the week/month/whenever i get to updating it: "Quis custodiet<BR>ipsos custodes?": "who shall watch the watchers themselves?" - Juvenal<BR><BR><BR><BR>------------------------------<BR><BR>Message: 7<BR>Date: Thu, 1 Sep 2011 23:11:23 +0100<BR>From: Alan Buxey <A.L.M.Buxey@lboro.ac.uk><BR>Subject: Re: Pre release of 2.1.12<BR>To: FreeRadius users mailing list<BR><freeradius-users@lists.freeradius.org><BR>Message-ID: <20110901221123.GF16795@lboro.ac.uk><BR>Content-Type: text/plain; charset=us-ascii<BR><BR>Hi,<BR><BR>> it's now running on our most busy server. Both -X and<BR>> background-multithreaded do their usual job. I do not see any problems<BR>> so far.<BR><BR>its on one of our production servers and on a couple of other<BR>systems. <BR><BR>alan<BR><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 5<BR>***********************************************<BR></DIV></:includetail></DIV>