[RadiusNT] RadiusNT Setup ODBC...

Robert Hipp ( rhipp@oc-net.com )
Sat, 23 Jan 1999 09:14:39 -0800

Hope someone can give me some clues. We are currently using version 1.16
(ok stop laughing) and installing 2.5124 using ODBC (MS SQL) on a new
machine. We ran the sql scripts to create the tables, using mixed security
set up a user and gave it full permissions to all the tables, setup Radius
Admin and configured it using this account for DSN and ran the verify. It
seems that we can log in ok but calls on-line and calls table never get
updated. Looking in past posts it seems a trigger issue. I re-ran
insttrig.sql, same results. When we disconnect the dial up a record is
written to RadLogs table. When ran using -x15 the following is what is
generated at login:

radrecv: Request from host cf68ee02 code=1, id=4, length=71
User-Name = "testing"
Password = "\257\254>\213_<+\004\214\031\221z\273\302\247\025"
NAS-Identifier = 207.104.238.2
NAS-Port = 1
User-Service = Framed-User
Framed-Protocol = PPP
rad_authenticate_ODBC()
Password = "\257\254>\213_<+\004\214\031\221z\273\302\247\025"

SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day,
(ma.Extension+ma
..OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), DateAdd(Day,
sa.Extensi
on+1, saExpireDate)), sa.AccountID, sa.AccountType, sa.Password, sa.Login,
sa.Sh
ell, sa.LoginLimit From MasterAccounts ma, SubAccounts sa Where
(sa.Login='test
ing' or sa.Shell='testing') AND ma.CustomerID=sa.CustomerID and
sa.Active<>0 and
ma.Active<>0

Decrypted Password: 123456
Database Password: 123456
Checking for duplicate logins.

SQL Statement: RadCheckOnline 'testing'

testing found on-line 0 time(s).

SQL Statement: RadGetConfigs 273

Loading radius defaults for this type...

SQL Statement: RadGetATConfigs 'PPP'

User-Service = 2 (2)
Framed-Protocol = 1 (1)
Framed-Address = 255.255.255.254 (1)
Framed-Netmask = 255.255.255.255 (1)
Framed-Compression = 1 (1)
Sending Ack of id 4 to cf68ee02 (pserv)
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 255.255.255.254
Framed-Netmask = 255.255.255.255
Framed-Compression = Van-Jacobsen-TCP-IP

Resp Time: 461 Auth: 2/1 -> 3 Acct: 0/0/0 -> 0

That seems ok. Then disconnect:

radrecv: Request from host cf68ee02 code=1, id=7, length=59
User-Name = "testing"
Password = "\371\235\261!Y\322\245\026a=O\211\224Lm\364"
NAS-Identifier = 207.104.238.2
NAS-Port = 1
rad_authenticate_ODBC()
Password = "\371\235\261!Y\322\245\026a=O\211\224Lm\364"

SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day,
(ma.Extension+ma
..OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), DateAdd(Day,
sa.Extensi
on+1, saExpireDate)), sa.AccountID, sa.AccountType, sa.Password, sa.Login,
sa.Sh
ell, sa.LoginLimit From MasterAccounts ma, SubAccounts sa Where
(sa.Login='test
ing' or sa.Shell='testing') AND ma.CustomerID=sa.CustomerID and
sa.Active<>0 and
ma.Active<>0

Decrypted Password:
Database Password: 123456
Sending Reject of id 7 to cf68ee02 (pserv)

SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data)
VALUE
S (11, GetDate(), 'testing', '')

User: testing Bad Password

User: testing Bad Password

Resp Time: 290 Auth: 2/2 -> 4 Acct: 0/0/0 -> 0

Any Ideas?

Thanks

Robert Hipp

For more information about this list, including removal, please
see this URL: http://www.iea-software.com/maillist.html