- Freeradius-Users - lists.freeradius.org

acctuniqueid
by Aurélio de Souza Ribeiro Neto 19 Sep '16

19 Sep '16

Hello All, I'm using FreeRadius 2.2.9. I'm experiencing some problems with acctuniqueid. My users allways come from the same NAS, and I have this errors: Error: [sql] Couldn't insert SQL accounting START record - Duplicate entry '8805551441c487d8' for key 'acctuniqueid' My acct_unique sesssion is: acct_unique { key = "User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port" } I think if I put additional clause like timestamp or something like this, I can solve my problem. Any suggestion? Aurelio

3 5

4.0.x Release Date
by Philipp Trenz 19 Sep '16

19 Sep '16

Hi FR-Team, I started configuring an FR Server and asked here which version I should choose. I got adviced to take 3.1.x and update to the upcoming 3.2 release. Now I read that this release will be skipped and next will be 4.0.x. Thats why I want to ask when the release will come up and how stable the 4.0.x branch is, is it stable enough to run it on a wide field? When will be the 4.0.x release? More precice I'm standing before the questions to wait for the next release while using 3.0.x or 4.0.x. It will be no complex infrastructure, just LDAP, PEAP w. MS-CHAPv2 and unsing the proxy. What's your advice? Thanks! --

3 5

LDAP distinguished name escaping
by Rob Johnson [rbj] 19 Sep '16

19 Sep '16

Hi all, I am pretty new to freeradius so please bear with me. Version 3.0.11 I am using the python module to return a DN based off the caller IP: def authorize(p): print "*** authorize ***" ip = getValue(p,'NAS-IP-Address') if ip == xxx.xxx.xxx.xxx: LDAPBaseDN = 'OU=MIS,OU=Auth,DC=ldap,DC=xx,DC=xx,DC=xx else: LDAPBaseDN = 'OU=Radius,OU=Auth,DC=ldap,DC=xx,DC=xx,DC=xx #LDAPBaseDN = 'OURadius' radiusd.radlog(radiusd.L_INFO, '*** radlog call in authorize ***') reply = (('Tmp-String-0',LDAPBaseDN),) return (radiusd.RLM_MODULE_OK, reply, None) This works and returns: *** authorize *** *** radlog call in authorize *** rlm_python:authorize: 'reply:Tmp-String-0' = 'OU=Radius,OU=Auth,DC=ldap,DC=xx,DC=xx,DC=xx' (0) [python] = ok But the problem lies in the ldap module by where I am trying to access the value in order to formulate my base_dn value: base_dn = "%{reply:Tmp-String-0}" The DN is escaped and obviously the the ldap bind fails due to the escaping: ldap: EXPAND %{reply:Tmp-String-0} (0) ldap: --> OU\3dRadius\2cOU\3dAuth\2cDC\3dldap\2cDC\3dxx\2cDC\3dxx\2cDC\3dxx (0) ldap: Performing search in "OU\3dRadius\2cOU\3dAuth\2cDC\3dldap\2cDC\3dxx\2cDC\3dxx\2cDC\3dxx" with filter "(CN=radius)", scope "sub" (0) ldap: Waiting for search result... (0) ldap: ERROR: Failed performing search: Invalid DN syntax I have tried using the ldap unescape method but to no joy. Please can someone help? Thanks, Rob -------------------------------------------------------------------- Un o'r 4 prifysgol uchaf yn y DU a'r gorau yng Nghymru am fodlonrwydd myfyrwyr (Arolwg Cenedlaethol y Myfyrwyr 2016) www.aber.ac.uk Top 4 UK university and best in Wales for student satisfaction (National Student Survey 2016) www.aber.ac.uk

4 6

(freeradius 3) I'm trying to integrate freeradius with active directory in cenos 7.
by Marcelo Martinez 16 Sep '16

16 Sep '16

Hello, I'm trying to integrate freeradius with active directory in cenos 7. The steps I did to join the client to AD domain here: yum install realm realm discover 10.8.10.109 test.uy type: kerberos realm-name: TEST.UY domain-name: test.uy configured: no server-software: active-directory client-software: sssd required-package: oddjob required-package: oddjob-mkhomedir required-package: sssd required-package: adcli required-package: samba-common yum -y install oddjob oddjobmkhomedir sssd adcli sambacommon yum install -y krb5workstation hostnamectl set-hostname prueba realm join -U Administrator test.uy ssh administrator@test.uy@localhost [administrator@test.uy@prueba ~]$ Done! Now I need help to install and configure freeradius and delegate authentication with active directory users. >From here, is there a guide to configure freeradius / active directory authentication? I tryied with different guides but I can't do the job yet... Thanks in advance.-

2 1

Troubleshooting EAP-TLS with External Certificates
by Matthew West 16 Sep '16

16 Sep '16

Hello FreeRADIUS Users, Thank you for taking my question. I am in the process of troubleshooting the EAP-TLS process using the following version of FreeRADIUS: radiusd: FreeRADIUS Version 2.2.6, for host x86_64-redhat-linux-gnu openssl: openssl-1.0.1e-48.el6_8.1.x86_64 I've gotten successful authentication using PAP through a switch with a test user, so the service is available and the client switch is communicating correctly. FreeRADIUS starts just fine, has the correct client, EAP loads, and points to the correct certs. I also have a client certificate in the certificate directory. Server certificate (star.companyname.net) was issued by GoDaddy and my (client) certificate was issued by VeriSign. I am pointing to the GoDaddy CA bundle for the server, but am not sure where to put the 'user' certificate chain (or does the whole chain need to be in the user cert)? Am I interpreting the error correctly? That the client cert appears to be self signed? radius -X OUTPUT: ==================== ... radiusd: #### Loading Clients #### client ***-CORP-SW1 { ipaddr = 10.x.x.123 require_message_authenticator = no secret = "xxxxxx" } ... ... Module: Instantiating module "eap" from file /etc/raddb/eap.conf eap { default_eap_type = "tls" timer_expire = 60 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 1024 } ... ... Module: Instantiating eap-tls tls { rsa_key_exchange = no dh_key_exchange = yes rsa_key_length = 512 dh_key_length = 512 verify_depth = 0 CA_path = "/etc/raddb/certs" pem_file_type = yes private_key_file = "/etc/raddb/certs/star.XXX.net.key" certificate_file = "/etc/raddb/certs/star.XXX.net.crt" CA_file = "/etc/raddb/certs/gd_bundle-g2.crt" dh_file = "/etc/raddb/certs/dh" fragment_size = 1024 include_length = yes check_crl = no cipher_list = "DEFAULT" ecdh_curve = "prime256v1" cache { enable = no lifetime = 24 max_entries = 255 } verify { } ocsp { enable = no override_cert_url = yes url = "http://127.0.0.1/ocsp/" use_nonce = yes timeout = 0 softfail = no } } ... ... Listening on authentication address * port 1812 Listening on accounting address * port 1813 Listening on command file /var/run/radiusd/radiusd.sock Listening on authentication address 127.0.0.1 port 18120 as server inner-tunnel Listening on proxy address * port 1814 Ready to process requests. ... When a request is made, I receive the following output: ... # Executing section authorize from file /etc/raddb/sites-enabled/default +group authorize { ++[preprocess] = ok ++[chap] = noop ++[mschap] = noop ++[digest] = noop [suffix] No '@' in User-Name = "Matthew West", looking up realm NULL [suffix] No such realm "NULL" ++[suffix] = noop [eap] EAP packet type response id 20 length 253 [eap] No EAP Start, assuming it's an on-going EAP conversation ++[eap] = updated ++[files] = noop ++[expiration] = noop ++[logintime] = noop ++[pap] = noop +} # group authorize = updated Found Auth-Type = EAP # Executing group from file /etc/raddb/sites-enabled/default +group authenticate { [eap] Request found, released from the list [eap] EAP/tls [eap] processing type tls [tls] Authenticate [tls] processing EAP-TLS [tls] eaptls_verify returned 7 [tls] Done initial handshake [tls] <<< TLS 1.0 Handshake [length 11fa], Certificate --> verify error:num=19:self signed certificate in certificate chain [tls] >>> TLS 1.0 Alert [length 0002], fatal unknown_ca TLS Alert write:fatal:unknown CA TLS_accept: error in SSLv3 read client certificate B rlm_eap: SSL error error:140890B2:SSL routines:SSL3_GET_CLIENT_CERTIFICATE:no certificate returned SSL: SSL_read failed in a system call (-1), TLS session fails. TLS receive handshake failed during operation [tls] eaptls_process returned 4 [eap] Handler failed in EAP/tls [eap] Failed in EAP select ++[eap] = invalid +} # group authenticate = invalid Failed to authenticate the user. Using Post-Auth-Type REJECT # Executing group from file /etc/raddb/sites-enabled/default +group REJECT { [attr_filter.access_reject] expand: %{User-Name} -> Matthew West attr_filter: Matched entry DEFAULT at line 11 ++[attr_filter.access_reject] = updated +} # group REJECT = updated Delaying reject of request 39 for 1 seconds Going to the next request Waking up in 0.9 seconds. Sending delayed reject for request 39 Sending Access-Reject of id 104 to 10.***.***.123 port 1645 EAP-Message = 0x04140004 Message-Authenticator = 0x00000000000000000000000000000000 Waking up in 3.8 seconds. Cleaning up request 30 ID 95 with timestamp +227 Cleaning up request 31 ID 96 with timestamp +227 Cleaning up request 32 ID 97 with timestamp +227 Cleaning up request 33 ID 98 with timestamp +227 Cleaning up request 34 ID 99 with timestamp +227 Cleaning up request 35 ID 100 with timestamp +227 Cleaning up request 36 ID 101 with timestamp +227 Cleaning up request 37 ID 102 with timestamp +227 Cleaning up request 38 ID 103 with timestamp +227 Waking up in 1.0 seconds. Cleaning up request 39 ID 104 with timestamp +227 Ready to process requests. ... Any help appreciated. Thank You, Matthew

8 32

Metrics and timings
by Louis Munro 16 Sep '16

16 Sep '16

Hello, I am curious to know what people use, if anything, to collect metrics about the various database calls that FreeRADIUS does. E.g. How fast is that LDAP server, or that SQL database? Sure you can measure some of that from the database side itself, and radsniff can give you some idea of the latency for your requests, but what do you do if you make multiple calls to a series of servers, some of which you may not have access to (cough.. AD server )? I have in the past written a wrapper for ntlm_auth that was logging the times (and sent them to a statsd server) but that process is now going away -- which is a good thing -- and that case does not cover metrics for FR's own modules. Ideally I'd like to be able to point to a slowdown in one submodule (redis, ldap, sql, winbind etc.) to explain why the total latency has increased. Short of adding metrics to each module I want them from (something I have played with using a statsd client library) is there a recommended way of getting that information? Especially if I want historical data to be able to compare against for anomaly detection or capacity planning? Any suggestions are welcome and appreciated. -- Louis Munro lmunro(a)inverse.ca <mailto:lmunro@inverse.ca> :: www.inverse.ca <http://www.inverse.ca/> +1.514.447.4918 x125 :: +1 (866) 353-6153 x125 Inverse inc. :: Leaders behind SOGo (www.sogo.nu <http://www.sogo.nu/>) and PacketFence (www.packetfence.org <http://www.packetfence.org/>)

3 4

Help troubleshooting No EAP session matching...
by Dave Aldwinckle 16 Sep '16

16 Sep '16

Hi List, During periods of high load, we are seeing many messages like the following: radiusd[28187]: rlm_eap: No EAP session matching the State variable. I understand the meaning of the message, but I need some assistance on how to go about locating the source of the problem. During peak times, we have about 8K wireless logins per minute, for extended periods. We have 6 wireless controllers, from which the Access-Requests are sent. Due to the high load, I am unable to run the server with -X, because it gets crushed while running single threaded. I can use radmin, but I'm not sure what to set the debug condition to. I don't see any errors about child processes being hung, or winbind/ntlm_auth taking too long. Some values which may be relevant: radiusd.conf: max_request_time = 30 radiusd.conf: cleanup_delay = 5 radiusd.conf: max_requests = 8000000 #about 30K wireless users at peak * 256 ~= 8million radiusd.conf: start_servers = 5 radiusd.conf: max_servers = 32 radiusd.conf: min_spare_servers = 3 radiusd.conf: max_spare_servers = 10 radiusd.conf: # max_queue_size = 65536 (unsure why this is commented out) mods-enabled/eap: timer_expire = 60 mods-enabled/eap: cache = disabled $ openssl speed rsa2048 Doing 2048 bit private rsa's for 10s: 5263 2048 bit private RSA's in 10.01s Doing 2048 bit public rsa's for 10s: 176233 2048 bit public RSA's in 10.00s OpenSSL 1.0.1e-fips 11 Feb 2013 built on: Mon May 2 06:13:20 EDT 2016 options:bn(64,64) md2(int) rc4(16x,int) des(idx,cisc,16,int) aes(partial) idea(int) blowfish(idx) compiler: gcc -fPIC -DOPENSSL_PIC -DZLIB -DOPENSSL_THREADS -D_REENTRANT -DDSO_DLFCN -DHAVE_DLFCN_H -DKRB5_MIT -m64 -DL_ENDIAN -DTERMIO -Wall -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -Wa,--noexecstack -DPURIFY -DOPENSSL_IA32_SSE2 -DOPENSSL_BN_ASM_MONT -DOPENSSL_BN_ASM_MONT5 -DOPENSSL_BN_ASM_GF2m -DSHA1_ASM -DSHA256_ASM -DSHA512_ASM -DMD5_ASM -DAES_ASM -DVPAES_ASM -DBSAES_ASM -DWHIRLPOOL_ASM -DGHASH_ASM sign verify sign/s verify/s rsa 2048 bits 0.001902s 0.000057s 525.8 17623.3 So, a couple questions: 1. Is there a way to get more info along with the message "rlm_eap: No EAP session matching the State variable." ? - eg. Which NAS it came from, calling-station-id, etc. 2. Are the aforementioned values OK? Any advice would be appreciated. Regards, Dave

4 16

CoA reply a wrong Session-Timeout
by prometeotv＠tiscali.it 16 Sep '16

16 Sep '16

Hi to all I am running freeradius ver 2.1.12-6 on CentOS 6.0. I have configured freeradius with sql_counter module and all is working fine. Now I have to configure CoA but on my NAS (Mikrotik) I receive the Session-Timeout equal to 0 and the same is for the Traffic (Mikrotik-XMit-Limit attribute) Which is the freeradius variable to pass to Session-Timeout inside the "update coa{" in order to have the residual credit time of the user? This is the freeradius configuration: /ETC/SITE-AVAILABLE/DEFAULT authorize { rewrite.calling_station_id preprocess chap mschap suffix eap { ok = return } unix sql expiration logintime pap noresetcounter dailycounter monthlycounter noresettrafficcounter dailytraffic monthlytraffic pppoetrafficcounter pppoedailytraffic pppoemonthlytraffic update control { Auth-Type := `/usr/bin/php -f /sitiweb/hotspot/functions/freeradiusauthorize.php %{User-Name} %{User-Password} %{Calling-Station-Id} %{NAS-IP-Address} %{Called-Station-ID}` } } accounting { rewrite.calling_station_id unix sql #COA update coa { User-Name = "%{User-Name}" Acct-Session-Id = "%{Acct-Session-Id}" NAS-IP-Address = "%{NAS-IP-Address}" Framed-IP-Address = "%{Framed-IP-Address}" Session-Timeout = "%{Session-Timeout}" # Session-Timeout = "%{Credit-Time}" # Session-Timeout = "%{noresetcounter:Credit-Time}" # Session-Timeout = "%{Session-Timeout}" # Session-Timeout = "%{sql:SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{User-Name}'}" # Session-Timeout = "%{noresetcounter}" # Session-Timeout = "%{rlm_sqlcounter:noresetcounter}" Mikrotik-XMit-Limit = "%{Mikrotik-XMit-Limit}" # Mikrotik-XMit-Limit = "%{Monthly-Credit-Traffic}" } # update control { # Send-CoA-Request = Yes # } } CLIENTS.CONF: client 0.0.0.0/0 { secret = hshelioos require_message_authenticator = no nastype = other } #COA home_server piazzalaterale-coa { type = coa # # Note that a home server of type "coa" MUST be a real NAS, # with an ipaddr or ipv6addr. It CANNOT point to a virtual # server. # ipaddr = 192.168.0.201 port = 3799 # This secret SHOULD NOT be the same as the shared # secret in a "client" section. secret = hshelioos # CoA specific parameters. See raddb/proxy.conf for details. coa { irt = 2 mrt = 16 mrc = 5 mrd = 30 } } SQLCOUNTER.CONF: sqlcounter noresetcounter { counter-name = Max-All-Session-Time check-name = Credit-Time sqlmod-inst = sql key = User-Name reset = never query = "SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{%k}'" } sqlcounter dailycounter { driver = "rlm_sqlcounter" counter-name = Daily-Session-Time check-name = Daily-Credit-Time sqlmod-inst = sql key = User-Name #reset = daily reset = never #query = "SELECT SUM(AcctSessionTime - GREATEST((%b - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'" #query = "SELECT SUM(SessionTime) FROM (SELECT SUM(AcctSessionTime - GREATEST((%b - UNIX_TIMESTAMP(AcctStartTime)), 0)) AS SessionTime FROM radacct WHERE UserName='%{%k}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b' UNION SELECT 0 AS SessionTime) AS Results" query = "SELECT SUM(SessionTime) FROM (SELECT SUM(AcctSessionTime) AS SessionTime FROM radacct WHERE UserName='%{%k}' AND DATE(NOW())=DATE(acctstoptime) UNION SELECT 0 AS SessionTime) AS Results" } sqlcounter monthlycounter { counter-name = Monthly-Session-Time check-name = Monthly-Credit-Time sqlmod-inst = sql key = User-Name #reset = daily reset = never #query = "SELECT SUM(AcctSessionTime - GREATEST((%b - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'" #query = "SELECT SUM(SessionTime) FROM (SELECT SUM(AcctSessionTime - GREATEST((%b - UNIX_TIMESTAMP(AcctStartTime)), 0)) AS SessionTime FROM radacct WHERE UserName='%{%k}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b' UNION SELECT 0 AS SessionTime) AS Results" query = "SELECT SUM(SessionTime) FROM (SELECT SUM(AcctSessionTime) AS SessionTime FROM radacct WHERE UserName='%{%k}' AND MONTH(acctstoptime) = MONTH(NOW()) AND YEAR(acctstoptime) = YEAR(NOW()) UNION SELECT 0 AS SessionTime) AS Results" } and this is the LOG of "radiusd -X" command: Listening on authentication address 127.0.0.1 port 18120 as server inner-tunnel Listening on proxy address * port 1814 Ready to process requests. rad_recv: Access-Request packet from host 192.168.0.201 port 33465, id=32, length=230 NAS-Port-Type = Wireless-802.11 Calling-Station-Id = "00:22:5F:0F:58:84" Called-Station-Id = "Piazza Laterale" NAS-Port-Id = "hs-bridge" User-Name = "00393383880766@BarCentrale" NAS-Port = 2151677962 Acct-Session-Id = "8040000a" Framed-IP-Address = 10.0.200.105 Mikrotik-Host-IP = 10.0.200.105 CHAP-Challenge = 0x980558b3c7d785a90bcc313cb3d36f05 CHAP-Password = 0xb857266bd68f0ad533ce1801e25f165f64 Service-Type = Login-User WISPr-Logoff-URL = "http://0.0.0.0/logout" NAS-Identifier = "Piazza Laterale" NAS-IP-Address = 192.168.0.201 # Executing section authorize from file /etc/raddb/sites-enabled/default +- entering group authorize {...} ++- entering policy rewrite.calling_station_id {...} +++? if ((Calling-Station-Id) && "%{Calling-Station-Id}" =~ /^%{config:policy.mac-addr}$/i) ?? Evaluating (Calling-Station-Id) -> TRUE expand: %{Calling-Station-Id} -> 00:22:5F:0F:58:84 expand: policy.mac-addr -> policy.mac-addr expand: ^%{config:policy.mac-addr}$ -> ^([0-9a-f]{2})[^0-9a-f]?([0-9a-f]{2})[^0-9a-f]?([0-9a-f]{2})[^0-9a-f]?([0-9a-f]{2})[^0-9a-f]?([0-9a-f]{2})[^0-9a-f]?([0-9a-f]{2})$ ? Evaluating ("%{Calling-Station-Id}" =~ /^%{config:policy.mac-addr}$/i) -> TRUE +++? if ((Calling-Station-Id) && "%{Calling-Station-Id}" =~ /^%{config:policy.mac-addr}$/i) -> TRUE +++- entering if ((Calling-Station-Id) && "%{Calling-Station-Id}" =~ /^%{config:policy.mac-addr}$/i) {...} expand: %{1}:%{2}:%{3}:%{4}:%{5}:%{6} -> 00:22:5F:0F:58:84 expand: %{toupper:%{1}:%{2}:%{3}:%{4}:%{5}:%{6}} -> 00:22:5F:0F:58:84 ++++[request] returns notfound ++++[updated] returns updated +++- if ((Calling-Station-Id) && "%{Calling-Station-Id}" =~ /^%{config:policy.mac-addr}$/i) returns updated +++ ... skipping else for request 0: Preceding "if" was taken ++- policy rewrite.calling_station_id returns updated ++[preprocess] returns ok [chap] Setting 'Auth-Type := CHAP' ++[chap] returns ok ++[mschap] returns noop [suffix] Looking up realm "BarCentrale" for User-Name = "00393383880766@BarCentrale" [suffix] No such realm "BarCentrale" ++[suffix] returns noop [eap] No EAP-Message, not doing EAP ++[eap] returns noop ++[unix] returns notfound [sql] expand: %{User-Name} -> 00393383880766@BarCentrale [sql] sql_set_user escaped user --> '00393383880766@BarCentrale' rlm_sql (sql): Reserving sql socket id: 4 [sql] expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radcheck WHERE username = '00393383880766@BarCentrale' ORDER BY id [sql] User found in radcheck table [sql] expand: SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radreply WHERE username = '00393383880766@BarCentrale' ORDER BY id [sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = '00393383880766@BarCentrale' ORDER BY priority [sql] expand: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'DEFAULT2048K-256K-5DEVICES' ORDER BY id [sql] User found in group DEFAULT2048K-256K-5DEVICES [sql] expand: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'DEFAULT2048K-256K-5DEVICES' ORDER BY id rlm_sql (sql): Released sql socket id: 4 ++[sql] returns ok ++[expiration] returns noop ++[logintime] returns noop [pap] WARNING: Auth-Type already set. Not setting to PAP ++[pap] returns noop rlm_sqlcounter: Entering module authorize code WARNING: Please replace '%k' with '${key}' sqlcounter_expand: 'SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{User-Name}'' [noresetcounter] expand: SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='%{User-Name}' -> SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='00393383880766@BarCentrale' WARNING: Please replace '%S' with '${sqlmod-inst}' sqlcounter_expand: '%{sql:SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='00393383880766@BarCentrale'}' [noresetcounter] sql_xlat [noresetcounter] expand: %{User-Name} -> 00393383880766@BarCentrale [noresetcounter] sql_set_user escaped user --> '00393383880766@BarCentrale' [noresetcounter] expand: SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='00393383880766@BarCentrale' -> SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='00393383880766@BarCentrale' rlm_sql (sql): Reserving sql socket id: 3 [noresetcounter] sql_xlat finished rlm_sql (sql): Released sql socket id: 3 [noresetcounter] expand: %{sql:SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='00393383880766@BarCentrale'} -> 747 rlm_sqlcounter: Check item is greater than query result rlm_sqlcounter: Authorized user 00393383880766@BarCentrale, check_item=2700, counter=747 rlm_sqlcounter: Sent Reply-Item for user 00393383880766@BarCentrale, Type=Session-Timeout, value=1953 ++[noresetcounter] returns ok rlm_sqlcounter: Entering module authorize code rlm_sqlcounter: Could not find Check item value pair ++[dailycounter] returns noop rlm_sqlcounter: Entering module authorize code rlm_sqlcounter: Could not find Check item value pair ++[monthlycounter] returns noop rlm_sqlcounter: Entering module authorize code rlm_sqlcounter: Could not find Check item value pair ++[noresettrafficcounter] returns noop rlm_sqlcounter: Entering module authorize code rlm_sqlcounter: Could not find Check item value pair ++[dailytraffic] returns noop rlm_sqlcounter: Entering module authorize code rlm_sqlcounter: Could not find Check item value pair ++[monthlytraffic] returns noop rlm_sqlcounter: Entering module authorize code rlm_sqlcounter: Could not find Check item value pair ++[pppoetrafficcounter] returns noop rlm_sqlcounter: Entering module authorize code rlm_sqlcounter: Could not find Check item value pair ++[pppoedailytraffic] returns noop rlm_sqlcounter: Entering module authorize code rlm_sqlcounter: Could not find Check item value pair ++[pppoemonthlytraffic] returns noop expand: %{User-Name} -> 00393383880766@BarCentrale expand: %{User-Password} -> expand: %{Calling-Station-Id} -> 00:22:5F:0F:58:84 expand: %{NAS-IP-Address} -> 192.168.0.201 expand: %{Called-Station-ID} -> Piazza Laterale Exec-Program output: Exec-Program: returned: 0 ++[control] returns noop Found Auth-Type = Local WARNING: Please update your configuration, and remove 'Auth-Type = Local' WARNING: Use the PAP or CHAP modules instead. CHAP-Password is correct. # Executing section session from file /etc/raddb/sites-enabled/default +- entering group session {...} [sql] expand: %{User-Name} -> 00393383880766@BarCentrale [sql] sql_set_user escaped user --> '00393383880766@BarCentrale' [sql] expand: SELECT COUNT(*) FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL -> SELECT COUNT(*) FROM radacct WHERE username = '00393383880766@BarCentrale' AND acctstoptime IS NULL rlm_sql (sql): Reserving sql socket id: 2 rlm_sql (sql): Released sql socket id: 2 ++[sql] returns ok # Executing section post-auth from file /etc/raddb/sites-enabled/default +- entering group post-auth {...} [sql] expand: %{User-Name} -> 00393383880766@BarCentrale [sql] sql_set_user escaped user --> '00393383880766@BarCentrale' [sql] expand: %{User-Password} -> [sql] ... expanding second conditional [sql] expand: %{Chap-Password} -> 0xb857266bd68f0ad533ce1801e25f165f64 [sql] expand: INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S') -> INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '00393383880766@BarCentrale', '0xb857266bd68f0ad533ce1801e25f165f64', 'Access-Accept', '2016-09-16 14:22:23') rlm_sql (sql) in sql_postauth: query is INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '00393383880766@BarCentrale', '0xb857266bd68f0ad533ce1801e25f165f64', 'Access-Accept', '2016-09-16 14:22:23') rlm_sql (sql): Reserving sql socket id: 1 rlm_sql (sql): Released sql socket id: 1 ++[sql] returns ok ++[exec] returns noop Sending Access-Accept of id 32 to 192.168.0.201 port 33465 SESSION-TIMEOUT := 1953 Idle-Timeout := 180 WISPr-Bandwidth-Max-Down := 2048000 WISPr-Bandwidth-Max-Up := 256000 Mikrotik-Rate-Limit := "256000/2048000" Finished request 0. Going to the next request Waking up in 4.9 seconds. rad_recv: Accounting-Request packet from host 192.168.0.201 port 55450, id=33, length=176 Acct-Status-Type = Start NAS-Port-Type = Wireless-802.11 Calling-Station-Id = "00:22:5F:0F:58:84" Called-Station-Id = "Piazza Laterale" NAS-Port-Id = "hs-bridge" User-Name = "00393383880766@BarCentrale" NAS-Port = 2151677962 Acct-Session-Id = "8040000a" Framed-IP-Address = 10.0.200.105 Mikrotik-Host-IP = 10.0.200.105 Event-Timestamp = "Sep 16 2016 14:22:23 CEST" NAS-Identifier = "Piazza Laterale" Acct-Delay-Time = 0 NAS-IP-Address = 192.168.0.201 # Executing section preacct from file /etc/raddb/radiusd.conf +- entering group preacct {...} [acct_unique] Hashing 'Client-IP-Address = 192.168.0.201,NAS-IP-Address = 192.168.0.201,Acct-Session-Id = "8040000a",User-Name = "00393383880766@BarCentrale"' [acct_unique] Acct-Unique-Session-ID = "9fbe06198361f0df". ++[acct_unique] returns ok # Executing section accounting from file /etc/raddb/sites-enabled/default +- entering group accounting {...} ++- entering policy rewrite.calling_station_id {...} +++? if ((Calling-Station-Id) && "%{Calling-Station-Id}" =~ /^%{config:policy.mac-addr}$/i) ?? Evaluating (Calling-Station-Id) -> TRUE expand: %{Calling-Station-Id} -> 00:22:5F:0F:58:84 expand: policy.mac-addr -> policy.mac-addr expand: ^%{config:policy.mac-addr}$ -> ^([0-9a-f]{2})[^0-9a-f]?([0-9a-f]{2})[^0-9a-f]?([0-9a-f]{2})[^0-9a-f]?([0-9a-f]{2})[^0-9a-f]?([0-9a-f]{2})[^0-9a-f]?([0-9a-f]{2})$ ? Evaluating ("%{Calling-Station-Id}" =~ /^%{config:policy.mac-addr}$/i) -> TRUE +++? if ((Calling-Station-Id) && "%{Calling-Station-Id}" =~ /^%{config:policy.mac-addr}$/i) -> TRUE +++- entering if ((Calling-Station-Id) && "%{Calling-Station-Id}" =~ /^%{config:policy.mac-addr}$/i) {...} expand: %{1}:%{2}:%{3}:%{4}:%{5}:%{6} -> 00:22:5F:0F:58:84 expand: %{toupper:%{1}:%{2}:%{3}:%{4}:%{5}:%{6}} -> 00:22:5F:0F:58:84 ++++[request] returns noop ++++[updated] returns updated +++- if ((Calling-Station-Id) && "%{Calling-Station-Id}" =~ /^%{config:policy.mac-addr}$/i) returns updated +++ ... skipping else for request 1: Preceding "if" was taken ++- policy rewrite.calling_station_id returns updated ++[unix] returns ok [sql] expand: %{User-Name} -> 00393383880766@BarCentrale [sql] sql_set_user escaped user --> '00393383880766@BarCentrale' [sql] expand: %{Acct-Delay-Time} -> 0 [sql] expand: 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, xascendsessionsvrkey) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', rlm_sql (sql): Reserving sql socket id: 0 rlm_sql (sql): Released sql socket id: 0 ++[sql] returns ok [attr_filter.accounting_response] expand: %{User-Name} -> 00393383880766@BarCentrale attr_filter: Matched entry DEFAULT at line 12 ++[attr_filter.accounting_response] returns updated expand: %{User-Name} -> 00393383880766@BarCentrale expand: %{Acct-Session-Id} -> 8040000a expand: %{NAS-IP-Address} -> 192.168.0.201 expand: %{Framed-IP-Address} -> 10.0.200.105 EXPAND: %{SESSION-TIMEOUT} -> ++[coa] returns updated Sending Accounting-Response of id 33 to 192.168.0.201 port 55450 WARNING: Empty pre-proxy section. Using default return values. SENDING COA-REQUEST OF ID 217 TO 192.168.0.201 PORT 3799 User-Name = "00393383880766@BarCentrale" Acct-Session-Id = "8040000a" NAS-IP-Address = 192.168.0.201 Framed-IP-Address = 10.0.200.105 SESSION-TIMEOUT = 0 Finished request 1. Cleaning up request 1 ID 33 with timestamp +134 Going to the next request Waking up in 1.8 seconds. rad_recv: CoA-ACK packet from host 192.168.0.201 port 3799, id=217, length=43 NAS-Identifier = "Piazza Laterale" NAS-IP-Address = 192.168.0.201 # Executing section post-proxy from file /etc/raddb/sites-enabled/default As you can see from the LOG, CoA is working correctly but send as Session-Timeout 0, instead of the correct credit Traffic for the user that is 1953. I have tried a lot of variable on the "coa update" for Session-Timeout and Mikrotik-XMit-Limit but none work. Can someone help me? Best regards Con Smart 3 Giga a 9 euro/4 sett navighi veloce, chiami e invii SMS dal tuo smartphone verso tutti i fissi e mobili in Italia. Passa a Tiscali Mobile! http://casa.tiscali.it/mobile/

2 1

disable response for accounting
by liran kessel 14 Sep '16

14 Sep '16

> > Hi, > > we have a freereadius server that is only responsible for collecting accounting info from a mobile network and storing to mysql. > However the network administrators have requested we don’t send back respond messages to confirm we received the message. > > I have found this thread from a few years ago and did as it suggested. > > http://lists.freeradius.org/pipermail/freeradius-users/2012-May/060723.html <http://lists.freeradius.org/pipermail/freeradius-users/2012-May/060723.html> > > but while it seems to have stopped sending responses to the network, it stopped logging the info into the mysql DB, eventhough it continued to log to the detail log file. and so I had to roll back. > > Can anyone explain why this caused the server to stop writing to mysql? > > thanks > > Liran Kessel > liran(a)rizotec.com <mailto:liran@rizotec.com> > Tel:(972)-52 6786885 > www.rizotec.com <http://www.rizotec.com/> > > >

2 3

PEAP label in PRF
by Chitrang Srivastava 14 Sep '16

14 Sep '16

Hi, This is regarding seed label which is used in PRF(Pseudo random function) to derive session keys. PEAPv0: https://tools.ietf.org/html/draft-kamath-pppext-peapv0-00 - I don't see any mention of label but look like it uses *client EAP encryption ? *Any official draft or RFC mentioned PEAPv0 uses this label ? PEAPv1: https://tools.ietf.org/html/draft-josefsson-pppext-eap-tls-eap-05 *client PEAP encryption* PEAPv2: https://tools.ietf.org/html/draft-josefsson-pppext-eap-tls-eap-10 *client EAP encryption* So on the *client *side the code should be something like if(PEAP_version ==1) label is *client PEAP encryption* otherwise // For version 0 and 2 label is *client PEAP encryption* This look OK? Why PEAPv2 uses old label ?

2 3