Re: DB problems, again.

Reid Sutherland ( (no email) )
Mon, 20 Jul 1998 17:00:51 -0400

Ahh, it's ok. I figured that one out pretty quick. Actually, the only thing
it checks the CustomerID field. So what I did was put 1 number in that


Then I went into my SubAccounts and put in the CustomerID field that same
number the whole way down.
So when Radius queries the database it just skips to the SubAccounts table.
Kinda a feature but most likely a bug :)

Thanks anyway Kurt :)

Reid Sutherland
Network Administrator
ISYS Technology Inc.
Fingerprint: 6552 6469 5320 7475 6568 6c72 6e61 0a64

-----Original Message-----
From: Kurt Schafer <>
To: <>
Date: Monday, July 20, 1998 2:18 PM
Subject: Re: DB problems, again.

>The only things being checked from MasterAccounts in that query you gave
>whether or not the account is active. The MasterAccounts table doesn't have
>any fields for login, password, shell, etc.
>Active = Active checkbox AND whether the account is expired in my
>BTW. (not just the active check box)
>- Kurt Schafer
>- Network Administrator
>- Cyber Beach Communications
>- BOO !!
>-----Original Message-----
>From: Reid Sutherland <>
>To: <>
>Date: Monday, July 20, 1998 12:10 PM
>Subject: DB problems, again.
>>In the documentation it states that MasterAccounts has pretty much nothing
>>to do with anything except for if the user is active or not. But I found
>>something fun today. MasterAccounts is checked for almost everything. In
>>other words, loginp, password, accounttype, and shell are all checked
>>Any reason for this not being in the docs?
>>If I removed these fields I had to create from the Masteraccounts, Radius
>>will not auth the user.
>>Here's a snipet I got from Radius in -x15 mode.
>> 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 From MasterAccounts ma, SubAccounts sa Where
>>or sa.Shell='fitzgewi') AND ma.CustomerID=sa.CustomerID and sa.Active<>0
>>ODBC Error:00000:1074927752:
>>Not Found in ODBC, Checking users file...
>>Reid Sutherland
>>Network Administrator
>>ISYS Technology Inc.
>>Fingerprint: 6552 6469 5320 7475 6568 6c72 6e61 0a64