root@ubuntu-2004-server:/home/ubuntuserver# freeradius -X FreeRADIUS Version 3.0.22 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/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/files including configuration file /etc/freeradius/mods-enabled/expiration including configuration file /etc/freeradius/mods-enabled/passwd including configuration file /etc/freeradius/mods-enabled/attr_filter including configuration file /etc/freeradius/mods-enabled/unpack including configuration file /etc/freeradius/mods-enabled/detail.log including configuration file /etc/freeradius/mods-enabled/exec including configuration file /etc/freeradius/mods-enabled/utf8 including configuration file /etc/freeradius/mods-enabled/logintime including configuration file /etc/freeradius/mods-enabled/mschap including configuration file /etc/freeradius/mods-enabled/realm including configuration file /etc/freeradius/mods-enabled/preprocess including configuration file /etc/freeradius/mods-enabled/soh including configuration file /etc/freeradius/mods-enabled/expr including configuration file /etc/freeradius/mods-enabled/WISPSQL including configuration file /etc/freeradius/mods-config/sql/main/mssql/queries.conf including configuration file /etc/freeradius/mods-enabled/unix including configuration file /etc/freeradius/mods-enabled/sradutmp including configuration file /etc/freeradius/mods-enabled/sql including configuration file /etc/freeradius/mods-config/sql/main/mssql/queries.conf including configuration file /etc/freeradius/mods-enabled/cache_eap including configuration file /etc/freeradius/mods-enabled/replicate including configuration file /etc/freeradius/mods-enabled/detail including configuration file /etc/freeradius/mods-enabled/linelog including configuration file /etc/freeradius/mods-enabled/chap including configuration file /etc/freeradius/mods-enabled/HotspotSQL including configuration file /etc/freeradius/mods-config/sql/main/mssql/queries.conf including configuration file /etc/freeradius/mods-enabled/digest including configuration file /etc/freeradius/mods-enabled/radutmp including configuration file /etc/freeradius/mods-enabled/date including configuration file /etc/freeradius/mods-enabled/eap including configuration file /etc/freeradius/mods-enabled/dynamic_clients including configuration file /etc/freeradius/mods-enabled/echo including configuration file /etc/freeradius/mods-enabled/pap including configuration file /etc/freeradius/mods-enabled/ntlm_auth including configuration file /etc/freeradius/mods-enabled/always including files in directory /etc/freeradius/policy.d/ including configuration file /etc/freeradius/policy.d/cui including configuration file /etc/freeradius/policy.d/operator-name including configuration file /etc/freeradius/policy.d/dhcp including configuration file /etc/freeradius/policy.d/debug including configuration file /etc/freeradius/policy.d/filter including configuration file /etc/freeradius/policy.d/eap including configuration file /etc/freeradius/policy.d/abfab-tr including configuration file /etc/freeradius/policy.d/moonshot-targeted-ids including configuration file /etc/freeradius/policy.d/accounting including configuration file /etc/freeradius/policy.d/control including configuration file /etc/freeradius/policy.d/canonicalization including configuration file /etc/freeradius/policy.d/rfc7542 including files in directory /etc/freeradius/sites-enabled/ including configuration file /etc/freeradius/sites-enabled/default including configuration file /etc/freeradius/sites-enabled/originate-coa including configuration file /etc/freeradius/sites-enabled/HotspotServer including configuration file /etc/freeradius/sites-enabled/inner-tunnel including configuration file /etc/freeradius/sites-enabled/WISPServer main { security { user = "freerad" group = "freerad" allow_core_dumps = no } name = "freeradius" prefix = "/usr" localstatedir = "/var" logdir = "/var/log/freeradius" run_dir = "/var/run/freeradius" } 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 = 16384 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 msg_denied = "You are already logged in - access denied" } resources { } security { max_attributes = 200 reject_delay = 1.000000 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 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 example-coa { ipaddr = 192.0.2.42 port = 3799 type = "coa" secret = <<< secret >>> response_window = 30.000000 response_timeouts = 1 max_outstanding = 65536 zombie_period = 40 status_check = "none" ping_interval = 30 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 home-coa { ipaddr = 192.168.1.200 port = 3799 type = "coa" secret = <<< secret >>> response_window = 30.000000 response_timeouts = 1 max_outstanding = 65536 zombie_period = 40 status_check = "none" ping_interval = 30 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 { } home_server_pool coa { type = fail-over virtual_server = originate-coa.example.com home_server = home-coa } radiusd: #### Loading Clients #### client localhost { ipaddr = 127.0.0.1 require_message_authenticator = no secret = <<< secret >>> nas_type = "other" proto = "*" limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } client localhost_ipv6 { ipv6addr = ::1 require_message_authenticator = no secret = <<< secret >>> limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } Debugger not attached systemd watchdog is disabled # Creating Auth-Type = mschap # Creating Auth-Type = digest # Creating Auth-Type = eap # Creating Auth-Type = PAP # Creating Auth-Type = CHAP # Creating Auth-Type = MS-CHAP radiusd: #### Instantiating modules #### modules { # Loaded module rlm_files # Loading module "files" from file /etc/freeradius/mods-enabled/files files { filename = "/etc/freeradius/mods-config/files/authorize" acctusersfile = "/etc/freeradius/mods-config/files/accounting" preproxy_usersfile = "/etc/freeradius/mods-config/files/pre-proxy" } # Loaded module rlm_expiration # Loading module "expiration" from file /etc/freeradius/mods-enabled/expiration # Loaded module rlm_passwd # Loading 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 } # Loaded module rlm_attr_filter # Loading 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 } # Loading 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 } # Loading 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 } # Loading 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 } # Loading 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 } # Loaded module rlm_unpack # Loading module "unpack" from file /etc/freeradius/mods-enabled/unpack # Loaded module rlm_detail # Loading 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 locking = no escape_filenames = no log_packet_header = no } # Loading 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 locking = no escape_filenames = no log_packet_header = no } # Loading 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 locking = no escape_filenames = no log_packet_header = no } # Loading 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 locking = no escape_filenames = no log_packet_header = no } # Loaded module rlm_exec # Loading module "exec" from file /etc/freeradius/mods-enabled/exec exec { wait = no input_pairs = "request" shell_escape = yes timeout = 10 } # Loaded module rlm_utf8 # Loading module "utf8" from file /etc/freeradius/mods-enabled/utf8 # Loaded module rlm_logintime # Loading module "logintime" from file /etc/freeradius/mods-enabled/logintime logintime { minimum_timeout = 60 } # Loaded module rlm_mschap # Loading 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 winbind_retry_with_normalised_username = no } # Loaded module rlm_realm # Loading module "IPASS" from file /etc/freeradius/mods-enabled/realm realm IPASS { format = "prefix" delimiter = "/" ignore_default = no ignore_null = no } # Loading module "suffix" from file /etc/freeradius/mods-enabled/realm realm suffix { format = "suffix" delimiter = "@" ignore_default = no ignore_null = no } # Loading module "bangpath" from file /etc/freeradius/mods-enabled/realm realm bangpath { format = "prefix" delimiter = "!" ignore_default = no ignore_null = no } # Loading module "realmpercent" from file /etc/freeradius/mods-enabled/realm realm realmpercent { format = "suffix" delimiter = "%" ignore_default = no ignore_null = no } # Loading module "ntdomain" from file /etc/freeradius/mods-enabled/realm realm ntdomain { format = "prefix" delimiter = "\\" ignore_default = no ignore_null = no } # Loaded module rlm_preprocess # Loading 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 } # Loaded module rlm_soh # Loading module "soh" from file /etc/freeradius/mods-enabled/soh soh { dhcp = yes } # Loaded module rlm_expr # Loading module "expr" from file /etc/freeradius/mods-enabled/expr expr { safe_characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /äéöüàâæçèéêëîïôœùûüaÿÄÉÖÜßÀÂÆÇÈÉÊËÎÏÔŒÙÛÜŸ" } # Loaded module rlm_sql # Loading module "WISPSQL" from file /etc/freeradius/mods-enabled/WISPSQL sql WISPSQL { driver = "rlm_sql_freetds" server = "SQLServer" port = 1433 login = "sa" password = <<< secret >>> radius_db = "WISP" read_groups = yes read_profiles = yes read_clients = yes delete_stale_sessions = yes sql_user_name = "%{User-Name}" default_user_profile = "" client_query = "SELECT Id, IPAddress, ShortName, 'other', Secret, ISNULL(Server, '') FROM nas WHERE IsActive = 1" authorize_check_query = "SELECT Id, UserName, Attribute, Value, Operation FROM radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY Id" authorize_reply_query = "SELECT Id, UserName, Attribute, Value, Operation FROM radreply WHERE UserName = '%{SQL-User-Name}' AND ( Attribute != 'Framed-IP-Address' OR ( Attribute = 'Framed-IP-Address' AND NOT EXISTS(SELECT * FROM radcheck INNER JOIN radgroupreply ON radcheck.GroupName = radgroupreply.GroupName WHERE radcheck.LineId = radreply.LineId AND radgroupreply.Attribute = 'Framed-Pool') ) ) ORDER BY Id" authorize_group_check_query = "SELECT radgroupcheck.Id,radgroupcheck.GroupName, radgroupcheck.Attribute,radgroupcheck.Value, radgroupcheck.Operation FROM radgroupcheck,radcheck WHERE radcheck.Username = '%{SQL-User-Name}' AND radcheck.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.Id" authorize_group_reply_query = "SELECT radgroupreply.Id, radgroupreply.GroupName, radgroupreply.Attribute,radgroupreply.Value, radgroupreply.Operation FROM radgroupreply,radcheck WHERE radcheck.Username = '%{SQL-User-Name}' AND radcheck.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.Id" group_membership_query = "SELECT GroupName FROM radcheck WHERE UserName = '%{SQL-User-Name}' AND Attribute = 'Cleartext-Password'" 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 = GETDATE(), AcctSessionTime = DATEDIFF(second, AcctStartTime, GETDATE()), AcctTerminateCause='%{%{Acct-Terminate-Cause}:-NAS-Reboot}', AcctStopDelay = %{Acct-Delay-Time} WHERE AcctStopTime IS NULL AND NASIPAddress = '%{%{Packet-Src-IP-Address}:-%{NAS-IP-Address}}' AND AcctStartTime <= GETDATE()" } accounting-off { query = "UPDATE radacct SET AcctStopTime = GETDATE(), AcctSessionTime = DATEDIFF(second, AcctStartTime, GETDATE()), AcctTerminateCause='%{%{Acct-Terminate-Cause}:-NAS-Reboot}', AcctStopDelay = %{Acct-Delay-Time} WHERE AcctStopTime IS NULL AND NASIPAddress = '%{%{Packet-Src-IP-Address}:-%{NAS-IP-Address}}' AND AcctStartTime <= GETDATE()" } start { query = "INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctUpdateTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfoStart, ConnectInfoStop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress) VALUES('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{%{Packet-Src-IP-Address}:-%{NAS-IP-Address}}', '%{%{NAS-Port-Id}:-%{NAS-Port}}', '%{NAS-Port-Type}', GETDATE(), GETDATE(), NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', NULL, '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', NULL, '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}')" } interim-update { query = "UPDATE radacct SET AcctInterval = DATEDIFF(second, AcctUpdateTime, GETDATE()), AcctUpdateTime = GETDATE(), AcctStopTime = NULL, AcctSessionTime = %{%{Acct-Session-Time}:-NULL}, FramedIPAddress = '%{Framed-IP-Address}', AcctInputOctets = convert(bigint, '%{%{Acct-Input-Gigawords}:-0}' * POWER(2.0, 32)) | '%{%{Acct-Input-Octets}:-0}', AcctOutputOctets = convert(bigint, '%{%{Acct-Output-Gigawords}:-0}' * POWER(2.0, 32)) | '%{%{Acct-Output-Octets}:-0}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}'" } stop { query = "UPDATE radacct SET AcctStopTime = GETDATE(), AcctSessionTime = %{%{Acct-Session-Time}:-NULL}, AcctInputOctets = convert(bigint, '%{%{Acct-Input-Gigawords}:-0}' * POWER(2.0, 32)) | '%{%{Acct-Input-Octets}:-0}', AcctOutputOctets = convert(bigint, '%{%{Acct-Output-Gigawords}:-0}' * POWER(2.0, 32)) | '%{%{Acct-Output-Octets}:-0}', AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay = %{Acct-Delay-Time}, ConnectInfoStop = '%{Connect-Info}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}'" } } } post-auth { reference = ".query" query = "INSERT INTO radpostauth (UserName, Password, Reply, AuthDate, NASIPAddress, CallingStationId) VALUES ( '%{SQL-User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', GETDATE(), '%{%{Packet-Src-IP-Address}:-%{NAS-IP-Address}}', '%{Calling-Station-Id}')" } } rlm_sql (WISPSQL): Driver rlm_sql_freetds (module rlm_sql_freetds) loaded and linked Creating attribute WISPSQL-SQL-Group # Loaded module rlm_unix # Loading module "unix" from file /etc/freeradius/mods-enabled/unix unix { radwtmp = "/var/log/freeradius/radwtmp" } Creating attribute Unix-Group # Loaded module rlm_radutmp # Loading 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 } # Loading module "sql" from file /etc/freeradius/mods-enabled/sql sql { driver = "rlm_sql_freetds" server = "SQLServer" port = 1433 login = "sa" password = <<< secret >>> radius_db = "ISP" read_groups = yes read_profiles = yes read_clients = yes delete_stale_sessions = yes sql_user_name = "%{User-Name}" default_user_profile = "" client_query = "SELECT Id, IPAddress, ShortName, 'other', Secret, ISNULL(Server, '') FROM nas WHERE IsActive = 1" authorize_check_query = "SELECT Id, UserName, Attribute, Value, Operation FROM radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY Id" authorize_reply_query = "SELECT Id, UserName, Attribute, Value, Operation FROM radreply WHERE UserName = '%{SQL-User-Name}' AND ( Attribute != 'Framed-IP-Address' OR ( Attribute = 'Framed-IP-Address' AND NOT EXISTS(SELECT * FROM radcheck INNER JOIN radgroupreply ON radcheck.GroupName = radgroupreply.GroupName WHERE radcheck.LineId = radreply.LineId AND radgroupreply.Attribute = 'Framed-Pool') ) ) ORDER BY Id" authorize_group_check_query = "SELECT radgroupcheck.Id,radgroupcheck.GroupName, radgroupcheck.Attribute,radgroupcheck.Value, radgroupcheck.Operation FROM radgroupcheck,radcheck WHERE radcheck.Username = '%{SQL-User-Name}' AND radcheck.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.Id" authorize_group_reply_query = "SELECT radgroupreply.Id, radgroupreply.GroupName, radgroupreply.Attribute,radgroupreply.Value, radgroupreply.Operation FROM radgroupreply,radcheck WHERE radcheck.Username = '%{SQL-User-Name}' AND radcheck.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.Id" group_membership_query = "SELECT GroupName FROM radcheck WHERE UserName = '%{SQL-User-Name}' AND Attribute = 'Cleartext-Password'" 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 = GETDATE(), AcctSessionTime = DATEDIFF(second, AcctStartTime, GETDATE()), AcctTerminateCause='%{%{Acct-Terminate-Cause}:-NAS-Reboot}', AcctStopDelay = %{Acct-Delay-Time} WHERE AcctStopTime IS NULL AND NASIPAddress = '%{%{Packet-Src-IP-Address}:-%{NAS-IP-Address}}' AND AcctStartTime <= GETDATE()" } accounting-off { query = "UPDATE radacct SET AcctStopTime = GETDATE(), AcctSessionTime = DATEDIFF(second, AcctStartTime, GETDATE()), AcctTerminateCause='%{%{Acct-Terminate-Cause}:-NAS-Reboot}', AcctStopDelay = %{Acct-Delay-Time} WHERE AcctStopTime IS NULL AND NASIPAddress = '%{%{Packet-Src-IP-Address}:-%{NAS-IP-Address}}' AND AcctStartTime <= GETDATE()" } start { query = "INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctUpdateTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfoStart, ConnectInfoStop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress) VALUES('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{%{Packet-Src-IP-Address}:-%{NAS-IP-Address}}', '%{%{NAS-Port-Id}:-%{NAS-Port}}', '%{NAS-Port-Type}', GETDATE(), GETDATE(), NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', NULL, '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', NULL, '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}')" } interim-update { query = "UPDATE radacct SET AcctInterval = DATEDIFF(second, AcctUpdateTime, GETDATE()), AcctUpdateTime = GETDATE(), AcctStopTime = NULL, AcctSessionTime = %{%{Acct-Session-Time}:-NULL}, FramedIPAddress = '%{Framed-IP-Address}', AcctInputOctets = convert(bigint, '%{%{Acct-Input-Gigawords}:-0}' * POWER(2.0, 32)) | '%{%{Acct-Input-Octets}:-0}', AcctOutputOctets = convert(bigint, '%{%{Acct-Output-Gigawords}:-0}' * POWER(2.0, 32)) | '%{%{Acct-Output-Octets}:-0}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}'" } stop { query = "UPDATE radacct SET AcctStopTime = GETDATE(), AcctSessionTime = %{%{Acct-Session-Time}:-NULL}, AcctInputOctets = convert(bigint, '%{%{Acct-Input-Gigawords}:-0}' * POWER(2.0, 32)) | '%{%{Acct-Input-Octets}:-0}', AcctOutputOctets = convert(bigint, '%{%{Acct-Output-Gigawords}:-0}' * POWER(2.0, 32)) | '%{%{Acct-Output-Octets}:-0}', AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay = %{Acct-Delay-Time}, ConnectInfoStop = '%{Connect-Info}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}'" } } } post-auth { reference = ".query" query = "INSERT INTO radpostauth (UserName, Password, Reply, AuthDate, NASIPAddress, CallingStationId) VALUES ( '%{SQL-User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', GETDATE(), '%{%{Packet-Src-IP-Address}:-%{NAS-IP-Address}}', '%{Calling-Station-Id}')" } } rlm_sql (sql): Driver rlm_sql_freetds (module rlm_sql_freetds) loaded and linked Creating attribute SQL-Group # Loaded module rlm_cache # Loading module "cache_eap" from file /etc/freeradius/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_replicate # Loading module "replicate" from file /etc/freeradius/mods-enabled/replicate # Loading 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 locking = no escape_filenames = no log_packet_header = no } # Loaded module rlm_linelog # Loading module "linelog" from file /etc/freeradius/mods-enabled/linelog linelog { filename = "/var/log/freeradius/linelog" 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_accounting" from file /etc/freeradius/mods-enabled/linelog linelog log_accounting { filename = "/var/log/freeradius/linelog-accounting" escape_filenames = no syslog_severity = "info" permissions = 384 format = "" reference = "Accounting-Request.%{%{Acct-Status-Type}:-unknown}" } # Loaded module rlm_chap # Loading module "chap" from file /etc/freeradius/mods-enabled/chap # Loading module "HotspotSQL" from file /etc/freeradius/mods-enabled/HotspotSQL sql HotspotSQL { driver = "rlm_sql_freetds" server = "SQLServer" port = 1433 login = "sa" password = <<< secret >>> radius_db = "Hotspot" read_groups = yes read_profiles = yes read_clients = yes delete_stale_sessions = yes sql_user_name = "%{User-Name}" default_user_profile = "" client_query = "SELECT Id, IPAddress, ShortName, 'other', Secret, ISNULL(Server, '') FROM nas WHERE IsActive = 1" authorize_check_query = "SELECT Id, UserName, Attribute, Value, Operation FROM vradcheck WHERE Username = '%{SQL-User-Name}' ORDER BY Id" authorize_reply_query = "SELECT Id, UserName, Attribute, Value, Operation FROM radreply WHERE UserName = '%{SQL-User-Name}' AND ( Attribute != 'Framed-IP-Address' OR ( Attribute = 'Framed-IP-Address' AND NOT EXISTS(SELECT * FROM vradcheck INNER JOIN radgroupreply ON vradcheck.GroupName = radgroupreply.GroupName WHERE vradcheck.LineId = radreply.LineId AND radgroupreply.Attribute = 'Framed-Pool') ) ) ORDER BY Id" authorize_group_check_query = "SELECT radgroupcheck.Id,radgroupcheck.GroupName, radgroupcheck.Attribute,radgroupcheck.Value, radgroupcheck.Operation FROM radgroupcheck,vradcheck WHERE vradcheck.Username = '%{SQL-User-Name}' AND vradcheck.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.Id" authorize_group_reply_query = "SELECT radgroupreply.Id, radgroupreply.GroupName, radgroupreply.Attribute,radgroupreply.Value, radgroupreply.Operation FROM radgroupreply,vradcheck WHERE vradcheck.Username = '%{SQL-User-Name}' AND vradcheck.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.Id" group_membership_query = "SELECT GroupName FROM vradcheck WHERE UserName = '%{SQL-User-Name}' AND Attribute = 'Cleartext-Password'" 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 = GETDATE(), AcctSessionTime = DATEDIFF(second, AcctStartTime, GETDATE()), AcctTerminateCause='%{%{Acct-Terminate-Cause}:-NAS-Reboot}', AcctStopDelay = %{Acct-Delay-Time} WHERE AcctStopTime IS NULL AND NASIPAddress = '%{%{Packet-Src-IP-Address}:-%{NAS-IP-Address}}' AND AcctStartTime <= GETDATE()" } accounting-off { query = "UPDATE radacct SET AcctStopTime = GETDATE(), AcctSessionTime = DATEDIFF(second, AcctStartTime, GETDATE()), AcctTerminateCause='%{%{Acct-Terminate-Cause}:-NAS-Reboot}', AcctStopDelay = %{Acct-Delay-Time} WHERE AcctStopTime IS NULL AND NASIPAddress = '%{%{Packet-Src-IP-Address}:-%{NAS-IP-Address}}' AND AcctStartTime <= GETDATE()" } start { query = "INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctUpdateTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfoStart, ConnectInfoStop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress) VALUES('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{%{Packet-Src-IP-Address}:-%{NAS-IP-Address}}', '%{%{NAS-Port-Id}:-%{NAS-Port}}', '%{NAS-Port-Type}', GETDATE(), GETDATE(), NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', NULL, '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', NULL, '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}')" } interim-update { query = "UPDATE radacct SET AcctInterval = DATEDIFF(second, AcctUpdateTime, GETDATE()), AcctUpdateTime = GETDATE(), AcctStopTime = NULL, AcctSessionTime = %{%{Acct-Session-Time}:-NULL}, FramedIPAddress = '%{Framed-IP-Address}', AcctInputOctets = convert(bigint, '%{%{Acct-Input-Gigawords}:-0}' * POWER(2.0, 32)) | '%{%{Acct-Input-Octets}:-0}', AcctOutputOctets = convert(bigint, '%{%{Acct-Output-Gigawords}:-0}' * POWER(2.0, 32)) | '%{%{Acct-Output-Octets}:-0}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}'" } stop { query = "UPDATE radacct SET AcctStopTime = GETDATE(), AcctSessionTime = %{%{Acct-Session-Time}:-NULL}, AcctInputOctets = convert(bigint, '%{%{Acct-Input-Gigawords}:-0}' * POWER(2.0, 32)) | '%{%{Acct-Input-Octets}:-0}', AcctOutputOctets = convert(bigint, '%{%{Acct-Output-Gigawords}:-0}' * POWER(2.0, 32)) | '%{%{Acct-Output-Octets}:-0}', AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay = %{Acct-Delay-Time}, ConnectInfoStop = '%{Connect-Info}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}'" } } } post-auth { reference = ".query" query = "INSERT INTO radpostauth (UserName, Password, Reply, AuthDate, NASIPAddress, CallingStationId) VALUES ( '%{SQL-User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', GETDATE(), '%{%{Packet-Src-IP-Address}:-%{NAS-IP-Address}}', '%{Calling-Station-Id}')" } } rlm_sql (HotspotSQL): Driver rlm_sql_freetds (module rlm_sql_freetds) loaded and linked Creating attribute HotspotSQL-SQL-Group # Loaded module rlm_digest # Loading module "digest" from file /etc/freeradius/mods-enabled/digest # Loading 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_date # Loading module "date" from file /etc/freeradius/mods-enabled/date date { format = "%b %e %Y %H:%M:%S %Z" utc = no } # Loading module "wispr2date" from file /etc/freeradius/mods-enabled/date date wispr2date { format = "%Y-%m-%dT%H:%M:%S" utc = no } # Loaded module rlm_eap # Loading module "eap" from file /etc/freeradius/mods-enabled/eap eap { default_eap_type = "md5" timer_expire = 60 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 16384 } # Loaded module rlm_dynamic_clients # Loading module "dynamic_clients" from file /etc/freeradius/mods-enabled/dynamic_clients # Loading 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_pap # Loading module "pap" from file /etc/freeradius/mods-enabled/pap pap { normalise = yes } # Loading 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 } # Loaded module rlm_always # Loading module "reject" from file /etc/freeradius/mods-enabled/always always reject { rcode = "reject" simulcount = 0 mpp = no } # Loading module "fail" from file /etc/freeradius/mods-enabled/always always fail { rcode = "fail" simulcount = 0 mpp = no } # Loading module "ok" from file /etc/freeradius/mods-enabled/always always ok { rcode = "ok" simulcount = 0 mpp = no } # Loading module "handled" from file /etc/freeradius/mods-enabled/always always handled { rcode = "handled" simulcount = 0 mpp = no } # Loading module "invalid" from file /etc/freeradius/mods-enabled/always always invalid { rcode = "invalid" simulcount = 0 mpp = no } # Loading module "userlock" from file /etc/freeradius/mods-enabled/always always userlock { rcode = "userlock" simulcount = 0 mpp = no } # Loading module "notfound" from file /etc/freeradius/mods-enabled/always always notfound { rcode = "notfound" simulcount = 0 mpp = no } # Loading module "noop" from file /etc/freeradius/mods-enabled/always always noop { rcode = "noop" simulcount = 0 mpp = no } # Loading module "updated" from file /etc/freeradius/mods-enabled/always always updated { rcode = "updated" simulcount = 0 mpp = no } instantiate { } # Instantiating module "files" from file /etc/freeradius/mods-enabled/files 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 # Instantiating module "expiration" from file /etc/freeradius/mods-enabled/expiration # Instantiating module "etc_passwd" from file /etc/freeradius/mods-enabled/passwd rlm_passwd: nfields: 3 keyfield 0(User-Name) listable: no # Instantiating module "attr_filter.post-proxy" from file /etc/freeradius/mods-enabled/attr_filter 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 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 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 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 reading pairlist file /etc/freeradius/mods-config/attr_filter/accounting_response # Instantiating module "auth_log" from file /etc/freeradius/mods-enabled/detail.log 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 # Instantiating module "pre_proxy_log" from file /etc/freeradius/mods-enabled/detail.log # Instantiating module "post_proxy_log" from file /etc/freeradius/mods-enabled/detail.log # Instantiating module "logintime" from file /etc/freeradius/mods-enabled/logintime # Instantiating module "mschap" from file /etc/freeradius/mods-enabled/mschap rlm_mschap (mschap): using internal authentication # Instantiating module "IPASS" from file /etc/freeradius/mods-enabled/realm # Instantiating module "suffix" from file /etc/freeradius/mods-enabled/realm # Instantiating module "bangpath" from file /etc/freeradius/mods-enabled/realm # Instantiating module "realmpercent" from file /etc/freeradius/mods-enabled/realm # Instantiating module "ntdomain" from file /etc/freeradius/mods-enabled/realm # Instantiating module "preprocess" from file /etc/freeradius/mods-enabled/preprocess reading pairlist file /etc/freeradius/mods-config/preprocess/huntgroups reading pairlist file /etc/freeradius/mods-config/preprocess/hints # Instantiating module "WISPSQL" from file /etc/freeradius/mods-enabled/WISPSQL rlm_sql (WISPSQL): Attempting to connect to database "WISP" rlm_sql (WISPSQL): Initialising connection pool pool { start = 5 min = 3 max = 32 spare = 10 uses = 0 lifetime = 0 cleanup_interval = 30 idle_timeout = 60 retry_delay = 30 spread = no } rlm_sql (WISPSQL): Opening additional connection (0), 1 of 32 pending slots used rlm_sql (WISPSQL): Opening additional connection (1), 1 of 31 pending slots used rlm_sql (WISPSQL): Opening additional connection (2), 1 of 30 pending slots used rlm_sql (WISPSQL): Opening additional connection (3), 1 of 29 pending slots used rlm_sql (WISPSQL): Opening additional connection (4), 1 of 28 pending slots used rlm_sql (WISPSQL): Processing generate_sql_clients rlm_sql (WISPSQL) in generate_sql_clients: query is SELECT Id, IPAddress, ShortName, 'other', Secret, ISNULL(Server, '') FROM nas WHERE IsActive = 1 rlm_sql (WISPSQL): Reserved connection (0) rlm_sql (WISPSQL): Executing select query: SELECT Id, IPAddress, ShortName, 'other', Secret, ISNULL(Server, '') FROM nas WHERE IsActive = 1 rlm_sql (WISPSQL): Adding client 192.168.1.200 (orbitalanya) to global clients list rlm_sql (192.168.1.200): Client "orbitalanya" (WISPSQL) added rlm_sql (WISPSQL): Released connection (0) Need 5 more connections to reach 10 spares rlm_sql (WISPSQL): Opening additional connection (5), 1 of 27 pending slots used # Instantiating module "sql" from file /etc/freeradius/mods-enabled/sql rlm_sql (sql): Attempting to connect to database "ISP" rlm_sql (sql): Initialising connection pool pool { start = 5 min = 3 max = 32 spare = 10 uses = 0 lifetime = 0 cleanup_interval = 30 idle_timeout = 60 retry_delay = 30 spread = no } rlm_sql (sql): Opening additional connection (0), 1 of 32 pending slots used rlm_sql (sql): Opening additional connection (1), 1 of 31 pending slots used rlm_sql (sql): Opening additional connection (2), 1 of 30 pending slots used rlm_sql (sql): Opening additional connection (3), 1 of 29 pending slots used rlm_sql (sql): Opening additional connection (4), 1 of 28 pending slots used rlm_sql (sql): Processing generate_sql_clients rlm_sql (sql) in generate_sql_clients: query is SELECT Id, IPAddress, ShortName, 'other', Secret, ISNULL(Server, '') FROM nas WHERE IsActive = 1 rlm_sql (sql): Reserved connection (0) rlm_sql (sql): Executing select query: SELECT Id, IPAddress, ShortName, 'other', Secret, ISNULL(Server, '') FROM nas WHERE IsActive = 1 rlm_sql (sql): Released connection (0) Need 5 more connections to reach 10 spares rlm_sql (sql): Opening additional connection (5), 1 of 27 pending slots used # Instantiating module "cache_eap" from file /etc/freeradius/mods-enabled/cache_eap rlm_cache (cache_eap): Driver rlm_cache_rbtree (module rlm_cache_rbtree) loaded and linked # Instantiating module "detail" from file /etc/freeradius/mods-enabled/detail # Instantiating module "linelog" from file /etc/freeradius/mods-enabled/linelog # Instantiating module "log_accounting" from file /etc/freeradius/mods-enabled/linelog # Instantiating module "HotspotSQL" from file /etc/freeradius/mods-enabled/HotspotSQL rlm_sql (HotspotSQL): Attempting to connect to database "Hotspot" rlm_sql (HotspotSQL): Initialising connection pool pool { start = 5 min = 3 max = 32 spare = 10 uses = 0 lifetime = 0 cleanup_interval = 30 idle_timeout = 60 retry_delay = 30 spread = no } rlm_sql (HotspotSQL): Opening additional connection (0), 1 of 32 pending slots used rlm_sql (HotspotSQL): Opening additional connection (1), 1 of 31 pending slots used rlm_sql (HotspotSQL): Opening additional connection (2), 1 of 30 pending slots used rlm_sql (HotspotSQL): Opening additional connection (3), 1 of 29 pending slots used rlm_sql (HotspotSQL): Opening additional connection (4), 1 of 28 pending slots used rlm_sql (HotspotSQL): Processing generate_sql_clients rlm_sql (HotspotSQL) in generate_sql_clients: query is SELECT Id, IPAddress, ShortName, 'other', Secret, ISNULL(Server, '') FROM nas WHERE IsActive = 1 rlm_sql (HotspotSQL): Reserved connection (0) rlm_sql (HotspotSQL): Executing select query: SELECT Id, IPAddress, ShortName, 'other', Secret, ISNULL(Server, '') FROM nas WHERE IsActive = 1 rlm_sql (HotspotSQL): Released connection (0) Need 5 more connections to reach 10 spares rlm_sql (HotspotSQL): Opening additional connection (5), 1 of 27 pending slots used # Instantiating module "eap" from file /etc/freeradius/mods-enabled/eap # Linked to sub-module rlm_eap_md5 # Linked to sub-module rlm_eap_leap # Linked to sub-module rlm_eap_gtc gtc { challenge = "Password: " auth_type = "PAP" } # Linked to sub-module rlm_eap_tls tls { tls = "tls-common" } tls-config tls-common { verify_depth = 0 ca_path = "/etc/freeradius/certs" pem_file_type = yes private_key_file = "/etc/freeradius/certs/server.pem" certificate_file = "/etc/freeradius/certs/server.pem" ca_file = "/etc/freeradius/certs/ca.pem" private_key_password = <<< secret >>> dh_file = "/etc/freeradius/certs/dh" fragment_size = 1024 include_length = yes auto_chain = yes check_crl = no check_all_crl = no cipher_list = "DEFAULT" cipher_server_preference = no ecdh_curve = "prime256v1" disable_tlsv1 = yes disable_tlsv1_1 = yes tls_max_version = "1.2" tls_min_version = "1.2" cache { enable = no lifetime = 24 max_entries = 255 } verify { skip_if_ocsp_ok = no } ocsp { enable = no override_cert_url = yes url = "http://127.0.0.1/ocsp/" use_nonce = yes timeout = 0 softfail = no } } Please use tls_min_version and tls_max_version instead of disable_tlsv1 Please use tls_min_version and tls_max_version instead of disable_tlsv1_2 # 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 } tls: Using cached TLS configuration from previous invocation # Linked to sub-module rlm_eap_peap peap { tls = "tls-common" default_eap_type = "mschapv2" copy_request_to_tunnel = no use_tunneled_reply = no proxy_tunneled_request_as_eap = yes virtual_server = "inner-tunnel" soh = no require_client_cert = no } tls: Using cached TLS configuration from previous invocation # Linked to sub-module rlm_eap_mschapv2 mschapv2 { with_ntdomain_hack = no send_error = no } # Instantiating module "pap" from file /etc/freeradius/mods-enabled/pap # Instantiating module "reject" from file /etc/freeradius/mods-enabled/always # Instantiating module "fail" from file /etc/freeradius/mods-enabled/always # Instantiating module "ok" from file /etc/freeradius/mods-enabled/always # Instantiating module "handled" from file /etc/freeradius/mods-enabled/always # Instantiating module "invalid" from file /etc/freeradius/mods-enabled/always # Instantiating module "userlock" from file /etc/freeradius/mods-enabled/always # Instantiating module "notfound" from file /etc/freeradius/mods-enabled/always # Instantiating module "noop" from file /etc/freeradius/mods-enabled/always # Instantiating module "updated" from file /etc/freeradius/mods-enabled/always } # modules radiusd: #### Loading Virtual Servers #### server { # from file /etc/freeradius/radiusd.conf } # server server default { # from file /etc/freeradius/sites-enabled/default # Loading authenticate {...} # Loading authorize {...} Ignoring "ldap" (see raddb/mods-available/README.rst) # Loading preacct {...} # Loading accounting {...} # Loading session {...} # Loading post-proxy {...} # Loading post-auth {...} } # server default server originate-coa.example.com { # from file /etc/freeradius/sites-enabled/originate-coa # Loading pre-proxy {...} # Loading post-proxy {...} } # server originate-coa.example.com server HotspotServer { # from file /etc/freeradius/sites-enabled/HotspotServer # Loading authenticate {...} # Loading authorize {...} # Loading preacct {...} # Loading accounting {...} # Loading session {...} # Loading post-proxy {...} # Loading post-auth {...} } # server HotspotServer server inner-tunnel { # from file /etc/freeradius/sites-enabled/inner-tunnel # Loading authenticate {...} # Loading authorize {...} # Loading session {...} # Loading post-proxy {...} # Loading post-auth {...} # Skipping contents of 'if' as it is always 'false' -- /etc/freeradius/sites-enabled/inner-tunnel:336 } # server inner-tunnel server WISPServer { # from file /etc/freeradius/sites-enabled/WISPServer # Loading authenticate {...} # Loading authorize {...} # Loading preacct {...} # Loading accounting {...} # Loading session {...} # Loading post-proxy {...} # Loading post-auth {...} } # server WISPServer /etc/freeradius/sites-enabled/default[605]: Please change "%{&control:User-NAS-Vendor}" to &&control:User-NAS-Vendor /etc/freeradius/sites-enabled/WISPServer[95]: Please change "%{&control:User-NAS-Vendor}" to &&control:User-NAS-Vendor radiusd: #### Opening IP addresses and Ports #### 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" ipv6addr = :: port = 0 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "acct" ipv6addr = :: port = 0 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 = "acct" ipaddr = * port = 3813 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "auth" ipv6addr = :: port = 3812 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "acct" ipv6addr = :: port = 3813 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "auth" ipaddr = 127.0.0.1 port = 18120 } listen { type = "auth" ipaddr = * port = 2812 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "acct" ipaddr = * port = 2813 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "auth" ipv6addr = :: port = 2812 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "acct" ipv6addr = :: port = 2813 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } Listening on auth address * port 1812 bound to server default Listening on acct address * port 1813 bound to server default Listening on auth address :: port 1812 bound to server default Listening on acct address :: port 1813 bound to server default Listening on auth address * port 3812 bound to server HotspotServer Listening on acct address * port 3813 bound to server HotspotServer Listening on auth address :: port 3812 bound to server HotspotServer Listening on acct address :: port 3813 bound to server HotspotServer Listening on auth address 127.0.0.1 port 18120 bound to server inner-tunnel Listening on auth address * port 2812 bound to server WISPServer Listening on acct address * port 2813 bound to server WISPServer Listening on auth address :: port 2812 bound to server WISPServer Listening on acct address :: port 2813 bound to server WISPServer Listening on proxy address * port 58263 Listening on proxy address :: port 54279 Ready to process requests (0) Received Access-Request Id 31 from 192.168.1.200:50552 to 192.168.1.51:2812 length 160 (0) Service-Type = Framed-User (0) Framed-Protocol = PPP (0) NAS-Port = 15728642 (0) NAS-Port-Type = Ethernet (0) User-Name = "test@orbit" (0) Calling-Station-Id = "D8:C4:97:15:C1:F8" (0) Called-Station-Id = "PPPoE" (0) NAS-Port-Id = "LAN" (0) MS-CHAP-Domain = "orbit" (0) Acct-Session-Id = "81600002" (0) User-Password = "102030" (0) NAS-Identifier = "orbitalanya" (0) Mikrotik-Realm = "orbit" (0) NAS-IP-Address = 192.168.1.200 (0) # Executing section authorize from file /etc/freeradius/sites-enabled/WISPServer (0) authorize { (0) [preprocess] = ok (0) [chap] = noop (0) [mschap] = noop (0) [digest] = noop (0) eap: No EAP-Message, not doing EAP (0) [eap] = noop (0) WISPSQL: EXPAND %{User-Name} (0) WISPSQL: --> test@orbit (0) WISPSQL: SQL-User-Name set to 'test@orbit' rlm_sql (WISPSQL): Reserved connection (1) (0) WISPSQL: EXPAND SELECT Id, UserName, Attribute, Value, Operation FROM radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY Id (0) WISPSQL: --> SELECT Id, UserName, Attribute, Value, Operation FROM radcheck WHERE Username = 'test@orbit' ORDER BY Id (0) WISPSQL: Executing select query: SELECT Id, UserName, Attribute, Value, Operation FROM radcheck WHERE Username = 'test@orbit' ORDER BY Id (0) WISPSQL: User found in radcheck table (0) WISPSQL: Conditional check items matched, merging assignment check items (0) WISPSQL: Cleartext-Password := "102030" (0) WISPSQL: EXPAND SELECT Id, UserName, Attribute, Value, Operation FROM radreply WHERE UserName = '%{SQL-User-Name}' AND ( Attribute != 'Framed-IP-Address' OR ( Attribute = 'Framed-IP-Address' AND NOT EXISTS(SELECT * FROM radcheck INNER JOIN radgroupreply ON radcheck.GroupName = radgroupreply.GroupName WHERE radcheck.LineId = radreply.LineId AND radgroupreply.Attribute = 'Framed-Pool') ) ) ORDER BY Id (0) WISPSQL: --> SELECT Id, UserName, Attribute, Value, Operation FROM radreply WHERE UserName = 'test@orbit' AND ( Attribute != 'Framed-IP-Address' OR ( Attribute = 'Framed-IP-Address' AND NOT EXISTS(SELECT * FROM radcheck INNER JOIN radgroupreply ON radcheck.GroupName = radgroupreply.GroupName WHERE radcheck.LineId = radreply.LineId AND radgroupreply.Attribute = 'Framed-Pool') ) ) ORDER BY Id (0) WISPSQL: Executing select query: SELECT Id, UserName, Attribute, Value, Operation FROM radreply WHERE UserName = 'test@orbit' AND ( Attribute != 'Framed-IP-Address' OR ( Attribute = 'Framed-IP-Address' AND NOT EXISTS(SELECT * FROM radcheck INNER JOIN radgroupreply ON radcheck.GroupName = radgroupreply.GroupName WHERE radcheck.LineId = radreply.LineId AND radgroupreply.Attribute = 'Framed-Pool') ) ) ORDER BY Id rlm_sql (WISPSQL): Reserved connection (2) rlm_sql (WISPSQL): Released connection (2) Need 5 more connections to reach 10 spares rlm_sql (WISPSQL): Opening additional connection (6), 1 of 26 pending slots used (0) WISPSQL: EXPAND SELECT GroupName FROM radcheck WHERE UserName = '%{SQL-User-Name}' AND Attribute = 'Cleartext-Password' (0) WISPSQL: --> SELECT GroupName FROM radcheck WHERE UserName = 'test@orbit' AND Attribute = 'Cleartext-Password' (0) WISPSQL: Executing select query: SELECT GroupName FROM radcheck WHERE UserName = 'test@orbit' AND Attribute = 'Cleartext-Password' (0) WISPSQL: User found in the group table (0) WISPSQL: EXPAND SELECT radgroupcheck.Id,radgroupcheck.GroupName, radgroupcheck.Attribute,radgroupcheck.Value, radgroupcheck.Operation FROM radgroupcheck,radcheck WHERE radcheck.Username = '%{SQL-User-Name}' AND radcheck.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.Id (0) WISPSQL: --> SELECT radgroupcheck.Id,radgroupcheck.GroupName, radgroupcheck.Attribute,radgroupcheck.Value, radgroupcheck.Operation FROM radgroupcheck,radcheck WHERE radcheck.Username = 'test@orbit' AND radcheck.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.Id (0) WISPSQL: Executing select query: SELECT radgroupcheck.Id,radgroupcheck.GroupName, radgroupcheck.Attribute,radgroupcheck.Value, radgroupcheck.Operation FROM radgroupcheck,radcheck WHERE radcheck.Username = 'test@orbit' AND radcheck.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.Id (0) WISPSQL: Group "default": Conditional check items matched (0) WISPSQL: Group "default": Merging assignment check items (0) WISPSQL: EXPAND SELECT radgroupreply.Id, radgroupreply.GroupName, radgroupreply.Attribute,radgroupreply.Value, radgroupreply.Operation FROM radgroupreply,radcheck WHERE radcheck.Username = '%{SQL-User-Name}' AND radcheck.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.Id (0) WISPSQL: --> SELECT radgroupreply.Id, radgroupreply.GroupName, radgroupreply.Attribute,radgroupreply.Value, radgroupreply.Operation FROM radgroupreply,radcheck WHERE radcheck.Username = 'test@orbit' AND radcheck.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.Id (0) WISPSQL: Executing select query: SELECT radgroupreply.Id, radgroupreply.GroupName, radgroupreply.Attribute,radgroupreply.Value, radgroupreply.Operation FROM radgroupreply,radcheck WHERE radcheck.Username = 'test@orbit' AND radcheck.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.Id (0) WISPSQL: Group "default": Merging reply items rlm_sql (WISPSQL): Released connection (1) (0) [WISPSQL] = ok (0) [expiration] = noop (0) [logintime] = noop (0) [pap] = updated (0) } # authorize = updated (0) Found Auth-Type = PAP (0) # Executing group from file /etc/freeradius/sites-enabled/WISPServer (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/freeradius/sites-enabled/WISPServer (0) post-auth { (0) if (session-state:User-Name && reply:User-Name && request:User-Name && (reply:User-Name == request:User-Name)) {(0) if (session-state:User-Name && reply:User-Name && request:User-Name && (reply:User-Name == request:User-Name)) -> FALSE (0) update { (0) No attributes updated for RHS &session-state: (0) } # update = noop (0) update reply { (0) Acct-Interim-Interval := 60 (0) } # update reply = noop (0) WISPSQL: EXPAND .query (0) WISPSQL: --> .query (0) WISPSQL: Using query template 'query' rlm_sql (WISPSQL): Reserved connection (3) (0) WISPSQL: EXPAND %{User-Name} (0) WISPSQL: --> test@orbit (0) WISPSQL: SQL-User-Name set to 'test@orbit' (0) WISPSQL: EXPAND INSERT INTO radpostauth (UserName, Password, Reply, AuthDate, NASIPAddress, CallingStationId) VALUES ( '%{SQL-User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', GETDATE(), '%{%{Packet-Src-IP-Address}:-%{NAS-IP-Address}}', '%{Calling-Station-Id}') (0) WISPSQL: --> INSERT INTO radpostauth (UserName, Password, Reply, AuthDate, NASIPAddress, CallingStationId) VALUES ( 'test@orbit', '102030', 'Access-Accept', GETDATE(), '192.168.1.200', 'D8:C4:97:15:C1:F8') (0) WISPSQL: Executing query: INSERT INTO radpostauth (UserName, Password, Reply, AuthDate, NASIPAddress, CallingStationId) VALUES ( 'test@orbit', '102030', 'Access-Accept', GETDATE(), '192.168.1.200', 'D8:C4:97:15:C1:F8') (0) WISPSQL: SQL query returned: success (0) WISPSQL: -1 record(s) updated (0) WISPSQL: No additional queries configured rlm_sql (WISPSQL): Released connection (3) (0) [WISPSQL] = noop (0) [exec] = noop (0) policy remove_reply_message_if_eap { (0) if (&reply:EAP-Message && &reply:Reply-Message) { (0) if (&reply:EAP-Message && &reply:Reply-Message) -> FALSE (0) else { (0) [noop] = noop (0) } # else = noop (0) } # policy remove_reply_message_if_eap = noop (0) } # post-auth = noop (0) Sent Access-Accept Id 31 from 192.168.1.51:2812 to 192.168.1.200:50552 length 0 (0) Acct-Interim-Interval := 60 (0) Finished request Waking up in 4.9 seconds. (1) Received Accounting-Request Id 32 from 192.168.1.200:56760 to 192.168.1.51:2813 length 172 (1) Service-Type = Framed-User (1) Framed-Protocol = PPP (1) NAS-Port = 15728642 (1) NAS-Port-Type = Ethernet (1) User-Name = "test@orbit" (1) Calling-Station-Id = "D8:C4:97:15:C1:F8" (1) Called-Station-Id = "PPPoE" (1) NAS-Port-Id = "LAN" (1) MS-CHAP-Domain = "orbit" (1) Acct-Session-Id = "81600002" (1) Framed-IP-Address = 192.168.10.255 (1) Acct-Authentic = RADIUS (1) Event-Timestamp = "Aug 6 2020 09:19:48 UTC" (1) Acct-Status-Type = Start (1) NAS-Identifier = "orbitalanya" (1) Acct-Delay-Time = 0 (1) Mikrotik-Realm = "orbit" (1) NAS-IP-Address = 192.168.1.200 (1) # Executing section preacct from file /etc/freeradius/sites-enabled/WISPServer (1) preacct { (1) [preprocess] = ok (1) if (&User-Name) { (1) if (&User-Name) -> TRUE (1) if (&User-Name) { (1) if ("%{WISPSQL:SELECT [dbo].[CheckDisconnectUser]('%{User-Name}', '%{Framed-IP-Address}', '%{Packet-Src-IP-Address}')}" == 1) { rlm_sql (WISPSQL): Reserved connection (4) rlm_sql (WISPSQL): Released connection (4) rlm_sql (WISPSQL): Reserved connection (0) rlm_sql (WISPSQL): Released connection (0) rlm_sql (WISPSQL): Reserved connection (5) rlm_sql (WISPSQL): Released connection (5) (1) EXPAND %{User-Name} (1) --> test@orbit (1) SQL-User-Name set to 'test@orbit' rlm_sql (WISPSQL): Reserved connection (1) (1) Executing select query: SELECT [dbo].[CheckDisconnectUser]('test@orbit', '192.168.10.255', '192.168.1.200') rlm_sql (WISPSQL): Released connection (1) (1) EXPAND %{WISPSQL:SELECT [dbo].[CheckDisconnectUser]('%{User-Name}', '%{Framed-IP-Address}', '%{Packet-Src-IP-Address}')} (1) --> 0 (1) if ("%{WISPSQL:SELECT [dbo].[CheckDisconnectUser]('%{User-Name}', '%{Framed-IP-Address}', '%{Packet-Src-IP-Address}')}" == 1) -> FALSE (1) else { (1) update control { rlm_sql (WISPSQL): Reserved connection (2) rlm_sql (WISPSQL): Released connection (2) (1) EXPAND %{User-Name} (1) --> test@orbit (1) SQL-User-Name set to 'test@orbit' rlm_sql (WISPSQL): Reserved connection (6) (1) Executing select query: SELECT TOP 1 Vendor FROM nas WHERE IPAddress = '192.168.1.200' rlm_sql (WISPSQL): Released connection (6) (1) EXPAND %{WISPSQL: SELECT TOP 1 Vendor FROM nas WHERE IPAddress = '%{Packet-Src-IP-Address}'} (1) --> Mikrotik (1) User-NAS-Vendor = Mikrotik rlm_sql (WISPSQL): Reserved connection (3) rlm_sql (WISPSQL): Released connection (3) (1) EXPAND %{User-Name} (1) --> test@orbit (1) SQL-User-Name set to 'test@orbit' rlm_sql (WISPSQL): Reserved connection (4) (1) Executing select query: SELECT [dbo].[GetUserRateLimit]('test@orbit') rlm_sql (WISPSQL): Released connection (4) (1) EXPAND %{WISPSQL:SELECT [dbo].[GetUserRateLimit]('%{User-Name}')} (1) --> 1024k/8196k (1) User-Rate-Limit = 1024k/8196k (1) } # update control = noop (1) if (&control:User-Rate-Limit && &control:User-Rate-Limit != '') { (1) if (&control:User-Rate-Limit && &control:User-Rate-Limit != '') -> TRUE (1) if (&control:User-Rate-Limit && &control:User-Rate-Limit != '') { (1) switch %{&control:User-NAS-Vendor} { (1) case Mikrotik { (1) if (!&Mikrotik-Rate-Limit || &control:User-Rate-Limit != &Mikrotik-Rate-Limit) { (1) if (!&Mikrotik-Rate-Limit || &control:User-Rate-Limit != &Mikrotik-Rate-Limit) -> TRUE (1) if (!&Mikrotik-Rate-Limit || &control:User-Rate-Limit != &Mikrotik-Rate-Limit) { (1) update coa { (1) EXPAND %{User-Name} (1) --> test@orbit (1) &User-Name = test@orbit (1) EXPAND %{Framed-IP-Address} (1) --> 192.168.10.255 (1) &Framed-IP-Address = 192.168.10.255 (1) &Mikrotik-Rate-Limit := &control:User-Rate-Limit -> '1024k/8196k' (1) } # update coa = noop (1) } # if (!&Mikrotik-Rate-Limit || &control:User-Rate-Limit != &Mikrotik-Rate-Limit) = noop (1) } # case Mikrotik = noop (1) } # switch %{&control:User-NAS-Vendor} = noop (1) } # if (&control:User-Rate-Limit && &control:User-Rate-Limit != '') = noop (1) } # else = noop (1) } # if (&User-Name) = noop (1) policy acct_unique { (1) update request { (1) &Tmp-String-9 := "ai:" (1) } # update request = noop (1) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (1) EXPAND %{hex:&Class} (1) --> (1) EXPAND ^%{hex:&Tmp-String-9} (1) --> ^61693a (1) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) -> FALSE (1) else { (1) update request { (1) EXPAND %{md5:%{User-Name},%{Acct-Session-ID},%{%{NAS-IPv6-Address}:-%{NAS-IP-Address}},%{NAS-Identifier},%{NAS-Port-ID},%{NAS-Port}} (1) --> 69913b8866eac834270ab589229ef6ab (1) &Acct-Unique-Session-Id := 69913b8866eac834270ab589229ef6ab (1) } # update request = noop (1) } # else = noop (1) } # policy acct_unique = noop (1) } # preacct = ok (1) # Executing section accounting from file /etc/freeradius/sites-enabled/WISPServer (1) accounting { (1) [unix] = ok (1) WISPSQL: EXPAND %{tolower:type.%{%{Acct-Status-Type}:-%{Request-Processing-Stage}}.query} (1) WISPSQL: --> type.start.query (1) WISPSQL: Using query template 'query' rlm_sql (WISPSQL): Reserved connection (0) (1) WISPSQL: EXPAND %{User-Name} (1) WISPSQL: --> test@orbit (1) WISPSQL: SQL-User-Name set to 'test@orbit' (1) WISPSQL: EXPAND INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctUpdateTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfoStart, ConnectInfoStop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress) VALUES('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{%{Packet-Src-IP-Address}:-%{NAS-IP-Address}}', '%{%{NAS-Port-Id}:-%{NAS-Port}}', '%{NAS-Port-Type}', GETDATE(), GETDATE(), NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', NULL, '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', NULL, '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}') (1) WISPSQL: --> INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctUpdateTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfoStart, ConnectInfoStop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress) VALUES('81600002', '69913b8866eac834270ab589229ef6ab', 'test@orbit', '', '192.168.1.200', 'LAN', 'Ethernet', GETDATE(), GETDATE(), NULL, '0', 'RADIUS', '', NULL, '0', '0', 'PPPoE', 'D8:C4:97:15:C1:F8', NULL, 'Framed-User', 'PPP', '192.168.10.255') (1) WISPSQL: Executing query: INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctUpdateTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfoStart, ConnectInfoStop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress) VALUES('81600002', '69913b8866eac834270ab589229ef6ab', 'test@orbit', '', '192.168.1.200', 'LAN', 'Ethernet', GETDATE(), GETDATE(), NULL, '0', 'RADIUS', '', NULL, '0', '0', 'PPPoE', 'D8:C4:97:15:C1:F8', NULL, 'Framed-User', 'PPP', '192.168.10.255') (1) WISPSQL: SQL query returned: success (1) WISPSQL: -1 record(s) updated (1) WISPSQL: Trying next query... (1) WISPSQL: EXPAND UPDATE radacct SET AcctStartTime = GETDATE(), AcctUpdateTime = GETDATE(), AcctStartDelay = %{Acct-Delay-Time}, ConnectInfoStart = '%{Connect-Info}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}' (1) WISPSQL: --> UPDATE radacct SET AcctStartTime = GETDATE(), AcctUpdateTime = GETDATE(), AcctStartDelay = 0, ConnectInfoStart = '' WHERE AcctUniqueId = '69913b8866eac834270ab589229ef6ab' (1) WISPSQL: Executing query: UPDATE radacct SET AcctStartTime = GETDATE(), AcctUpdateTime = GETDATE(), AcctStartDelay = 0, ConnectInfoStart = '' WHERE AcctUniqueId = '69913b8866eac834270ab589229ef6ab' (1) WISPSQL: SQL query returned: success (1) WISPSQL: -1 record(s) updated (1) WISPSQL: No additional queries configured rlm_sql (WISPSQL): Released connection (0) (1) [WISPSQL] = noop (1) update control { (1) EXPAND %{User-Name} (1) --> test@orbit (1) SQL-User-Name set to 'test@orbit' rlm_sql (WISPSQL): Reserved connection (5) (1) Executing select query: SELECT @@ROWCOUNT rlm_sql (WISPSQL): Released connection (5) (1) EXPAND %{WISPSQL:SELECT @@ROWCOUNT} (1) --> 0 (1) Tmp-Integer-0 = 0 (1) } # update control = noop (1) [exec] = noop (1) attr_filter.accounting_response: EXPAND %{User-Name} (1) attr_filter.accounting_response: --> test@orbit (1) attr_filter.accounting_response: Matched entry DEFAULT at line 12 (1) [attr_filter.accounting_response] = updated (1) } # accounting = updated (1) Sent CoA-Request Id 149 from 0.0.0.0:58263 to 192.168.1.200:3799 length 57 (1) User-Name = "test@orbit" (1) Framed-IP-Address = 192.168.10.255 (1) Mikrotik-Rate-Limit := "1024k/8196k" (1) Sent Accounting-Response Id 32 from 192.168.1.51:2813 to 192.168.1.200:56760 length 0 (1) Finished request (1) Cleaning up request packet ID 32 with timestamp +21 Waking up in 2.3 seconds. (1) Marking home server 192.168.1.200 port 3799 alive (1) Clearing existing &reply: attributes (1) Received CoA-ACK Id 149 from 192.168.1.200:3799 to 192.168.1.51:58263 length 33 (1) NAS-Identifier = "orbitalanya" (1) server WISPServer { (1) # Executing section post-proxy from file /etc/freeradius/sites-enabled/WISPServer (1) post-proxy { (1) eap: No pre-existing handler found (1) [eap] = noop (1) } # post-proxy = noop (1) } (1) Cleaning up request packet ID 32 with timestamp +21 Waking up in 4.6 seconds. (0) Cleaning up request packet ID 31 with timestamp +21 Ready to process requests (2) Received Accounting-Request Id 34 from 192.168.1.200:35859 to 192.168.1.51:2813 length 281 (2) Service-Type = Framed-User (2) Framed-Protocol = PPP (2) NAS-Port = 15728642 (2) NAS-Port-Type = Ethernet (2) User-Name = "test@orbit" (2) Calling-Station-Id = "D8:C4:97:15:C1:F8" (2) Called-Station-Id = "PPPoE" (2) NAS-Port-Id = "LAN" (2) MS-CHAP-Domain = "orbit" (2) Acct-Session-Id = "81600002" (2) Framed-IP-Address = 192.168.10.255 (2) Acct-Authentic = RADIUS (2) Event-Timestamp = "Aug 6 2020 09:21:48 UTC" (2) Acct-Session-Time = 121 (2) Idle-Timeout = 0 (2) Session-Timeout = 0 (2) X-Ascend-Data-Rate = 8196000 (2) Ascend-Xmit-Rate = 8196000 (2) X-Ascend-Data-Rate = 1024000 (2) Ascend-Data-Rate = 1024000 (2) Mikrotik-Rate-Limit = "1024k/8196k" (2) Acct-Input-Octets = 95438 (2) Acct-Input-Gigawords = 0 (2) Acct-Input-Packets = 1165 (2) Acct-Output-Octets = 45977 (2) Acct-Output-Gigawords = 0 (2) Acct-Output-Packets = 113 (2) Acct-Status-Type = Interim-Update (2) NAS-Identifier = "orbitalanya" (2) Acct-Delay-Time = 0 (2) Mikrotik-Realm = "orbit" (2) NAS-IP-Address = 192.168.1.200 (2) # Executing section preacct from file /etc/freeradius/sites-enabled/WISPServer (2) preacct { (2) [preprocess] = ok (2) if (&User-Name) { (2) if (&User-Name) -> TRUE (2) if (&User-Name) { (2) if ("%{WISPSQL:SELECT [dbo].[CheckDisconnectUser]('%{User-Name}', '%{Framed-IP-Address}', '%{Packet-Src-IP-Address}')}" == 1) { rlm_sql (WISPSQL): Closing connection (1): Hit idle_timeout, was idle for 120 seconds rlm_sql_freetds: socket destructor called, closing socket rlm_sql (WISPSQL): Closing connection (2): Hit idle_timeout, was idle for 120 seconds rlm_sql_freetds: socket destructor called, closing socket rlm_sql (WISPSQL): Closing connection (6): Hit idle_timeout, was idle for 120 seconds rlm_sql_freetds: socket destructor called, closing socket rlm_sql (WISPSQL): Closing connection (3): Hit idle_timeout, was idle for 120 seconds rlm_sql_freetds: socket destructor called, closing socket rlm_sql (WISPSQL): Closing connection (4): Hit idle_timeout, was idle for 120 seconds rlm_sql (WISPSQL): You probably need to lower "min" rlm_sql_freetds: socket destructor called, closing socket rlm_sql (WISPSQL): Closing connection (0): Hit idle_timeout, was idle for 120 seconds rlm_sql (WISPSQL): You probably need to lower "min" rlm_sql_freetds: socket destructor called, closing socket rlm_sql (WISPSQL): Closing connection (5): Hit idle_timeout, was idle for 120 seconds rlm_sql (WISPSQL): You probably need to lower "min" rlm_sql_freetds: socket destructor called, closing socket rlm_sql (WISPSQL): 0 of 0 connections in use. You may need to increase "spare" rlm_sql (WISPSQL): Opening additional connection (7), 1 of 32 pending slots used rlm_sql (WISPSQL): Reserved connection (7) rlm_sql (WISPSQL): Released connection (7) Need 2 more connections to reach min connections (3) rlm_sql (WISPSQL): Opening additional connection (8), 1 of 31 pending slots used rlm_sql (WISPSQL): Reserved connection (7) rlm_sql (WISPSQL): Released connection (7) rlm_sql (WISPSQL): Reserved connection (8) rlm_sql (WISPSQL): Released connection (8) (2) EXPAND %{User-Name} (2) --> test@orbit (2) SQL-User-Name set to 'test@orbit' rlm_sql (WISPSQL): Reserved connection (7) (2) Executing select query: SELECT [dbo].[CheckDisconnectUser]('test@orbit', '192.168.10.255', '192.168.1.200') rlm_sql (WISPSQL): Released connection (7) (2) EXPAND %{WISPSQL:SELECT [dbo].[CheckDisconnectUser]('%{User-Name}', '%{Framed-IP-Address}', '%{Packet-Src-IP-Address}')} (2) --> 0 (2) if ("%{WISPSQL:SELECT [dbo].[CheckDisconnectUser]('%{User-Name}', '%{Framed-IP-Address}', '%{Packet-Src-IP-Address}')}" == 1) -> FALSE (2) else { (2) update control { rlm_sql (WISPSQL): Reserved connection (8) rlm_sql (WISPSQL): Released connection (8) (2) EXPAND %{User-Name} (2) --> test@orbit (2) SQL-User-Name set to 'test@orbit' rlm_sql (WISPSQL): Reserved connection (7) (2) Executing select query: SELECT TOP 1 Vendor FROM nas WHERE IPAddress = '192.168.1.200' rlm_sql (WISPSQL): Released connection (7) (2) EXPAND %{WISPSQL: SELECT TOP 1 Vendor FROM nas WHERE IPAddress = '%{Packet-Src-IP-Address}'} (2) --> Mikrotik (2) User-NAS-Vendor = Mikrotik rlm_sql (WISPSQL): Reserved connection (8) rlm_sql (WISPSQL): Released connection (8) (2) EXPAND %{User-Name} (2) --> test@orbit (2) SQL-User-Name set to 'test@orbit' rlm_sql (WISPSQL): Reserved connection (7) (2) Executing select query: SELECT [dbo].[GetUserRateLimit]('test@orbit') rlm_sql (WISPSQL): Released connection (7) (2) EXPAND %{WISPSQL:SELECT [dbo].[GetUserRateLimit]('%{User-Name}')} (2) --> 1024k/8196k (2) User-Rate-Limit = 1024k/8196k (2) } # update control = noop (2) if (&control:User-Rate-Limit && &control:User-Rate-Limit != '') { (2) if (&control:User-Rate-Limit && &control:User-Rate-Limit != '') -> TRUE (2) if (&control:User-Rate-Limit && &control:User-Rate-Limit != '') { (2) switch %{&control:User-NAS-Vendor} { (2) case Mikrotik { (2) if (!&Mikrotik-Rate-Limit || &control:User-Rate-Limit != &Mikrotik-Rate-Limit) { (2) if (!&Mikrotik-Rate-Limit || &control:User-Rate-Limit != &Mikrotik-Rate-Limit) -> FALSE (2) } # case Mikrotik = noop (2) } # switch %{&control:User-NAS-Vendor} = noop (2) } # if (&control:User-Rate-Limit && &control:User-Rate-Limit != '') = noop (2) } # else = noop (2) } # if (&User-Name) = noop (2) policy acct_unique { (2) update request { (2) &Tmp-String-9 := "ai:" (2) } # update request = noop (2) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (2) EXPAND %{hex:&Class} (2) --> (2) EXPAND ^%{hex:&Tmp-String-9} (2) --> ^61693a (2) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) -> FALSE (2) else { (2) update request { (2) EXPAND %{md5:%{User-Name},%{Acct-Session-ID},%{%{NAS-IPv6-Address}:-%{NAS-IP-Address}},%{NAS-Identifier},%{NAS-Port-ID},%{NAS-Port}} (2) --> 69913b8866eac834270ab589229ef6ab (2) &Acct-Unique-Session-Id := 69913b8866eac834270ab589229ef6ab (2) } # update request = noop (2) } # else = noop (2) } # policy acct_unique = noop (2) } # preacct = ok (2) # Executing section accounting from file /etc/freeradius/sites-enabled/WISPServer (2) accounting { (2) [unix] = noop (2) WISPSQL: EXPAND %{tolower:type.%{%{Acct-Status-Type}:-%{Request-Processing-Stage}}.query} (2) WISPSQL: --> type.interim-update.query (2) WISPSQL: Using query template 'query' rlm_sql (WISPSQL): Reserved connection (8) (2) WISPSQL: EXPAND %{User-Name} (2) WISPSQL: --> test@orbit (2) WISPSQL: SQL-User-Name set to 'test@orbit' (2) WISPSQL: EXPAND UPDATE radacct SET AcctInterval = DATEDIFF(second, AcctUpdateTime, GETDATE()), AcctUpdateTime = GETDATE(), AcctStopTime = NULL, AcctSessionTime = %{%{Acct-Session-Time}:-NULL}, FramedIPAddress = '%{Framed-IP-Address}', AcctInputOctets = convert(bigint, '%{%{Acct-Input-Gigawords}:-0}' * POWER(2.0, 32)) | '%{%{Acct-Input-Octets}:-0}', AcctOutputOctets = convert(bigint, '%{%{Acct-Output-Gigawords}:-0}' * POWER(2.0, 32)) | '%{%{Acct-Output-Octets}:-0}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}' (2) WISPSQL: --> UPDATE radacct SET AcctInterval = DATEDIFF(second, AcctUpdateTime, GETDATE()), AcctUpdateTime = GETDATE(), AcctStopTime = NULL, AcctSessionTime = 121, FramedIPAddress = '192.168.10.255', AcctInputOctets = convert(bigint, '0' * POWER(2.0, 32)) | '95438', AcctOutputOctets = convert(bigint, '0' * POWER(2.0, 32)) | '45977' WHERE AcctUniqueId = '69913b8866eac834270ab589229ef6ab' (2) WISPSQL: Executing query: UPDATE radacct SET AcctInterval = DATEDIFF(second, AcctUpdateTime, GETDATE()), AcctUpdateTime = GETDATE(), AcctStopTime = NULL, AcctSessionTime = 121, FramedIPAddress = '192.168.10.255', AcctInputOctets = convert(bigint, '0' * POWER(2.0, 32)) | '95438', AcctOutputOctets = convert(bigint, '0' * POWER(2.0, 32)) | '45977' WHERE AcctUniqueId = '69913b8866eac834270ab589229ef6ab' (2) WISPSQL: SQL query returned: success (2) WISPSQL: -1 record(s) updated (2) WISPSQL: Trying next query... (2) WISPSQL: EXPAND IF NOT EXISTS(SELECT 1 FROM radacct WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}') INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctUpdateTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfoStart, ConnectInfoStop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress) VALUES('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{%{Packet-Src-IP-Address}:-%{NAS-IP-Address}}', '%{%{NAS-Port-Id}:-%{NAS-Port}}', '%{NAS-Port-Type}', DATEADD(second, -1 * (%{%{Acct-Session-Time}:-0}), GETDATE()), GETDATE(), NULL, %{%{Acct-Session-Time}:-NULL}, '%{Acct-Authentic}', '%{Connect-Info}', NULL, convert(bigint, '%{%{Acct-Input-Gigawords}:-0}' * POWER(2.0, 32)) | '%{%{Acct-Input-Octets}:-0}', convert(bigint, '%{%{Acct-Output-Gigawords}:-0}' * POWER(2.0, 32)) | '%{%{Acct-Output-Octets}:-0}', '%{Called-Station-Id}', '%{Calling-Station-Id}', NULL, '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}') (2) WISPSQL: --> IF NOT EXISTS(SELECT 1 FROM radacct WHERE AcctUniqueId = '69913b8866eac834270ab589229ef6ab') INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctUpdateTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfoStart, ConnectInfoStop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress) VALUES('81600002', '69913b8866eac834270ab589229ef6ab', 'test@orbit', '', '192.168.1.200', 'LAN', 'Ethernet', DATEADD(second, -1 * (121), GETDATE()), GETDATE(), NULL, 121, 'RADIUS', '', NULL, convert(bigint, '0' * POWER(2.0, 32)) | '95438', convert(bigint, '0' * POWER(2.0, 32)) | '45977', 'PPPoE', 'D8:C4:97:15:C1:F8', NULL, 'Framed-User', 'PPP', '192.168.10.255') (2) WISPSQL: Executing query: IF NOT EXISTS(SELECT 1 FROM radacct WHERE AcctUniqueId = '69913b8866eac834270ab589229ef6ab') INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctUpdateTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfoStart, ConnectInfoStop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress) VALUES('81600002', '69913b8866eac834270ab589229ef6ab', 'test@orbit', '', '192.168.1.200', 'LAN', 'Ethernet', DATEADD(second, -1 * (121), GETDATE()), GETDATE(), NULL, 121, 'RADIUS', '', NULL, convert(bigint, '0' * POWER(2.0, 32)) | '95438', convert(bigint, '0' * POWER(2.0, 32)) | '45977', 'PPPoE', 'D8:C4:97:15:C1:F8', NULL, 'Framed-User', 'PPP', '192.168.10.255') (2) WISPSQL: SQL query returned: success (2) WISPSQL: -1 record(s) updated (2) WISPSQL: No additional queries configured rlm_sql (WISPSQL): Released connection (8) (2) [WISPSQL] = noop (2) update control { (2) EXPAND %{User-Name} (2) --> test@orbit (2) SQL-User-Name set to 'test@orbit' rlm_sql (WISPSQL): Reserved connection (7) (2) Executing select query: SELECT @@ROWCOUNT rlm_sql (WISPSQL): Released connection (7) (2) EXPAND %{WISPSQL:SELECT @@ROWCOUNT} (2) --> 1 (2) Tmp-Integer-0 = 1 (2) } # update control = noop (2) [exec] = noop (2) attr_filter.accounting_response: EXPAND %{User-Name} (2) attr_filter.accounting_response: --> test@orbit (2) attr_filter.accounting_response: Matched entry DEFAULT at line 12 (2) [attr_filter.accounting_response] = updated (2) } # accounting = updated (2) Sent Accounting-Response Id 34 from 192.168.1.51:2813 to 192.168.1.200:35859 length 0 (2) Finished request (2) Cleaning up request packet ID 34 with timestamp +141 Ready to process requests (3) Received Accounting-Request Id 34 from 192.168.1.200:35859 to 192.168.1.51:2813 length 281 (3) Service-Type = Framed-User (3) Framed-Protocol = PPP (3) NAS-Port = 15728642 (3) NAS-Port-Type = Ethernet (3) User-Name = "test@orbit" (3) Calling-Station-Id = "D8:C4:97:15:C1:F8" (3) Called-Station-Id = "PPPoE" (3) NAS-Port-Id = "LAN" (3) MS-CHAP-Domain = "orbit" (3) Acct-Session-Id = "81600002" (3) Framed-IP-Address = 192.168.10.255 (3) Acct-Authentic = RADIUS (3) Event-Timestamp = "Aug 6 2020 09:21:48 UTC" (3) Acct-Session-Time = 121 (3) Idle-Timeout = 0 (3) Session-Timeout = 0 (3) X-Ascend-Data-Rate = 8196000 (3) Ascend-Xmit-Rate = 8196000 (3) X-Ascend-Data-Rate = 1024000 (3) Ascend-Data-Rate = 1024000 (3) Mikrotik-Rate-Limit = "1024k/8196k" (3) Acct-Input-Octets = 95438 (3) Acct-Input-Gigawords = 0 (3) Acct-Input-Packets = 1165 (3) Acct-Output-Octets = 45977 (3) Acct-Output-Gigawords = 0 (3) Acct-Output-Packets = 113 (3) Acct-Status-Type = Interim-Update (3) NAS-Identifier = "orbitalanya" (3) Acct-Delay-Time = 0 (3) Mikrotik-Realm = "orbit" (3) NAS-IP-Address = 192.168.1.200 (3) # Executing section preacct from file /etc/freeradius/sites-enabled/WISPServer (3) preacct { (3) [preprocess] = ok (3) if (&User-Name) { (3) if (&User-Name) -> TRUE (3) if (&User-Name) { (3) if ("%{WISPSQL:SELECT [dbo].[CheckDisconnectUser]('%{User-Name}', '%{Framed-IP-Address}', '%{Packet-Src-IP-Address}')}" == 1) { rlm_sql (WISPSQL): Reserved connection (8) rlm_sql (WISPSQL): Released connection (8) rlm_sql (WISPSQL): Reserved connection (7) rlm_sql (WISPSQL): Released connection (7) rlm_sql (WISPSQL): Reserved connection (8) rlm_sql (WISPSQL): Released connection (8) (3) EXPAND %{User-Name} (3) --> test@orbit (3) SQL-User-Name set to 'test@orbit' rlm_sql (WISPSQL): Reserved connection (7) (3) Executing select query: SELECT [dbo].[CheckDisconnectUser]('test@orbit', '192.168.10.255', '192.168.1.200') rlm_sql (WISPSQL): Released connection (7) (3) EXPAND %{WISPSQL:SELECT [dbo].[CheckDisconnectUser]('%{User-Name}', '%{Framed-IP-Address}', '%{Packet-Src-IP-Address}')} (3) --> 0 (3) if ("%{WISPSQL:SELECT [dbo].[CheckDisconnectUser]('%{User-Name}', '%{Framed-IP-Address}', '%{Packet-Src-IP-Address}')}" == 1) -> FALSE (3) else { (3) update control { rlm_sql (WISPSQL): Reserved connection (8) rlm_sql (WISPSQL): Released connection (8) (3) EXPAND %{User-Name} (3) --> test@orbit (3) SQL-User-Name set to 'test@orbit' rlm_sql (WISPSQL): Reserved connection (7) (3) Executing select query: SELECT TOP 1 Vendor FROM nas WHERE IPAddress = '192.168.1.200' rlm_sql (WISPSQL): Released connection (7) (3) EXPAND %{WISPSQL: SELECT TOP 1 Vendor FROM nas WHERE IPAddress = '%{Packet-Src-IP-Address}'} (3) --> Mikrotik (3) User-NAS-Vendor = Mikrotik rlm_sql (WISPSQL): Reserved connection (8) rlm_sql (WISPSQL): Released connection (8) (3) EXPAND %{User-Name} (3) --> test@orbit (3) SQL-User-Name set to 'test@orbit' rlm_sql (WISPSQL): Reserved connection (7) (3) Executing select query: SELECT [dbo].[GetUserRateLimit]('test@orbit') rlm_sql (WISPSQL): Released connection (7) (3) EXPAND %{WISPSQL:SELECT [dbo].[GetUserRateLimit]('%{User-Name}')} (3) --> 1024k/8196k (3) User-Rate-Limit = 1024k/8196k (3) } # update control = noop (3) if (&control:User-Rate-Limit && &control:User-Rate-Limit != '') { (3) if (&control:User-Rate-Limit && &control:User-Rate-Limit != '') -> TRUE (3) if (&control:User-Rate-Limit && &control:User-Rate-Limit != '') { (3) switch %{&control:User-NAS-Vendor} { (3) case Mikrotik { (3) if (!&Mikrotik-Rate-Limit || &control:User-Rate-Limit != &Mikrotik-Rate-Limit) { (3) if (!&Mikrotik-Rate-Limit || &control:User-Rate-Limit != &Mikrotik-Rate-Limit) -> FALSE (3) } # case Mikrotik = noop (3) } # switch %{&control:User-NAS-Vendor} = noop (3) } # if (&control:User-Rate-Limit && &control:User-Rate-Limit != '') = noop (3) } # else = noop (3) } # if (&User-Name) = noop (3) policy acct_unique { (3) update request { (3) &Tmp-String-9 := "ai:" (3) } # update request = noop (3) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) { (3) EXPAND %{hex:&Class} (3) --> (3) EXPAND ^%{hex:&Tmp-String-9} (3) --> ^61693a (3) if (("%{hex:&Class}" =~ /^%{hex:&Tmp-String-9}/) && ("%{string:&Class}" =~ /^ai:([0-9a-f]{32})/i)) -> FALSE (3) else { (3) update request { (3) EXPAND %{md5:%{User-Name},%{Acct-Session-ID},%{%{NAS-IPv6-Address}:-%{NAS-IP-Address}},%{NAS-Identifier},%{NAS-Port-ID},%{NAS-Port}} (3) --> 69913b8866eac834270ab589229ef6ab (3) &Acct-Unique-Session-Id := 69913b8866eac834270ab589229ef6ab (3) } # update request = noop (3) } # else = noop (3) } # policy acct_unique = noop (3) } # preacct = ok (3) # Executing section accounting from file /etc/freeradius/sites-enabled/WISPServer (3) accounting { (3) [unix] = noop (3) WISPSQL: EXPAND %{tolower:type.%{%{Acct-Status-Type}:-%{Request-Processing-Stage}}.query} (3) WISPSQL: --> type.interim-update.query (3) WISPSQL: Using query template 'query' rlm_sql (WISPSQL): Reserved connection (8) (3) WISPSQL: EXPAND %{User-Name} (3) WISPSQL: --> test@orbit (3) WISPSQL: SQL-User-Name set to 'test@orbit' (3) WISPSQL: EXPAND UPDATE radacct SET AcctInterval = DATEDIFF(second, AcctUpdateTime, GETDATE()), AcctUpdateTime = GETDATE(), AcctStopTime = NULL, AcctSessionTime = %{%{Acct-Session-Time}:-NULL}, FramedIPAddress = '%{Framed-IP-Address}', AcctInputOctets = convert(bigint, '%{%{Acct-Input-Gigawords}:-0}' * POWER(2.0, 32)) | '%{%{Acct-Input-Octets}:-0}', AcctOutputOctets = convert(bigint, '%{%{Acct-Output-Gigawords}:-0}' * POWER(2.0, 32)) | '%{%{Acct-Output-Octets}:-0}' WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}' (3) WISPSQL: --> UPDATE radacct SET AcctInterval = DATEDIFF(second, AcctUpdateTime, GETDATE()), AcctUpdateTime = GETDATE(), AcctStopTime = NULL, AcctSessionTime = 121, FramedIPAddress = '192.168.10.255', AcctInputOctets = convert(bigint, '0' * POWER(2.0, 32)) | '95438', AcctOutputOctets = convert(bigint, '0' * POWER(2.0, 32)) | '45977' WHERE AcctUniqueId = '69913b8866eac834270ab589229ef6ab' (3) WISPSQL: Executing query: UPDATE radacct SET AcctInterval = DATEDIFF(second, AcctUpdateTime, GETDATE()), AcctUpdateTime = GETDATE(), AcctStopTime = NULL, AcctSessionTime = 121, FramedIPAddress = '192.168.10.255', AcctInputOctets = convert(bigint, '0' * POWER(2.0, 32)) | '95438', AcctOutputOctets = convert(bigint, '0' * POWER(2.0, 32)) | '45977' WHERE AcctUniqueId = '69913b8866eac834270ab589229ef6ab' (3) WISPSQL: SQL query returned: success (3) WISPSQL: -1 record(s) updated (3) WISPSQL: Trying next query... (3) WISPSQL: EXPAND IF NOT EXISTS(SELECT 1 FROM radacct WHERE AcctUniqueId = '%{Acct-Unique-Session-Id}') INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctUpdateTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfoStart, ConnectInfoStop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress) VALUES('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{%{Packet-Src-IP-Address}:-%{NAS-IP-Address}}', '%{%{NAS-Port-Id}:-%{NAS-Port}}', '%{NAS-Port-Type}', DATEADD(second, -1 * (%{%{Acct-Session-Time}:-0}), GETDATE()), GETDATE(), NULL, %{%{Acct-Session-Time}:-NULL}, '%{Acct-Authentic}', '%{Connect-Info}', NULL, convert(bigint, '%{%{Acct-Input-Gigawords}:-0}' * POWER(2.0, 32)) | '%{%{Acct-Input-Octets}:-0}', convert(bigint, '%{%{Acct-Output-Gigawords}:-0}' * POWER(2.0, 32)) | '%{%{Acct-Output-Octets}:-0}', '%{Called-Station-Id}', '%{Calling-Station-Id}', NULL, '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}') (3) WISPSQL: --> IF NOT EXISTS(SELECT 1 FROM radacct WHERE AcctUniqueId = '69913b8866eac834270ab589229ef6ab') INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctUpdateTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfoStart, ConnectInfoStop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress) VALUES('81600002', '69913b8866eac834270ab589229ef6ab', 'test@orbit', '', '192.168.1.200', 'LAN', 'Ethernet', DATEADD(second, -1 * (121), GETDATE()), GETDATE(), NULL, 121, 'RADIUS', '', NULL, convert(bigint, '0' * POWER(2.0, 32)) | '95438', convert(bigint, '0' * POWER(2.0, 32)) | '45977', 'PPPoE', 'D8:C4:97:15:C1:F8', NULL, 'Framed-User', 'PPP', '192.168.10.255') (3) WISPSQL: Executing query: IF NOT EXISTS(SELECT 1 FROM radacct WHERE AcctUniqueId = '69913b8866eac834270ab589229ef6ab') INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctUpdateTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfoStart, ConnectInfoStop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress) VALUES('81600002', '69913b8866eac834270ab589229ef6ab', 'test@orbit', '', '192.168.1.200', 'LAN', 'Ethernet', DATEADD(second, -1 * (121), GETDATE()), GETDATE(), NULL, 121, 'RADIUS', '', NULL, convert(bigint, '0' * POWER(2.0, 32)) | '95438', convert(bigint, '0' * POWER(2.0, 32)) | '45977', 'PPPoE', 'D8:C4:97:15:C1:F8', NULL, 'Framed-User', 'PPP', '192.168.10.255') (3) WISPSQL: SQL query returned: success (3) WISPSQL: -1 record(s) updated (3) WISPSQL: No additional queries configured rlm_sql (WISPSQL): Released connection (8) (3) [WISPSQL] = noop (3) update control { (3) EXPAND %{User-Name} (3) --> test@orbit (3) SQL-User-Name set to 'test@orbit' rlm_sql (WISPSQL): Reserved connection (7) (3) Executing select query: SELECT @@ROWCOUNT rlm_sql (WISPSQL): Released connection (7) (3) EXPAND %{WISPSQL:SELECT @@ROWCOUNT} (3) --> 1 (3) Tmp-Integer-0 = 1 (3) } # update control = noop (3) [exec] = noop (3) attr_filter.accounting_response: EXPAND %{User-Name} (3) attr_filter.accounting_response: --> test@orbit (3) attr_filter.accounting_response: Matched entry DEFAULT at line 12 (3) [attr_filter.accounting_response] = updated (3) } # accounting = updated (3) Sent Accounting-Response Id 34 from 192.168.1.51:2813 to 192.168.1.200:35859 length 0 (3) Finished request (3) Cleaning up request packet ID 34 with timestamp +173 Ready to process requests