Re: [RadiusNT] Not saving NASIdentifier

Mike Kovacich ( (no email) )
Mon, 01 May 2000 05:25:55 -0400

My NASIdentifier & OutputOctets are not being saved in Calls. I see
them both in the accounting stop record in the debug window as
NAS-Identifier and Output-Octets. I do not see them listed among all the
other fields from calls when debug mode is 1st started. I was gettting
NASIdentifier for the 1st day but haven't for a few weeks now. Today,
while attempting to get to identify and resolve no NASIdentifier I am
now now saving OutputOctets.

I have compacted and repaired the database with same results. Besides
what I have done renaming a few attributes so data from two different
NAS's gets stored in the same field in Calls. This was working just fine
unitl. . . Any ideas would be great.

Mike Kovacich wrote:

> Thank you Danny, that cleared up the lookup date issue. Now to get
> ServerPorts working with Manual Calls Update or send stop record only
> option in the Radius Admin GUI, I get this error.
>
> SQL Statement: UPDATE Servers AS s, ServerPorts AS sp
> SETAcctStatusType=2,UserName='lambie',FramedAddress='216
> .94.224.70',CallDate='2000-04-30 11:25:39' FROM Servers s, ServerPorts
> sp WHERE sp.ServerID = s.ServerID AND s
> .IPAddress='216.94.224.3' and sp.Port=0 AND (DateAdd('s', 0-0,
> '2000-04-30 11:25:39') >= sp.CallDate OR sp.Cal
> lDate IS NULL)
> ODBC Error [37000] -3503:[Microsoft][ODBC Microsoft Access 97 Driver]
> Syntax error in UPDATE statement. [UPDAT
> E Servers AS s, ServerPorts AS sp
> SETAcctStatusType=2,UserName='lambie',FramedAddress='216.94.224.70',CallDate
>
> ='2000-04-30 11:25:39' FROM Servers s, ServerPorts sp WHERE
> sp.ServerID = s.ServerID AND s.IPAddress='216.94.2
> 24.3' and sp.Port=0 AND (DateAdd('s', 0-0, '2000-04-30 11:25:39') >=
> sp.CallDate OR sp.CallDate IS NULL) ]
> Sending Accounting Ack of id 29 to d85ee003 (NAS-GAND)
>
>
> Danny Sinang wrote:
>
>> Assuming your datestart and dateend are of type Date, then your date
>> values should be surrounded by the # character. Your SQL Statement
>> would then look like this : sql="SELECT Sum([AcctSessionTime]) AS
>> [SumDuration] FROM [calls] WHERE UserName='"_
>> & username & "' AND CallDate >= #" & datestart & "# AND
>> callDate <= #" &_
>> dateend & "#"
>
>> - Danny Sinang
>
> --
> Mike Kovacich
> System Administrator
> sysadmin@inter-pc.com
>
> Inter-PC Internet Services
> WarpLink Communications
> http://www.inter-pc.com
>

--Mike KovacichSystem Administratorsysadmin@inter-pc.com

Inter-PC Internet ServicesWarpLink Communicationshttp://www.inter-pc.com





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