Can anyone give me any hints as to why I
cannot get any accounting entries in my database? Below is my
radius config and the output from a Trace 4. I am authenticating from the
system password file OK but no accounting is being put into the database.
I am running RH7.2 and Radiator 3.0.
Thanks, Steve
*************************** Config ***************************
# radius.cfg
# # Radiator configuration file. # # #Foreground
#LogStdout LogDir /var/log/radius DbDir /etc/radiator # Use a low trace level in production systems. Increase # it to 4 or 5 for debugging, or use the -trace flag to radiusd Trace 4 # Add other Clients below...
<Client xxx.xxx.xxx.xxx> Identifier ppp Secret removed DupInterval 0 </Client> <Client xxx.xxx.xxx.xxx>
Identifier ppp Secret removed
DupInterval 0
</Client> <Client
xxx.xxx.xxx.xxx>
Identifier vpn Secret removed
DupInterval 0
</Client> <Realm DEFAULT> <AuthBy UNIX> Filename /etc/shadow </AuthBy> # Log accounting to a detail file AcctLogFileName %L/%{Client:Identifier}/%m%d%y.log <AuthBy
SQL>
DBSource dbi:mysql:radiuslogs DBUsername removed DBAuth removed AuthSelect
AccountingTable
ACCOUNTING
AcctColumnDef USERNAME,username AcctColumnDef TIME_STAMP,Timestamp,integer AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer AcctColumnDef ACCTINPUTPACKETS,Acct-Input-Packets,integer AcctColumnDef ACCTOUTPUTPACKETS,Acct-Output-Packets,integer AcctColumnDef ACCTSESSIONID,Acct-Session-Id AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause,integer AcctColumnDef NASIPADDRESS,NAS-IP-Address, AcctColumnDef NASIDENTIFIER,NAS-Identifier AcctColumnDef NASPORT,NAS-Port,integer AcctColumnDef NASPORTTYPE,NAS-Port-Type AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address AcctColumnDef CALLEDSTATIONID,Called-Station-Id AcctColumnDef CALLINGSTATIONID,Calling-Station-Id AcctColumnDef ACCTAUTHENTIC,Acct-Authentic AcctColumnDef FRAMEDPROTOCOL,Framed-Protocol AcctColumnDef ACCTLINKCNT,Acct-Link-Count AcctColumnDef ACCTMULTISESSID,Acct-Multi-Session-Id AcctColumnDef CLASS,Class AcctColumnDef ACCOUNTSESSIONTIME,Acct-Session-Time,integer AcctColumnDef TUNNELCLIENTENDPOINT,Tunnel-Client-Endpoint # AcctFailedLogFileName
%D/missedaccounting
</AuthBy> </Realm> *************************** TRACE 4 ***************************
Mon Jul 29 15:37:22 2002: DEBUG: Packet dump:
*** Received from x.x.x.x port 1645 .... Code: Access-Request Identifier: 57 Authentic: ?R<210><13>r<<135><132>R<192><4><28><207>9<183><134> Attributes: NAS-IP-Address = x.x.x.x NAS-Port = 114 NAS-Port-Type = Async User-Name = "username" Called-Station-Id = "3238732" Calling-Station-Id = "5551212" User-Password = "<202><2>]L><195><197>u<184><248><130><198><128>.<30>9" Service-Type = Framed-User Framed-Protocol = PPP Mon Jul 29 15:37:22 2002: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Mon Jul 29 15:37:22 2002: DEBUG: Deleting session for username, x.x.x.x, 114 Mon Jul 29 15:37:22 2002: DEBUG: Handling with Radius::AuthUNIX: Mon Jul 29 15:37:22 2002: DEBUG: Radius::AuthUNIX looks for match with username Mon Jul 29 15:37:22 2002: DEBUG: Radius::AuthUNIX ACCEPT: Mon Jul 29 15:37:22 2002: DEBUG: Access accepted for username Mon Jul 29 15:37:22 2002: DEBUG: Packet dump: *** Sending to x.x.x.x port 1645 .... Code: Access-Accept Identifier: 57 Authentic: ?R<210><13>r<<135><132>R<192><4><28><207>9<183><134> Attributes: Mon Jul 29 15:37:22 2002: DEBUG: Packet dump:
*** Received from x.x.x.x port 1646 .... Code: Accounting-Request Identifier: 58 Authentic: Q<29>:<144>-A<198><199>z<154>*}<<145>Q<171> Attributes: NAS-IP-Address = x.x.x.x NAS-Port = 114 NAS-Port-Type = Async User-Name = "username" Called-Station-Id = "3238732" Calling-Station-Id = "5551212" Acct-Status-Type = Start Acct-Authentic = RADIUS Service-Type = Framed-User Acct-Session-Id = "000001D4" Framed-Protocol = PPP Acct-Link-Count = 1 Acct-Multi-Session-Id = "44" Framed-IP-Address = x.x.x.49 Acct-Delay-Time = 0 Mon Jul 29 15:37:22 2002: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Mon Jul 29 15:37:22 2002: DEBUG: Adding session for username, x.x.x.x, 114 Mon Jul 29 15:37:22 2002: DEBUG: Handling with Radius::AuthUNIX: Mon Jul 29 15:37:22 2002: DEBUG: Accounting accepted Mon Jul 29 15:37:22 2002: DEBUG: Packet dump: *** Sending to x.x.x.x port 1646 .... Code: Accounting-Response Identifier: 58 Authentic: Q<29>:<144>-A<198><199>z<154>*}<<145>Q<171> Attributes: Mon Jul 29 15:38:18 2002: DEBUG: Packet dump:
*** Received from x.x.x.x port 1646 .... Code: Accounting-Request Identifier: 59 Authentic: <2>j!<3><165><174><239><227>X<242>0neH[) Attributes: NAS-IP-Address = x.x.x.x NAS-Port = 114 NAS-Port-Type = Async User-Name = "username" Called-Station-Id = "3238732" Calling-Station-Id = "5551212" Acct-Status-Type = Stop Acct-Authentic = RADIUS Service-Type = Framed-User Acct-Session-Id = "000001D4" Framed-Protocol = PPP Acct-Link-Count = 1 Acct-Multi-Session-Id = "44" Framed-IP-Address = x.x.x.49 Acct-Terminate-Cause = User-Request Acct-Input-Octets = 1363 Acct-Output-Octets = 721 Acct-Input-Packets = 37 Acct-Output-Packets = 15 Acct-Session-Time = 54 Acct-Delay-Time = 0 Mon Jul 29 15:38:18 2002: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Mon Jul 29 15:38:18 2002: DEBUG: Deleting session for username, x.x.x.x, 114 Mon Jul 29 15:38:18 2002: DEBUG: Handling with Radius::AuthUNIX: Mon Jul 29 15:38:18 2002: DEBUG: Accounting accepted Mon Jul 29 15:38:18 2002: DEBUG: Packet dump: *** Sending to x.x.x.x port 1646 .... Code: Accounting-Response Identifier: 59 Authentic: <2>j!<3><165><174><239><227>X<242>0neH[) Attributes: |
- Re: (RADIATOR) Help getting MySQL Accounting working Steve Caporossi