Hi ALL, I have made no progress in resolving the radaccct problem. Radius is loading with no error messages and I've gone over the radiusd.conf and sql.conf a million times. below is the output from Radius when a client logs in. rad_recv: Access-Request packet from host 82.141.232.132:51214, id=0, length=218 --- Walking the entire request list --- Waking up in 31 seconds... Thread 2 got semaphore Thread 2 handling request 1, (1 handled so far) User-Name = "sipkek10" CHAP-Challenge = 0x8a37e2835fe0e45acf9680564cb660c3 CHAP-Password = 0x003c7507dd1f4ecf4389429af1a1e74e9d NAS-IP-Address = 0.0.0.0 Service-Type = Login-User Framed-IP-Address = 192.168.182.14 Calling-Station-Id = "00-C0-49-5C-40-48" Called-Station-Id = "00-12-17-4A-01-A9" NAS-Identifier = "wasp1" Acct-Session-Id = "430c042e00000001" NAS-Port-Type = Wireless-802.11 NAS-Port = 1 Message-Authenticator = 0x6df308586dc9a8df5dc7a274fa008a88 WISPr-Logoff-URL = "http://192.168.182.1:3990/logoff" Processing the authorize section of radiusd.conf modcall: entering group authorize for request 1 modcall[authorize]: module "preprocess" returns ok for request 1 rlm_chap: Setting 'Auth-Type := CHAP' modcall[authorize]: module "chap" returns ok for request 1 modcall[authorize]: module "mschap" returns noop for request 1 rlm_realm: No '@' in User-Name = "sipkek10", looking up realm NULL rlm_realm: No such realm "NULL" modcall[authorize]: module "suffix" returns noop for request 1 radius_xlat: 'sipkek10' rlm_sql (sql): sql_set_user escaped user --> 'sipkek10' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'sipkek10' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 2 radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'sipkek10' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'sipkek10' ORDER BY id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'sipkek10' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): Released sql socket id: 2 modcall[authorize]: module "sql" returns ok for request 1 rlm_sqlcounter: Entering module authorize code sqlcounter_expand: 'SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{User-Name}'' radius_xlat: 'SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='sipkek10'' sqlcounter_expand: '%{sql:SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='sipkek10'}' radius_xlat: Running registered xlat function of module sql for string 'SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='sipkek10'' rlm_sql (sql): - sql_xlat radius_xlat: 'sipkek10' rlm_sql (sql): sql_set_user escaped user --> 'sipkek10' radius_xlat: 'SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='sipkek10'' rlm_sql (sql): Reserving sql socket id: 1 rlm_sql (sql): row[0] returned NULL rlm_sql (sql): Released sql socket id: 1 radius_xlat: '' rlm_sqlcounter: (Check item - counter) is greater than zero rlm_sqlcounter: Authorized user sipkek10, check_item=1800, counter=0 rlm_sqlcounter: Sent Reply-Item for user sipkek10, Type=Session-Timeout, value=1800 modcall[authorize]: module "noresetcounter" returns ok for request 1 modcall: group authorize returns ok for request 1 rad_check_password: Found Auth-Type CHAP auth: type "CHAP" Processing the authenticate section of radiusd.conf modcall: entering group Auth-Type for request 1 rlm_chap: login attempt by "sipkek10" with CHAP password rlm_chap: Using clear text password bigdogut for user sipkek10 authentication. rlm_chap: chap user sipkek10 authenticated succesfully modcall[authenticate]: module "chap" returns ok for request 1 modcall: group Auth-Type returns ok for request 1 Processing the session section of radiusd.conf modcall: entering group session for request 1 modcall[session]: module "sql" returns noop for request 1 modcall: group session returns noop for request 1 Sending Access-Accept of id 0 to 82.141.232.132:51214 Session-Timeout = 1800 Finished request 1 Going to the next request Thread 2 waiting to be assigned a request --- Walking the entire request list --- Cleaning up request 1 ID 0 with timestamp 430c7430 Nothing to do. Sleeping until we see a request. Can anyone spot something in this that might point me in the right direction? Regards, Sean
sean wrote:
Hi ALL,
I have made no progress in resolving the radaccct problem. Radius is loading with no error messages and I've gone over the radiusd.conf and sql.conf a million times.
below is the output from Radius when a client logs in.
Now a debug trace of an Access-Request packet is very handy to spot an issue which has to do all with accounting packets :) The radacct table is only filled with INSERT queries when Accounting-Request packets are handled! Check that the NAS is actually sending accounting packets and that they actually arrive on the correct radius server! -- Groeten, Regards, Salutations, Thor Spruyt M: +32 (0)475 67 22 65 E: thor.spruyt@telenet.be W: www.thor-spruyt.com www.salesguide.be www.telenethotspot.be
sean <sean@topup.ie> wrote:
I have made no progress in resolving the radaccct problem. Radius is loading with no error messages and I've gone over the radiusd.conf and sql.conf a million times.
But not the responses on this list.
below is the output from Radius when a client logs in.
In which there is no accounting packets. In other words, you are trying to figure out why your car makes funny noises by looking at your bicycle. See the FAQ. If the NAS doesn't send accounting information, FreeRADIUS can't log data it doesn't receive. Make the NAS send accounting data. This MAY involve reading NAS documentation, and not "radiusd.conf". Alan DeKok.
participants (3)
-
Alan DeKok -
sean -
Thor Spruyt