Re: Calls Online

Dale E. Reed Jr. ( (no email) )
Fri, 22 May 1998 10:43:00 -0700

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