RadiusNT 2.5.110 Copyright (c) 1995-1997 IEA Software, Inc.
All Rights Reserved, Worldwide
Some portions Copyright (c) 1992 Livingston Enterprises, Inc.
and Copyright (c) 1995 Ascend Communications, Inc.
0) IgnoreCase: 0
1) TrimName: 1
2) AuthPort: 1645
3) ReqAcctAuth: 0
4) AllowMalformed: 1
5) AcctPort: 1646
6) Mode: 1
7) Proxy: 0
8) Options: 67
9) Debug: 5
10) LogFile:
11) AcctLogFile:
12) ODBCDatasource: Radius
13) Username: raduser
14) Password: TheP0nd
15) AcctODBCDatasource:
16) AcctUsername:
17) AcctPassword:
18) DataDirectory:
19) AcctDirectory:
20) UsersFile: Users
21) CompanyName:
22) License:
23) IPAddress: All
Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: 'Radius'...
Making ODBC Connection...
MS SQL Server Mode Enabled
ODBC Datasource: 'Radius'...
Making ODBC Connection...
MS SQL Server Mode Enabled
Allocating Statement...
SQL Statement: Select Name, RadAttributeID, Type From RadAttributes
SQL Statement: Select ra.Name, rv.Name, rv.Value From RadValues rv,
RadAttribut
es ra Where rv.RadAttributeID = ra.RadAttributeID
123 Dictionary Attributes Loaded...
SQL Statement: Select Server, IPAddress, Secret From Servers
2 Clients Loaded
Accounting Column 0 (16): 'NASIdentifier'
Accounting Column 1 (4): 'NASPort'
Accounting Column 2 (10): 'AcctSessionID'
Accounting Column 3 (1): 'AcctStatusType'
Accounting Column 4 (16): 'CallDate'
Accounting Column 5 (32): 'UserName'
Accounting Column 6 (4): 'AcctDelayTime'
Accounting Column 7 (4): 'AcctSessionTime'
Accounting Column 8 (16): 'FramedAddress'
Accounting Column 9 (1): 'AcctTerminateCause'
10 Accounting Columns Loaded
RadiusNT Standard Initialized...
radrecv: Request from host c7d95d03 code=4, id=211, length=55
NAS-Identifier = 127.0.0.1
NAS-Port = 0
User-Name = "gent"
Acct-Session-Id = "416209211"
Acct-Status-Type = Start
SQL Statement: INSERT INTO Calls
(CallDate,NASIdentifier,NASPort,UserName,AcctSessionId,AcctStatusType) VALUES
(GetDate(),'127.0.0.1',0,'gent','416209211',1)
SQL Statement: UPDATE CallsOnline Set Username='gent',AcctStatusType=1,
CallDa
te=GetDate(), FramedAddress=NULL WHERE NASIdentifier='127.0.0.1' and
NASPort=0
AND (DateAdd(Second, 0-i.AcctDelayTime, i.CallDate) >= CallDate OR
CallD
ate IS NULL)
ODBC Error:37000:107:
[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'i' does
not m
atch with a table name or alias name used in the query.
Sending Accounting Ack of id 211 to c7d95d03 (tidepool)
Resp Time: 40 Auth: 0/0 -> 0 Acct: 1/0/0 -> 1
Mike Gent <gent@pond.net> Phone: (541) 302-1295
Network Systems Administrator Fax: (541) 302-1298
Pacific Crest Interactive (http://www.pond.net)