(RADIATOR) LogQuery

Hugh Irvine hugh at open.com.au
Mon Apr 22 17:38:53 CDT 2002


Hello Rolando -

I don't quite understand what you are showing below.

The Unix timestamp is available directly as %{Timestamp} - it just needs to 
be inserted into an integer column.

regards

Hugh


On Tue, 23 Apr 2002 06:41, Rolando Riley wrote:
> I have been searching thru the mailing list a solution to make loggings on
> RADLOG with this format TIME_STAMP
>
> <Log SQL>
>          DBSource        dbi:mysql:radius:localhost
>          DBUsername      myuser
>          DBAuth          mypass
>        LogQuery    insert into %3 (TIME_STAMP, PRIORITY, MESSAGE)\
>        values ('%m/%d/%Y %H:%M:%S', %0, %2)
>             Trace 3
> </Log>
>
>
> This is not working on my Radiator 3.0 .     Bellow is the SQL output when
> I query it.
>
>   4  3 Server started: Radiator 3.0 on dns.ayayai.com
>   4  3 Connecting to 200.24.128.3, port 389
>   4  3 Attempting to bind with cn=admin, dc=ayayai, dc=com, copycat (server
> xx.xx.xx.xx:xxxx)
>   4  2 SIGTERM received: stopping
>
>
> 	I am thinking to use a function that convert seconds TIME_STAMP to a unix
> TIME_STAMP from a perl cgi if I don't get this working. Anybody know a perl
> function that does this?
>
>
> cheers,
>
>
> -----------------------------------
> Ing. Rolando Riley
> Gerente de Sistemas
> AYAYAI.COM S.A.
> Tel: (507) 265-2424 ext. 408
> -----------------------------------
>
> ===
> 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.


More information about the radiator mailing list