Going from Access to SQL...

hostmaster@interaxs.net
Mon, 27 Apr 1998 15:40:25 -0400

I have created a db in sql and I used the upgrade to sql wizard in Access
to export the necessary tables to the sql db. I have created a view in sql
for CallsOnline. Everything in the structure and inter-relationship of the
db seems to be ok.

I have been running radius in debug. No errors showing up.

When I use RadiusNT 2.2.41 it will not authenticate me. It keeps telling me
that my account has expired. I have made every change conceivable to
saexpiredate, maexpiredate, and the active fields in both tables. It still
tells me that my account has expired. (It can't, I own the damned thing :) ).

So upgrade to RadiusNT 2.5.1 (Which I removed from the production box
yesterday due to 4 freezes yesterday--another story). Now, I can get
authenticated. Everything looks good, for about 30 seconds. Then it UPDATES
the calls table again, and again, and again, about every 30 seconds you are
online. When you logoff, it updates the calls table with a stop record and
then another start record. This leaves the ServerPorts table believing that
you are still online!

I then sent only Stop records. Then the same situation acurred with the
Update to CallsOnline, with the last update, after you logged off, saying
that you are still online.

I have read and reread the debug window. There is no indication there of
why it is sending so many accounting acks for the start record and only one
for the stop record.

This is driving me nuts... can anybody offer some advice?

Jim
----------------------------
hostmaster@interaxs.net
InterNet Access Network
18 McDaniel Street
Dayton, OH 45405-4816
Voice: 937-461-3660 Fax:937-228-2773