Re: [RadiusNT] ServerAccess still not working

skarim ( (no email) )
Tue, 29 Jun 1999 11:25:54 PDT

------------------------------------------------------------------------
This mail message contains standard MIME attachments. If you see this
note, your e-mail program does not support MIME. You may need a MIME-
compliant mail reader to read any non-text attachments in this message.
------------------------------------------------------------------------

--==IMail_v4.b1==
Content-Type: text/plain; charset=us-ascii

Debug file is as attachment

--==IMail_v4.b1==
Content-Type: text/plain; name="Debug.txt"
Content-Transfer-Encoding: binary

5) AllowMalformed: 0
6) AcctPort: 1646
7) Proxy: 0
8) Options: 839
9) Debug: 15
10) LogFile:
11) AcctLogFile:
12) ODBCDatasource: ISP
13) Username: sa
14) Password:
15) AcctODBCDatasource: ISP
16) AcctUsername: sa
17) AcctPassword:
18) DataDirectory:
19) AcctDirectory:
20) UsersFile: Users
21) CompanyName:
22) License:
23) IPAddress: All

Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: 'ISP'...
Making ODBC Connection...
MS SQL Server Mode Enabled
ODBC Datasource: 'ISP'...
Making ODBC Connection...
MS SQL Server Mode Enabled
C:\radius\Radius.exe: Invalid Database or Computer Date.
Invalid Database or Computer Date.

Allocating Statement...

SQL Statement: Select Name, RadAttributeID, Type From RadAttributes

SQL Statement: Select ra.Name, rv.Name, rv.Value From RadValues rv, RadA
es ra Where rv.RadAttributeID = ra.RadAttributeID

161 Dictionary Attributes Loaded...

SQL Statement: Select Server, IPAddress, Secret From Servers

3 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): 'StartTime'
Accounting Column 5 (16): 'CallDate'
Accounting Column 6 (32): 'UserName'
Accounting Column 7 (4): 'AcctDelayTime'
Accounting Column 8 (4): 'AcctSessionTime'
Accounting Column 9 (16): 'FramedAddress'
Accounting Column 10 (1): 'AcctTerminateCause'
11 Accounting Columns Loaded

RadiusNT Enterprise Initialized...

radrecv: Request from host d23803fe code=1, id=7, length=76
User-Name = "salman"
Password = "\2314\277\233W\362\235\200\235\020\360\215\236\207\253\30
NAS-Identifier = 210.56.3.254
NAS-Port = 11
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
rad_authenticate_ODBC()
Password = "\2314\277\233W\362\235\200\235\020\360\215\236\207\253\30

SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day, (ma.Exten
..OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), DateAdd(Day, sa.
on+1, saExpireDate)), sa.AccountID, sa.AccountType, sa.Password, sa.Login
ell, sa.TimeLeft, sa.LoginLimit From MasterAccounts ma, SubAccounts sa W
a.Login='salman' or sa.Shell='salman') AND ma.CustomerID=sa.CustomerID an
tive<>0 and ma.Active<>0

Decrypted Password: salman
Database Password: salman
Checking for duplicate logins.

SQL Statement: RadCheckOnline 'salman'

salman found on-line 0 time(s).
Checking for port access.

SQL Statement: RadCheckPort '210.56.3.254', 11, 'PPP'

SQL Statement: RadGetConfigs 1

Framed-Filter = mirconly (1788352085)
Sending Ack of id 7 to d23803fe (210.56.3.254)
Framed-Filter = "mirconly"
Session-Timeout = 1104120

Resp Time: 220 Auth: 1/0 -> 1 Acct: 0/0/0 -> 0
radrecv: Request from host d23803fe code=4, id=8, length=92
Acct-Session-Id = "C2000002"
User-Name = "salman"
NAS-Identifier = 210.56.3.254
NAS-Port = 11
NAS-Port-Type = Async
Acct-Status-Type = Start
Acct-Authentic = RADIUS
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 210.56.3.232
Acct-Delay-Time = 0

SQL Statement: UPDATE CallsOnline Set Username='salman',AcctStatusType=
Date=GetDate(), FramedAddress='210.56.3.232' WHERE NASIdentifier='210.56.
and NASPort=11 AND (DateAdd(Second, 0-1, GetDate()) >= CallDate OR
Date IS NULL)

Sending Accounting Ack of id 8 to d23803fe (210.56.3.254)

Resp Time: 110 Auth: 1/0 -> 1 Acct: 1/0/0 -> 1
radrecv: Request from host d23803fe code=4, id=9, length=116
Acct-Session-Id = "C2000002"
User-Name = "salman"
NAS-Identifier = 210.56.3.254
NAS-Port = 11
NAS-Port-Type = Async
Acct-Status-Type = Stop
Acct-Session-Time = 51
Acct-Authentic = RADIUS
Acct-Input-Octets = 325
Acct-Output-Octets = 244
Acct-Terminate-Cause = Lost-Carrier
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 210.56.3.232
Acct-Delay-Time = 0

SQL Statement: INSERT INTO Calls (CallDate,AcctSessionId,UserName,NASIde
,NASPort,AcctStatusType,AcctSessionTime,AcctTerminateCause,FramedAddress,
ayTime) VALUES (GetDate(),'C2000002','salman','210.56.3.254',11,2,51,2,'2
..232',0)

SQL Statement: UPDATE CallsOnline Set Username='salman',AcctStatusType=
Date=GetDate(), FramedAddress='210.56.3.232' WHERE NASIdentifier='210.56.
and NASPort=11 AND (DateAdd(Second, 0-2, GetDate()) >= CallDate OR
Date IS NULL)

Sending Accounting Ack of id 9 to d23803fe (210.56.3.254)

Resp Time: 190 Auth: 1/0 -> 1 Acct: 2/0/0 -> 2

--==IMail_v4.b1==--