(RADIATOR) Using AcctSQLStatement with integer-date format

[Hugh Irvine]

Hello Vangelis -

I would be inclined to have Radiator simply store the values and do any 
calculations in your post-processing.

regards

Hugh


On Wednesday, Jan 22, 2003, at 19:42 Australia/Melbourne, Vangelis 
Kyriakakis wrote:

> Hello Hugh,
>
>     I'm trying to calculate %{Timestamp} - %{Acct-Session-Time} in 
> order to
> get the Connect Time from the STOP packet.
>
>                 thanks
>                    Vangelis
>
> Hugh Irvine wrote:
>
>> Hello Vangelis -
>>
>> Could you explain to me what you are trying to do? In other words, 
>> what
>> value are you trying to calculate?
>>
>> thanks
>>
>> Hugh
>>
>> On Monday, Jan 20, 2003, at 23:29 Australia/Melbourne, Vangelis
>> Kyriakakis wrote:
>>
>>> Hi again,
>>>
>>> I'm trying to use something like
>>>
>>> AcctColumnDef CONNECTTIME,%b-0%{Acct-Session-Time},integer-date
>>>
>>> but it doesn't work. It gives a NULL value for the CONNECTTIME
>>> attribute.
>>> I have also tried AcctColumnDef
>>> CONNECTTIME,%{Timestamp}-0%{Acct-Session-Time},integer-date
>>>
>>> If I write AcctColumnDef CONNECTTIME,Timestamp,integer-date it works,
>>> but
>>> ofcourse it's not what I want.
>>> I want to use this attribute with Sybase Datetime type
>>>
>>>              Regards
>>>                   Vangelis
>>>
>>> Hugh Irvine wrote:
>>>
>>>> Hello Vangelis -
>>>>
>>>> You should use AcctColumnDef's for what you show below.
>>>>
>>>> See section 6.28.14 in the Radiator 3.5 reference manual.
>>>>
>>>> regards
>>>>
>>>> Hugh
>>>>
>>>> On Saturday, Jan 18, 2003, at 02:55 Australia/Melbourne, Vangelis
>>>> Kyriakakis wrote:
>>>>
>>>>> Hello,
>>>>>
>>>>>      I want to write the following AcctSQLStatement:
>>>>>
>>>>> AcctSQLStatement insert into TABLE (LOGIN_TIME, LOGOUT_TIME,.....)
>>>>> values
>>>>> (%{Timestamp}-%{Acct-Session-Time}Formatted using integer-date and
>>>>> (%Y%m%d %H:%M) Format,%{Timestamp}Formatted using integer-date and
>>>>> (%Y%m%d %H:%M) Format,.......)
>>>>>
>>>>>      How should I write the above SQL query? I have read the manual
>>>>> but
>>>>> I cannot figure out the exact format of the query.
>>>>>
>>>>>              Regards
>>>>>                  Vangelis
>>>>>
>>>>> ===
>>>>> Archive at http://www.open.com.au/archives/radiator/
>>>>> Announcements on radiator-announce at open.com.au
>>>>> To unsubscribe, email 'majordomo at open.com.au' with
>>>>> 'unsubscribe radiator' in the body of the message.
>>>>>
>>>>>
>>>>
>>>> --
>>>> Radiator: the most portable, flexible and configurable RADIUS server
>>>> anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
>>>> -
>>>> Nets: internetwork inventory and management - graphical, extensible,
>>>> flexible with hardware, software, platform and database 
>>>> independence.
>>>
>>> ===
>>> Archive at http://www.open.com.au/archives/radiator/
>>> Announcements on radiator-announce at open.com.au
>>> To unsubscribe, email 'majordomo at open.com.au' with
>>> 'unsubscribe radiator' in the body of the message.
>>>
>>>
>>
>> --
>> Radiator: the most portable, flexible and configurable RADIUS server
>> anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
>> -
>> Nets: internetwork inventory and management - graphical, extensible,
>> flexible with hardware, software, platform and database independence.
>>
>> ===
>> Archive at http://www.open.com.au/archives/radiator/
>> Announcements on radiator-announce at open.com.au
>> To unsubscribe, email 'majordomo at open.com.au' with
>> 'unsubscribe radiator' in the body of the message.
>
>

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.