radius accounting issue.

Eero Volotinen eero.volotinen at iki.fi
Tue Jan 29 11:26:47 CET 2019


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


More information about the Freeradius-Users mailing list