Dale E. Reed Jr. wrote:
> Run RadiusNT in -x15 debug mode and see what is happening on
> accounting requests. You might be getting an error on the insert.
Hi Dale,
I've tried this, but RadiusNT doesn't seem to even compose an insert
statement for the accounting-start/stop messages. Messages with standard
Start/Stop AcctStatusTypes are logged to the DB with no problems. I enclose
the debug output generated by an ascend rebooting below. Any ideas?
Cheers,
Ross McNab.
>>>> Output from radius.exe -x15
0) IgnoreCase: 0
1) TrimName: 0
2) ReqAcctAuth: 0
3) AllowMalformed: 0
4) Mode: 2
5) Proxy: 0
6) Options: 0
7) SNMP: 0
8) Debug: 0
9) LogFile:
10) AcctLogFile: c:\radius\acc.log
11) ODBCDatasource: Radius
12) Username:
13) Password:
14) AcctODBCDatasource: Radius
15) AcctUsername:
16) AcctPassword:
17) TestDatabaseSecs:
18) DataDirectory: c:\radius\
19) AcctDirectory: c:\radius\acct\
20) UsersFile: Users
21) CompanyName: [snip]
22) License: [snip]
23) IPAddress: All
24) AcctPort: 1646
Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: 'Radius'...
Making ODBC Connection...
MS Access Mode Enabled
SQL Statement: Select DISTINCT Company, LicenseID From Licenses
SQL Statement: Select DISTINCT Company, LiscenseID From Liscenses
ODBC Datasource: 'Radius'...
Making ODBC Connection...
MS Access Mode Enabled
SQL Statement: Select DISTINCT Company, LicenseID From Licenses
SQL Statement: Select DISTINCT Company, LiscenseID From Liscenses
Allocating Statement...
SQL Statement: Select Name, RadAttributeID, Type, RadVendorID,
RadVendorType From RadAttributes Order By RadVendorID, RadAttributeID
SQL Statement: Select ra.Name, rv.Name, rv.Value From RadValues rv,
RadAttributes ra Where rv.RadAttributeID = ra.RadAttributeID
118 Dictionary Attributes Loaded...
SQL Statement: Select Server, IPAddress, Secret From Servers
12 Clients Loaded
Accounting Column 0 (16): 'NASIPAddress'
Accounting Column 1 (4): 'NASPort'
Accounting Column 2 (9): 'AcctSessionId'
Accounting Column 3 (2): 'AcctStatusType'
Accounting Column 4 (16): 'CallDate'
Accounting Column 5 (40): 'UserName'
Accounting Column 6 (4): 'AcctDelayTime'
Accounting Column 7 (4): 'AcctSessionTime'
Accounting Column 8 (2): 'NASPortType'
Accounting Column 9 (4): 'pkid'
10 Accounting Columns Loaded
Loading users...
0 users loaded!
Defaulting to port 1645 for RADIUS Authentication.
RadiusNT 2.5.175 Standard Initialized...
radrecv: Request from host c3d80e15 code=4, id=3, length=49
NAS-IP-Address = 195.216.14.21
Acct-Status-Type = 8
Acct-Delay-Time = 0
Acct-Session-Id = "919991645"
Sending Accounting Ack of id 3 to c3d80e15 (testascend)
Resp Time: 0 Auth: 0/0 -> 0 Acct: 0/0/0 -> 1
radrecv: Request from host c3d80e15 code=33, id=1, length=32
NAS-IP-Address = 195.216.14.21
Received unknown attribute 150, vendor 0
Resp Time: 0 Auth: 0/0 -> 0 Acct: 0/0/0 -> 1
radrecv: Request from host c3d80e15 code=4, id=2, length=49
NAS-IP-Address = 195.216.14.21
Acct-Status-Type = 7
Acct-Delay-Time = 0
Acct-Session-Id = "919994245"
Sending Accounting Ack of id 2 to c3d80e15 (testascend)
Resp Time: 0 Auth: 0/0 -> 0 Acct: 0/0/0 -> 2
CLEANUP IN PROGRESS (2)....
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart