Alan DeKok wrote:
Alexander Serkin <[EMAIL PROTECTED]> wrote:
I did not think radiusd rewrites unix timestamp into date.
Just because previous radius i was using used to put the timestamp into accounting as an integer.
Which I, for one, have a hard time understanding.
Does it mean that %S takes the timestamp from the Event-Timestamp field of the accounting packet?
No. It takes the time that the packet was received. The Event-Timestamp attribute MAY be a lie.
oops. When and why? Have not seen a lie from cisco NASes yet.
Hm. That's not a trick. And not good at all. %S takes time at which the request comes to radius.
Exactly. You can't trust the NAS.
It's a big surprise for me.
I've pushed a pack of accounting records to the radius with radrelay. When using %S i have a session as this one:
id: D4776040004F9475 start - 18-MAY-05 12.25.15, stop - 18-MAY-05 12.25.15
and actual values are:
id: D4776040004F9475 start: 18/05/2005 12:03:46, stop: 18/05/2005 12:07:34
does not seem like a valid "relay".
Since you're not going to explain why, I'm guessing it's not really a problem.
Why not. Just a small example: when subscriber requests packet data usage details we provide a list of his sessions with start-stop times and an amount of bytes in/out. What do you think he would say seing that he has downloaded 300Mbytes in one second while the maximum speed of his mobile terminal is up to 153kbit/s?
Another issue - police investigations. When department K requests who was online on 25 Dec 2001 00:00:00 whith the ip address 1.2.3.4 - how can we find this session if the data was pushed into database with wrong timing?
Now who can give me a hint of pushing Event-Timestamp like "May 18 2005 12:08:18 MSD" into oracle TIMESTAMP WITH TIME ZONE field?
Edit oraclesql.conf to use the query you want. That's why the queries are configurable.
Shure i will. I've seen them occasionally :-)
The question was to guys who may did the trick already. Because in Oracle
You can parse the string "May 18 2005 12:08:18 +0400" easily, but i've no idea what to do with timezone specified as MSD or something else.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Sincerely Yours, Alexander
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
