radius accounting issue.

slnarayanan at nitt.edu slnarayanan at nitt.edu
Wed Jan 30 07:08:56 CET 2019


Hai,

    As per your instruction i have given the details for radiusd -X  
report to this mail as a text

FreeRADIUS Version 3.0.13
Copyright (C) 1999-2017 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/always
including configuration file /etc/raddb/mods-enabled/attr_filter
including configuration file /etc/raddb/mods-enabled/cache_eap
including configuration file /etc/raddb/mods-enabled/chap
including configuration file /etc/raddb/mods-enabled/date
including configuration file /etc/raddb/mods-enabled/detail
including configuration file /etc/raddb/mods-enabled/detail.log
including configuration file /etc/raddb/mods-enabled/dhcp
including configuration file /etc/raddb/mods-enabled/digest
including configuration file /etc/raddb/mods-enabled/dynamic_clients
including configuration file /etc/raddb/mods-enabled/eap
including configuration file /etc/raddb/mods-enabled/echo
including configuration file /etc/raddb/mods-enabled/exec
including configuration file /etc/raddb/mods-enabled/expiration
including configuration file /etc/raddb/mods-enabled/expr
including configuration file /etc/raddb/mods-enabled/files
including configuration file /etc/raddb/mods-enabled/linelog
including configuration file /etc/raddb/mods-enabled/logintime
including configuration file /etc/raddb/mods-enabled/mschap
including configuration file /etc/raddb/mods-enabled/ntlm_auth
including configuration file /etc/raddb/mods-enabled/pap
including configuration file /etc/raddb/mods-enabled/passwd
including configuration file /etc/raddb/mods-enabled/preprocess
including configuration file /etc/raddb/mods-enabled/radutmp
including configuration file /etc/raddb/mods-enabled/realm
including configuration file /etc/raddb/mods-enabled/replicate
including configuration file /etc/raddb/mods-enabled/soh
including configuration file /etc/raddb/mods-enabled/sradutmp
including configuration file /etc/raddb/mods-enabled/unix
including configuration file /etc/raddb/mods-enabled/unpack
including configuration file /etc/raddb/mods-enabled/utf8
including configuration file /etc/raddb/mods-enabled/sql
including configuration file  
/etc/raddb/mods-config/sql/main/mysql/queries.conf
including files in directory /etc/raddb/policy.d/
including configuration file /etc/raddb/policy.d/accounting
including configuration file /etc/raddb/policy.d/canonicalization
including configuration file /etc/raddb/policy.d/control
including configuration file /etc/raddb/policy.d/cui
including configuration file /etc/raddb/policy.d/debug
including configuration file /etc/raddb/policy.d/dhcp
including configuration file /etc/raddb/policy.d/eap
including configuration file /etc/raddb/policy.d/filter
including configuration file /etc/raddb/policy.d/operator-name
including files in directory /etc/raddb/sites-enabled/
including configuration file /etc/raddb/sites-enabled/default
including configuration file /etc/raddb/sites-enabled/inner-tunnel
main {
  security {
  	user = "radiusd"
  	group = "radiusd"
  	allow_core_dumps = no
  }
	name = "radiusd"
	prefix = "/usr"
	localstatedir = "/var"
	logdir = "/var/log/radius"
	run_dir = "/var/run/radiusd"
}
main {
	name = "radiusd"
	prefix = "/usr"
	localstatedir = "/var"
	sbindir = "/usr/sbin"
	logdir = "/var/log/radius"
	run_dir = "/var/run/radiusd"
	libdir = "/usr/lib64/freeradius"
	radacctdir = "/var/log/radius/radacct"
	hostname_lookups = no
	max_request_time = 30
	cleanup_delay = 5
	max_requests = 16384
	pidfile = "/var/run/radiusd/radiusd.pid"
	checkrad = "/usr/sbin/checkrad"
	debug_level = 0
	proxy_requests = no
  log {
  	stripped_names = yes
  	auth = yes
  	auth_badpass = yes
  	auth_goodpass = yes
  	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_pool my_auth_failover {
	type = fail-over
	home_server = localhost
  }
  realm example.com {
	auth_pool = my_auth_failover
  }
  realm LOCAL {
  }
  realm int {
	virtual_server = inner-tunnel
  }
radiusd: #### Loading Clients ####
  client localhost {
  	ipv4addr = *
  	require_message_authenticator = no
  	secret = <<< secret >>>
  	nas_type = "other"
  	proto = "udp"
   limit {
   	max_connections = 16
   	lifetime = 0
   	idle_timeout = 0
   }
  }
Debugger not attached
  # Creating Auth-Type = mschap
  # Creating Auth-Type = eap
  # Creating Auth-Type = NTLMAuth
  # Creating Auth-Type = MS-CHAP
  # Creating Autz-Type = Status-Server
  # Creating Acct-Type = Status-Server
  # Creating Auth-Type = NTLM_AUTH
radiusd: #### Instantiating modules ####
  modules {
   # 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_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_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_chap
   # Loading module "chap" from file /etc/raddb/mods-enabled/chap
   # Loaded module rlm_date
   # Loading module "date" from file /etc/raddb/mods-enabled/date
   date {
   	format = "%b %e %Y %H:%M:%S %Z"
   }
   # Loaded module rlm_detail
   # Loading module "detail" from file /etc/raddb/mods-enabled/detail
   detail {
   	filename =  
"/var/log/radius/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
   }
   # Loading module "auth_log" from file /etc/raddb/mods-enabled/detail.log
   detail auth_log {
   	filename =  
"/var/log/radius/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/raddb/mods-enabled/detail.log
   detail reply_log {
   	filename =  
"/var/log/radius/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/raddb/mods-enabled/detail.log
   detail pre_proxy_log {
   	filename =  
"/var/log/radius/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/raddb/mods-enabled/detail.log
   detail post_proxy_log {
   	filename =  
"/var/log/radius/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_dhcp
   # Loading module "dhcp" from file /etc/raddb/mods-enabled/dhcp
   # Loaded module rlm_digest
   # Loading module "digest" from file /etc/raddb/mods-enabled/digest
   # Loaded module rlm_dynamic_clients
   # Loading module "dynamic_clients" from file  
/etc/raddb/mods-enabled/dynamic_clients
   # Loaded module rlm_eap
   # Loading module "eap" from file /etc/raddb/mods-enabled/eap
   eap {
   	default_eap_type = "peap"
   	timer_expire = 60
   	ignore_unknown_eap_types = no
   	cisco_accounting_username_bug = no
   	max_sessions = 16384
   }
   # Loaded module rlm_exec
   # 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
   }
   # Loading module "exec" from file /etc/raddb/mods-enabled/exec
   exec {
   	wait = no
   	input_pairs = "request"
   	shell_escape = yes
   	timeout = 10
   }
   # Loaded module rlm_expiration
   # Loading module "expiration" from file /etc/raddb/mods-enabled/expiration
   # Loaded module rlm_expr
   # Loading module "expr" from file /etc/raddb/mods-enabled/expr
   expr {
   	safe_characters =  
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_:  
/äéöüàâæçèéêëîïôœùûüaÿÄÉÖÜßÀÂÆÇÈÉÊËÎÏÔŒÙÛÜŸ"
   }
   # Loaded module rlm_files
   # Loading module "files" from file /etc/raddb/mods-enabled/files
   files {
   	filename = "/etc/raddb/mods-config/files/authorize"
   	acctusersfile = "/etc/raddb/mods-config/files/accounting"
   	preproxy_usersfile = "/etc/raddb/mods-config/files/pre-proxy"
   }
   # Loaded module rlm_linelog
   # Loading module "linelog" from file /etc/raddb/mods-enabled/linelog
   linelog {
   	filename = "/var/log/radius/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/raddb/mods-enabled/linelog
   linelog log_accounting {
   	filename = "/var/log/radius/linelog-accounting"
   	escape_filenames = no
   	syslog_severity = "info"
   	permissions = 384
   	format = ""
   	reference = "Accounting-Request.%{%{Acct-Status-Type}:-unknown}"
   }
   # Loaded module rlm_logintime
   # Loading module "logintime" from file /etc/raddb/mods-enabled/logintime
   logintime {
   	minimum_timeout = 60
   }
   # Loaded module rlm_mschap
   # Loading module "mschap" from file /etc/raddb/mods-enabled/mschap
   mschap {
   	use_mppe = yes
   	require_encryption = yes
   	require_strong = yes
   	with_ntdomain_hack = yes
   	ntlm_auth = "/usr/bin/ntlm_auth --request-nt-key  
--username=%{mschap:User-Name:-None}  
--domain=%{%{mschap:NT-Domain}:-OCTA.EDU}  
--challenge=%{mschap:Challenge:-00}  
--nt-response=%{mschap:NT-Response:-00}"
   	ntlm_auth_timeout = 10
    passchange {
    	ntlm_auth = "/usr/bin/ntlm_auth --helper-protocol=ntlm-change-password-1"
    	ntlm_auth_username = "username: %{mschap:User-Name}"
    	ntlm_auth_domain = "nt-domain: %{mschap:NT-Domain}"
    }
   	allow_retry = yes
   	winbind_retry_with_normalised_username = no
   }
   # Loading module "ntlm_auth" from file /etc/raddb/mods-enabled/ntlm_auth
   exec ntlm_auth {
   	wait = yes
   	program = "/usr/bin/ntlm_auth --request-nt-key --domain=OCTA.EDU  
--username=%{mschap:User-Name} --password=%{User-Password}"
   	shell_escape = yes
   }
   # Loaded module rlm_pap
   # Loading module "pap" from file /etc/raddb/mods-enabled/pap
   pap {
   	normalise = yes
   }
   # Loaded module rlm_passwd
   # Loading module "etc_passwd" from file /etc/raddb/mods-enabled/passwd
   passwd etc_passwd {
   	filename = "/etc/passwd"
   	format = "*User-Name:Cleartext-Password:"
   	delimiter = ":"
   	ignore_nislike = no
   	ignore_empty = yes
   	allow_multiple_keys = no
   	hash_size = 100
   }
   # 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_radutmp
   # Loading module "radutmp" from file /etc/raddb/mods-enabled/radutmp
   radutmp {
   	filename = "/var/log/radius/radutmp"
   	username = "%{User-Name}"
   	case_sensitive = no
   	check_with_nas = yes
   	permissions = 384
   	caller_id = yes
   }
   # 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 "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_replicate
   # Loading module "replicate" from file /etc/raddb/mods-enabled/replicate
   # 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/radius/sradutmp"
   	username = "%{User-Name}"
   	case_sensitive = yes
   	check_with_nas = yes
   	permissions = 420
   	caller_id = no
   }
   # Loaded module rlm_unix
   # Loading module "unix" from file /etc/raddb/mods-enabled/unix
   unix {
   	radwtmp = "/var/log/radius/radwtmp"
   }
Creating attribute Unix-Group
   # Loaded module rlm_unpack
   # Loading module "unpack" from file /etc/raddb/mods-enabled/unpack
   # Loaded module rlm_utf8
   # Loading module "utf8" from file /etc/raddb/mods-enabled/utf8
   # Loaded module rlm_sql
   # Loading module "sql" from file /etc/raddb/mods-enabled/sql
   sql {
   	driver = "rlm_sql_mysql"
   	server = "localhost"
   	port = 3306
   	login = "root"
   	password = <<< secret >>>
   	radius_db = "radius"
   	read_groups = yes
   	read_profiles = yes
   	read_clients = yes
   	delete_stale_sessions = yes
   	sql_user_name = "%{User-Name}"
   	logfile = "/var/log/radius/sqllog.sql"
   	default_user_profile = ""
   	client_query = "SELECT id, nasname, shortname, type, secret,  
server FROM nas"
   	authorize_check_query = "SELECT id, username, attribute, value, op  
FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id"
   	authorize_reply_query = "SELECT id, username, attribute, value, op  
FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id"
   	authorize_group_check_query = "SELECT id, groupname, attribute,  
Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY  
id"
   	authorize_group_reply_query = "SELECT id, groupname, attribute,  
value, op FROM radgroupreply WHERE groupname = '%{SQL-Group}' ORDER BY  
id"
   	group_membership_query = "SELECT groupname FROM radusergroup WHERE  
username = '%{SQL-User-Name}' ORDER BY priority"
   	simul_count_query = "SELECT COUNT(*) FROM radacct WHERE username =  
'%{SQL-User-Name}' AND acctstoptime IS NULL"
   	simul_verify_query = "SELECT radacctid, acctsessionid, username,  
nasipaddress, nasportid, framedipaddress, callingstationid,  
framedprotocol FROM radacct WHERE username = '%{SQL-User-Name}' AND  
acctstoptime IS NULL"
   	safe_characters =  
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
    accounting {
    	reference = "%{tolower:type.%{Acct-Status-Type}.query}"
     type {
      accounting-on {
      	query = "UPDATE radacct SET acctstoptime =  
FROM_UNIXTIME(%{integer:Event-Timestamp}), acctsessiontime	=  
'%{integer:Event-Timestamp}' - UNIX_TIMESTAMP(acctstarttime),  
acctterminatecause = '%{%{Acct-Terminate-Cause}:-NAS-Reboot}' WHERE  
acctstoptime IS NULL AND nasipaddress   = '%{NAS-IP-Address}' AND  
acctstarttime <= FROM_UNIXTIME(%{integer:Event-Timestamp})"
      }
      accounting-off {
      	query = "UPDATE radacct SET acctstoptime =  
FROM_UNIXTIME(%{integer:Event-Timestamp}), acctsessiontime	=  
'%{integer:Event-Timestamp}' - UNIX_TIMESTAMP(acctstarttime),  
acctterminatecause = '%{%{Acct-Terminate-Cause}:-NAS-Reboot}' WHERE  
acctstoptime IS NULL AND nasipaddress   = '%{NAS-IP-Address}' AND  
acctstarttime <= FROM_UNIXTIME(%{integer:Event-Timestamp})"
      }
      start {
      	query = "INSERT INTO radacct  
(acctsessionid,		acctuniqueid,		username,  
realm,			nasipaddress,		nasportid,  
nasporttype,		acctstarttime,		acctupdatetime,  
acctstoptime,		acctsessiontime, 	acctauthentic,  
connectinfo_start,	connectinfo_stop, 	acctinputoctets,  
acctoutputoctets,	calledstationid, 	callingstationid,  
acctterminatecause,	servicetype,		framedprotocol, framedipaddress)  
VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}',  
'%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}',  
'%{%{NAS-Port-ID}:-%{NAS-Port}}', '%{NAS-Port-Type}',  
FROM_UNIXTIME(%{integer:Event-Timestamp}),  
FROM_UNIXTIME(%{integer:Event-Timestamp}), NULL, '0',  
'%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0',  
'%{Called-Station-Id}', '%{Calling-Station-Id}', '',  
'%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}')"
      }
      interim-update {
      	query = "UPDATE radacct SET acctupdatetime  =  
(@acctupdatetime_old:=acctupdatetime), acctupdatetime  =  
FROM_UNIXTIME(%{integer:Event-Timestamp}), acctinterval    =  
%{integer:Event-Timestamp} - UNIX_TIMESTAMP(@acctupdatetime_old),  
framedipaddress = '%{Framed-IP-Address}', acctsessiontime =  
%{%{Acct-Session-Time}:-NULL}, acctinputoctets =  
'%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}',  
acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 |  
'%{%{Acct-Output-Octets}:-0}' WHERE AcctUniqueId =  
'%{Acct-Unique-Session-Id}'"
      }
      stop {
      	query = "UPDATE radacct SET acctstoptime	=  
FROM_UNIXTIME(%{integer:Event-Timestamp}), acctsessiontime	=  
%{%{Acct-Session-Time}:-NULL}, acctinputoctets	=  
'%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}',  
acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 |  
'%{%{Acct-Output-Octets}:-0}', acctterminatecause =  
'%{Acct-Terminate-Cause}', connectinfo_stop = '%{Connect-Info}' WHERE  
AcctUniqueId = '%{Acct-Unique-Session-Id}'"
      }
     }
    }
    post-auth {
    	reference = ".query"
    	query = "INSERT INTO radpostauth (username, pass, reply,  
authdate) VALUES ( '%{SQL-User-Name}',  
'%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S')"
    }
   }
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
Creating attribute SQL-Group
   instantiate {
   }
   # 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 "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
[/etc/raddb/mods-config/attr_filter/access_reject]:11 Check item  
"FreeRADIUS-Response-Delay" 	found in filter list for realm "DEFAULT".
[/etc/raddb/mods-config/attr_filter/access_reject]:11 Check item  
"FreeRADIUS-Response-Delay-USec" 	found in filter list for realm  
"DEFAULT".
   # 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 "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 "detail" from file /etc/raddb/mods-enabled/detail
   # 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 "eap" from file /etc/raddb/mods-enabled/eap
    # Linked to sub-module rlm_eap_tls
    tls {
    	tls = "tls-common"
    }
    tls-config tls-common {
    	verify_depth = 0
    	ca_path = "/etc/raddb/certs"
    	pem_file_type = yes
    	private_key_file = "/etc/raddb/certs/server.pem"
    	certificate_file = "/etc/raddb/certs/server.pem"
    	ca_file = "/etc/raddb/certs/ca.pem"
    	private_key_password = <<< secret >>>
    	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"
     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
     }
    }
    # 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 = yes
    	use_tunneled_reply = yes
    	proxy_tunneled_request_as_eap = no
    	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 = yes
    	identity = "FreeRADIUS"
    }
   # Instantiating module "expiration" from file  
/etc/raddb/mods-enabled/expiration
   # Instantiating module "files" from file /etc/raddb/mods-enabled/files
reading pairlist file /etc/raddb/mods-config/files/authorize
reading pairlist file /etc/raddb/mods-config/files/accounting
reading pairlist file /etc/raddb/mods-config/files/pre-proxy
   # Instantiating module "linelog" from file /etc/raddb/mods-enabled/linelog
   # Instantiating module "log_accounting" from file  
/etc/raddb/mods-enabled/linelog
   # Instantiating module "logintime" from file  
/etc/raddb/mods-enabled/logintime
   # Instantiating module "mschap" from file /etc/raddb/mods-enabled/mschap
rlm_mschap (mschap): authenticating by calling 'ntlm_auth'
   # Instantiating module "pap" from file /etc/raddb/mods-enabled/pap
   # Instantiating module "etc_passwd" from file /etc/raddb/mods-enabled/passwd
rlm_passwd: nfields: 3 keyfield 0(User-Name) listable: no
   # 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 "IPASS" from file /etc/raddb/mods-enabled/realm
   # Instantiating module "suffix" 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 "sql" from file /etc/raddb/mods-enabled/sql
rlm_sql_mysql: libmysql version: 10.1.37-MariaDB
    mysql {
     tls {
     }
    	warnings = "auto"
    }
rlm_sql (sql): Attempting to connect to database "radius"
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_mysql: Starting connect to MySQL server
rlm_sql_mysql: Connected to database 'radius' on Localhost via UNIX  
socket, server version 10.1.37-MariaDB, protocol version 10
rlm_sql (sql): Opening additional connection (1), 1 of 31 pending slots used
rlm_sql_mysql: Starting connect to MySQL server
rlm_sql_mysql: Connected to database 'radius' on Localhost via UNIX  
socket, server version 10.1.37-MariaDB, protocol version 10
rlm_sql (sql): Opening additional connection (2), 1 of 30 pending slots used
rlm_sql_mysql: Starting connect to MySQL server
rlm_sql_mysql: Connected to database 'radius' on Localhost via UNIX  
socket, server version 10.1.37-MariaDB, protocol version 10
rlm_sql (sql): Opening additional connection (3), 1 of 29 pending slots used
rlm_sql_mysql: Starting connect to MySQL server
rlm_sql_mysql: Connected to database 'radius' on Localhost via UNIX  
socket, server version 10.1.37-MariaDB, protocol version 10
rlm_sql (sql): Opening additional connection (4), 1 of 28 pending slots used
rlm_sql_mysql: Starting connect to MySQL server
rlm_sql_mysql: Connected to database 'radius' on Localhost via UNIX  
socket, server version 10.1.37-MariaDB, protocol version 10
rlm_sql (sql): Processing generate_sql_clients
rlm_sql (sql) in generate_sql_clients: query is SELECT id, nasname,  
shortname, type, secret, server FROM nas
rlm_sql (sql): Reserved connection (0)
rlm_sql (sql): Executing select query: SELECT id, nasname, shortname,  
type, secret, server FROM nas
rlm_sql (sql): Adding client 10.0.0.38 (domain controller) to global  
clients list
rlm_sql (10.0.0.38): Client "domain controller" (sql) added
rlm_sql (sql): Adding client 10.0.0.39 (domain contr-2) to global clients list
rlm_sql (10.0.0.39): Client "domain contr-2" (sql) added
rlm_sql (sql): Adding client 10.1.172.16 (team2) to global clients list
rlm_sql (10.1.172.16): Client "team2" (sql) added
rlm_sql (sql): Adding client 10.1.172.18 (team4) to global clients list
rlm_sql (10.1.172.18): Client "team4" (sql) added
rlm_sql (sql): Adding client 10.1.172.19 (team5) to global clients list
rlm_sql (10.1.172.19): Client "team5" (sql) added
rlm_sql (sql): Adding client 10.1.172.20 (team6) to global clients list
rlm_sql (10.1.172.20): Client "team6" (sql) added
rlm_sql (sql): Adding client 10.0.0.1 (Local network) to global clients list
rlm_sql (10.0.0.1): Client "Local network" (sql) added
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
rlm_sql_mysql: Starting connect to MySQL server
rlm_sql_mysql: Connected to database 'radius' on Localhost via UNIX  
socket, server version 10.1.37-MariaDB, protocol version 10
  } # modules
radiusd: #### Loading Virtual Servers ####
server { # from file /etc/raddb/radiusd.conf
} # server
server default { # from file /etc/raddb/sites-enabled/default
  # Loading authenticate {...}
  # Loading authorize {...}
Ignoring "ldap" (see raddb/mods-available/README.rst)
  # Loading preacct {...}
  # Loading accounting {...}
} # server default
server inner-tunnel { # from file /etc/raddb/sites-enabled/inner-tunnel
  # Loading authenticate {...}
  # Loading authorize {...}
  # Loading session {...}
  # Loading post-auth {...}
} # server inner-tunnel
radiusd: #### Opening IP addresses and Ports ####
listen {
   	type = "auth"
   	ipaddr = *
   	port = 0
    limit {
    	max_connections = 16
    	lifetime = 0
    	idle_timeout = 0
    }
}
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 = 127.0.0.1
   	port = 18120
}
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 127.0.0.1 port 18120 bound to server inner-tunnel
Ready to process requests


Regards,
S.Lakshmi narayanan

Quoting Eero Volotinen <eero.volotinen at iki.fi>:

> You can really run two instances of radius in same port. stop it first and
> then run with parameter -X
>
> Eero
>
> On Tue, Jan 29, 2019 at 6:09 AM <slnarayanan at nitt.edu> wrote:
>
>> Hi,
>>
>>     As per you instruction i have given the details for radiusd -X
>> report to this mail as a text.
>>
>> FreeRADIUS Version 3.0.13
>> Copyright (C) 1999-2017 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/always
>> including configuration file /etc/raddb/mods-enabled/attr_filter
>> including configuration file /etc/raddb/mods-enabled/cache_eap
>> including configuration file /etc/raddb/mods-enabled/chap
>> including configuration file /etc/raddb/mods-enabled/date
>> including configuration file /etc/raddb/mods-enabled/detail
>> including configuration file /etc/raddb/mods-enabled/detail.log
>> including configuration file /etc/raddb/mods-enabled/dhcp
>> including configuration file /etc/raddb/mods-enabled/digest
>> including configuration file /etc/raddb/mods-enabled/dynamic_clients
>> including configuration file /etc/raddb/mods-enabled/eap
>> including configuration file /etc/raddb/mods-enabled/echo
>> including configuration file /etc/raddb/mods-enabled/exec
>> including configuration file /etc/raddb/mods-enabled/expiration
>> including configuration file /etc/raddb/mods-enabled/expr
>> including configuration file /etc/raddb/mods-enabled/files
>> including configuration file /etc/raddb/mods-enabled/linelog
>> including configuration file /etc/raddb/mods-enabled/logintime
>> including configuration file /etc/raddb/mods-enabled/mschap
>> including configuration file /etc/raddb/mods-enabled/ntlm_auth
>> including configuration file /etc/raddb/mods-enabled/pap
>> including configuration file /etc/raddb/mods-enabled/passwd
>> including configuration file /etc/raddb/mods-enabled/preprocess
>> including configuration file /etc/raddb/mods-enabled/radutmp
>> including configuration file /etc/raddb/mods-enabled/realm
>> including configuration file /etc/raddb/mods-enabled/replicate
>> including configuration file /etc/raddb/mods-enabled/soh
>> including configuration file /etc/raddb/mods-enabled/sradutmp
>> including configuration file /etc/raddb/mods-enabled/unix
>> including configuration file /etc/raddb/mods-enabled/unpack
>> including configuration file /etc/raddb/mods-enabled/utf8
>> including configuration file /etc/raddb/mods-enabled/sql
>> including configuration file
>> /etc/raddb/mods-config/sql/main/mysql/queries.conf
>> including files in directory /etc/raddb/policy.d/
>> including configuration file /etc/raddb/policy.d/accounting
>> including configuration file /etc/raddb/policy.d/canonicalization
>> including configuration file /etc/raddb/policy.d/control
>> including configuration file /etc/raddb/policy.d/cui
>> including configuration file /etc/raddb/policy.d/debug
>> including configuration file /etc/raddb/policy.d/dhcp
>> including configuration file /etc/raddb/policy.d/eap
>> including configuration file /etc/raddb/policy.d/filter
>> including configuration file /etc/raddb/policy.d/operator-name
>> including files in directory /etc/raddb/sites-enabled/
>> including configuration file /etc/raddb/sites-enabled/default
>> including configuration file /etc/raddb/sites-enabled/inner-tunnel
>> main {
>>   security {
>>         user = "radiusd"
>>         group = "radiusd"
>>         allow_core_dumps = no
>>   }
>>         name = "radiusd"
>>         prefix = "/usr"
>>         localstatedir = "/var"
>>         logdir = "/var/log/radius"
>>         run_dir = "/var/run/radiusd"
>> }
>> main {
>>         name = "radiusd"
>>         prefix = "/usr"
>>         localstatedir = "/var"
>>         sbindir = "/usr/sbin"
>>         logdir = "/var/log/radius"
>>         run_dir = "/var/run/radiusd"
>>         libdir = "/usr/lib64/freeradius"
>>         radacctdir = "/var/log/radius/radacct"
>>         hostname_lookups = no
>>         max_request_time = 30
>>         cleanup_delay = 5
>>         max_requests = 16384
>>         pidfile = "/var/run/radiusd/radiusd.pid"
>>         checkrad = "/usr/sbin/checkrad"
>>         debug_level = 0
>>         proxy_requests = no
>>   log {
>>         stripped_names = yes
>>         auth = yes
>>         auth_badpass = yes
>>         auth_goodpass = yes
>>         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_pool my_auth_failover {
>>         type = fail-over
>>         home_server = localhost
>>   }
>>   realm example.com {
>>         auth_pool = my_auth_failover
>>   }
>>   realm LOCAL {
>>   }
>>   realm int {
>>         virtual_server = inner-tunnel
>>   }
>> radiusd: #### Loading Clients ####
>>   client localhost {
>>         ipv4addr = *
>>         require_message_authenticator = no
>>         secret = <<< secret >>>
>>         nas_type = "other"
>>         proto = "udp"
>>    limit {
>>         max_connections = 16
>>         lifetime = 0
>>         idle_timeout = 0
>>    }
>>   }
>> Debugger not attached
>>   # Creating Auth-Type = mschap
>>   # Creating Auth-Type = eap
>>   # Creating Auth-Type = NTLMAuth
>>   # Creating Auth-Type = MS-CHAP
>>   # Creating Autz-Type = Status-Server
>>   # Creating Acct-Type = Status-Server
>>   # Creating Auth-Type = NTLM_AUTH
>> radiusd: #### Instantiating modules ####
>>   modules {
>>    # 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_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_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_chap
>>    # Loading module "chap" from file /etc/raddb/mods-enabled/chap
>>    # Loaded module rlm_date
>>    # Loading module "date" from file /etc/raddb/mods-enabled/date
>>    date {
>>         format = "%b %e %Y %H:%M:%S %Z"
>>    }
>>    # Loaded module rlm_detail
>>    # Loading module "detail" from file /etc/raddb/mods-enabled/detail
>>    detail {
>>         filename =
>>
>> "/var/log/radius/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
>>    }
>>    # Loading module "auth_log" from file /etc/raddb/mods-enabled/detail.log
>>    detail auth_log {
>>         filename =
>>
>> "/var/log/radius/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/raddb/mods-enabled/detail.log
>>    detail reply_log {
>>         filename =
>>
>> "/var/log/radius/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/raddb/mods-enabled/detail.log
>>    detail pre_proxy_log {
>>         filename =
>>
>> "/var/log/radius/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/raddb/mods-enabled/detail.log
>>    detail post_proxy_log {
>>         filename =
>>
>> "/var/log/radius/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_dhcp
>>    # Loading module "dhcp" from file /etc/raddb/mods-enabled/dhcp
>>    # Loaded module rlm_digest
>>    # Loading module "digest" from file /etc/raddb/mods-enabled/digest
>>    # Loaded module rlm_dynamic_clients
>>    # Loading module "dynamic_clients" from file
>> /etc/raddb/mods-enabled/dynamic_clients
>>    # Loaded module rlm_eap
>>    # Loading module "eap" from file /etc/raddb/mods-enabled/eap
>>    eap {
>>         default_eap_type = "peap"
>>         timer_expire = 60
>>         ignore_unknown_eap_types = no
>>         cisco_accounting_username_bug = no
>>         max_sessions = 16384
>>    }
>>    # Loaded module rlm_exec
>>    # 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
>>    }
>>    # Loading module "exec" from file /etc/raddb/mods-enabled/exec
>>    exec {
>>         wait = no
>>         input_pairs = "request"
>>         shell_escape = yes
>>         timeout = 10
>>    }
>>    # Loaded module rlm_expiration
>>    # Loading module "expiration" from file
>> /etc/raddb/mods-enabled/expiration
>>    # Loaded module rlm_expr
>>    # Loading module "expr" from file /etc/raddb/mods-enabled/expr
>>    expr {
>>         safe_characters =
>> "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_:
>> /äéöüàâæçèéêëîïôœùûüaÿÄÉÖÜßÀÂÆÇÈÉÊËÎÏÔŒÙÛÜŸ"
>>    }
>>    # Loaded module rlm_files
>>    # Loading module "files" from file /etc/raddb/mods-enabled/files
>>    files {
>>         filename = "/etc/raddb/mods-config/files/authorize"
>>         acctusersfile = "/etc/raddb/mods-config/files/accounting"
>>         preproxy_usersfile = "/etc/raddb/mods-config/files/pre-proxy"
>>    }
>>    # Loaded module rlm_linelog
>>    # Loading module "linelog" from file /etc/raddb/mods-enabled/linelog
>>    linelog {
>>         filename = "/var/log/radius/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/raddb/mods-enabled/linelog
>>    linelog log_accounting {
>>         filename = "/var/log/radius/linelog-accounting"
>>         escape_filenames = no
>>         syslog_severity = "info"
>>         permissions = 384
>>         format = ""
>>         reference = "Accounting-Request.%{%{Acct-Status-Type}:-unknown}"
>>    }
>>    # Loaded module rlm_logintime
>>    # Loading module "logintime" from file /etc/raddb/mods-enabled/logintime
>>    logintime {
>>         minimum_timeout = 60
>>    }
>>    # Loaded module rlm_mschap
>>    # Loading module "mschap" from file /etc/raddb/mods-enabled/mschap
>>    mschap {
>>         use_mppe = yes
>>         require_encryption = yes
>>         require_strong = yes
>>         with_ntdomain_hack = yes
>>         ntlm_auth = "/usr/bin/ntlm_auth --request-nt-key
>> --username=%{mschap:User-Name:-None}
>> --domain=%{%{mschap:NT-Domain}:-OCTA.EDU}
>> --challenge=%{mschap:Challenge:-00}
>> --nt-response=%{mschap:NT-Response:-00}"
>>         ntlm_auth_timeout = 10
>>     passchange {
>>         ntlm_auth = "/usr/bin/ntlm_auth
>> --helper-protocol=ntlm-change-password-1"
>>         ntlm_auth_username = "username: %{mschap:User-Name}"
>>         ntlm_auth_domain = "nt-domain: %{mschap:NT-Domain}"
>>     }
>>         allow_retry = yes
>>         winbind_retry_with_normalised_username = no
>>    }
>>    # Loading module "ntlm_auth" from file /etc/raddb/mods-enabled/ntlm_auth
>>    exec ntlm_auth {
>>         wait = yes
>>         program = "/usr/bin/ntlm_auth --request-nt-key --domain=OCTA.EDU
>> --username=%{mschap:User-Name} --password=%{User-Password}"
>>         shell_escape = yes
>>    }
>>    # Loaded module rlm_pap
>>    # Loading module "pap" from file /etc/raddb/mods-enabled/pap
>>    pap {
>>         normalise = yes
>>    }
>>    # Loaded module rlm_passwd
>>    # Loading module "etc_passwd" from file /etc/raddb/mods-enabled/passwd
>>    passwd etc_passwd {
>>         filename = "/etc/passwd"
>>         format = "*User-Name:Cleartext-Password:"
>>         delimiter = ":"
>>         ignore_nislike = no
>>         ignore_empty = yes
>>         allow_multiple_keys = no
>>         hash_size = 100
>>    }
>>    # 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_radutmp
>>    # Loading module "radutmp" from file /etc/raddb/mods-enabled/radutmp
>>    radutmp {
>>         filename = "/var/log/radius/radutmp"
>>         username = "%{User-Name}"
>>         case_sensitive = no
>>         check_with_nas = yes
>>         permissions = 384
>>         caller_id = yes
>>    }
>>    # 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 "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_replicate
>>    # Loading module "replicate" from file /etc/raddb/mods-enabled/replicate
>>    # 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/radius/sradutmp"
>>         username = "%{User-Name}"
>>         case_sensitive = yes
>>         check_with_nas = yes
>>         permissions = 420
>>         caller_id = no
>>    }
>>    # Loaded module rlm_unix
>>    # Loading module "unix" from file /etc/raddb/mods-enabled/unix
>>    unix {
>>         radwtmp = "/var/log/radius/radwtmp"
>>    }
>> Creating attribute Unix-Group
>>    # Loaded module rlm_unpack
>>    # Loading module "unpack" from file /etc/raddb/mods-enabled/unpack
>>    # Loaded module rlm_utf8
>>    # Loading module "utf8" from file /etc/raddb/mods-enabled/utf8
>>    # Loaded module rlm_sql
>>    # Loading module "sql" from file /etc/raddb/mods-enabled/sql
>>    sql {
>>         driver = "rlm_sql_mysql"
>>         server = "localhost"
>>         port = 3306
>>         login = "root"
>>         password = <<< secret >>>
>>         radius_db = "radius"
>>         read_groups = yes
>>         read_profiles = yes
>>         read_clients = yes
>>         delete_stale_sessions = yes
>>         sql_user_name = "%{User-Name}"
>>         logfile = "/var/log/radius/sqllog.sql"
>>         default_user_profile = ""
>>         client_query = "SELECT id, nasname, shortname, type, secret,
>> server FROM nas"
>>         authorize_check_query = "SELECT id, username, attribute, value,
>> op
>> FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id"
>>         authorize_reply_query = "SELECT id, username, attribute, value,
>> op
>> FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id"
>>         authorize_group_check_query = "SELECT id, groupname, attribute,
>> Value, op FROM radgroupcheck WHERE groupname = '%{SQL-Group}' ORDER BY
>> id"
>>         authorize_group_reply_query = "SELECT id, groupname, attribute,
>> value, op FROM radgroupreply WHERE groupname = '%{SQL-Group}' ORDER BY
>> id"
>>         group_membership_query = "SELECT groupname FROM radusergroup
>> WHERE
>> username = '%{SQL-User-Name}' ORDER BY priority"
>>         simul_count_query = "SELECT COUNT(*) FROM radacct WHERE username
>> =
>> '%{SQL-User-Name}' AND acctstoptime IS NULL"
>>         simul_verify_query = "SELECT radacctid, acctsessionid, username,
>> nasipaddress, nasportid, framedipaddress, callingstationid,
>> framedprotocol FROM radacct WHERE username = '%{SQL-User-Name}' AND
>> acctstoptime IS NULL"
>>         safe_characters =
>> "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
>>     accounting {
>>         reference = "%{tolower:type.%{Acct-Status-Type}.query}"
>>      type {
>>       accounting-on {
>>         query = "UPDATE radacct SET acctstoptime =
>> FROM_UNIXTIME(%{integer:Event-Timestamp}), acctsessiontime      =
>> '%{integer:Event-Timestamp}' - UNIX_TIMESTAMP(acctstarttime),
>> acctterminatecause = '%{%{Acct-Terminate-Cause}:-NAS-Reboot}' WHERE
>> acctstoptime IS NULL AND nasipaddress   = '%{NAS-IP-Address}' AND
>> acctstarttime <= FROM_UNIXTIME(%{integer:Event-Timestamp})"
>>       }
>>       accounting-off {
>>         query = "UPDATE radacct SET acctstoptime =
>> FROM_UNIXTIME(%{integer:Event-Timestamp}), acctsessiontime      =
>> '%{integer:Event-Timestamp}' - UNIX_TIMESTAMP(acctstarttime),
>> acctterminatecause = '%{%{Acct-Terminate-Cause}:-NAS-Reboot}' WHERE
>> acctstoptime IS NULL AND nasipaddress   = '%{NAS-IP-Address}' AND
>> acctstarttime <= FROM_UNIXTIME(%{integer:Event-Timestamp})"
>>       }
>>       start {
>>         query = "INSERT INTO radacct
>> (acctsessionid,         acctuniqueid,           username,
>> realm,                  nasipaddress,           nasportid,
>> nasporttype,            acctstarttime,          acctupdatetime,
>> acctstoptime,           acctsessiontime,        acctauthentic,
>> connectinfo_start,      connectinfo_stop,       acctinputoctets,
>> acctoutputoctets,       calledstationid,        callingstationid,
>> acctterminatecause,     servicetype,            framedprotocol,
>> framedipaddress)
>> VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}',
>> '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}',
>> '%{%{NAS-Port-ID}:-%{NAS-Port}}', '%{NAS-Port-Type}',
>> FROM_UNIXTIME(%{integer:Event-Timestamp}),
>> FROM_UNIXTIME(%{integer:Event-Timestamp}), NULL, '0',
>> '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0',
>> '%{Called-Station-Id}', '%{Calling-Station-Id}', '',
>> '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}')"
>>       }
>>       interim-update {
>>         query = "UPDATE radacct SET acctupdatetime  =
>> (@acctupdatetime_old:=acctupdatetime), acctupdatetime  =
>> FROM_UNIXTIME(%{integer:Event-Timestamp}), acctinterval    =
>> %{integer:Event-Timestamp} - UNIX_TIMESTAMP(@acctupdatetime_old),
>> framedipaddress = '%{Framed-IP-Address}', acctsessiontime =
>> %{%{Acct-Session-Time}:-NULL}, acctinputoctets =
>> '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}',
>> acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 |
>> '%{%{Acct-Output-Octets}:-0}' WHERE AcctUniqueId =
>> '%{Acct-Unique-Session-Id}'"
>>       }
>>       stop {
>>         query = "UPDATE radacct SET acctstoptime        =
>> FROM_UNIXTIME(%{integer:Event-Timestamp}), acctsessiontime      =
>> %{%{Acct-Session-Time}:-NULL}, acctinputoctets  =
>> '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}',
>> acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 |
>> '%{%{Acct-Output-Octets}:-0}', acctterminatecause =
>> '%{Acct-Terminate-Cause}', connectinfo_stop = '%{Connect-Info}' WHERE
>> AcctUniqueId = '%{Acct-Unique-Session-Id}'"
>>       }
>>      }
>>     }
>>     post-auth {
>>         reference = ".query"
>>         query = "INSERT INTO radpostauth (username, pass, reply,
>> authdate) VALUES ( '%{SQL-User-Name}',
>> '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S')"
>>     }
>>    }
>> rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and
>> linked
>> Creating attribute SQL-Group
>>    instantiate {
>>    }
>>    # 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 "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
>> [/etc/raddb/mods-config/attr_filter/access_reject]:11 Check item
>> "FreeRADIUS-Response-Delay"     found in filter list for realm "DEFAULT".
>> [/etc/raddb/mods-config/attr_filter/access_reject]:11 Check item
>> "FreeRADIUS-Response-Delay-USec"        found in filter list for realm
>> "DEFAULT".
>>    # 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 "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 "detail" from file /etc/raddb/mods-enabled/detail
>>    # 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 "eap" from file /etc/raddb/mods-enabled/eap
>>     # Linked to sub-module rlm_eap_tls
>>     tls {
>>         tls = "tls-common"
>>     }
>>     tls-config tls-common {
>>         verify_depth = 0
>>         ca_path = "/etc/raddb/certs"
>>         pem_file_type = yes
>>         private_key_file = "/etc/raddb/certs/server.pem"
>>         certificate_file = "/etc/raddb/certs/server.pem"
>>         ca_file = "/etc/raddb/certs/ca.pem"
>>         private_key_password = <<< secret >>>
>>         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"
>>      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
>>      }
>>     }
>>     # 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 = yes
>>         use_tunneled_reply = yes
>>         proxy_tunneled_request_as_eap = no
>>         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 = yes
>>         identity = "FreeRADIUS"
>>     }
>>    # Instantiating module "expiration" from file
>> /etc/raddb/mods-enabled/expiration
>>    # Instantiating module "files" from file /etc/raddb/mods-enabled/files
>> reading pairlist file /etc/raddb/mods-config/files/authorize
>> reading pairlist file /etc/raddb/mods-config/files/accounting
>> reading pairlist file /etc/raddb/mods-config/files/pre-proxy
>>    # Instantiating module "linelog" from file
>> /etc/raddb/mods-enabled/linelog
>>    # Instantiating module "log_accounting" from file
>> /etc/raddb/mods-enabled/linelog
>>    # Instantiating module "logintime" from file
>> /etc/raddb/mods-enabled/logintime
>>    # Instantiating module "mschap" from file /etc/raddb/mods-enabled/mschap
>> rlm_mschap (mschap): authenticating by calling 'ntlm_auth'
>>    # Instantiating module "pap" from file /etc/raddb/mods-enabled/pap
>>    # Instantiating module "etc_passwd" from file
>> /etc/raddb/mods-enabled/passwd
>> rlm_passwd: nfields: 3 keyfield 0(User-Name) listable: no
>>    # 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 "IPASS" from file /etc/raddb/mods-enabled/realm
>>    # Instantiating module "suffix" 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 "sql" from file /etc/raddb/mods-enabled/sql
>> rlm_sql_mysql: libmysql version: 10.1.37-MariaDB
>>     mysql {
>>      tls {
>>      }
>>         warnings = "auto"
>>     }
>> rlm_sql (sql): Attempting to connect to database "radius"
>> 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_mysql: Starting connect to MySQL server
>> rlm_sql_mysql: Connected to database 'radius' on Localhost via UNIX
>> socket, server version 10.1.37-MariaDB, protocol version 10
>> rlm_sql (sql): Opening additional connection (1), 1 of 31 pending slots
>> used
>> rlm_sql_mysql: Starting connect to MySQL server
>> rlm_sql_mysql: Connected to database 'radius' on Localhost via UNIX
>> socket, server version 10.1.37-MariaDB, protocol version 10
>> rlm_sql (sql): Opening additional connection (2), 1 of 30 pending slots
>> used
>> rlm_sql_mysql: Starting connect to MySQL server
>> rlm_sql_mysql: Connected to database 'radius' on Localhost via UNIX
>> socket, server version 10.1.37-MariaDB, protocol version 10
>> rlm_sql (sql): Opening additional connection (3), 1 of 29 pending slots
>> used
>> rlm_sql_mysql: Starting connect to MySQL server
>> rlm_sql_mysql: Connected to database 'radius' on Localhost via UNIX
>> socket, server version 10.1.37-MariaDB, protocol version 10
>> rlm_sql (sql): Opening additional connection (4), 1 of 28 pending slots
>> used
>> rlm_sql_mysql: Starting connect to MySQL server
>> rlm_sql_mysql: Connected to database 'radius' on Localhost via UNIX
>> socket, server version 10.1.37-MariaDB, protocol version 10
>> rlm_sql (sql): Processing generate_sql_clients
>> rlm_sql (sql) in generate_sql_clients: query is SELECT id, nasname,
>> shortname, type, secret, server FROM nas
>> rlm_sql (sql): Reserved connection (0)
>> rlm_sql (sql): Executing select query: SELECT id, nasname, shortname,
>> type, secret, server FROM nas
>> rlm_sql (sql): Adding client 10.0.0.38 (domain controller) to global
>> clients list
>> rlm_sql (10.0.0.38): Client "domain controller" (sql) added
>> rlm_sql (sql): Adding client 10.0.0.39 (domain contr-2) to global clients
>> list
>> rlm_sql (10.0.0.39): Client "domain contr-2" (sql) added
>> rlm_sql (sql): Adding client 10.1.172.16 (team2) to global clients list
>> rlm_sql (10.1.172.16): Client "team2" (sql) added
>> rlm_sql (sql): Adding client 10.1.172.18 (team4) to global clients list
>> rlm_sql (10.1.172.18): Client "team4" (sql) added
>> rlm_sql (sql): Adding client 10.1.172.19 (team5) to global clients list
>> rlm_sql (10.1.172.19): Client "team5" (sql) added
>> rlm_sql (sql): Adding client 10.1.172.20 (team6) to global clients list
>> rlm_sql (10.1.172.20): Client "team6" (sql) added
>> rlm_sql (sql): Adding client 10.0.0.1 (Local network) to global clients
>> list
>> rlm_sql (10.0.0.1): Client "Local network" (sql) added
>> 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
>> rlm_sql_mysql: Starting connect to MySQL server
>> rlm_sql_mysql: Connected to database 'radius' on Localhost via UNIX
>> socket, server version 10.1.37-MariaDB, protocol version 10
>>   } # modules
>> radiusd: #### Loading Virtual Servers ####
>> server { # from file /etc/raddb/radiusd.conf
>> } # server
>> server default { # from file /etc/raddb/sites-enabled/default
>>   # Loading authenticate {...}
>>   # Loading authorize {...}
>> Ignoring "ldap" (see raddb/mods-available/README.rst)
>>   # Loading preacct {...}
>>   # Loading accounting {...}
>> } # server default
>> server inner-tunnel { # from file /etc/raddb/sites-enabled/inner-tunnel
>>   # Loading authenticate {...}
>>   # Loading authorize {...}
>>   # Loading session {...}
>>   # Loading post-auth {...}
>> } # server inner-tunnel
>> radiusd: #### Opening IP addresses and Ports ####
>> listen {
>>         type = "auth"
>>         ipaddr = *
>>         port = 0
>>     limit {
>>         max_connections = 16
>>         lifetime = 0
>>         idle_timeout = 0
>>     }
>> Failed binding to auth address * port 1812 bound to server default:
>> Address already in use
>> /etc/raddb/sites-enabled/default[60]: Error binding to port for
>> 0.0.0.0 port 1812
>>
>>
>> Regards,
>> S.Lakshmi narayanan
>> Quoting Alan DeKok <aland at deployingradius.com>:
>>
>> > On Jan 27, 2019, at 11:35 PM, slnarayanan at nitt.edu wrote:
>> >>
>> >>      I have a problem with accounting .Everything is working fine
>> >> on freeradius.Login& authentication sql everything is working
>> >> fine.But i have a problem in accounting pocket.We are using
>> >> sonciwall firwall in our campus.Those who logged through our radius
>> >> server the login information (Radius Accounting) information need
>> >> to display on sonicwall user's page.The UDP pocket 1813 not send to
>> >> our firewall ip.In the firewall
>> >
>> >   Then fix that.  This isn't a RADIUS problem.  It's a network
>> > problem.  No amount of poking FreeRADIUS will fix the firewall.
>> >
>> >> i have enable policy allow to all our local network.I have attached
>> >> my radiususd -X log to this mail.
>> >
>> >   Which doesn't show anything useful.
>> >
>> >> Kindly provide the solution for resolve my issue.The Radius
>> >> Accounting information now shows on radacct in the phpmyadmin.
>> >>
>> >> Regards.
>> >> S.Lakshmi narayanan
>> >>
>> >> <28012019.txt>-
>> >
>> >   Add the debug output as text.  Don't add an attachment.
>> >
>> > http://wiki.freeradius.org/list-help
>> >
>> >   Alan DeKok.
>> >
>> >
>> > -
>> > List info/subscribe/unsubscribe? See
>> > http://www.freeradius.org/list/users.html
>>
>>
>>
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
> -
> List info/subscribe/unsubscribe? See  
> http://www.freeradius.org/list/users.html





More information about the Freeradius-Users mailing list