Impossible de créer un compte utilisateur, croix rouge dans Daloradius

[indian65]

Actual behavior

{Please write here}

Expected behavior

Impossible de créer un user, croix rouge systématiquement, quelque soit le type d'identification, idem avec un user créer en ligne de commande Les services freeradius fonctionnent. Là, je sèche. {Please write here}

Configuration parameters (if changed in the script)

Script installé sans modification {Please write here}

Logs

info: Dropping packet without response because of error. Receveid Accounting request packet ffrom client 127.0.0.1 with invalid request authenticator ( shared secret is incorrect)

// write log messages here, if possible
// like output of the script or system messages
// The more information you provide, the best answer you will get

Your environment

• Hardware : Raspberry pi 3 b+
• Operating system: Raspbian stretch

Additional comments

{Please write here, if there is something more to tell}

[pihomeserver]

Hello First be sure that the value of HS_RADSECRET in /etc/chilli/config is the same than secret in /etc/freeradius/3.0/clients.conf (2 values should be uncomment) Then stop freeradius service, start freeradius in debug mode and run the radtest command to check that all is running fine (look for an example here https://github.com/pihomeserver/Kupiki-Hotspot-Script/issues/10#issuecomment-262168674)

[indian65]

The two values are differents, i change for the same key, (the key of freeradius) but when i test a new user I have that pi@kupikihotspot:~ $ echo "insert into radcheck (username, attribute, op, value) values ('usertest', 'Cleartext-Password', ':=', 'passwd');" | mysql -u root -praspbian radius ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[pihomeserver]

Password for the db is wrong. Check the value in the script and replace raspbian with the correct one. Should be pihotspot by default

[indian65]

The same pi@kupikihotspot:~ $ echo "insert into radcheck (username, attribute, op, value) values ('usertest', 'Cleartext-Password', ':=', 'passwd');" | mysql -u root -pihotspot radius ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) I change nothing in the script, it's crazy!

[pihomeserver]

You forget the p before the password ! It’s -ppihotspot

[indian65]

Ok, I'm stupid I'm create a new user but when i test ,no accept/accept sudo radtest usertest passwd localhost 0 testing123 (0) Received Access-Request Id 89 from 127.0.0.1:42248 to 127.0.0.1:1812 length 78 Dropping packet without response because of error: Received packet from 127.0.0.1 with invalid Message-Authenticator! (Shared secret is incorrect.) Waking up in 0.3 seconds. (0) Cleaning up request packet ID 89 with timestamp +303 Ready to process requests (1) Received Access-Request Id 89 from 127.0.0.1:42248 to 127.0.0.1:1812 length 78 Dropping packet without response because of error: Received packet from 127.0.0.1 with invalid Message-Authenticator! (Shared secret is incorrect.) Waking up in 0.3 seconds. (1) Cleaning up request packet ID 89 with timestamp +308 Ready to process requests (2) Received Access-Request Id 89 from 127.0.0.1:42248 to 127.0.0.1:1812 length 78 Dropping packet without response because of error: Received packet from 127.0.0.1 with invalid Message-Authenticator! (Shared secret is incorrect.) Waking up in 0.3 seconds. (2) Cleaning up request packet ID 89 with timestamp +313 Ready to process requests

[pihomeserver]

That’s normal you use testing123 as the secret key instead of the real one.

[indian65]

It's work, When i create a new user by step, it's no recognize but when i use quick add user option, it's work. Thank's for your quickly responses. Merci beaucoup pour votre réactivité.

[pihomeserver]

I guess there is something wrong in the way you try to create the user. Often the problem is in the attribute creation to add a check for the password

[indian65]

I bought a new sd, I try a clean installation this afternoon and modifying some lines of the script (adding the driver of my external wifi antenna).

[pihomeserver]

The installation is not related to the way the users are created. All is handle by Daloradius. Once the user is created, be sure that in the radius database you have something like bellow

[indian65]

1/I tried with my antenna, the driver is recognized and the antenna activated (LED lit) but no visible wifi network. 2/ for the radius database, is it possible to give me the path of the file, I am a noob.

[pihomeserver]

If you are not with little linux experience it will be difficult to achieve your goal For the antena did you updated the script with the new interface ? About the database it’s not a file but a database in the mariadb instance. Look at google about a GUI tool for your OS to connect to your instance (after allowing remote root access)

[indian65]

For the antenna, I changed the two values LAN_INTERFACE: wlan1 LAN_WIFI_DRIVER:ath9k_htc (atheros 9271) Maybe I'm forgetting something

[pihomeserver]

If your antenna is up and running on wlan1 no it should be ok. Are you sure that the wifi key could work as an access point ?

[indian65]

iw list Wiphy phy1 max # scan SSIDs: 4 max scan IEs length: 2257 bytes max # sched scan SSIDs: 0 max # match sets: 0 max # scan plans: 1 max scan plan interval: -1 max scan plan iterations: 0 Retry short limit: 7 Retry long limit: 4 Coverage class: 0 (up to 0m) Device supports RSN-IBSS. Device supports T-DLS. Supported Ciphers:

• WEP40 (00-0f-ac:1)
• WEP104 (00-0f-ac:5)
• TKIP (00-0f-ac:2)
• CCMP-128 (00-0f-ac:4)
• CCMP-256 (00-0f-ac:10)
• GCMP-128 (00-0f-ac:8)
• GCMP-256 (00-0f-ac:9)
• CMAC (00-0f-ac:6)
• CMAC-256 (00-0f-ac:13)
• GMAC-128 (00-0f-ac:11)
• GMAC-256 (00-0f-ac:12) Available Antennas: TX 0x1 RX 0x1 Configured Antennas: TX 0x1 RX 0x1 Supported interface modes:
  • IBSS
  • managed
  • AP
  • AP/VLAN
  • monitor
  • mesh point
  • P2P-client
  • P2P-GO
  • outside context of a BSS Band 1: Capabilities: 0x116e HT20/HT40 SM Power Save disabled RX HT20 SGI RX HT40 SGI RX STBC 1-stream Max AMSDU length: 3839 bytes DSSS/CCK HT40 Maximum RX AMPDU length 65535 bytes (exponent: 0x003) Minimum RX AMPDU time spacing: 8 usec (0x06) HT TX/RX MCS rate indexes supported: 0-7 Bitrates (non-HT):
    • 1.0 Mbps
    • 2.0 Mbps (short preamble supported)
    • 5.5 Mbps (short preamble supported)
    • 11.0 Mbps (short preamble supported)
    • 6.0 Mbps
    • 9.0 Mbps
    • 12.0 Mbps
    • 18.0 Mbps
    • 24.0 Mbps
    • 36.0 Mbps
    • 48.0 Mbps
    • 54.0 Mbps Frequencies:
    • 2412 MHz [1] (20.0 dBm)
    • 2417 MHz [2] (20.0 dBm)
    • 2422 MHz [3] (20.0 dBm)
    • 2427 MHz [4] (20.0 dBm)
    • 2432 MHz [5] (20.0 dBm)
    • 2437 MHz [6] (20.0 dBm)
    • 2442 MHz [7] (20.0 dBm)
    • 2447 MHz [8] (20.0 dBm)
    • 2452 MHz [9] (20.0 dBm)
    • 2457 MHz [10] (20.0 dBm)
    • 2462 MHz [11] (20.0 dBm)
    • 2467 MHz [12] (20.0 dBm)
    • 2472 MHz [13] (20.0 dBm)
    • 2484 MHz [14] (disabled) Supported commands:
  • new_interface
  • set_interface
  • new_key
  • start_ap
  • new_station
  • new_mpath
  • set_mesh_config
  • set_bss
  • authenticate
  • associate
  • deauthenticate
  • disassociate
  • join_ibss
  • join_mesh
  • remain_on_channel
  • set_tx_bitrate_mask
  • frame
  • frame_wait_cancel
  • set_wiphy_netns
  • set_channel
  • set_wds_peer
  • tdls_mgmt
  • tdls_oper
  • probe_client
  • set_noack_map
  • register_beacons
  • start_p2p_device
  • set_mcast_rate
  • connect
  • disconnect
  • channel_switch
  • set_qos_map
  • Unknown command (121) Supported TX frame types:
  • IBSS: 0x00 0x10 0x20 0x30 0x40 0x50 0x60 0x70 0x80 0x90 0xa0 0xb0 0xc0 0xd0 0xe0 0xf0
  • managed: 0x00 0x10 0x20 0x30 0x40 0x50 0x60 0x70 0x80 0x90 0xa0 0xb0 0xc0 0xd0 0xe0 0xf0
  • AP: 0x00 0x10 0x20 0x30 0x40 0x50 0x60 0x70 0x80 0x90 0xa0 0xb0 0xc0 0xd0 0xe0 0xf0
  • AP/VLAN: 0x00 0x10 0x20 0x30 0x40 0x50 0x60 0x70 0x80 0x90 0xa0 0xb0 0xc0 0xd0 0xe0 0xf0
  • mesh point: 0x00 0x10 0x20 0x30 0x40 0x50 0x60 0x70 0x80 0x90 0xa0 0xb0 0xc0 0xd0 0xe0 0xf0
  • P2P-client: 0x00 0x10 0x20 0x30 0x40 0x50 0x60 0x70 0x80 0x90 0xa0 0xb0 0xc0 0xd0 0xe0 0xf0
  • P2P-GO: 0x00 0x10 0x20 0x30 0x40 0x50 0x60 0x70 0x80 0x90 0xa0 0xb0 0xc0 0xd0 0xe0 0xf0
  • P2P-device: 0x00 0x10 0x20 0x30 0x40 0x50 0x60 0x70 0x80 0x90 0xa0 0xb0 0xc0 0xd0 0xe0 0xf0 Supported RX frame types:
  • IBSS: 0x40 0xb0 0xc0 0xd0
  • managed: 0x40 0xd0
  • AP: 0x00 0x20 0x40 0xa0 0xb0 0xc0 0xd0
  • AP/VLAN: 0x00 0x20 0x40 0xa0 0xb0 0xc0 0xd0
  • mesh point: 0xb0 0xc0 0xd0
  • P2P-client: 0x40 0xd0
  • P2P-GO: 0x00 0x20 0x40 0xa0 0xb0 0xc0 0xd0
  • P2P-device: 0x40 0xd0 software interface modes (can always be added):
  • AP/VLAN
  • monitor valid interface combinations:

  • { managed, P2P-client } <= 2, #{ AP, mesh point, P2P-GO } <= 2,

    total <= 2, #channels <= 1 HT Capability overrides:

  • MCS: ff ff ff ff ff ff ff ff ff ff
  • maximum A-MSDU length
  • supported channel width
  • short GI for 40 MHz
  • max A-MPDU length exponent
  • min MPDU start spacing Device supports TX status socket option. Device supports HT-IBSS. Device supports SAE with AUTHENTICATE command Device supports low priority scan. Device supports scan flush. Device supports AP scan. Device supports per-vif TX power setting Driver supports full state transitions for AP/GO clients Driver supports a userspace MPM Device supports configuring vdev MAC-addr on create. Wiphy phy0 max # scan SSIDs: 10 max scan IEs length: 2048 bytes max # sched scan SSIDs: 16 max # match sets: 16 max # scan plans: 1 max scan plan interval: 508 max scan plan iterations: 0 Retry short limit: 7 Retry long limit: 4 Coverage class: 0 (up to 0m) Supported Ciphers:
• WEP40 (00-0f-ac:1)
• WEP104 (00-0f-ac:5)
• TKIP (00-0f-ac:2)
• CCMP-128 (00-0f-ac:4) Available Antennas: TX 0 RX 0 Supported interface modes:
  • IBSS
  • managed
  • AP
  • P2P-client
  • P2P-GO
  • P2P-device Band 1: Capabilities: 0x1020 HT20 Static SM Power Save RX HT20 SGI No RX STBC Max AMSDU length: 3839 bytes DSSS/CCK HT40 Maximum RX AMPDU length 65535 bytes (exponent: 0x003) Minimum RX AMPDU time spacing: 16 usec (0x07) HT TX/RX MCS rate indexes supported: 0-7 Bitrates (non-HT):
    • 1.0 Mbps
    • 2.0 Mbps (short preamble supported)
    • 5.5 Mbps (short preamble supported)
    • 11.0 Mbps (short preamble supported)
    • 6.0 Mbps
    • 9.0 Mbps
    • 12.0 Mbps
    • 18.0 Mbps
    • 24.0 Mbps
    • 36.0 Mbps
    • 48.0 Mbps
    • 54.0 Mbps Frequencies:
    • 2412 MHz [1] (20.0 dBm)
    • 2417 MHz [2] (20.0 dBm)
    • 2422 MHz [3] (20.0 dBm)
    • 2427 MHz [4] (20.0 dBm)
    • 2432 MHz [5] (20.0 dBm)
    • 2437 MHz [6] (20.0 dBm)
    • 2442 MHz [7] (20.0 dBm)
    • 2447 MHz [8] (20.0 dBm)
    • 2452 MHz [9] (20.0 dBm)
    • 2457 MHz [10] (20.0 dBm)
    • 2462 MHz [11] (20.0 dBm)
    • 2467 MHz [12] (20.0 dBm)
    • 2472 MHz [13] (20.0 dBm)
    • 2484 MHz [14] (disabled) Supported commands:
  • new_interface
  • set_interface
  • new_key
  • start_ap
  • join_ibss
  • set_pmksa
  • del_pmksa
  • flush_pmksa
  • remain_on_channel
  • frame
  • set_wiphy_netns
  • set_channel
  • start_sched_scan
  • start_p2p_device
  • connect
  • disconnect
  • crit_protocol_start
  • crit_protocol_stop
  • Unknown command (122) Supported TX frame types:
  • managed: 0x00 0x10 0x20 0x30 0x40 0x50 0x60 0x70 0x80 0x90 0xa0 0xb0 0xc0 0xd0 0xe0 0xf0
  • P2P-client: 0x00 0x10 0x20 0x30 0x40 0x50 0x60 0x70 0x80 0x90 0xa0 0xb0 0xc0 0xd0 0xe0 0xf0
  • P2P-GO: 0x00 0x10 0x20 0x30 0x40 0x50 0x60 0x70 0x80 0x90 0xa0 0xb0 0xc0 0xd0 0xe0 0xf0
  • P2P-device: 0x00 0x10 0x20 0x30 0x40 0x50 0x60 0x70 0x80 0x90 0xa0 0xb0 0xc0 0xd0 0xe0 0xf0 Supported RX frame types:
  • managed: 0x40 0xd0
  • P2P-client: 0x40 0xd0
  • P2P-GO: 0x00 0x20 0x40 0xa0 0xb0 0xc0 0xd0
  • P2P-device: 0x40 0xd0 software interface modes (can always be added): valid interface combinations:

  • { managed } <= 1, #{ P2P-device } <= 1, #{ P2P-client, P2P-GO } <= 1,

    total <= 3, #channels <= 2

  • { managed } <= 1, #{ AP } <= 1, #{ P2P-client } <= 1, #{ P2P-device } <= 1,

    total <= 4, #channels <= 1 Device supports scan flush. pi@raspberrypi:~ $ `

[pihomeserver]

Seems to support AP. To check on the web if hostapd can handle the hardware as it’s it who expose the SSID

[indian65]

I found, the antenna works with the generic driver, I reconfigured the hostapd.conf file, reboot and my network is visible and functional. the key was this page http://benoit.ofoofo.net/2012/07/21/hostapd-configuration-for-a-802-11n-ap-with-ath9k/

[indian65]

A new issue when i want to create a new user FreeRADIUS Version 3.0.12 Copyright (C) 1999-2016 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 configuration file /etc/freeradius/3.0/radiusd.conf Unable to open file "/etc/freeradius/3.0/radiusd.conf": Permission denied Errors reading or parsing /etc/freeradius/3.0/radiusd.conf

[pihomeserver]

Look at the error message, i guess that you are not running the command as root. It should be better to learn about user creation in daloradius to avoid the use of root

[indian65]

I test in root no problème with freeradius, when i test a new user with daloradius, acces-accept, but when i tried to connect with the new user, i have password or login incorrect

[indian65]

I create a new user, and test Executed: echo User-Name='condorinette',User-Password='condorinette' | radclient -c '1' -n '3' -r '3' -t '3' -x '127.0.0.1:1812' 'auth' 'PrUHmdaHkHFDCxmT85RPWlKoHyuQWOXm' 2>&1

Results: Sent Access-Request Id 235 from 0.0.0.0:46805 to 127.0.0.1:1812 length 52 User-Name = "condorinette" User-Password = "condorinette" Cleartext-Password = "condorinette" Received Access-Accept Id 235 from 127.0.0.1:1812 to 0.0.0.0:0 length 20

but when i want to connect with this user

[pihomeserver]

Stop freeradius service and start freeradius in debug mode. You will see the error message. Pretty sure the secret key is the issue

[indian65]

The secret key are the same in the two folders When i start freeradius in debug mode

'%{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

Loaded module rlm_logintime

Loading module "logintime" from file /etc/freeradius/3.0/mods-enabled/logintime

logintime { minimum_timeout = 60 }

Loaded module rlm_exec

Loading module "exec" from file /etc/freeradius/3.0/mods-enabled/exec

exec { wait = no input_pairs = "request" shell_escape = yes timeout = 10 }

Loaded module rlm_files

Loading module "files" from file /etc/freeradius/3.0/mods-enabled/files

files { filename = "/etc/freeradius/3.0/mods-config/files/authorize" acctusersfile = "/etc/freeradius/3.0/mods-config/files/accounting" preproxy_usersfile = "/etc/freeradius/3.0/mods-config/files/pre-proxy" }

Loaded module rlm_linelog

Loading module "linelog" from file /etc/freeradius/3.0/mods-enabled/linelog

linelog { filename = "/var/log/freeradius/linelog" escape_filenames = no syslog_severity = "info" permissions = 384 format = "This is a log message for %{User-Name}" reference = "messages.%{%{reply:Packet-Type}:-default}" }

Loading module "log_accounting" from file /etc/freeradius/3.0/mods-enabled/linelog

linelog log_accounting { filename = "/var/log/freeradius/linelog-accounting" escape_filenames = no syslog_severity = "info" permissions = 384 format = "" reference = "Accounting-Request.%{%{Acct-Status-Type}:-unknown}" }

Loaded module rlm_chap

Loading module "chap" from file /etc/freeradius/3.0/mods-enabled/chap

Loaded module rlm_pap

Loading module "pap" from file /etc/freeradius/3.0/mods-enabled/pap

pap { normalise = yes }

Loaded module rlm_realm

Loading module "IPASS" from file /etc/freeradius/3.0/mods-enabled/realm

realm IPASS { format = "prefix" delimiter = "/" ignore_default = no ignore_null = no }

Loading module "suffix" from file /etc/freeradius/3.0/mods-enabled/realm

realm suffix { format = "suffix" delimiter = "@" ignore_default = no ignore_null = no }

Loading module "realmpercent" from file /etc/freeradius/3.0/mods-enabled/realm

realm realmpercent { format = "suffix" delimiter = "%" ignore_default = no ignore_null = no }

Loading module "ntdomain" from file /etc/freeradius/3.0/mods-enabled/realm

realm ntdomain { format = "prefix" delimiter = "\" ignore_default = no ignore_null = no }

Loaded module rlm_unpack

Loading module "unpack" from file /etc/freeradius/3.0/mods-enabled/unpack

Loading module "ntlm_auth" from file /etc/freeradius/3.0/mods-enabled/ntlm_auth

exec ntlm_auth { wait = yes program = "/path/to/ntlm_auth --request-nt-key --domain=MYDOMAIN --username=%{mschap:User-Name} --password=%{User-Password}" shell_escape = yes }

Loaded module rlm_replicate

Loading module "replicate" from file /etc/freeradius/3.0/mods-enabled/replicate

Loaded module rlm_cache

Loading module "cache_eap" from file /etc/freeradius/3.0/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_attr_filter

Loading module "attr_filter.post-proxy" from file /etc/freeradius/3.0/mods-enabled/attr_filter

attr_filter attr_filter.post-proxy { filename = "/etc/freeradius/3.0/mods-config/attr_filter/post-proxy" key = "%{Realm}" relaxed = no }

Loading module "attr_filter.pre-proxy" from file /etc/freeradius/3.0/mods-enabled/attr_filter

attr_filter attr_filter.pre-proxy { filename = "/etc/freeradius/3.0/mods-config/attr_filter/pre-proxy" key = "%{Realm}" relaxed = no }

Loading module "attr_filter.access_reject" from file /etc/freeradius/3.0/mods-enabled/attr_filter

attr_filter attr_filter.access_reject { filename = "/etc/freeradius/3.0/mods-config/attr_filter/access_reject" key = "%{User-Name}" relaxed = no }

Loading module "attr_filter.access_challenge" from file /etc/freeradius/3.0/mods-enabled/attr_filter

attr_filter attr_filter.access_challenge { filename = "/etc/freeradius/3.0/mods-config/attr_filter/access_challenge" key = "%{User-Name}" relaxed = no }

Loading module "attr_filter.accounting_response" from file /etc/freeradius/3.0/mods-enabled/attr_filter

attr_filter attr_filter.accounting_response { filename = "/etc/freeradius/3.0/mods-config/attr_filter/accounting_response" key = "%{User-Name}" relaxed = no }

Loaded module rlm_expiration

Loading module "expiration" from file /etc/freeradius/3.0/mods-enabled/expiration

Loading module "sradutmp" from file /etc/freeradius/3.0/mods-enabled/sradutmp

radutmp sradutmp { filename = "/var/log/freeradius/sradutmp" username = "%{User-Name}" case_sensitive = yes check_with_nas = yes permissions = 420 caller_id = no }

Loaded module rlm_digest

Loading module "digest" from file /etc/freeradius/3.0/mods-enabled/digest

Loaded module rlm_mschap

Loading module "mschap" from file /etc/freeradius/3.0/mods-enabled/mschap

mschap { use_mppe = yes require_encryption = no require_strong = no with_ntdomain_hack = yes passchange { } allow_retry = yes }

Loaded module rlm_detail

Loading module "auth_log" from file /etc/freeradius/3.0/mods-enabled/detail.log

detail auth_log { filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/auth-detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no }

Loading module "reply_log" from file /etc/freeradius/3.0/mods-enabled/detail.log

detail reply_log { filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/reply-detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no }

Loading module "pre_proxy_log" from file /etc/freeradius/3.0/mods-enabled/detail.log

detail pre_proxy_log { filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/pre-proxy-detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no }

Loading module "post_proxy_log" from file /etc/freeradius/3.0/mods-enabled/detail.log

detail post_proxy_log { filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/post-proxy-detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no }

Loaded module rlm_unix

Loading module "unix" from file /etc/freeradius/3.0/mods-enabled/unix

unix { radwtmp = "/var/log/freeradius/radwtmp" } Creating attribute Unix-Group

Loaded module rlm_sqlcounter

Loading module "dailycounter" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter dailycounter { sql_module_instance = "sql" key = "User-Name" query = "SELECT SUM(acctsessiontime - GREATEST((%%b - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username = '%{User-Name}' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '%%b'" reset = "daily" counter_name = "Daily-Session-Time" check_name = "Max-Daily-Session" reply_name = "Session-Timeout" }

Loading module "weeklycounter" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter weeklycounter { sql_module_instance = "sql" key = "User-Name" query = "SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='%{User-Name}'" reset = "weekly" counter_name = "Weekly-Session-Time" check_name = "Max-Weekly-Session" reply_name = "Session-Timeout" }

Loading module "monthlycounter" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter monthlycounter { sql_module_instance = "sql" key = "User-Name" query = "SELECT SUM(acctsessiontime - GREATEST((%%b - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username='%{User-Name}' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '%%b'" reset = "monthly" counter_name = "Monthly-Session-Time" check_name = "Max-Monthly-Session" reply_name = "Session-Timeout" }

Loading module "quaterlycounter" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter quaterlycounter { sql_module_instance = "sql" key = "User-Name" query = "SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='%{User-Name}'" reset = "3m" counter_name = "Quaterly-Session-Time" check_name = "Max-Quaterly-Session" reply_name = "Session-Timeout" }

Loading module "yearlycounter" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter yearlycounter { sql_module_instance = "sql" key = "User-Name" query = "SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='%{User-Name}'" reset = "12m" counter_name = "Yearly-Session-Time" check_name = "Max-Yearly-Session" reply_name = "Session-Timeout" }

Loading module "noresetcounter" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter noresetcounter { sql_module_instance = "sql" key = "User-Name" query = "SELECT IFNULL(SUM(AcctSessionTime),0) FROM radacct WHERE UserName='%{User-Name}'" reset = "never" counter_name = "Max-All-Session-Time" check_name = "Max-All-Session" reply_name = "Session-Timeout" }

Loading module "expire_on_login" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter expire_on_login { sql_module_instance = "sql" key = "User-Name" query = "SELECT IFNULL( MAX(TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime))),0) FROM radacct WHERE UserName='%{User-Name}' ORDER BY acctstarttime LIMIT 1;" reset = "never" counter_name = "Expire-After-Initial-Login" check_name = "Expire-After" reply_name = "Session-Timeout" }

Loading module "counterChilliSpotMaxTotalOctetsDaily" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter counterChilliSpotMaxTotalOctetsDaily { sql_module_instance = "sql" key = "User-Name" query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'" reset = "daily" counter_name = "ChilliSpot-Max-Total-Octets-Daily" check_name = "CS-Total-Octets-Daily" reply_name = "ChilliSpot-Max-Total-Octets" }

Loading module "counterChilliSpotMaxTotalOctetsWeekly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter counterChilliSpotMaxTotalOctetsWeekly { sql_module_instance = "sql" key = "User-Name" query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'" reset = "weekly" counter_name = "ChilliSpot-Max-Total-Octets-Weekly" check_name = "CS-Total-Octets-Weekly" reply_name = "ChilliSpot-Max-Total-Octets" }

Loading module "counterChilliSpotMaxTotalOctetsMonthly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter counterChilliSpotMaxTotalOctetsMonthly { sql_module_instance = "sql" key = "User-Name" query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0)FROM radacct WHERE UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'" reset = "monthly" counter_name = "ChilliSpot-Max-Total-Octets-Monthly" check_name = "CS-Total-Octets-Monthly" reply_name = "ChilliSpot-Max-Total-Octets" }

Loading module "counterChilliSpotMaxTotalOctetsQuarterly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter counterChilliSpotMaxTotalOctetsQuarterly { sql_module_instance = "sql" key = "User-Name" query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'" reset = "3m" counter_name = "ChilliSpot-Max-Total-Octets-Quarterly" check_name = "CS-Total-Octets-Quarterly" reply_name = "ChilliSpot-Max-Total-Octets" }

Loading module "counterChilliSpotMaxTotalOctetsYearly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter counterChilliSpotMaxTotalOctetsYearly { sql_module_instance = "sql" key = "User-Name" query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'" reset = "12m" counter_name = "ChilliSpot-Max-Total-Octets-Yearly" check_name = "CS-Total-Octets-Yearly" reply_name = "ChilliSpot-Max-Total-Octets" }

Loading module "counterChilliSpotMaxInputOctetsDaily" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter counterChilliSpotMaxInputOctetsDaily { sql_module_instance = "sql" key = "User-Name" query = "SELECT IFNULL(SUM(AcctInputOctets),0) FROM radacct WHERE UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'" reset = "daily" counter_name = "ChilliSpot-Max-Input-Octets-Daily" check_name = "CS-Input-Octets-Daily" reply_name = "ChilliSpot-Max-Input-Octets" }

Loading module "counterChilliSpotMaxInputOctetsWeekly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter counterChilliSpotMaxInputOctetsWeekly { sql_module_instance = "sql" key = "User-Name" query = "SELECT IFNULL(SUM(AcctInputOctets),0) FROM radacct WHERE UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'" reset = "weekly" counter_name = "ChilliSpot-Max-Input-Octets-Weekly" check_name = "CS-Input-Octets-Weekly" reply_name = "ChilliSpot-Max-Input-Octets" }

Loading module "counterChilliSpotMaxInputOctetsMonthly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter counterChilliSpotMaxInputOctetsMonthly { sql_module_instance = "sql" key = "User-Name" query = "SELECT IFNULL(SUM(AcctInputOctets),0) FROM radacct WHERE UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'" reset = "monthly" counter_name = "ChilliSpot-Max-Input-Octets-Monthly" check_name = "CS-Input-Octets-Monthly" reply_name = "ChilliSpot-Max-Input-Octets" }

Loading module "counterChilliSpotMaxInputOctetsQuarterly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter counterChilliSpotMaxInputOctetsQuarterly { sql_module_instance = "sql" key = "User-Name" query = "SELECT IFNULL(SUM(AcctInputOctets),0) FROM radacct WHERE UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'" reset = "3m" counter_name = "ChilliSpot-Max-Input-Octets-Quarterly" check_name = "CS-Input-Octets-Quarterly" reply_name = "ChilliSpot-Max-Input-Octets" }

Loading module "counterChilliSpotMaxInputOctetsYearly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter counterChilliSpotMaxInputOctetsYearly { sql_module_instance = "sql" key = "User-Name" query = "SELECT IFNULL(SUM(AcctInputOctets),0) FROM radacct WHERE UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'" reset = "12m" counter_name = "ChilliSpot-Max-Input-Octets-Yearly" check_name = "CS-Input-Octets-Yearly" reply_name = "ChilliSpot-Max-Input-Octets" }

Loading module "counterChilliSpotMaxOutputOctetsDaily" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter counterChilliSpotMaxOutputOctetsDaily { sql_module_instance = "sql" key = "User-Name" query = "SELECT IFNULL(SUM(AcctOutputOctets),0) FROM radacct WHERE UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'" reset = "daily" counter_name = "ChilliSpot-Max-Output-Octets-Daily" check_name = "CS-Output-Octets-Daily" reply_name = "ChilliSpot-Max-Output-Octets" }

Loading module "counterChilliSpotMaxOutputOctetsWeekly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter counterChilliSpotMaxOutputOctetsWeekly { sql_module_instance = "sql" key = "User-Name" query = "SELECT IFNULL(SUM(AcctOutputOctets),0) FROM radacct WHERE UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'" reset = "weekly" counter_name = "ChilliSpot-Max-Output-Octets-Weekly" check_name = "CS-Output-Octets-Weekly" reply_name = "ChilliSpot-Max-Output-Octets" }

Loading module "counterChilliSpotMaxOutputOctetsMonthly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter counterChilliSpotMaxOutputOctetsMonthly { sql_module_instance = "sql" key = "User-Name" query = "SELECT IFNULL(SUM(AcctOutputOctets),0) FROM radacct WHERE UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'" reset = "monthly" counter_name = "ChilliSpot-Max-Output-Octets-Monthly" check_name = "CS-Output-Octets-Monthly" reply_name = "ChilliSpot-Max-Output-Octets" }

Loading module "counterChilliSpotMaxOutputOctetsQuarterly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter counterChilliSpotMaxOutputOctetsQuarterly { sql_module_instance = "sql" key = "User-Name" query = "SELECT IFNULL(SUM(AcctOutputOctets),0) FROM radacct WHERE UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'" reset = "3m" counter_name = "ChilliSpot-Max-Output-Octets-Quarterly" check_name = "CS-Output-Octets-Quarterly" reply_name = "ChilliSpot-Max-Output-Octets" }

Loading module "counterChilliSpotMaxOutputOctetsYearly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

sqlcounter counterChilliSpotMaxOutputOctetsYearly { sql_module_instance = "sql" key = "User-Name" query = "SELECT IFNULL(SUM(AcctOutputOctets),0) FROM radacct WHERE UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'" reset = "12m" counter_name = "ChilliSpot-Max-Output-Octets-Yearly" check_name = "CS-Output-Octets-Yearly" reply_name = "ChilliSpot-Max-Output-Octets" }

Loading module "detail" from file /etc/freeradius/3.0/mods-enabled/detail

detail { filename = "/var/log/freeradius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d" header = "%t" permissions = 384 locking = no escape_filenames = no log_packet_header = no }

Loaded module rlm_expr

Loading module "expr" from file /etc/freeradius/3.0/mods-enabled/expr

expr { safecharacters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-: /äéöüàâæçèéêëîïôœùûüaÿÄÉÖÜßÀÂÆÇÈÉÊËÎÏÔŒÙÛÜŸ" }

Loaded module rlm_utf8

Loading module "utf8" from file /etc/freeradius/3.0/mods-enabled/utf8

Loaded module rlm_soh

Loading module "soh" from file /etc/freeradius/3.0/mods-enabled/soh

soh { dhcp = yes }

Loaded module rlm_passwd

Loading module "etc_passwd" from file /etc/freeradius/3.0/mods-enabled/passwd

passwd etc_passwd { filename = "/etc/passwd" format = "*User-Name:Crypt-Password:" delimiter = ":" ignore_nislike = no ignore_empty = yes allow_multiple_keys = no hash_size = 100 }

Loading module "echo" from file /etc/freeradius/3.0/mods-enabled/echo

exec echo { wait = yes program = "/bin/echo %{User-Name}" input_pairs = "request" output_pairs = "reply" shell_escape = yes } instantiate { }

Instantiating module "reject" from file /etc/freeradius/3.0/mods-enabled/always

Instantiating module "fail" from file /etc/freeradius/3.0/mods-enabled/always

Instantiating module "ok" from file /etc/freeradius/3.0/mods-enabled/always

Instantiating module "handled" from file /etc/freeradius/3.0/mods-enabled/always

Instantiating module "invalid" from file /etc/freeradius/3.0/mods-enabled/always

Instantiating module "userlock" from file /etc/freeradius/3.0/mods-enabled/always

Instantiating module "notfound" from file /etc/freeradius/3.0/mods-enabled/always

Instantiating module "noop" from file /etc/freeradius/3.0/mods-enabled/always

Instantiating module "updated" from file /etc/freeradius/3.0/mods-enabled/always

Instantiating module "eap" from file /etc/freeradius/3.0/mods-enabled/eap

Linked to sub-module rlm_eap_md5

Linked to sub-module rlm_eap_leap

Linked to sub-module rlm_eap_gtc

gtc { challenge = "Password: " auth_type = "PAP" }

Linked to sub-module rlm_eap_tls

tls { tls = "tls-common" } tls-config tls-common { verify_depth = 0 ca_path = "/etc/freeradius/3.0/certs" pem_file_type = yes private_key_file = "/etc/ssl/private/ssl-cert-snakeoil.key" certificate_file = "/etc/ssl/certs/ssl-cert-snakeoil.pem" ca_file = "/etc/ssl/certs/ca-certificates.crt" private_key_password = <<< secret >>> dh_file = "/etc/freeradius/3.0/certs/dh" fragment_size = 1024 include_length = yes auto_chain = yes check_crl = no check_all_crl = no cipher_list = "DEFAULT" ecdh_curve = "prime256v1" cache { enable = yes 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 = no use_tunneled_reply = no proxy_tunneled_request_as_eap = yes virtual_server = "inner-tunnel" soh = no require_client_cert = no } tls: Using cached TLS configuration from previous invocation

Linked to sub-module rlm_eap_mschapv2

mschapv2 { with_ntdomain_hack = no send_error = no }

Instantiating module "preprocess" from file /etc/freeradius/3.0/mods-enabled/preprocess

reading pairlist file /etc/freeradius/3.0/mods-config/preprocess/huntgroups reading pairlist file /etc/freeradius/3.0/mods-config/preprocess/hints

Instantiating module "sql" from file /etc/freeradius/3.0/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-0+deb9u1, 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-0+deb9u1, 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-0+deb9u1, 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-0+deb9u1, 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-0+deb9u1, protocol version 10

Instantiating module "logintime" from file /etc/freeradius/3.0/mods-enabled/logintime

Instantiating module "files" from file /etc/freeradius/3.0/mods-enabled/files

reading pairlist file /etc/freeradius/3.0/mods-config/files/authorize reading pairlist file /etc/freeradius/3.0/mods-config/files/accounting reading pairlist file /etc/freeradius/3.0/mods-config/files/pre-proxy

Instantiating module "linelog" from file /etc/freeradius/3.0/mods-enabled/linelog

Instantiating module "log_accounting" from file /etc/freeradius/3.0/mods-enabled/linelog

Instantiating module "pap" from file /etc/freeradius/3.0/mods-enabled/pap

Instantiating module "IPASS" from file /etc/freeradius/3.0/mods-enabled/realm

Instantiating module "suffix" from file /etc/freeradius/3.0/mods-enabled/realm

Instantiating module "realmpercent" from file /etc/freeradius/3.0/mods-enabled/realm

Instantiating module "ntdomain" from file /etc/freeradius/3.0/mods-enabled/realm

Instantiating module "cache_eap" from file /etc/freeradius/3.0/mods-enabled/cache_eap

rlm_cache (cache_eap): Driver rlm_cache_rbtree (module rlm_cache_rbtree) loaded and linked

Instantiating module "attr_filter.post-proxy" from file /etc/freeradius/3.0/mods-enabled/attr_filter

reading pairlist file /etc/freeradius/3.0/mods-config/attr_filter/post-proxy

Instantiating module "attr_filter.pre-proxy" from file /etc/freeradius/3.0/mods-enabled/attr_filter

reading pairlist file /etc/freeradius/3.0/mods-config/attr_filter/pre-proxy

Instantiating module "attr_filter.access_reject" from file /etc/freeradius/3.0/mods-enabled/attr_filter

reading pairlist file /etc/freeradius/3.0/mods-config/attr_filter/access_reject [/etc/freeradius/3.0/mods-config/attr_filter/access_reject]:11 Check item "FreeRADIUS-Response-Delay" found in filter list for realm "DEFAULT". [/etc/freeradius/3.0/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/freeradius/3.0/mods-enabled/attr_filter

reading pairlist file /etc/freeradius/3.0/mods-config/attr_filter/access_challenge

Instantiating module "attr_filter.accounting_response" from file /etc/freeradius/3.0/mods-enabled/attr_filter

reading pairlist file /etc/freeradius/3.0/mods-config/attr_filter/accounting_response

Instantiating module "expiration" from file /etc/freeradius/3.0/mods-enabled/expiration

Instantiating module "mschap" from file /etc/freeradius/3.0/mods-enabled/mschap

rlm_mschap (mschap): using internal authentication

Instantiating module "auth_log" from file /etc/freeradius/3.0/mods-enabled/detail.log

rlm_detail (auth_log): 'User-Password' suppressed, will not appear in detail output

Instantiating module "reply_log" from file /etc/freeradius/3.0/mods-enabled/detail.log

Instantiating module "pre_proxy_log" from file /etc/freeradius/3.0/mods-enabled/detail.log

Instantiating module "post_proxy_log" from file /etc/freeradius/3.0/mods-enabled/detail.log

Instantiating module "dailycounter" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 1549666800 [2019-02-09 00:00:00] rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 1549580400 [2019-02-08 00:00:00]

Instantiating module "weeklycounter" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 1549753200 [2019-02-10 00:00:00] rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 1549148400 [2019-02-03 00:00:00]

Instantiating module "monthlycounter" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 1551394800 [2019-03-01 00:00:00] rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 1548975600 [2019-02-01 00:00:00]

Instantiating module "quaterlycounter" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: num=3, last=m rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 1556665200 [2019-05-01 01:00:00] rlm_sqlcounter: num=3, last=m rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 1543618800 [2018-12-01 00:00:00]

Instantiating module "yearlycounter" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: num=12, last=m rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 1580511600 [2020-02-01 00:00:00] rlm_sqlcounter: num=12, last=m rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 1519858800 [2018-03-01 00:00:00]

Instantiating module "noresetcounter" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 0 [2019-02-08 22:00:00] rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 0 [2019-02-08 22:00:00]

Instantiating module "expire_on_login" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 0 [2019-02-08 22:00:00] rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 0 [2019-02-08 22:00:00]

Instantiating module "counterChilliSpotMaxTotalOctetsDaily" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 1549666800 [2019-02-09 00:00:00] rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 1549580400 [2019-02-08 00:00:00]

Instantiating module "counterChilliSpotMaxTotalOctetsWeekly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 1549753200 [2019-02-10 00:00:00] rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 1549148400 [2019-02-03 00:00:00]

Instantiating module "counterChilliSpotMaxTotalOctetsMonthly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 1551394800 [2019-03-01 00:00:00] rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 1548975600 [2019-02-01 00:00:00]

Instantiating module "counterChilliSpotMaxTotalOctetsQuarterly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: num=3, last=m rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 1556665200 [2019-05-01 01:00:00] rlm_sqlcounter: num=3, last=m rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 1543618800 [2018-12-01 00:00:00]

Instantiating module "counterChilliSpotMaxTotalOctetsYearly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: num=12, last=m rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 1580511600 [2020-02-01 00:00:00] rlm_sqlcounter: num=12, last=m rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 1519858800 [2018-03-01 00:00:00]

Instantiating module "counterChilliSpotMaxInputOctetsDaily" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 1549666800 [2019-02-09 00:00:00] rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 1549580400 [2019-02-08 00:00:00]

Instantiating module "counterChilliSpotMaxInputOctetsWeekly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 1549753200 [2019-02-10 00:00:00] rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 1549148400 [2019-02-03 00:00:00]

Instantiating module "counterChilliSpotMaxInputOctetsMonthly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 1551394800 [2019-03-01 00:00:00] rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 1548975600 [2019-02-01 00:00:00]

Instantiating module "counterChilliSpotMaxInputOctetsQuarterly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: num=3, last=m rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 1556665200 [2019-05-01 01:00:00] rlm_sqlcounter: num=3, last=m rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 1543618800 [2018-12-01 00:00:00]

Instantiating module "counterChilliSpotMaxInputOctetsYearly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: num=12, last=m rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 1580511600 [2020-02-01 00:00:00] rlm_sqlcounter: num=12, last=m rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 1519858800 [2018-03-01 00:00:00]

Instantiating module "counterChilliSpotMaxOutputOctetsDaily" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 1549666800 [2019-02-09 00:00:00] rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 1549580400 [2019-02-08 00:00:00]

Instantiating module "counterChilliSpotMaxOutputOctetsWeekly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 1549753200 [2019-02-10 00:00:00] rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 1549148400 [2019-02-03 00:00:00]

Instantiating module "counterChilliSpotMaxOutputOctetsMonthly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 1551394800 [2019-03-01 00:00:00] rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 1548975600 [2019-02-01 00:00:00]

Instantiating module "counterChilliSpotMaxOutputOctetsQuarterly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: num=3, last=m rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 1556665200 [2019-05-01 01:00:00] rlm_sqlcounter: num=3, last=m rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 1543618800 [2018-12-01 00:00:00]

Instantiating module "counterChilliSpotMaxOutputOctetsYearly" from file /etc/freeradius/3.0/mods-enabled/sqlcounter

rlm_sqlcounter: num=12, last=m rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Next reset 1580511600 [2020-02-01 00:00:00] rlm_sqlcounter: num=12, last=m rlm_sqlcounter: Current Time: 1549663155 [2019-02-08 22:59:15], Prev reset 1519858800 [2018-03-01 00:00:00]

Instantiating module "detail" from file /etc/freeradius/3.0/mods-enabled/detail

Instantiating module "etc_passwd" from file /etc/freeradius/3.0/mods-enabled/passwd

rlm_passwd: nfields: 3 keyfield 0(User-Name) listable: no } # modules radiusd: #### Loading Virtual Servers #### server { # from file /etc/freeradius/3.0/radiusd.conf } # server server coa { # from file /etc/freeradius/3.0/sites-enabled/coa

Loading recv-coa {...}

Loading send-coa {...}

} # server coa server default { # from file /etc/freeradius/3.0/sites-enabled/default

Loading authenticate {...}

Loading authorize {...}

Ignoring "ldap" (see raddb/mods-available/README.rst)

Loading preacct {...}

Loading accounting {...}

Loading session {...}

Loading post-proxy {...}

Loading post-auth {...}

} # server default server inner-tunnel { # from file /etc/freeradius/3.0/sites-enabled/inner-tunnel

Loading authenticate {...}

Loading authorize {...}

Loading session {...}

Loading post-proxy {...}

Loading post-auth {...}

} # server inner-tunnel radiusd: #### Opening IP addresses and Ports #### listen { type = "coa" virtual_server = "coa" ipaddr = port = 1700 } listen { type = "auth" ipaddr = port = 0 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "acct" ipaddr = port = 0 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "auth" ipv6addr = :: port = 0 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "acct" ipv6addr = :: port = 0 limit { max_connections = 16 lifetime = 0 idle_timeout = 30 } } listen { type = "auth" ipaddr = 127.0.0.1 port = 18120 } Listening on coa address port 1700 bound to server coa 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 Listening on proxy address * port 37393 Listening on proxy address :: port 33535 Ready to process requests

[indian65]

I don't know why, but my new user is accept this morning. Thanks for your help. Very good job.