Re: i want to add new attributs
"Tim O'Donovan" <[EMAIL PROTECTED]> wrote: > I didn't know radrelay could do that. This may sound strange, but does > it do this automatically without any intervention, or does it need to be > set manually? The reason I ask is that the logged AcctStartTime and > AcctStopTime differs (by up to 2mins) on the secondary radius server. It should do it automatically. See the documentation. As for why the logged times are different, see the RADIUS packets. You know the times in the DB are wrong, so see if the times in the RADIUS packets are correct. Maybe the system times on the two systems aren't in sync. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: i want to add new attributs
Thanks Alan. >> That's why radrelay sets Acct-Delay-Time, so that the timestamp of >> the original request can be calculated as "received packet time - >> Acct-Delay-Time" I didn't know radrelay could do that. This may sound strange, but does it do this automatically without any intervention, or does it need to be set manually? The reason I ask is that the logged AcctStartTime and AcctStopTime differs (by up to 2mins) on the secondary radius server. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: i want to add new attributs
"Tim O'Donovan" <[EMAIL PROTECTED]> wrote: > Mon Oct 10 22:25:37 2005 ... > Timestamp = 1128979537 > > So it is recognising the Timestamp attribute, as you suggested. Where am > I going wrong? The "Timestamp" entry is not a real attribute. It is added by the "detail" module when the record gets printed. > >> 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. The NAS is *not* sending the Timestamp. > >> 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. In normal systems, the time of insertion *is* when the packet was received. > >> 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. That's why radrelay sets Acct-Delay-Time, so that the timestamp of the original request can be calculated as "received packet time - Acct-Delay-Time" Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: i want to add new attributs
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
Re: i want to add new attributs
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
Re: i want to add new attributs
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. I believe the solution involves editing the dictionary file (found in raddb dir) to add the new attribute. 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