- Freeradius-Users - lists.freeradius.org

(no subject)
by Saurabh Lahoti 26 May '18

26 May '18

Dear Alan, Below is the configuration for wifi virtual server: specific to post-auth section post-auth { if( Airespace-Wlan-Id == 2 ) { if( "%{control:LDAP-UserDN}" =~ /ou=guest,ou=wifi,o=mydomain.com$/i ) { noop } elsif( LDAP_Group == "cn=WiFiGuestPartners,ou=RADIUS Groups,ou=Groups,ou=staff,o=mydomain.com") { noop } else { reject } } LDAP module config: # -*- text -*- # # $Id$ # # Lightweight Directory Access Protocol (LDAP) # ldap ldapwifi { # Note that this needs to match the name(s) in the LDAP server # certificate, if you're using ldaps. See OpenLDAP documentation # for the behavioral semantics of specifying more than one host. # # Depending on the libldap in use, server may be an LDAP URI. # In the case of OpenLDAP this allows additional the following # additional schemes: # - ldaps:// (LDAP over SSL) # - ldapi:// (LDAP over Unix socket) # - ldapc:// (Connectionless LDAP) server = 'ldapcorp.ux.mydomain.com' # server = 'ldap.rrdns.example.org' # server = 'ldap.rrdns.example.org' # Port to connect on, defaults to 389, will be ignored for LDAP URIs. port = 389 # Administrator account for searching and possibly modifying. # If using SASL + KRB5 these should be commented out. identity = 'uid=wifiadmin,ou=production,ou=system,o=mydomain.com' password = xxxxxxx # Unless overridden in another section, the dn from which all # searches will start from. base_dn = 'o=mydomain.com' # # SASL parameters to use for admin binds # # When we're prompted by the SASL library, these control # the responses given, as well as the identity and password # directives above. # # If any directive is commented out, a NULL response will be # provided to cyrus-sasl. # # Unfortunately the only way to control Keberos here is through # environmental variables, as cyrus-sasl provides no API to # set the krb5 config directly. # # Full documentation for MIT krb5 can be found here: # # http://web.mit.edu/kerberos/krb5-devel/doc/admin/env_variables.html # # At a minimum you probably want to set KRB5_CLIENT_KTNAME. # # sasl { # SASL mechanism # mech = 'PLAIN' # SASL authorisation identity to proxy. # proxy = 'autz_id' # SASL realm. Used for kerberos. # realm = 'example.org' # } # # Generic valuepair attribute # # If set, this will attribute will be retrieved in addition to any # mapped attributes. # # Values should be in the format: # <radius attr> <op> <value> # # Where: # <radius attr>: Is the attribute you wish to create # with any valid list and request qualifiers. # <op>: Is any assignment operator (=, :=, +=, -=). # <value>: Is the value to parse into the new valuepair. # If the value is wrapped in double quotes it # will be xlat expanded. # valuepair_attribute = 'radiusAttribute' # # Mapping of LDAP directory attributes to RADIUS dictionary attributes. # # WARNING: Although this format is almost identical to the unlang # update section format, it does *NOT* mean that you can use other # unlang constructs in module configuration files. # # Configuration items are in the format: # <radius attr> <op> <ldap attr> # # Where: # <radius attr>: Is the destination RADIUS attribute # with any valid list and request qualifiers. # <op>: Is any assignment attribute (=, :=, +=, -=). # <ldap attr>: Is the attribute associated with user or # profile objects in the LDAP directory. # If the attribute name is wrapped in double # quotes it will be xlat expanded. # # Request and list qualifiers may also be placed after the 'update' # section name to set defaults destination requests/lists # for unqualified RADIUS attributes. # # Note: LDAP attribute names should be single quoted unless you want # the name value to be derived from an xlat expansion, or an # attribute ref. update { control:Password-With-Header += 'userPassword' # control:NT-Password := 'ntPassword' # reply:Reply-Message := 'radiusReplyMessage' # reply:Tunnel-Type := 'radiusTunnelType' # reply:Tunnel-Medium-Type := 'radiusTunnelMediumType' # reply:Tunnel-Private-Group-ID := 'radiusTunnelPrivategroupId' # Where only a list is specified as the RADIUS attribute, # the value of the LDAP attribute is parsed as a valuepair # in the same format as the 'valuepair_attribute' (above). control: += 'radiusControlAttribute' request: += 'radiusRequestAttribute' reply: += 'radiusReplyAttribute' } # Set to yes if you have eDirectory and want to use the universal # password mechanism. # edir = no # Set to yes if you want to bind as the user after retrieving the # Cleartext-Password. This will consume the login grace, and # verify user authorization. # edir_autz = no # Note: set_auth_type was removed in v3.x.x # Equivalent functionality can be achieved by adding the following # stanza to the authorize {} section of your virtual server. # # ldap # if ((ok || updated) && User-Password) { # update { # control:Auth-Type := ldap # } # } # # User object identification. # user { # Where to start searching in the tree for users base_dn = "${..base_dn}" # Filter for user objects, should be specific enough # to identify a single user object. # # For Active Directory, you should use # "samaccountname=" instead of "uid=" # filter = "(uid=%{%{Stripped-User-Name}:-%{User-Name}})" # SASL parameters to use for user binds # # When we're prompted by the SASL library, these control # the responses given. # # Any of the config items below may be an attribute ref # or and expansion, so different SASL mechs, proxy IDs # and realms may be used for different users. # sasl { # SASL mechanism # mech = 'PLAIN' # SASL authorisation identity to proxy. # proxy = &User-Name # SASL realm. Used for kerberos. # realm = 'example.org' # } # Search scope, may be 'base', 'one', sub' or 'children' scope = 'sub' # Server side result sorting # # A list of space delimited attributes to order the result # set by, if the filter matches multiple objects. # Only the first result in the set will be processed. # # If the attribute name is prefixed with a hyphen '-' the # sorting order will be reversed for that attribute. # # If sort_by is set, and the server does not support sorting # the search will fail. # sort_by = '-uid' # If this is undefined, anyone is authorised. # If it is defined, the contents of this attribute # determine whether or not the user is authorised # access_attribute = 'dialupAccess' # Control whether the presence of 'access_attribute' # allows access, or denys access. # # If 'yes', and the access_attribute is present, or # 'no' and the access_attribute is absent then access # will be allowed. # # If 'yes', and the access_attribute is absent, or # 'no' and the access_attribute is present, then # access will not be allowed. # # If the value of the access_attribute is 'false', it # will negate the result. # # e.g. # access_positive = yes # access_attribute = userAccessAllowed # # With an LDAP object containing: # userAccessAllowed: false # # Will result in the user being locked out. # access_positive = yes } # # User membership checking. # group { # Where to start searching in the tree for groups base_dn = "${..base_dn}" # Filter for group objects, should match all available # group objects a user might be a member of. filter = '(&(objectClass=GroupOfUniqueNames)(uniquemember=%{control:LDAP-UserDN}))' # Search scope, may be 'base', 'one', sub' or 'children' scope = 'sub' # Attribute that uniquely identifies a group. # Is used when converting group DNs to group # names. name_attribute = cn # Filter to find group objects a user is a member of. # That is, group objects with attributes that # identify members (the inverse of membership_attribute). membership_filter = "(|(&(objectClass=group)(member=%{control:Ldap-UserDn})))" # The attribute in user objects which contain the names # or DNs of groups a user is a member of. # # Unless a conversion between group name and group DN is # needed, there's no requirement for the group objects # referenced to actually exist. # membership_attribute = 'memberOf' # If cacheable_name or cacheable_dn are enabled, # all group information for the user will be # retrieved from the directory and written to LDAP-Group # attributes appropriate for the instance of rlm_ldap. # # For group comparisons these attributes will be checked # instead of querying the LDAP directory directly. # # This feature is intended to be used with rlm_cache. # # If you wish to use this feature, you should enable # the type that matches the format of your check items # i.e. if your groups are specified as DNs then enable # cacheable_dn else enable cacheable_name. # cacheable_name = 'no' # cacheable_dn = 'no' # Override the normal cache attribute (<inst>-LDAP-Group or # LDAP-Group if using the default instance) and create a # custom attribute. This can help if multiple module instances # are used in fail-over. # cache_attribute = 'LDAP-Cached-Membership' } # # User profiles. RADIUS profile objects contain sets of attributes # to insert into the request. These attributes are mapped using # the same mapping scheme applied to user objects (the update section above). # # profile { # Filter for RADIUS profile objects # filter = '(objectclass=radiusprofile)' # The default profile. This may be a DN or an attribute # reference. # To get old v2.2.x style behaviour, or to use the # &User-Profile attribute to specify the default profile, # set this to &control:User-Profile. # default = 'cn=radprofile,dc=example,dc=org' # The LDAP attribute containing profile DNs to apply # in addition to the default profile above. These are # retrieved from the user object, at the same time as the # attributes from the update section, are are applied # if authorization is successful. # attribute = 'radiusProfileDn' # } # # Bulk load clients from the directory # # client { # Where to start searching in the tree for clients # base_dn = "${..base_dn}" # # Filter to match client objects # # filter = '(objectClass=radiusClient)' # Search scope, may be 'base', 'one', 'sub' or 'children' # scope = 'sub' # # Sets default values (not obtained from LDAP) for new client entries # # template { # login = 'test' # password = 'test' # proto = tcp # require_message_authenticator = yes # Uncomment to add a home_server with the same # attributes as the client. # coa_server { # response_window = 2.0 # } # } # # Client attribute mappings are in the format: # <client attribute> = <ldap attribute> # # The following attributes are required: # * ipaddr | ipv4addr | ipv6addr - Client IP Address. # * secret - RADIUS shared secret. # # All other attributes usually supported in a client # definition are also supported here. # # Schemas are available in doc/schemas/ldap for openldap and eDirectory # # attribute { # ipaddr = 'radiusClientIdentifier' # secret = 'radiusClientSecret' # shortname = 'radiusClientShortname' # nas_type = 'radiusClientType' # virtual_server = 'radiusClientVirtualServer' # require_message_authenticator = 'radiusClientRequireMa' # } # } # Load clients on startup # read_clients = no # # Modify user object on receiving Accounting-Request # # Useful for recording things like the last time the user logged # in, or the Acct-Session-ID for CoA/DM. # # LDAP modification items are in the format: # <ldap attr> <op> <value> # # Where: # <ldap attr>: The LDAP attribute to add modify or delete. # <op>: One of the assignment operators: # (:=, +=, -=, ++). # Note: '=' is *not* supported. # <value>: The value to add modify or delete. # # WARNING: If using the ':=' operator with a multi-valued LDAP # attribute, all instances of the attribute will be removed and # replaced with a single attribute. accounting { reference = "%{tolower:type.%{Acct-Status-Type}}" type { start { update { description := "Online at %S" } } interim-update { update { description := "Last seen at %S" } } stop { update { description := "Offline at %S" } } } } # # Post-Auth can modify LDAP objects too # post-auth { update { description := "Authenticated at %S" } } # # LDAP connection-specific options. # # These options set timeouts, keep-alives, etc. for the connections. # options { # Control under which situations aliases are followed. # May be one of 'never', 'searching', 'finding' or 'always' # default: libldap's default which is usually 'never'. # # LDAP_OPT_DEREF is set to this value. # dereference = 'always' # # The following two configuration items control whether the # server follows references returned by LDAP directory. # They are mostly for Active Directory compatibility. # If you set these to 'no', then searches will likely return # 'operations error', instead of a useful result. # chase_referrals = yes rebind = yes # SASL Security Properties (see SASL_SECPROPS in ldap.conf man page). # Note - uncomment when using GSS-API sasl mechanism along with TLS # encryption against Active-Directory LDAP servers (this disables # sealing and signing at the GSS level as required by AD). #sasl_secprops = 'noanonymous,noplain,maxssf=0' # Seconds to wait for LDAP query to finish. default: 20 res_timeout = 10 # Seconds LDAP server has to process the query (server-side # time limit). default: 20 # # LDAP_OPT_TIMELIMIT is set to this value. srv_timelimit = 3 # Seconds to wait for response of the server. (network # failures) default: 10 # # LDAP_OPT_NETWORK_TIMEOUT is set to this value. net_timeout = 1 # LDAP_OPT_X_KEEPALIVE_IDLE idle = 60 # LDAP_OPT_X_KEEPALIVE_PROBES probes = 3 # LDAP_OPT_X_KEEPALIVE_INTERVAL interval = 3 # ldap_debug: debug flag for LDAP SDK # (see OpenLDAP documentation). Set this to enable # huge amounts of LDAP debugging on the screen. # You should only use this if you are an LDAP expert. # # default: 0x0000 (no debugging messages) # Example:(LDAP_DEBUG_FILTER+LDAP_DEBUG_CONNS) ldap_debug = 0x0028 } # # This subsection configures the tls related items # that control how FreeRADIUS connects to an LDAP # server. It contains all of the 'tls_*' configuration # entries used in older versions of FreeRADIUS. Those # configuration entries can still be used, but we recommend # using these. # tls { # Set this to 'yes' to use TLS encrypted connections # to the LDAP database by using the StartTLS extended # operation. # # The StartTLS operation is supposed to be # used with normal ldap connections instead of # using ldaps (port 636) connections start_tls = no # ca_file = ${certdir}/cacert.pem # ca_path = ${certdir} # certificate_file = /path/to/radius.crt # private_key_file = /path/to/radius.key # random_file = /dev/urandom # Certificate Verification requirements. Can be: # 'never' (do not even bother trying) # 'allow' (try, but don't fail if the certificate # cannot be verified) # 'demand' (fail if the certificate does not verify) # 'hard' (similar to 'demand' but fails if TLS # cannot negotiate) # # The default is libldap's default, which varies based # on the contents of ldap.conf. # require_cert = 'demand' } # As of version 3.0, the 'pool' section has replaced the # following configuration items: # # ldap_connections_number # The connection pool is new for 3.0, and will be used in many # modules, for all kinds of connection-related activity. # # When the server is not threaded, the connection pool # limits are ignored, and only one connection is used. pool { # Connections to create during module instantiation. # If the server cannot create specified number of # connections during instantiation it will exit. # Set to 0 to allow the server to start without the # directory being available. start = ${thread[pool].start_servers} # Minimum number of connections to keep open min = ${thread[pool].min_spare_servers} # Maximum number of connections # # If these connections are all in use and a new one # is requested, the request will NOT get a connection. # # Setting 'max' to LESS than the number of threads means # that some threads may starve, and you will see errors # like 'No connections available and at max connection limit' # # Setting 'max' to MORE than the number of threads means # that there are more connections than necessary. max = ${thread[pool].max_servers} # Spare connections to be left idle # # NOTE: Idle connections WILL be closed if "idle_timeout" # is set. This should be less than or equal to "max" above. spare = ${thread[pool].max_spare_servers} # Number of uses before the connection is closed # # 0 means "infinite" uses = 0 # The number of seconds to wait after the server tries # to open a connection, and fails. During this time, # no new connections will be opened. retry_delay = 30 # The lifetime (in seconds) of the connection lifetime = 0 # Idle timeout (in seconds). A connection which is # unused for this length of time will be closed. idle_timeout = 60 # NOTE: All configuration settings are enforced. If a # connection is closed because of 'idle_timeout', # 'uses', or 'lifetime', then the total number of # connections MAY fall below 'min'. When that # happens, it will open a new connection. It will # also log a WARNING message. # # The solution is to either lower the 'min' connections, # or increase lifetime/idle_timeout. } } ERROR received: (0) if ( Airespace-Wlan-Id == 2 ) { (0) if ( Airespace-Wlan-Id == 2 ) -> TRUE (0) if ( Airespace-Wlan-Id == 2 ) { (0) if ( "%{control:LDAP-UserDN}" =~ /ou=guest,ou=wifi,o= mydomain.com$/i ) { (0) EXPAND %{control:LDAP-UserDN} (0) --> uid=u5496622,ou=Techmahindra,ou=Partners,o= mydomain.com (0) if ( "%{control:LDAP-UserDN}" =~ /ou=guest,ou=wifi,o= mydomain.com $/i ) -> FALSE (0) elsif ( LDAP_Group == "cn=WiFiGuestPartners,ou=RADIUS Groups,ou=Groups,ou=staff,o=mydomain.com" ) { (0) elsif ( LDAP_Group == "cn=WiFiGuestPartners,ou=RADIUS Groups,ou=Groups,ou=staff,o=mydomain.com ) -> FALSE (0) else { (0) [reject] = reject (0) } # else = reject (0) } # if ( Airespace-Wlan-Id == 2 ) = reject (0) } # post-auth = reject (0) Using Post-Auth-Type Reject Probably, radius isn't able to glance into the LDAP group & search for uid. Perhaps, query syntax is wrong or incorrect. Could you please help with correct syntax..? ---- *Thanks & Kind Regards,* Saurabh LAHOTI.

2 1

Re: problem with table radacct column acctstarttime acctstoptime
by Alexandr 24 May '18

24 May '18

On 24.05.2018 11:59, Alexandr wrote: > I found function strftime, i think it writes time , but i found error > contain strftime > > (12) sql: ERROR: rlm_sql_mysql: ERROR 1305 (FUNCTION > radius_serv.strftime does not exist): 42000 > (12) sql: SQL query returned: server error > > How do fix it? > > some sql queries ( insert / update) > > INSERT: > > rlm_sql (sql): Reserved connection (0) > (11) sql: EXPAND %{User-Name} > (11) sql: --> systemn > (11) sql: SQL-User-Name set to 'systemn' > (11) sql: EXPAND INSERT INTO radacct (acctsessionid, acctuniqueid, > username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, > acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, > connectinfo_start, connectinfo_stop, acctinputoctets, > acctoutputoctets, calledstationid, callingstationid, > acctterminatecause, servicetype, framedprotocol, framedipaddress) > VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', > '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', > '%{%{NAS-Port-ID}:-%{NAS-Port}}', '%{NAS-Port-Type}', > %{%{integer:Event-Timestamp}:-date('now')}, > %{%{integer:Event-Timestamp}:-date('now')}, NULL, '0', > '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', > '%{Called-Station-Id}', '%{Calling-Station-Id}', '', > '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}') > > (11) sql: --> INSERT INTO radacct (acctsessionid, acctuniqueid, > username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, > acctupdatetime, acctstoptime, acctsessiontime, acctauthentic, > connectinfo_start, connectinfo_stop, acctinputoctets, > acctoutputoctets, calledstationid, callingstationid, > acctterminatecause, servicetype, framedprotocol, framedipaddress) > VALUES ('8D3C0B6681A85E4F', '4884926a9a6b3dadbdd270f22e5fd4c4', > 'systemn', '', '192.168.10.26', '2', 'Wireless-802.11', 1527148106, > 1527148106, NULL, '0', 'RADIUS', 'CONNECT 54Mbps 802.11g', '', '0', > '0', '60-E3-27-72-BF-5A:DEvChata_new', '38-2D-D1-32-61-1E', '', > 'Framed-User', '', '') > > (11) sql: Executing query: INSERT INTO radacct (acctsessionid, > acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, > acctstarttime, acctupdatetime, acctstoptime, acctsessiontime, > acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, > acctoutputoctets, calledstationid, callingstationid, > acctterminatecause, servicetype, framedprotocol, framedipaddress) > VALUES ('8D3C0B6681A85E4F', '4884926a9a6b3dadbdd270f22e5fd4c4', > 'systemn', '', '192.168.10.26', '2', 'Wireless-802.11', 1527148106, > 1527148106, NULL, '0', 'RADIUS', 'CONNECT 54Mbps 802.11g', '', '0', > '0', '60-E3-27-72-BF-5A:DEvChata_new', '38-2D-D1-32-61-1E', '', > 'Framed-User', '', '') > (11) sql: SQL query returned: success > (11) sql: 1 record(s) updated > > > UPDATE: > rlm_sql (sql): Reserved connection (1) > (13) sql: EXPAND %{User-Name} > (13) sql: --> systemn > (13) sql: SQL-User-Name set to 'systemn' > (13) sql: EXPAND UPDATE radacct SET acctstoptime = > %{%{integer:Event-Timestamp}:-date('now')}, acctsessiontime = > %{%{Acct-Session-Time}:-NULL}, acctinputoctets = > %{%{Acct-Input-Gigawords}:-0} << 32 | %{%{Acct-Input-Octets}:-0}, > acctoutputoctets = %{%{Acct-Output-Gigawords}:-0} << 32 | > %{%{Acct-Output-Octets}:-0}, acctterminatecause = > '%{Acct-Terminate-Cause}', connectinfo_stop = '%{Connect-Info}' WHERE > AcctUniqueId = '%{Acct-Unique-Session-Id}' > > (13) sql: --> UPDATE radacct SET acctstoptime = 1527150519, > acctsessiontime = 36, acctinputoctets = 0 << 32 | 282380, > acctoutputoctets = 0 << 32 | 1486385, acctterminatecause = > 'User-Request', connectinfo_stop = 'CONNECT 54Mbps 802.11g' WHERE > AcctUniqueId = '4ac1349d1e910f79fba700d0d1a1abba' > > (13) sql: Executing query: UPDATE radacct SET acctstoptime = > 1527150519, acctsessiontime = 36, acctinputoctets = 0 << 32 | > 282380, acctoutputoctets = 0 << 32 | 1486385, acctterminatecause = > 'User-Request', connectinfo_stop = 'CONNECT 54Mbps 802.11g' WHERE > AcctUniqueId = '4ac1349d1e910f79fba700d0d1a1abba' > > rlm_sql_mysql: Rows matched: 1 Changed: 1 Warnings: 1 > (13) sql: SQL query returned: success > (13) sql: 1 record(s) updated > > > > On 23.05.2018 13:51, Alan DeKok wrote: >> On May 23, 2018, at 4:00 AM, Alexandr<systemn17088(a)gmail.com> wrote: >>> freeradius -v3.0.18 >>> >>> Instead db mysql in table radacct shows incorrect time column acctstartime and acctstoptime in v.3 , if I will use v.2 or v.4 it will be ok. It's a bug ? >> Those times are created by the access point. FreeRADIUS just writes them to the database. >> >> Run the server in debugging mode to see what's going on. >> >> Alan DeKok. >> >> >> - >> List info/subscribe/unsubscribe? Seehttp://www.freeradius.org/list/users.html >

2 1

(no subject)
by Saurabh Lahoti 24 May '18

24 May '18

Dear Alan, Below is our ldap module config: ldap ldapwifi1 { server = "192.168.154.33" identity = "uid=wifitest,ou=production,ou=system,o=domain.com" password = xxxxxx basedn = "o=domain.com" filter = "(&(uid=%{Stripped-User-Name:-%{User-Name}})(!(nsaccountlock=true)))" base_filter = "(objectclass=*)" groupmembership_filter = "(&(objectClass=GroupOfUniqueNames)(uniquemember=%{control:Ldap-UserDn}))" ldap_connections_number = 5 timeout = 10 timelimit = 9 net_timeout = 10 tls { start_tls = no } dictionary_mapping = ${confdir}/ldap.attrmap Framed-Ip-Address = ipaddress edir_account_policy_check = no } ldap ldapwifi2 { server = "192.168.154.34" identity = "uid=wifitest,ou=production,ou=system,o=domain.com" password = xxxxxx basedn = "o=mobistar.be" filter = "(&(uid=%{Stripped-User-Name:-%{User-Name}})(!(nsaccountlock=true)))" base_filter = "(objectclass=*)" groupmembership_filter = "(&(objectClass=GroupOfUniqueNames)(uniquemember=%{control:Ldap-UserDn}))" ldap_connections_number = 5 timeout = 10 timelimit = 9 net_timeout = 10 tls { start_tls = no } dictionary_mapping = ${confdir}/ldap.attrmap Framed-Ip-Address = ipaddress edir_account_policy_check = no } Below is my ldap server config in sites-enabled: server wifi { authorize { preprocess suffix # if ( Called-Station-id =~ /:OBE_Byod$/ ) { # eap_byod # } if( Called-Station-Id =~ /:OBE_Office$/ ) { eap } elsif( Airespace-Wlan-Id == 2 ) { redundant-load-balance { ldapwifi1 ldapwifi2 } } expiration logintime } authenticate { Auth-Type LDAP { redundant-load-balance { ldapwifi1 ldapwifi2 } } # Auth-Type eap_byod { # eap_byod #} Auth-Type eap { eap } } preacct { preprocess update request { FreeRADIUS-Acct-Session-Start-Time = "%{expr: %l - %{%{Acct-Session-Time}:-0} - %{%{Acct-Delay-Time}:-0}}" } acct_unique suffix } accounting { wifi linelog-session } session { } post-auth { if( Airespace-Wlan-Id == 2 ) { if( "%{control:LDAP-UserDN}" =~ /ou=guest,ou=wifi,o=domain.com$/i ) { noop } elsif( LDAP_Group == "cn=WiFiGuestPartners,ou=RADIUS Groups,ou=Groups,ou=staff,o=domain.com" ) { noop } else { reject } } linelog-access # Post-Auth-Type REJECT { # linelog-access # attr_filter.access_reject # } } pre-proxy { } post-proxy { } } Could you please help where is the configuration wrong..? ---- *Thanks & Kind Regards,* Saurabh LAHOTI.

2 1

TLSMC: MozNSS compatibility interception begins message
by Chris Howley 23 May '18

23 May '18

Hello, We upgraded our test RADIUS server to use CentOS Linux release 7.5.1804 (Core) this morning and noticed the following messages in the /var/log/message file: May 23 09:04:05 XXXXXX systemd: Starting FreeRADIUS high performance RADIUS server.... May 23 09:04:05 XXXXXX radiusd: TLSMC: MozNSS compatibility interception begins. May 23 09:04:05 XXXXXX radiusd: tlsmc_convert: INFO: cannot open the NSS DB, expecting PEM configuration is present. May 23 09:04:05 XXXXXX radiusd: tlsmc_intercept_initialization: INFO: successfully intercepted TLS initialization. Continuing with OpenSSL only. May 23 09:04:05 XXXXXX radiusd: TLSMC: MozNSS compatibility interception ends. We're using FR 3.0.15. The current version of OpenSSL package is 1.0.2k-12. (previous version 1.0.2k-8). Please, could someone provide an explanation of these messages. Thanks, Chris Howley

3 3

Re: Error while authenticating users on Wifi.
by Saurabh Lahoti 23 May '18

23 May '18

Dear Alan, Rectified the clients.conf file & added clients configuration to it. Still, authentication fails with below error: (0) Received Access-Request Id 8 from 172.18.40.40:32774 to 192.168.154.96:1812 length 248 (0) User-Name = "wwwwww" (0) User-Password = "xxxxxx" (0) Service-Type = Login-User (0) NAS-IP-Address = 172.18.40.40 (0) NAS-Port = 13 (0) Cisco-AVPair = "audit-session-id=ac122828000653795b05b338" (0) Framed-IP-Address = 192.168.246.30 (0) Acct-Session-Id = "5b05b335/f4:0f:24:1a:89:35/447199" (0) NAS-Identifier = "BOR-WLC-01" (0) NAS-Port-Type = Wireless-802.11 (0) Airespace-Wlan-Id = 2 (0) Calling-Station-Id = "f4-0f-24-1a-89-35" (0) Called-Station-Id = "00-23-eb-26-f3-60:guest" (0) Message-Authenticator = 0x9fd55d37c61ac59b43dc5bae82c8470d (0) # Executing section authorize from file /usr/app/radius-new2/prod-corp-internal/etc/raddb/sites-enabled/wifi (0) authorize { (0) [preprocess] = ok (0) suffix: Checking for suffix after "@" (0) suffix: No '@' in User-Name = "wwwwww", looking up realm NULL (0) suffix: No such realm "NULL" (0) [suffix] = noop (0) if ( Called-Station-Id =~ /:SSID_Office$/ ) { (0) if ( Called-Station-Id =~ /:SSID_Office$/ ) -> FALSE (0) elsif ( Airespace-Wlan-Id == 2 ) { (0) elsif ( Airespace-Wlan-Id == 2 ) -> TRUE (0) elsif ( Airespace-Wlan-Id == 2 ) { (0) redundant-load-balance group { rlm_ldap (ldapwifi1): Closing connection (0): Hit idle_timeout, was idle for 272 seconds rlm_ldap (ldapwifi1): You probably need to lower "min" rlm_ldap (ldapwifi1): Closing connection (1): Hit idle_timeout, was idle for 272 seconds rlm_ldap (ldapwifi1): You probably need to lower "min" rlm_ldap (ldapwifi1): Closing connection (2): Hit idle_timeout, was idle for 272 seconds rlm_ldap (ldapwifi1): You probably need to lower "min" rlm_ldap (ldapwifi1): Closing connection (3): Hit idle_timeout, was idle for 272 seconds rlm_ldap (ldapwifi1): You probably need to lower "min" rlm_ldap (ldapwifi1): Closing connection (4): Hit idle_timeout, was idle for 272 seconds rlm_ldap (ldapwifi1): You probably need to lower "min" rlm_ldap (ldapwifi1): 0 of 0 connections in use. You may need to increase "spare" rlm_ldap (ldapwifi1): Opening additional connection (5), 1 of 10 pending slots used rlm_ldap (ldapwifi1): Connecting to ldap://192.168.154.33:389 rlm_ldap (ldapwifi1): Waiting for bind result... rlm_ldap (ldapwifi1): Bind successful rlm_ldap (ldapwifi1): Reserved connection (5) (0) ldapwifi1: Performing unfiltered search in "", scope "sub" (0) ldapwifi1: Waiting for search result... (0) ldapwifi1: The specified DN wasn't found (0) ldapwifi1: Search returned no results rlm_ldap (ldapwifi1): Released connection (5) Need 4 more connections to reach min connections (5) rlm_ldap (ldapwifi1): Opening additional connection (6), 1 of 9 pending slots used rlm_ldap (ldapwifi1): Connecting to ldap://192.168.154.33:389 rlm_ldap (ldapwifi1): Waiting for bind result... rlm_ldap (ldapwifi1): Bind successful (0) [ldapwifi1] = notfound (0) } # redundant-load-balance group = notfound (0) } # elsif ( Airespace-Wlan-Id == 2 ) = notfound (0) [expiration] = noop (0) [logintime] = noop (0) } # authorize = ok (0) ERROR: No Auth-Type found: rejecting the user via Post-Auth-Type = Reject (0) Failed to authenticate the user (0) Using Post-Auth-Type Reject (0) Post-Auth-Type sub-section not found. Ignoring. (0) # Executing group from file /usr/app/radius-new2/prod-corp-internal/etc/raddb/sites-enabled/wifi (0) Login incorrect (No Auth-Type found: rejecting the user via Post-Auth-Type = Reject): [wwwwww] (from client WLC1 port 13 cli f4-0f-24-1a-89-35) (0) Delaying response for 1.000000 seconds Waking up in 0.3 seconds. Waking up in 0.6 seconds. (0) Sending delayed response (0) Sent Access-Reject Id 8 from 192.168.154.96:1812 to 172.18.40.40:32774 length 20 Waking up in 3.9 seconds. (0) Cleaning up request packet ID 8 with timestamp +272 Could you please help in rectifying missing authorization config for radius server..? ---- *Thanks & Kind Regards,* Saurabh LAHOTI.

2 1

problem with table radacct column acctstarttime acctstoptime
by Alexandr 23 May '18

23 May '18

freeradius -v3.0.18 Instead db mysql in table radacct shows incorrect time column acctstartime and acctstoptime in v.3 , if I will use v.2 or v.4 it will be ok. It's a bug ? /var/log Tue May 22 14:10:14 2018 Acct-Status-Type = Start Acct-Authentic = RADIUS User-Name = "systemn" Called-Station-Id = "18-A6-F7-77-34-20:U_need?" NAS-Port-Type = Wireless-802.11 Service-Type = Framed-User NAS-Port = 1 Calling-Station-Id = "38-2D-D1-32-61-1E" Connect-Info = "CONNECT 54Mbps 802.11g" Acct-Session-Id = "50405B44E552BE9F" WLAN-Pairwise-Cipher = 1027076 WLAN-Group-Cipher = 1027076 WLAN-AKM-Suite = 1027073 Event-Timestamp = "May 22 2018 14:06:04 MSK" Acct-Delay-Time = 0 NAS-IP-Address = 192.168.1.3 Tmp-String-9 = "ai:" Acct-Unique-Session-Id = "4eebe6180c8f71124f48580c88965921" Timestamp = 1526987414 Tue May 22 16:06:56 2018 Acct-Status-Type = Stop Acct-Authentic = RADIUS User-Name = "systemn" Called-Station-Id = "18-A6-F7-77-34-20:U_need?" NAS-Port-Type = Wireless-802.11 Service-Type = Framed-User NAS-Port = 1 Calling-Station-Id = "38-2D-D1-32-61-1E" Connect-Info = "CONNECT 54Mbps 802.11g" Acct-Session-Id = "50405B44E552BE9F" WLAN-Pairwise-Cipher = 1027076 WLAN-Group-Cipher = 1027076 WLAN-AKM-Suite = 1027073 Event-Timestamp = "May 22 2018 16:02:46 MSK" Acct-Delay-Time = 0 Acct-Session-Time = 7002 Acct-Input-Packets = 3576 Acct-Output-Packets = 1851 Acct-Input-Octets = 429484 Acct-Input-Gigawords = 0 Acct-Output-Octets = 729649 Acct-Output-Gigawords = 0 NAS-IP-Address = 192.168.1.3 Tmp-String-9 = "ai:" Acct-Unique-Session-Id = "4eebe6180c8f71124f48580c88965921" Timestamp = 1526994416 On AP (access point openwrt) seted correct time MYSQL: mysql> select acctstarttime, acctsessiontime, acctstoptime, acctinputoctets, acctoutputoctets, acctsessionid from radacct; +---------------------+-----------------+---------------------+-----------------+------------------+------------------+ | acctstarttime | acctsessiontime | acctstoptime | acctinputoctets | acctoutputoctets | acctsessionid | +---------------------+-----------------+---------------------+-----------------+------------------+------------------+ | 0000-00-00 00:00:00 | 68 | 0000-00-00 00:00:00 | 38240 | 55976 | 6443639F657526A9 | | 0000-00-00 00:00:00 | 1982 | 0000-00-00 00:00:00 | 225720 | 340295 | 0E1A73B95E5440A2 | | 0000-00-00 00:00:00 | 37 | 0000-00-00 00:00:00 | 15182 | 17591 | 13A640668372BE96 | | 0000-00-00 00:00:00 | 7040 | 0000-00-00 00:00:00 | 214251 | 198763 | 7218BBDC869071C0 | | 0000-00-00 00:00:00 | 7034 | 0000-00-00 00:00:00 | 1258946 | 3001674 | 6F167E9A04670B6E | | 0000-00-00 00:00:00 | 7033 | 0000-00-00 00:00:00 | 2809545 | 50253172 | 5EBC5DA61E869DAE | | 0000-00-00 00:00:00 | 7002 | 0000-00-00 00:00:00 | 429484 | 729649 | 50405B44E552BE9F | | 0000-00-00 00:00:00 | 3882 | 0000-00-00 00:00:00 | 832739 | 4944760 | 4524CB7AF305309D | | 0000-00-00 00:00:00 | 0 | NULL | 0 | 0 | D0A7050D8D899789 | +---------------------+-----------------+---------------------+-----------------+------------------+------------------+ mysql> select now(); +---------------------+ | now() | +---------------------+ | 2018-05-23 10:34:46 | +---------------------+

3 2

problem with table radacct column acctstarttime acctstoptime
by Александр Михайлов 23 May '18

23 May '18

freeradius -v3.0.18 Instead db mysql in table radacct shows incorrect time column acctstartime and acctstoptime in v.3 , if I will use v.2 or v.4 it will be ok. It's a bug ? /var/log Tue May 22 14:10:14 2018 Acct-Status-Type = Start Acct-Authentic = RADIUS User-Name = "systemn" Called-Station-Id = "18-A6-F7-77-34-20:U_need?" NAS-Port-Type = Wireless-802.11 Service-Type = Framed-User NAS-Port = 1 Calling-Station-Id = "38-2D-D1-32-61-1E" Connect-Info = "CONNECT 54Mbps 802.11g" Acct-Session-Id = "50405B44E552BE9F" WLAN-Pairwise-Cipher = 1027076 WLAN-Group-Cipher = 1027076 WLAN-AKM-Suite = 1027073 Event-Timestamp = "May 22 2018 14:06:04 MSK" Acct-Delay-Time = 0 NAS-IP-Address = 192.168.1.3 Tmp-String-9 = "ai:" Acct-Unique-Session-Id = "4eebe6180c8f71124f48580c88965921" Timestamp = 1526987414 Tue May 22 16:06:56 2018 Acct-Status-Type = Stop Acct-Authentic = RADIUS User-Name = "systemn" Called-Station-Id = "18-A6-F7-77-34-20:U_need?" NAS-Port-Type = Wireless-802.11 Service-Type = Framed-User NAS-Port = 1 Calling-Station-Id = "38-2D-D1-32-61-1E" Connect-Info = "CONNECT 54Mbps 802.11g" Acct-Session-Id = "50405B44E552BE9F" WLAN-Pairwise-Cipher = 1027076 WLAN-Group-Cipher = 1027076 WLAN-AKM-Suite = 1027073 Event-Timestamp = "May 22 2018 16:02:46 MSK" Acct-Delay-Time = 0 Acct-Session-Time = 7002 Acct-Input-Packets = 3576 Acct-Output-Packets = 1851 Acct-Input-Octets = 429484 Acct-Input-Gigawords = 0 Acct-Output-Octets = 729649 Acct-Output-Gigawords = 0 NAS-IP-Address = 192.168.1.3 Tmp-String-9 = "ai:" Acct-Unique-Session-Id = "4eebe6180c8f71124f48580c88965921" Timestamp = 1526994416 On AP (access point openwrt) seted correct time MYSQL: mysql> select acctstarttime, acctsessiontime, acctstoptime, acctinputoctets, acctoutputoctets, acctsessionid from radacct; +---------------------+-----------------+---------------------+-----------------+------------------+------------------+ | acctstarttime | acctsessiontime | acctstoptime | acctinputoctets | acctoutputoctets | acctsessionid | +---------------------+-----------------+---------------------+-----------------+------------------+------------------+ | 0000-00-00 00:00:00 | 68 | 0000-00-00 00:00:00 | 38240 | 55976 | 6443639F657526A9 | | 0000-00-00 00:00:00 | 1982 | 0000-00-00 00:00:00 | 225720 | 340295 | 0E1A73B95E5440A2 | | 0000-00-00 00:00:00 | 37 | 0000-00-00 00:00:00 | 15182 | 17591 | 13A640668372BE96 | | 0000-00-00 00:00:00 | 7040 | 0000-00-00 00:00:00 | 214251 | 198763 | 7218BBDC869071C0 | | 0000-00-00 00:00:00 | 7034 | 0000-00-00 00:00:00 | 1258946 | 3001674 | 6F167E9A04670B6E | | 0000-00-00 00:00:00 | 7033 | 0000-00-00 00:00:00 | 2809545 | 50253172 | 5EBC5DA61E869DAE | | 0000-00-00 00:00:00 | 7002 | 0000-00-00 00:00:00 | 429484 | 729649 | 50405B44E552BE9F | | 0000-00-00 00:00:00 | 3882 | 0000-00-00 00:00:00 | 832739 | 4944760 | 4524CB7AF305309D | | 0000-00-00 00:00:00 | 0 | NULL | 0 | 0 | D0A7050D8D899789 | +---------------------+-----------------+---------------------+-----------------+------------------+------------------+ mysql> select now(); +---------------------+ | now() | +---------------------+ | 2018-05-23 10:34:46 | +---------------------+

1 0

REST Module vs Perl/Ruby REST
by Mohammad Mahefooz 22 May '18

22 May '18

I want to handle the authentication and authorisation on Nodejs server instead of SQL. Is it better to use rlm_rest module or use Perl/Ruby script and access REST within the script? The objective here is to select the most stable method. Is rlm_rest stable enough to get into production? Thanks Mohammad Mahefooz

3 5

Hide User-Password Attribute in eap_ttls and inner_tunnel
by Giorgos Tsirkas 22 May '18

22 May '18

Hello, Is there any way to hide User-Password attribute in logs when execute eap_ttls or inner-tunnel virtual server? /Tue May 22 15:04:32 2018 : Debug: (46) eap_ttls: [eaptls process] = ok// //Tue May 22 15:04:32 2018 : Debug: (46) eap_ttls: Session established. Proceeding to decode tunneled attributes// //Tue May 22 15:04:32 2018 : Debug: (46) eap_ttls: Got tunneled request// //Tue May 22 15:04:32 2018 : Debug: (46) eap_ttls: User-Name = "test_user"// //Tue May 22 15:04:32 2018 : Debug: (46) eap_ttls: User-Password = "test_password"// //Tue May 22 15:04:32 2018 : Debug: (46) eap_ttls: FreeRADIUS-Proxied-To = 127.0.0.1// //Tue May 22 15:04:32 2018 : Debug: (46) eap_ttls: Sending tunneled request// //Tue May 22 15:04:32 2018 : Debug: (46) Virtual server inner-tunnel received request// //Tue May 22 15:04:32 2018 : Debug: (46) User-Name = "test_user"// //Tue May 22 15:04:32 2018 : Debug: (46) User-Password = "test_password"// //Tue May 22 15:04:32 2018 : Debug: (46) FreeRADIUS-Proxied-To = 127.0.0.1// //Tue May 22 15:04:32 2018 : Debug: (46) NAS-IP-Address = 10.10.10.36// //Tue May 22 15:04:32 2018 : Debug: (46) NAS-Port-Type = Ethernet// //Tue May 22 15:04:32 2018 : Debug: (46) NAS-Port = 22// /

2 1

NAS Send Different Ip Address
by Muhammed Buvaydani 22 May '18

22 May '18

Hello I don't know if my quetion related to the list or not , but I must try because I have tried in many places without result . I have fortigate firewall which ip address is 10.10.0.88 and when I send authentication request or test request to freeradius freeradius Show error msg which contain ignore the request because comming from unknown ip address 77.25.44.22 . why that happend is the problem is in freeradius or firewall Thank you very much

1 0