- Freeradius-Users - lists.freeradius.org

How to log sites-available/default variables
by mdii 19 May '15

19 May '15

> > Hi, > >* Hi, > *> >* In my sites-available/default file I set a post-proxy variable that is > *>* added to the proxy-reply: > *> >* > post-proxy { > *>* > > *>* update reply { > *>* > Filter-Id := `/usr/sbin/ldap_get_group_info.sh %{User-Name}` > *>* > } > *>* > > *>* } > *>* > > *> >* I'm trying to add the Filter-Id value into the auth-detail-<date> file, is > *>* it possible? > * > everything gets logged - but i reckon you are calling the detail module BEFORE you've done > this update reply call..... > > alan > > Thanks for your answer Alan, How exactly it's logged? How can I add the Filter-Id information to the log? My auth-detail-20150518 log file looks like: Mon May 18 06:46:16 2015 Packet-Type = Access-Request User-Name = "user(a)domain.com" Acct-Session-Id = "1431935176I23fkb" NAS-IP-Address = 127.0.0.1 NAS-Identifier = "Localhost" NAS-Port = 0 Calling-Station-Id = "1115551212" Message-Authenticator = 0x2a9e87211fd9ce73f6e6faf739da0732 I've tried to play with the "Log" section in the radius.conf file but it didn't change nothing. I imagine it could be in the modules/detail.log but I couldn't find any info of how to set this up... thanks again, Marc <freeradius-users%40lists.freeradius.org?Subject=Re%3A%20How%20to%20log%20sites-available/default%20variables&In-Reply-To=%3C20150519063917.GB955%40lboro.ac.uk%3E>

2 1

How to log sites-available/default variables
by mdii 19 May '15

19 May '15

Hi, In my sites-available/default file I set a post-proxy variable that is added to the proxy-reply: > post-proxy { > update reply { > Filter-Id := `/usr/sbin/ldap_get_group_info.sh %{User-Name}` > } > } > I'm trying to add the Filter-Id value into the auth-detail-<date> file, is it possible? Thanks in advance, Marc

2 1

LDAP authentication
by chenjiang 19 May '15

19 May '15

Hi! Experts Sorry for disturbing, I try to use LDAP as FreeRADIUS backend DB to authentication Windows2008 domain users but the POC test is failed, do you have experience on this and could shed some light on it? Thanks for your support. My FreeRADIUS LDAP related configuration listed below: more /etc/raddb/modules/ldap â¦... ldap { # # Note that this needs to match the name in the LDAP # server certificate, if you're using ldaps. server = "192.168.254.102" identity = "cn=Administrator,cn=Users,dc=ms,dc=local" password = "1qaz!QAZ" basedn = "dc=ms,dc=local" filter = "(sAMAccountName=%{%{Stripped-User-Name}:-%{User-Name}})" ldap_connections_number = 5 # seconds to wait for LDAP query to finish. default: 20 timeout = 20 # seconds LDAP server has to process the query (server-side # time limit). default: 20 # # LDAP_OPT_TIMELIMIT is set to this value. timelimit = 20 â¦â¦ And my radiusd -X output as below, you could see there is Access-Reject messages sent to NAS. rad_recv: Access-Request packet from host 192.168.253.254 port 49603, id=77, length=253 NAS-IP-Address = 192.168.253.254 NAS-Port = 0 NAS-Port-Type = Wireless-802.11 User-Name = "lab" Service-Type = Login-User Calling-Station-Id = "F437B7011933" Called-Station-Id = "000B86999D57" MS-CHAP-Challenge = 0xbd38014db9614219e63be5946a2e5e37 MS-CHAP2-Response = 0x09001650f03ffa8a6d6ce04f76d60a8cf4c900000000000000008be9d324ae40a1063 66c1ee86933dacd17bf520297182190 Aruba-Essid-Name = "microshield-lab" Aruba-Location-Id = "lab-AP-1" Aruba-Attr-10 = 0x6d6963726f736869656c642d6c6162 Aruba-Attr-12 = 0x6950686f6e65 Message-Authenticator = 0x530723b754043a3c9ff8cdc151e2ed87 # Executing section authorize from file /etc/raddb/sites-enabled/default +- entering group authorize {...} ++[preprocess] returns ok ++[digest] returns noop [suffix] No '@' in User-Name = "lab", looking up realm NULL [suffix] No such realm "NULL" ++[suffix] returns noop [ldap] performing user authorization for lab [ldap] expand: %{Stripped-User-Name} -> [ldap] ... expanding second conditional [ldap] expand: %{User-Name} -> lab [ldap] expand: (sAMAccountName=%{%{Stripped-User-Name}:-%{User-Name}}) -> (sAMAccountName=lab) [ldap] expand: dc=ms,dc=local -> dc=ms,dc=local [ldap] ldap_get_conn: Checking Id: 0 [ldap] ldap_get_conn: Got Id: 0 [ldap] performing search in dc=ms,dc=local, with filter (sAMAccountName=lab) [ldap] looking for check items in directory... [ldap] looking for reply items in directory... WARNING: No "known good" password was found in LDAP. Are you sure that the user is configured correctly? [ldap] user lab authorized to use remote access [ldap] ldap_release_conn: Release Id: 0 ++[ldap] returns ok ++[expiration] returns noop ++[logintime] returns noop Failed to authenticate the user. Using Post-Auth-Type Reject # Executing group from file /etc/raddb/sites-enabled/default +- entering group REJECT {...} [sql] expand: %{User-Name} -> lab [sql] sql_set_user escaped user --> 'lab' [sql] expand: %{User-Password} -> [sql] ... expanding second conditional [sql] expand: %{Chap-Password} -> [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 ( 'lab', '', 'Access-Reject', '2015-05-18 13:53:47') rlm_sql (sql) in sql_postauth: query is INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( 'lab', '', 'Access-Reject', '2015-05-18 13:53:47') rlm_sql (sql): Reserving sql socket id: 2 rlm_sql (sql): Released sql socket id: 2 ++[sql] returns ok [attr_filter.access_reject] expand: %{User-Name} -> lab attr_filter: Matched entry DEFAULT at line 11 ++[attr_filter.access_reject] returns updated Sending Access-Reject of id 77 to 192.168.253.254 port 49603 Finished request 26. BR! Chen Jiang Microshield Technology Co., Ltd åäº¬å¸æµ·æ·åºè¥¿ä¸ç¯åè·¯50å·è±ªæå¤§å¦C2åº§18-19å± 100048 (86)10-88518768 (86)18612696123 [1]chenjiang(a)microshield.com.cn References 1. mailto:chenjiang@microshield.com.cn

2 1

Help with Radius errors
by Philip Bellino 18 May '15

18 May '15

Hello, I was running FreeRadius version 2.1.1 on Fedora Core 4. This worked fine, using a vanilla configuration with perhaps a dozen users defined. Due to a hard disk crash we had to replace our radius server PC. Our newer PC is running Fedora Core 21. We then downloaded the FreeRadius 3.0.8 tar.gz file, built and installed it. We now cannot get past the following errors (in bold below). We have tried reconfiguring the shared secret as suggested, on the server (editing the clients.conf file and retyping the secret) and the client side but still get these errors. In the 2.1.1 version, the only files we changed were "radiusd.conf", "clients.conf" and "users" and added our own dictionary file. So for 3.0.8, we followed suit. Any assistance would be most appreciated. Thanks, Phil Partial output from running radiusd -X: I have attached the entire output. Listening on auth address * port 1812 bound to server default Listening on acct address * port 1813 bound to server default Listening on auth address :: port 1812 bound to server default Listening on acct address :: port 1813 bound to server default Listening on auth address 127.0.0.1 port 18120 bound to server inner-tunnel Opening new proxy socket 'proxy address * port 0' Listening on proxy address * port 54743 Ready to process requests (0) Received Access-Request Id 24 from 10.242.135.17:1026 to 10.242.135.10:1812 length 68 (0) MRV-Remote-Access-List = 'gina' (0) MRV-Outlet-Group-Access-List = ' ???' (0) MRV-Login-Mode = ' (0) NAS-Port-Type = Virtual (0) MRV-Port-Access-List = '^????D???a????S?' (0) MRV-Menu-Name = ' (0) # Executing section authorize from file /usr/local/etc/raddb/sites-enabled/default (0) authorize { (0) policy filter_username { (0) if (!&User-Name) { (0) if (!&User-Name) -> TRUE (0) if (!&User-Name) { (0) [noop] = noop (0) } # if (!&User-Name) = noop (0) if (&User-Name =~ / /) { (0) ERROR: Failed retrieving values required to evaluate condition (0) if (&User-Name =~ /@.*@/<mailto:/@.*@/> ) { (0) ERROR: Failed retrieving values required to evaluate condition (0) if (&User-Name =~ /\.\./ ) { (0) ERROR: Failed retrieving values required to evaluate condition (0) if ((&User-Name =~ /@/) && (&User-Name !~ /(a)(.+)\.(.+)$/))<mailto:/@(.+)\.(.+)$/))> { (0) ERROR: Failed retrieving values required to evaluate condition (0) if (&User-Name =~ /\.$/) { (0) ERROR: Failed retrieving values required to evaluate condition (0) if (&User-Name =~ /(a)\./<mailto:/@\./>) { (0) ERROR: Failed retrieving values required to evaluate condition (0) } # policy filter_username = noop (0) [preprocess] = ok (0) [chap] = noop (0) [mschap] = noop (0) [digest] = noop (0) suffix: Checking for suffix after "@" (0) suffix: No '@' in User-Name = "gina", looking up realm NULL (0) suffix: No such realm "NULL" (0) [suffix] = noop (0) eap: No EAP-Message, not doing EAP (0) [eap] = noop (0) files: users: Matched entry gina at line 128 (0) [files] = ok (0) [expiration] = noop (0) [logintime] = noop (0) [pap] = updated (0) } # authorize = updated (0) Found Auth-Type = PAP (0) # Executing group from file /usr/local/etc/raddb/sites-enabled/default (0) Auth-Type PAP { (0) pap: Login attempt with password (0) pap: ERROR: Cleartext password does not match "known good" password (0) pap: Passwords don't match (0) [pap] = reject (0) } # Auth-Type PAP = reject (0) Failed to authenticate the user (0) WARNING: Unprintable characters in the password. Double-check the shared secret on the server and the NAS! (0) Using Post-Auth-Type Reject (0) # Executing group from file /usr/local/etc/raddb/sites-enabled/default (0) Post-Auth-Type REJECT { (0) attr_filter.access_reject: EXPAND %{User-Name} (0) attr_filter.access_reject: --> (0) [attr_filter.access_reject] = noop (0) [eap] = noop (0) policy remove_reply_message_if_eap { (0) if (&reply:EAP-Message && &reply:Reply-Message) { (0) if (&reply:EAP-Message && &reply:Reply-Message) -> FALSE (0) else { (0) [noop] = noop (0) } # else = noop (0) } # policy remove_reply_message_if_eap = noop (0) } # Post-Auth-Type REJECT = noop (0) Delaying response for 1.000000 seconds Waking up in 0.3 seconds. Waking up in 0.6 seconds. (0) <delay>: Sending delayed response (0) <delay>: Sent Access-Reject Id 24 from 10.242.135.10:1812 to 10.242.135.17:1026 length 20 Waking up in 3.9 seconds. (0) <delay>: Cleaning up request packet ID 24 with timestamp +19 Ready to process requests Phil Bellino Principal Software Engineer | MRV Communications Inc. 300 Apollo Drive | Chelmsford, MA 01824 Phone: 978-674-6870 | Fax: 978-674-6799 www.mrv.com [MRV-email] [E-Banner]<http://www.mrv.com/landing/video-datasheet-mrvs-optidriver-platform> MRV Communications is a global supplier of packet and optical solutions that power the world's largest networks. Our products combine innovative hardware with intelligent software to make networks smarter, faster and more efficient. The contents of this message, together with any attachments, are intended only for the use of the person(s) to whom they are addressed and may contain confidential and/or privileged information. If you are not the intended recipient, immediately advise the sender, delete this message and any attachments and note that any distribution, or copying of this message, or any attachment, is prohibited.

3 9

Fetching users from external source
by mlstfr＠ntcomputer.de 17 May '15

17 May '15

Hello freeradius users, I am using freeradius2 on OpenWRT (having very little resources to operate), which is working fine. Now I'm trying to load users (usernames + passwords) from an external source for authentication in a guest network - the external source is another server which will be running a web interface and database to configure guest accounts. My approach would be to use wget/curl for fetching the users from the server (wrapped in a script), which allows the server to format the user list in a way freeradius understands it. How can I configure freeradius to execute the script on startup and use its stdout to later authenticate users against it? Of course, if there is another (better) approach on how to fetch the users, I would be happy to hear about it :) Also, guest accounts will be modified while freeradius is running. I need a way to inform freeradius (using SIGHUP?) to reload the user list from the server. Do you have a recommendation on how to achieve this in real-time? Thank you for your help!

4 6

Re: Publishing an EAP-TLS WPA2 Enterprise Setup Guide on the Wiki (Jasvinder S. Bahra)
by Rui Ribeiro 17 May '15

17 May '15

Hi Jasvinder, iPhone configurator has been indeed deprecated some while ago. It sort half worked in iOS 7, and it finally stopped being useful in iOS 8. At the moment, only XCode is useful for that. Apple configurator is used in a corporate setting, however last time I checked, it was only supported in a handful of countries, and not here in Portugal. Someone more used to it can comment. As for the profiles, we are generating them with cat.eduroam.org, because we are a university. However you also have available the service for free at https://802.1x-config.org for a corporate setting. Nevertheless, the profiles are essentially text files. So after generating the first, you can keep it. I also believe you can download client certificates never tried it. You just have to be aware that to download profiles or certificates you have to use the native Safari and not other browser. I also wrote a tutorial to the Portuguese federation on implementing FR 2+EAP-TTLS+AD, that I will have to update to FR 3 and make a little more presentable to distribute it widely. Feel free to contact me if you need more ideas about the Apple profiles. Regards, Rui Ribeiro -- Rui Ribeiro Senior Sysadm ISCTE-IUL https://www.linkedin.com/pub/rui-ribeiro/16/ab8/434 > Message: 2 > Date: Sat, 3 Jan 2015 10:30:37 -0000 > From: "Jasvinder S. Bahra" <bbdl21548(a)blueyonder.co.uk> > To: "FreeRadius users mailing list" > <freeradius-users(a)lists.freeradius.org> > Subject: Re: Publishing an EAP-TLS WPA2 Enterprise Setup Guide on the > Wiki > Message-ID: <1C37CF3272EE4702B874E462A92A49A6@atlantis> > Content-Type: text/plain; format=flowed; charset="iso-8859-1"; > reply-type=original > > Everyone, > > It looks like I posted too soon. > > My guide describes how to configure windows and android clients to connect > to a WPA2 Enterprise wifi network. > > I had done some research into getting apple devices onto it, and I believed > I had all the information necessary to get ipad's, iphone's and ipod's etc > onto the network. However, when I sat down to actually do so, I hit > something of a brick wall. > > I believed all I needed to do was download a PC application from the apple > website called the iPhone Configuration Utility (or iPCU), and use it to > create a profile which configured the relevant devices wifi connection > settings. > > It seems however, that the software has been deprecated - it hasn't been > updated in years. I can find no reference to it on the apple website. It > seems to have been replaced by an application named Configurator - which is > only available for mac's. > > Does anyone know of a way to configure ipad's, iphone's and ipod's wifi > settings, without tools such as iPCU or Configurator? > > Regards, > > Jazz > > > > ------------------------------ > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > End of Freeradius-Users Digest, Vol 117, Issue 5 > ************************************************ > -- Regards,

3 2

mysql user provisiong for limit session time
by Franz Angeli 16 May '15

16 May '15

Hi, i'm using Freeradius 2.1.12+dfsg-1.2ubuntu8 (ubuntu 14.04 default package), i would like to know if there is a way to provision users for time limit session; for example user John can use (for one time) an hotspot for an hour between 15:00 - 16:00, after the 16 it will be disconnected and can't connect anymore. Is it possible? Thanks in advance Franz

2 2

OpenLdap + Freeradius on centos 6.5 Not working
by Vishesh kumar 15 May '15

15 May '15

Hi All, I guess this may be a very repetitive question but I stuck in configuring openldap+freeradius setup on centos 6.5 My FreeRadius settings is as below ++++++++++++++++++++++++++++++++++++ authorize { preprocess ldap { ok = return } } authenticate { Auth-Type LDAP { ldap } Auth-Type PAP { pap } } +++++++++++++++++++++++++++++++++++++++++ And when I try to make connection from Supplicant to this Radius Server, in log , I am flooded with message " *ERROR: No authenticate method (Auth-Type) found for the request: Rejecting the user*" But when I probe Radius Server directly using radtest or any othe tool, I got below logs. ++++++++++++++++++++++++++++++++++++++++++++++++ [ldap] login attempt by "radtest" with password "XXXXX" [ldap] user DN: uid=radtest,ou=People,dc=xxxx,dc=local [ldap] (re)connect to 127.0.0.1:389, authentication 1 [ldap] bind as uid=radtest,ou=People,dc=xxxx,dc=local/redhat to 127.0.0.1:389 [ldap] waiting for bind result ... [ldap] Bind was successful [ldap] user radtest authenticated succesfully ++[ldap] returns ok WARNING: Empty post-auth section. Using default return values. ++++++++++++++++++++++++ Please let me know if I am doing anything wrong here -- Regards, Vishesh Kumar

5 11

RFC: voucherBox (autoprovisioned wifi vouchers)
by Luigi Capriotti 15 May '15

15 May '15

There are a few turnkey solutions for WiFi vouchers management, but I have not found a streamlined solution providing pure AAA services only. What I mean is rely on a web auth authentication where FreeRADIUS acts as AAA server for voucher codes, and where provision of vouchers could be fully automated. The scenario is a guest wifi hotspot where employees can obtain time-limited wifi vouchers to hand over to their for external guests, where expiration is calculated upon first use of the code. As a result (although knowing very little of FreeRADIUS) I created "voucherbox", ie a SaaS application providing both a web frontend for voucher generation as well as AAA services to an external captive portal. I pushed on github the implementation walk-though (starting from zero and using Ubuntu), the required configuration files for both FreeRADIUS and Apache and a POC web interface for voucher auto-provision: https://github.com/lcapriotti/voucherBox I would appreciate any constructive criticism from anyone with more experience in FreeRADIUS than me (most of the list subscribers I guess...), in a way to pinpoint the weaknesses or the unnecessary intricacies that I may have come up with. Thanks a lot in advance Luigi Capriotti

1 0

Reject
by escalanterj＠gmail.com 14 May '15

14 May '15

Hello, I have this output from debug, but no clue what is the problem, can anybody help me? Thanks! BR FreeRADIUS Debugging Output This colorized output was produced by an automated tool from Network RADIUS including configuration file /etc/freeradius/radiusd.conf including configuration file /etc/freeradius/sql.conf including configuration file /etc/freeradius/sql/mysql/dialup.conf including configuration file /etc/freeradius/proxy.conf including configuration file /etc/freeradius/clients.conf including files in directory /etc/freeradius/modules/ including configuration file /etc/freeradius/modules/sradutmp including configuration file /etc/freeradius/modules/mac2vlan including configuration file /etc/freeradius/modules/opendirectory including configuration file /etc/freeradius/modules/logintime including configuration file /etc/freeradius/modules/acct_unique including configuration file /etc/freeradius/modules/attr_filter including configuration file /etc/freeradius/modules/sqlcounter_expire_on_login including configuration file /etc/freeradius/modules/pam including configuration file /etc/freeradius/modules/replicate including configuration file /etc/freeradius/modules/radutmp including configuration file /etc/freeradius/modules/krb5 including configuration file /etc/freeradius/modules/cui including configuration file /etc/freeradius/modules/counter including configuration file /etc/freeradius/modules/detail.example.com including configuration file /etc/freeradius/modules/preprocess including configuration file /etc/freeradius/modules/passwd including configuration file /etc/freeradius/modules/cache including configuration file /etc/freeradius/modules/detail including configuration file /etc/freeradius/modules/digest including configuration file /etc/freeradius/modules/redis including configuration file /etc/freeradius/modules/files including configuration file /etc/freeradius/modules/inner-eap including configuration file /etc/freeradius/modules/dhcp_sqlippool including configuration file /etc/freeradius/modules/unix including configuration file /etc/freeradius/modules/mschap including configuration file /etc/freeradius/modules/exec including configuration file /etc/freeradius/modules/chap including configuration file /etc/freeradius/modules/wimax including configuration file /etc/freeradius/modules/mac2ip including configuration file /etc/freeradius/modules/realm including configuration file /etc/freeradius/modules/expr including configuration file /etc/freeradius/modules/dynamic_clients including configuration file /etc/freeradius/modules/ntlm_auth including configuration file /etc/freeradius/modules/attr_rewrite including configuration file /etc/freeradius/modules/etc_group including configuration file /etc/freeradius/modules/smsotp including configuration file /etc/freeradius/modules/radrelay including configuration file /etc/freeradius/modules/rediswho including configuration file /etc/freeradius/modules/pap including configuration file /etc/freeradius/modules/policy including configuration file /etc/freeradius/modules/sql_log including configuration file /etc/freeradius/modules/ippool including configuration file /etc/freeradius/modules/always including configuration file /etc/freeradius/modules/perl including configuration file /etc/freeradius/modules/expiration including configuration file /etc/freeradius/modules/echo including configuration file /etc/freeradius/modules/otp including configuration file /etc/freeradius/modules/ldap including configuration file /etc/freeradius/modules/detail.log including configuration file /etc/freeradius/modules/smbpasswd including configuration file /etc/freeradius/modules/soh including configuration file /etc/freeradius/modules/linelog including configuration file /etc/freeradius/modules/checkval including configuration file /etc/freeradius/eap.conf including configuration file /etc/freeradius/sql.conf including configuration file /etc/freeradius/sql/mysql/dialup.conf including configuration file /etc/freeradius/sql/mysql/counter.conf including files in directory /etc/freeradius/sites-enabled/ including configuration file /etc/freeradius/sites-enabled/default including configuration file /etc/freeradius/sites-enabled/default (copy) including configuration file /etc/freeradius/sites-enabled/inner-tunnel main { user = "freerad" group = "freerad" allow_core_dumps = no } including dictionary file /etc/freeradius/dictionary main { name = "freeradius" prefix = "/usr" localstatedir = "/var" sbindir = "/usr/sbin" logdir = "/var/log/freeradius" run_dir = "/var/run/freeradius" libdir = "/usr/lib/freeradius" radacctdir = "/var/log/freeradius/radacct" hostname_lookups = no max_request_time = 30 cleanup_delay = 5 max_requests = 1024 pidfile = "/var/run/freeradius/freeradius.pid" checkrad = "/usr/sbin/checkrad" debug_level = 0 proxy_requests = yes log { stripped_names = no auth = no auth_badpass = no auth_goodpass = no } security { max_attributes = 200 reject_delay = 1 status_server = yes allow_vulnerable_openssl = yes } } radiusd: #### Loading Realms and Home Servers #### proxy server { retry_delay = 5 retry_count = 3 default_fallback = no dead_time = 120 wake_all_if_all_dead = no } home_server localhost { ipaddr = 127.0.0.1 port = 1812 type = "auth" secret = "testing123" response_window = 20 max_outstanding = 65536 require_message_authenticator = yes zombie_period = 40 status_check = "status-server" ping_interval = 30 check_interval = 30 num_answers_to_alive = 3 num_pings_to_alive = 3 revive_interval = 120 status_check_timeout = 4 coa { irt = 2 mrt = 16 mrc = 5 mrd = 30 } } home_server_pool my_auth_failover { type = fail-over home_server = localhost } realm example.com { auth_pool = my_auth_failover } realm LOCAL { } radiusd: #### Loading Clients #### client localhost { ipaddr = 127.0.0.1 require_message_authenticator = no secret = "1107" nastype = "other" } client 0.0.0.0/0 { require_message_authenticator = no secret = "1107" shortname = "global" } radiusd: #### Instantiating modules #### instantiate { Module: Linked to module rlm_exec Module: Instantiating module "exec" from file /etc/freeradius/modules/exec exec { wait = no input_pairs = "request" shell_escape = yes timeout = 10 } Module: Linked to module rlm_expr Module: Instantiating module "expr" from file /etc/freeradius/modules/expr Module: Linked to module rlm_sqlcounter Module: Instantiating module "noresetcounter" from file /etc/freeradius/sql/mysql/counter.conf sqlcounter noresetcounter { counter-name = "Max-All-Session-Time" check-name = "Max-All-Session" reply-name = "Session-Timeout" key = "User-Name" sqlmod-inst = "sql" query = "SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='%{%k}'" reset = "never" safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" } rlm_sqlcounter: Check attribute Max-All-Session is number 11274 rlm_sqlcounter: Current Time: 1431638754 [2015-05-14 23:25:54], Next reset 0 [2015-05-14 23:00:00] rlm_sqlcounter: Current Time: 1431638754 [2015-05-14 23:25:54], Prev reset 0 [2015-05-14 23:00:00] Module: Linked to module rlm_expiration Module: Instantiating module "expiration" from file /etc/freeradius/modules/expiration expiration { reply-message = "Password Has Expired " } Module: Linked to module rlm_logintime Module: Instantiating module "logintime" from file /etc/freeradius/modules/logintime logintime { reply-message = "You are calling outside your allowed timespan " minimum-timeout = 60 } Module: Instantiating module "accessperiod" from file /etc/freeradius/sql/mysql/counter.conf sqlcounter accessperiod { counter-name = "Max-Access-Period-Never" check-name = "Access-Period" reply-name = "Session-Timeout" key = "User-Name" sqlmod-inst = "sql" query = "SELECT IF(COUNT(radacctid>=1),(UNIX_TIMESTAMP() - IFNULL(UNIX_TIMESTAMP(AcctStartTime),0)),0) FROM radacct WHERE UserName = '%{%k}' AND AcctSessionTime >= 1 ORDER BY AcctStartTime LIMIT 1" reset = "never" safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" } rlm_sqlcounter: Check attribute Access-Period is number 11276 rlm_sqlcounter: Current Time: 1431638754 [2015-05-14 23:25:54], Next reset 0 [2015-05-14 23:00:00] rlm_sqlcounter: Current Time: 1431638754 [2015-05-14 23:25:54], Prev reset 0 [2015-05-14 23:00:00] } radiusd: #### Loading Virtual Servers #### server { # from file pâ–’?? modules { Module: Creating Post-Auth-Type = REJECT Module: Checking authenticate {...} for more modules to load Module: Linked to module rlm_chap Module: Instantiating module "chap" from file /etc/freeradius/modules/chap Module: Linked to module rlm_eap Module: Instantiating module "eap" from file /etc/freeradius/eap.conf eap { default_eap_type = "md5" timer_expire = 60 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 1024 } Module: Linked to sub-module rlm_eap_md5 Module: Instantiating eap-md5 Module: Linked to sub-module rlm_eap_leap Module: Instantiating eap-leap Module: Linked to sub-module rlm_eap_gtc Module: Instantiating eap-gtc gtc { challenge = "Password: " auth_type = "PAP" } Module: Linked to sub-module rlm_eap_tls 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/freeradius/certs" pem_file_type = yes private_key_file = "/etc/freeradius/certs/server.key" certificate_file = "/etc/freeradius/certs/server.pem" CA_file = "/etc/freeradius/certs/ca.pem" private_key_password = "whatever" dh_file = "/etc/freeradius/certs/dh" random_file = "/dev/urandom" fragment_size = 1024 include_length = yes check_crl = no cipher_list = "DEFAULT" make_cert_command = "/etc/freeradius/certs/bootstrap" 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 } } Module: Linked to sub-module rlm_eap_ttls Module: Instantiating eap-ttls ttls { default_eap_type = "md5" copy_request_to_tunnel = no use_tunneled_reply = no virtual_server = "inner-tunnel" include_length = yes } Module: Linked to sub-module rlm_eap_peap Module: Instantiating eap-peap peap { default_eap_type = "mschapv2" copy_request_to_tunnel = no use_tunneled_reply = no proxy_tunneled_request_as_eap = yes virtual_server = "inner-tunnel" soh = no } Module: Linked to sub-module rlm_eap_mschapv2 Module: Instantiating eap-mschapv2 mschapv2 { with_ntdomain_hack = no send_error = no } Module: Linked to module rlm_pap Module: Instantiating module "pap" from file /etc/freeradius/modules/pap pap { encryption_scheme = "auto" auto_header = no } Module: Checking authorize {...} for more modules to load Module: Linked to module rlm_preprocess Module: Instantiating module "preprocess" from file /etc/freeradius/modules/preprocess preprocess { huntgroups = "/etc/freeradius/huntgroups" hints = "/etc/freeradius/hints" with_ascend_hack = no ascend_channels_per_line = 23 with_ntdomain_hack = no with_specialix_jetstream_hack = no with_cisco_vsa_hack = no with_alvarion_vsa_hack = no } reading pairlist file /etc/freeradius/huntgroups reading pairlist file /etc/freeradius/hints Module: Linked to module rlm_mschap Module: Instantiating module "mschap" from file /etc/freeradius/modules/mschap mschap { use_mppe = yes require_encryption = no require_strong = no with_ntdomain_hack = no allow_retry = yes } Module: Linked to module rlm_realm Module: Instantiating module "suffix" from file /etc/freeradius/modules/realm realm suffix { format = "suffix" delimiter = "@" ignore_default = no ignore_null = no } Module: Linked to module rlm_sql Module: Instantiating module "sql" from file /etc/freeradius/sql.conf sql { driver = "rlm_sql_mysql" server = "localhost" port = "" login = "root" password = "1107" radius_db = "radius" read_groups = yes sqltrace = no sqltracefile = "/var/log/freeradius/sqltrace.sql" readclients = no deletestalesessions = yes num_sql_socks = 5 lifetime = 0 max_queries = 0 sql_user_name = "%{User-Name}" default_user_profile = "" nas_query = "SELECT id, nasname, shortname, type, secret, server FROM nas" authorize_check_query = "SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id" authorize_reply_query = "SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id" authorize_group_check_query = "SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id" authorize_group_reply_query = "SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id" accounting_onoff_query = " UPDATE radacct SET acctstoptime = '%S', acctsessiontime = unix_timestamp('%S') - unix_timestamp(acctstarttime), acctterminatecause = '%{Acct-Terminate-Cause}', acctstopdelay = %{%{Acct-Delay-Time}:-0} WHERE acctstoptime IS NULL AND nasipaddress = '%{NAS-IP-Address}' AND acctstarttime <= '%S'" accounting_update_query = " UPDATE radacct SET framedipaddress = '%{Framed-IP-Address}', acctsessiontime = '%{Acct-Session-Time}', acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'" accounting_update_query_alt = " INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctsessiontime, acctauthentic, connectinfo_start, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, servicetype, framedprotocol, framedipaddress, acctstartdelay, xascendsessionsvrkey) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{%{Acct-Session-Time}:-0} + %{%{Acct-Delay-Time}:-0}) SECOND), '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{X-Ascend-Session-Svr-Key}')" accounting_start_query = " 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}', '%{%{Acct-Delay-Time}:-0}', '0', '%{X-Ascend-Session-Svr-Key}')" accounting_start_query_alt = " UPDATE radacct SET acctstarttime = '%S', acctstartdelay = '%{%{Acct-Delay-Time}:-0}', connectinfo_start = '%{Connect-Info}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'" accounting_stop_query = " UPDATE radacct SET acctstoptime = '%S', acctsessiontime = '%{Acct-Session-Time}', acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', acctterminatecause = '%{Acct-Terminate-Cause}', acctstopdelay = '%{%{Acct-Delay-Time}:-0}', connectinfo_stop = '%{Connect-Info}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'" accounting_stop_query_alt = " 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 ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{%{Acct-Session-Time}:-0} + %{%{Acct-Delay-Time}:-0}) SECOND), '%S', '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Connect-Info}', '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Acct-Terminate-Cause}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{%{Acct-Delay-Time}:-0}')" group_membership_query = "SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority" connect_failure_retry_delay = 60 simul_count_query = "" simul_verify_query = "SELECT radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocol FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL" postauth_query = "INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S')" safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" } rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to root@localhost:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql (sql): Connected new DB handle, #0 rlm_sql (sql): starting 1 rlm_sql (sql): Attempting to connect rlm_sql_mysql #1 rlm_sql_mysql: Starting connect to MySQL server for #1 rlm_sql (sql): Connected new DB handle, #1 rlm_sql (sql): starting 2 rlm_sql (sql): Attempting to connect rlm_sql_mysql #2 rlm_sql_mysql: Starting connect to MySQL server for #2 rlm_sql (sql): Connected new DB handle, #2 rlm_sql (sql): starting 3 rlm_sql (sql): Attempting to connect rlm_sql_mysql #3 rlm_sql_mysql: Starting connect to MySQL server for #3 rlm_sql (sql): Connected new DB handle, #3 rlm_sql (sql): starting 4 rlm_sql (sql): Attempting to connect rlm_sql_mysql #4 rlm_sql_mysql: Starting connect to MySQL server for #4 rlm_sql (sql): Connected new DB handle, #4 Module: Checking preacct {...} for more modules to load Module: Linked to module rlm_acct_unique Module: Instantiating module "acct_unique" from file /etc/freeradius/modules/acct_unique acct_unique { key = "User-Name, Acct-Session-Id, NAS-IP-Address, NAS-Identifier, NAS-Port" } Module: Linked to module rlm_files Module: Instantiating module "files" from file /etc/freeradius/modules/files files { usersfile = "/etc/freeradius/users" acctusersfile = "/etc/freeradius/acct_users" preproxy_usersfile = "/etc/freeradius/preproxy_users" compat = "no" } reading pairlist file /etc/freeradius/users reading pairlist file /etc/freeradius/acct_users reading pairlist file /etc/freeradius/preproxy_users Module: Checking accounting {...} for more modules to load Module: Linked to module rlm_detail Module: Instantiating module "detail" from file /etc/freeradius/modules/detail detail { detailfile = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d" header = "%t" detailperm = 384 dirperm = 493 locking = no log_packet_header = no } Module: Linked to module rlm_radutmp Module: Instantiating module "radutmp" from file /etc/freeradius/modules/radutmp radutmp { filename = "/var/log/freeradius/radutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes perm = 384 callerid = yes } Module: Checking session {...} for more modules to load Module: Checking post-proxy {...} for more modules to load Module: Checking post-auth {...} for more modules to load Module: Linked to module rlm_attr_filter Module: Instantiating module "attr_filter.access_reject" from file /etc/freeradius/modules/attr_filter attr_filter attr_filter.access_reject { attrsfile = "/etc/freeradius/attrs.access_reject" key = "%{User-Name}" relaxed = no } reading pairlist file /etc/freeradius/attrs.access_reject } # modules } # server server inner-tunnel { # from file /etc/freeradius/sites-enabled/inner-tunnel modules { Module: Checking authenticate {...} for more modules to load Module: Linked to module rlm_unix Module: Instantiating module "unix" from file /etc/freeradius/modules/unix unix { radwtmp = "/var/log/freeradius/radwtmp" } Module: Checking authorize {...} for more modules to load Module: Checking session {...} for more modules to load Module: Checking post-proxy {...} for more modules to load Module: Checking post-auth {...} for more modules to load } # modules } # server radiusd: #### Opening IP addresses and Ports #### listen { type = "auth" ipaddr = * port = 0 } listen { type = "acct" ipaddr = * port = 0 } listen { type = "auth" ipaddr = 127.0.0.1 port = 18120 } ... adding new socket proxy address * port 51758 Listening on authentication address * port 1812 Listening on accounting address * port 1813 Listening on authentication address 127.0.0.1 port 18120 as server inner-tunnel Listening on proxy address * port 1814 Ready to process requests. Packet 0 rad_recv: Access-Request packet from host 217.162.186.120 port 34319, id=27, length=282 NAS-Port-Type = Wireless-802.11 Calling-Station-Id = "D0:59:E4:08:F3:82" Called-Station-Id = "Zurich-tests" NAS-Port-Id = "ether5" User-Name = "escalanterj(a)gmail.com" NAS-Port = 2154823697 Acct-Session-Id = "80700011" Framed-IP-Address = 192.168.10.6 Mikrotik-Host-IP = 192.168.10.6 User-Password = "d41d8cd98f00b204e9800998ecf8427e81dc9bdb52d04dc20036dbd8313ed055d41d8cd98f00b204e9800998ecf8427e" Service-Type = Login-User WISPr-Logoff-URL = "http://192.168.10.1/logout" NAS-Identifier = "Zurich-tests" NAS-IP-Address = 192.168.0.119 # Executing section authorize from file /etc/freeradius/radiusd.conf +group authorize { ++[preprocess] = ok ++[chap] = noop ++[mschap] = noop [suffix] Looking up realm "gmail.com" for User-Name = "escalanterj(a)gmail.com" [suffix] No such realm "gmail.com" ++[suffix] = noop [eap] No EAP-Message, not doing EAP ++[eap] = noop [sql] expand: %{User-Name} -> escalanterj(a)gmail.com [sql] sql_set_user escaped user --> 'escalanterj(a)gmail.com' 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 = 'escalanterj(a)gmail.com' 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 = 'escalanterj(a)gmail.com' ORDER BY id [sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = 'escalanterj(a)gmail.com' 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 = 'permanent' ORDER BY id [sql] User found in group permanent [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 = 'permanent' ORDER BY id rlm_sql (sql): Released sql socket id: 4 ++[sql] = ok [pap] WARNING: Auth-Type already set. Not setting to PAP ++[pap] = noop rlm_sqlcounter: Entering module authorize code WARNING: Please replace '%k' with '${key}' sqlcounter_expand: 'SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='%{User-Name}'' [noresetcounter] expand: SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='%{User-Name}' -> SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='escalanterj(a)gmail.com' WARNING: Please replace '%S' with '${sqlmod-inst}' sqlcounter_expand: '%{sql:SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='escalanterj(a)gmail.com'}' [noresetcounter] sql_xlat [noresetcounter] expand: %{User-Name} -> escalanterj(a)gmail.com [noresetcounter] sql_set_user escaped user --> 'escalanterj(a)gmail.com' [noresetcounter] expand: SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='escalanterj(a)gmail.com' -> SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='escalanterj(a)gmail.com' rlm_sql (sql): Reserving sql socket id: 3 [noresetcounter] sql_xlat finished rlm_sql (sql): Released sql socket id: 3 [noresetcounter] expand: %{sql:SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='escalanterj(a)gmail.com'} -> 14 rlm_sqlcounter: Check item is greater than query result rlm_sqlcounter: Authorized user escalanterj(a)gmail.com, check_item=1316134911, counter=14 rlm_sqlcounter: Sent Reply-Item for user escalanterj(a)gmail.com, Type=Session-Timeout, value=1080000000 ++[noresetcounter] = ok rlm_sqlcounter: Entering module authorize code rlm_sqlcounter: Could not find Check item value pair ++[accessperiod] = noop +} # group authorize = ok Found Auth-Type = PAP # Executing group from file /etc/freeradius/radiusd.conf +group PAP { [pap] login attempt with password "d41d8cd98f00b204e9800998ecf8427e81dc9bdb52d04dc20036dbd8313ed055d41d8cd98f00b204e9800998ecf8427e" [pap] Using clear text password "2a2c72271ce06ddb38ddb3acd6398e41" [pap] Passwords don't match ++[pap] = reject +} # group PAP = reject Failed to authenticate the user. Using Post-Auth-Type REJECT # Executing group from file /etc/freeradius/sites-enabled/default +group REJECT { [attr_filter.access_reject] expand: %{User-Name} -> escalanterj(a)gmail.com attr_filter: Matched entry DEFAULT at line 11 ++[attr_filter.access_reject] = updated +} # group REJECT = updated Delaying reject of request 0 for 1 seconds Going to the next request Waking up in 0.9 seconds. Sending delayed reject for request 0 Sending Access-Reject of id 27 to 217.162.186.120 port 34319

3 2