FreeRADIUS Version 3.0.21 Copyright (C) 1999-2019 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 /usr/share/freeradius/dictionary including dictionary file /usr/share/freeradius/dictionary.dhcp including dictionary file /usr/share/freeradius/dictionary.vqp including dictionary file /etc/raddb/dictionary 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/mods-enabled/ including configuration file /etc/raddb/mods-enabled/unix including configuration file /etc/raddb/mods-enabled/detail including configuration file /etc/raddb/mods-enabled/radutmp including configuration file /etc/raddb/mods-enabled/pap including configuration file /etc/raddb/mods-enabled/utf8 including configuration file /etc/raddb/mods-enabled/replicate including configuration file /etc/raddb/mods-enabled/date including configuration file /etc/raddb/mods-enabled/cache_eap including configuration file /etc/raddb/mods-enabled/exec including configuration file /etc/raddb/mods-enabled/files including configuration file /etc/raddb/mods-enabled/../config/files.conf including configuration file /etc/raddb/mods-enabled/detail.log including configuration file /etc/raddb/mods-enabled/dynamic_clients including configuration file /etc/raddb/mods-enabled/realm including configuration file /etc/raddb/mods-enabled/soh including configuration file /etc/raddb/mods-enabled/sradutmp including configuration file /etc/raddb/mods-enabled/ntlm_auth including configuration file /etc/raddb/mods-enabled/preprocess including configuration file /etc/raddb/mods-enabled/passwd including configuration file /etc/raddb/mods-enabled/logintime including configuration file /etc/raddb/mods-enabled/expr including configuration file /etc/raddb/mods-enabled/always including configuration file /etc/raddb/mods-enabled/linelog including configuration file /etc/raddb/mods-enabled/attr_filter including configuration file /etc/raddb/mods-enabled/sql including configuration file /etc/raddb/mods-enabled/../config/sql.conf including configuration file /etc/raddb/mods-enabled/../config/Accounting.conf including configuration file /etc/raddb/mods-enabled/../config/Accounting.conf including configuration file /etc/raddb/mods-enabled/expiration including configuration file /etc/raddb/mods-enabled/sqlippool including configuration file /etc/raddb/mods-enabled/../config/ippool.conf including configuration file /etc/raddb/mods-enabled/../config/../mods-config/sql/ippool/mysql/DSL.conf including configuration file /etc/raddb/mods-enabled/../config/../mods-config/sql/ippool/mysql/DSL.conf including configuration file /etc/raddb/mods-enabled/../config/../mods-config/sql/ippool/mysql/DSL.conf including configuration file /etc/raddb/mods-enabled/mschap including configuration file /etc/raddb/mods-enabled/digest including configuration file /etc/raddb/mods-enabled/echo including configuration file /etc/raddb/mods-enabled/unpack including configuration file /etc/raddb/mods-enabled/chap including files in directory /etc/raddb/policy.d/ including configuration file /etc/raddb/policy.d/eap including configuration file /etc/raddb/policy.d/debug including configuration file /etc/raddb/policy.d/accounting including configuration file /etc/raddb/policy.d/abfab-tr including configuration file /etc/raddb/policy.d/moonshot-targeted-ids including configuration file /etc/raddb/policy.d/filter including configuration file /etc/raddb/policy.d/cui including configuration file /etc/raddb/policy.d/operator-name including configuration file /etc/raddb/policy.d/dhcp including configuration file /etc/raddb/policy.d/rfc7542 including configuration file /etc/raddb/policy.d/canonicalization including configuration file /etc/raddb/policy.d/control including configuration file /etc/raddb/config/YYY_DSL.conf main { security { allow_core_dumps = no } name = "radiusd" prefix = "/" localstatedir = "//var" logdir = "//var/log/" run_dir = "//var/run/radiusd" } main { name = "radiusd" prefix = "/" localstatedir = "//var" sbindir = "//sbin" logdir = "//var/log/" run_dir = "//var/run/radiusd" libdir = "/usr/local/lib/" radacctdir = "//var/log//radacct" hostname_lookups = no max_request_time = 30 cleanup_delay = 5 max_requests = 16384 pidfile = "//var/run/radiusd/radiusd.pid" checkrad = "//sbin/checkrad" debug_level = 0 proxy_requests = yes log { stripped_names = no auth = yes auth_badpass = no auth_goodpass = no colourise = yes msg_denied = "You are already logged in - access denied" } resources { } security { max_attributes = 200 reject_delay = 1.000000 status_server = yes allow_vulnerable_openssl = "yes" } } radiusd: #### Loading Realms and Home Servers #### proxy server { retry_delay = 5 retry_count = 3 default_fallback = no dead_time = 120 wake_all_if_all_dead = no } home_server localhost { ipaddr = 127.0.0.1 port = 1812 type = "auth" secret = <<< secret >>> response_window = 20.000000 response_timeouts = 1 max_outstanding = 65536 zombie_period = 40 status_check = "status-server" ping_interval = 30 check_interval = 30 check_timeout = 4 num_answers_to_alive = 3 revive_interval = 120 limit { max_connections = 16 max_requests = 0 lifetime = 0 idle_timeout = 0 } coa { irt = 2 mrt = 16 mrc = 5 mrd = 30 } } home_server YYY { ipaddr = user port = 1649 type = "auth" secret = <<< secret >>> response_window = 20.000000 response_timeouts = 1 max_outstanding = 65536 zombie_period = 40 status_check = "status-server" ping_interval = 30 check_interval = 20 check_timeout = 4 num_answers_to_alive = 3 revive_interval = 300 limit { max_connections = 16 max_requests = 0 lifetime = 0 idle_timeout = 0 } coa { irt = 2 mrt = 16 mrc = 5 mrd = 30 } } home_server_pool my_auth_failover { type = fail-over home_server = localhost } realm example.com { auth_pool = my_auth_failover } realm LOCAL { } realm YYY { nostrip } home_server_pool YYY { home_server = YYY } radiusd: #### Loading Clients #### client 217.112.190.2 { ipaddr = 217.112.190.2 require_message_authenticator = no secret = <<< secret >>> shortname = "test" limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } } Debugger not attached # Creating Auth-Type = PAP # Creating Auth-Type = CHAP radiusd: #### Instantiating modules #### modules { # Loaded module rlm_unix # Loading module "unix" from file /etc/raddb/mods-enabled/unix unix { radwtmp = "//var/log//radwtmp" } Creating attribute Unix-Group # Loaded module rlm_detail # Loading module "detail" from file /etc/raddb/mods-enabled/detail detail { filename = "//var/log//radacct/%{Packet-Src-IP-Address}/detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loaded module rlm_radutmp # Loading module "radutmp" from file /etc/raddb/mods-enabled/radutmp radutmp { filename = "//var/log//radutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes permissions = 384 caller_id = yes } # Loaded module rlm_pap # Loading module "pap" from file /etc/raddb/mods-enabled/pap pap { normalise = yes } # Loaded module rlm_utf8 # Loading module "utf8" from file /etc/raddb/mods-enabled/utf8 # Loaded module rlm_replicate # Loading module "replicate" from file /etc/raddb/mods-enabled/replicate # Loaded module rlm_date # Loading module "date" from file /etc/raddb/mods-enabled/date date { format = "%b %e %Y %H:%M:%S %Z" utc = no } # Loading module "wispr2date" from file /etc/raddb/mods-enabled/date date wispr2date { format = "%Y-%m-%dT%H:%M:%S" utc = no } # Loaded module rlm_cache # Loading module "cache_eap" from file /etc/raddb/mods-enabled/cache_eap cache cache_eap { driver = "rlm_cache_rbtree" key = "%{%{control:State}:-%{%{reply:State}:-%{State}}}" ttl = 15 max_entries = 0 epoch = 0 add_stats = no } # Loaded module rlm_exec # Loading module "exec" from file /etc/raddb/mods-enabled/exec exec { wait = no input_pairs = "request" shell_escape = yes timeout = 10 } # Loaded module rlm_files # Loading module "auth_dsl" from file /etc/raddb/mods-enabled/../config/files.conf files auth_dsl { filename = "/etc/raddb/mods-config/files/authorize" usersfile = "//etc/raddb/DSL_UsersRadius" acctusersfile = "/etc/raddb/mods-config/files/accounting" preproxy_usersfile = "/etc/raddb/mods-config/files/pre-proxy" } # Loading module "auth_log" from file /etc/raddb/mods-enabled/detail.log detail auth_log { filename = "//var/log//radacct/%{Packet-Src-IP-Address}/auth-detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loading module "reply_log" from file /etc/raddb/mods-enabled/detail.log detail reply_log { filename = "//var/log//radacct/%{Packet-Src-IP-Address}/reply-detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loading module "pre_proxy_log" from file /etc/raddb/mods-enabled/detail.log detail pre_proxy_log { filename = "//var/log//radacct/%{Packet-Src-IP-Address}/pre-proxy-detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loading module "post_proxy_log" from file /etc/raddb/mods-enabled/detail.log detail post_proxy_log { filename = "//var/log//radacct/%{Packet-Src-IP-Address}/post-proxy-detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no } # Loaded module rlm_dynamic_clients # Loading module "dynamic_clients" from file /etc/raddb/mods-enabled/dynamic_clients # Loaded module rlm_realm # Loading module "IPASS" from file /etc/raddb/mods-enabled/realm realm IPASS { format = "prefix" delimiter = "/" ignore_default = no ignore_null = no } # Loading module "suffix" from file /etc/raddb/mods-enabled/realm realm suffix { format = "suffix" delimiter = "@" ignore_default = no ignore_null = no } # Loading module "bangpath" from file /etc/raddb/mods-enabled/realm realm bangpath { format = "prefix" delimiter = "!" ignore_default = no ignore_null = no } # Loading module "realmpercent" from file /etc/raddb/mods-enabled/realm realm realmpercent { format = "suffix" delimiter = "%" ignore_default = no ignore_null = no } # Loading module "ntdomain" from file /etc/raddb/mods-enabled/realm realm ntdomain { format = "prefix" delimiter = "\\" ignore_default = no ignore_null = no } # Loaded module rlm_soh # Loading module "soh" from file /etc/raddb/mods-enabled/soh soh { dhcp = yes } # Loading module "sradutmp" from file /etc/raddb/mods-enabled/sradutmp radutmp sradutmp { filename = "//var/log//sradutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes permissions = 420 caller_id = no } # Loading module "ntlm_auth" from file /etc/raddb/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 } # Loaded module rlm_preprocess # Loading module "preprocess" from file /etc/raddb/mods-enabled/preprocess preprocess { huntgroups = "/etc/raddb/mods-config/preprocess/huntgroups" hints = "/etc/raddb/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 } # Loaded module rlm_passwd # Loading module "etc_passwd" from file /etc/raddb/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 } # Loaded module rlm_logintime # Loading module "logintime" from file /etc/raddb/mods-enabled/logintime logintime { minimum_timeout = 60 } # Loaded module rlm_expr # Loading module "expr" from file /etc/raddb/mods-enabled/expr expr { safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /äéöüàâæçèéêëîïôœùûüaÿÄÉÖÜßÀÂÆÇÈÉÊËÎÏÔŒÙÛÜŸ" } # Loaded module rlm_always # Loading module "reject" from file /etc/raddb/mods-enabled/always always reject { rcode = "reject" simulcount = 0 mpp = no } # Loading module "fail" from file /etc/raddb/mods-enabled/always always fail { rcode = "fail" simulcount = 0 mpp = no } # Loading module "ok" from file /etc/raddb/mods-enabled/always always ok { rcode = "ok" simulcount = 0 mpp = no } # Loading module "handled" from file /etc/raddb/mods-enabled/always always handled { rcode = "handled" simulcount = 0 mpp = no } # Loading module "invalid" from file /etc/raddb/mods-enabled/always always invalid { rcode = "invalid" simulcount = 0 mpp = no } # Loading module "userlock" from file /etc/raddb/mods-enabled/always always userlock { rcode = "userlock" simulcount = 0 mpp = no } # Loading module "notfound" from file /etc/raddb/mods-enabled/always always notfound { rcode = "notfound" simulcount = 0 mpp = no } # Loading module "noop" from file /etc/raddb/mods-enabled/always always noop { rcode = "noop" simulcount = 0 mpp = no } # Loading module "updated" from file /etc/raddb/mods-enabled/always always updated { rcode = "updated" simulcount = 0 mpp = no } # Loaded module rlm_linelog # Loading module "linelog" from file /etc/raddb/mods-enabled/linelog linelog { filename = "/var/log/radius.log" escape_filenames = no syslog_severity = "info" permissions = 384 format = "This is a log message for %{User-Name}" reference = "messages.%{%{reply:Packet-Type}:-default}" } # Loading module "log_ip_failure" from file /etc/raddb/mods-enabled/linelog linelog log_ip_failure { filename = "/var/log/radius.log" escape_filenames = no syslog_severity = "info" permissions = 384 reference = "messages.%{%{Packet-Type}:-default}" } # Loading module "log_accounting" from file /etc/raddb/mods-enabled/linelog linelog log_accounting { filename = "//var/log//linelog-accounting" escape_filenames = no syslog_severity = "info" permissions = 384 format = "" reference = "Accounting-Request.%{%{Acct-Status-Type}:-unknown}" } # Loaded module rlm_attr_filter # Loading module "attr_filter.post-proxy" from file /etc/raddb/mods-enabled/attr_filter attr_filter attr_filter.post-proxy { filename = "/etc/raddb/mods-config/attr_filter/post-proxy" key = "%{Realm}" relaxed = no } # Loading module "attr_filter.pre-proxy" from file /etc/raddb/mods-enabled/attr_filter attr_filter attr_filter.pre-proxy { filename = "/etc/raddb/mods-config/attr_filter/pre-proxy" key = "%{Realm}" relaxed = no } # Loading module "attr_filter.access_reject" from file /etc/raddb/mods-enabled/attr_filter attr_filter attr_filter.access_reject { filename = "/etc/raddb/mods-config/attr_filter/access_reject" key = "%{User-Name}" relaxed = no } # Loading module "attr_filter.access_challenge" from file /etc/raddb/mods-enabled/attr_filter attr_filter attr_filter.access_challenge { filename = "/etc/raddb/mods-config/attr_filter/access_challenge" key = "%{User-Name}" relaxed = no } # Loading module "attr_filter.accounting_response" from file /etc/raddb/mods-enabled/attr_filter attr_filter attr_filter.accounting_response { filename = "/etc/raddb/mods-config/attr_filter/accounting_response" key = "%{User-Name}" relaxed = no } # Loaded module rlm_sql # Loading module "Accounting_01" from file /etc/raddb/mods-enabled/../config/sql.conf sql Accounting_01 { driver = "rlm_sql_mysql" server = "xxxxxxxxxxx" port = 0 login = "user" password = <<< secret >>> radius_db = "radius" read_groups = yes read_profiles = yes read_clients = no delete_stale_sessions = yes sql_user_name = "%{User-Name}" default_user_profile = "" client_query = "SELECT id,nasname,shortname,type,secret FROM nas" safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" auto_escape = no accounting { reference = "%{tolower:type.%{%{Acct-Status-Type}:-%{Request-Processing-Stage}}.query}" type { accounting-on { query = "UPDATE radacct SET AcctStopTime='%S', AcctSessionTime=unix_timestamp('%S') - unix_timestamp(AcctStartTime), AcctTerminateCause='%{Acct-Terminate-Cause}', AcctStopDelay = '%{Acct-Delay-Time}' WHERE AcctSessionTime=0 AND AcctStopTime=0 AND NASIPAddress= '%{NAS-IP-Address}' AND AcctStartTime <= '%S'" } accounting-off { } start { query = "INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start,ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}','%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}','%{NAS-Port}','%{NAS-Port-Type}', FROM_UNIXTIME(%{integer:Event-Timestamp}), '0', '0', '%{Acct-Authentic}', '%{Connect-Info}','', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '','%{Service-Type}','%{Framed-Protocol}-2','%{Framed-IP-Address}','%{Acct-Delay-Time}', '0')" } interim-update { query = "UPDATE radacct SET FramedIPAddress = '%{Framed-IP-Address}', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets-64}',AcctOutputOctets = '%{Acct-Output-Octets-64}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress= '%{NAS-IP-Address}'" } stop { query = "UPDATE radacct SET AcctStopTime = '%S', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets-64}', AcctOutputOctets = '%{Acct-Output-Octets-64}', AcctTerminateCause = '%{Acct-Terminate-Cause}',AcctStopDelay = '%{Acct-Delay-Time}', ConnectInfo_stop = '%{Connect-Info}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}'" } } } post-auth { reference = ".query" } } rlm_sql (Accounting_01): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked # Loading module "Accounting_02" from file /etc/raddb/mods-enabled/../config/sql.conf sql Accounting_02 { driver = "rlm_sql_mysql" server = "xxxxxxxxxxxxxxxx" port = 0 login = "user" password = <<< secret >>> radius_db = "radius" read_groups = yes read_profiles = yes read_clients = no delete_stale_sessions = yes sql_user_name = "%{User-Name}" default_user_profile = "" client_query = "SELECT id,nasname,shortname,type,secret FROM nas" safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" auto_escape = no accounting { reference = "%{tolower:type.%{%{Acct-Status-Type}:-%{Request-Processing-Stage}}.query}" type { accounting-on { query = "UPDATE radacct SET AcctStopTime='%S', AcctSessionTime=unix_timestamp('%S') - unix_timestamp(AcctStartTime), AcctTerminateCause='%{Acct-Terminate-Cause}', AcctStopDelay = '%{Acct-Delay-Time}' WHERE AcctSessionTime=0 AND AcctStopTime=0 AND NASIPAddress= '%{NAS-IP-Address}' AND AcctStartTime <= '%S'" } accounting-off { } start { query = "INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start,ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}','%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}','%{NAS-Port}','%{NAS-Port-Type}', FROM_UNIXTIME(%{integer:Event-Timestamp}), '0', '0', '%{Acct-Authentic}', '%{Connect-Info}','', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '','%{Service-Type}','%{Framed-Protocol}-2','%{Framed-IP-Address}','%{Acct-Delay-Time}', '0')" } interim-update { query = "UPDATE radacct SET FramedIPAddress = '%{Framed-IP-Address}', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets-64}',AcctOutputOctets = '%{Acct-Output-Octets-64}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress= '%{NAS-IP-Address}'" } stop { query = "UPDATE radacct SET AcctStopTime = '%S', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets-64}', AcctOutputOctets = '%{Acct-Output-Octets-64}', AcctTerminateCause = '%{Acct-Terminate-Cause}',AcctStopDelay = '%{Acct-Delay-Time}', ConnectInfo_stop = '%{Connect-Info}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}'" } } } post-auth { reference = ".query" } } rlm_sql (Accounting_02): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked # Loading module "xxxxxxxxxxx" from file /etc/raddb/mods-enabled/../config/sql.conf sql xxxxxxxxxxx { driver = "rlm_sql_mysql" server = "xxxxxxxxxxxxxxxx" port = 0 login = "user" password = <<< secret >>> radius_db = "radius" read_groups = yes read_profiles = yes read_clients = no delete_stale_sessions = yes sql_user_name = "" default_user_profile = "" client_query = "SELECT id,nasname,shortname,type,secret FROM nas" safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" auto_escape = no accounting { reference = ".query" type { accounting-on { } accounting-off { } start { } interim-update { } stop { } } } post-auth { reference = ".query" } } rlm_sql (xxxxxxxxxxx): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked # Loading module "xxxxxxxxxxx" from file /etc/raddb/mods-enabled/../config/sql.conf sql xxxxxxxxxxx { driver = "rlm_sql_mysql" server = "xxxxxxxxxxx" port = 0 login = "user" password = <<< secret >>> radius_db = "radius" read_groups = yes read_profiles = yes read_clients = no delete_stale_sessions = yes sql_user_name = "" default_user_profile = "" client_query = "SELECT id,nasname,shortname,type,secret FROM nas" safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" auto_escape = no accounting { reference = ".query" type { accounting-on { } accounting-off { } start { } interim-update { } stop { } } } post-auth { reference = ".query" } } rlm_sql (xxxxxxxxxxx): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked # Loaded module rlm_expiration # Loading module "expiration" from file /etc/raddb/mods-enabled/expiration # Loaded module rlm_sqlippool # Loading module "IP-POOLING-01" from file /etc/raddb/mods-enabled/../config/ippool.conf sqlippool IP-POOLING-01 { sql_module_instance = "xxxxxxxxxxxxxxxxxx" lease_duration = 86400 pool_name = "Pool-Name" default_pool = "main_pool" attribute_name = "Framed-IP-Address" allocate_begin = "BEGIN" allocate_clear = "COMMIT" allocate_clear_timeout = 1 allocate_find = "SELECT ip_address FROM radippool WHERE (pool_name like '%{reply:Pool-Suffix}*%{Huntgroup-Name}%%%%') AND expiry_time < NOW() ORDER BY rand(), pool_name, expiry_time LIMIT 1 FOR UPDATE" allocate_update = "COMMIT" allocate_commit = "COMMIT" pool_check = "" start_begin = "BEGIN" start_update = "UPDATE radippool SET nas_ip_address = '%{NAS-IP-Address}', rb_path='%{Calling-Station-Id}', calling_station_id = '%{User-Name}', connected_time=NOW(), expiry_time = DATE_ADD(NOW(), INTERVAL %{Session-Timeout} SECOND) WHERE ip_address = '%{Framed-IP-Address}'" start_commit = "COMMIT" alive_begin = "BEGIN" alive_update = "UPDATE radippool SET nas_ip_address = '%{NAS-IP-Address}', connected_time=NOW(), expiry_time = DATE_ADD(NOW(), INTERVAL %{Session-Timeout} SECOND), nas_port = '%{NAS-Port}', rb_path='%{Calling-Station-Id}', calling_station_id = '%{User-Name}' WHERE ip_address = '%{Framed-IP-Address}' AND (calling_station_id != '%{User-Name}' OR expiry_time < NOW())" alive_commit = "COMMIT" stop_begin = "BEGIN" stop_clear = "UPDATE radippool SET nas_ip_address = '', nas_port = 0, calling_station_id = '', expiry_time = DATE_SUB(NOW(), INTERVAL 1 SECOND) WHERE ip_address = '%{Framed-IP-Address}'" stop_commit = "COMMIT" on_begin = "BEGIN" on_clear = "UPDATE radippool SET nas_ip_address = '', nas_port = 0, calling_station_id = '', expiry_time = DATE_SUB(NOW(), INTERVAL 1 SECOND) WHERE nas_ip_address = '%{NAS-IP-Address}'" on_commit = "COMMIT" off_begin = "BEGIN" off_clear = "UPDATE radippool SET nas_ip_address = '', nas_port = 0, calling_station_id = '', expiry_time = DATE_SUB(NOW(), INTERVAL 1 SECOND) WHERE nas_ip_address = '%{NAS-IP-Address}'" off_commit = "COMMIT" messages { exists = "Existing IP: %{reply:Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" success = "Allocated IP: %{reply:Framed-IP-Address} from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" clear = "Released IP %{Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name})" failed = "IP Allocation FAILED from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" nopool = "No Pool-Name defined (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" } } # Loading module "IP-POOLING-02" from file /etc/raddb/mods-enabled/../config/ippool.conf sqlippool IP-POOLING-02 { sql_module_instance = "xxxxxxxxxxxxxxxxxx" lease_duration = 86400 pool_name = "Pool-Name" default_pool = "main_pool" attribute_name = "Framed-IP-Address" allocate_begin = "BEGIN" allocate_clear = "COMMIT" allocate_clear_timeout = 1 allocate_find = "SELECT ip_address FROM radippool WHERE (pool_name like '%{reply:Pool-Suffix}*%{Huntgroup-Name}%%%%') AND expiry_time < NOW() ORDER BY rand(), pool_name, expiry_time LIMIT 1 FOR UPDATE" allocate_update = "COMMIT" allocate_commit = "COMMIT" pool_check = "" start_begin = "BEGIN" start_update = "UPDATE radippool SET nas_ip_address = '%{NAS-IP-Address}', rb_path='%{Calling-Station-Id}', calling_station_id = '%{User-Name}', connected_time=NOW(), expiry_time = DATE_ADD(NOW(), INTERVAL %{Session-Timeout} SECOND) WHERE ip_address = '%{Framed-IP-Address}'" start_commit = "COMMIT" alive_begin = "BEGIN" alive_update = "UPDATE radippool SET nas_ip_address = '%{NAS-IP-Address}', connected_time=NOW(), expiry_time = DATE_ADD(NOW(), INTERVAL %{Session-Timeout} SECOND), nas_port = '%{NAS-Port}', rb_path='%{Calling-Station-Id}', calling_station_id = '%{User-Name}' WHERE ip_address = '%{Framed-IP-Address}' AND (calling_station_id != '%{User-Name}' OR expiry_time < NOW())" alive_commit = "COMMIT" stop_begin = "BEGIN" stop_clear = "UPDATE radippool SET nas_ip_address = '', nas_port = 0, calling_station_id = '', expiry_time = DATE_SUB(NOW(), INTERVAL 1 SECOND) WHERE ip_address = '%{Framed-IP-Address}'" stop_commit = "COMMIT" on_begin = "BEGIN" on_clear = "UPDATE radippool SET nas_ip_address = '', nas_port = 0, calling_station_id = '', expiry_time = DATE_SUB(NOW(), INTERVAL 1 SECOND) WHERE nas_ip_address = '%{NAS-IP-Address}'" on_commit = "COMMIT" off_begin = "BEGIN" off_clear = "UPDATE radippool SET nas_ip_address = '', nas_port = 0, calling_station_id = '', expiry_time = DATE_SUB(NOW(), INTERVAL 1 SECOND) WHERE nas_ip_address = '%{NAS-IP-Address}'" off_commit = "COMMIT" messages { exists = "Existing IP: %{reply:Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" success = "Allocated IP: %{reply:Framed-IP-Address} from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" clear = "Released IP %{Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name})" failed = "IP Allocation FAILED from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" nopool = "No Pool-Name defined (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" } } # Loading module "Check_Pool" from file /etc/raddb/mods-enabled/../config/ippool.conf sqlippool Check_Pool { sql_module_instance = "xxxxxxxxxxxxxxxxxx" lease_duration = 86400 pool_name = "Pool-Name" default_pool = "main_pool" attribute_name = "Framed-IP-Address" allocate_begin = "BEGIN" allocate_clear = "COMMIT" allocate_clear_timeout = 1 allocate_find = "SELECT ip_address FROM radippool WHERE (pool_name like '%{reply:Pool-Suffix}*%{Huntgroup-Name}%%%%') AND expiry_time < NOW() ORDER BY rand(), pool_name, expiry_time LIMIT 1 FOR UPDATE" allocate_update = "COMMIT" allocate_commit = "COMMIT" pool_check = "" start_begin = "BEGIN" start_update = "UPDATE radippool SET nas_ip_address = '%{NAS-IP-Address}', rb_path='%{Calling-Station-Id}', calling_station_id = '%{User-Name}', connected_time=NOW(), expiry_time = DATE_ADD(NOW(), INTERVAL %{Session-Timeout} SECOND) WHERE ip_address = '%{Framed-IP-Address}'" start_commit = "COMMIT" alive_begin = "BEGIN" alive_update = "UPDATE radippool SET nas_ip_address = '%{NAS-IP-Address}', connected_time=NOW(), expiry_time = DATE_ADD(NOW(), INTERVAL %{Session-Timeout} SECOND), nas_port = '%{NAS-Port}', rb_path='%{Calling-Station-Id}', calling_station_id = '%{User-Name}' WHERE ip_address = '%{Framed-IP-Address}' AND (calling_station_id != '%{User-Name}' OR expiry_time < NOW())" alive_commit = "COMMIT" stop_begin = "BEGIN" stop_clear = "UPDATE radippool SET nas_ip_address = '', nas_port = 0, calling_station_id = '', expiry_time = DATE_SUB(NOW(), INTERVAL 1 SECOND) WHERE ip_address = '%{Framed-IP-Address}'" stop_commit = "COMMIT" on_begin = "BEGIN" on_clear = "UPDATE radippool SET nas_ip_address = '', nas_port = 0, calling_station_id = '', expiry_time = DATE_SUB(NOW(), INTERVAL 1 SECOND) WHERE nas_ip_address = '%{NAS-IP-Address}'" on_commit = "COMMIT" off_begin = "BEGIN" off_clear = "UPDATE radippool SET nas_ip_address = '', nas_port = 0, calling_station_id = '', expiry_time = DATE_SUB(NOW(), INTERVAL 1 SECOND) WHERE nas_ip_address = '%{NAS-IP-Address}'" off_commit = "COMMIT" messages { exists = "Existing IP: %{reply:Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" success = "Allocated IP: %{reply:Framed-IP-Address} from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" clear = "Released IP %{Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name})" failed = "IP Allocation FAILED from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" nopool = "No Pool-Name defined (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})" } } # Loaded module rlm_mschap # Loading module "mschap" from file /etc/raddb/mods-enabled/mschap mschap { use_mppe = yes require_encryption = no require_strong = no with_ntdomain_hack = yes passchange { } allow_retry = yes winbind_retry_with_normalised_username = no } # Loaded module rlm_digest # Loading module "digest" from file /etc/raddb/mods-enabled/digest # Loading module "echo" from file /etc/raddb/mods-enabled/echo exec echo { wait = yes program = "/bin/echo %{User-Name}" input_pairs = "request" output_pairs = "reply" shell_escape = yes } # Loaded module rlm_unpack # Loading module "unpack" from file /etc/raddb/mods-enabled/unpack # Loaded module rlm_chap # Loading module "chap" from file /etc/raddb/mods-enabled/chap instantiate { } # Instantiating module "detail" from file /etc/raddb/mods-enabled/detail # Instantiating module "pap" from file /etc/raddb/mods-enabled/pap # Instantiating module "cache_eap" from file /etc/raddb/mods-enabled/cache_eap rlm_cache (cache_eap): Driver rlm_cache_rbtree (module rlm_cache_rbtree) loaded and linked # Instantiating module "auth_dsl" from file /etc/raddb/mods-enabled/../config/files.conf reading pairlist file /etc/raddb/mods-config/files/authorize reading pairlist file //etc/raddb/DSL_UsersRadius reading pairlist file /etc/raddb/mods-config/files/accounting reading pairlist file /etc/raddb/mods-config/files/pre-proxy # Instantiating module "auth_log" from file /etc/raddb/mods-enabled/detail.log rlm_detail (auth_log): 'User-Password' suppressed, will not appear in detail output # Instantiating module "reply_log" from file /etc/raddb/mods-enabled/detail.log # Instantiating module "pre_proxy_log" from file /etc/raddb/mods-enabled/detail.log # Instantiating module "post_proxy_log" from file /etc/raddb/mods-enabled/detail.log # Instantiating module "IPASS" from file /etc/raddb/mods-enabled/realm # Instantiating module "suffix" from file /etc/raddb/mods-enabled/realm # Instantiating module "bangpath" from file /etc/raddb/mods-enabled/realm # Instantiating module "realmpercent" from file /etc/raddb/mods-enabled/realm # Instantiating module "ntdomain" from file /etc/raddb/mods-enabled/realm # Instantiating module "preprocess" from file /etc/raddb/mods-enabled/preprocess reading pairlist file /etc/raddb/mods-config/preprocess/huntgroups reading pairlist file /etc/raddb/mods-config/preprocess/hints # Instantiating module "etc_passwd" from file /etc/raddb/mods-enabled/passwd rlm_passwd: nfields: 3 keyfield 0(User-Name) listable: no # Instantiating module "logintime" from file /etc/raddb/mods-enabled/logintime # Instantiating module "reject" from file /etc/raddb/mods-enabled/always # Instantiating module "fail" from file /etc/raddb/mods-enabled/always # Instantiating module "ok" from file /etc/raddb/mods-enabled/always # Instantiating module "handled" from file /etc/raddb/mods-enabled/always # Instantiating module "invalid" from file /etc/raddb/mods-enabled/always # Instantiating module "userlock" from file /etc/raddb/mods-enabled/always # Instantiating module "notfound" from file /etc/raddb/mods-enabled/always # Instantiating module "noop" from file /etc/raddb/mods-enabled/always # Instantiating module "updated" from file /etc/raddb/mods-enabled/always # Instantiating module "linelog" from file /etc/raddb/mods-enabled/linelog # Instantiating module "log_ip_failure" from file /etc/raddb/mods-enabled/linelog # Instantiating module "log_accounting" from file /etc/raddb/mods-enabled/linelog # Instantiating module "attr_filter.post-proxy" from file /etc/raddb/mods-enabled/attr_filter reading pairlist file /etc/raddb/mods-config/attr_filter/post-proxy # Instantiating module "attr_filter.pre-proxy" from file /etc/raddb/mods-enabled/attr_filter reading pairlist file /etc/raddb/mods-config/attr_filter/pre-proxy # Instantiating module "attr_filter.access_reject" from file /etc/raddb/mods-enabled/attr_filter reading pairlist file /etc/raddb/mods-config/attr_filter/access_reject # Instantiating module "attr_filter.access_challenge" from file /etc/raddb/mods-enabled/attr_filter reading pairlist file /etc/raddb/mods-config/attr_filter/access_challenge # Instantiating module "attr_filter.accounting_response" from file /etc/raddb/mods-enabled/attr_filter reading pairlist file /etc/raddb/mods-config/attr_filter/accounting_response # Instantiating module "Accounting_01" from file /etc/raddb/mods-enabled/../config/sql.conf rlm_sql_mysql: libmysql version: 5.1.73 mysql { tls { } warnings = "auto" } rlm_sql (Accounting_01): Attempting to connect to database "radius" rlm_sql (Accounting_01): Initialising connection pool pool { start = 5 min = 2 max = 20 spare = 3 uses = 0 lifetime = 0 cleanup_interval = 30 idle_timeout = 60 retry_delay = 1 spread = no } rlm_sql (Accounting_01): Opening additional connection (0), 1 of 20 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on xxxxxxxxxxx via TCP/IP, server version 5.7.36-log, protocol version 10 rlm_sql (Accounting_01): Opening additional connection (1), 1 of 19 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on xxxxxxxxxxx via TCP/IP, server version 5.7.36-log, protocol version 10 rlm_sql (Accounting_01): Opening additional connection (2), 1 of 18 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on xxxxxxxxxxx via TCP/IP, server version 5.7.36-log, protocol version 10 rlm_sql (Accounting_01): Opening additional connection (3), 1 of 17 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on xxxxxxxxxxx via TCP/IP, server version 5.7.36-log, protocol version 10 rlm_sql (Accounting_01): Opening additional connection (4), 1 of 16 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on xxxxxxxxxxx via TCP/IP, server version 5.7.36-log, protocol version 10 # Instantiating module "Accounting_02" from file /etc/raddb/mods-enabled/../config/sql.conf mysql { tls { } warnings = "auto" } rlm_sql (Accounting_02): Attempting to connect to database "radius" rlm_sql (Accounting_02): Initialising connection pool pool { start = 5 min = 2 max = 20 spare = 3 uses = 0 lifetime = 0 cleanup_interval = 30 idle_timeout = 60 retry_delay = 1 spread = no } rlm_sql (Accounting_02): Opening additional connection (0), 1 of 20 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on xxxxxxxxxxx via TCP/IP, server version 5.7.36-log, protocol version 10 rlm_sql (Accounting_02): Opening additional connection (1), 1 of 19 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on xxxxxxxxxxx via TCP/IP, server version 5.7.36-log, protocol version 10 rlm_sql (Accounting_02): Opening additional connection (2), 1 of 18 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on xxxxxxxxxxx via TCP/IP, server version 5.7.36-log, protocol version 10 rlm_sql (Accounting_02): Opening additional connection (3), 1 of 17 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on xxxxxxxxxxx via TCP/IP, server version 5.7.36-log, protocol version 10 rlm_sql (Accounting_02): Opening additional connection (4), 1 of 16 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on xxxxxxxxxxx via TCP/IP, server version 5.7.36-log, protocol version 10 # Instantiating module "xxxxxxxxxxx" from file /etc/raddb/mods-enabled/../config/sql.conf mysql { tls { } warnings = "auto" } rlm_sql (xxxxxxxxxxx): Attempting to connect to database "radius" rlm_sql (xxxxxxxxxxx): Initialising connection pool pool { start = 5 min = 2 max = 20 spare = 3 uses = 0 lifetime = 0 cleanup_interval = 30 idle_timeout = 60 retry_delay = 1 spread = no } rlm_sql (xxxxxxxxxxx): Opening additional connection (0), 1 of 20 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on xxxxxxxxxxx via TCP/IP, server version 5.7.36-log, protocol version 10 rlm_sql (xxxxxxxxxxx): Opening additional connection (1), 1 of 19 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on xxxxxxxxxxx via TCP/IP, server version 5.7.36-log, protocol version 10 rlm_sql (xxxxxxxxxxx): Opening additional connection (2), 1 of 18 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on xxxxxxxxxxx via TCP/IP, server version 5.7.36-log, protocol version 10 rlm_sql (xxxxxxxxxxx): Opening additional connection (3), 1 of 17 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on xxxxxxxxxxx via TCP/IP, server version 5.7.36-log, protocol version 10 rlm_sql (xxxxxxxxxxx): Opening additional connection (4), 1 of 16 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on xxxxxxxxxxx via TCP/IP, server version 5.7.36-log, protocol version 10 # Instantiating module "xxxxxxxxxxx" from file /etc/raddb/mods-enabled/../config/sql.conf mysql { tls { } warnings = "auto" } rlm_sql (xxxxxxxxxxx): Attempting to connect to database "radius" rlm_sql (xxxxxxxxxxx): Initialising connection pool pool { start = 5 min = 2 max = 20 spare = 3 uses = 0 lifetime = 0 cleanup_interval = 30 idle_timeout = 60 retry_delay = 1 spread = no } rlm_sql (xxxxxxxxxxx): Opening additional connection (0), 1 of 20 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on xxxxxxxxxxx via TCP/IP, server version 5.7.36-log, protocol version 10 rlm_sql (xxxxxxxxxxx): Opening additional connection (1), 1 of 19 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on xxxxxxxxxxx via TCP/IP, server version 5.7.36-log, protocol version 10 rlm_sql (xxxxxxxxxxx): Opening additional connection (2), 1 of 18 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on xxxxxxxxxxx via TCP/IP, server version 5.7.36-log, protocol version 10 rlm_sql (xxxxxxxxxxx): Opening additional connection (3), 1 of 17 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on xxxxxxxxxxx via TCP/IP, server version 5.7.36-log, protocol version 10 rlm_sql (xxxxxxxxxxx): Opening additional connection (4), 1 of 16 pending slots used rlm_sql_mysql: Starting connect to MySQL server rlm_sql_mysql: Connected to database 'radius' on xxxxxxxxxxx via TCP/IP, server version 5.7.36-log, protocol version 10 # Instantiating module "expiration" from file /etc/raddb/mods-enabled/expiration # Instantiating module "IP-POOLING-01" from file /etc/raddb/mods-enabled/../config/ippool.conf Ignoring "allocate_clear_timeout = 1", forcing to "allocate_clear_timeout = 1" # Instantiating module "IP-POOLING-02" from file /etc/raddb/mods-enabled/../config/ippool.conf Ignoring "allocate_clear_timeout = 1", forcing to "allocate_clear_timeout = 1" # Instantiating module "Check_Pool" from file /etc/raddb/mods-enabled/../config/ippool.conf Ignoring "allocate_clear_timeout = 1", forcing to "allocate_clear_timeout = 1" # Instantiating module "mschap" from file /etc/raddb/mods-enabled/mschap rlm_mschap (mschap): using internal authentication } # modules radiusd: #### Loading Virtual Servers #### server { # from file /etc/raddb/radiusd.conf } # server server YYY_dsl { # from file /etc/raddb/config/YYY_DSL.conf # Loading authenticate {...} # Loading authorize {...} # Loading preacct {...} # Loading accounting {...} # Loading pre-proxy {...} # Loading post-proxy {...} # Loading post-auth {...} } # server YYY_dsl radiusd: #### Opening IP addresses and Ports #### listen { type = "auth" ipaddr = user port = 1649 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "acct" ipaddr = user port = 1650 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } Listening on auth address user port 1649 bound to server YYY_dsl Listening on acct address user port 1650 bound to server YYY_dsl Listening on proxy address * port 51079 Ready to process requests (0) Received Access-Request Id 113 from 217.112.190.2:1645 to user:1649 length 161 (0) Framed-Protocol = PPP (0) User-Name = "BCtest@YYY" (0) User-Password = "test" (0) NAS-Port-Type = Virtual (0) NAS-Port = 0 (0) NAS-Port-Id = "ether 0/0/1:4096.150 0/0/0/0/0/0" (0) Cisco-AVPair = "client-mac-address=7a32.a21d.c6ba" (0) Service-Type = Framed-User (0) NAS-IP-Address = 217.112.190.2 (0) # Executing section authorize from file /etc/raddb/config/YYY_DSL.conf (0) authorize { (0) [preprocess] = ok (0) [chap] = noop (0) [mschap] = noop (0) suffix: Checking for suffix after "@" (0) suffix: Looking up realm "YYY" for User-Name = "BCtest@YYY" (0) suffix: Found realm "YYY" (0) suffix: Adding Realm = "YYY" (0) suffix: Authentication realm is LOCAL (0) [suffix] = ok (0) auth_dsl: users: Matched entry DEFAULT at line 10 (0) auth_dsl: EXPAND ^([^@]+)@(.*) (0) auth_dsl: --> ^([^@]+)@(.*) (0) auth_dsl: users: Matched entry DEFAULT at line 14 (0) auth_dsl: users: Matched entry DEFAULT at line 84 (0) auth_dsl: users: Matched entry BCtest@YYY at line 91 (0) [auth_dsl] = ok (0) [expiration] = noop (0) [logintime] = noop (0) [pap] = updated (0) } # authorize = updated (0) Found Auth-Type = PAP (0) # Executing group from file /etc/raddb/config/YYY_DSL.conf (0) Auth-Type PAP { (0) pap: Login attempt with password (0) pap: Comparing with "known good" Cleartext-Password (0) pap: User authenticated successfully (0) [pap] = ok (0) } # Auth-Type PAP = ok (0) # Executing section post-auth from file /etc/raddb/config/YYY_DSL.conf (0) post-auth { (0) if (&proxy-reply:Proxy-State) { (0) WARNING: List "proxy-reply" is not available (0) if (&proxy-reply:Proxy-State) -> FALSE (0) else { (0) if (&Cisco-AVPair) { (0) if (&Cisco-AVPair) -> TRUE (0) if (&Cisco-AVPair) { (0) update reply { (0) EXPAND ip:vrf-id=%{2} (0) --> ip:vrf-id=YYY (0) Cisco-AVPair += ip:vrf-id=YYY (0) Cisco-AVPair += "ip:ip-unnumbered=Loopback22" (0) EXPAND accounting-list=%{2} (0) --> accounting-list=YYY (0) Cisco-AVPair += accounting-list=YYY (0) Cisco-Account-Info += "APPPOE" (0) } # update reply = noop (0) # if (&Cisco-AVPair) = noop (0) ... skipping elsif: Preceding "if" was taken (0) if (&reply:Subscription-Name=="NOSERVICE") { (0) if (&reply:Subscription-Name=="NOSERVICE") -> FALSE (0) update reply { (0) Service-Type := Framed-User (0) Framed-IP-Netmask := 255.255.255.255 (0) } # update reply = noop (0) if (reply:Framed-IP-Address) { (0) if (reply:Framed-IP-Address) -> FALSE (0) else { (0) redundant { rlm_sql (xxxxxxxxxxx): Reserved connection (0) (0) IP-POOLING-02: EXPAND BEGIN (0) IP-POOLING-02: --> BEGIN (0) IP-POOLING-02: Executing query: BEGIN (0) IP-POOLING-02: EXPAND COMMIT (0) IP-POOLING-02: --> COMMIT (0) IP-POOLING-02: Executing query: COMMIT (0) IP-POOLING-02: EXPAND COMMIT (0) IP-POOLING-02: --> COMMIT (0) IP-POOLING-02: Executing query: COMMIT (0) IP-POOLING-02: EXPAND BEGIN (0) IP-POOLING-02: --> BEGIN (0) IP-POOLING-02: Executing query: BEGIN (0) IP-POOLING-02: EXPAND SELECT ip_address FROM radippool WHERE (pool_name like '%{reply:Pool-Suffix}*%{Huntgroup-Name}%%%%') AND expiry_time < NOW() ORDER BY rand(), pool_name, expiry_time LIMIT 1 FOR UPDATE (0) IP-POOLING-02: --> SELECT ip_address FROM radippool WHERE (pool_name like '*RB1%%') AND expiry_time < NOW() ORDER BY rand(), pool_name, expiry_time LIMIT 1 FOR UPDATE (0) IP-POOLING-02: Executing select query: SELECT ip_address FROM radippool WHERE (pool_name like '*RB1%%') AND expiry_time < NOW() ORDER BY rand(), pool_name, expiry_time LIMIT 1 FOR UPDATE (0) IP-POOLING-02: ERROR: SQL query did not return any results (0) IP-POOLING-02: EXPAND COMMIT (0) IP-POOLING-02: --> COMMIT (0) IP-POOLING-02: Executing query: COMMIT rlm_sql (xxxxxxxxxxx): Released connection (0) (0) IP-POOLING-02: IP address could not be allocated (0) IP-POOLING-02: EXPAND IP Allocation FAILED from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name}) (0) IP-POOLING-02: --> IP Allocation FAILED from ip_pooling (did cli port 0 user BCtest@YYY) (0) [IP-POOLING-02] = noop (0) } # redundant = noop (0) if (!ok) { (0) if (!ok) -> TRUE (0) if (!ok) { (0) log_ip_failure: EXPAND messages.%{%{Packet-Type}:-default} (0) log_ip_failure: --> messages.Access-Request (0) log_ip_failure: EXPAND %t : IP-Pooling Failure to get an ip address for %{User-Name} -> Reply to Redback sent to handle that issue. (0) log_ip_failure: --> Thu Dec 9 17:13:28 2021 : IP-Pooling Failure to get an ip address for BCtest@YYY -> Reply to Redback sent to handle that issue. (0) log_ip_failure: EXPAND /var/log/radius.log (0) log_ip_failure: --> /var/log/radius.log File /var/log/radius.log permissions are 0640 (rw-r-----) not 0600 (rw-------)) (0) [log_ip_failure] = ok (0) } # if (!ok) = ok (0) update reply { (0) Session-Timeout = 172800 (0) } # update reply = noop (0) } # else = ok (0) } # else = ok (0) } # post-auth = ok (0) Login OK: [BCtest@YYY] (from client test port 0) (0) Sent Access-Accept Id 113 from user:1649 to 217.112.190.2:1645 length 0 (0) Service-Type := Framed-User (0) Cisco-AVPair += "ip:vrf-id=YYY" (0) Cisco-AVPair += "ip:ip-unnumbered=Loopback22" (0) Cisco-AVPair += "accounting-list=YYY" (0) Cisco-Account-Info += "APPPOE" (0) Framed-IP-Netmask := 255.255.255.255 (0) Session-Timeout = 172800 (0) Finished request Waking up in 4.9 seconds.