(RADIATOR) interger-date does not seem to work

Hugh Irvine hugh at open.com.au
Wed Jan 14 15:27:49 CST 2004


Hello Michel -

Have you specified a "DateFormat" and the correct column type in the 
database for DATETIME?

See sections 6.3 and 6.28.14 in the Radiator 3.8 reference manual 
("doc/ref.html").

If you still have problems please send me a copy of your configuration 
file (no secrets) together with a trace 4 debug from Radiator showing 
what is happening.

regards

Hugh


On 15 Jan 2004, at 07:28, Michel Merle - PacWan wrote:

> I have a mysql accounting table, with a specific datetime field after 
> the regular ones.
>
> my conf is as follows :
>
>                 AccountingTable ACCOUNTING
>                 AcctColumnDef   USERNAME,User-Name
>                 AcctColumnDef   TIME_STAMP,Timestamp,integer
>                 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   NASPORTTYPE,NAS-Port-Type
>                 AcctColumnDef   NASIPADDRESS,Nas-IP-Address
>                 AcctColumnDef   FRAMEDIPADDRESS,Framed-IP-Address
>                 AcctColumnDef   CALLINGSTATIONID,Calling-Station-Id
>                 AcctColumnDef   CALLEDSTATIONID,Called-Station-Id
>                 AcctColumnDef   DATETIME,Timestamp,integer-date
>                 AcctFailedLogFileName   %D/missedaccounting
>         </AuthBy>
>
> this should put the date and time right into my sql record, but 
> unfortunately it stays empty :0000-00-00 00:00:00
>
> Any idea ?
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.

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