(RADIATOR) Problem with Timestamp and DateFormat

[Herman verschooten]

Hi,

I seem to be having a problem with the way time is handled in
Radiator... My Calls-table is a remnant of an earlier
RadiusNT-installation, and has a CallDate-field which is a
datetime-value.  My online-table uses a numeric field to contain the
timestamp.  I assumed that adding 1/1/1970 to this timestamp would give
me the same datetime as the one inserted in the calls table.  But that
does not seem to be right, the datetime is adjusted to my timezone, but
the other timestamp seems to be GMT is this true or have I made a
mistake somewhere?

Tx,

Herman

Relevant pieces of my config-file.

<Handler>
 AcctLogFileName %L/%Y%m%d.log
 AuthByPolicy  ContinueWhileAccept
 SessionDatabase ADSL
 <AuthBy SQL>
  DBSource dbi:ODBC:xxx
  DBUsername xxxxxx
  DBAuth  xxxxxxx
#  Accounting
  DateFormat  %b %e, %Y %H:%M:%S
  AccountingTable Calls
  AcctColumnDef NASIdentifier,NAS-Identifier
  AcctColumnDef NASIdentifier,NAS-IP-Address
  AcctColumnDef NASPort,NAS-Port,integer
  AcctColumnDef AcctSessionId,Acct-Session-Id
  AcctColumnDef AcctStatusType,Acct-Status-Type,integer
  AcctColumnDef CallDate,Timestamp,integer-date
  AcctColumnDef UserName,User-Name
  AcctColumnDef AcctDelayTime,Acct-Delay-Time,integer
  AcctColumnDef AcctSessionTime,Acct-Session-Time,integer
  AcctColumnDef FramedAddress,Framed-IP-Address
  AcctColumnDef AcctTerminateCause,Acct-Terminate-Cause,integer
  AcctColumnDef ConnectInfo,Connect-Info,string
  AcctColumnDef CallerID,Calling-Station-Id,string
  AcctColumnDef AcctInputOctets,Acct-Input-Octets,integer
  AcctColumnDef AcctOutputOctets,Acct-Output-Octets,integer
  AcctColumnDef AcctInputOctets,RB-Acct-Input-Octets-64,integer
  AcctColumnDef AcctOutputOctets,RB-Acct-Output-Octets-64,integer
 </AuthBy>
</Handler>

<SessionDatabase SQL>
 Identifier ADSL
 DBSource dbi:ODBC:xxx
 DBUsername xxxxxxx
 DBAuth   xxxxxxx
 AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT,
ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE,
CALLERID, INPUTOCTETS, OUTPUTOCTETS, SESSIONTIME)    values ('%n','%N',
0%{NAS-Port}, '%{Acct-Session-Id}', %{Timestamp},
'%{Framed-IP-Address}', '%{NAS-Port-Type}','%{Service-Type}',
'%{Calling-Station-Id}',0%{Acct-Input-Octets},0%{Acct-Output-Octets},0%{
Acct-Session-Time})
</SessionDatabase>

--
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.