SQL Statement: Select DateAdd(Day, ma.extension, maExpireDate), DateAdd(Day, sa
..extension, saExpireDate), sa.AccountID, sa.AccountType, sa.Password, sa.Login,
sa.Shell From MasterAccounts ma, SubAccounts sa Where (sa.Login='myname'
or sa.Sh
ell='myname') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and
ma.Active<>0
Database Password: WINNT\MYDOMAIN
Freeing SQL Statement...
LOG: User: myname Not found
User: myname Not found
Sending Reject of id 1 to ac11015f (myterminal.mycompany.co.jp)
Response Time: 125
----------------- To Here ----------------------------------------
I changed Password data on above list.
If I did 'radlogin abc xyz' from my terminal, I got followings:
--------------- From here -----------------------------
ODBC: SQLFetch Error:100: (00000)
Freeing SQL Statement...
LOG: User: abc Not found
User: abc Not found
----------------- To Here ----------------------------------------
Login ID 'abc' is not stored on Master and Sub Accounts database.
First example seems to me that Radius NT could find LoginID 'myname'
on the database because it shows the password I put into the database.
But RadiusNT says 'User: myname Not found'.
Could someone advice me what should I do next.
P.S.
Is there any detailed documents regarding database layout?
I studied Version 2.1 document(Word format) but it is not enough
to me. For example, I do not understand the meaning of 'saCurrent'
on the SubAccounts table.
Thanks.
Toshio Kasai