I have tried altering the insert/update strings within sql.conf,
specifically by changing the %S variable to %{Timestamp} (and altering
the table definition to except an integer) but to no avail. It just
inserts a 0. I have searched the dictionary files for an attribute named
Timestamp but the only equivalent is Event-Timestamp.
Here's an example from the detail file:
Mon Oct 10 22:25:37 2005
User-Name = "[EMAIL PROTECTED]"
NAS-IP-Address = *
NAS-Port = 328
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-IP-Address = *
Proxy-State = 0x42543030326436336366643134
Acct-Status-Type = Start
Acct-Delay-Time = 0
Acct-Session-Id = "000151A7"
Acct-Authentic = RADIUS
NAS-Port-Type = Virtual
Client-IP-Address = *
Acct-Unique-Session-Id = "e74e5806dc266e0d"
Timestamp = 1128979537
So it is recognising the Timestamp attribute, as you suggested. Where am
I going wrong?
Kind regards,
Tim O'Donovan
Joe Maimon wrote:
Tim O'Donovan wrote:
Hi Harish,
I am trying to accomplish almost exactly the same thing on our
freeradius setup. Our NAS servers send us an additional attribute,
'Timestamp', in UNIX time, but at the moment our radius server is
ignoring it altogether.
We are using MySQL for accounting etc and the default setup logs
entries using the current time of insertion, not the time sent by the
NAS. We have a secondary radius server that is replicated by using
radrelay on the primary server which runs every minute or so. This is
the main problem as the time logged to the secondary server is
different to the primary.
You can do anything you would like with the SQL logging by editing the
sql.conf file, which contains the sql query strings the radius server uses.
I believe the solution involves editing the dictionary file (found in
raddb dir) to add the new attribute.
You would only need to do that if the server did not recognize the
attribute (translating it from a numerical id to a string name). If the
server logs the attribute into the detail file with the proper name or
the server prints its name in debugging mode, there is no need for that.
Although I am not 100% if that is
enough for it to come into effect. The standard attributes can be
found here: http://www.iana.org/assignments/radius-types.
When I find a complete solution I will let you know. :-)
Let me know how you get on.
Kind regards,
Tim O'Donovan
Harish Gupta wrote:
Hello All,
I m Harish Gupta from india, i m working in a Telecom & ISP company
as system Administator and I m using freeradius application on linux
platform(CentOS4.0) for my dialup users . its working fine, but i
want to add a new attribute like "caller-id and calling-id " how can
add these attributs plz. help me .
Thanx & Regards
Harish Gupta
System Aministrator
India
+919828032258
------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------
This email message is personal statement of the sender and shall not
be construed as statement of Shyam Telelink Limited. The contents of
this email and attached documents (if any) may contain confidential
and privileged material for the sole use of the intended recipient.
Any unauthorized review, dissemination, use or distribution by others
is strictly prohibited. If you have received the message in error,
please advise the sender by reply email and delete the message. The
recipient is also advised to get the statement confirmed in writing
from the company before acting on the contents of this email.
------------------------------------------------------------------------
- List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html