- Freeradius-Users - lists.freeradius.org

rlm_cache NT-Password with EAP-PEAP
by Sherker, Donald 02 Mar '15

02 Mar '15

We are trying to setup a freeradius 3.0.7 server that uses EAP-PEAP and EAP-TTLS, both with MSCHAPv2. This server reads a users Cleartext-Password from an ldap server. In order to minimize the calls to the ldap server we are trying to use rlm_cache to cache the NT-Password and LM-Password so that when a user logs in after the initial log in freeradius does not need to query the ldap server. This works with EAP-TTLS, but it does not work with EAP-PEAP. The NT-Password and LM-Password do not seem to be available to the caching module with EAP-PEAP. I am pasting the parts of the config files related to this below. Please let me know if there is any other information needed. mods-enabled/cache: update { control:NT-Password := "%{control:NT-Password}" control:LM-Password := "%{control:LM-Password}" } mods-enabled/eap: eap { default_eap_type = peap ignore_unknown_eap_types = no ttls { tls = tls-common default_eap_type = mschapv2 copy_request_to_tunnel = no use_tunneled_reply = no virtual_server = "inner-tunnel" } peap { tls = tls-common default_eap_type = mschapv2 copy_request_to_tunnel = no use_tunneled_reply = no proxy_tunneled_request_as_eap = no virtual_server = "inner-tunnel" } } sites-enabled/inner-tunnel: authorize { eap { ok = return } update control { Cache-Status-Only = 'yes' } cache if (notfound) { ldap } else { cache } mschap } post-auth { cache } I am also posting excerpts from the debug, again if more is needed let me know. This is for en EAP-TTLS session: Tue Feb 24 16:32:57 2015 : Debug: (7) modsingle[post-auth]: calling cache (rlm_cache) for request 7 Tue Feb 24 16:32:57 2015 : Debug: %{User-Name}%{outer.request:Calling-Station-Id} Tue Feb 24 16:32:57 2015 : Debug: Parsed xlat tree: Tue Feb 24 16:32:57 2015 : Debug: attribute --> User-Name Tue Feb 24 16:32:57 2015 : Debug: attribute --> Calling-Station-Id Tue Feb 24 16:32:57 2015 : Debug: (7) cache: EXPAND %{User-Name}%{outer.request:Calling-Station-Id} Tue Feb 24 16:32:57 2015 : Debug: (7) cache: --> andyresd022be6e8229 Tue Feb 24 16:32:57 2015 : Debug: (7) cache: Mutex acquired Tue Feb 24 16:32:57 2015 : Debug: (7) cache: No cache entry found for "andyresd022be6e8229" Tue Feb 24 16:32:57 2015 : Debug: (7) cache: Creating new cache entry Tue Feb 24 16:32:57 2015 : Debug: %{control:NT-Password} Tue Feb 24 16:32:57 2015 : Debug: Parsed xlat tree: Tue Feb 24 16:32:57 2015 : Debug: attribute --> NT-Password Tue Feb 24 16:32:57 2015 : Debug: (7) cache: EXPAND %{control:NT-Password} Tue Feb 24 16:32:57 2015 : Debug: (7) cache: --> 0x927b45aa1c222ebeaad483703f11c465 Tue Feb 24 16:32:57 2015 : Debug: (7) cache: control:NT-Password := 0x927b45aa1c222ebeaad483703f11c465 Tue Feb 24 16:32:57 2015 : Debug: (7) cache: Merging cache entry into request Tue Feb 24 16:32:57 2015 : Debug: (7) cache: &control:NT-Password := 0x927b45aa1c222ebeaad483703f11c465 Tue Feb 24 16:32:57 2015 : Debug: (7) cache: ::: FROM 1 TO 6 MAX 7 Tue Feb 24 16:32:57 2015 : Debug: (7) cache: ::: Examining NT-Password Tue Feb 24 16:32:57 2015 : Debug: (7) cache: ::: OVERWRITING NT-Password FROM 0 TO 4 Tue Feb 24 16:32:57 2015 : Debug: (7) cache: ::: TO in 6 out 6 Tue Feb 24 16:32:57 2015 : Debug: (7) cache: ::: to[0] = Proxy-To-Realm Tue Feb 24 16:32:57 2015 : Debug: (7) cache: ::: to[1] = Ldap-UserDn Tue Feb 24 16:32:57 2015 : Debug: (7) cache: ::: to[2] = Cleartext-Password Tue Feb 24 16:32:57 2015 : Debug: (7) cache: ::: to[3] = Auth-Type Tue Feb 24 16:32:57 2015 : Debug: (7) cache: ::: to[4] = NT-Password Tue Feb 24 16:32:57 2015 : Debug: (7) cache: ::: to[5] = LM-Password Tue Feb 24 16:32:57 2015 : Debug: (7) cache: Commited entry, TTL 86400 seconds Tue Feb 24 16:32:57 2015 : Debug: (7) cache: Mutex released Tue Feb 24 16:32:57 2015 : Debug: (7) modsingle[post-auth]: returned from cache (rlm_cache) for request 7 Tue Feb 24 16:32:57 2015 : Debug: (7) [cache] = updated Tue Feb 24 16:32:57 2015 : Debug: (7) } # post-auth = updated Tue Feb 24 16:32:57 2015 : Debug: (7) } # server inner-tunnel This is for an EAP-PEAP Session: Tue Feb 24 16:34:57 2015 : Debug: (8) modsingle[post-auth]: calling cache (rlm_cache) for request 8 Tue Feb 24 16:34:57 2015 : Debug: %{User-Name}%{outer.request:Calling-Station-Id} Tue Feb 24 16:34:57 2015 : Debug: Parsed xlat tree: Tue Feb 24 16:34:57 2015 : Debug: attribute --> User-Name Tue Feb 24 16:34:57 2015 : Debug: attribute --> Calling-Station-Id Tue Feb 24 16:34:57 2015 : Debug: (8) cache: EXPAND %{User-Name}%{outer.request:Calling-Station-Id} Tue Feb 24 16:34:57 2015 : Debug: (8) cache: --> qaresdonE8-99-C4-72-33-D8 Tue Feb 24 16:34:57 2015 : Debug: (8) cache: Mutex acquired Tue Feb 24 16:34:57 2015 : Debug: (8) cache: No cache entry found for "qaresdonE8-99-C4-72-33-D8" Tue Feb 24 16:34:57 2015 : Debug: (8) cache: Creating new cache entry Tue Feb 24 16:34:57 2015 : Debug: %{control:NT-Password} Tue Feb 24 16:34:57 2015 : Debug: Parsed xlat tree: Tue Feb 24 16:34:57 2015 : Debug: attribute --> NT-Password Tue Feb 24 16:34:57 2015 : Debug: (8) cache: EXPAND %{control:NT-Password} Tue Feb 24 16:34:57 2015 : Debug: (8) cache: --> Tue Feb 24 16:34:57 2015 : Debug: (8) cache: control:NT-Password := 0x Tue Feb 24 16:34:57 2015 : Debug: %{control:LM-Password} Tue Feb 24 16:34:57 2015 : Debug: Parsed xlat tree: Tue Feb 24 16:34:57 2015 : Debug: attribute --> LM-Password Tue Feb 24 16:34:57 2015 : Debug: (8) cache: EXPAND %{control:LM-Password} Tue Feb 24 16:34:57 2015 : Debug: (8) cache: --> Tue Feb 24 16:34:57 2015 : Debug: (8) cache: control:LM-Password := 0x Tue Feb 24 16:34:57 2015 : Debug: (8) cache: Merging cache entry into request Tue Feb 24 16:34:57 2015 : Debug: (8) cache: &control:NT-Password := 0x Tue Feb 24 16:34:57 2015 : Debug: (8) cache: &control:LM-Password := 0x Tue Feb 24 16:34:57 2015 : Debug: (8) cache: ::: FROM 2 TO 4 MAX 6 Tue Feb 24 16:34:57 2015 : Debug: (8) cache: ::: Examining NT-Password Tue Feb 24 16:34:57 2015 : Debug: (8) cache: ::: APPENDING NT-Password FROM 0 TO 4 Tue Feb 24 16:34:57 2015 : Debug: (8) cache: ::: Examining LM-Password Tue Feb 24 16:34:57 2015 : Debug: (8) cache: ::: APPENDING LM-Password FROM 1 TO 5 Tue Feb 24 16:34:57 2015 : Debug: (8) cache: ::: TO in 4 out 6 Tue Feb 24 16:34:57 2015 : Debug: (8) cache: ::: to[0] = Proxy-To-Realm Tue Feb 24 16:34:57 2015 : Debug: (8) cache: ::: to[1] = Auth-Type Tue Feb 24 16:34:57 2015 : Debug: (8) cache: ::: to[2] = Ldap-UserDn Tue Feb 24 16:34:57 2015 : Debug: (8) cache: ::: to[3] = Cleartext-Password Tue Feb 24 16:34:57 2015 : Debug: (8) cache: ::: to[4] = NT-Password Tue Feb 24 16:34:57 2015 : Debug: (8) cache: ::: to[5] = LM-Password Tue Feb 24 16:34:57 2015 : Debug: (8) cache: Commited entry, TTL 86400 seconds Tue Feb 24 16:34:57 2015 : Debug: (8) cache: Mutex released ________________________________ CONFIDENTIALITY NOTICE: This e-mail may contain information that is privileged, confidential or otherwise protected from disclosure. **If you are not the intended recipient of this e-mail, please notify the sender immediately by return e-mail, purge it and do not disseminate or copy it.

4 16

RADIUS Monitoring tool
by Clement Ogedengbe 02 Mar '15

02 Mar '15

On two occasions in the last 2 weeks, our RADIUS server suddenly started to reject ALL users. Even though we have set up a failover system. Unfotunately, the fail-over system did not kick in because the RADIUS service was still running, only that it was rejecting all users for some strange reasons. Does anyone know of any monitoring script/tool that can be used to test that the RADIUS server is authenticating properly and which can send an alert by email or text in the event that the server rejects authentication of a valid user credentials a number of times. Best Regards Clement Ogedengbe -----Original Message----- From: Freeradius-Users [mailto:freeradius-users-bounces+c.ogedengbe=worc.ac.uk@lists.freeradius.org] On Behalf Of Tevfik Ceydeliler Sent: 25 February 2015 12:44 To: freeradius-users(a)lists.freeradius.org Subject: Re: GGSN/APN Freeradius and Proxy On 02/24/2015 06:00 PM, Alan DeKok wrote: > On Feb 24, 2015, at 10:14 AM, Tevfik Ceydeliler <tevfik.ceydeliler(a)astron.yasar.com.tr> wrote: >> I use Kobil Secovid as Motp , home server and its log very primitive like this: >> "Tue Feb 24 11:40:21 2015: sending reject for vantacgida4's query from 10.43.1.51" >> It not help me to understand why reject. > So… ask the Kobil people why their RADIUS server is broken. No support we paid :( > >> Differences are very obvious: > So… use FreeRADIUS to edit the proxied packet, so that it looks more like the one from radtest. That’s what the “pre-proxy” section is for. There are lots of examples and documentation for this. > >> rad_recv: Access-Request packet from host 172.30.80.1 port 24208, >> id=136, length=372 Comes from GGSN: >> Calling-Station-Id = "905344776557" >> User-Name = "vantacgida4” >> ... >> User-Password = "5080+00526417” > Does that name / password work for radtest? If not, then stop > wasting your time, and throw the home server in the garbage. Get one > that works, I cant test this use bec. It is reseller. But I create another user and can test it. ######################################################## root@radiuspnb:/etc/freeradius# radtest kivanccepel 475224928708 10.1.1.51 10 geheim Sending Access-Request of id 21 to 10.1.1.51 port 1812 User-Name = "kivanccepel" User-Password = "475224928708" NAS-IP-Address = 127.0.1.1 NAS-Port = 10 Message-Authenticator = 0x00000000000000000000000000000000 rad_recv: Access-Accept packet from host 10.1.1.51 port 1812, id=21, length=2 ########################################################### As you see it works. But from GGSN not work. I really wish to throw taht home-serve rto garbage. But more that 300 reseller connect via this home-server. OK lets change home server. I have another one for internal usage. In this case, ##################################################################33 ad_recv: Access-Request packet from host 172.30.80.1 port 24144, id=10, length=377 Calling-Station-Id = "905303630245" User-Name = "biryudumgida3" NAS-IP-Address = 172.30.80.1 NAS-Identifier = "MTCGGSNK3" Service-Type = Framed-User Framed-Protocol = GPRS-PDP-Context NAS-Port-Type = Wireless-Other 3GPP-IMSI = "286015918760926" 3GPP-IMSI-MCC-MNC = "28601" 3GPP-NSAPI = "5" 3GPP-Selection-Mode = "0" 3GPP-Charging-ID = 50711443 3GPP-GPRS-Negotiated-QoS-profile = "05-13921F7396F7FE74620846006400" 3GPP-Charging-Characteristics = "0800" Called-Station-Id = "yasarapn" 3GPP-SGSN-Address = 86.108.153.116 3GPP-SGSN-MCC-MNC = "28601" 3GPP-GGSN-Address = 86.108.153.126 3GPP-GGSN-MCC-MNC = "28601" 3GPP-Negotiated-DSCP = 18 3GPP-RAT-Type = 1 3GPP-Location-Info = 0x0182f610eb2acd62 3GPP-Attr-23 = 0x8020 3GPP-IMEISV = "9800670040325323" 3GPP-PDP-Type = 0 NAS-Port = 41524 User-Password = "645327067460" 3GPP-Charging-Gateway-Address = 10.200.211.27 # Executing section authorize from file /etc/freeradius/sites-enabled/default +- entering group authorize {...} ++[preprocess] returns ok ++[chap] returns noop ++[mschap] returns noop ++[digest] returns noop [suffix] No '@' in User-Name = "biryudumgida3", looking up realm NULL [suffix] No such realm "NULL" ++[suffix] returns noop [eap] No EAP-Message, not doing EAP ++[eap] returns noop ++[files] returns noop [sql] expand: %{User-Name} -> biryudumgida3 [sql] sql_set_user escaped user --> 'biryudumgida3' 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 = 'biryudumgida3' 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 = 'biryudumgida3' ORDER BY id [sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = 'biryudumgida3' 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 = 'UGR_TcellOtonomYBB-Secovid' ORDER BY id [sql] User found in group UGR_TcellOtonomYBB-Secovid [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 = 'UGR_TcellOtonomYBB-Secovid' ORDER BY id rlm_sql (sql): Released sql socket id: 4 ++[sql] returns ok ++[expiration] returns noop ++[logintime] returns noop ++[pap] returns noop WARNING: Empty pre-proxy section. Using default return values. Sending Access-Request of id 80 to 10.1.1.51 port 1812 Calling-Station-Id = "905303630245" User-Name = "biryudumgida3" NAS-IP-Address = 172.30.80.1 NAS-Identifier = "MTCGGSNK3" Service-Type = Framed-User Framed-Protocol = GPRS-PDP-Context NAS-Port-Type = Wireless-Other 3GPP-IMSI = "286015918760926" 3GPP-IMSI-MCC-MNC = "28601" 3GPP-NSAPI = "5" 3GPP-Selection-Mode = "0" 3GPP-Charging-ID = 50711443 3GPP-GPRS-Negotiated-QoS-profile = "05-13921F7396F7FE74620846006400" 3GPP-Charging-Characteristics = "0800" Called-Station-Id = "yasarapn" 3GPP-SGSN-Address = 86.108.153.116 3GPP-SGSN-MCC-MNC = "28601" 3GPP-GGSN-Address = 86.108.153.126 3GPP-GGSN-MCC-MNC = "28601" 3GPP-Negotiated-DSCP = 18 3GPP-RAT-Type = 1 3GPP-Location-Info = 0x0182f610eb2acd62 3GPP-Attr-23 = 0x8020 3GPP-IMEISV = "9800670040325323" 3GPP-PDP-Type = 0 NAS-Port = 41524 User-Password = "645327067460" 3GPP-Charging-Gateway-Address = 10.200.211.27 Proxy-State = 0x3130 Proxying request 4 to home server 10.1.1.51 port 1812 Sending Access-Request of id 80 to 10.1.1.51 port 1812 Calling-Station-Id = "905303630245" User-Name = "biryudumgida3" NAS-IP-Address = 172.30.80.1 NAS-Identifier = "MTCGGSNK3" Service-Type = Framed-User Framed-Protocol = GPRS-PDP-Context NAS-Port-Type = Wireless-Other 3GPP-IMSI = "286015918760926" 3GPP-IMSI-MCC-MNC = "28601" 3GPP-NSAPI = "5" 3GPP-Selection-Mode = "0" 3GPP-Charging-ID = 50711443 3GPP-GPRS-Negotiated-QoS-profile = "05-13921F7396F7FE74620846006400" 3GPP-Charging-Characteristics = "0800" Called-Station-Id = "yasarapn" 3GPP-SGSN-Address = 86.108.153.116 3GPP-SGSN-MCC-MNC = "28601" 3GPP-GGSN-Address = 86.108.153.126 3GPP-GGSN-MCC-MNC = "28601" 3GPP-Negotiated-DSCP = 18 3GPP-RAT-Type = 1 3GPP-Location-Info = 0x0182f610eb2acd62 3GPP-Attr-23 = 0x8020 3GPP-IMEISV = "9800670040325323" 3GPP-PDP-Type = 0 NAS-Port = 41524 User-Password = "645327067460" 3GPP-Charging-Gateway-Address = 10.200.211.27 Proxy-State = 0x3130 Going to the next request Waking up in 0.9 seconds. rad_recv: Access-Accept packet from host 10.1.1.51 port 1812, id=80, length=24 Proxy-State = 0x3130 # Executing section post-proxy from file /etc/freeradius/sites-enabled/default +- entering group post-proxy {...} [eap] No pre-existing handler found ++[eap] returns noop Found Auth-Type = Accept Auth-Type = Accept, accepting the user # Executing section post-auth from file /etc/freeradius/sites-enabled/default +- entering group post-auth {...} rlm_sql (sql): Reserving sql socket id: 3 [sqlippool] expand: %{User-Name} -> biryudumgida3 [sqlippool] sql_set_user escaped user --> 'biryudumgida3' [sqlippool] expand: START TRANSACTION -> START TRANSACTION [sqlippool] expand: UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NULL WHERE expiry_time <= NOW() - INTERVAL 1 SECOND AND nasipaddress = '%{Nas-IP-Address}' -> UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NULL WHERE expiry_time <= NOW() - INTERVAL 1 SECOND AND nasipaddress = '172.30.80.1' [sqlippool] expand: SELECT framedipaddress FROM radippool WHERE pool_name = '%{control:Pool-Name}' AND (expiry_time < NOW() OR expiry_time IS NULL) ORDER BY (username <> '%{User-Name}'), (callingstationid <> '%{Calling-Station-Id}'), expiry_time LIMIT 1 FOR UPDATE -> SELECT framedipaddress FROM radippool WHERE pool_name = 'IP_TcellOtonomYBB' AND (expiry_time < NOW() OR expiry_time IS NULL) ORDER BY (username <> 'biryudumgida3'), (callingstationid <> '905303630245'), expiry_time LIMIT 1 FOR UPDATE [sqlippool] expand: UPDATE radippool SET nasipaddress = '%{NAS-IP-Address}', pool_key = '%{NAS-Port}', callingstationid = '%{Calling-Station-Id}', username = '%{User-Name}', expiry_time = NOW() + INTERVAL 21600 SECOND WHERE framedipaddress = '172.30.64.190' AND expiry_time IS NULL -> UPDATE radippool SET nasipaddress = '172.30.80.1', pool_key = '41524', callingstationid = '905303630245', username = 'biryudumgida3', expiry_time = NOW() + INTERVAL 21600 SECOND WHERE framedipaddress = '172.30.64.190' AND expiry_time IS NULL [sqlippool] Allocated IP 172.30.64.190 [be401eac] [sqlippool] expand: COMMIT -> COMMIT rlm_sql (sql): Released sql socket id: 3 [sqlippool] expand: Allocated IP: %{reply:Framed-IP-Address} from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name}) -> Allocated IP: 172.30.64.190 from IP_TcellOtonomYBB (did yasarapn cli 905303630245 port 41524 user biryudumgida3) Allocated IP: 172.30.64.190 from IP_TcellOtonomYBB (did yasarapn cli 905303630245 port 41524 user biryudumgida3) ++[sqlippool] returns ok ++[exec] returns noop Sending Access-Accept of id 10 to 172.30.80.1 port 24144 Framed-IP-Address = 172.30.64.190 Finished request 4. Going to the next request Waking up in 4.9 seconds. Cleaning up request 4 ID 10 with timestamp +133 Ready to process requests. rad_recv: Access-Request packet from host 172.30.80.1 port 24144, id=10, length=377 Calling-Station-Id = "905303630245" User-Name = "biryudumgida3" NAS-IP-Address = 172.30.80.1 NAS-Identifier = "MTCGGSNK3" Service-Type = Framed-User Framed-Protocol = GPRS-PDP-Context NAS-Port-Type = Wireless-Other 3GPP-IMSI = "286015918760926" 3GPP-IMSI-MCC-MNC = "28601" 3GPP-NSAPI = "5" 3GPP-Selection-Mode = "0" 3GPP-Charging-ID = 50711443 3GPP-GPRS-Negotiated-QoS-profile = "05-13921F7396F7FE74620846006400" 3GPP-Charging-Characteristics = "0800" Called-Station-Id = "yasarapn" 3GPP-SGSN-Address = 86.108.153.116 3GPP-SGSN-MCC-MNC = "28601" 3GPP-GGSN-Address = 86.108.153.126 3GPP-GGSN-MCC-MNC = "28601" 3GPP-Negotiated-DSCP = 18 3GPP-RAT-Type = 1 3GPP-Location-Info = 0x0182f610eb2acd62 3GPP-Attr-23 = 0x8020 3GPP-IMEISV = "9800670040325323" 3GPP-PDP-Type = 0 NAS-Port = 41524 User-Password = "645327067460" 3GPP-Charging-Gateway-Address = 10.200.211.27 # Executing section authorize from file /etc/freeradius/sites-enabled/default +- entering group authorize {...} ++[preprocess] returns ok ++[chap] returns noop ++[mschap] returns noop ++[digest] returns noop [suffix] No '@' in User-Name = "biryudumgida3", looking up realm NULL [suffix] No such realm "NULL" ++[suffix] returns noop [eap] No EAP-Message, not doing EAP ++[eap] returns noop ++[files] returns noop [sql] expand: %{User-Name} -> biryudumgida3 [sql] sql_set_user escaped user --> 'biryudumgida3' rlm_sql (sql): Reserving sql socket id: 2 [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 = 'biryudumgida3' 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 = 'biryudumgida3' ORDER BY id [sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = 'biryudumgida3' 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 = 'UGR_TcellOtonomYBB-Secovid' ORDER BY id [sql] User found in group UGR_TcellOtonomYBB-Secovid [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 = 'UGR_TcellOtonomYBB-Secovid' ORDER BY id rlm_sql (sql): Released sql socket id: 2 ++[sql] returns ok ++[expiration] returns noop ++[logintime] returns noop ++[pap] returns noop WARNING: Empty pre-proxy section. Using default return values. Sending Access-Request of id 101 to 10.1.1.51 port 1812 Calling-Station-Id = "905303630245" User-Name = "biryudumgida3" NAS-IP-Address = 172.30.80.1 NAS-Identifier = "MTCGGSNK3" Service-Type = Framed-User Framed-Protocol = GPRS-PDP-Context NAS-Port-Type = Wireless-Other 3GPP-IMSI = "286015918760926" 3GPP-IMSI-MCC-MNC = "28601" 3GPP-NSAPI = "5" 3GPP-Selection-Mode = "0" 3GPP-Charging-ID = 50711443 3GPP-GPRS-Negotiated-QoS-profile = "05-13921F7396F7FE74620846006400" 3GPP-Charging-Characteristics = "0800" Called-Station-Id = "yasarapn" 3GPP-SGSN-Address = 86.108.153.116 3GPP-SGSN-MCC-MNC = "28601" 3GPP-GGSN-Address = 86.108.153.126 3GPP-GGSN-MCC-MNC = "28601" 3GPP-Negotiated-DSCP = 18 3GPP-RAT-Type = 1 3GPP-Location-Info = 0x0182f610eb2acd62 3GPP-Attr-23 = 0x8020 3GPP-IMEISV = "9800670040325323" 3GPP-PDP-Type = 0 NAS-Port = 41524 User-Password = "645327067460" 3GPP-Charging-Gateway-Address = 10.200.211.27 Proxy-State = 0x3130 Proxying request 5 to home server 10.1.1.51 port 1812 Sending Access-Request of id 101 to 10.1.1.51 port 1812 Calling-Station-Id = "905303630245" User-Name = "biryudumgida3" NAS-IP-Address = 172.30.80.1 NAS-Identifier = "MTCGGSNK3" Service-Type = Framed-User Framed-Protocol = GPRS-PDP-Context NAS-Port-Type = Wireless-Other 3GPP-IMSI = "286015918760926" 3GPP-IMSI-MCC-MNC = "28601" 3GPP-NSAPI = "5" 3GPP-Selection-Mode = "0" 3GPP-Charging-ID = 50711443 3GPP-GPRS-Negotiated-QoS-profile = "05-13921F7396F7FE74620846006400" 3GPP-Charging-Characteristics = "0800" Called-Station-Id = "yasarapn" 3GPP-SGSN-Address = 86.108.153.116 3GPP-SGSN-MCC-MNC = "28601" 3GPP-GGSN-Address = 86.108.153.126 3GPP-GGSN-MCC-MNC = "28601" 3GPP-Negotiated-DSCP = 18 3GPP-RAT-Type = 1 3GPP-Location-Info = 0x0182f610eb2acd62 3GPP-Attr-23 = 0x8020 3GPP-IMEISV = "9800670040325323" 3GPP-PDP-Type = 0 NAS-Port = 41524 User-Password = "645327067460" 3GPP-Charging-Gateway-Address = 10.200.211.27 Proxy-State = 0x3130 Going to the next request Waking up in 0.9 seconds. rad_recv: Access-Reject packet from host 10.1.1.51 port 1812, id=101, length=24 Proxy-State = 0x3130 # Executing section post-proxy from file /etc/freeradius/sites-enabled/default +- entering group post-proxy {...} [eap] No pre-existing handler found ++[eap] returns noop Using Post-Auth-Type Reject # Executing group from file /etc/freeradius/sites-enabled/default +- entering group REJECT {...} [attr_filter.access_reject] expand: %{User-Name} -> biryudumgida3 attr_filter: Matched entry DEFAULT at line 11 ++[attr_filter.access_reject] returns updated Delaying reject of request 5 for 1 seconds Going to the next request Waking up in 0.9 seconds. Sending delayed reject for request 5 Sending Access-Reject of id 10 to 172.30.80.1 port 24144 Waking up in 4.9 seconds. Cleaning up request 5 ID 10 with timestamp +143 Ready to process requests. ####################################################3 User somes from GGSN SQL detect username and IP pool and profile Freeradius receive Access-Accept message from home server: rad_recv: Access-Accept packet from host 10.1.1.51 port 1812, id=80, length=24 Proxy-State = 0x3130 # Executing section post-proxy from file /etc/freeradius/sites-enabled/default +- entering group post-proxy {...} [eap] No pre-existing handler found ++[eap] returns noop Found Auth-Type = Accept Auth-Type = Accept, accepting the user # Executing section post-auth from file /etc/freeradius/sites-enabled/default +- entering group post-auth {...} rlm_sql (sql): Reserving sql socket id: 3 [sqlippool] expand: %{User-Name} -> biryudumgida3 [sqlippool] sql_set_user escaped user --> 'biryudumgida3' [sqlippool] expand: START TRANSACTION -> START TRANSACTION Then again SQL query Again and again. really dont know why happen > Alan DeKok. > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html -- <br> <img src="http://www.yasar.com.tr/banner/yhbanner.jpg"> </img> <br><br> Bu elektronik postada bulunan tum fikir ve gorusler ve ekindeki dosyalar sadece adres sahip/sahiplerine ait olup, Yasar Toplulugu Sirketleri bu mesajin icerigi ile ilgili olarak hic bir hukuksal sorumlulugu kabul etmez. Eger gonderilmesi dusunulen kisi veya kurulus degilseniz, lutfen gonderen kisiyi derhal haberdar ediniz ve mesaji sisteminizden siliniz.The information contained in this e-mail and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed and Yasar Group Companies do not accept legal responsibility for the contents. If you are not the intended recipient, please immediately notify the sender and delete it from your system. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

8 11

test succeeds but can't connect?
by Brian 02 Mar '15

02 Mar '15

Hello, I am using FreeRADIUS Version 2.1.12 on CentOS 6. I set up Freeradius and MSCHAPV2 according to these guides. http://safesrv.net/install-and-setup-freeradius-on-centos-5/ http://www.tldp.org/HOWTO/8021X-HOWTO/freeradius.html The tests succeed. Sending Access-Request of id 148 to 127.0.0.1 port 1812 User-Name = "test" User-Password = "test" NAS-IP-Address = 127.0.0.1 NAS-Port = 0 Message-Authenticator = 0x00000000000000000000000000000000 rad_recv: Access-Accept packet from host 127.0.0.1 port 1812, id=148, length=20 However when I tried to implement it in WPA2 enterprise on my DD-WRT router, I can't connect. It just keeps trying to authenticate on my device but never succeeds. I did make sure to select peap/mschapv2. I also made sure port 1812 was open on the server and it is, both incoming and outgoing. I can't find any log file that would show any useful info. I apologize if this is a noob problem but I can't find anything that would give a simple answer. Thank you all.

2 1

FreeRadius PAP authentication for Non-EAPOL clients on Avaya 5500 switch.
by jan hugo prins 02 Mar '15

02 Mar '15

Hello, We have been running our radius servers for some time now and they work just fine authenticating our wireless users against our LDAP tree etc. Now my management has asked me to spend some time setting up radius authentication for wired outleds in the office, and for the workstations I got it working rather quickly using EAP-TLS and certificates signed by the same CA that signed the radius certificate. But I also need to accommodate telephones and printers and they don't do EAP themselves. To work around this, the switches we use have an option to configure the switch in such a way that it creates a radius access request based on the MAC address of the client, it's own IP address and the port the client is connected to. You then have to add this information to the users file of the radius server and you should be able to authenticate the device and open the port. This sounds like a simple setup, just add some users with plaintext passwords and start the authentication process. But the problem is that this fails, and it looks like the switch is sending 2 exactly the same authentication requests short after another, and the first one succeeds, but the second one fails. I also see this when I ping the host, I receive one reply and after that the port is closed again. Could someone tell me if I have something wrong in my config? Thanks a lot. Jan Hugo Prins Starting - reading configuration files ... including configuration file /etc/raddb/radiusd.conf including configuration file /etc/raddb/proxy.conf including configuration file /etc/raddb/clients.conf including files in directory /etc/raddb/modules/ including configuration file /etc/raddb/modules/logintime including configuration file /etc/raddb/modules/always including configuration file /etc/raddb/modules/perl including configuration file /etc/raddb/modules/ippool including configuration file /etc/raddb/modules/attr_rewrite including configuration file /etc/raddb/modules/files including configuration file /etc/raddb/modules/exec including configuration file /etc/raddb/modules/smbpasswd including configuration file /etc/raddb/modules/cui including configuration file /etc/raddb/modules/smsotp including configuration file /etc/raddb/modules/preprocess including configuration file /etc/raddb/modules/mac2vlan including configuration file /etc/raddb/modules/counter including configuration file /etc/raddb/modules/dynamic_clients including configuration file /etc/raddb/modules/attr_filter including configuration file /etc/raddb/modules/sql_log including configuration file /etc/raddb/modules/detail including configuration file /etc/raddb/modules/realm including configuration file /etc/raddb/modules/expiration including configuration file /etc/raddb/modules/mschap including configuration file /etc/raddb/modules/digest including configuration file /etc/raddb/modules/policy including configuration file /etc/raddb/modules/pam including configuration file /etc/raddb/modules/checkval including configuration file /etc/raddb/modules/etc_group including configuration file /etc/raddb/modules/expr including configuration file /etc/raddb/modules/ntlm_auth including configuration file /etc/raddb/modules/echo including configuration file /etc/raddb/modules/passwd including configuration file /etc/raddb/modules/sqlcounter_expire_on_login including configuration file /etc/raddb/modules/inner-eap including configuration file /etc/raddb/modules/otp including configuration file /etc/raddb/modules/mac2ip including configuration file /etc/raddb/modules/ldap including configuration file /etc/raddb/modules/radutmp including configuration file /etc/raddb/modules/detail.example.com including configuration file /etc/raddb/modules/wimax including configuration file /etc/raddb/modules/unix including configuration file /etc/raddb/modules/sradutmp including configuration file /etc/raddb/modules/acct_unique including configuration file /etc/raddb/modules/pap including configuration file /etc/raddb/modules/linelog including configuration file /etc/raddb/modules/opendirectory including configuration file /etc/raddb/modules/detail.log including configuration file /etc/raddb/modules/chap including configuration file /etc/raddb/eap.conf including configuration file /etc/raddb/policy.conf including files in directory /etc/raddb/sites-enabled/ including configuration file /etc/raddb/sites-enabled/Compagny1 including configuration file /etc/raddb/sites-enabled/Compagny1-tunnel main { user = "radiusd" group = "radiusd" allow_core_dumps = no } including dictionary file /etc/raddb/dictionary main { prefix = "/usr" localstatedir = "/var" logdir = "/var/log/radius" libdir = "/usr/lib64/freeradius" radacctdir = "/var/log/radius/radacct" hostname_lookups = no max_request_time = 30 cleanup_delay = 5 max_requests = 1024 pidfile = "/var/run/radiusd/radiusd.pid" checkrad = "/usr/sbin/checkrad" debug_level = 0 proxy_requests = yes log { stripped_names = no auth = yes auth_badpass = no auth_goodpass = no } security { max_attributes = 200 reject_delay = 1 status_server = 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 } realm Compagny1.com { nostrip } realm bedrijf2.nl { nostrip } realm bedrijf3.nl { nostrip } realm LOCAL { } radiusd: #### Loading Clients #### client localhost { ipaddr = 127.0.0.1 require_message_authenticator = no secret = "xxxxxxxxxxxxxxxxx" nastype = "other" } client aruba01 { ipaddr = 172.30.20.47 require_message_authenticator = no secret = "xxxxxxxxxxxxxxxxxxx" nastype = "other" } client pppoe { ipaddr = 172.30.20.48 require_message_authenticator = no secret = "xxxxxxxxxxxxxxxxx" nastype = "other" } client radius01 { ipaddr = 172.30.20.16 require_message_authenticator = no secret = "xxxxxxxxxxxxxxxx" nastype = "other" } client radius02 { ipaddr = 172.30.20.17 require_message_authenticator = no secret = "xxxxxxxxxxxxxxxxx" nastype = "other" } client infranode01 { ipaddr = 172.30.20.52 require_message_authenticator = no secret = "axxxxxxxxxxxxxx" nastype = "other" } client infranode02 { ipaddr = 172.30.20.53 require_message_authenticator = no secret = "xxxxxxxxxxxxxxxxxxx" nastype = "other" } client tc03st01sw1 { ipaddr = 192.168.202.41 require_message_authenticator = no secret = "xxxxxxxxxxxxxxxxxx" nastype = "other" } client tc03st02sw1 { ipaddr = 192.168.202.61 require_message_authenticator = no secret = "nortel" nastype = "other" } radiusd: #### Instantiating modules #### instantiate { Module: Linked to module rlm_exec Module: Instantiating module "exec" from file /etc/raddb/modules/exec exec { wait = no input_pairs = "request" shell_escape = yes } Module: Linked to module rlm_expr Module: Instantiating module "expr" from file /etc/raddb/modules/expr Module: Linked to module rlm_expiration Module: Instantiating module "expiration" from file /etc/raddb/modules/expiration expiration { reply-message = "Password Has Expired " } Module: Linked to module rlm_logintime Module: Instantiating module "logintime" from file /etc/raddb/modules/logintime logintime { reply-message = "You are calling outside your allowed timespan " minimum-timeout = 60 } } radiusd: #### Loading Virtual Servers #### server inner-tunnel-Compagny1 { # from file /etc/raddb/sites-enabled/Compagny1-tunnel modules { Module: Checking authenticate {...} for more modules to load Module: Linked to module rlm_pap Module: Instantiating module "pap" from file /etc/raddb/modules/pap pap { encryption_scheme = "auto" auto_header = no } Module: Linked to module rlm_chap Module: Instantiating module "chap" from file /etc/raddb/modules/chap Module: Linked to module rlm_mschap Module: Instantiating module "mschap" from file /etc/raddb/modules/mschap mschap { use_mppe = yes require_encryption = no require_strong = no with_ntdomain_hack = no } Module: Linked to module rlm_unix Module: Instantiating module "unix" from file /etc/raddb/modules/unix unix { radwtmp = "/var/log/radius/radwtmp" } Module: Linked to module rlm_eap Module: Instantiating module "eap_Compagny1" from file /etc/raddb/eap.conf eap eap_Compagny1 { default_eap_type = "md5" timer_expire = 60 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 4096 } 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/raddb/certs" pem_file_type = yes private_key_file = "/etc/raddb/certs/server.pem" certificate_file = "/etc/raddb/certs/server.pem" CA_file = "/etc/raddb/certs/ca.pem" private_key_password = "whatever" dh_file = "/etc/raddb/certs/dh" random_file = "/etc/raddb/certs/random" fragment_size = 1024 include_length = yes check_crl = no check_cert_cn = "%{User-Name}" cipher_list = "DEFAULT" cache { enable = no lifetime = 24 max_entries = 255 } verify { } } Module: Linked to sub-module rlm_eap_ttls Module: Instantiating eap-ttls ttls { default_eap_type = "md5" copy_request_to_tunnel = yes use_tunneled_reply = yes virtual_server = "inner-tunnel-Compagny1" include_length = yes } Module: Linked to sub-module rlm_eap_peap Module: Instantiating eap-peap peap { default_eap_type = "mschapv2" copy_request_to_tunnel = yes use_tunneled_reply = yes proxy_tunneled_request_as_eap = yes virtual_server = "inner-tunnel-Compagny1" } Module: Linked to sub-module rlm_eap_mschapv2 Module: Instantiating eap-mschapv2 mschapv2 { with_ntdomain_hack = no } Module: Checking authorize {...} for more modules to load Module: Loading virtual module optional_realm Module: Linked to module rlm_always Module: Instantiating module "updated" from file /etc/raddb/modules/always always updated { rcode = "updated" simulcount = 0 mpp = no } Module: Instantiating module "notfound" from file /etc/raddb/modules/always always notfound { rcode = "notfound" simulcount = 0 mpp = no } Module: Linked to module rlm_realm Module: Instantiating module "suffix" from file /etc/raddb/modules/realm realm suffix { format = "suffix" delimiter = "@" ignore_default = no ignore_null = no } Module: Linked to module rlm_files Module: Instantiating module "files" from file /etc/raddb/modules/files files { usersfile = "/etc/raddb/users" acctusersfile = "/etc/raddb/acct_users" preproxy_usersfile = "/etc/raddb/preproxy_users" compat = "no" } Module: Linked to module rlm_ldap Module: Instantiating module "ldap_Compagny1" from file /etc/raddb/modules/ldap ldap ldap_Compagny1 { server = "ldap.svc.be.nl" port = 389 password = "" identity = "" net_timeout = 1 timeout = 4 timelimit = 3 tls_mode = no start_tls = no tls_require_cert = "allow" tls { start_tls = no require_cert = "allow" } basedn = "ou=bedrijf1,dc=Compagny1,dc=com" filter = "(mailLocalAddress=%{User-Name})" base_filter = "(objectclass=radiusprofile)" auto_header = no access_attr_used_for_allow = yes groupname_attribute = "cn" groupmembership_filter = "(&(objectClass=posixGroup)(memberUid=%{Stripped-User-Name}))" dictionary_mapping = "/etc/raddb/ldap.attrmap" ldap_debug = 0 ldap_connections_number = 5 compare_check_items = no do_xlat = yes set_auth_type = yes } rlm_ldap: Registering ldap_groupcmp for Ldap-Group rlm_ldap: Creating new attribute ldap_Compagny1-Ldap-Group rlm_ldap: Registering ldap_groupcmp for ldap_Compagny1-Ldap-Group rlm_ldap: Registering ldap_xlat with xlat_name ldap_Compagny1 rlm_ldap: Over-riding set_auth_type, as there is no module ldap_Compagny1 listed in the "authenticate" section. rlm_ldap: reading ldap<->radius mappings from file /etc/raddb/ldap.attrmap rlm_ldap: LDAP radiusCheckItem mapped to RADIUS $GENERIC$ rlm_ldap: LDAP radiusReplyItem mapped to RADIUS $GENERIC$ rlm_ldap: LDAP radiusAuthType mapped to RADIUS Auth-Type rlm_ldap: LDAP radiusSimultaneousUse mapped to RADIUS Simultaneous-Use rlm_ldap: LDAP radiusCalledStationId mapped to RADIUS Called-Station-Id rlm_ldap: LDAP radiusCallingStationId mapped to RADIUS Calling-Station-Id rlm_ldap: LDAP lmPassword mapped to RADIUS LM-Password rlm_ldap: LDAP ntPassword mapped to RADIUS NT-Password rlm_ldap: LDAP sambaLmPassword mapped to RADIUS LM-Password rlm_ldap: LDAP sambaNtPassword mapped to RADIUS NT-Password rlm_ldap: LDAP dBCSPwd mapped to RADIUS LM-Password rlm_ldap: LDAP userPassword mapped to RADIUS Password-With-Header rlm_ldap: LDAP acctFlags mapped to RADIUS SMB-Account-CTRL-TEXT rlm_ldap: LDAP radiusExpiration mapped to RADIUS Expiration rlm_ldap: LDAP radiusNASIpAddress mapped to RADIUS NAS-IP-Address rlm_ldap: LDAP radiusServiceType mapped to RADIUS Service-Type rlm_ldap: LDAP radiusFramedProtocol mapped to RADIUS Framed-Protocol rlm_ldap: LDAP radiusFramedIPAddress mapped to RADIUS Framed-IP-Address rlm_ldap: LDAP radiusFramedIPNetmask mapped to RADIUS Framed-IP-Netmask rlm_ldap: LDAP radiusFramedRoute mapped to RADIUS Framed-Route rlm_ldap: LDAP radiusFramedRouting mapped to RADIUS Framed-Routing rlm_ldap: LDAP radiusFilterId mapped to RADIUS Filter-Id rlm_ldap: LDAP radiusFramedMTU mapped to RADIUS Framed-MTU rlm_ldap: LDAP radiusFramedCompression mapped to RADIUS Framed-Compression rlm_ldap: LDAP radiusLoginIPHost mapped to RADIUS Login-IP-Host rlm_ldap: LDAP radiusLoginService mapped to RADIUS Login-Service rlm_ldap: LDAP radiusLoginTCPPort mapped to RADIUS Login-TCP-Port rlm_ldap: LDAP radiusCallbackNumber mapped to RADIUS Callback-Number rlm_ldap: LDAP radiusCallbackId mapped to RADIUS Callback-Id rlm_ldap: LDAP radiusFramedIPXNetwork mapped to RADIUS Framed-IPX-Network rlm_ldap: LDAP radiusClass mapped to RADIUS Class rlm_ldap: LDAP radiusSessionTimeout mapped to RADIUS Session-Timeout rlm_ldap: LDAP radiusIdleTimeout mapped to RADIUS Idle-Timeout rlm_ldap: LDAP radiusTerminationAction mapped to RADIUS Termination-Action rlm_ldap: LDAP radiusLoginLATService mapped to RADIUS Login-LAT-Service rlm_ldap: LDAP radiusLoginLATNode mapped to RADIUS Login-LAT-Node rlm_ldap: LDAP radiusLoginLATGroup mapped to RADIUS Login-LAT-Group rlm_ldap: LDAP radiusFramedAppleTalkLink mapped to RADIUS Framed-AppleTalk-Link rlm_ldap: LDAP radiusFramedAppleTalkNetwork mapped to RADIUS Framed-AppleTalk-Network rlm_ldap: LDAP radiusFramedAppleTalkZone mapped to RADIUS Framed-AppleTalk-Zone rlm_ldap: LDAP radiusPortLimit mapped to RADIUS Port-Limit rlm_ldap: LDAP radiusLoginLATPort mapped to RADIUS Login-LAT-Port rlm_ldap: LDAP radiusReplyMessage mapped to RADIUS Reply-Message rlm_ldap: LDAP radiusTunnelType mapped to RADIUS Tunnel-Type rlm_ldap: LDAP radiusTunnelMediumType mapped to RADIUS Tunnel-Medium-Type rlm_ldap: LDAP radiusTunnelPrivateGroupId mapped to RADIUS Tunnel-Private-Group-Id conns: 0x1ee5b30 Module: Instantiating module "ldap_bedrijf2" from file /etc/raddb/modules/ldap ldap ldap_bedrijf2 { server = "ldap.svc.be.nl" port = 389 password = "" identity = "" net_timeout = 1 timeout = 4 timelimit = 3 tls_mode = no start_tls = no tls_require_cert = "allow" tls { start_tls = no require_cert = "allow" } basedn = "ou=bedrijf2,dc=Compagny1,dc=com" filter = "(mailLocalAddress=%{User-Name})" base_filter = "(objectclass=radiusprofile)" auto_header = no access_attr_used_for_allow = yes groupname_attribute = "cn" groupmembership_filter = "(&(objectClass=posixGroup)(memberUid=%{Stripped-User-Name}))" dictionary_mapping = "/etc/raddb/ldap.attrmap" ldap_debug = 0 ldap_connections_number = 5 compare_check_items = no do_xlat = yes set_auth_type = yes } rlm_ldap: Registering ldap_groupcmp for Ldap-Group rlm_ldap: Creating new attribute ldap_bedrijf2-Ldap-Group rlm_ldap: Registering ldap_groupcmp for ldap_bedrijf2-Ldap-Group rlm_ldap: Registering ldap_xlat with xlat_name ldap_bedrijf2 rlm_ldap: Over-riding set_auth_type, as there is no module ldap_bedrijf2 listed in the "authenticate" section. rlm_ldap: reading ldap<->radius mappings from file /etc/raddb/ldap.attrmap rlm_ldap: LDAP radiusCheckItem mapped to RADIUS $GENERIC$ rlm_ldap: LDAP radiusReplyItem mapped to RADIUS $GENERIC$ rlm_ldap: LDAP radiusAuthType mapped to RADIUS Auth-Type rlm_ldap: LDAP radiusSimultaneousUse mapped to RADIUS Simultaneous-Use rlm_ldap: LDAP radiusCalledStationId mapped to RADIUS Called-Station-Id rlm_ldap: LDAP radiusCallingStationId mapped to RADIUS Calling-Station-Id rlm_ldap: LDAP lmPassword mapped to RADIUS LM-Password rlm_ldap: LDAP ntPassword mapped to RADIUS NT-Password rlm_ldap: LDAP sambaLmPassword mapped to RADIUS LM-Password rlm_ldap: LDAP sambaNtPassword mapped to RADIUS NT-Password rlm_ldap: LDAP dBCSPwd mapped to RADIUS LM-Password rlm_ldap: LDAP userPassword mapped to RADIUS Password-With-Header rlm_ldap: LDAP acctFlags mapped to RADIUS SMB-Account-CTRL-TEXT rlm_ldap: LDAP radiusExpiration mapped to RADIUS Expiration rlm_ldap: LDAP radiusNASIpAddress mapped to RADIUS NAS-IP-Address rlm_ldap: LDAP radiusServiceType mapped to RADIUS Service-Type rlm_ldap: LDAP radiusFramedProtocol mapped to RADIUS Framed-Protocol rlm_ldap: LDAP radiusFramedIPAddress mapped to RADIUS Framed-IP-Address rlm_ldap: LDAP radiusFramedIPNetmask mapped to RADIUS Framed-IP-Netmask rlm_ldap: LDAP radiusFramedRoute mapped to RADIUS Framed-Route rlm_ldap: LDAP radiusFramedRouting mapped to RADIUS Framed-Routing rlm_ldap: LDAP radiusFilterId mapped to RADIUS Filter-Id rlm_ldap: LDAP radiusFramedMTU mapped to RADIUS Framed-MTU rlm_ldap: LDAP radiusFramedCompression mapped to RADIUS Framed-Compression rlm_ldap: LDAP radiusLoginIPHost mapped to RADIUS Login-IP-Host rlm_ldap: LDAP radiusLoginService mapped to RADIUS Login-Service rlm_ldap: LDAP radiusLoginTCPPort mapped to RADIUS Login-TCP-Port rlm_ldap: LDAP radiusCallbackNumber mapped to RADIUS Callback-Number rlm_ldap: LDAP radiusCallbackId mapped to RADIUS Callback-Id rlm_ldap: LDAP radiusFramedIPXNetwork mapped to RADIUS Framed-IPX-Network rlm_ldap: LDAP radiusClass mapped to RADIUS Class rlm_ldap: LDAP radiusSessionTimeout mapped to RADIUS Session-Timeout rlm_ldap: LDAP radiusIdleTimeout mapped to RADIUS Idle-Timeout rlm_ldap: LDAP radiusTerminationAction mapped to RADIUS Termination-Action rlm_ldap: LDAP radiusLoginLATService mapped to RADIUS Login-LAT-Service rlm_ldap: LDAP radiusLoginLATNode mapped to RADIUS Login-LAT-Node rlm_ldap: LDAP radiusLoginLATGroup mapped to RADIUS Login-LAT-Group rlm_ldap: LDAP radiusFramedAppleTalkLink mapped to RADIUS Framed-AppleTalk-Link rlm_ldap: LDAP radiusFramedAppleTalkNetwork mapped to RADIUS Framed-AppleTalk-Network rlm_ldap: LDAP radiusFramedAppleTalkZone mapped to RADIUS Framed-AppleTalk-Zone rlm_ldap: LDAP radiusPortLimit mapped to RADIUS Port-Limit rlm_ldap: LDAP radiusLoginLATPort mapped to RADIUS Login-LAT-Port rlm_ldap: LDAP radiusReplyMessage mapped to RADIUS Reply-Message rlm_ldap: LDAP radiusTunnelType mapped to RADIUS Tunnel-Type rlm_ldap: LDAP radiusTunnelMediumType mapped to RADIUS Tunnel-Medium-Type rlm_ldap: LDAP radiusTunnelPrivateGroupId mapped to RADIUS Tunnel-Private-Group-Id conns: 0x1ee7840 Module: Instantiating module "ldap_bedrijf3" from file /etc/raddb/modules/ldap ldap ldap_bedrijf3 { server = "ldap.svc.be.nl" port = 389 password = "" identity = "" net_timeout = 1 timeout = 4 timelimit = 3 tls_mode = no start_tls = no tls_require_cert = "allow" tls { start_tls = no require_cert = "allow" } basedn = "ou=bedrijf3,dc=Compagny1,dc=com" filter = "(mailLocalAddress=%{User-Name})" base_filter = "(objectclass=radiusprofile)" auto_header = no access_attr_used_for_allow = yes groupname_attribute = "cn" groupmembership_filter = "(&(objectClass=posixGroup)(memberUid=%{Stripped-User-Name}))" dictionary_mapping = "/etc/raddb/ldap.attrmap" ldap_debug = 0 ldap_connections_number = 5 compare_check_items = no do_xlat = yes set_auth_type = yes } rlm_ldap: Registering ldap_groupcmp for Ldap-Group rlm_ldap: Creating new attribute ldap_bedrijf3-Ldap-Group rlm_ldap: Registering ldap_groupcmp for ldap_bedrijf3-Ldap-Group rlm_ldap: Registering ldap_xlat with xlat_name ldap_bedrijf3 rlm_ldap: Over-riding set_auth_type, as there is no module ldap_bedrijf3 listed in the "authenticate" section. rlm_ldap: reading ldap<->radius mappings from file /etc/raddb/ldap.attrmap rlm_ldap: LDAP radiusCheckItem mapped to RADIUS $GENERIC$ rlm_ldap: LDAP radiusReplyItem mapped to RADIUS $GENERIC$ rlm_ldap: LDAP radiusAuthType mapped to RADIUS Auth-Type rlm_ldap: LDAP radiusSimultaneousUse mapped to RADIUS Simultaneous-Use rlm_ldap: LDAP radiusCalledStationId mapped to RADIUS Called-Station-Id rlm_ldap: LDAP radiusCallingStationId mapped to RADIUS Calling-Station-Id rlm_ldap: LDAP lmPassword mapped to RADIUS LM-Password rlm_ldap: LDAP ntPassword mapped to RADIUS NT-Password rlm_ldap: LDAP sambaLmPassword mapped to RADIUS LM-Password rlm_ldap: LDAP sambaNtPassword mapped to RADIUS NT-Password rlm_ldap: LDAP dBCSPwd mapped to RADIUS LM-Password rlm_ldap: LDAP userPassword mapped to RADIUS Password-With-Header rlm_ldap: LDAP acctFlags mapped to RADIUS SMB-Account-CTRL-TEXT rlm_ldap: LDAP radiusExpiration mapped to RADIUS Expiration rlm_ldap: LDAP radiusNASIpAddress mapped to RADIUS NAS-IP-Address rlm_ldap: LDAP radiusServiceType mapped to RADIUS Service-Type rlm_ldap: LDAP radiusFramedProtocol mapped to RADIUS Framed-Protocol rlm_ldap: LDAP radiusFramedIPAddress mapped to RADIUS Framed-IP-Address rlm_ldap: LDAP radiusFramedIPNetmask mapped to RADIUS Framed-IP-Netmask rlm_ldap: LDAP radiusFramedRoute mapped to RADIUS Framed-Route rlm_ldap: LDAP radiusFramedRouting mapped to RADIUS Framed-Routing rlm_ldap: LDAP radiusFilterId mapped to RADIUS Filter-Id rlm_ldap: LDAP radiusFramedMTU mapped to RADIUS Framed-MTU rlm_ldap: LDAP radiusFramedCompression mapped to RADIUS Framed-Compression rlm_ldap: LDAP radiusLoginIPHost mapped to RADIUS Login-IP-Host rlm_ldap: LDAP radiusLoginService mapped to RADIUS Login-Service rlm_ldap: LDAP radiusLoginTCPPort mapped to RADIUS Login-TCP-Port rlm_ldap: LDAP radiusCallbackNumber mapped to RADIUS Callback-Number rlm_ldap: LDAP radiusCallbackId mapped to RADIUS Callback-Id rlm_ldap: LDAP radiusFramedIPXNetwork mapped to RADIUS Framed-IPX-Network rlm_ldap: LDAP radiusClass mapped to RADIUS Class rlm_ldap: LDAP radiusSessionTimeout mapped to RADIUS Session-Timeout rlm_ldap: LDAP radiusIdleTimeout mapped to RADIUS Idle-Timeout rlm_ldap: LDAP radiusTerminationAction mapped to RADIUS Termination-Action rlm_ldap: LDAP radiusLoginLATService mapped to RADIUS Login-LAT-Service rlm_ldap: LDAP radiusLoginLATNode mapped to RADIUS Login-LAT-Node rlm_ldap: LDAP radiusLoginLATGroup mapped to RADIUS Login-LAT-Group rlm_ldap: LDAP radiusFramedAppleTalkLink mapped to RADIUS Framed-AppleTalk-Link rlm_ldap: LDAP radiusFramedAppleTalkNetwork mapped to RADIUS Framed-AppleTalk-Network rlm_ldap: LDAP radiusFramedAppleTalkZone mapped to RADIUS Framed-AppleTalk-Zone rlm_ldap: LDAP radiusPortLimit mapped to RADIUS Port-Limit rlm_ldap: LDAP radiusLoginLATPort mapped to RADIUS Login-LAT-Port rlm_ldap: LDAP radiusReplyMessage mapped to RADIUS Reply-Message rlm_ldap: LDAP radiusTunnelType mapped to RADIUS Tunnel-Type rlm_ldap: LDAP radiusTunnelMediumType mapped to RADIUS Tunnel-Medium-Type rlm_ldap: LDAP radiusTunnelPrivateGroupId mapped to RADIUS Tunnel-Private-Group-Id conns: 0x1ee9630 Module: Loading virtual module real_id Module: Checking session {...} for more modules to load Module: Linked to module rlm_radutmp Module: Instantiating module "radutmp" from file /etc/raddb/modules/radutmp radutmp { filename = "/var/log/radius/radutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes perm = 384 callerid = yes } Module: Checking pre-proxy {...} for more modules to load Module: Linked to module rlm_detail Module: Instantiating module "pre_proxy_log" from file /etc/raddb/modules/detail.log detail pre_proxy_log { detailfile = "/var/log/radius/radacct/%{Client-IP-Address}/pre-proxy-detail-%Y%m%d" header = "%t" detailperm = 384 dirperm = 493 locking = no log_packet_header = no } Module: Checking post-proxy {...} for more modules to load Module: Instantiating module "post_proxy_log" from file /etc/raddb/modules/detail.log detail post_proxy_log { detailfile = "/var/log/radius/radacct/%{Client-IP-Address}/post-proxy-detail-%Y%m%d" header = "%t" detailperm = 384 dirperm = 493 locking = no log_packet_header = no } Module: Checking post-auth {...} for more modules to load Module: Instantiating module "reply_log" from file /etc/raddb/modules/detail.log detail reply_log { detailfile = "/var/log/radius/radacct/%{Client-IP-Address}/reply-detail-%Y%m%d" header = "%t" detailperm = 384 dirperm = 493 locking = no log_packet_header = no } Module: Linked to module rlm_attr_filter Module: Instantiating module "attr_filter.access_reject" from file /etc/raddb/modules/attr_filter attr_filter attr_filter.access_reject { attrsfile = "/etc/raddb/attrs.access_reject" key = "%{User-Name}" } } # modules } # server server { # from file /etc/raddb/radiusd.conf modules { Module: Checking authenticate {...} for more modules to load Module: Linked to module rlm_digest Module: Instantiating module "digest" from file /etc/raddb/modules/digest Module: Checking authorize {...} for more modules to load Module: Loading virtual module optional_realm Module: Linked to module rlm_preprocess Module: Instantiating module "preprocess" from file /etc/raddb/modules/preprocess preprocess { huntgroups = "/etc/raddb/huntgroups" hints = "/etc/raddb/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 } Module: Instantiating module "auth_log" from file /etc/raddb/modules/detail.log detail auth_log { detailfile = "/var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d" header = "%t" detailperm = 384 dirperm = 493 locking = no log_packet_header = no } Module: Checking preacct {...} for more modules to load Module: Linked to module rlm_acct_unique Module: Instantiating module "acct_unique" from file /etc/raddb/modules/acct_unique acct_unique { key = "User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port" } Module: Checking accounting {...} for more modules to load Module: Instantiating module "detail" from file /etc/raddb/modules/detail detail { detailfile = "/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d" header = "%t" detailperm = 384 dirperm = 493 locking = no log_packet_header = no } Module: Instantiating module "attr_filter.accounting_response" from file /etc/raddb/modules/attr_filter attr_filter attr_filter.accounting_response { attrsfile = "/etc/raddb/attrs.accounting_response" key = "%{User-Name}" } Module: Checking session {...} for more modules to load Module: Checking pre-proxy {...} for more modules to load Module: Loading virtual module allow_only_Compagny1 Module: Instantiating module "reject" from file /etc/raddb/modules/always always reject { rcode = "reject" simulcount = 0 mpp = no } 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 } 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-Compagny1 Listening on proxy address * port 1814 Ready to process requests. rad_recv: Access-Request packet from host 192.168.202.61 port 3490, id=203, length=86 NAS-IP-Address = 192.168.202.61 User-Password = "192168202061.78acc0788222.0003" Service-Type = Login-User NAS-Port = 3 User-Name = "78acc0788222" # Executing section authorize from file /etc/raddb/sites-enabled/Compagny1 +- entering group authorize {...} ++- entering policy optional_realm {...} +++? if (User-Name =~ /(.+)(a)(.+)/) ? Evaluating (User-Name =~ /(.+)(a)(.+)/) -> FALSE +++? if (User-Name =~ /(.+)(a)(.+)/) -> FALSE +++- entering else else {...} ++++[notfound] returns notfound +++- else else returns notfound ++- policy optional_realm returns notfound ++[preprocess] returns ok [auth_log] expand: /var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d -> /var/log/radius/radacct/192.168.202.61/auth-detail-20150226 [auth_log] /var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d expands to /var/log/radius/radacct/192.168.202.61/auth-detail-20150226 [auth_log] expand: %t -> Thu Feb 26 01:08:14 2015 ++[auth_log] returns ok ++[chap] returns noop ++[mschap] returns noop ++[digest] returns noop [suffix] No '@' in User-Name = "78acc0788222", looking up realm NULL [suffix] No such realm "NULL" ++[suffix] returns noop [eap_Compagny1] No EAP-Message, not doing EAP ++[eap_Compagny1] returns noop [ldap_Compagny1] Entering ldap_groupcmp() [files] expand: ou=bedrijf1,dc=Compagny1,dc=com -> ou=bedrijf1,dc=Compagny1,dc=com [files] expand: (mailLocalAddress=%{User-Name}) -> (mailLocalAddress=78acc0788222) [ldap_Compagny1] ldap_get_conn: Checking Id: 0 [ldap_Compagny1] ldap_get_conn: Got Id: 0 [ldap_Compagny1] attempting LDAP reconnection [ldap_Compagny1] (re)connect to ldap.svc.be.nl:389, authentication 0 [ldap_Compagny1] bind as / to ldap.svc.be.nl:389 [ldap_Compagny1] waiting for bind result ... [ldap_Compagny1] Bind was successful [ldap_Compagny1] performing search in ou=bedrijf1,dc=Compagny1,dc=com, with filter (mailLocalAddress=78acc0788222) [ldap_Compagny1] object not found rlm_ldap::ldap_groupcmp: search failed [ldap_Compagny1] ldap_release_conn: Release Id: 0 [ldap_Compagny1] Entering ldap_groupcmp() [files] expand: ou=bedrijf1,dc=Compagny1,dc=com -> ou=bedrijf1,dc=Compagny1,dc=com [files] expand: (mailLocalAddress=%{User-Name}) -> (mailLocalAddress=78acc0788222) [ldap_Compagny1] ldap_get_conn: Checking Id: 0 [ldap_Compagny1] ldap_get_conn: Got Id: 0 [ldap_Compagny1] performing search in ou=bedrijf1,dc=Compagny1,dc=com, with filter (mailLocalAddress=78acc0788222) [ldap_Compagny1] object not found rlm_ldap::ldap_groupcmp: search failed [ldap_Compagny1] ldap_release_conn: Release Id: 0 [ldap_bedrijf2] Entering ldap_groupcmp() [files] expand: ou=bedrijf2,dc=Compagny1,dc=com -> ou=bedrijf2,dc=Compagny1,dc=com [files] expand: (mailLocalAddress=%{User-Name}) -> (mailLocalAddress=78acc0788222) [ldap_bedrijf2] ldap_get_conn: Checking Id: 0 [ldap_bedrijf2] ldap_get_conn: Got Id: 0 [ldap_bedrijf2] attempting LDAP reconnection [ldap_bedrijf2] (re)connect to ldap.svc.be.nl:389, authentication 0 [ldap_bedrijf2] bind as / to ldap.svc.be.nl:389 [ldap_bedrijf2] waiting for bind result ... [ldap_bedrijf2] Bind was successful [ldap_bedrijf2] performing search in ou=bedrijf2,dc=Compagny1,dc=com, with filter (mailLocalAddress=78acc0788222) [ldap_bedrijf2] object not found rlm_ldap::ldap_groupcmp: search failed [ldap_bedrijf2] ldap_release_conn: Release Id: 0 [ldap_bedrijf3] Entering ldap_groupcmp() [files] expand: ou=bedrijf3,dc=Compagny1,dc=com -> ou=bedrijf3,dc=Compagny1,dc=com [files] expand: (mailLocalAddress=%{User-Name}) -> (mailLocalAddress=78acc0788222) [ldap_bedrijf3] ldap_get_conn: Checking Id: 0 [ldap_bedrijf3] ldap_get_conn: Got Id: 0 [ldap_bedrijf3] attempting LDAP reconnection [ldap_bedrijf3] (re)connect to ldap.svc.be.nl:389, authentication 0 [ldap_bedrijf3] bind as / to ldap.svc.be.nl:389 [ldap_bedrijf3] waiting for bind result ... [ldap_bedrijf3] Bind was successful [ldap_bedrijf3] performing search in ou=bedrijf3,dc=Compagny1,dc=com, with filter (mailLocalAddress=78acc0788222) [ldap_bedrijf3] object not found rlm_ldap::ldap_groupcmp: search failed [ldap_bedrijf3] ldap_release_conn: Release Id: 0 [ldap_Compagny1] Entering ldap_groupcmp() [files] expand: ou=bedrijf1,dc=Compagny1,dc=com -> ou=bedrijf1,dc=Compagny1,dc=com [files] expand: (mailLocalAddress=%{User-Name}) -> (mailLocalAddress=78acc0788222) [ldap_Compagny1] ldap_get_conn: Checking Id: 0 [ldap_Compagny1] ldap_get_conn: Got Id: 0 [ldap_Compagny1] performing search in ou=bedrijf1,dc=Compagny1,dc=com, with filter (mailLocalAddress=78acc0788222) [ldap_Compagny1] object not found rlm_ldap::ldap_groupcmp: search failed [ldap_Compagny1] ldap_release_conn: Release Id: 0 [files] users: Matched entry 78acc0788222 at line 24 ++[files] returns ok ++? if (Realm == "Compagny1.com" ) (Attribute Realm was not found) ? Evaluating (Realm == "Compagny1.com" ) -> FALSE ++? if (Realm == "Compagny1.com" ) -> FALSE ++? if (Realm == "bedrijf2.nl" ) (Attribute Realm was not found) ? Evaluating (Realm == "bedrijf2.nl" ) -> FALSE ++? if (Realm == "bedrijf2.nl" ) -> FALSE ++? if (Realm == "bedrijf3.nl" ) (Attribute Realm was not found) ? Evaluating (Realm == "bedrijf3.nl" ) -> FALSE ++? if (Realm == "bedrijf3.nl" ) -> FALSE ++[expiration] returns noop ++[logintime] returns noop ++[pap] returns updated Found Auth-Type = PAP # Executing group from file /etc/raddb/sites-enabled/Compagny1 +- entering group PAP {...} ++[files] returns noop [pap] login attempt with password "192168202061.78acc0788222.0003" [pap] Using clear text password "192168202061.78acc0788222.0003" [pap] User authenticated successfully ++[pap] returns ok Login OK: [78acc0788222] (from client tc03st02sw1 port 3) # Executing section post-auth from file /etc/raddb/sites-enabled/Compagny1 +- entering group post-auth {...} [reply_log] expand: /var/log/radius/radacct/%{Client-IP-Address}/reply-detail-%Y%m%d -> /var/log/radius/radacct/192.168.202.61/reply-detail-20150226 [reply_log] /var/log/radius/radacct/%{Client-IP-Address}/reply-detail-%Y%m%d expands to /var/log/radius/radacct/192.168.202.61/reply-detail-20150226 [reply_log] expand: %t -> Thu Feb 26 01:08:14 2015 ++[reply_log] returns ok ++[exec] returns noop Sending Access-Accept of id 203 to 192.168.202.61 port 3490 Finished request 0. Going to the next request Waking up in 4.9 seconds. rad_recv: Access-Request packet from host 192.168.202.61 port 3490, id=204, length=86 NAS-IP-Address = 192.168.202.61 User-Password = "192168202061.78acc0788220.0003" Service-Type = Login-User NAS-Port = 3 User-Name = "78acc0788220" # Executing section authorize from file /etc/raddb/sites-enabled/Compagny1 +- entering group authorize {...} ++- entering policy optional_realm {...} +++? if (User-Name =~ /(.+)(a)(.+)/) ? Evaluating (User-Name =~ /(.+)(a)(.+)/) -> FALSE +++? if (User-Name =~ /(.+)(a)(.+)/) -> FALSE +++- entering else else {...} ++++[notfound] returns notfound +++- else else returns notfound ++- policy optional_realm returns notfound ++[preprocess] returns ok [auth_log] expand: /var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d -> /var/log/radius/radacct/192.168.202.61/auth-detail-20150226 [auth_log] /var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d expands to /var/log/radius/radacct/192.168.202.61/auth-detail-20150226 [auth_log] expand: %t -> Thu Feb 26 01:08:15 2015 ++[auth_log] returns ok ++[chap] returns noop ++[mschap] returns noop ++[digest] returns noop [suffix] No '@' in User-Name = "78acc0788220", looking up realm NULL [suffix] No such realm "NULL" ++[suffix] returns noop [eap_Compagny1] No EAP-Message, not doing EAP ++[eap_Compagny1] returns noop [ldap_Compagny1] Entering ldap_groupcmp() [files] expand: ou=bedrijf1,dc=Compagny1,dc=com -> ou=bedrijf1,dc=Compagny1,dc=com [files] expand: (mailLocalAddress=%{User-Name}) -> (mailLocalAddress=78acc0788220) [ldap_Compagny1] ldap_get_conn: Checking Id: 0 [ldap_Compagny1] ldap_get_conn: Got Id: 0 [ldap_Compagny1] performing search in ou=bedrijf1,dc=Compagny1,dc=com, with filter (mailLocalAddress=78acc0788220) [ldap_Compagny1] object not found rlm_ldap::ldap_groupcmp: search failed [ldap_Compagny1] ldap_release_conn: Release Id: 0 [ldap_Compagny1] Entering ldap_groupcmp() [files] expand: ou=bedrijf1,dc=Compagny1,dc=com -> ou=bedrijf1,dc=Compagny1,dc=com [files] expand: (mailLocalAddress=%{User-Name}) -> (mailLocalAddress=78acc0788220) [ldap_Compagny1] ldap_get_conn: Checking Id: 0 [ldap_Compagny1] ldap_get_conn: Got Id: 0 [ldap_Compagny1] performing search in ou=bedrijf1,dc=Compagny1,dc=com, with filter (mailLocalAddress=78acc0788220) [ldap_Compagny1] object not found rlm_ldap::ldap_groupcmp: search failed [ldap_Compagny1] ldap_release_conn: Release Id: 0 [ldap_bedrijf2] Entering ldap_groupcmp() [files] expand: ou=bedrijf2,dc=Compagny1,dc=com -> ou=bedrijf2,dc=Compagny1,dc=com [files] expand: (mailLocalAddress=%{User-Name}) -> (mailLocalAddress=78acc0788220) [ldap_bedrijf2] ldap_get_conn: Checking Id: 0 [ldap_bedrijf2] ldap_get_conn: Got Id: 0 [ldap_bedrijf2] performing search in ou=bedrijf2,dc=Compagny1,dc=com, with filter (mailLocalAddress=78acc0788220) [ldap_bedrijf2] object not found rlm_ldap::ldap_groupcmp: search failed [ldap_bedrijf2] ldap_release_conn: Release Id: 0 [ldap_bedrijf3] Entering ldap_groupcmp() [files] expand: ou=bedrijf3,dc=Compagny1,dc=com -> ou=bedrijf3,dc=Compagny1,dc=com [files] expand: (mailLocalAddress=%{User-Name}) -> (mailLocalAddress=78acc0788220) [ldap_bedrijf3] ldap_get_conn: Checking Id: 0 [ldap_bedrijf3] ldap_get_conn: Got Id: 0 [ldap_bedrijf3] performing search in ou=bedrijf3,dc=Compagny1,dc=com, with filter (mailLocalAddress=78acc0788220) [ldap_bedrijf3] object not found rlm_ldap::ldap_groupcmp: search failed [ldap_bedrijf3] ldap_release_conn: Release Id: 0 [ldap_Compagny1] Entering ldap_groupcmp() [files] expand: ou=bedrijf1,dc=Compagny1,dc=com -> ou=bedrijf1,dc=Compagny1,dc=com [files] expand: (mailLocalAddress=%{User-Name}) -> (mailLocalAddress=78acc0788220) [ldap_Compagny1] ldap_get_conn: Checking Id: 0 [ldap_Compagny1] ldap_get_conn: Got Id: 0 [ldap_Compagny1] performing search in ou=bedrijf1,dc=Compagny1,dc=com, with filter (mailLocalAddress=78acc0788220) [ldap_Compagny1] object not found rlm_ldap::ldap_groupcmp: search failed [ldap_Compagny1] ldap_release_conn: Release Id: 0 ++[files] returns noop ++? if (Realm == "Compagny1.com" ) (Attribute Realm was not found) ? Evaluating (Realm == "Compagny1.com" ) -> FALSE ++? if (Realm == "Compagny1.com" ) -> FALSE ++? if (Realm == "bedrijf2.nl" ) (Attribute Realm was not found) ? Evaluating (Realm == "bedrijf2.nl" ) -> FALSE ++? if (Realm == "bedrijf2.nl" ) -> FALSE ++? if (Realm == "bedrijf3.nl" ) (Attribute Realm was not found) ? Evaluating (Realm == "bedrijf3.nl" ) -> FALSE ++? if (Realm == "bedrijf3.nl" ) -> FALSE ++[expiration] returns noop ++[logintime] returns noop [pap] WARNING! No "known good" password found for the user. Authentication may fail because of this. ++[pap] returns noop ERROR: No authenticate method (Auth-Type) found for the request: Rejecting the user Failed to authenticate the user. Login incorrect: [78acc0788220] (from client tc03st02sw1 port 3) Using Post-Auth-Type Reject # Executing group from file /etc/raddb/sites-enabled/Compagny1 +- entering group REJECT {...} [attr_filter.access_reject] expand: %{User-Name} -> 78acc0788220 attr_filter: Matched entry DEFAULT at line 11 ++[attr_filter.access_reject] returns updated Delaying reject of request 1 for 1 seconds Going to the next request Waking up in 0.9 seconds. Sending delayed reject for request 1 Sending Access-Reject of id 204 to 192.168.202.61 port 3490 Waking up in 3.3 seconds. Cleaning up request 0 ID 203 with timestamp +14 Waking up in 1.6 seconds. Cleaning up request 1 ID 204 with timestamp +15 Ready to process requests.

5 11

Re: Question about multiple sql databases!
by Haviaras Kostas 02 Mar '15

02 Mar '15

I create 3 new virtual servers, one for each database and it is working as I expect! Thanks!!!

1 0

Re: Question about multiple sql databases!
by Haviaras Kostas 02 Mar '15

02 Mar '15

Each database is for different company! I will change to have different username and passwords. Thanks for your quick responses.

3 2

Re: Question about multiple sql databases!
by Haviaras Kostas 02 Mar '15

02 Mar '15

If I create 3 different virtual servers, it will be a problem if I have the same username and password for the mysql databases? Thanks

2 1

Question about multiple sql databases!
by Haviaras Kostas 02 Mar '15

02 Mar '15

Hello, I have define three sql databases on the sql.conf and each database point to different database but they have the same username and password. Each of them I have added on the /sites-enabled/default instead of the sql. My problem, when I connect to one through the my NAS its connect simultaneously on the 3 databases. Even if the username is doesn't exist on the other 2. Here is my config: sql.conf: sql db1{ } sql db2{ } sql db3{ } default(replace each sql with the following three): db1 db2 db3 I have to create Realms? Or 3 differents virtual servers? Thanks

3 2

Adding custom SQL counter
by Lorenzo Milesi 01 Mar '15

01 Mar '15

Hi. I'm trying to create a custom counter which basically is the same as Max-Daily-Session but restricted to the current Called-Station-Id. I added this to sql/mysql/counter.conf: sqlcounter dailycounterlocation { counter-name = Daily-Session-Location-Time check-name = Max-Daily-Session-Location reply-name = Session-Timeout sqlmod-inst = sql key = User-Name reset = daily query = "SELECT SUM(acctsessiontime - \ GREATEST((%b - UNIX_TIMESTAMP(acctstarttime)), 0)) \ FROM radacct WHERE username = '${key}' AND \ (UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '%b') \ AND calledstationid = '%{Called-Station-Id}' " } then in sites-enabled/default: [...] authorize { dailycounterlocation { reject = 1 } if(reject){ update reply { Reply-Message := "You have reached your daily time limit from this location" } reject } } but it's not working at all... Compared to a Max-Daily-Session attribute, in the radius debug I see the value gets returned just after the group check query. Instead with my custom attribute the value is never returned, the check query returns null (when there's no previous activity in radacct) so the user can stay connected forever (for the first session, from the second on it works). What am I doing wrong? Why the default session timeout is not returned? thanks -- Lorenzo Milesi - lorenzo.milesi(a)yetopen.it YetOpen S.r.l. - http://www.yetopen.it/

2 2

VSA Processing embedded values
by Ben Gatewood 01 Mar '15

01 Mar '15

Hi All, I am processing Accounting records from a vendor who overloads VSA 255 to extend the range of available attributes. For instance, they may send something like this: VENDOR-Attr-255 = "272=Yes” Which really means VSA 272 = “Yes” I am struggling a bit to figure out how to process these effectively. I found rlm_attr_rewrite but I can’t see a way to make it split the string and drop the “272=“ part. Is there a way to do this in unlang at all or am I going to need to bring in rlm_python or similar? Thanks in Advance, Ben

5 21