- Freeradius-Users - lists.freeradius.org

Command Authorization in freeradius
by ajay raut 14 Dec '07

14 Dec '07

Hi, I want to do a command authorization from a Freeradius server...like the way Tacacs+ have cmd-arg attribute specifies a specific commands the can be executed by a user. I am searching for the attribute in freeradius that can enable such kind of behaviour... Regards, Ajay --------------------------------- Never miss a thing. Make Yahoo your homepage.

3 2

Problem with authentication
by Pablo Lucchetti 14 Dec '07

14 Dec '07

Hi, I've a Freeradius on a Debian Etch with Mysql but when I'm triying to test with NTRadPing always got the same error. The user already exists in database rad_recv: Access-Request packet from host 192.168.1.109:4027, id=2, length=49 User-Name = "test-user" User-Password = "test-pass" rlm_sql (sql): Reserving sql socket id: 4 rlm_sql (sql): SQL query error; rejecting user rlm_sql (sql): Released sql socket id: 4 Sending Access-Reject of id 2 to 192.168.1.109 port 4027 Any help please? Thanks in advance, Pablo

3 14

Question about windowsXP(Odessey Client) + EAP-TLS with freeRADIUS
by Hangjun He 14 Dec '07

14 Dec '07

Hi, I am using freeRADIUS 1.1.6. And I use EAP-TLS and with correct certs. Even if I set wrong username in Odessey Client, freeRADIUS will return success.(check_cert_cn not set). Can I let freeRADIUS to check if username in the users file or other database? If not, reject user. Thanks! John --------------------------------- 天生购物狂，狂抢购物券，你还等什么！

4 4

sqlcounter, counting data and large amounts of it
by Russell Tester 13 Dec '07

13 Dec '07

Hi All, I am new to the freeradius list but have been running freeradius for some time. We are changing the way we do some of our accounting here and have a requirement to provide users with monthly prepaid cards for specific data values, namely 1,5 and 10GB. I have no problems making the pass timeout after the month, that bit is fine using the expiration check value. Where I am faced with a problem is telling the nas about (we use Mikrotik's) and counting above the hair pulling 4GB boundary. An example of my sqlcounter is below, this works perfectly fine anywhere up to 4GB, note that I run two of these one for up and one for downloaded data. Not 100% accurate in terms of the user could theoretically get the max amount of data up and down from their first session but accurate enough for us for now. I believe Mikrtoik v3 has a Total-Limit attribute which will fix this when its released. sqlcounter prepay-data-down { counter-name = Max-All-Session-Data check-name = Max-All-Data reply-name = Mikrotik-Recv-Limit sqlmod-inst = sql key = User-Name reset = never query = "SELECT SUM(AcctInputOctets) + SUM(AcctOutputOctets) FROM radacct WHERE UserName='%{%k}'" } Two problems exist with this setup: 1. When I specify a larger than 4GB value in radcheck I get an Access-Reject. 2. I have no way to send the equivalent gigawords attribute to the NAS as well, I believe I need to send both the Mikrotik-Recv-Limit and Mikrtoik-Recv-Limit-Gigawords values. I have spent some time playing myself and have managed to send the gigawords attribute by using another sqlcounter, and another radcheck attribute for gigawords, but get lost somewhere in the middle of checking both the gigawords and octets values against the radacct data and getting a sensible reply from them. The other question I have relates to the action the sqlcounter performs when the limit is reached. Is there any way to modify the reply attribute that gets passed to the nas when the limit is reached? Either by changing the reply message, or passing say a rate-limit value to the NAS to throttle the user. Any help to get this working, or examples of existing setups would be greatly appreciated. Cheers, Russell Tester

3 3

about Error: rlm_sql
by ann kok 13 Dec '07

13 Dec '07

Hi all As the debian upgrade, i also upgrade the freeradius version to from 1.0.2 to 1.1.3 in debian package the radius database is migrated to this new debian I use the NTRADping utiliy to tests the new freeradius login fine. When I put it in the production, the radius.log is showing Error: rlm_sql: Failed to create the pair: Unknown value Mysql for attribute Auth-Type and I can't see any "Auth: Login OK:" All are " Auth: Login incorrect" please help ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

2 1

attribute assignment in post-auth?
by Norbert Wegener 13 Dec '07

13 Dec '07

With 1.1.7 I want to add attributes to an eap authenticated client. The rules for applying vlan are somewhat unusual, that I decided to use mysql and stored procedures to determine the values that have to be applied. When I call the corresponding sql module from the authorize section, I run into the problem described at: https://lists.freeradius.org/pipermail/freeradius-users/2007-September/0663… to which Alan already answered: > Ideally, the attributes in the reply should be sent ONLY on >Access-Accept. i.e. the configuration should NOT update the reply until >it has determined that the user has been authenticated. > This involves moving most of the policy from the "authorize" section >to the "post-auth" section. That is why I want to call the stored procedure in the post-auth section. Therefore in sql.conf I set : postauth_query = "call speap ('%{SQL-User-Name}', '%{NAS-IP-Address}','2')" radiusd -AX shows , that procedure is called, ..... rlm_sql (sp1): Processing sql_postauth radius_xlat: 'host/28tef003.ww006.mycompany.net' rlm_sql (sp1): sql_set_user escaped user --> 'host/28tef003.ww006.mycompany.net' radius_xlat: 'call speap ('host/28tef003.ww006.mycompany.net', '172.31.110.146','2')' rlm_sql (sp1) in sql_postauth: query is call speap ('host/28tef003.ww006.mycompany.net', '172.31.110.146','2') rlm_sql (sp1): Reserving sql socket id: 28 rlm_sql_mysql: SQL statement returned unexpected result .. unfortunately with an unexpected result. When I call that stored procedure directly from mysql I get the expected result: mysql> call speap ('host/28tef003.ww006.mycompany.net', '172.31.110.146','2') +---+-----------------------------------+--------------+-----+----+ | 0 | s_username | Fall-Through | Yes | += | +---+-----------------------------------+--------------+-----+----+ | 0 | HOST/28tef003.ww006.mycompany.net | Fall-Through | Yes | += | +---+-----------------------------------+--------------+-----+----+ what I would expect. So, what is unexpected with that result? Norbert Wegener

2 2

sqlippool issue
by hadi golestani 13 Dec '07

13 Dec '07

Hi, I'm using freeradius to assign ip to my vpn clients. so I've configured sqlippool to bind ips to my users and groups. and in pptpd.conf I choose not to assign ip in pptpd. but connections to pptpd fails ( from win xp ) with error: no assigned ip. what's wrong in my configurations? my DB state: insert into radcheck ( username , attribute , op , value ) values ( 'newuser3' , 'Cleartext-Password' , ':=' , 'newpass3'); insert into usergroup (username , groupname ) values ( 'newuser3' , 'offpart1'); insert into radgroupcheck ( groupname , attribute , op , value ) values ('offpart1' , 'Pool-Name' , ':=' , '1515'); insert into radippool ( 'pool_name' , 'framedipaddress' ) values ('1515',' 10.15.15.3'); it's the output of debug mod: rad_recv: Access-Request packet from host 127.0.0.1:34045, id=149, length=148 Service-Type = Framed-User Framed-Protocol = PPP User-Name = "newuser3" MS-CHAP-Challenge = 0xc2af22b4941ad3a9f8ffba6ca9793eea MS-CHAP2-Response = 0x220069907d4b717d6e15a59053bead0f51900000000000000000283b13c9c3bd7f543ae7385f6b5749cb18330955aade9ea7 Calling-Station-Id = "xx.xx.xx.xx" NAS-IP-Address = 127.0.0.1 NAS-Port = 0 Processing the authorize section of radiusd.conf modcall: entering group authorize for request 8 modcall[authorize]: module "preprocess" returns ok for request 8 modcall[authorize]: module "chap" returns noop for request 8 rlm_mschap: Found MS-CHAP attributes. Setting 'Auth-Type = mschap' modcall[authorize]: module "mschap" returns ok for request 8 rlm_realm: No '@' in User-Name = "newuser3", looking up realm NULL rlm_realm: No such realm "NULL" modcall[authorize]: module "suffix" returns noop for request 8 rlm_eap: No EAP-Message, not doing EAP modcall[authorize]: module "eap" returns noop for request 8 users: Matched entry DEFAULT at line 173 users: Matched entry DEFAULT at line 185 modcall[authorize]: module "files" returns ok for request 8 radius_xlat: 'newuser3' rlm_sql (sql): sql_set_user escaped user --> 'newuser3' radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'newuser3' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 0 radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName, radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'newuser3' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radreply WHERE Username = 'newuser3' ORDER BY id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName, radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'newuser3' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql (sql): Released sql socket id: 0 modcall[authorize]: module "sql" returns ok for request 8 rlm_pap: Found existing Auth-Type, not changing it. modcall[authorize]: module "pap" returns noop for request 8 modcall: leaving group authorize (returns ok) for request 8 rad_check_password: Found Auth-Type MS-CHAP auth: type "MS-CHAP" Processing the authenticate section of radiusd.conf modcall: entering group MS-CHAP for request 8 rlm_mschap: Told to do MS-CHAPv2 for newuser3 with NT-Password rlm_mschap: adding MS-CHAPv2 MPPE keys modcall[authenticate]: module "mschap" returns ok for request 8 modcall: leaving group MS-CHAP (returns ok) for request 8 Processing the post-auth section of radiusd.conf modcall: entering group post-auth for request 8 rlm_sqlippool: Framed-IP-Address already exists modcall[post-auth]: module "sqlippool" returns noop for request 8 rlm_sql (sql): Processing sql_postauth radius_xlat: 'newuser3' rlm_sql (sql): sql_set_user escaped user --> 'newuser3' radius_xlat: 'INSERT into radpostauth (user, pass, reply, date) values ('newuser3', 'Chap-Password', 'Access-Accept', NOW())' rlm_sql (sql) in sql_postauth: query is INSERT into radpostauth (user, pass, reply, date) values ('newuser3', 'Chap-Password', 'Access-Accept', NOW()) rlm_sql (sql): Reserving sql socket id: 3 rlm_sql (sql): Released sql socket id: 3 modcall[post-auth]: module "sql" returns ok for request 8 modcall: leaving group post-auth (returns ok) for request 8 Sending Access-Accept of id 149 to 127.0.0.1 port 34045 Framed-IP-Address = 255.255.255.254 Framed-MTU = 576 Service-Type = Framed-User Framed-Protocol = PPP Framed-Compression = Van-Jacobson-TCP-IP MS-CHAP2-Success = 0x22533d36413732333834453141433843323544364432373245454244333734303038463238363630453439 MS-MPPE-Recv-Key = 0x0d42ffa8adfe8471a692876c86a6b26d MS-MPPE-Send-Key = 0x5110ed91d6d36bb4c9d44e2a0f6367e1 MS-MPPE-Encryption-Policy = 0x00000001 MS-MPPE-Encryption-Types = 0x00000006 Finished request 8 Going to the next request --- Walking the entire request list --- Waking up in 6 seconds... --- Walking the entire request list --- Cleaning up request 8 ID 149 with timestamp 4760fe8f Nothing to do. Sleeping until we see a request.

2 8

Re: Example listed in huntgroup file does not work
by Reynolds, Walter 13 Dec '07

13 Dec '07

I am looking at that option, but I should not have to. Per the huntgroups file: "# This file can also be used to define restricted access # to certain huntgroups. The second and following lines # define the access restrictions (based on username and # UNIX usergroup) for the huntgroup. #" So I can create a huntgroup with multiple Nas, but the 'second and following lines' are only recognized by the last entry in the huntgroup. So If I go with groups, I should be able to add the following: (can someone tell me if this is the write syntax, or do I still have to add something to the dictionary.... have to leave right now to catch a flight. Thanks) File radiusd.conf passwd etc_group { filename = /usr/local/ett/raddb/grouplist format = "=Group-Name:*,User-Name" hashsize = 50 ignorenislike = yes allowmultiplekeys = yes delimiter = ":" } ================= File /usr/local/etc/raddb/grouplist: datacenter:user1,user2,usera ================== File huntgroups: Limit1 NAS-IP-Address == 192.168.2.5 Limit1 NAS-IP-Address == 192.168.2.6 Group-Name == datacenter --- Walt Reynolds Principal Systems Security Development Engineer Information Technology Central Services University of Michigan (734) 615-9438 > > Message: 8 > Date: Thu, 13 Dec 2007 12:55:51 +0000 > From: A.L.M.Buxey(a)lboro.ac.uk > Subject: Re: Example listed in huntgroup file does not work > To: FreeRadius users mailing list > <freeradius-users(a)lists.freeradius.org> > Message-ID: <20071213125551.GA29697(a)lboro.ac.uk> > Content-Type: text/plain; charset=us-ascii > > Hi, > > > I should say that I do not want to use an external solution. > Creating a > > huntgroup for each NAS with the exact same user list does work, but > then > > if I have to change a user I would then have to modify what could be > > over 100 groups. > > i think, therein, lies your problem - you havent looked at the whole > logical design - and are fixated on the singular huntgroups file. > > if you want to control users, in groups, with huntgroups etc then > you should be using the huntgroup file to define NAS in groups, and > then another config file eg users to tie users to those huntgroups. > > alan > > > ------------------------------ > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > > End of Freeradius-Users Digest, Vol 32, Issue 37 > ************************************************

3 2

RE: Example listed in huntgroup file does not work
by Reynolds, Walter 13 Dec '07

13 Dec '07

> Message: 9 > Date: Wed, 12 Dec 2007 22:41:54 +0100 > From: <tnt(a)kalik.co.yu> > Subject: RE: Example listed in huntgroup file does not work > To: "FreeRadius users mailing list" > <freeradius-users(a)lists.freeradius.org> > Message-ID: <MmeHNnnk.1197495714.6796440.tnt(a)kalik.co.yu> > Content-Type: text/plain; charset=ISO-8859-2 > > >But I guess here is my problem. How do you assign more than one NAS > to > >a huntgroup? > > > The way it is shown in the huntgroups file. > I did, but the user list is not being recognized by more than one. How can I get that user list to be used for all NAS that are in that huntgroup? Or is this a bug? > >But this uses SQL which we are not using and would prefer not to. > > > Use LDAP then. Or feel free to list (same) users for every huntgroup > entry. I should say that I do not want to use an external solution. Creating a huntgroup for each NAS with the exact same user list does work, but then if I have to change a user I would then have to modify what could be over 100 groups. > > Ivan Kalik > Kalik Informatika ISP > > --- Walt Reynolds Principal Systems Security Development Engineer Information Technology Central Services University of Michigan (734) 615-9438

3 2

Need help to test EAP-MD5
by Nilanjan Sarkar 13 Dec '07

13 Dec '07

Hi Friends, I want to test radiusd with radeapclient. I am following from radeapclient man page, and using "./radeapclient -x localhost auth testing123 <req.txt". req.txt is like this, User-Name = "bob" EAP-MD5-Password = "hello" NAS-IP-Address = marajade.sandelman.ottawa.on.c EAP-Code = Response EAP-Id = 210 EAP-Type-Identity = "bob" Message-Authenticator = 0x00 NAS-Port = 0 But radeapclient is getting access-reject with Failure EAP-Code from radiusd (running like ./radiusd -X in another console). ============== +++> About to send encoded packet: User-Name = "bob" EAP-MD5-Password = "hello" NAS-IP-Address = 255.255.255.255 EAP-Code = Response EAP-Id = 210 EAP-Type-Identity = "bob" Message-Authenticator = 0x00 NAS-Port = 0 Sending Access-Request of id 116 to 127.0.0.1 port 1812 User-Name = "bob" NAS-IP-Address = 255.255.255.255 Message-Authenticator = 0x00000000000000000000000000000000 NAS-Port = 0 EAP-Message = 0x02d2000801626f62 rad_recv: Access-Challenge packet from host 127.0.0.1:1812, id=116, length=80 EAP-Message = 0x01d30016041066eb786fd424a0ee6f85a194ea8c9d30 Message-Authenticator = 0x323ec83f657e741fc131ba05f1bac39f State = 0xa3e884a46fc0e687c2bce84c917cc61e <+++ EAP decoded packet: EAP-Message = 0x01d30016041066eb786fd424a0ee6f85a194ea8c9d30 Message-Authenticator = 0x323ec83f657e741fc131ba05f1bac39f State = 0xa3e884a46fc0e687c2bce84c917cc61e EAP-Id = 211 EAP-Code = Request EAP-Type-MD5 = 0x1066eb786fd424a0ee6f85a194ea8c9d30 +++> About to send encoded packet: User-Name = "bob" EAP-MD5-Password = "hello" NAS-IP-Address = 255.255.255.255 EAP-Code = Response EAP-Id = 211 Message-Authenticator = 0x00000000000000000000000000000000 NAS-Port = 0 EAP-Type-MD5 = 0x108d31440ff81df18a9294cd9bd36bdce6 State = 0xa3e884a46fc0e687c2bce84c917cc61e Sending Access-Request of id 117 to 127.0.0.1 port 1812 User-Name = "bob" NAS-IP-Address = 255.255.255.255 Message-Authenticator = 0x00000000000000000000000000000000 NAS-Port = 0 State = 0xa3e884a46fc0e687c2bce84c917cc61e EAP-Message = 0x02d3001604108d31440ff81df18a9294cd9bd36bdce6 Re-sending Access-Request of id 117 to 127.0.0.1 port 1812 User-Name = "bob" EAP-MD5-Password = "hello" NAS-IP-Address = 255.255.255.255 EAP-Code = Response EAP-Id = 211 Message-Authenticator = 0x00000000000000000000000000000000 NAS-Port = 0 EAP-Type-MD5 = 0x108d31440ff81df18a9294cd9bd36bdce6 State = 0xa3e884a46fc0e687c2bce84c917cc61e EAP-Message = 0x02d3001604108d31440ff81df18a9294cd9bd36bdce6 rad_recv: Access-Reject packet from host 127.0.0.1:1812, id=117, length=44 EAP-Message = 0x04d30004 Message-Authenticator = 0x083613356791ba254aa786ddbb62d393 <+++ EAP decoded packet: EAP-Message = 0x04d30004 Message-Authenticator = 0x083613356791ba254aa786ddbb62d393 EAP-Id = 211 EAP-Code = Failure ============== I have added in radiusd.conf the following info eap { default_eap_type = md5 md5 { } ==================================== My queries are as following.. Do I need to add any md5 related attributes in server configuration? I have found in some file like digest-auth-MD5 "<>/freeradius-1.1.7/src/tests", but not sure how to inform radiusd server about this file. Also do not find any documentation about usage of "digest-auth-MD5". Any information/help regarding this is highly appreciated. Kind Regards, Nilanjan

3 6