Hi folks.
Im trying to get sql and radutmp/radwtmp accounting and session working,
but so far only SQL
seems to work.
Here's more info:
Config:
<snip>
accounting {
detail
unix
sql
radutmp
}
session {
sql
radutmp
}
</snip>
Log:
rad_recv: Accounting-Request packet from host 127.0.0.1:1390, id=30,
length=110
NAS-IP-Address = 216.18.72.104
NAS-Port-Id = "1756"
NAS-Port-Type = Async
User-Name = "sylhubert"
Called-Station-Id = "4482998"
Calling-Station-Id = "4502581853"
Acct-Status-Type = Start
Acct-Authentic = RADIUS
Service-Type = Framed-User
Acct-Session-Id = "00063E6D"
Framed-Protocol = PPP
Acct-Delay-Time = 0
modcall: entering group preacct
modcall[preacct]: module "preprocess" returns noop
rlm_realm: Looking up realm NULL for User-Name = "sylhubert"
rlm_realm: No such realm NULL
modcall[preacct]: module "suffix" returns noop
modcall[preacct]: module "files" returns noop
modcall: group preacct returns noop
modcall: entering group accounting
radius_xlat: '/usr/local/var/log/radius/radacct/127.0.0.1/detail'
rlm_detail:
/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail expand
s to /usr/local/var/log/radius/radacct/127.0.0.1/detail
modcall[accounting]: module "detail" returns ok
modcall[accounting]: module "unix" returns noop
radius_xlat: 'sylhubert'
sql_set_user: escaped user --> 'sylhubert'
radius_xlat: 'INSERT into radacct (AcctSessionId, AcctUniqueId,
UserName, Realm
, NASIPAddress, NASPortID, NASPortType, AcctStartTime, AcctSessionTime,
AcctAuth
entic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets,
AcctOutputOctets, C
alledStationId, CallingStationId, AcctTerminateCause, ServiceType,
FramedProtoco
l, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('00063E6D',
'', 'sylhu
bert', '', 'XXX.XXX.XXX.XXX', '1756', 'Async', '2002-09-27 13:02:35',
NULL, 'RADIU
S', '', '', '0', '0', '4482998', 'XXXXXXXXXX', '', 'Framed-User', 'PPP',
'', '0'
, '0')'
query: INSERT into radacct (AcctSessionId, AcctUniqueId, UserName,
Realm, NASIPA
ddress, NASPortID, NASPortType, AcctStartTime, AcctSessionTime,
AcctAuthentic, C
onnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets,
CalledSta
tionId, CallingStationId, AcctTerminateCause, ServiceType,
FramedProtocol, Frame
dIPAddress, AcctStartDelay, AcctStopDelay) values('00063E6D', '',
'sylhubert', '
', 'XXX.XXX.XXX.XXX', '1756', 'Async', '2002-09-27 13:02:35', NULL,
'RADIUS', '',
'', '0', '0', '4482998', 'XXXXXXXXXX', '', 'Framed-User', 'PPP', '',
'0', '0')
rlm_postgresql Status: PGRES_COMMAND_OK
sql_postgresql: affected rows = 1
rlm_sql: Released sql socket id: 4
modcall[accounting]: module "sql" returns ok
radius_xlat: 'sylhubert'
modcall[accounting]: module "radutmp" returns noop
modcall: group accounting returns ok
Sending Accounting-Response of id 30 to 127.0.0.1:1390
Finished request 0
Going to the next request
--- Walking the entire request list ---
Cleaning up request 0 ID 30 with timestamp 3d9456eb
Nothing to do. Sleeping until we see a request.
What's not looking good:
modcall[accounting]: module "unix" returns noop
radius_xlat: 'sylhubert'
modcall[accounting]: module "radutmp" returns noop
I have looked into rlm_radutmp and it seems to return NOOP because
nas_port is missing
from the request. I would suspect that same is happening with rlm_unix
and radutmp and radwtmp are not being created.
Any ideas ?
Thanx
Paul
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
