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.
