Re: [RadiusNT] CallsOnline and Radius 3.X

Tom Long ( tlong@lakesnet.net )
Wed, 19 Apr 2000 08:24:52 -0500

I am using Radius 3.0 and Platypus and they tell me because I am using a
3rd party piece of software (tsmon) that I cannot get call online. TSMON
monitors usage and kicks people off that are idle or if they have been on
for a certain amount of time and the modems are busy and tracks modem
usage. Has anyone heard of this, is there a call online with radiusnt?

Thanks

At 04:01 PM 3/24/00, you wrote:
>Is it simply a MSAccess should not be used for radiusnt 3.0 or do you think
>there might be a fix for it.??
>
>
>
>
>Date sent: Fri, 24 Mar 2000 09:22:44 -0800 (Pacific Standard Time)
>From: Peter Deacon <peterd@iea-software.com>
>To: radiusnt@iea-software.com
>Subject: Re: [RadiusNT] CallsOnline and Radius 3.X
>Send reply to: radiusnt@iea-software.com
>
>> On Thu, 23 Mar 2000, James B. Hrdy wrote:
>>
>> > Running RadiusNT 3.0.163
>> > I am getting an update error on or with callsonline.
>> > Debug output will be at the bottom of the page.
>> > My question is will this work with an access database ?
>> > The SETUsername statement looks like it may make the ODBC driver choke.
>> > Just wondering if SET username would work better. MSAccess sometimes
>> > gets a little bummed about not using spaces.
>>
>> This is a bug :( I'd chat w/ support about getting a patch for this one.
>>
>> > SQL Statement:
>> > UPDATE Servers AS s,
>> > ServerPorts AS sp
>> > SETUserName='jgray',AcctStatusType=1,FramedAddress='63.68.34.153',Call
>> > Date='2000-03-23 12:37:5'
>> > FROM Servers s,
>> > ServerPorts sp
>> > WHERE sp.ServerID = s.ServerID
>> > AND s.IPAddress='208.247.48.22'
>> > and sp.Port=11267 AND (DateAdd('s', 0-0, '2000-03-23 12:37:5') >=
>> > sp.CallDate OR sp.CallDate IS NULL)
>>
>> > ODBC Error [37000]
>> > -3503:[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in
>> > UPDATE statement.
>> > [UPDATE Servers AS s, ServerPorts AS sp
>> > SETUserName='jgray',AcctStatusType=1,FramedAddress='63.68.34.153',Call
>> > Date='2000-03-23 12:37:5'
>> > FROM Servers s, ServerPorts sp
>> > WHERE sp.ServerID = s.ServerID
>> > AND s.IPAddress='208.247.48.22'
>> > and sp.Port=11267
>> > AND (DateAdd('s', 0-0, '2000-03-23 12:37:5') >= sp.CallDate
>> > OR sp.CallDate IS NULL) ]
>> > Sending Accounting Ack of id 40 to d0f73016 (max-tnt)
>>
>> Have Fun!
>> Peter
>>
>>
>> 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

Tom Long
Communications Supervisor 1025 Roosevelt Avenue

City of Detroit Lakes Detroit Lakes, MN 56501

tlong@lakesnet.net Telephone: 218-846-7142

www.detroitlakes.org Fax: 708-810-3445

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart