While in the process of trying to migrate from Cistron Radius to
FreeRadius, I have been testing posting of my detail files to a test server
running the latest Freeradius via cvs and postgresql. One problem I have
run into is that the logs from my MAX sometimes will create radius records
that do not have a username.
e.g.
Tue Mar 19 16:24:04 2002
NAS-IP-Address = 192.168.1.26
NAS-Port = 20102
NAS-Port-Type = Async
Acct-Status-Type = Stop
Acct-Delay-Time = 20
Acct-Session-Id = "146da78a"
Ascend-Disconnect-Cause = Modem-No-DCD
Ascend-Connect-Progress = 31
Ascend-Xmit-Rate = 0
Ascend-Data-Rate = 0
Ascend-PreSession-Time = 60
Ascend-Pre-Input-Octets = 0
Ascend-Pre-Output-Octets = 0
Ascend-Pre-Input-Packets = 0
Ascend-Pre-Output-Packets = 0
Ascend-Modem-PortNo = 1
Ascend-Modem-SlotNo = 4
Calling-Station-Id = "5195555555"
Called-Station-Id = "5195555555"
Client-IP-Address = 192.168.1.26
Timestamp = 1016573044
Request-Authenticator = Verified
radiusd -X
gives the following....
--- Walking the entire request list ---
Cleaning up request 92 ID 57 with timestamp 3c9f9a35
Nothing to do. Sleeping until we see a request.
rad_recv: Accounting-Request packet from host 199.212.134.2:4923, id=25,
length=216
NAS-IP-Address = 209.112.4.26
NAS-Port = 20102
NAS-Port-Type = Async
Acct-Status-Type = Stop
Acct-Delay-Time = 519640
Acct-Session-Id = "146da78a"
Ascend-Disconnect-Cause = Modem-No-DCD
Ascend-Connect-Progress = Modem-Awaiting-DCD
Ascend-Xmit-Rate = 0
Ascend-Data-Rate = 0
Ascend-PreSession-Time = 60
Ascend-Pre-Input-Octets = 0
Ascend-Pre-Output-Octets = 0
Ascend-Pre-Input-Packets = 0
Ascend-Pre-Output-Packets = 0
Ascend-Modem-PortNo = 1
Ascend-Modem-SlotNo = 4
Calling-Station-Id = "5197480550"
Called-Station-Id = "5192243023"
modcall: entering group preacct
modcall[preacct]: module "suffix" returns ok
modcall[preacct]: module "files" returns noop
modcall[preacct]: module "preprocess" returns noop
modcall: group preacct returns ok
modcall: entering group accounting
radius_xlat: '/usr/local/adm/radacct/199.212.134.2/detail'
rlm_detail: /usr/local/adm/radacct/%{Client-IP-Address}/detail expands to
/usr/local/adm/radacct/199.212.134.2/detail
modcall[accounting]: module "detail" returns ok
radius_xlat: ''
modcall[accounting]: module "sql" returns fail
modcall: group accounting returns fail
Finished request 93
Going to the next request
--- Walking the entire request list ---
Cleaning up request 93 ID 25 with timestamp 3c9f9a37
Nothing to do. Sleeping until we see a request.
2 questions: Is there any way to configure FreeRADIUS to ignore this an
log what it can to the sql database ? And secondly, are there any other
utilities other than radrelay that will aid in the loading of detail files
into an sql database ?
Thanks,
---Mike
--------------------------------------------------------------------
Mike Tancsa, tel +1 519 651 3400
Sentex Communications, [EMAIL PROTECTED]
Providing Internet since 1994 www.sentex.net
Cambridge, Ontario Canada www.sentex.net/mike
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html