Make sure that the radius 'user' has proper permissions on the table or view.
Try running sqlTrace to see what is going on when radius tries to update
the ServerPorts table.
Jim
At 02:37 PM 11/10/1999 +0100, you wrote:
>I've tried to replace the CallsOnLine view with a table and I've got mopre
>problems :
> the update for the start packet works but don't for the stop packet....
>
>In fact, it's the same problem as the view but for all the entries...
>I don't understand it looks like a problem with the lock method on the
>database...
>We're using MS SQL 7 does anybody has tried to use radius with it ?
>
>thanks for help
>
>David
>----- Original Message -----
>From: Dale E. Reed Jr. <daler@iea-software.com>
>To: <radiusnt@iea-software.com>
>Sent: Tuesday, November 09, 1999 7:36 PM
>Subject: Re: [RadiusNT] CallsOnLine not correct ?
>
>
> > Dave wrote:
> > >
> > > I've checked my accounting timeouts, It is set to 15 seconds which is
> > > already important...
> > >
> > > I've looked to the informations given by radius -x15 and the accounting
>time
> > > for a stop packet (AcctStatusType=2) is between 100 and 300 ms during
>high
> > > charges.
> > > Another idea ?
> >
> > Check out the Manual Calls Update for you Stop Records Only Option.
> > Older RadiusNT versions use the CallsOnline view for this. If there
> > is something wrong with your CallsOnline view (like its not updateable,
> > because its a union) then you will have problems like this.
> >
> > cut/paste the "Update CallsOnline ..." statement from the -x15 debug and
> > run it in isql_w to see what it does. Does the port and IP address
> > exist?
> > Does it update any records?
> >
> >
> > --
> >
> > Dale E. Reed Jr. Emerald and RadiusNT
> > __________________________________________
> > IEA Software, Inc. www.iea-software.com
> >
> > For more information about this list (including removal) go to:
> > http://www.iea-software.com/support/maillists/liststart
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
----------------------------
hostmaster@interaxs.net
InterNet Access Network
18 McDaniel Street
Dayton, OH 45405-4816
Voice: 937-461-3660 Fax:937-228-2773
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart