FW: Problems with Rads

Fox, Thomas ( (no email) )
Fri, 1 May 1998 14:01:57 -0400

Dale-

I'm still unable to determine why my clients who have static
IP's aren't receiving them. I've compared our production database
to the sample, and all of the field names, etc. match. Can you
please offer some guidance?

User olgar should be receiving ip 209.176.106.220, but is being
assigned from the pool

Here is the pertinent information:

0) EncryptPasswords: 0
1) IgnoreCase: 1
2) ReqAcctAuth: 0
3) Mode: 2
4) Options: 67
5) Debug: 7
6) ODBCDatasource: Radius
7) DataDirectory: c:\radius
8) AcctDirectory: c:\radius\acct
9) UsersFile: users
10) Username:
11) Password:
12) CompanyName:
13) License:
14) Proxy: 0
15) TrimName: 0
16) LogFile:
17) AcctODBCDatasource:
18) AcctUsername:
19) AcctPassword:

radrecv: Request from host d1b06ae9 code=1, id=128, length=72 User-Name =
"olgar"
Password = "\026\375\345\354:xm\330\216\346)q\304\371\221\206"
NAS-Identifier = 209.176.106.233
NAS-Port = 3
NAS-Port-Type = ISDN-V120
NAS-Port-DNIS = "3841375"
rad_authenticate_ODBC() Password =
"\026\375\345\354:xm\330\216\346)q\304\371\221\206"

SQL Statement: Select DateDiff('n', Now, DateAdd('d', ma.Extension+1,
maExpireDate)), DateDiff('n', Now, DateAdd('d', ma.Extension+1, maExpireDate)),
sa.AccountID, sa.AccountType, sa.Password, sa.Login, sa.Shell, sa.LoginLimit
>From MasterAccounts ma, SubAccounts sa Where (sa.Login='olgar' or
sa.Shell='olgar') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and
ma.Active<>0

Decrypted Password: <passwrd here>
Database Password: <passwrd here>
Checking for duplicate logins.

SQL Statement: Select Count(Username) From ServerPorts Where Username='olgar'
and AcctStatusType=1

olgar found on-line 0 time(s).

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type,
rc.RadVendorID, rc.RadVendorType, rc.RadCheck From RadConfigs rc, RadAttributes
ra Where ra.RadAttributeID=rc.RadAttributeID AND rc.AccountID=26

CHECK Framed-Address = 209.176.106.220 (0)
CHECK Idle-Timeout = 600 (600)
Loading radius defaults for this type...

SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type,
rc.RadVendorID, rc.RadVendorType, rc.RadCheck From RadATConfigs rc,
RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND
rc.AccountType='PPP'

Framed-Protocol = PPP (1)
User-Service = Framed-User (2)
Session-Timeout = 14400 (14400)
Framed-Compression = Frames-Compression (1)
Idle-Timeout = 600 (600)
Sending Ack of id 128 to d1b06ae9 (portmaster3.foxberry.com) Framed-Protocol
= PPP
User-Service = Framed-User
Session-Timeout = 14400
Framed-Compression = Van-Jacobsen-TCP-IP
Idle-Timeout = 600