>If you use localserver, you need to make sure the database (click
>options
>when editing the DSN) has "Emerald" specified. Else you might be on the
>master database (or whatever the default is for the user, which isn't
>specified, unless you cleared it out) that doesn't have the Emerald
>database tables, etc.
>
Yep I did not have it pointed to the right place.
>> D:\radius>radius -x15 -o
>>=20
>> 0) EncryptPasswords: 0
>> 1) IgnoreCase: 1
>> 2) AuthPort: 1645
>> 3) ReqAcctAuth: 0
>> 4) AcctPort: 1646
>> 5) Mode: 1
>> 6) Options: 101
>> 7) Debug: 15
>> 8) ODBCDatasource: LocalServer
>> 9) DataDirectory: d:\mssql\data
>> 10) AcctDirectory: d:\mssql\data
>
>these should be c:\radius and c:\radius\acct, NOT d:\mssql\data
>
Didn't think this mattered in ODBC but I changed it anyway.
One last question all is well now but it is not auth my test
guy.....once I get that going I should be up and running....saying the
user is not found...yes I double checked that he is in there....double
checked that the local machine was in the server list and that the
user was active...any ideas from below debug
-------------------------------------------------------------------------=
----------
radrecv: Request from host cef2c90f code=3D1, id=3D1, length=3D0
NAS-Identifier =3D 127.0.0.1
NAS-Port =3D 0
User-Name =3D "test"
Password =3D "pv\274\312\350\304\345\037\374\033\254\345p`J\231"
rad_authenticate_ODBC()
Password =3D "pv\274\312\350\304\345\037\374\033\254\345p`J\231"
Decrypted Password: [=F7N+=98+M=F1+2sZy7+=BC
Allocating Statement...
SQL Statement: Select DateAdd(Day, ma.extension, maExpireDate),
DateAdd(Day, sa
..extension, saExpireDate), sa.AccountID, sa.AccountType, sa.Password,
sa.Login,
sa.Shell, sa.TimeLeft, sa.LoginLimit From MasterAccounts ma,
SubAccounts sa Wher
e (sa.Login=3D'test' or sa.Shell=3D'test') AND =
ma.CustomerID=3Dsa.CustomerID
and sa.Ac
tive<>0 and ma.Active<>0
Database Password: testuser
=46reeing SQL Statement...
LOG: User: test Not found
User: test Not found
Sending Reject of id 1 to cef2c90f (radac.interconnect.net)
Response Time: 40