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

Reply via email to