One more question.. How to support these attributes ...Disc-Cause-Ext, PPP-Disconnect-Cause. Are they supported in freeradius version 1.1.6? Do i need to import any dictionary files if this version doesn't supports? PLease kindly give suggestions... Regards, Ramesh. On Thu, Jan 8, 2009 at 7:36 PM, ramesh p <rock786143@gmail.com> wrote:

Thank you.

On Thu, Jan 8, 2009 at 7:23 PM, <tnt@kalik.net> wrote:

...

...

How to start supporting Tunnel attributes for freeradius vers 1.1.6. Any document references??

No documentation. They are supported just like any other attribute.

...

Which will be the starting point for this. Do i need to change configuration of mysql.conf file? Or directly creating database helps?

Use them for what? Authentication? Just add them like any other attribute to user/group entry. Accounting? You will need to alter/extend radacct schema to log them there and edit accounting queries in sql.conf.

Ivan Kalik Kalik Informatika ISP

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

These are *Cisco*- *AVpair's. *Any suggestion how to add them to sql.conf and sql database. Any syntax references?? Thanks in Advance! Ramesh. On Fri, Jan 9, 2009 at 4:30 PM, <tnt@kalik.net> wrote:

...

How to support these attributes ...Disc-Cause-Ext, PPP-Disconnect-Cause. Are they supported in freeradius version 1.1.6?

Do i need to import any dictionary files if this version doesn't supports?

They look like vendor specific. Look in the vendor dictionary. Are those Cisco avpairs?

Ivan Kalik Kalik Informatika ISP

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

I understand this will be received like cisco-avpair=Disc-Cause-Ext=No Reason cisco-avpair=PPP-Disconnect-Cause=some cause. How to store in radacct table both Disc-Cause-Ext, PPP-Disconnect-Cause attributes individually?

Attribute => Cisco-AVPair Value => Disc-Cause-Ext = whatever Ivan Kalik Kalik Informatika ISP

I need to have both Disc-Cause-Ext, PPP-Disconnect-Cause as columns in radacct table. For that do i need to do parsing? How to proceed.

For parsing best use perl. You might want to add some attributes to raddb/dictionary and store parsed values there. And you will need to alter radacct table schema and accounting queries in dialup.conf. Ivan Kalik Kalik Informatika ISP

Yes. That's the general idea - create custom attributes; fill them with vaues from avpairs; alter radacct and queries to store new attributes. Ivan Kalik Kalik Informatika ISP Dana 19/1/2009, "ramesh p" <rock786143@gmail.com> piše:

Thanks. Is this digest helps for making changes? http://osdir.com/ml/gnu.radius.general/2003-04/msg00086.html Regards, Ramesh. On Mon, Jan 19, 2009 at 6:15 PM, <tnt@kalik.net> wrote:

...

...

I need to have both Disc-Cause-Ext, PPP-Disconnect-Cause as columns in radacct table. For that do i need to do parsing? How to proceed.

For parsing best use perl. You might want to add some attributes to raddb/dictionary and store parsed values there. And you will need to alter radacct table schema and accounting queries in dialup.conf.

Ivan Kalik Kalik Informatika ISP

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

am using freeradius-1.1.6 2009/1/19 ramesh p <rock786143@gmail.com>

One more question how to include the perl script for parsing. I haven't done this before. Please kindly give suggestions.

Thanks in advance! Ramesh.

2009/1/19 <tnt@kalik.net>

Yes. That's the general idea - create custom attributes; fill them with

...

vaues from avpairs; alter radacct and queries to store new attributes.

Ivan Kalik Kalik Informatika ISP

Dana 19/1/2009, "ramesh p" <rock786143@gmail.com> piše:

...

Thanks. Is this digest helps for making changes? http://osdir.com/ml/gnu.radius.general/2003-04/msg00086.html Regards, Ramesh. On Mon, Jan 19, 2009 at 6:15 PM, <tnt@kalik.net> wrote:

...

...

I need to have both Disc-Cause-Ext, PPP-Disconnect-Cause as columns in radacct table. For that do i need to do parsing? How to proceed.

For parsing best use perl. You might want to add some attributes to raddb/dictionary and store parsed values there. And you will need to alter radacct table schema and accounting queries in dialup.conf.

Ivan Kalik Kalik Informatika ISP

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Does freeradius.1.1.6 supoorts? which version of freeradius supports?? 2009/1/19 <tnt@kalik.net>

Upgrade. perl is experimental there.

Ivan Kalik Kalik Informatika iSP

Dana 19/1/2009, "ramesh p" <rock786143@gmail.com> piše:

...

am using freeradius-1.1.6

2009/1/19 ramesh p <rock786143@gmail.com>

...

One more question how to include the perl script for parsing. I haven't done this before. Please kindly give suggestions.

Thanks in advance! Ramesh.

2009/1/19 <tnt@kalik.net>

Yes. That's the general idea - create custom attributes; fill them with

...

vaues from avpairs; alter radacct and queries to store new attributes.

Ivan Kalik Kalik Informatika ISP

Dana 19/1/2009, "ramesh p" <rock786143@gmail.com> piše:

...

Thanks. Is this digest helps for making changes? http://osdir.com/ml/gnu.radius.general/2003-04/msg00086.html Regards, Ramesh. On Mon, Jan 19, 2009 at 6:15 PM, <tnt@kalik.net> wrote:

...

>I need to have both Disc-Cause-Ext, PPP-Disconnect-Cause as columns in >radacct table. For that do i need to do parsing? How to proceed.

For parsing best use perl. You might want to add some attributes to raddb/dictionary and store parsed values there. And you will need to alter radacct table schema and accounting queries in dialup.conf.

Ivan Kalik Kalik Informatika ISP

- 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

At present we are not recommended for upgrading. So is there any way to parse Cisco-AVpair attributes in sql.conf file itself? Regards, Ramesh. 2009/1/19 <tnt@kalik.net>

Upgrade to the latest version.

Ivan Kalik Kalik Informatika ISP

Dana 19/1/2009, "ramesh p" <rock786143@gmail.com> piše:

...

Does freeradius.1.1.6 supoorts? which version of freeradius supports??

2009/1/19 <tnt@kalik.net>

...

Upgrade. perl is experimental there.

Ivan Kalik Kalik Informatika iSP

Dana 19/1/2009, "ramesh p" <rock786143@gmail.com> piše:

...

am using freeradius-1.1.6

2009/1/19 ramesh p <rock786143@gmail.com>

...

One more question how to include the perl script for parsing. I haven't done this before. Please kindly give suggestions.

Thanks in advance! Ramesh.

2009/1/19 <tnt@kalik.net>

Yes. That's the general idea - create custom attributes; fill them with

...

vaues from avpairs; alter radacct and queries to store new attributes.

Ivan Kalik Kalik Informatika ISP

Dana 19/1/2009, "ramesh p" <rock786143@gmail.com> piše:

>Thanks. Is this digest helps for making changes? >http://osdir.com/ml/gnu.radius.general/2003-04/msg00086.html >Regards, >Ramesh. >On Mon, Jan 19, 2009 at 6:15 PM, <tnt@kalik.net> wrote: > >> >I need to have both Disc-Cause-Ext, PPP-Disconnect-Cause as columns in >> >radacct table. For that do i need to do parsing? How to proceed. >> >> For parsing best use perl. You might want to add some attributes to >> raddb/dictionary and store parsed values there. And you will need to >> alter radacct table schema and accounting queries in dialup.conf. >> >> Ivan Kalik >> Kalik Informatika ISP >> >> - >> 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

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

On Tue, Jan 20, 2009 at 8:31 AM, <tnt@kalik.net> wrote:

...

At present we are not recommended for upgrading.

I would really like to know who recommends that *new* installations should use outdated, insecure and buggy versions?

...

So is there any way to parse Cisco-AVpair attributes in sql.conf file itself?

No. But you can copy the perl module from freeradius wiki, add that to radiusd.conf as a module and hope for the best. Then copy example.pl to raddb directory (where radiusd.conf is) and modify it to suit you.

http://wiki.freeradius.org/Rlm_perl

By the way, what about cisco-vsa-hack? Quoting SQL HOWTO "If you have a Cisco nas, set the cisco-vsa-hack" How and where is this set? Regards Luciano

Configure perl module to use your script (raddb/modules/perl). Script should use sub acconting. List perl in accounting. Ivan Kalik Kalik Informatika ISP Dana 19/1/2009, "ramesh p" <rock786143@gmail.com> piše:

One more question how to include the perl script for parsing. I haven't done this before. Please kindly give suggestions.

Thanks in advance! Ramesh.

2009/1/19 <tnt@kalik.net>

...

Yes. That's the general idea - create custom attributes; fill them with vaues from avpairs; alter radacct and queries to store new attributes.

Ivan Kalik Kalik Informatika ISP

Dana 19/1/2009, "ramesh p" <rock786143@gmail.com> piše:

...

Thanks. Is this digest helps for making changes? http://osdir.com/ml/gnu.radius.general/2003-04/msg00086.html Regards, Ramesh. On Mon, Jan 19, 2009 at 6:15 PM, <tnt@kalik.net> wrote:

...

...

I need to have both Disc-Cause-Ext, PPP-Disconnect-Cause as columns in radacct table. For that do i need to do parsing? How to proceed.

For parsing best use perl. You might want to add some attributes to raddb/dictionary and store parsed values there. And you will need to alter radacct table schema and accounting queries in dialup.conf.

Ivan Kalik Kalik Informatika ISP

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html