September 2005 - Freeradius-Users - lists.freeradius.org

radgroupreply table
by N White 14 Sep '05

14 Sep '05

Can anyone explain to me the purpose and usage of the 'prio' column in the radgroupreply table? Much Googling has returned nothing, accept other questions. -- --------------------------- | Nick White | | Network Administrator | | Tele-NET Internet | | http://www.tele-net.net | | nwtech(a)tele-net.net | ---------------------------

4 6

El tercero... a ver si entiende lo que quiero decir
by Paolo Rotela 14 Sep '05

14 Sep '05

Ing. Paolo Rotela Jefe Técnico Blue Telecom ----- Original Message ----- From: "Paolo Rotela" <paolo.rotela(a)bluetelecom.com> To: "Freeradius Users" <freeradius-users(a)lists.freeradius.org> Sent: Wednesday, September 14, 2005 10:20 AM Subject: Re: FreeRadius Proxying and Message-Authenticator >I wonder if it is correct to discard a packet based on the presence of an >attribute witch use is not defined by any standard. I've read the >"aboba-radext-fixes" and I see that FR is calculating Message-Authenticator >in Accounting packets this way. But there is no RFC about it... RFC2869 >describes how to handle incorrect or missing Message-Authenticator in >Access-* packets, it doesn't say that you must discard an Accounting packet >with invalid Message Authenticator, because as you say there is no standard >about how to calculate it. > > I suggest at least a configuration option that can help to avoid this > compatibility issue, giving the user the option of accepting or not > "incorrect" MAs in Accounting. > > I'll try to find out the algorithm used by Cisco... If I happen to be > successful, I'll post it. > > Thanks > > > Date: Tue, 13 Sep 2005 17:57:05 -0400 > From: "Alan DeKok" <aland(a)ox.org> > Subject: Re: FreeRadius Proxying and Message-Authenticator > To: FreeRadius users mailing list > <freeradius-users(a)lists.freeradius.org> > Message-ID: <20050913215705.0B8CA170D2(a)mail.nitros9.org> > > "Paolo Rotela" <paolo.rotela(a)bluetelecom.com> wrote: >> Hi. I've downloaded FR 1.0.5 whch is supposed to have a bugfix for >> Message-Authenticator handling in Accounting-* messages. > > The issue is that the suggested method of calculatin > Message-Authenticator MAY NOT be the same as what Cisco's using. > Because there's no standard, Cisco may be doing almost *anything*. > >> I'am missing something? > > If you can find out the algorithm used by Cisco, we may be able to > update FreeRADIUS to handle it. Until then, there isn't much we can > do. > > > Ing. Paolo Rotela > Jefe Técnico > Blue Telecom

1 0

Lengths
by Iandc Davies 14 Sep '05

14 Sep '05

All, In the standard header there is a code, Identifier, length and authenticator fields. For the length, is that the sum of all the vp->lengths + 20 for the standard header. My reason for this question is that I'm trying to rationalise an example I've got. I.e. how do you get 164 See below: Code =1 Identifier =1 Length =164 Authenticator = 56 7b e6 9a 8e 43 cf b6 fb a6 c0 f0 9a 92 6f 0e These are standard header, therefore 164 - 20 = 144 Attributes: NAS-IP-Address =d5 89 45 26 4 NAS-PORT-TYPE =5 (virtual) 1 User-Name ="12345678" 8 Disgest-Response ="2ae133421cda65d67dc50d13ba0eb9bc" 32 Digest-Attributes= Realm(1) = "deltathree" 10 Nonce(2) = "3bada1a0" 8 Method(3) = "INVITE" 6 URI(4) = "sip:96226491335@213.137.69.38" 29 Algorithm(5) = "md5" 3 User-Name(10) = "12345678" 8 Equals = 109 (35 not accounted for ?) Ian Davies {02476 564662} Internal (x740 4662) IMS-SIPAC Software Development Engineer

2 1

Re: PW_NAS_IP_ADDRESS ?
by Iandc Davies 14 Sep '05

14 Sep '05

> The IP addresses are usually stored in vp->lvalue. I note the easiest >way to assign values is to use the function pairparsevalue() in >src/lib/valuepair.c -- >Nicolas Baradakis Just looked at pairparsevalue(), and it seems that the string "213.137.69.38" is kept in vp->strvalue but it is also converted into a uint32_t d5 89 45 26 and stored in vp->lvalue. It that right ? Ian Davies {02476 564662} Internal (x740 4662) IMS-SIPAC Software Development Engineer

2 1

Radius Log Reporting Tool
by John Oxley 14 Sep '05

14 Sep '05

I apologise if this has been asked before. I have just come across radreport (from the FreeBSD ports) which is okay. What other tools are there for freeradius log monitoring and reporting? -John

3 2

/etc/shadow
by den 14 Sep '05

14 Sep '05

HI All. I`ve read this article: http://www.tldp.org/HOWTO/8021X-HOWTO, and several related. But I want freeRADIUS to look for passwords in /etc/shadow. Can somebody help me? v 1.0.2 Debian Sarge.

2 3

(no subject)
by Callis 14 Sep '05

14 Sep '05

Hi all, Excuse me if i sound boring but am trying to use freeradius(1.0.1-1) to collect terminating VOIP traffic from an AS5300. I keep getting this error in my radius.log ===== Wed Sep 14 13:53:20 2005 : Error: rlm_sql (pgsql-voip): Couldn't update SQL accounting STOP record - ERROR: duplicate key violates unique constraint "stoptelephonycombo" Wed Sep 14 13:53:20 2005 : Error: rlm_sql (pgsql-voip): failed after re-connect Wed Sep 14 13:53:20 2005 : Error: rlm_sql (pgsql-voip): Couldn't update SQL accounting STOP record - ERROR: duplicate key violates unique constraint "stoptelephonycombo" Wed Sep 14 13:53:21 2005 : Error: rlm_sql (pgsql-voip): failed after re-connect Wed Sep 14 13:53:21 2005 : Error: rlm_sql (pgsql-voip): Couldn't update SQL accounting STOP record - ERROR: duplicate key violates unique constraint "stoptelephonycombo" Wed Sep 14 13:53:21 2005 : Error: rlm_sql (pgsql-voip): failed after re-connect Wed Sep 14 13:53:21 2005 : Error: rlm_sql (pgsql-voip): Couldn't update SQL accounting STOP record - ERROR: duplicate key violates unique constraint "stoptelephonycombo" Wed Sep 14 13:53:21 2005 : Error: rlm_sql (pgsql-voip): failed after re-connect =========== It sometimes kills my freeradius daemon. Any help in the form of documentation or anything will be useful. Thank you.

1 0

PW_NAS_IP_ADDRESS ?
by Iandc Davies 14 Sep '05

14 Sep '05

All, Using an example ip address of 213.137.69.38, this converts to d5 89 45 26 (hex). Is it OK to split the above hex into 8 bits so that it can fit into the vp->strvalue format or is there another way ? i.e. strvalue[0] = d5 strvalue[1] = 89 strvalue[2] = 45 strvalue[3] = 26 Ian Davies {02476 564662} Internal (x740 4662) IMS-SIPAC Software Development Engineer

2 1

RE: custom variable in config files
by Tariq Rashid 14 Sep '05

14 Sep '05

thanks - that works - i can confirm that for the list tariq -----Original Message----- From: freeradius-users-bounces(a)lists.freeradius.org [mailto:freeradius-users-bounces@lists.freeradius.org]On Behalf Of Nicolas Baradakis Sent: 13 September 2005 18:08 To: FreeRadius users mailing list Subject: Re: custom variable in config files Tariq Rashid wrote: > but this doesn't ... > > # local test user for monitoring and diagnostics > test1@proxyradius.%{config:easynet_site} User-Password == "test1.proxyradius.%{config:easynet_site}" > Reply-Message = "hello from the proxyradius layer %{config:easynet_site}" > > any ideas? i'm using version 1.0.2 on debian 3.1 It doesn't work because the name of the entry isn't xlat'ed in src/main/files.c. Perhaps this syntax would work: DEFAULT User-Name = "test1@proxyradius.%{config:easynet_site}", User-Password == "test1.proxyradius.%{config:easynet_site}" Reply-Message = "hello from the proxyradius layer %{config:easynet_site}" -- Nicolas Baradakis - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

1 0

EAP/TTLS with Windows SecureW2 -> symbol lookup error: rlm_eap_ttls-1.0.4.so:
by Achim Friedland 14 Sep '05

14 Sep '05

Hello, I have a strange error with freeradius eap/ttls... I'm using CISCO AP1200 with a central WDS box. The main authentication is done by freeradius. Authentication for special users is by by another freeradius using the realm "zki"... Using Secure W2 for authentication fails when the outer identity is set to default (== anonymous). SecureW2 seem to send "anonymous@zki" instead of the plain "anonymous". freeradius 1.0.4 will crash when receiving "anonymous@zki" as outer identity, complaining about: "radiusd: symbol lookup error: /usr/local/lib/rlm_eap_ttls-1.0.4.so:" Setting the Outer Identity to "anonymous" by hand and everything seems to work fine... Using Mac OS X 10.4.x is also working fine... Is this a freeradius bug or is this an configuration mistake? thx... achim WindowsXP SecureW2 with Outer Identity default: "Use anonymous outer identity" --------------------------------------- rad_recv: Access-Request packet from host 141.24.X.153:1814, id=2, length=196 User-Name = "anonymous@zki" Framed-MTU = 1400 Called-Station-Id = "0012.d91d.8506" Calling-Station-Id = "0040.96a6.f325" Cisco-AVPair = "ssid=802.1X_A" Service-Type = Login-User Message-Authenticator = 0x5335216cd649ea7293d33d345ccaf001 EAP-Message = 0x0203001201616e6f6e796d6f7573407a6b69 NAS-Port-Type = Wireless-802.11 Cisco-NAS-Port = "11152" NAS-Port = 11152 State = 0xf32cdefb67a6c958841160d79940483d NAS-IP-Address = 141.24.Y.197 NAS-Identifier = "wds" Proxy-State = 0x3130 Processing the authorize section of radiusd.conf modcall: entering group authorize for request 0 modcall[authorize]: module "preprocess" returns ok for request 0 modcall[authorize]: module "chap" returns noop for request 0 rlm_realm: Looking up realm "zki" for User-Name = "anonymous@zki" rlm_realm: Found realm "zki" rlm_realm: Adding Stripped-User-Name = "anonymous" rlm_realm: Proxying request from user anonymous to realm zki rlm_realm: Adding Realm = "zki" rlm_realm: Authentication realm is LOCAL. modcall[authorize]: module "suffix" returns noop for request 0 rlm_eap: EAP packet type response id 3 length 18 rlm_eap: No EAP Start, assuming it's an on-going EAP conversation modcall[authorize]: module "eap" returns updated for request 0 modcall[authorize]: module "files" returns notfound for request 0 radius_xlat: 'anonymous' rlm_sql (sql): sql_set_user escaped user --> 'anonymous' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'anonymous' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 4 rlm_sql (sql): User anonymous not found in radcheck radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'anonymous' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'anonymous' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): User anonymous not found in radgroupcheck rlm_sql (sql): User not found rlm_sql (sql): Released sql socket id: 4 modcall[authorize]: module "sql" returns notfound for request 0 modcall: group authorize returns updated for request 0 rad_check_password: Found Auth-Type EAP auth: type "EAP" Processing the authenticate section of radiusd.conf modcall: entering group authenticate for request 0 rlm_eap: EAP Identity rlm_eap: processing type md5 rlm_eap_md5: Issuing Challenge modcall[authenticate]: module "eap" returns handled for request 0 modcall: group authenticate returns handled for request 0 Sending Access-Challenge of id 2 to 141.24.X.153:1814 EAP-Message = 0x01040016041077a0fb8bd58d97d0b17ac1df9de98f47 Message-Authenticator = 0x00000000000000000000000000000000 State = 0x36f0b37fa9b38cb7bbb80bdf4fe46ed3 Proxy-State = 0x3130 Finished request 0 Going to the next request --- Walking the entire request list --- Waking up in 6 seconds... rad_recv: Access-Request packet from host 141.24.X.153:1814, id=3, length=184 User-Name = "anonymous@zki" Framed-MTU = 1400 Called-Station-Id = "0012.d91d.8506" Calling-Station-Id = "0040.96a6.f325" Cisco-AVPair = "ssid=802.1X_A" Service-Type = Login-User Message-Authenticator = 0xcadb1594ff0bdba3568742d74f111ea9 EAP-Message = 0x020400060315 NAS-Port-Type = Wireless-802.11 Cisco-NAS-Port = "11152" NAS-Port = 11152 State = 0x36f0b37fa9b38cb7bbb80bdf4fe46ed3 NAS-IP-Address = 141.24.Y.197 NAS-Identifier = "wds" Proxy-State = 0x3131 Processing the authorize section of radiusd.conf modcall: entering group authorize for request 1 modcall[authorize]: module "preprocess" returns ok for request 1 modcall[authorize]: module "chap" returns noop for request 1 rlm_realm: Looking up realm "zki" for User-Name = "anonymous@zki" rlm_realm: Found realm "zki" rlm_realm: Adding Stripped-User-Name = "anonymous" rlm_realm: Proxying request from user anonymous to realm zki rlm_realm: Adding Realm = "zki" rlm_realm: Authentication realm is LOCAL. modcall[authorize]: module "suffix" returns noop for request 1 rlm_eap: EAP packet type response id 4 length 6 rlm_eap: No EAP Start, assuming it's an on-going EAP conversation modcall[authorize]: module "eap" returns updated for request 1 modcall[authorize]: module "files" returns notfound for request 1 radius_xlat: 'anonymous' rlm_sql (sql): sql_set_user escaped user --> 'anonymous' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'anonymous' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 3 rlm_sql (sql): User anonymous not found in radcheck radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'anonymous' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'anonymous' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): User anonymous not found in radgroupcheck rlm_sql (sql): User not found rlm_sql (sql): Released sql socket id: 3 modcall[authorize]: module "sql" returns notfound for request 1 modcall: group authorize returns updated for request 1 rad_check_password: Found Auth-Type EAP auth: type "EAP" Processing the authenticate section of radiusd.conf modcall: entering group authenticate for request 1 rlm_eap: Request found, released from the list rlm_eap: EAP NAK rlm_eap: EAP-NAK asked for EAP-Type/ttls rlm_eap: processing type tls rlm_eap_tls: Initiate rlm_eap_tls: Start returned 1 modcall[authenticate]: module "eap" returns handled for request 1 modcall: group authenticate returns handled for request 1 Sending Access-Challenge of id 3 to 141.24.X.153:1814 EAP-Message = 0x010500061520 Message-Authenticator = 0x00000000000000000000000000000000 State = 0x2b311532eebabb9eb8503c79a2d4fa9a Proxy-State = 0x3131 Finished request 1 Going to the next request Waking up in 6 seconds... rad_recv: Access-Request packet from host 141.24.X.153:1814, id=4, length=238 User-Name = "anonymous@zki" Framed-MTU = 1400 Called-Station-Id = "0012.d91d.8506" Calling-Station-Id = "0040.96a6.f325" Cisco-AVPair = "ssid=802.1X_A" Service-Type = Login-User Message-Authenticator = 0xdfbeb7f6c68f0044d69f70e8c7789c49 EAP-Message = 0x0205003c158000000032160301002d01000029030168032500510bcf65fcee8021c8e22ed0192f5f8033a7007c36fdf4e5904e86 NAS-Port-Type = Wireless-802.11 Cisco-NAS-Port = "11152" NAS-Port = 11152 State = 0x2b311532eebabb9eb8503c79a2d4fa9a NAS-IP-Address = 141.24.Y.197 NAS-Identifier = "wds" Proxy-State = 0x3132 Processing the authorize section of radiusd.conf modcall: entering group authorize for request 2 modcall[authorize]: module "preprocess" returns ok for request 2 modcall[authorize]: module "chap" returns noop for request 2 rlm_realm: Looking up realm "zki" for User-Name = "anonymous@zki" rlm_realm: Found realm "zki" rlm_realm: Adding Stripped-User-Name = "anonymous" rlm_realm: Proxying request from user anonymous to realm zki rlm_realm: Adding Realm = "zki" rlm_realm: Authentication realm is LOCAL. modcall[authorize]: module "suffix" returns noop for request 2 rlm_eap: EAP packet type response id 5 length 60 rlm_eap: No EAP Start, assuming it's an on-going EAP conversation modcall[authorize]: module "eap" returns updated for request 2 modcall[authorize]: module "files" returns notfound for request 2 radius_xlat: 'anonymous' rlm_sql (sql): sql_set_user escaped user --> 'anonymous' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'anonymous' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 2 rlm_sql (sql): User anonymous not found in radcheck radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'anonymous' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'anonymous' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): User anonymous not found in radgroupcheck rlm_sql (sql): User not found radiusd-windosen-bug Ctrl-K H for help rlm_sql (sql): Released sql socket id: 2 modcall[authorize]: module "sql" returns notfound for request 2 modcall: group authorize returns updated for request 2 rad_check_password: Found Auth-Type EAP auth: type "EAP" Processing the authenticate section of radiusd.conf modcall: entering group authenticate for request 2 rlm_eap: Request found, released from the list rlm_eap: EAP/ttls rlm_eap: processing type ttls rlm_eap_ttls: Authenticate radiusd: symbol lookup error: /usr/local/lib/rlm_eap_ttls-1.0.4.so: undefined symbol: eaptls_process WindowsXP SecureW2 with Outer Identity: "Specify outer Identity: 'anonymous'" --------------------------------------- rad_recv: Access-Request packet from host 141.24.X.153:1814, id=14, length=65 User-Name = "rznotebook@zki" User-Password = "notenbuch" NAS-IP-Address = 127.0.0.1 Proxy-State = 0x313534 Processing the authorize section of radiusd.conf modcall: entering group authorize for request 0 modcall[authorize]: module "preprocess" returns ok for request 0 modcall[authorize]: module "chap" returns noop for request 0 rlm_realm: Looking up realm "zki" for User-Name = "rznotebook@zki" rlm_realm: Found realm "zki" rlm_realm: Adding Stripped-User-Name = "rznotebook" rlm_realm: Proxying request from user rznotebook to realm zki rlm_realm: Adding Realm = "zki" rlm_realm: Authentication realm is LOCAL. modcall[authorize]: module "suffix" returns noop for request 0 rlm_eap: No EAP-Message, not doing EAP modcall[authorize]: module "eap" returns noop for request 0 modcall[authorize]: module "files" returns notfound for request 0 radius_xlat: 'rznotebook' rlm_sql (sql): sql_set_user escaped user --> 'rznotebook' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'rznotebook' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 4 radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'rznotebook' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'rznotebook' ORDER BY id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'rznotebook' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): Released sql socket id: 4 modcall[authorize]: module "sql" returns ok for request 0 modcall: group authorize returns ok for request 0 auth: type Local auth: user supplied User-Password matches local User-Password radiusd-windosen-bug Ctrl-K H for help Login OK: [rznotebook@zki] (from client telly-rz port 0) Processing the post-auth section of radiusd.conf modcall: entering group post-auth for request 0 rlm_sql (sql): Processing sql_postauth radius_xlat: 'rznotebook' rlm_sql (sql): sql_set_user escaped user --> 'rznotebook' radius_xlat: 'INSERT into radpostauth (id, user, pass, reply, date) values ('', 'rznotebook@zki', 'notenbuch', 'Access-Accept', NOW())' rlm_sql (sql) in sql_postauth: query is INSERT into radpostauth (id, user, pass, reply, date) values ('', 'rznotebook@zki', 'notenbuch', 'Access-Accept', NOW()) rlm_sql (sql): Reserving sql socket id: 3 rlm_sql (sql): Released sql socket id: 3 modcall[post-auth]: module "sql" returns ok for request 0 modcall: group post-auth returns ok for request 0 Sending Access-Accept of id 14 to 141.24.X.153:1814 Proxy-State = 0x313534 Finished request 0 Going to the next request --- Walking the entire request list --- Waking up in 6 seconds... --- Walking the entire request list --- Cleaning up request 0 ID 14 with timestamp 4326761a Nothing to do. Sleeping until we see a request. Mac OS X 10.4 ------------- rad_recv: Access-Request packet from host 141.24.X.153:1814, id=15, length=67 User-Name = "fempowerbook@zki" User-Password = "fpb" NAS-IP-Address = 127.0.0.1 Proxy-State = 0x313931 Processing the authorize section of radiusd.conf modcall: entering group authorize for request 0 modcall[authorize]: module "preprocess" returns ok for request 0 modcall[authorize]: module "chap" returns noop for request 0 rlm_realm: Looking up realm "zki" for User-Name = "fempowerbook@zki" rlm_realm: Found realm "zki" rlm_realm: Adding Stripped-User-Name = "fempowerbook" rlm_realm: Proxying request from user fempowerbook to realm zki rlm_realm: Adding Realm = "zki" rlm_realm: Authentication realm is LOCAL. modcall[authorize]: module "suffix" returns noop for request 0 rlm_eap: No EAP-Message, not doing EAP modcall[authorize]: module "eap" returns noop for request 0 modcall[authorize]: module "files" returns notfound for request 0 radius_xlat: 'fempowerbook' rlm_sql (sql): sql_set_user escaped user --> 'fempowerbook' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'fempowerbook' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 4 radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'fempowerbook' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'fempowerbook' ORDER BY id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'fempowerbook' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): Released sql socket id: 4 modcall[authorize]: module "sql" returns ok for request 0 modcall: group authorize returns ok for request 0 auth: type Local auth: user supplied User-Password matches local User-Password radiusd-windosen-bug Ctrl-K H for help Login OK: [fempowerbook@zki] (from client telly-rz port 0) Processing the post-auth section of radiusd.conf modcall: entering group post-auth for request 0 rlm_sql (sql): Processing sql_postauth radius_xlat: 'fempowerbook' rlm_sql (sql): sql_set_user escaped user --> 'fempowerbook' radius_xlat: 'INSERT into radpostauth (id, user, pass, reply, date) values ('', 'fempowerbook@zki', 'fpb', 'Access-Accept', NOW())' rlm_sql (sql) in sql_postauth: query is INSERT into radpostauth (id, user, pass, reply, date) values ('', 'fempowerbook@zki', 'fpb', 'Access-Accept', NOW()) rlm_sql (sql): Reserving sql socket id: 3 rlm_sql (sql): Released sql socket id: 3 modcall[post-auth]: module "sql" returns ok for request 0 modcall: group post-auth returns ok for request 0 Sending Access-Accept of id 15 to 141.24.X.153:1814 Proxy-State = 0x313931 Finished request 0 Going to the next request --- Walking the entire request list --- Waking up in 6 seconds... --- Walking the entire request list --- Cleaning up request 0 ID 15 with timestamp 43267cb9 Nothing to do. Sleeping until we see a request.

4 3