Hello Toni -
I think your NAS is not correctly configured. The reason you don't see an
accounting log is because you are not receiving any accounting packets from the
NAS.
hth
Hugh
On Tue, 14 Nov 2000, Toni Riekkinen wrote:
> Hello,
>
> I've problem with accounting logs, I can't get any accounting log at all,
> not in plain detail-file nor in our database. Authentication works just fine
> from users-file or database.
>
> I've Solaris 8 (5.8) and Oracle8i Release 2 (8.1.6). I've installed timeout
> patch.
>
> This is my current radius.cfg with database support:
> As I said, I've also tried for example with "AcctLogFileName
> /opt/radius/log/detail" and authentication from users file, no help.
> --------------------------------------------
> Foreground
> LogStdout
> LogDir /opt/radius/log
> DbDir /opt/radius/raddb
> LogFile %L/radiusd.log
> Trace 4
>
> <Client DEFAULT>
> Secret XXXX
> DupInterval 5
> NasType Cisco
> StatusServerShowClientDetails
> </Client>
>
> <Realm DEFAULT>
> MaxSessions 1
> <AuthBy SQL>
> DBSource dbi:Oracle:XXXXX
> DBUsername XXXXX
> DBAuth XXXXX
> AuthSelect select accesspw from kpy_customers where
> accesslogin='%n'
> AccountingTable kpy_radaccount
> # AcctColumnDef aika,Timestamp,formatted-date,to_date\
> # ('%e %m %Y %H:%M:%S', 'DD MM YYYY HH24:MI:SS')
> AcctColumnDef user_name,User-Name
> AcctColumnDef nas_ip_address,NAS-IP-Address
> AcctColumnDef nas_port,NAS-Port,integer
> AcctColumnDef framed_ip_address,Framed-IP-Address
> AcctColumnDef called_station_id,Called-Station-Id
> AcctColumnDef nas_port_type,NAS-Port-Type
> AcctColumnDef acct_input_octets,Acct-Input-Octets,integer
> AcctColumnDef
> acct_output_octets,Acct-Output-Octets,integer
> AcctColumnDef acct_session_id,Acct-Session-Id
> AcctColumnDef acct_session_time,Acct-Session-Time,integer
> AcctColumnDef acct_terminate_cause,Acct-Terminate-Cause
> Timeout 15
> AddToReply Service-Type=Framed-User,
> Framed-Protocol=PPP, Framed-Routing = None, Framed-MTU = 1500,
> Framed-Compression = Van-Jacobson-TCP-IP
> </AuthBy>
> </Realm>
> ------------------------------
>
> With tracelevel 4, I get this:
>
> ------------------------------
> Mon Nov 13 16:10:22 2000: DEBUG: Packet dump:
> *** Received from xxx.xxx.xxx.xxx port 1645 ....
> Code: Access-Request
> Identifier: 43
> Authentic: k<145><5><15><209>T$<250><150>'<223>zN<167><189><217>
> Attributes:
> NAS-IP-Address = xxx.xxx.xxx.xxx
> NAS-Port = 30001
> NAS-Port-Type = ISDN
> User-Name = "testi1"
> Called-Station-Id = "173636057"
> Calling-Station-Id = "0173643572"
> CHAP-Password = "XXXXX"
> Service-Type = Framed-User
> Framed-Protocol = PPP
>
> Mon Nov 13 16:10:22 2000: DEBUG: Handling request with Handler
> 'Realm=DEFAULT'
> Mon Nov 13 16:10:22 2000: DEBUG: Deleting session for testi1,
> xxx.xxx.xxx.xxx, 30001
> Mon Nov 13 16:10:22 2000: DEBUG: Handling with Radius::AuthSQL
> Mon Nov 13 16:10:26 2000: DEBUG: Handling with Radius::AuthSQL
> Mon Nov 13 16:10:26 2000: DEBUG: Query is: select accesspw from
> kpy_customers where accesslogin='testi1'
>
> Mon Nov 13 16:10:26 2000: DEBUG: Radius::AuthSQL looks for match with testi1
> Mon Nov 13 16:10:26 2000: DEBUG: Radius::AuthSQL ACCEPT:
> Mon Nov 13 16:10:26 2000: DEBUG: Access accepted for testi1
> Mon Nov 13 16:10:26 2000: DEBUG: Packet dump:
> *** Sending to xxx.xxx.xxx.xxx port 1645 ....
> Code: Access-Accept
> Identifier: 43
> Authentic: k<145><5><15><209>T$<250><150>'<223>zN<167><189><217>
> Attributes:
> Service-Type = Framed-User
> Framed-Protocol = PPP
> Framed-Routing = None
> Framed-MTU = 1500
> Framed-Compression = Van-Jacobson-TCP-IP
>
> ------------------------------
>
> What I have configured wrong? I believe I should see atleast some
> AcctColumnDef information at debug, but there is nothing?
>
> Also I'd like to get BOTH accounting logging methods work at same time, to
> database and into detail-file. Though even another of those would be nice
> for start... :)
>
> ++Toni
>
>
>
> ===
> Archive at http://www.starport.net/~radiator/
> Announcements on [EMAIL PROTECTED]
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
