(RADIATOR) time format is not written well in PostgreSQL

deden purnamahadi dedenph at hotmail.com
Thu Dec 18 03:49:04 CST 2003

The Configuration :


LogDir          /usr/local/src/Radiator-3.7/log
DbDir           .
#DbDir          /usr/local/srd/Radiator-3.7/raddb
Trace           4

# You will probably want to add other Clients to suit your site.
<Client x.x.x.x)>
#<Client DEFAULT>
        Secret  adaajah
        DupInterval 0

        AuthByPolicy    ContinueAlways
        RewriteUsername s/^([^@]+).*/$1/
#       AcctLogFileName %L/details

<AuthBy SQL>
#do the accounting but not authentication
        DBSource        dbi:Pg:dbname=radiator;host=x.x.x.x
        DBUsername      post
        DBAuth          post
        AccountingTable accounting
        AcctColumnDef   username,User-Name
        AcctColumnDef   time_stamp,Timestamp,formatted-date,to_date \
        ('%e %m %Y %H:%M:%S', 'DD MM YYYY HH:MI:SS')
        AcctColumnDef   acctstatustype,Acct-Status-Type
        AcctColumnDef   acctdelaytime,Acct-Delay-Time,integer
        AcctColumnDef   acctinputoctets,Acct-Input-Octets,integer
        AcctColumnDef   acctoutputoctets,Acct-Output-Octets,integer
        AcctColumnDef   acctsessionid,Acct-Session-Id
        AcctColumnDef   acctsessiontime,Acct-Session-Time,integer
        AcctColumnDef   acctterminatecause,Acct-Terminate-Cause
        AcctColumnDef   nasidentifier,NAS-Identifier
        AcctColumnDef   nasport,NAS-Port,integer
        AcctColumnDef   frameipaddress,Framed-IP-Address
        AcctColumnDef   userrequest,User-Request
        AcctFailedLogFileName %D/missedaccounting

Message when a call received :

Thu Dec 18 16:44:16 2003: DEBUG: Handling request with Handler 
Thu Dec 18 16:44:16 2003: DEBUG: Rewrote user name to user_a
Thu Dec 18 16:44:16 2003: DEBUG:  Adding session for dedenph,, 
Thu Dec 18 16:44:16 2003: DEBUG: Handling with Radius::AuthSQL
Thu Dec 18 16:44:16 2003: DEBUG: Handling accounting with Radius::AuthSQL
Thu Dec 18 16:44:16 2003: DEBUG: do query is: 'insert into accounting 
values (0,'030000B7','Start','',10,to_date ('18 12 2003 
16:44:16', 'DD MM YYYY HH:MI:SS'),'user_a')':

Problem :
Content in database for time stamp showing that the time is :  '18 12 2003 
So, it's not really put the real time.

What could be wrong ???


Warmest regards


Tired of spam? Get advanced junk mail protection with MSN 8. 

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.

More information about the radiator mailing list