Re: Going from Access to SQL...

Dale E. Reed Jr. ( (no email) )
Mon, 27 Apr 1998 13:54:30 -0700

hostmaster@interaxs.net wrote:
>
> At 01:11 PM 4/27/98 -0700, you wrote:
>
> >
> >Check two things. First Look at the maExpireDate, Extension, and Limit
> fields.
> >What are they and what do they total?
> maExpite and OverDue are NULL Extension is 0.

RadiusNT 2.2 doesn't support NULL in the maExpireDate field.

> >I would guess that your NAS is re-sending the accounting records. Check
> >the timeout on it. Also, you might want to isntall the trigger on your
>
> Where can I find the trigger?

See the following URL. Its in the list archives many times:

http://www.iea-software.com/lists/9711/emerald/00001441.htm

> >RadiusNT only responds to what the NAS sends. It can't tell the NAS
> >to re-sent the accounting records. :) What kind of NAS are you using
> >and what OS version? Those are a couple of important things you
> >didn't mention.
>
> PM3e 30 ComOs 3.7.2
>
> The problem is not ocurring when I use the Access db. No multiple acks are
> sent. This only ocurrs with sql and 2.5.1. How could it be the NAS?

Are you using 2.5 with the Access Database? I'm guessing that you don't
have something setup correctly in the SQL Server database, then. I'd
need the -x15 debug of it to help solve the problem.

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com