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 :)
ISYS Technology Inc.
Fingerprint: 6552 6469 5320 7475 6568 6c72 6e61 0a64
From: Kurt Schafer <firstname.lastname@example.org>
To: email@example.com <firstname.lastname@example.org>
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 !!
>From: Reid Sutherland <email@example.com>
>To: firstname.lastname@example.org <email@example.com>
>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
>>Not Found in ODBC, Checking users file...
>>ISYS Technology Inc.
>>Fingerprint: 6552 6469 5320 7475 6568 6c72 6e61 0a64