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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Reply via email to