RE: Calls Online

Bruno Tremblay ( (no email) )
Fri, 22 May 1998 15:02:02 -0400

Radius V. 2.5.110

I change "usersname" to "username" and I still getting the same error.
Any idea ?
I don't want any times restrictions on ServerAccess do I set Start time to 0
and Stop time to 1440

Thank's

Bruno Tremblay

-----Original Message-----
From: radiusnt-request@iea-software.com
[mailto:radiusnt-request@iea-software.com] On Behalf Of Dale E. Reed Jr.
Sent: Friday, May 22, 1998 1:43 PM
To: radiusnt@iea-software.com
Subject: Re: Calls Online

Bruno Tremblay wrote:
>
> I have some problemes with my calls online.
> All Other things appear to work fine.
>
> SQL Statement: UPDATE CallsOnline Set Usersname='XXXppp',AcctStatusType=2,
> CallDate=Now(), FramedAddress='XXX.XXX.XXX.XXX' WHERE
> NASIdentifier='XXX.XXX.XXX.XXX' and NASPort=8 AND (DateADD('s',
> 0-i.AcctDelayTime, i.CallDate) >= CallDate or CallDate IS NULL)
>
> ODBC Error:07001:-3010:
> [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters.
> Expected 2.

This error means one of the fields listed above doesn't match a
field in the CallsOnline query. Actually, this looks like a bug
in RadiusNT 2.5, since it should be "username", not "usersname".
You could modify the query to have the column named usersname for
now until we can release a correction for it.

> If someone can say me which value I need to use in table ServerAccess,
> StartTime and StopTime. Each time I tried to use that service I got tha
> error in logs : Server:Vserver9 (XXX.XXX.XXX.XXX) Port:15 (Time)

They are minutes past midnight. SO if the customer can logn 8am to
5pm, it would be Start: 480 and Stop: 1020 (17*60). RadiusNT understands
that a start time larger than a stop time means wrap midnight. So
reversing the numbers would mean the user could login from 5pm to
8am.

--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