i want to add new attributs

[Tim O'Donovan]

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 = "user at realm"
         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
>>
>>
> 
>