July 2005 - Freeradius-Users - lists.freeradius.org

RE: authenticate machine accounts with ntlm_auth
by martin.p.bradley＠bt.com 01 Aug '05

01 Aug '05

>> j.cluzel wrote: >> Is it possible to authenticate a machine account with ntlm_auth ? >No. AD does not permit that. > Alan DeKok. I'm very frustrated now after spending a couple of weeks trying to get free radius to authenticate my Win2k machine accounts against active directory. :-( Alan, do you know of any way to get this working. I have been assured that Funk can do this, have you any idea how Funk are doing it. Funk costs too much. Maybe I'm not allowed to ask such questions. Regards, Martin.

5 5

Cisco WAP 1200 Accounting for 802.1X PEAP
by Colleen Morrissey 01 Aug '05

01 Aug '05

I am having difficulty getting my Cisco APs (all 1230s) to send accounting information regarding 802.1x PEAP authentications - stop/start info. Does anyone have this working? If so can you please post the AP config. I currently have the following: aaa accounting network eap_methods start-stop group rad_acct I get radius accounting information for exec on the APs (people logging directly into the AP), but not for wireless authentications. So I know I have the radius server and config setup correctly. Thanks Colleen

2 1

Authenticate as computer - Windows XP
by israel＠topazio.com 01 Aug '05

01 Aug '05

Hi, In IAS we do a policy that contain: host/*.teste.com How I can do this in Freeradius for authenticate computer account, striping the computer name for search in OpenLdap. Thanks

2 1

Computer Authentication problem
by israel＠topazio.com 01 Aug '05

01 Aug '05

Hi, I have Samba with backend for password's OpenLDAP. I want to know if there is a way to work with realm configuration based on "host/fqdn", example: host/israel.teste.com Conform example, I do search in OpenLdap based in username "uid", that is "israel". If somebody can help me, I will very thanks. Thanks.

2 1

newbie questions using freeradius as wifi access point
by Will Carter 30 Jul '05

30 Jul '05

Hi, First, sorry for the long post... I am new to radius in general and freeradius and am attempting to set up a credit card based wifi access point where you can buy time to surf the internet for certain alotments of time. The configuration should kick them off when their alloted paid for time expires and redirect them to a web page so that they can buy more time. I have some questions the progress we have made and would very much appreciate any information anyone could provide. I apologize for any ignorance or assumptions about how the set up would work, as I am just fumbling through. I have set up freeradius on a linux server and I have it successfully talking to a mySQL database that has radcheck, radreply, radacct tables, etc. I am able to use the natradping utility to get accept/reject messages from it based on entries in radcheck. I have a NAS device (nomadix ag-2000w) that I can get it to correctly recognize a wireless laptop and authenticate against entries in the radius database. I am sending a session-timeout attribute in my reply message and my nas is correctly coming up with an expiration time based on that. Basically my process is like this. Login: 1. I have a separate database from radius that authenticates the user's login/password. I delete all rows from from radcheck for this user. I delete all rows from radreply for this user. I add back a radcheck record and radreply session-timeout record that corresponds to how much time left that they have paid for. Now I log them in (using an xml command to my nas). My nas correctly reports the expire time based on the session-timeout that I inserted. After the user is logged in, I add another row to radcheck that is an auth-type reject. This is so that when the nas time expires and it tries to reauthenticate with radius, it will get a reject message and not allow surfing to continue. I believe this is the wrong way to be doing things and I think radacct is the table for this but I do not understand how that table fits in or if the nas device is supposed to be inserting into radacct or what. My question here is that should I be using radacct in some way to influence the reject/accept response when the session times out for the user. By the way, if the user tries to login again, they wont be hit with the auth-type reject in their response because I am clearing out radcheck and radreply first. User is trying to add time: I update my non-radius database with how much time they have purchased. I log the user out of my nas device (using an xml command). I delete everything from radcheck and radreply for this user. I add back a radcheck record for this user. I add a session-timout record to radreply for this user that corresponds to how much additional time they just purchased. I log the user back in, resyncing the nas with the session-timeout in radius. After they are logged in again I add back a auth-type reject to radcheck so that when their time runs out again they will be kicked off. The underlying problem with this set up is that the order of the logout/login/insert reject into radcheck bits seem not to happen in order. I am issuing xml commands to my nas to do the login/logout. So sometimes it seems that the logout happens after the login xml command or the login happens after the reject row is inserted, effectively blocking the user incorrectly. Basically, I would like some advice as to where I am going wrong in the process and what is the correct way that radacct comes into play. I have my nas set up to have accounting enabled and I see radacct getting written to but I don't understand how AcctStartTime, AcctStopTime comes into play although that looks interesting. Any guidance here would be great. Thanks for any info or direction you can provide. -will

3 26

Proxim AP-700 AcctUniqueId
by Uwe Driessen 29 Jul '05

29 Jul '05

Hello i have a Problem with the Proxim AP700 to get a Unique Session ID or AcctUniqueId There only MAC Authentication. Has anyone Experience with the AP-700. To avoidance that more than one record for a session in the radacct-table i have made Username and AcctUniqueID Unique. The Problem is that the AP-700 deliver only this Information : As rad_recv: Access-Request packet from host 192.168.0.232:6001, id=9, length=125 User-Name = "001195-0942e8" User-Password = "secret" NAS-IP-Address = 192.168.0.232 Called-Station-Id = "00-20-a6-56-38-ff:wireless-people-AP002" Calling-Station-Id = "00-11-95-09-42-e8" NAS-Port = 0 Processing the authorize section of radiusd.conf There missing the Framed-IP-Adress and the Acctsession-ID is the MAC from the Calling Station with this Information the Unique session Id is alway for this User the same and after a separation the Radius write in the same record. So i get 1 record per User and Month but only for the latest session. I hope you can help me. Sorry for this long posting and my english As Start from the AP comes User-Name = "000f3d-47ba87" Acct-Session-Id = "000f3d-47ba87" NAS-Identifier = "Wireless-People-AP001" NAS-IP-Address = 192.168.0.231 NAS-Port = 2 NAS-Port-Type = Wireless-802.11 Acct-Authentic = RADIUS Acct-Status-Type = Start Acct-Input-Octets = 0 Acct-Output-Octets = 0 Acct-Session-Time = 0 Acct-Input-Packets = 0 Acct-Output-Packets = 0 Acct-Terminate-Cause = 0 Acct-Delay-Time = 0 As Alive comes User-Name = "001195-0a21d8" Acct-Session-Id = "001195-0a21d8" NAS-Identifier = "Wireless-People-AP001" NAS-IP-Address = 192.168.0.231 NAS-Port = 2 NAS-Port-Type = Wireless-802.11 Acct-Authentic = RADIUS Acct-Status-Type = Alive Acct-Input-Octets = 0 Acct-Output-Octets = 0 Acct-Session-Time = 608 Acct-Input-Packets = 0 Acct-Output-Packets = 0 Acct-Terminate-Cause = 999 Acct-Delay-Time = 0 With this Information the freeradius don't create a UniqueSessionId, so i think i make the unique by mysql with this statement: accounting_start_query = "select @sesid := MD5(Concat(count(*),'%{Calling-Station-Id}', '%{NAS-IP-Address}',now())) FROM ${acct_table1};INSERT into ${acct_table1}(AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime,AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId,CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('%{Acct-Session-Id}', @sesid, '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', '0', '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '%{Acct-Delay-Time}', '0')" In MySQL the Statement with filled values is write a correct record, from FreeRadius i get fail, the same Statement in MySQL brings OK and the data insert in the Table. I not see what is wrong rlm_sql (sql): sql_set_user escaped user --> '001195-0942e8' radius_xlat: 'select @sesid := MD5(Concat(count(*),'', '192.168.0.232',now())) FROM radacct;INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime,AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('001195-0942e8', @sesid, '001195-0942e8', '', '192.168.0.232', '2', 'Wireless-802.11', '2005-07-26 02:03:20', '0', '0', 'RADIUS', '', '', '0', '0', '', '', '', '', '', '', '0', '0')' radius_xlat: '/var/log/freeradius/sqltrace.sql' rlm_sql (sql): Reserving sql socket id: 5 rlm_sql_mysql: query: select @sesid := MD5(Concat(count(*),'', '192.168.0.232',now())) FROM radacct;INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime,AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('001195-0942e8', @sesid, '001195-0942e8', '', '192.168.0.232', '2', 'Wireless-802.11', '2005-07-26 02:03:20', '0', '0', 'RADIUS', '', '', '0', '0', '', '', '', '', '', '', '0', '0') rlm_sql_mysql: MYSQL check_error: 1064 received rlm_sql (sql): Couldn't insert SQL accounting START record - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Rea radius_xlat: 'select @sesid := AcctUniqueId, @matime :=max(AcctStartTime) from radacct Where UserName = '001195-0942e8' and AcctStopTime ='0' group by UserName;UPDATE radacct SET AcctStartTime = '2005-07-26 02:03:20', AcctStartDelay = '0', ConnectInfo_start = '' WHERE AcctUniqueId = @sesid AND UserName = '001195-0942e8' AND NASIPAddress = '192.168.0.232'' To filter what is the correct record for this user i made this statement. It is testet with MySQL and OK and the same problem when it comes from radius. accounting_update_query = "select @sesid := AcctUniqueId, @matime :=max(AcctStartTime) from ${acct_table1} Where UserName = '%{SQL-User-Name}' and `AcctStopTime` ='0' group by UserName;UPDATE ${acct_table1} SET FramedIPAddress = '%{Framed-IP-Address}',lastupd = '%S', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress= '%{NAS-IP-Address}'" Mit freundlichen Grüßen Drießen Es liegt was in der Luft www.feilbingert.net Uwe Drießen Software & Computer

2 3

Problems with Simultaneous-Use
by jck-freeradius＠southwestern.edu 29 Jul '05

29 Jul '05

Hello, I am having problems with Simultaneous-Use and checkrad. I know that checkrad is not running because: grep debug /usr/local/sbin/checkrad # Config: $debug is the file you want to put debug messages in #$debug = ""; $debug = "$logdir/checkrad.log"; and: -- tail -F /var/log/radius/checkrad.log Fri Jul 29 12:57:30 2005 checkrad Usage: checkrad nas_type nas_ip nas_port login session_id -- (nothing new is showing up in the checkrad log file, except for when I run it by hand) I have both the Perl SNMP modules installed, along with NET-SNMP (and the correct syntax for NET used in the checkrad script, even though it should be using the perl modules first). I am able to manually use snmpwalk /fine/. Here is how my SQL table looks: mysql> select * from radgroupcheck; +----+------------+------------------+----+-------+ | id | GroupName | Attribute | op | Value | +----+------------+------------------+----+-------+ | 1 | pirate | Simultaneous-Use | := | 2 | | 2 | pirate-stu | Simultaneous-Use | := | 2 | | 3 | pirate-stf | Simultaneous-Use | := | 2 | | 4 | pirate-fac | Simultaneous-Use | := | 2 | | 5 | pirate-its | Simultaneous-Use | := | 1 | +----+------------+------------------+----+-------+ Here are the related sections from my radiusd.conf file: radutmp { # Where the file is stored. It's not a log file, # so it doesn't need rotating. # filename = ${logdir}/radutmp # The field in the packet to key on for the # 'user' name, If you have other fields which you want # to use to key on to control Simultaneous-Use, # then you can use them here. # # Note, however, that the size of the field in the # 'utmp' data structure is small, around 32 # characters, so that will limit the possible choices # of keys. # # You may want instead: %{Stripped-User-Name:-%{User-Name}} username = %{User-Name} # Whether or not we want to treat "user" the same # as "USER", or "User". Some systems have problems # with case sensitivity, so this should be set to # 'no' to enable the comparisons of the key attribute # to be case insensitive. # case_sensitive = yes # Accounting information may be lost, so the user MAY # have logged off of the NAS, but we haven't noticed. # If so, we can verify this information with the NAS, # # If we want to believe the 'utmp' file, then this # configuration entry can be set to 'no'. # check_with_nas = yes # Set the file permissions, as the contents of this file # are usually private. perm = 0600 # callerid = "yes" } # # For Simultaneous-Use tracking. # # Due to packet losses in the network, the data here # may be incorrect. There is little we can do about it. radutmp # sradutmp # # Log traffic to an SQL database. # # See "Accounting queries" in sql.conf sql # Session database, used for checking Simultaneous-Use. Either the radutmp # or rlm_sql module can handle this. # The rlm_sql module is *much* faster session { #radutmp # # See "Simultaneous Use Checking Querie" in sql.conf sql } And here is my sql.conf file: # Simultaneous Use Checking Queries ####################################################################### # simul_count_query - query for the number of current connections # - If this is not defined, no simultaneouls use checking # - will be performed by this module instance # simul_verify_query - query to return details of current connections for verification # - Leave blank or commented out to disable verification step # - Note that the returned field order should not be changed. ####################################################################### # Uncomment simul_count_query to enable simultaneous use checking simul_count_query = "SELECT COUNT(*) FROM ${acct_table1} WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0" simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName, NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, FramedProtocol FROM ${acct_table1} WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0" Here is how my radacct table looks: mysql> select * from radacct order by RadAcctId desc limit 1; +-----------+---------------+------------------+----------+-------+---------------+-----------+-----------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+--------------------+-------------+----------------+-----------------+----------------+---------------+ | RadAcctId | AcctSessionId | AcctUniqueId | UserName | Realm | NASIPAddress | NASPortId | NASPortType | AcctStartTime | AcctStopTime | AcctSessionTime | AcctAuthentic | ConnectInfo_start | ConnectInfo_stop | AcctInputOctets | AcctOutputOctets | CalledStationId | CallingStationId | AcctTerminateCause | ServiceType | FramedProtocol | FramedIPAddress | AcctStartDelay | AcctStopDelay | +-----------+---------------+------------------+----------+-------+---------------+-----------+-----------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+--------------------+-------------+----------------+-----------------+----------------+---------------+ | 281 | 0000019F | c91763dbcdfe02cb | johnk | | 192.168.0.49 | 558 | Wireless-802.11 | 2005-07-29 15:03:06 | 0000-00-00 00:00:00 | 0 | RADIUS | | | 0 | 0 | 0014.691e.e9c0 | 000e.35b5.eb8f | | Framed-User | | | 0 | 0 | +-----------+---------------+------------------+----------+-------+---------------+-----------+-----------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+-----------------+------------------+--------------- hecate:/etc/raddb # tail naspasswd # WARNING: Always make sure that this file has the "-r------" permission. # And, don't set the passwords on your other systems to the same # passwords that can be found below. # # #203.172.90.118 !root TufFseCrET #203.172.42.152 !root ToTaLCnTl 192.168.0.49 hecate:/etc/raddb # grep 192.168 -A 3 clients.conf client 192.168.0.49 { secret = xXxXxXxX shortname = Aironet1100-johnk nastype = cisco The proper accounting configuration lines have been included in my Cisco AP conf. My username is part of the pirate-its group; 1 connection allowed. What I find interesting is that if I connect once: radwho Login Name What TTY When From Location johnk John Koen shell S534 Fri 14:57 192.168.0 ...then if I open a second connection (from another machine, at the same time as the first connection): radwho Login Name What TTY When From Location johnk John Koen shell S535 Fri 14:58 192.168.0 Notice that radutmp seems to forget about the first connection, and only remember the newest (connection number 2) connection. On this 2nd connection attempt I should be Rejected instead of Accepted. I see nothing in the checkrad log of checkrad running. What else can I try? --johnk

1 0

Limiting the number of connections
by Jose Divino de Lima 29 Jul '05

29 Jul '05

Hi people, I need your help. We´ve a solution that use SER athenticating, athotizing and accounting in a freeRadius+mySQL. I´ve a challenge now to limit thu number of simultaneous connections (i.e: we can permit only ten connections at the same time). Does anybody has any idea to implement this in freeRadius+mySQL ? I imagine that i need to change the sql queries in sql.conf, but i´m not sure.. Any ideas ? Tks, Lima

2 1

Freeradius + AP + Access Point Client
by ManyX 29 Jul '05

29 Jul '05

How can I authenticate my access point CLIENT to AP in freeradius ?? In my network I have EAP/TLS authenticate and everything go well when I authenticate users with windows xp and WLAN cart, but one of my user have a access point client and this is a problem becouse I dont now how can I configure my freeradius. I need tell my access point that this access point client is authenticate to let in. The best soluton will be check ip and mac of access point client. how can I do that?? thank a lot many(a)poczta.fm

2 3

RE: adding user-name to post-proxy logs
by Tariq Rashid 29 Jul '05

29 Jul '05

Tariq Rashid <tariq.rashid(a)uk.easynet.net> wrote: > since the state must be maintained in the freeradius proxy - is it possible > to add it to the logs so that troubleshooting is easier? currently i have to > match the timestamps. Which log are you talking about? Alan DeKok. --- those that are at $PREFIX/var/log/radius/radacct/1.2.3.4/post-proxy-detail-20050729 and $PREFIX/var/log/radius/radacct/1.2.3.4/pre-proxy-detail-20050729 for example - written by the following directgives in radiusd.conf : # This module logs packets proxied to a home server. # # You will also need to un-comment the 'pre_proxy_log' line # in the 'pre-proxy' section, below. # detail pre_proxy_log { detailfile = ${radacctdir}/%{Client-IP-Address}/pre-proxy-detail-%Y%m%d # # This MUST be 0600, otherwise anyone can read # the users passwords! detailperm = 0600 } # # This module logs response packets from a home server. # # You will also need to un-comment the 'post_proxy_log' line # in the 'post-proxy' section, below. # detail post_proxy_log { detailfile = ${radacctdir}/%{Client-IP-Address}/post-proxy-detail-%Y%m%d # # This MUST be 0600, otherwise anyone can read # the users passwords! detailperm = 0600 }

2 1