(RADIATOR) Help getting MySQL Accounting working
Frank Danielson
fdanielson at dataonair.com
Tue Aug 6 11:41:21 CDT 2002
The timestamp 1028648432 recorded in the trace converts to a local time of
2002-7-6 11:40:32 which is the same as the time of Tue Aug 6 11:40:32 2002
recorded on the log file entry. So it appears that RADIATOR it correctly
timestamping the entry with the local time of the system it is running on. Is
the time correct on your server?
>===== Original Message From "Steve Caporossi" <capoross at musc.edu> =====
>Hugh,
>
>Attached is my config and Trace 4. I did download and install the
>timedate module from CPAN.
>
>Thanks, Steve
>
># radius.cfg
>#
># Radiator configuration file.
>#
># This will authenticate from the /etc/shadow file.
># Accounting will be logged to a SQL Database
>#
># It will and try to handle request for any realm.
>#
>#
>
>#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 128.23.10.1>
> Identifier NASPPP
> NasType Cisco
> Secret mysecret
> DupInterval 0
></Client>
>
><Client 128.23.10.2>
> Identifier NASPPP
> NasType Cisco
> Secret mysecret
> DupInterval 0
></Client>
>
><Client 128.23.11.1>
> Identifier NAS-vpn
> NasType Cisco
> Secret mysecret
> DupInterval 0
></Client>
>
>
><Realm DEFAULT>
>
> AuthByPolicy ContinueAlways
>
> <AuthBy SQL>
> DBSource dbi:mysql:radiuslogs
> DBUsername myuser
> DBAuth mypasswd
>
> AuthSelect
>
> AccountingTable ACCOUNTING
> AcctColumnDef USERNAME,User-Name
> 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 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
> AcctColumnDef NASIDENTIFIER,NAS-Identifier
> AcctColumnDef NASIPADDRESS,NAS-IP-Address
> AcctColumnDef NASPORT,NAS-Port,integer
> AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
> AcctColumnDef CALLEDSTATIONID,Called-Station-Id
> AcctColumnDef CALLINGSTATIONID,Calling-Station-Id
> AcctColumnDef ACCTAUTHENTIC,Acct-Authentic
> AcctColumnDef CLASS,Class
> AcctColumnDef ACCOUNTSESSIONTIME,Acct-Session-Time,integer
> AcctColumnDef TUNNELCLIENTENDPOINT,Tunnel-Client-Endpoint
>
> AcctFailedLogFileName
>%L/%{Client:Identifier}/%m%d%y.missedaccountin.log
> </AuthBy>
>
> <AuthBy UNIX>
> Filename /etc/shadow
> </AuthBy>
>
> # Log accounting to a detail file
> AcctLogFileName %L/%{Client:Identifier}/%m%d%y.log
>
></Realm>
>
>********************TRACE 4*********************************
>
>Tue Aug 6 11:39:11 2002: INFO: Server started: Radiator 3.1 on myserver
>Tue Aug 6 11:40:12 2002: DEBUG: Packet dump:
>*** Received from xxx.xxx.xxx.2 port 1645 ....
>Code: Access-Request
>Identifier: 178
>Authentic: <184>%<146><135><190><24><199><31>WXS<2><161><205>!<211>
>Attributes:
> NAS-IP-Address = xxx.xxx.xxx.2
> NAS-Port = 59
> NAS-Port-Type = Async
> User-Name = "username"
> Called-Station-Id = "yyyyyyy"
> Calling-Station-Id = "??????????"
> User-Password =
>"<140><228><235><243>Z<27><21><136>5%<208><6><229>y<213><140>"
> Service-Type = Framed-User
> Framed-Protocol = PPP
>
>Tue Aug 6 11:40:12 2002: DEBUG: Handling request with Handler
>'Realm=DEFAULT'
>Tue Aug 6 11:40:12 2002: DEBUG: Deleting session for username,
>xxx.xxx.xxx.2, 59
>Tue Aug 6 11:40:12 2002: DEBUG: Handling with Radius::AuthSQL
>Tue Aug 6 11:40:12 2002: DEBUG: Handling with Radius::AuthUNIX:
>Tue Aug 6 11:40:12 2002: DEBUG: Radius::AuthUNIX looks for match with
>username
>Tue Aug 6 11:40:12 2002: DEBUG: Radius::AuthUNIX ACCEPT:
>Tue Aug 6 11:40:12 2002: DEBUG: Access accepted for username
>Tue Aug 6 11:40:12 2002: DEBUG: Packet dump:
>*** Sending to xxx.xxx.xxx.2 port 1645 ....
>Code: Access-Accept
>Identifier: 178
>Authentic: <184>%<146><135><190><24><199><31>WXS<2><161><205>!<211>
>Attributes:
>
>Tue Aug 6 11:40:13 2002: DEBUG: Packet dump:
>*** Received from xxx.xxx.xxx.2 port 1646 ....
>Code: Accounting-Request
>Identifier: 179
>Authentic: ;<155><137><244>LD<216>C}<180><1><161><220><26>{<143>
>Attributes:
> NAS-IP-Address = xxx.xxx.xxx.2
> NAS-Port = 59
> NAS-Port-Type = Async
> User-Name = "username"
> Called-Station-Id = "yyyyyyy"
> Calling-Station-Id = "??????????"
> Acct-Status-Type = Start
> Acct-Authentic = RADIUS
> Service-Type = Framed-User
> Acct-Session-Id = "000001EB"
> Framed-Protocol = PPP
> Acct-Link-Count = 1
> Acct-Multi-Session-Id = "65"
> Framed-IP-Address = xxx.xxx.xxx.33
> Acct-Delay-Time = 0
>
>Tue Aug 6 11:40:13 2002: DEBUG: Handling request with Handler
>'Realm=DEFAULT'
>Tue Aug 6 11:40:13 2002: DEBUG: Adding session for username,
>xxx.xxx.xxx.2, 59
>Tue Aug 6 11:40:13 2002: DEBUG: Handling with Radius::AuthSQL
>Tue Aug 6 11:40:13 2002: DEBUG: Handling accounting with
>Radius::AuthSQL
>Tue Aug 6 11:40:13 2002: DEBUG: do query is: insert into ACCOUNTING
> (USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME,
>ACCTSESSIONID, NASIPADDRESS, NASPORT, FRAMEDIPADDRESS, CALLEDSTATIONID,
>CALLINGSTATIONID, ACCTAUTHENTIC)
> values
> ('username', 1028648413, 'Start', 0, '000001EB',
>'xxx.xxx.xxx.2', 59, 'xxx.xxx.xxx.33', 'yyyyyyy', '??????????',
>'RADIUS')
>
>Tue Aug 6 11:40:13 2002: DEBUG: Handling with Radius::AuthUNIX:
>Tue Aug 6 11:40:13 2002: DEBUG: Accounting accepted
>Tue Aug 6 11:40:13 2002: DEBUG: Packet dump:
>*** Sending to xxx.xxx.xxx.2 port 1646 ....
>Code: Accounting-Response
>Identifier: 179
>Authentic: ;<155><137><244>LD<216>C}<180><1><161><220><26>{<143>
>Attributes:
>
>Tue Aug 6 11:40:32 2002: DEBUG: Packet dump:
>*** Received from xxx.xxx.xxx.2 port 1646 ....
>Code: Accounting-Request
>Identifier: 180
>Authentic: <152><177><241>h<203>Z<201><247>nf<242><223><184><183>9<134>
>Attributes:
> NAS-IP-Address = xxx.xxx.xxx.2
> NAS-Port = 59
> NAS-Port-Type = Async
> User-Name = "username"
> Called-Station-Id = "yyyyyyy"
> Calling-Station-Id = "??????????"
> Acct-Status-Type = Stop
> Acct-Authentic = RADIUS
> Service-Type = Framed-User
> Acct-Session-Id = "000001EB"
> Framed-Protocol = PPP
> Acct-Link-Count = 1
> Acct-Multi-Session-Id = "65"
> Framed-IP-Address = xxx.xxx.xxx.33
> Acct-Terminate-Cause = User-Request
> Acct-Input-Octets = 1202
> Acct-Output-Octets = 339
> Acct-Input-Packets = 33
> Acct-Output-Packets = 11
> Acct-Session-Time = 18
> Acct-Delay-Time = 0
>
>Tue Aug 6 11:40:32 2002: DEBUG: Handling request with Handler
>'Realm=DEFAULT'
>Tue Aug 6 11:40:32 2002: DEBUG: Deleting session for username,
>xxx.xxx.xxx.2, 59
>Tue Aug 6 11:40:32 2002: DEBUG: Handling with Radius::AuthSQL
>Tue Aug 6 11:40:32 2002: DEBUG: Handling accounting with
>Radius::AuthSQL
>Tue Aug 6 11:40:32 2002: DEBUG: do query is: insert into ACCOUNTING
> (USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME,
>ACCTINPUTOCTETS, ACCTOUTPUTOCTETS, ACCTINPUTPACKETS, ACCTOUTPUTPACKETS,
>ACCTSESSIONID, ACCTSESSIONTIME, ACCTTERMINATECAUSE, NASIPADDRESS,
>NASPORT, FRAMEDIPADDRESS, CALLEDSTATIONID, CALLINGSTATIONID,
>ACCTAUTHENTIC, ACCOUNTSESSIONTIME)
> values
> ('username', 1028648432, 'Stop', 0, 1202, 339, 33, 11,
>'000001EB', 18, 'User-Request', 'xxx.xxx.xxx.2', 59, 'xxx.xxx.xxx.33',
>'yyyyyyy', '??????????', 'RADIUS', 18)
>
>Tue Aug 6 11:40:32 2002: DEBUG: Handling with Radius::AuthUNIX:
>Tue Aug 6 11:40:32 2002: DEBUG: Accounting accepted
>Tue Aug 6 11:40:32 2002: DEBUG: Packet dump:
>*** Sending to xxx.xxx.xxx.2 port 1646 ....
>Code: Accounting-Response
>Identifier: 180
>Authentic: <152><177><241>h<203>Z<201><247>nf<242><223><184><183>9<134>
>Attributes:
>
>
>----- Original Message -----
>From: Hugh Irvine <mailto:hugh at open.com.au>
>To: Steve Caporossi <mailto:capoross at musc.edu>
>Cc: radiator at open.com.au <mailto:radiator at open.com.au>
>Sent: Monday, August 05, 2002 7:21 PM
>Subject: Re: (RADIATOR) Help getting MySQL Accounting working
>
>Hello Steve -
>
>I will need to see a copy of the current configuration file (no secrets)
>together with a trace 4 debug showing what is happening. You should be
>aware that the Timestamp is the time on the Radiator host that is
>automatically corrected for any Acct-Delay-Time included in the
>accounting request.
>
>regards
>
>Hugh
>
>
>On Tuesday, August 6, 2002, at 05:17 AM, Steve Caporossi wrote:
>
>
>
>Thanks Hugh.
>
>I have a couple more questions, Why is the timestamp inserted with the
>incorrect date? I tried all the permutations of the timestamp but, I
>either get 0000-00-00 00:00:00 or an incorrect date such as 2000-10-28
>57:17:65 which is from 5 minutes ago.
>
>Thanks,
>Steve
>
>
>
>--
>Radiator: the most portable, flexible and configurable RADIUS server
>anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
>-
>Nets: internetwork inventory and management - graphical, extensible,
>flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.
More information about the radiator
mailing list