freeradius: FreeRADIUS Version 3.0.1, for host i486-pc-linux-gnu, built on Feb 13 2014 at 10:01:06 Copyright (C) 1999-2014 The FreeRADIUS server project and contributors There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE You may redistribute copies of FreeRADIUS under the terms of the GNU General Public License For more information about these matters, see the file named COPYRIGHT Starting - reading configuration files ... including dictionary file /etc/freeradius/dictionary including configuration file /etc/freeradius/radiusd.conf including configuration file /etc/freeradius/proxy.conf including configuration file /etc/freeradius/clients.conf including files in directory /etc/freeradius/mods-enabled/ including configuration file /etc/freeradius/mods-enabled/realm including configuration file /etc/freeradius/mods-enabled/sql including configuration file /etc/freeradius/mods-config/sql/main/mysql/queries.conf including configuration file /etc/freeradius/mods-enabled/mschap including configuration file /etc/freeradius/mods-enabled/expiration including configuration file /etc/freeradius/mods-enabled/passwd including configuration file /etc/freeradius/mods-enabled/chap including configuration file /etc/freeradius/mods-enabled/always including configuration file /etc/freeradius/mods-enabled/cache_eap including configuration file /etc/freeradius/mods-enabled/radutmp including configuration file /etc/freeradius/mods-enabled/files including configuration file /etc/freeradius/mods-enabled/exec including configuration file /etc/freeradius/mods-enabled/ldap including configuration file /etc/freeradius/mods-enabled/pap including configuration file /etc/freeradius/mods-enabled/expr including configuration file /etc/freeradius/mods-enabled/linelog including configuration file /etc/freeradius/mods-enabled/dhcp including configuration file /etc/freeradius/mods-enabled/ntlm_auth including configuration file /etc/freeradius/mods-enabled/sradutmp including configuration file /etc/freeradius/mods-enabled/replicate including configuration file /etc/freeradius/mods-enabled/utf8 including configuration file /etc/freeradius/mods-enabled/eap including configuration file /etc/freeradius/mods-enabled/detail.log including configuration file /etc/freeradius/mods-enabled/dynamic_clients including configuration file /etc/freeradius/mods-enabled/attr_filter including configuration file /etc/freeradius/mods-enabled/detail including configuration file /etc/freeradius/mods-enabled/preprocess including configuration file /etc/freeradius/mods-enabled/unix including configuration file /etc/freeradius/mods-enabled/soh including configuration file /etc/freeradius/mods-enabled/digest including configuration file /etc/freeradius/mods-enabled/echo including configuration file /etc/freeradius/mods-enabled/logintime including files in directory /etc/freeradius/policy.d/ including configuration file /etc/freeradius/policy.d/filter including configuration file /etc/freeradius/policy.d/cui including configuration file /etc/freeradius/policy.d/operator-name including configuration file /etc/freeradius/policy.d/control including configuration file /etc/freeradius/policy.d/dhcp including configuration file /etc/freeradius/policy.d/eap including configuration file /etc/freeradius/policy.d/accounting including configuration file /etc/freeradius/policy.d/canonicalization including files in directory /etc/freeradius/sites-enabled/ including configuration file /etc/freeradius/sites-enabled/check-eap-tls including configuration file /etc/freeradius/sites-enabled/port-2812-wifi-atm including configuration file /etc/freeradius/sites-enabled/port-3812-wifi-pro including configuration file /etc/freeradius/sites-enabled/control-socket including configuration file /etc/freeradius/sites-enabled/port-1812-mac-auth including configuration file /etc/freeradius/sites-enabled/inner-tunnel main { security { user = "freerad" group = "freerad" allow_core_dumps = no } } main { name = "freeradius" prefix = "/usr" localstatedir = "/var" sbindir = "/usr/sbin" logdir = "/var/log/freeradius" run_dir = "/var/run/freeradius" libdir = "/usr/lib/freeradius" radacctdir = "/var/log/freeradius/radacct" hostname_lookups = no max_request_time = 30 cleanup_delay = 5 max_requests = 1024 pidfile = "/var/run/freeradius/freeradius.pid" checkrad = "/usr/sbin/checkrad" debug_level = 0 proxy_requests = yes log { stripped_names = no auth = no auth_badpass = no auth_goodpass = no colourise = yes } 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 } home_server AD_chldc1 { ipaddr = 172.16.10.61 port = 1812 type = "auth+acct" secret = "123456" response_window = 3 max_outstanding = 65536 zombie_period = 40 status_check = "request" ping_interval = 30 check_interval = 30 num_answers_to_alive = 3 revive_interval = 300 status_check_timeout = 4 username = "testuser" password = "testpw" coa { irt = 2 mrt = 16 mrc = 5 mrd = 30 } limit { max_connections = 16 max_requests = 0 lifetime = 0 idle_timeout = 0 } } home_server AD_chldc2 { ipaddr = 172.16.10.62 port = 1812 type = "auth+acct" secret = "123456" response_window = 3 max_outstanding = 65536 zombie_period = 40 status_check = "request" ping_interval = 30 check_interval = 30 num_answers_to_alive = 3 revive_interval = 300 status_check_timeout = 4 username = "testuser" password = "testpw" coa { irt = 2 mrt = 16 mrc = 5 mrd = 30 } limit { max_connections = 16 max_requests = 0 lifetime = 0 idle_timeout = 0 } } home_server localhost { ipaddr = 127.0.0.1 port = 1812 type = "auth" secret = "testing123" response_window = 20 max_outstanding = 65536 zombie_period = 40 status_check = "status-server" ping_interval = 30 check_interval = 30 num_answers_to_alive = 3 revive_interval = 120 status_check_timeout = 4 coa { irt = 2 mrt = 16 mrc = 5 mrd = 30 } limit { max_connections = 16 max_requests = 0 lifetime = 0 idle_timeout = 0 } } home_server_pool AD_pool { type = client-balance home_server = AD_chldc1 home_server = AD_chldc2 } realm host { pool = AD_pool nostrip } realm MILETRIE { pool = AD_pool nostrip } home_server_pool my_auth_failover { type = fail-over home_server = localhost } realm example.com { auth_pool = my_auth_failover } realm LOCAL { } radiusd: #### Loading Clients #### client localhost { ipaddr = 127.0.0.1 require_message_authenticator = no secret = "testing123" nas_type = "other" proto = "*" limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } radiusd: #### Instantiating modules #### instantiate { } modules { # Loaded module rlm_realm # Instantiating module "IPASS" from file /etc/freeradius/mods-enabled/realm realm IPASS { format = "prefix" delimiter = "/" ignore_default = no ignore_null = no } # Instantiating module "suffix" from file /etc/freeradius/mods-enabled/realm realm suffix { format = "suffix" delimiter = "@" ignore_default = no ignore_null = no } # Instantiating module "realmpercent" from file /etc/freeradius/mods-enabled/realm realm realmpercent { format = "suffix" delimiter = "%" ignore_default = no ignore_null = no } # Instantiating module "ntdomain" from file /etc/freeradius/mods-enabled/realm realm ntdomain { format = "prefix" delimiter = "\" ignore_default = no ignore_null = no } # Loaded module rlm_sql # Instantiating module "sql" from file /etc/freeradius/mods-enabled/sql sql { driver = "rlm_sql_mysql" server = "dev.ch-poitiers.fr" port = "" login = "radius" password = "123456" radius_db = "radius" read_groups = yes read_clients = yes delete_stale_sessions = yes sql_user_name = "%{User-Name}" default_user_profile = "" client_query = "SELECT id, nasname, shortname, type, secret, server FROM nas" authorize_check_query = "SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id" authorize_reply_query = "SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id" authorize_group_check_query = "SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id" authorize_group_reply_query = "SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id" group_membership_query = "SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority" simul_count_query = "SELECT COUNT(*) FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL" simul_verify_query = "SELECT radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocol FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL" safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" } accounting { reference = "%{tolower:type.%{Acct-Status-Type}.query}" } post-auth { reference = ".query" } mysql { tls { } } rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to database "radius" rlm_sql (sql): Initialising connection pool pool { start = 5 min = 3 max = 10 spare = 3 uses = 0 lifetime = 0 cleanup_delay = 5 idle_timeout = 120 spread = no } rlm_sql (sql): Opening additional connection (0) rlm_sql_mysql: Starting connect to MySQL server rlm_sql (sql): Opening additional connection (1) rlm_sql_mysql: Starting connect to MySQL server rlm_sql (sql): Opening additional connection (2) rlm_sql_mysql: Starting connect to MySQL server rlm_sql (sql): Opening additional connection (3) rlm_sql_mysql: Starting connect to MySQL server rlm_sql (sql): Opening additional connection (4) rlm_sql_mysql: Starting connect to MySQL server rlm_sql (sql): Processing generate_sql_clients rlm_sql (sql) in generate_sql_clients: query is SELECT id, nasname, shortname, type, secret, server FROM nas rlm_sql (sql): Reserved connection (4) rlm_sql (sql): Executing query: 'SELECT id, nasname, shortname, type, secret, server FROM nas' rlm_sql (sql): Adding client wap54g.ch-poitiers.fr (wap54g) to global clients list rlm_sql (172.16.10.107): Client "wap54g" (sql) added rlm_sql (sql): Adding client sw-test2.ch-poitiers.fr (sw-test2) to global clients list rlm_sql (172.27.10.221): Client "sw-test2" (sql) added rlm_sql (sql): Adding client sw-atelier.ch-poitiers.fr (sw-atelier) to global clients list rlm_sql (172.27.10.219): Client "sw-atelier" (sql) added rlm_sql (sql): Adding client sw-mosaique.ch-poitiers.fr (sw-mosaique) to global clients list rlm_sql (172.31.9.1): Client "sw-mosaique" (sql) added rlm_sql (sql): Adding client 172.27.50.200 (hp-formation) to global clients list rlm_sql (172.27.50.200): Client "hp-formation" (sql) added rlm_sql (sql): Adding client sw-hp.ch-poitiers.fr (sw-hp) to global clients list Failed to look up hostname sw-hp.ch-poitiers.fr: ip_hton: Name or service not known rlm_sql (sql): Adding client sw-admin-a3.ch-poitiers.fr (sw-admin-a3) to global clients list rlm_sql (172.27.10.200): Client "sw-admin-a3" (sql) added rlm_sql (sql): Adding client sw-admin-a1.ch-poitiers.fr (sw-admin-a1) to global clients list rlm_sql (172.27.10.203): Client "sw-admin-a1" (sql) added rlm_sql (sql): Adding client sw-pinel-a.ch-poitiers.fr (sw-pinel-a) to global clients list rlm_sql (172.27.50.6): Client "sw-pinel-a" (sql) added rlm_sql (sql): Adding client sw-pinel-b.ch-poitiers.fr (sw-pinel-b) to global clients list rlm_sql (172.27.50.1): Client "sw-pinel-b" (sql) added rlm_sql (sql): Adding client sw-pinel-c.ch-poitiers.fr (sw-pinel-c) to global clients list rlm_sql (172.27.50.3): Client "sw-pinel-c" (sql) added rlm_sql (sql): Adding client sw-pinel-d.ch-poitiers.fr (sw-pinel-d) to global clients list rlm_sql (172.27.50.4): Client "sw-pinel-d" (sql) added rlm_sql (sql): Adding client sw-pinel-e.ch-poitiers.fr (sw-pinel-e) to global clients list rlm_sql (172.27.50.2): Client "sw-pinel-e" (sql) added rlm_sql (sql): Adding client sw-pinel-f.ch-poitiers.fr (sw-pinel-f) to global clients list rlm_sql (172.27.50.5): Client "sw-pinel-f" (sql) added rlm_sql (sql): Adding client sw-test-poe.ch-poitiers.fr (sw-test-poe) to global clients list rlm_sql (172.27.8.253): Client "sw-test-poe" (sql) added rlm_sql (sql): Adding client sw-espace-vienne.ch-poitiers.fr (sw-espace-vienne) to global clients list rlm_sql (172.31.17.1): Client "sw-espace-vienne" (sql) added rlm_sql (sql): Adding client sw-toulouse-nord.ch-poitiers.fr (sw-toulouse-nord) to global clients list rlm_sql (172.27.80.1): Client "sw-toulouse-nord" (sql) added rlm_sql (sql): Adding client sw-toulouse-sud.ch-poitiers.fr (sw-toulouse-sud) to global clients list rlm_sql (172.27.80.2): Client "sw-toulouse-sud" (sql) added rlm_sql (sql): Adding client sw-urc.ch-poitiers.fr (sw-urc) to global clients list rlm_sql (172.27.75.1): Client "sw-urc" (sql) added rlm_sql (sql): Adding client sw-empe.ch-poitiers.fr (sw-empe) to global clients list rlm_sql (172.27.90.1): Client "sw-empe" (sql) added rlm_sql (sql): Adding client sw-empe-b.ch-poitiers.fr (sw-empe-b) to global clients list rlm_sql (172.27.90.2): Client "sw-empe-b" (sql) added rlm_sql (sql): Adding client sw-amadeus.ch-poitiers.fr (sw-amadeus) to global clients list rlm_sql (172.27.35.1): Client "sw-amadeus" (sql) added rlm_sql (sql): Adding client sw-tony-laine.ch-poitiers.fr (sw-tony-laine) to global clients list rlm_sql (172.27.110.1): Client "sw-tony-laine" (sql) added rlm_sql (sql): Adding client sw-mas-vouille-voip.ch-poitiers.fr (sw-mas-vouille-voip) to global clients list rlm_sql (172.31.26.1): Client "sw-mas-vouille-voip" (sql) added rlm_sql (sql): Adding client sw-janet-a.ch-poitiers.fr (sw-janet-a) to global clients list rlm_sql (172.27.30.1): Client "sw-janet-a" (sql) added rlm_sql (sql): Adding client sw-janet-b.ch-poitiers.fr (sw-janet-b) to global clients list rlm_sql (172.27.30.2): Client "sw-janet-b" (sql) added rlm_sql (sql): Adding client sw-lagrange.ch-poitiers.fr (sw-lagrange) to global clients list rlm_sql (172.27.70.1): Client "sw-lagrange" (sql) added rlm_sql (sql): Adding client sw-dim.ch-poitiers.fr (sw-dim) to global clients list rlm_sql (172.27.12.1): Client "sw-dim" (sql) added rlm_sql (sql): Adding client sw-admin-b.ch-poitiers.fr (sw-admin-b) to global clients list rlm_sql (172.27.11.1): Client "sw-admin-b" (sql) added rlm_sql (sql): Adding client sw-relais-b.ch-poitiers.fr (sw-relais-b) to global clients list rlm_sql (172.27.40.1): Client "sw-relais-b" (sql) added rlm_sql (sql): Adding client sw-relais-c.ch-poitiers.fr (sw-relais-c) to global clients list rlm_sql (172.27.40.3): Client "sw-relais-c" (sql) added rlm_sql (sql): Adding client sw-mink-a.ch-poitiers.fr (sw-mink-a) to global clients list rlm_sql (172.27.42.1): Client "sw-mink-a" (sql) added rlm_sql (sql): Adding client sw-mink-b.ch-poitiers.fr (sw-mink-b) to global clients list rlm_sql (172.27.42.2): Client "sw-mink-b" (sql) added rlm_sql (sql): Adding client sw-mink-c.ch-poitiers.fr (sw-mink-c) to global clients list rlm_sql (172.27.42.3): Client "sw-mink-c" (sql) added rlm_sql (sql): Adding client sw-cousin.ch-poitiers.fr (sw-cousin) to global clients list rlm_sql (172.27.60.1): Client "sw-cousin" (sql) added rlm_sql (sql): Adding client sw-aji-voip.ch-poitiers.fr (sw-aji-voip) to global clients list rlm_sql (172.31.18.1): Client "sw-aji-voip" (sql) added rlm_sql (sql): Adding client sw-esat-voip.ch-poitiers.fr (sw-esat-voip) to global clients list rlm_sql (172.31.29.29): Client "sw-esat-voip" (sql) added rlm_sql (sql): Adding client sw-vangogh.ch-poitiers.fr (sw-vangogh) to global clients list rlm_sql (172.27.25.1): Client "sw-vangogh" (sql) added rlm_sql (sql): Adding client sw-loudun.ch-poitiers.fr (sw-loudun) to global clients list rlm_sql (172.31.7.1): Client "sw-loudun" (sql) added rlm_sql (sql): Adding client sw-tourniquet.ch-poitiers.fr (sw-tourniquet) to global clients list rlm_sql (172.31.4.1): Client "sw-tourniquet" (sql) added rlm_sql (sql): Adding client sw-tourniquet-chatel.ch-poitiers.fr (sw-tourniquet-chatel) to global clients list rlm_sql (172.31.32.1): Client "sw-tourniquet-chatel" (sql) added rlm_sql (sql): Adding client sw-dolto-voip.ch-poitiers.fr (sw-dolto-voip) to global clients list rlm_sql (172.31.2.1): Client "sw-dolto-voip" (sql) added rlm_sql (sql): Adding client sw-dolto-a.ch-poitiers.fr (sw-dolto-a) to global clients list rlm_sql (172.31.2.2): Client "sw-dolto-a" (sql) added rlm_sql (sql): Adding client sw-dolto-b.ch-poitiers.fr (sw-dolto-b) to global clients list rlm_sql (172.31.2.3): Client "sw-dolto-b" (sql) added rlm_sql (sql): Adding client sw-dolto-c.ch-poitiers.fr (sw-dolto-c) to global clients list rlm_sql (172.31.2.4): Client "sw-dolto-c" (sql) added rlm_sql (sql): Adding client sw-esat.ch-poitiers.fr (sw-esat) to global clients list rlm_sql (172.31.29.1): Client "sw-esat" (sql) added rlm_sql (sql): Adding client sw-esat-b.ch-poitiers.fr (sw-esat-b) to global clients list rlm_sql (172.31.29.2): Client "sw-esat-b" (sql) added rlm_sql (sql): Adding client sw-esat-c.ch-poitiers.fr (sw-esat-c) to global clients list rlm_sql (172.31.29.3): Client "sw-esat-c" (sql) added rlm_sql (sql): Adding client sw-sevres.ch-poitiers.fr (sw-sevres) to global clients list rlm_sql (172.31.20.1): Client "sw-sevres" (sql) added rlm_sql (sql): Adding client sw-pre-medard.ch-poitiers.fr (sw-pre-medard) to global clients list rlm_sql (172.31.13.1): Client "sw-pre-medard" (sql) added rlm_sql (sql): Adding client sw-isatis.ch-poitiers.fr (sw-isatis) to global clients list rlm_sql (172.31.16.1): Client "sw-isatis" (sql) added rlm_sql (sql): Adding client sw-3logis-voip.ch-poitiers.fr (sw-3logis-voip) to global clients list rlm_sql (172.31.15.1): Client "sw-3logis-voip" (sql) added rlm_sql (sql): Adding client sw-sablons-voip.ch-poitiers.fr (sw-sablons-voip) to global clients list rlm_sql (172.31.23.1): Client "sw-sablons-voip" (sql) added rlm_sql (sql): Adding client sw-cecat.ch-poitiers.fr (sw-cecat) to global clients list rlm_sql (172.31.5.1): Client "sw-cecat" (sql) added rlm_sql (sql): Adding client sw-csocial.ch-poitiers.fr (sw-csocial) to global clients list rlm_sql (172.27.65.1): Client "sw-csocial" (sql) added rlm_sql (sql): Adding client sw-gay-lussac-voip.ch-poitiers.fr (sw-gay-lussac-voip) to global clients list rlm_sql (172.31.30.1): Client "sw-gay-lussac-voip" (sql) added rlm_sql (sql): Adding client sw-gay-lussac.ch-poitiers.fr (sw-gay-lussac) to global clients list rlm_sql (172.31.30.2): Client "sw-gay-lussac" (sql) added rlm_sql (sql): Adding client sw-mlking.ch-poitiers.fr (sw-mlking) to global clients list rlm_sql (172.31.12.1): Client "sw-mlking" (sql) added rlm_sql (sql): Adding client sw-schuman.ch-poitiers.fr (sw-schuman) to global clients list rlm_sql (172.31.6.1): Client "sw-schuman" (sql) added rlm_sql (sql): Adding client sw-dset.ch-poitiers.fr (sw-dset) to global clients list rlm_sql (172.27.20.1): Client "sw-dset" (sql) added rlm_sql (sql): Adding client sw-archives.ch-poitiers.fr (sw-archives) to global clients list rlm_sql (172.27.45.1): Client "sw-archives" (sql) added rlm_sql (sql): Adding client sw-smpr.ch-poitiers.fr (sw-smpr) to global clients list rlm_sql (172.31.31.1): Client "sw-smpr" (sql) added rlm_sql (sql): Adding client sw-umpc.ch-poitiers.fr (sw-umpc) to global clients list rlm_sql (172.31.3.1): Client "sw-umpc" (sql) added rlm_sql (sql): Adding client sw-formation.ch-poitiers.fr (sw-formation) to global clients list rlm_sql (172.27.120.1): Client "sw-formation" (sql) added rlm_sql (sql): Adding client radius-test.ch-poitiers.fr (radius-test) to global clients list rlm_sql (172.27.10.129): Client "radius-test" (sql) added rlm_sql (sql): Adding client eon.ch-poitiers.fr (eon) to global clients list rlm_sql (172.27.10.61): Client "eon" (sql) added rlm_sql (sql): Adding client ap-dafsi.ch-poitiers.fr (ap-dafsi) to global clients list rlm_sql (172.27.10.11): Client "ap-dafsi" (sql) added rlm_sql (sql): Adding client wapc1.ch-poitiers.fr (wapc1) to global clients list rlm_sql (172.27.10.17): Client "wapc1" (sql) added rlm_sql (sql): Adding client 172.20.12.200 (ap-200) to global clients list rlm_sql (172.20.12.200): Client "ap-200" (sql) added rlm_sql (sql): Adding client 172.20.12.199 (ap-199) to global clients list rlm_sql (172.20.12.199): Client "ap-199" (sql) added rlm_sql (sql): Adding client 172.20.12.198 (ap-198) to global clients list rlm_sql (172.20.12.198): Client "ap-198" (sql) added rlm_sql (sql): Adding client 172.20.12.197 (ap-197) to global clients list rlm_sql (172.20.12.197): Client "ap-197" (sql) added rlm_sql (sql): Adding client 172.20.12.196 (ap-196) to global clients list rlm_sql (172.20.12.196): Client "ap-196" (sql) added rlm_sql (sql): Adding client 172.20.12.195 (ap-195) to global clients list rlm_sql (172.20.12.195): Client "ap-195" (sql) added rlm_sql (sql): Adding client sw-test.ch-poitiers.fr (sw-test) to global clients list rlm_sql (172.27.10.222): Client "sw-test" (sql) added rlm_sql (sql): Adding client 172.31.5.125 (ap-cecat-125) to global clients list rlm_sql (172.31.5.125): Client "ap-cecat-125" (sql) added rlm_sql (sql): Adding client 172.20.12.194 (ap-194) to global clients list rlm_sql (172.20.12.194): Client "ap-194" (sql) added rlm_sql (sql): Adding client 172.20.12.193 (ap-193) to global clients list rlm_sql (172.20.12.193): Client "ap-193" (sql) added rlm_sql (sql): Adding client 172.20.12.192 (ap-192) to global clients list rlm_sql (172.20.12.192): Client "ap-192" (sql) added rlm_sql (sql): Adding client 172.20.12.191 (ap-191) to global clients list rlm_sql (172.20.12.191): Client "ap-191" (sql) added rlm_sql (sql): Adding client 172.20.12.190 (ap-190) to global clients list rlm_sql (172.20.12.190): Client "ap-190" (sql) added rlm_sql (sql): Adding client 172.20.12.189 (ap-189) to global clients list rlm_sql (172.20.12.189): Client "ap-189" (sql) added rlm_sql (sql): Adding client 172.20.12.188 (ap-188) to global clients list rlm_sql (172.20.12.188): Client "ap-188" (sql) added rlm_sql (sql): Adding client 172.20.12.187 (ap-187) to global clients list rlm_sql (172.20.12.187): Client "ap-187" (sql) added rlm_sql (sql): Adding client 172.20.12.186 (ap-186) to global clients list rlm_sql (172.20.12.186): Client "ap-186" (sql) added rlm_sql (sql): Adding client 172.20.12.185 (ap-185) to global clients list rlm_sql (172.20.12.185): Client "ap-185" (sql) added rlm_sql (sql): Adding client 172.20.12.184 (ap-184) to global clients list rlm_sql (172.20.12.184): Client "ap-184" (sql) added rlm_sql (sql): Adding client 172.20.12.183 (ap-183) to global clients list rlm_sql (172.20.12.183): Client "ap-183" (sql) added rlm_sql (sql): Adding client 172.20.12.182 (ap-182) to global clients list rlm_sql (172.20.12.182): Client "ap-182" (sql) added rlm_sql (sql): Adding client 172.20.12.181 (ap-181) to global clients list rlm_sql (172.20.12.181): Client "ap-181" (sql) added rlm_sql (sql): Adding client 172.20.12.180 (ap-180) to global clients list rlm_sql (172.20.12.180): Client "ap-180" (sql) added rlm_sql (sql): Adding client 172.20.12.179 (ap-179) to global clients list rlm_sql (172.20.12.179): Client "ap-179" (sql) added rlm_sql (sql): Adding client 172.20.12.178 (ap-178) to global clients list rlm_sql (172.20.12.178): Client "ap-178" (sql) added rlm_sql (sql): Adding client 172.20.12.177 (ap-177) to global clients list rlm_sql (172.20.12.177): Client "ap-177" (sql) added rlm_sql (sql): Adding client 172.20.12.176 (ap-176) to global clients list rlm_sql (172.20.12.176): Client "ap-176" (sql) added rlm_sql (sql): Adding client 172.20.12.175 (ap-175) to global clients list rlm_sql (172.20.12.175): Client "ap-175" (sql) added rlm_sql (sql): Adding client 172.20.12.174 (ap-174) to global clients list rlm_sql (172.20.12.174): Client "ap-174" (sql) added rlm_sql (sql): Adding client 172.20.12.173 (ap-173) to global clients list rlm_sql (172.20.12.173): Client "ap-173" (sql) added rlm_sql (sql): Adding client 172.20.12.172 (ap-172) to global clients list rlm_sql (172.20.12.172): Client "ap-172" (sql) added rlm_sql (sql): Adding client 172.20.12.171 (ap-171) to global clients list rlm_sql (172.20.12.171): Client "ap-171" (sql) added rlm_sql (sql): Adding client 172.20.12.170 (ap-170) to global clients list rlm_sql (172.20.12.170): Client "ap-170" (sql) added rlm_sql (sql): Adding client 172.20.12.169 (ap-169) to global clients list rlm_sql (172.20.12.169): Client "ap-169" (sql) added rlm_sql (sql): Adding client 172.20.12.168 (ap-168) to global clients list rlm_sql (172.20.12.168): Client "ap-168" (sql) added rlm_sql (sql): Adding client 172.20.12.167 (ap-167) to global clients list rlm_sql (172.20.12.167): Client "ap-167" (sql) added rlm_sql (sql): Adding client 172.20.12.166 (ap-166) to global clients list rlm_sql (172.20.12.166): Client "ap-166" (sql) added rlm_sql (sql): Adding client 172.20.12.165 (ap-165) to global clients list rlm_sql (172.20.12.165): Client "ap-165" (sql) added rlm_sql (sql): Adding client 172.20.12.164 (ap-164) to global clients list rlm_sql (172.20.12.164): Client "ap-164" (sql) added rlm_sql (sql): Adding client 172.20.12.163 (ap-163) to global clients list rlm_sql (172.20.12.163): Client "ap-163" (sql) added rlm_sql (sql): Adding client 172.20.12.162 (ap-162) to global clients list rlm_sql (172.20.12.162): Client "ap-162" (sql) added rlm_sql (sql): Adding client 172.20.12.161 (ap-161) to global clients list rlm_sql (172.20.12.161): Client "ap-161" (sql) added rlm_sql (sql): Adding client 172.20.12.160 (ap-160) to global clients list rlm_sql (172.20.12.160): Client "ap-160" (sql) added rlm_sql (sql): Adding client 172.20.12.159 (ap-159) to global clients list rlm_sql (172.20.12.159): Client "ap-159" (sql) added rlm_sql (sql): Adding client 172.20.12.158 (ap-158) to global clients list rlm_sql (172.20.12.158): Client "ap-158" (sql) added rlm_sql (sql): Adding client 172.20.12.157 (ap-157) to global clients list rlm_sql (172.20.12.157): Client "ap-157" (sql) added rlm_sql (sql): Adding client 172.20.12.156 (ap-156) to global clients list rlm_sql (172.20.12.156): Client "ap-156" (sql) added rlm_sql (sql): Adding client 172.20.12.155 (ap-155) to global clients list rlm_sql (172.20.12.155): Client "ap-155" (sql) added rlm_sql (sql): Adding client 172.20.12.154 (ap-154) to global clients list rlm_sql (172.20.12.154): Client "ap-154" (sql) added rlm_sql (sql): Adding client 172.20.12.153 (ap-153) to global clients list rlm_sql (172.20.12.153): Client "ap-153" (sql) added rlm_sql (sql): Adding client 172.20.12.152 (ap-152) to global clients list rlm_sql (172.20.12.152): Client "ap-152" (sql) added rlm_sql (sql): Adding client 172.20.12.151 (ap-151) to global clients list rlm_sql (172.20.12.151): Client "ap-151" (sql) added rlm_sql (sql): Adding client 172.20.12.150 (ap-150) to global clients list rlm_sql (172.20.12.150): Client "ap-150" (sql) added rlm_sql (sql): Adding client 172.20.12.149 (ap-149) to global clients list rlm_sql (172.20.12.149): Client "ap-149" (sql) added rlm_sql (sql): Adding client 172.20.12.148 (ap-148) to global clients list rlm_sql (172.20.12.148): Client "ap-148" (sql) added rlm_sql (sql): Adding client 172.20.12.147 (ap-147) to global clients list rlm_sql (172.20.12.147): Client "ap-147" (sql) added rlm_sql (sql): Adding client 172.20.12.146 (ap-146) to global clients list rlm_sql (172.20.12.146): Client "ap-146" (sql) added rlm_sql (sql): Adding client 172.20.12.145 (ap-145) to global clients list rlm_sql (172.20.12.145): Client "ap-145" (sql) added rlm_sql (sql): Adding client 172.20.12.144 (ap-144) to global clients list rlm_sql (172.20.12.144): Client "ap-144" (sql) added rlm_sql (sql): Adding client 172.20.12.143 (ap-143) to global clients list rlm_sql (172.20.12.143): Client "ap-143" (sql) added rlm_sql (sql): Adding client 172.20.12.142 (ap-142) to global clients list rlm_sql (172.20.12.142): Client "ap-142" (sql) added rlm_sql (sql): Adding client 172.20.12.141 (ap-141) to global clients list rlm_sql (172.20.12.141): Client "ap-141" (sql) added rlm_sql (sql): Adding client 172.20.12.140 (ap-140) to global clients list rlm_sql (172.20.12.140): Client "ap-140" (sql) added rlm_sql (sql): Adding client 172.20.12.139 (ap-139) to global clients list rlm_sql (172.20.12.139): Client "ap-139" (sql) added rlm_sql (sql): Adding client 172.20.12.138 (ap-138) to global clients list rlm_sql (172.20.12.138): Client "ap-138" (sql) added rlm_sql (sql): Adding client 172.20.12.137 (ap-137) to global clients list rlm_sql (172.20.12.137): Client "ap-137" (sql) added rlm_sql (sql): Adding client 172.20.12.136 (ap-136) to global clients list rlm_sql (172.20.12.136): Client "ap-136" (sql) added rlm_sql (sql): Adding client 172.20.12.135 (ap-135) to global clients list rlm_sql (172.20.12.135): Client "ap-135" (sql) added rlm_sql (sql): Adding client 172.20.12.134 (ap-134) to global clients list rlm_sql (172.20.12.134): Client "ap-134" (sql) added rlm_sql (sql): Adding client 172.20.12.133 (ap-133) to global clients list rlm_sql (172.20.12.133): Client "ap-133" (sql) added rlm_sql (sql): Adding client 172.20.12.132 (ap-132) to global clients list rlm_sql (172.20.12.132): Client "ap-132" (sql) added rlm_sql (sql): Adding client 172.20.12.131 (ap-131) to global clients list rlm_sql (172.20.12.131): Client "ap-131" (sql) added rlm_sql (sql): Adding client 172.20.12.130 (ap-130) to global clients list rlm_sql (172.20.12.130): Client "ap-130" (sql) added rlm_sql (sql): Adding client 172.20.12.129 (ap-129) to global clients list rlm_sql (172.20.12.129): Client "ap-129" (sql) added rlm_sql (sql): Adding client 172.20.12.128 (ap-128) to global clients list rlm_sql (172.20.12.128): Client "ap-128" (sql) added rlm_sql (sql): Adding client 172.20.12.127 (ap-127) to global clients list rlm_sql (172.20.12.127): Client "ap-127" (sql) added rlm_sql (sql): Adding client 172.20.12.126 (ap-126) to global clients list rlm_sql (172.20.12.126): Client "ap-126" (sql) added rlm_sql (sql): Adding client 172.20.12.125 (ap-125) to global clients list rlm_sql (172.20.12.125): Client "ap-125" (sql) added rlm_sql (sql): Adding client 172.20.12.124 (ap-124) to global clients list rlm_sql (172.20.12.124): Client "ap-124" (sql) added rlm_sql (sql): Adding client 172.20.12.123 (ap-123) to global clients list rlm_sql (172.20.12.123): Client "ap-123" (sql) added rlm_sql (sql): Adding client 172.20.12.122 (ap-122) to global clients list rlm_sql (172.20.12.122): Client "ap-122" (sql) added rlm_sql (sql): Adding client 172.20.12.121 (ap-121) to global clients list rlm_sql (172.20.12.121): Client "ap-121" (sql) added rlm_sql (sql): Adding client 172.20.12.120 (ap-120) to global clients list rlm_sql (172.20.12.120): Client "ap-120" (sql) added rlm_sql (sql): Adding client 172.20.12.119 (ap-119) to global clients list rlm_sql (172.20.12.119): Client "ap-119" (sql) added rlm_sql (sql): Adding client 172.20.12.118 (ap-118) to global clients list rlm_sql (172.20.12.118): Client "ap-118" (sql) added rlm_sql (sql): Adding client 172.20.12.117 (ap-117) to global clients list rlm_sql (172.20.12.117): Client "ap-117" (sql) added rlm_sql (sql): Adding client 172.20.12.116 (ap-116) to global clients list rlm_sql (172.20.12.116): Client "ap-116" (sql) added rlm_sql (sql): Adding client 172.20.12.115 (ap-115) to global clients list rlm_sql (172.20.12.115): Client "ap-115" (sql) added rlm_sql (sql): Adding client 172.20.12.114 (ap-114) to global clients list rlm_sql (172.20.12.114): Client "ap-114" (sql) added rlm_sql (sql): Adding client 172.20.12.113 (ap-113) to global clients list rlm_sql (172.20.12.113): Client "ap-113" (sql) added rlm_sql (sql): Adding client 172.20.12.112 (ap-112) to global clients list rlm_sql (172.20.12.112): Client "ap-112" (sql) added rlm_sql (sql): Adding client 172.20.12.111 (ap-111) to global clients list rlm_sql (172.20.12.111): Client "ap-111" (sql) added rlm_sql (sql): Adding client 172.20.12.110 (ap-110) to global clients list rlm_sql (172.20.12.110): Client "ap-110" (sql) added rlm_sql (sql): Adding client 172.20.12.109 (ap-109) to global clients list rlm_sql (172.20.12.109): Client "ap-109" (sql) added rlm_sql (sql): Adding client 172.20.12.108 (ap-108) to global clients list rlm_sql (172.20.12.108): Client "ap-108" (sql) added rlm_sql (sql): Adding client 172.20.12.107 (ap-107) to global clients list rlm_sql (172.20.12.107): Client "ap-107" (sql) added rlm_sql (sql): Adding client 172.20.12.106 (ap-106) to global clients list rlm_sql (172.20.12.106): Client "ap-106" (sql) added rlm_sql (sql): Adding client 172.20.12.105 (ap-105) to global clients list rlm_sql (172.20.12.105): Client "ap-105" (sql) added rlm_sql (sql): Adding client 172.20.12.104 (ap-104) to global clients list rlm_sql (172.20.12.104): Client "ap-104" (sql) added rlm_sql (sql): Adding client 172.20.12.103 (ap-103) to global clients list rlm_sql (172.20.12.103): Client "ap-103" (sql) added rlm_sql (sql): Adding client 172.20.12.102 (ap-102) to global clients list rlm_sql (172.20.12.102): Client "ap-102" (sql) added rlm_sql (sql): Adding client 172.20.12.101 (ap-101) to global clients list rlm_sql (172.20.12.101): Client "ap-101" (sql) added rlm_sql (sql): Adding client 172.20.12.100 (ap-100) to global clients list rlm_sql (172.20.12.100): Client "ap-100" (sql) added rlm_sql (sql): Adding client 172.20.12.99 (ap-99) to global clients list rlm_sql (172.20.12.99): Client "ap-99" (sql) added rlm_sql (sql): Adding client 172.20.12.98 (ap-98) to global clients list rlm_sql (172.20.12.98): Client "ap-98" (sql) added rlm_sql (sql): Adding client 172.20.12.97 (ap-97) to global clients list rlm_sql (172.20.12.97): Client "ap-97" (sql) added rlm_sql (sql): Adding client 172.20.12.96 (ap-96) to global clients list rlm_sql (172.20.12.96): Client "ap-96" (sql) added rlm_sql (sql): Adding client 172.20.12.95 (ap-95) to global clients list rlm_sql (172.20.12.95): Client "ap-95" (sql) added rlm_sql (sql): Adding client 172.20.12.94 (ap-94) to global clients list rlm_sql (172.20.12.94): Client "ap-94" (sql) added rlm_sql (sql): Adding client 172.20.12.93 (ap-93) to global clients list rlm_sql (172.20.12.93): Client "ap-93" (sql) added rlm_sql (sql): Adding client 172.20.12.92 (ap-92) to global clients list rlm_sql (172.20.12.92): Client "ap-92" (sql) added rlm_sql (sql): Adding client 172.20.12.91 (ap-91) to global clients list rlm_sql (172.20.12.91): Client "ap-91" (sql) added rlm_sql (sql): Adding client 172.20.12.90 (ap-90) to global clients list rlm_sql (172.20.12.90): Client "ap-90" (sql) added rlm_sql (sql): Adding client 172.20.12.89 (ap-89) to global clients list rlm_sql (172.20.12.89): Client "ap-89" (sql) added rlm_sql (sql): Adding client 172.20.12.88 (ap-88) to global clients list rlm_sql (172.20.12.88): Client "ap-88" (sql) added rlm_sql (sql): Adding client 172.20.12.87 (ap-87) to global clients list rlm_sql (172.20.12.87): Client "ap-87" (sql) added rlm_sql (sql): Adding client 172.20.12.86 (ap-86) to global clients list rlm_sql (172.20.12.86): Client "ap-86" (sql) added rlm_sql (sql): Adding client 172.20.12.85 (ap-85) to global clients list rlm_sql (172.20.12.85): Client "ap-85" (sql) added rlm_sql (sql): Adding client 172.20.12.84 (ap-84) to global clients list rlm_sql (172.20.12.84): Client "ap-84" (sql) added rlm_sql (sql): Adding client 172.20.12.83 (ap-83) to global clients list rlm_sql (172.20.12.83): Client "ap-83" (sql) added rlm_sql (sql): Adding client 172.20.12.82 (ap-82) to global clients list rlm_sql (172.20.12.82): Client "ap-82" (sql) added rlm_sql (sql): Adding client 172.20.12.81 (ap-81) to global clients list rlm_sql (172.20.12.81): Client "ap-81" (sql) added rlm_sql (sql): Adding client 172.20.12.80 (ap-80) to global clients list rlm_sql (172.20.12.80): Client "ap-80" (sql) added rlm_sql (sql): Adding client 172.20.12.79 (ap-79) to global clients list rlm_sql (172.20.12.79): Client "ap-79" (sql) added rlm_sql (sql): Adding client 172.20.12.78 (ap-78) to global clients list rlm_sql (172.20.12.78): Client "ap-78" (sql) added rlm_sql (sql): Adding client 172.20.12.77 (ap-77) to global clients list rlm_sql (172.20.12.77): Client "ap-77" (sql) added rlm_sql (sql): Adding client 172.20.12.76 (ap-76) to global clients list rlm_sql (172.20.12.76): Client "ap-76" (sql) added rlm_sql (sql): Adding client 172.20.12.75 (ap-75) to global clients list rlm_sql (172.20.12.75): Client "ap-75" (sql) added rlm_sql (sql): Adding client 172.20.12.74 (ap-74) to global clients list rlm_sql (172.20.12.74): Client "ap-74" (sql) added rlm_sql (sql): Adding client 172.20.12.73 (ap-73) to global clients list rlm_sql (172.20.12.73): Client "ap-73" (sql) added rlm_sql (sql): Adding client 172.20.12.72 (ap-72) to global clients list rlm_sql (172.20.12.72): Client "ap-72" (sql) added rlm_sql (sql): Adding client 172.20.12.71 (ap-71) to global clients list rlm_sql (172.20.12.71): Client "ap-71" (sql) added rlm_sql (sql): Adding client 172.20.12.70 (ap-70) to global clients list rlm_sql (172.20.12.70): Client "ap-70" (sql) added rlm_sql (sql): Adding client 172.20.12.69 (ap-69) to global clients list rlm_sql (172.20.12.69): Client "ap-69" (sql) added rlm_sql (sql): Adding client 172.20.12.68 (ap-68) to global clients list rlm_sql (172.20.12.68): Client "ap-68" (sql) added rlm_sql (sql): Adding client 172.20.12.67 (ap-67) to global clients list rlm_sql (172.20.12.67): Client "ap-67" (sql) added rlm_sql (sql): Adding client 172.20.12.66 (ap-66) to global clients list rlm_sql (172.20.12.66): Client "ap-66" (sql) added rlm_sql (sql): Adding client 172.20.12.65 (ap-65) to global clients list rlm_sql (172.20.12.65): Client "ap-65" (sql) added rlm_sql (sql): Adding client 172.20.12.64 (ap-64) to global clients list rlm_sql (172.20.12.64): Client "ap-64" (sql) added rlm_sql (sql): Adding client 172.20.12.63 (ap-63) to global clients list rlm_sql (172.20.12.63): Client "ap-63" (sql) added rlm_sql (sql): Adding client 172.20.12.62 (ap-62) to global clients list rlm_sql (172.20.12.62): Client "ap-62" (sql) added rlm_sql (sql): Adding client 172.20.12.61 (ap-61) to global clients list rlm_sql (172.20.12.61): Client "ap-61" (sql) added rlm_sql (sql): Adding client 172.20.12.60 (ap-60) to global clients list rlm_sql (172.20.12.60): Client "ap-60" (sql) added rlm_sql (sql): Adding client 172.20.12.59 (ap-59) to global clients list rlm_sql (172.20.12.59): Client "ap-59" (sql) added rlm_sql (sql): Adding client 172.20.12.58 (ap-58) to global clients list rlm_sql (172.20.12.58): Client "ap-58" (sql) added rlm_sql (sql): Adding client 172.20.12.57 (ap-57) to global clients list rlm_sql (172.20.12.57): Client "ap-57" (sql) added rlm_sql (sql): Adding client 172.20.12.56 (ap-56) to global clients list rlm_sql (172.20.12.56): Client "ap-56" (sql) added rlm_sql (sql): Adding client 172.20.12.55 (ap-55) to global clients list rlm_sql (172.20.12.55): Client "ap-55" (sql) added rlm_sql (sql): Adding client 172.20.12.54 (ap-54) to global clients list rlm_sql (172.20.12.54): Client "ap-54" (sql) added rlm_sql (sql): Adding client 172.20.12.53 (ap-53) to global clients list rlm_sql (172.20.12.53): Client "ap-53" (sql) added rlm_sql (sql): Adding client 172.20.12.52 (ap-52) to global clients list rlm_sql (172.20.12.52): Client "ap-52" (sql) added rlm_sql (sql): Adding client 172.20.12.51 (ap-51) to global clients list rlm_sql (172.20.12.51): Client "ap-51" (sql) added rlm_sql (sql): Adding client 172.20.12.50 (ap-50) to global clients list rlm_sql (172.20.12.50): Client "ap-50" (sql) added rlm_sql (sql): Adding client 172.20.12.49 (ap-49) to global clients list rlm_sql (172.20.12.49): Client "ap-49" (sql) added rlm_sql (sql): Adding client 172.20.12.48 (ap-48) to global clients list rlm_sql (172.20.12.48): Client "ap-48" (sql) added rlm_sql (sql): Adding client 172.20.12.47 (ap-47) to global clients list rlm_sql (172.20.12.47): Client "ap-47" (sql) added rlm_sql (sql): Adding client 172.20.12.46 (ap-46) to global clients list rlm_sql (172.20.12.46): Client "ap-46" (sql) added rlm_sql (sql): Adding client 172.20.12.45 (ap-45) to global clients list rlm_sql (172.20.12.45): Client "ap-45" (sql) added rlm_sql (sql): Adding client 172.20.12.44 (ap-44) to global clients list rlm_sql (172.20.12.44): Client "ap-44" (sql) added rlm_sql (sql): Adding client 172.20.12.43 (ap-43) to global clients list rlm_sql (172.20.12.43): Client "ap-43" (sql) added rlm_sql (sql): Adding client 172.20.12.42 (ap-42) to global clients list rlm_sql (172.20.12.42): Client "ap-42" (sql) added rlm_sql (sql): Adding client 172.20.12.41 (ap-41) to global clients list rlm_sql (172.20.12.41): Client "ap-41" (sql) added rlm_sql (sql): Adding client 172.20.12.40 (ap-40) to global clients list rlm_sql (172.20.12.40): Client "ap-40" (sql) added rlm_sql (sql): Adding client 172.20.12.39 (ap-39) to global clients list rlm_sql (172.20.12.39): Client "ap-39" (sql) added rlm_sql (sql): Adding client 172.20.12.38 (ap-38) to global clients list rlm_sql (172.20.12.38): Client "ap-38" (sql) added rlm_sql (sql): Adding client 172.20.12.37 (ap-37) to global clients list rlm_sql (172.20.12.37): Client "ap-37" (sql) added rlm_sql (sql): Adding client 172.20.12.36 (ap-36) to global clients list rlm_sql (172.20.12.36): Client "ap-36" (sql) added rlm_sql (sql): Adding client 172.20.12.35 (ap-35) to global clients list rlm_sql (172.20.12.35): Client "ap-35" (sql) added rlm_sql (sql): Adding client 172.20.12.34 (ap-34) to global clients list rlm_sql (172.20.12.34): Client "ap-34" (sql) added rlm_sql (sql): Adding client 172.20.12.33 (ap-33) to global clients list rlm_sql (172.20.12.33): Client "ap-33" (sql) added rlm_sql (sql): Adding client 172.20.12.32 (ap-32) to global clients list rlm_sql (172.20.12.32): Client "ap-32" (sql) added rlm_sql (sql): Adding client 172.20.12.31 (ap-31) to global clients list rlm_sql (172.20.12.31): Client "ap-31" (sql) added rlm_sql (sql): Adding client 172.20.12.30 (ap-30) to global clients list rlm_sql (172.20.12.30): Client "ap-30" (sql) added rlm_sql (sql): Adding client 172.20.12.29 (ap-29) to global clients list rlm_sql (172.20.12.29): Client "ap-29" (sql) added rlm_sql (sql): Adding client 172.20.12.28 (ap-28) to global clients list rlm_sql (172.20.12.28): Client "ap-28" (sql) added rlm_sql (sql): Adding client 172.20.12.27 (ap-27) to global clients list rlm_sql (172.20.12.27): Client "ap-27" (sql) added rlm_sql (sql): Adding client 172.20.12.26 (ap-26) to global clients list rlm_sql (172.20.12.26): Client "ap-26" (sql) added rlm_sql (sql): Adding client 172.20.12.25 (ap-25) to global clients list rlm_sql (172.20.12.25): Client "ap-25" (sql) added rlm_sql (sql): Adding client 172.20.12.24 (ap-24) to global clients list rlm_sql (172.20.12.24): Client "ap-24" (sql) added rlm_sql (sql): Adding client 172.20.12.23 (ap-23) to global clients list rlm_sql (172.20.12.23): Client "ap-23" (sql) added rlm_sql (sql): Adding client 172.20.12.22 (ap-22) to global clients list rlm_sql (172.20.12.22): Client "ap-22" (sql) added rlm_sql (sql): Adding client 172.20.12.21 (ap-21) to global clients list rlm_sql (172.20.12.21): Client "ap-21" (sql) added rlm_sql (sql): Adding client 172.20.12.20 (ap-20) to global clients list rlm_sql (172.20.12.20): Client "ap-20" (sql) added rlm_sql (sql): Adding client 172.20.12.19 (ap-19) to global clients list rlm_sql (172.20.12.19): Client "ap-19" (sql) added rlm_sql (sql): Adding client 172.20.12.18 (ap-18) to global clients list rlm_sql (172.20.12.18): Client "ap-18" (sql) added rlm_sql (sql): Adding client 172.20.12.17 (ap-17) to global clients list rlm_sql (172.20.12.17): Client "ap-17" (sql) added rlm_sql (sql): Adding client 172.20.12.16 (ap-16) to global clients list rlm_sql (172.20.12.16): Client "ap-16" (sql) added rlm_sql (sql): Adding client 172.20.12.15 (ap-15) to global clients list rlm_sql (172.20.12.15): Client "ap-15" (sql) added rlm_sql (sql): Adding client 172.20.12.14 (ap-14) to global clients list rlm_sql (172.20.12.14): Client "ap-14" (sql) added rlm_sql (sql): Adding client 172.20.12.13 (ap-13) to global clients list rlm_sql (172.20.12.13): Client "ap-13" (sql) added rlm_sql (sql): Adding client 172.20.12.12 (ap-12) to global clients list rlm_sql (172.20.12.12): Client "ap-12" (sql) added rlm_sql (sql): Adding client 172.20.12.11 (ap-11) to global clients list rlm_sql (172.20.12.11): Client "ap-11" (sql) added rlm_sql (sql): Adding client 172.20.12.10 (ap-10) to global clients list rlm_sql (172.20.12.10): Client "ap-10" (sql) added rlm_sql (sql): Released connection (4) # Loaded module rlm_mschap # Instantiating module "mschap" from file /etc/freeradius/mods-enabled/mschap mschap { use_mppe = yes require_encryption = no require_strong = no with_ntdomain_hack = yes passchange { } allow_retry = yes } # Loaded module rlm_expiration # Instantiating module "expiration" from file /etc/freeradius/mods-enabled/expiration # Loaded module rlm_passwd # Instantiating module "etc_passwd" from file /etc/freeradius/mods-enabled/passwd passwd etc_passwd { filename = "/etc/passwd" format = "*User-Name:Crypt-Password:" delimiter = ":" ignore_nislike = no ignore_empty = yes allow_multiple_keys = no hash_size = 100 } rlm_passwd: nfields: 3 keyfield 0(User-Name) listable: no # Loaded module rlm_chap # Instantiating module "chap" from file /etc/freeradius/mods-enabled/chap # Loaded module rlm_always # Instantiating module "fail" from file /etc/freeradius/mods-enabled/always always fail { rcode = "fail" simulcount = 0 mpp = no } # Instantiating module "reject" from file /etc/freeradius/mods-enabled/always always reject { rcode = "reject" simulcount = 0 mpp = no } # Instantiating module "noop" from file /etc/freeradius/mods-enabled/always always noop { rcode = "noop" simulcount = 0 mpp = no } # Instantiating module "handled" from file /etc/freeradius/mods-enabled/always always handled { rcode = "handled" simulcount = 0 mpp = no } # Instantiating module "updated" from file /etc/freeradius/mods-enabled/always always updated { rcode = "updated" simulcount = 0 mpp = no } # Instantiating module "notfound" from file /etc/freeradius/mods-enabled/always always notfound { rcode = "notfound" simulcount = 0 mpp = no } # Instantiating module "ok" from file /etc/freeradius/mods-enabled/always always ok { rcode = "ok" simulcount = 0 mpp = no } # Loaded module rlm_cache # Instantiating module "cache_eap" from file /etc/freeradius/mods-enabled/cache_eap cache cache_eap { key = "%{%{control:State}:-%{%{reply:State}:-%{State}}}" ttl = 15 max_entries = 16384 epoch = 0 add_stats = no } # Loaded module rlm_radutmp # Instantiating module "radutmp" from file /etc/freeradius/mods-enabled/radutmp radutmp { filename = "/var/log/freeradius/radutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes permissions = 384 caller_id = yes } # Loaded module rlm_files # Instantiating module "files" from file /etc/freeradius/mods-enabled/files files { filename = "/etc/freeradius/mods-config/files/authorize" usersfile = "/etc/freeradius/mods-config/files/authorize" acctusersfile = "/etc/freeradius/mods-config/files/accounting" preproxy_usersfile = "/etc/freeradius/mods-config/files/pre-proxy" compat = "no" } reading pairlist file /etc/freeradius/mods-config/files/authorize reading pairlist file /etc/freeradius/mods-config/files/authorize reading pairlist file /etc/freeradius/mods-config/files/accounting reading pairlist file /etc/freeradius/mods-config/files/pre-proxy # Loaded module rlm_exec # Instantiating module "exec" from file /etc/freeradius/mods-enabled/exec exec { wait = no input_pairs = "request" shell_escape = yes timeout = 10 } # Loaded module rlm_ldap # Instantiating module "ldap1" from file /etc/freeradius/mods-enabled/ldap ldap ldap1 { server = "ldap1.ch-poitiers.fr" port = 389 password = "123456" identity = "cn=radius,ou=applications,dc=exemple,dc=fr" read_clients = no user { filter = "(uid=%{User-Name})" scope = "sub" base_dn = "ou=utilisateurs,dc=exemple,dc=fr" access_attribute = "chlRadiusAccess" access_positive = no } group { filter = "(objectClass=groupOfNames)" scope = "sub" base_dn = "ou=groupes,dc=exemple,dc=fr" name_attribute = "cn" membership_attribute = "memberOf" membership_filter = "(member=%{control:Ldap-UserDn})" cacheable_name = no cacheable_dn = no } client { scope = "sub" base_dn = "" attribute { identifier = "host" shortname = "cn" } } profile { filter = "(&)" } options { ldap_debug = 40 chase_referrals = no rebind = no net_timeout = 3 res_timeout = 20 srv_timelimit = 20 idle = 60 probes = 3 interval = 3 } tls { start_tls = no } } accounting { reference = "." } post-auth { reference = "." } rlm_ldap (ldap1): Initialising connection pool pool { start = 3 min = 3 max = 50 spare = 3 uses = 0 lifetime = 0 cleanup_delay = 5 idle_timeout = 900 spread = no } rlm_ldap (ldap1): Opening additional connection (0) rlm_ldap (ldap1): Connecting to ldap1.ch-poitiers.fr:389 rlm_ldap (ldap1): Waiting for bind result... rlm_ldap (ldap1): Bind successful rlm_ldap (ldap1): Opening additional connection (1) rlm_ldap (ldap1): Connecting to ldap1.ch-poitiers.fr:389 rlm_ldap (ldap1): Waiting for bind result... rlm_ldap (ldap1): Bind successful rlm_ldap (ldap1): Opening additional connection (2) rlm_ldap (ldap1): Connecting to ldap1.ch-poitiers.fr:389 rlm_ldap (ldap1): Waiting for bind result... rlm_ldap (ldap1): Bind successful # Instantiating module "ldap2" from file /etc/freeradius/mods-enabled/ldap ldap ldap2 { server = "ldap2.ch-poitiers.fr" port = 389 password = "123456" identity = "cn=radius,ou=applications,dc=exemple,dc=fr" read_clients = no user { filter = "(uid=%{User-Name})" scope = "sub" base_dn = "ou=utilisateurs,dc=exemple,dc=fr" access_attribute = "chlRadiusAccess" access_positive = no } group { filter = "(objectClass=groupOfNames)" scope = "sub" base_dn = "ou=groupes,dc=exemple,dc=fr" name_attribute = "cn" membership_attribute = "memberOf" membership_filter = "(member=%{control:Ldap-UserDn})" cacheable_name = no cacheable_dn = no } client { scope = "sub" base_dn = "" attribute { identifier = "host" shortname = "cn" } } profile { filter = "(&)" } options { ldap_debug = 40 chase_referrals = no rebind = no net_timeout = 3 res_timeout = 20 srv_timelimit = 20 idle = 60 probes = 3 interval = 3 } tls { start_tls = no } } accounting { reference = "." } post-auth { reference = "." } rlm_ldap (ldap2): Initialising connection pool pool { start = 3 min = 3 max = 50 spare = 3 uses = 0 lifetime = 0 cleanup_delay = 5 idle_timeout = 900 spread = no } rlm_ldap (ldap2): Opening additional connection (0) rlm_ldap (ldap2): Connecting to ldap2.ch-poitiers.fr:389 rlm_ldap (ldap2): Waiting for bind result... rlm_ldap (ldap2): Bind successful rlm_ldap (ldap2): Opening additional connection (1) rlm_ldap (ldap2): Connecting to ldap2.ch-poitiers.fr:389 rlm_ldap (ldap2): Waiting for bind result... rlm_ldap (ldap2): Bind successful rlm_ldap (ldap2): Opening additional connection (2) rlm_ldap (ldap2): Connecting to ldap2.ch-poitiers.fr:389 rlm_ldap (ldap2): Waiting for bind result... rlm_ldap (ldap2): Bind successful # Loaded module rlm_pap # Instantiating module "pap" from file /etc/freeradius/mods-enabled/pap pap { auto_header = no normalise = yes } # Loaded module rlm_expr # Instantiating module "expr" from file /etc/freeradius/mods-enabled/expr expr { safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" } # Loaded module rlm_linelog # Instantiating module "linelog" from file /etc/freeradius/mods-enabled/linelog linelog { filename = "/var/log/freeradius/linelog" permissions = 384 format = "This is a log message for %{User-Name}" reference = "%{%{Packet-Type}:-format}" } # Loaded module rlm_dhcp # Instantiating module "dhcp" from file /etc/freeradius/mods-enabled/dhcp # Instantiating module "ntlm_auth" from file /etc/freeradius/mods-enabled/ntlm_auth exec ntlm_auth { wait = yes program = "/path/to/ntlm_auth --request-nt-key --domain=MYDOMAIN --username=%{mschap:User-Name} --password=%{User-Password}" shell_escape = yes } # Instantiating module "sradutmp" from file /etc/freeradius/mods-enabled/sradutmp radutmp sradutmp { filename = "/var/log/freeradius/sradutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes permissions = 420 caller_id = no } # Loaded module rlm_replicate # Instantiating module "replicate" from file /etc/freeradius/mods-enabled/replicate # Loaded module rlm_utf8 # Instantiating module "utf8" from file /etc/freeradius/mods-enabled/utf8 # Loaded module rlm_eap # Instantiating module "eap-pro" from file /etc/freeradius/mods-enabled/eap eap eap-pro { default_eap_type = "md5" timer_expire = 60 ignore_unknown_eap_types = no mod_accounting_username_bug = no max_sessions = 4096 } # Linked to sub-module rlm_eap_md5 # Linked to sub-module rlm_eap_tls tls { tls = "tls-common" virtual_server = "check-eap-tls" } tls-config tls-common { rsa_key_exchange = no dh_key_exchange = yes rsa_key_length = 512 dh_key_length = 512 verify_depth = 0 pem_file_type = yes private_key_file = "/etc/freeradius/certs/radius.ch-poitiers.fr.pem.key" certificate_file = "/etc/freeradius/certs/radius.ch-poitiers.fr.pem.crt" ca_file = "/etc/freeradius/certs/chl-ca.crt" private_key_password = "123456" dh_file = "/etc/freeradius/certs/dh" fragment_size = 1024 include_length = yes check_crl = no cipher_list = "DEFAULT:-EXP:-LOW" ecdh_curve = "prime256v1" cache { enable = yes lifetime = 24 max_entries = 255 name = "EAP module" persist_dir = "/var/cache/freeradius/tlscache" } verify { } ocsp { enable = no override_cert_url = yes url = "http://127.0.0.1/ocsp/" use_nonce = yes timeout = 0 softfail = yes } } # Linked to sub-module rlm_eap_mschapv2 mschapv2 { with_ntdomain_hack = no send_error = no } # Instantiating module "eap-atm" from file /etc/freeradius/mods-enabled/eap eap eap-atm { default_eap_type = "md5" timer_expire = 60 ignore_unknown_eap_types = no mod_accounting_username_bug = no max_sessions = 4096 } # Linked to sub-module rlm_eap_md5 # Linked to sub-module rlm_eap_tls tls { tls = "tls-common" } tls-config tls-common { rsa_key_exchange = no dh_key_exchange = yes rsa_key_length = 512 dh_key_length = 512 verify_depth = 0 pem_file_type = yes private_key_file = "/etc/freeradius/certs/radius.ch-poitiers.fr.pem.key" certificate_file = "/etc/freeradius/certs/radius.ch-poitiers.fr.pem.crt" ca_file = "/etc/freeradius/certs/chl-ca.crt" private_key_password = "123456" dh_file = "/etc/freeradius/certs/dh" fragment_size = 1024 include_length = yes check_crl = no cipher_list = "DEFAULT:-EXP:-LOW" ecdh_curve = "prime256v1" cache { enable = yes lifetime = 24 max_entries = 255 name = "EAP module" persist_dir = "/var/cache/freeradius/tlscache" } verify { } ocsp { enable = no override_cert_url = yes url = "http://127.0.0.1/ocsp/" use_nonce = yes timeout = 0 softfail = yes } } # Linked to sub-module rlm_eap_ttls ttls { tls = "tls-common" default_eap_type = "md5" copy_request_to_tunnel = no use_tunneled_reply = no virtual_server = "inner-tunnel" include_length = yes require_client_cert = no } Using cached TLS configuration from previous invocation # Linked to sub-module rlm_eap_peap peap { tls = "tls-common" default_method = "mschapv2" copy_request_to_tunnel = no use_tunneled_reply = no proxy_tunneled_request_as_eap = yes virtual_server = "inner-tunnel" soh = no require_client_cert = no } Using cached TLS configuration from previous invocation # Linked to sub-module rlm_eap_mschapv2 mschapv2 { with_ntdomain_hack = no send_error = no } # Loaded module rlm_detail # Instantiating module "auth_log" from file /etc/freeradius/mods-enabled/detail.log detail auth_log { filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/auth-detail-%Y%m%d" header = "%t" permissions = 384 dir_permissions = 493 locking = no log_packet_header = no } rlm_detail (auth_log): 'User-Password' suppressed, will not appear in detail output # Instantiating module "reply_log" from file /etc/freeradius/mods-enabled/detail.log detail reply_log { filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/reply-detail-%Y%m%d" header = "%t" permissions = 384 dir_permissions = 493 locking = no log_packet_header = no } # Instantiating module "pre_proxy_log" from file /etc/freeradius/mods-enabled/detail.log detail pre_proxy_log { filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/pre-proxy-detail-%Y%m%d" header = "%t" permissions = 384 dir_permissions = 493 locking = no log_packet_header = no } # Instantiating module "post_proxy_log" from file /etc/freeradius/mods-enabled/detail.log detail post_proxy_log { filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/post-proxy-detail-%Y%m%d" header = "%t" permissions = 384 dir_permissions = 493 locking = no log_packet_header = no } # Loaded module rlm_dynamic_clients # Instantiating module "dynamic_clients" from file /etc/freeradius/mods-enabled/dynamic_clients # Loaded module rlm_attr_filter # Instantiating module "attr_filter.post-proxy" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.post-proxy { filename = "/etc/freeradius/mods-config/attr_filter/post-proxy" key = "%{Realm}" relaxed = no } reading pairlist file /etc/freeradius/mods-config/attr_filter/post-proxy # Instantiating module "attr_filter.pre-proxy" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.pre-proxy { filename = "/etc/freeradius/mods-config/attr_filter/pre-proxy" key = "%{Realm}" relaxed = no } reading pairlist file /etc/freeradius/mods-config/attr_filter/pre-proxy # Instantiating module "attr_filter.access_reject" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.access_reject { filename = "/etc/freeradius/mods-config/attr_filter/access_reject" key = "%{User-Name}" relaxed = no } reading pairlist file /etc/freeradius/mods-config/attr_filter/access_reject # Instantiating module "attr_filter.access_challenge" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.access_challenge { filename = "/etc/freeradius/mods-config/attr_filter/access_challenge" key = "%{User-Name}" relaxed = no } reading pairlist file /etc/freeradius/mods-config/attr_filter/access_challenge # Instantiating module "attr_filter.accounting_response" from file /etc/freeradius/mods-enabled/attr_filter attr_filter attr_filter.accounting_response { filename = "/etc/freeradius/mods-config/attr_filter/accounting_response" key = "%{User-Name}" relaxed = no } reading pairlist file /etc/freeradius/mods-config/attr_filter/accounting_response # Instantiating module "detail" from file /etc/freeradius/mods-enabled/detail detail { filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d" header = "%t" permissions = 384 dir_permissions = 493 locking = no log_packet_header = no } # Loaded module rlm_preprocess # Instantiating module "preprocess" from file /etc/freeradius/mods-enabled/preprocess preprocess { huntgroups = "/etc/freeradius/mods-config/preprocess/huntgroups" hints = "/etc/freeradius/mods-config/preprocess/hints" with_ascend_hack = no ascend_channels_per_line = 23 with_ntdomain_hack = no with_specialix_jetstream_hack = no with_cisco_vsa_hack = no with_alvarion_vsa_hack = no } reading pairlist file /etc/freeradius/mods-config/preprocess/huntgroups reading pairlist file /etc/freeradius/mods-config/preprocess/hints # Loaded module rlm_unix # Instantiating module "unix" from file /etc/freeradius/mods-enabled/unix unix { radwtmp = "/var/log/freeradius/radwtmp" } # Loaded module rlm_soh # Instantiating module "soh" from file /etc/freeradius/mods-enabled/soh soh { dhcp = yes } # Loaded module rlm_digest # Instantiating module "digest" from file /etc/freeradius/mods-enabled/digest # Instantiating module "echo" from file /etc/freeradius/mods-enabled/echo exec echo { wait = yes program = "/bin/echo %{User-Name}" input_pairs = "request" output_pairs = "reply" shell_escape = yes } # Loaded module rlm_logintime # Instantiating module "logintime" from file /etc/freeradius/mods-enabled/logintime logintime { minimum_timeout = 60 } } # modules radiusd: #### Loading Virtual Servers #### server { # from file /etc/freeradius/radiusd.conf } # server server check-eap-tls { # from file /etc/freeradius/sites-enabled/check-eap-tls # Loading authorize {...} } # server check-eap-tls server atm-auth { # from file /etc/freeradius/sites-enabled/port-2812-wifi-atm # Creating Auth-Type = eap-atm # Loading authenticate {...} # Loading authorize {...} # Loading virtual module rewrite_called_station_id # Loading virtual module filter_username # Loading preacct {...} # Loading virtual module acct_unique # Loading accounting {...} # Loading session {...} # Loading post-proxy {...} # Loading post-auth {...} # Loading virtual module remove_reply_message_if_eap # Loading virtual module remove_reply_message_if_eap } # server atm-auth server pro-auth { # from file /etc/freeradius/sites-enabled/port-3812-wifi-pro # Creating Auth-Type = eap-pro # Loading authenticate {...} # Loading authorize {...} # Loading virtual module rewrite_called_station_id # Loading virtual module filter_username # Loading preacct {...} # Loading virtual module acct_unique # Loading accounting {...} # Loading session {...} # Loading post-proxy {...} # Loading post-auth {...} # Loading virtual module remove_reply_message_if_eap # Loading virtual module remove_reply_message_if_eap } # server pro-auth server macauth { # from file /etc/freeradius/sites-enabled/port-1812-mac-auth # Loading authenticate {...} # Loading authorize {...} # Loading virtual module filter_username # Loading virtual module rewrite_calling_station_id # Loading preacct {...} # Loading virtual module acct_unique # Loading accounting {...} # Loading session {...} # Loading post-proxy {...} # Loading post-auth {...} # Loading virtual module remove_reply_message_if_eap # Loading virtual module remove_reply_message_if_eap } # server macauth server inner-tunnel { # from file /etc/freeradius/sites-enabled/inner-tunnel # Loading authenticate {...} # Loading authorize {...} # Loading session {...} # Loading post-proxy {...} # Loading post-auth {...} } # server inner-tunnel radiusd: #### Opening IP addresses and Ports #### listen { type = "control" listen { socket = "/var/run/freeradius/freeradius.sock" uid = "freerad" gid = "freerad" mode = "rw" } } listen { type = "auth" ipaddr = * port = 2812 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "auth" ipaddr = * port = 3812 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "auth" ipaddr = * port = 0 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "acct" ipaddr = * port = 0 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "auth" ipaddr = 127.0.0.1 port = 18120 } Listening on command file /var/run/freeradius/freeradius.sock Listening on auth address * port 2812 as server atm-auth Listening on auth address * port 3812 as server pro-auth Listening on auth address * port 1812 as server macauth Listening on acct address * port 1813 as server macauth Listening on auth address 127.0.0.1 port 18120 as server inner-tunnel Opening new proxy address * port 1814 Listening on proxy address * port 1814 Ready to process requests. rad_recv: Access-Request packet from host 172.27.10.221 port 49154, id=0, length=108 NAS-IP-Address = 172.27.10.221 NAS-Port-Type = Ethernet NAS-Port = 10 User-Name = 'eca86bf20216' Calling-Station-Id = 'EC-A8-6B-F2-02-16' EAP-Message = 0x0200001101656361383662663230323136 Message-Authenticator = 0x554c3337d78accbb981b7babc75bc646 (0) # Executing section authorize from file /etc/freeradius/sites-enabled/port-1812-mac-auth (0) authorize { (0) filter_username filter_username { (0) ? if (User-Name =~ / /) (0) ? if (User-Name =~ / /) -> FALSE (0) ? if (User-Name =~ /@.*@/ ) (0) ? if (User-Name =~ /@.*@/ ) -> FALSE (0) ? if (User-Name =~ /\\.\\./ ) (0) ? if (User-Name =~ /\\.\\./ ) -> FALSE (0) ? if (User-Name =~ /\\.$/) (0) ? if (User-Name =~ /\\.$/) -> FALSE (0) ? if (User-Name =~ /@\\./) (0) ? if (User-Name =~ /@\\./) -> FALSE (0) } # filter_username filter_username = notfound (0) update request { (0) expand: "%{User-Name}" -> 'eca86bf20216' (0) SQL-User-Name set to 'eca86bf20216' rlm_sql (sql): Reserved connection (4) rlm_sql (sql): Executing query: 'select groupname from radhuntgroup where nasipaddress="172.27.10.221"' (0) sql_xlat finished rlm_sql (sql): Released connection (4) rlm_sql (sql): Closing connection (0): Too many free connections (5 > 3) rlm_sql_mysql: Socket destructor called, closing socket (0) expand: "%{sql:select groupname from radhuntgroup where nasipaddress="%{NAS-IP-Address}"}" -> 'LAN-Miletrie' (0) Huntgroup-Name := "LAN-Miletrie" (0) } # update request = noop (0) IPASS : No '/' in User-Name = "eca86bf20216", looking up realm NULL (0) IPASS : No such realm "NULL" (0) [IPASS] = noop (0) ntdomain : No '\' in User-Name = "eca86bf20216", looking up realm NULL (0) ntdomain : No such realm "NULL" (0) [ntdomain] = noop (0) eap-pro : EAP packet type response id 0 length 17 (0) eap-pro : EAP-Identity reply, returning 'ok' so we can short-circuit the rest of authorize (0) [eap-pro] = ok (0) } # authorize = ok (0) Found Auth-Type = eap-pro (0) # Executing group from file /etc/freeradius/sites-enabled/port-1812-mac-auth (0) authenticate { (0) eap-pro : Peer sent Identity (1) (0) eap-pro : Calling eap_md5 to process EAP data rlm_eap_md5: Issuing Challenge (0) eap-pro : New EAP session, adding 'State' attribute to reply 0x8edfa6f08edea2b3 (0) [eap-pro] = handled (0) } # authenticate = handled Sending Access-Challenge of id 0 from 172.27.10.128 port 1812 to 172.27.10.221 port 49154 EAP-Message = 0x010100160410292ff7b21af99d36d58790f5a9d6e29d Message-Authenticator = 0x00000000000000000000000000000000 State = 0x8edfa6f08edea2b38335e27f4c8f4511 (0) Finished request 0. Waking up in 0.3 seconds. rad_recv: Access-Request packet from host 172.27.10.221 port 49154, id=0, length=143 (0) Cleaning up request packet ID 0 with timestamp +21 NAS-IP-Address = 172.27.10.221 NAS-Port-Type = Ethernet NAS-Port = 10 User-Name = 'eca86bf20216' State = 0x8edfa6f08edea2b38335e27f4c8f4511 Calling-Station-Id = 'EC-A8-6B-F2-02-16' EAP-Message = 0x0201002204108a423da3f312e593558e66829a8060cb656361383662663230323136 Message-Authenticator = 0xee17fc738286a439da7bff87dd5c23ad (1) # Executing section authorize from file /etc/freeradius/sites-enabled/port-1812-mac-auth (1) authorize { (1) filter_username filter_username { (1) ? if (User-Name =~ / /) (1) ? if (User-Name =~ / /) -> FALSE (1) ? if (User-Name =~ /@.*@/ ) (1) ? if (User-Name =~ /@.*@/ ) -> FALSE (1) ? if (User-Name =~ /\\.\\./ ) (1) ? if (User-Name =~ /\\.\\./ ) -> FALSE (1) ? if (User-Name =~ /\\.$/) (1) ? if (User-Name =~ /\\.$/) -> FALSE (1) ? if (User-Name =~ /@\\./) (1) ? if (User-Name =~ /@\\./) -> FALSE (1) } # filter_username filter_username = notfound (1) update request { (1) expand: "%{User-Name}" -> 'eca86bf20216' (1) SQL-User-Name set to 'eca86bf20216' rlm_sql (sql): Reserved connection (4) rlm_sql (sql): Executing query: 'select groupname from radhuntgroup where nasipaddress="172.27.10.221"' (1) sql_xlat finished rlm_sql (sql): Released connection (4) (1) expand: "%{sql:select groupname from radhuntgroup where nasipaddress="%{NAS-IP-Address}"}" -> 'LAN-Miletrie' (1) Huntgroup-Name := "LAN-Miletrie" (1) } # update request = noop (1) IPASS : No '/' in User-Name = "eca86bf20216", looking up realm NULL (1) IPASS : No such realm "NULL" (1) [IPASS] = noop (1) ntdomain : No '\' in User-Name = "eca86bf20216", looking up realm NULL (1) ntdomain : No such realm "NULL" (1) [ntdomain] = noop (1) eap-pro : EAP packet type response id 1 length 34 (1) eap-pro : No EAP Start, assuming it's an on-going EAP conversation (1) [eap-pro] = updated (1) ? if (Service-Type == Call-Check) (1) ? if (Service-Type == Call-Check) -> FALSE (1) sql : expand: "%{User-Name}" -> 'eca86bf20216' (1) sql : SQL-User-Name set to 'eca86bf20216' rlm_sql (sql): Reserved connection (4) (1) 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 = 'eca86bf20216' ORDER BY id' rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'eca86bf20216' ORDER BY id' (1) sql : User found in radcheck table (1) sql : Check items matched (1) 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 = 'eca86bf20216' ORDER BY id' rlm_sql (sql): Executing query: 'SELECT id, username, attribute, value, op FROM radreply WHERE username = 'eca86bf20216' ORDER BY id' (1) sql : expand: "SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority" -> 'SELECT groupname FROM radusergroup WHERE username = 'eca86bf20216' ORDER BY priority' rlm_sql (sql): Executing query: 'SELECT groupname FROM radusergroup WHERE username = 'eca86bf20216' ORDER BY priority' rlm_sql (sql): Released connection (4) (1) [sql] = ok (1) [expiration] = noop (1) [logintime] = noop (1) WARNING: pap : Auth-Type already set. Not setting to PAP (1) [pap] = noop (1) } # authorize = updated (1) Found Auth-Type = eap-pro (1) # Executing group from file /etc/freeradius/sites-enabled/port-1812-mac-auth (1) authenticate { (1) eap-pro : Expiring EAP session with state 0x8edfa6f08edea2b3 (1) eap-pro : Finished EAP session with state 0x8edfa6f08edea2b3 (1) eap-pro : Previous EAP request found for state 0x8edfa6f08edea2b3, released from the list (1) eap-pro : Peer sent MD5 (4) (1) eap-pro : EAP MD5 (4) (1) eap-pro : Calling eap_md5 to process EAP data (1) eap-pro : Freeing handler (1) [eap-pro] = ok (1) } # authenticate = ok (1) # Executing section post-auth from file /etc/freeradius/sites-enabled/port-1812-mac-auth (1) post-auth { (1) sql : expand: ".query" -> '.query' (1) sql : Using query template 'query' rlm_sql (sql): Reserved connection (4) (1) sql : expand: "%{User-Name}" -> 'eca86bf20216' (1) sql : SQL-User-Name set to 'eca86bf20216' (1) sql : expand: "INSERT INTO radpostauth (username, reply, authdate, callingstationid, nasipaddress, nasportid, nasporttype, ssid) VALUES ( '%{User-Name}', '%{reply:Packet-Type}', '%S', '%{Calling-Station-Id}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%{Called-Station-SSID}' )" -> 'INSERT INTO radpostauth (username, reply, authdate, callingstationid, nasipaddress, nasportid, nasporttype, ssid) VALUES ( 'eca86bf20216', 'Access-Accept', '2014-02-13 15:52:42', 'EC-A8-6B-F2-02-16', '172.27.10.221', '10', 'Ethernet', '' )' rlm_sql (sql): Executing query: 'INSERT INTO radpostauth (username, reply, authdate, callingstationid, nasipaddress, nasportid, nasporttype, ssid) VALUES ( 'eca86bf20216', 'Access-Accept', '2014-02-13 15:52:42', 'EC-A8-6B-F2-02-16', '172.27.10.221', '10', 'Ethernet', '' )' rlm_sql (sql): Released connection (4) (1) [sql] = ok (1) [exec] = noop (1) remove_reply_message_if_eap remove_reply_message_if_eap { (1) ? if (reply:EAP-Message && reply:Reply-Message) (1) ? if (reply:EAP-Message && reply:Reply-Message) -> FALSE (1) else else { (1) [noop] = noop (1) } # else else = noop (1) } # remove_reply_message_if_eap remove_reply_message_if_eap = noop (1) } # post-auth = ok Sending Access-Accept of id 0 from 172.27.10.128 port 1812 to 172.27.10.221 port 49154 EAP-Message = 0x03010004 Message-Authenticator = 0x00000000000000000000000000000000 User-Name = 'eca86bf20216' (1) Finished request 1. Waking up in 0.3 seconds. Waking up in 4.6 seconds. (1) Cleaning up request packet ID 0 with timestamp +21 Ready to process requests.