[RadiusNT] SQL, Radius problems

Gene Burch ( (no email) )
Wed, 28 Jul 1999 14:10:32 EDT

Hello,

I have been working with this for the past few days, and I seem to be making
some progress, but I really can't tell to be honest.

Whenever I run Radius Debug, I get this

RadiusNT 2.5.178 Copyright (c) 1995-1998 IEA Software, Inc.
All Rights Reserved, Worldwide

Some portions Copyright (c) 1992 Livingston Enterprises, Inc.
and Copyright (c) 1995 Ascend Communications, Inc.

0) Mode: 4
1) IgnoreCase: 0
2) ReqAcctAuth: 1
3) AllowMalformed: 0
4) TrimName: 0
5) Proxy: 0
6) Options: 0
7) SNMP: 0
8) Debug: 15
9) LogFile: D:\Logs\RadLog.log
10) AcctLogFile: D:\Logs\RadACC.log
11) ODBCDatasource: Emerald
12) Username: sa
13) Password:
14) AcctODBCDatasource: Emerald
15) AcctUsername: sa
16) AcctPassword:
17) TestDatabaseSecs: 30
18) DataDirectory: C:\program files\emerald
19) AcctDirectory: C:\program files\emerald
20) UsersFile: Users
21) CompanyName: aaark computers
22) License: 639162000567263500053225
23) IPAddress: 208.44.22.2
24) AuthPort: 1645
25) AcctPort: 1646

Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: 'Emerald'...
Making ODBC Connection...
MS SQL Server Mode Enabled

SQL Statement: Select DISTINCT Company, LicenseID From Licenses

SQL Statement: Select DISTINCT Company, LiscenseID From Liscenses

ODBC Datasource: 'Emerald'...
Making ODBC Connection...
MS SQL Server Mode Enabled

SQL Statement: Select DISTINCT Company, LicenseID From Licenses

SQL Statement: Select DISTINCT Company, LiscenseID From Liscenses

Licensed MBRs: 500
Allocating Statement...

SQL Statement: Select Name, RadAttributeID, Type, RadVendorID, RadVendorType
Fr
om RadAttributes Order By RadVendorID, RadAttributeID

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

286 Dictionary Attributes Loaded...

SQL Statement: Select Server, IPAddress, Secret From Servers

2 Clients Loaded
Accounting Column 0 (16): 'AcctSessionID'
Accounting Column 1 (16): 'NASIdentifier'
Accounting Column 2 (1): 'AcctStatusType'
Accounting Column 3 (4): 'NASPort'
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 (4): 'AcctInputOctets'
Accounting Column 10 (4): 'AcctOutputOctets'
Accounting Column 11 (1): 'AcctTerminateCause'
Accounting Column 12 (1): 'NASPortType'
Accounting Column 13 (10): 'NASPortDNIS'
Accounting Column 14 (15): 'CallerID'
Accounting Column 15 (32): 'ConnectInfo'
Accounting Column 16 (4): 'ServerID'
Accounting Column 17 (4): 'AccountID'
Accounting Column 18 (1): 'Status'
19 Accounting Columns Loaded

Loading users...
User:gburch
User:root
User:test
3 users loaded!

Enterprise features enabled.

RadiusNT 2.5.178 (Emerald Standard) Initialized...

radrecv: Request from host d02c1603 code=1, id=1, length=58
User-Name = "gburch"
Password = "\343\247\350\276$Y9\306\312\302S\217\243\026\322\342"
NAS-Identifier = 208.44.22.3
NAS-Port = 2
rad_authenticate_ODBC()

SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day,
(ma.Extension+ma
..OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), DateAdd(Day,
sa.Extensi
on+1, saExpireDate)), sa.AccountID, sa.AccountType, sa.Password, sa.Login,
sa.Sh
ell, ma.Balance, ma.OverLimit From MasterAccounts ma, SubAccounts sa Where
sa.L
ogin='gburch' AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and
ma.Active<>0

SQL Statement: RadGetConfigs 2

SQL Statement: RadGetATConfigs 'PPP'

Sending Ack of id 1 to d02c1603 (pluto)
User-Service = Framed-User
Framed-Protocol = PPP
Resp Time: 47 Auth: 1/0 -> 1 Acct: 0/0/0 -> 0

Can someone give me a hand, or at least point me in the right direction? Our
deadline to be online is Monday, so any help is very, very appriciated.

_______________________________________________________________
Get Free Email and Do More On The Web. Visit http://www.msn.com

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart