<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
Hello,<br><br>Despite taht my user is authenticated, I don't get the data in RADACCT table, my output is this one. Can anybody help me?<br><br>Thanks<br> input_pairs = "request"
<br>
shell_escape = yes
<br>
}
<br>
Module: Linked to module rlm_expr
<br>
Module: Instantiating module "expr" from file /etc/freeradius/modules/expr
<br>
Module: Linked to module rlm_expiration
<br>
Module: Instantiating module "expiration" from file /etc/freeradius/modules/expiration
<br>
expiration {
<br>
reply-message = "Password Has Expired "
<br>
}
<br>
Module: Linked to module rlm_logintime
<br>
Module: Instantiating module "logintime" from file /etc/freeradius/modules/logintime
<br>
logintime {
<br>
reply-message = "You are calling outside your allowed timespan "
<br>
minimum-timeout = 60
<br>
}
<br>
}
<br>
radiusd: #### Loading Virtual Servers ####
<br>
server inner-tunnel { # from file /etc/freeradius/sites-enabled/inner-tunnel
<br>
modules {
<br>
Module: Checking authenticate {...} for more modules to load
<br>
Module: Linked to module rlm_pap
<br>
Module: Instantiating module "pap" from file /etc/freeradius/modules/pap
<br>
pap {
<br>
encryption_scheme = "auto"
<br>
auto_header = no
<br>
}
<br>
Module: Linked to module rlm_chap
<br>
Module: Instantiating module "chap" from file /etc/freeradius/modules/chap
<br>
Module: Linked to module rlm_mschap
<br>
Module: Instantiating module "mschap" from file /etc/freeradius/modules/mschap
<br>
mschap {
<br>
use_mppe = yes
<br>
require_encryption = no
<br>
require_strong = no
<br>
with_ntdomain_hack = no
<br>
}
<br>
Module: Linked to module rlm_unix
<br>
Module: Instantiating module "unix" from file /etc/freeradius/modules/unix
<br>
unix {
<br>
radwtmp = "/var/log/freeradius/radwtmp"
<br>
}
<br>
Module: Linked to module rlm_eap
<br>
Module: Instantiating module "eap" from file /etc/freeradius/eap.conf
<br>
eap {
<br>
default_eap_type = "md5"
<br>
timer_expire = 60
<br>
ignore_unknown_eap_types = no
<br>
cisco_accounting_username_bug = no
<br>
max_sessions = 4096
<br>
}
<br>
Module: Linked to sub-module rlm_eap_md5
<br>
Module: Instantiating eap-md5
<br>
Module: Linked to sub-module rlm_eap_leap
<br>
Module: Instantiating eap-leap
<br>
Module: Linked to sub-module rlm_eap_gtc
<br>
Module: Instantiating eap-gtc
<br>
gtc {
<br>
challenge = "Password: "
<br>
auth_type = "PAP"
<br>
}
<br>
Module: Linked to sub-module rlm_eap_tls
<br>
Module: Instantiating eap-tls
<br>
tls {
<br>
rsa_key_exchange = no
<br>
dh_key_exchange = yes
<br>
rsa_key_length = 512
<br>
dh_key_length = 512
<br>
verify_depth = 0
<br>
CA_path = "/etc/freeradius/certs"
<br>
pem_file_type = yes
<br>
private_key_file = "/etc/freeradius/certs/server.key"
<br>
certificate_file = "/etc/freeradius/certs/server.pem"
<br>
CA_file = "/etc/freeradius/certs/ca.pem"
<br>
private_key_password = "whatever"
<br>
dh_file = "/etc/freeradius/certs/dh"
<br>
random_file = "/dev/urandom"
<br>
fragment_size = 1024
<br>
include_length = yes
<br>
check_crl = no
<br>
cipher_list = "DEFAULT"
<br>
make_cert_command = "/etc/freeradius/certs/bootstrap"
<br>
cache {
<br>
enable = no
<br>
lifetime = 24
<br>
max_entries = 255
<br>
}
<br>
verify {
<br>
}
<br>
}
<br>
Module: Linked to sub-module rlm_eap_ttls
<br>
Module: Instantiating eap-ttls
<br>
ttls {
<br>
default_eap_type = "md5"
<br>
copy_request_to_tunnel = no
<br>
use_tunneled_reply = no
<br>
virtual_server = "inner-tunnel"
<br>
include_length = yes
<br>
}
<br>
Module: Linked to sub-module rlm_eap_peap
<br>
Module: Instantiating eap-peap
<br>
peap {
<br>
default_eap_type = "mschapv2"
<br>
copy_request_to_tunnel = no
<br>
use_tunneled_reply = no
<br>
proxy_tunneled_request_as_eap = yes
<br>
virtual_server = "inner-tunnel"
<br>
}
<br>
Module: Linked to sub-module rlm_eap_mschapv2
<br>
Module: Instantiating eap-mschapv2
<br>
mschapv2 {
<br>
with_ntdomain_hack = no
<br>
}
<br>
Module: Checking authorize {...} for more modules to load
<br>
Module: Linked to module rlm_realm
<br>
Module: Instantiating module "suffix" from file /etc/freeradius/modules/realm
<br>
realm suffix {
<br>
format = "suffix"
<br>
delimiter = "@"
<br>
ignore_default = no
<br>
ignore_null = no
<br>
}
<br>
Module: Linked to module rlm_files
<br>
Module: Instantiating module "files" from file /etc/freeradius/modules/files
<br>
files {
<br>
usersfile = "/etc/freeradius/users"
<br>
acctusersfile = "/etc/freeradius/acct_users"
<br>
preproxy_usersfile = "/etc/freeradius/preproxy_users"
<br>
compat = "no"
<br>
}
<br>
Module: Checking session {...} for more modules to load
<br>
Module: Linked to module rlm_radutmp
<br>
Module: Instantiating module "radutmp" from file /etc/freeradius/modules/radutmp
<br>
radutmp {
<br>
filename = "/var/log/freeradius/radutmp"
<br>
username = "%{User-Name}"
<br>
case_sensitive = yes
<br>
check_with_nas = yes
<br>
perm = 384
<br>
callerid = yes
<br>
}
<br>
Module: Checking post-proxy {...} for more modules to load
<br>
Module: Checking post-auth {...} for more modules to load
<br>
Module: Linked to module rlm_attr_filter
<br>
<div style="background-color: #ff3333"> Module: Instantiating module "attr_filter.access_reject" from file /etc/freeradius/modules/attr_filter
</div><div style="background-color: #ff3333"> attr_filter attr_filter.access_reject {
</div><div style="background-color: #ff3333"> attrsfile = "/etc/freeradius/attrs.access_reject"
</div> key = "%{User-Name}"
<br>
}
<br>
} # modules
<br>
} # server
<br>
server { # from file /etc/freeradius/radiusd.conf
<br>
modules {
<br>
Module: Checking authenticate {...} for more modules to load
<br>
Module: Checking authorize {...} for more modules to load
<br>
Module: Linked to module rlm_preprocess
<br>
Module: Instantiating module "preprocess" from file /etc/freeradius/modules/preprocess
<br>
preprocess {
<br>
huntgroups = "/etc/freeradius/huntgroups"
<br>
hints = "/etc/freeradius/hints"
<br>
with_ascend_hack = no
<br>
ascend_channels_per_line = 23
<br>
with_ntdomain_hack = no
<br>
with_specialix_jetstream_hack = no
<br>
with_cisco_vsa_hack = no
<br>
with_alvarion_vsa_hack = no
<br>
}
<br>
Module: Linked to module rlm_sql
<br>
Module: Instantiating module "sql" from file /etc/freeradius/sql.conf
<br>
sql {
<br>
driver = "rlm_sql_mysql"
<br>
server = "localhost"
<br>
port = ""
<br>
login = "root"
<br>
password = "1107"
<br>
radius_db = "radius"
<br>
read_groups = yes
<br>
sqltrace = no
<br>
sqltracefile = "/var/log/freeradius/sqltrace.sql"
<br>
readclients = no
<br>
deletestalesessions = yes
<br>
num_sql_socks = 5
<br>
lifetime = 0
<br>
max_queries = 0
<br>
sql_user_name = "%{User-Name}"
<br>
default_user_profile = ""
<br>
nas_query = "SELECT id, nasname, shortname, type, secret, server FROM nas"
<br>
authorize_check_query = "SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id"
<br>
authorize_reply_query = "SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id"
<br>
authorize_group_check_query = "SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id"
<br>
authorize_group_reply_query = "SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id"
<br>
accounting_onoff_query = " UPDATE radacct SET acctstoptime = '%S', acctsessiontime = unix_timestamp('%S') - unix_timestamp(acctstarttime), acctterminatecause = '%{Acct-Terminate-Cause}', acctstopdelay = %{%{Acct-Delay-Time}:-0} WHERE acctstoptime IS NULL AND nasipaddress = '%{NAS-IP-Address}' AND acctstarttime <= '%S'"
<br>
accounting_update_query = " UPDATE radacct SET framedipaddress = '%{Framed-IP-Address}', acctsessiontime = '%{Acct-Session-Time}', acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'"
<br>
accounting_update_query_alt = " INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctsessiontime, acctauthentic, connectinfo_start, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, servicetype, framedprotocol, framedipaddress, acctstartdelay, xascendsessionsvrkey) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{%{Acct-Session-Time}:-0} + %{%{Acct-Delay-Time}:-0}) SECOND), '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{X-Ascend-Session-Svr-Key}')"
<br>
accounting_start_query = " INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, acctstartdelay, acctstopdelay, xascendsessionsvrkey) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', NULL, '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '%{%{Acct-Delay-Time}:-0}', '0', '%{X-Ascend-Session-Svr-Key}')"
<br>
accounting_start_query_alt = " UPDATE radacct SET acctstarttime = '%S', acctstartdelay = '%{%{Acct-Delay-Time}:-0}', connectinfo_start = '%{Connect-Info}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'"
<br>
accounting_stop_query = " UPDATE radacct SET acctstoptime = '%S', acctsessiontime = '%{Acct-Session-Time}', acctinputoctets = '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', acctterminatecause = '%{Acct-Terminate-Cause}', acctstopdelay = '%{%{Acct-Delay-Time}:-0}', connectinfo_stop = '%{Connect-Info}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'"
<br>
accounting_stop_query_alt = " INSERT INTO radacct (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctstoptime, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, acctstartdelay, acctstopdelay) VALUES ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{%{Acct-Session-Time}:-0} + %{%{Acct-Delay-Time}:-0}) SECOND), '%S', '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Connect-Info}', '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}', '%{%{Acct-Output-Gigawords}:-0}' << 32 | '%{%{Acct-Output-Octets}:-0}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Acct-Terminate-Cause}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{%{Acct-Delay-Time}:-0}')"
<br>
group_membership_query = "SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority"
<br>
connect_failure_retry_delay = 60
<br>
simul_count_query = ""
<br>
simul_verify_query = "SELECT radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocol FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL"
<br>
postauth_query = "INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S')"
<br>
safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
<br>
}
<br>
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
<br>
rlm_sql (sql): Attempting to connect to root@localhost:/radius
<br>
rlm_sql (sql): starting 0
<br>
rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
<br>
rlm_sql_mysql: Starting connect to MySQL server for #0
<br>
rlm_sql (sql): Connected new DB handle, #0
<br>
rlm_sql (sql): starting 1
<br>
rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
<br>
rlm_sql_mysql: Starting connect to MySQL server for #1
<br>
rlm_sql (sql): Connected new DB handle, #1
<br>
rlm_sql (sql): starting 2
<br>
rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
<br>
rlm_sql_mysql: Starting connect to MySQL server for #2
<br>
rlm_sql (sql): Connected new DB handle, #2
<br>
rlm_sql (sql): starting 3
<br>
rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
<br>
rlm_sql_mysql: Starting connect to MySQL server for #3
<br>
rlm_sql (sql): Connected new DB handle, #3
<br>
rlm_sql (sql): starting 4
<br>
rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
<br>
rlm_sql_mysql: Starting connect to MySQL server for #4
<br>
rlm_sql (sql): Connected new DB handle, #4
<br>
Module: Checking preacct {...} for more modules to load
<br>
Module: Linked to module rlm_acct_unique
<br>
Module: Instantiating module "acct_unique" from file /etc/freeradius/modules/acct_unique
<br>
acct_unique {
<br>
key = "User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port"
<br>
}
<br>
Module: Checking accounting {...} for more modules to load
<br>
Module: Linked to module rlm_detail
<br>
Module: Instantiating module "detail" from file /etc/freeradius/modules/detail
<br>
detail {
<br>
detailfile = "/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d"
<br>
header = "%t"
<br>
detailperm = 384
<br>
dirperm = 493
<br>
locking = no
<br>
log_packet_header = no
<br>
}
<br>
Module: Checking session {...} for more modules to load
<br>
Module: Checking post-proxy {...} for more modules to load
<br>
Module: Checking post-auth {...} for more modules to load
<br>
} # modules
<br>
} # server
<br>
radiusd: #### Opening IP addresses and Ports ####
<br>
listen {
<br>
type = "auth"
<br>
ipaddr = *
<br>
port = 0
<br>
}
<br>
listen {
<br>
type = "acct"
<br>
ipaddr = *
<br>
port = 0
<br>
}
<br>
listen {
<br>
type = "auth"
<br>
ipaddr = 127.0.0.1
<br>
port = 18120
<br>
}
<br>
Listening on authentication address * port 1812
<br>
Listening on accounting address * port 1813
<br>
Listening on authentication address 127.0.0.1 port 18120 as server inner-tunnel
<br>
Listening on proxy address * port 1814
<br>
Ready to process requests.
<br>
<div style="border:1px solid #dadada;margin:20px 10px;padding:8px;background-color: #fcfcfc">
<b>Packet 0</b>
<hr>
<div style="background-color: #c5effd">rad_recv: Access-Request packet from host 192.168.1.11 port 42704, id=6, length=195
</div><div style="background-color: #c5effd"> NAS-Port-Type = Wireless-802.11
</div><div style="background-color: #c5effd"> Calling-Station-Id = "68:A3:C4:37:A2:59"
</div><div style="background-color: #c5effd"> Called-Station-Id = "hotspot1"
</div><div style="background-color: #c5effd"> NAS-Port-Id = "wlan1"
</div><div style="background-color: #c5effd"> User-Name = "terezia"
</div><div style="background-color: #c5effd"> NAS-Port = 2163212290
</div><div style="background-color: #c5effd"> Acct-Session-Id = "80f00002"
</div><div style="background-color: #c5effd"> Framed-IP-Address = 10.5.50.253
</div><div style="background-color: #c5effd"> Mikrotik-Host-IP = 10.5.50.253
</div><div style="background-color: #c5effd"> CHAP-Challenge = 0x3cbbf994793f97861a7be55834b6aa8c
</div><div style="background-color: #c5effd"> CHAP-Password = 0xc22f6ecadc317de6e657d2e0b04217c40b
</div><div style="background-color: #c5effd"> Service-Type = Login-User
</div><div style="background-color: #c5effd"> WISPr-Logoff-URL = "http://10.5.50.1/logout"
</div><div style="background-color: #c5effd"> NAS-Identifier = "MikroTik"
</div><div style="background-color: #c5effd"> NAS-IP-Address = 192.168.1.11
</div># Executing section authorize from file /etc/freeradius/radiusd.conf
<br>
+- entering group authorize {...}
<br>
++[preprocess] returns ok
<br>
[chap] Setting 'Auth-Type := CHAP'
<br>
++[chap] returns ok
<br>
++[mschap] returns noop
<br>
[suffix] No '@' in User-Name = "terezia", looking up realm NULL
<br>
[suffix] No such realm "NULL"
<br>
++[suffix] returns noop
<br>
[eap] No EAP-Message, not doing EAP
<br>
++[eap] returns noop
<br>
[sql] expand: %{User-Name} -> terezia
<br>
[sql] sql_set_user escaped user --> 'terezia'
<br>
rlm_sql (sql): Reserving sql socket id: 4
<br>
[sql] expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'terezia' ORDER BY id
<br>
[sql] User found in radcheck table
<br>
[sql] expand: SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'terezia' ORDER BY id
<br>
[sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = 'terezia' ORDER BY priority
<br>
rlm_sql (sql): Released sql socket id: 4
<br>
++[sql] returns ok
<br>
<div style="background-color: yellow">[pap] WARNING: Auth-Type already set. Not setting to PAP
</div>++[pap] returns noop
<br>
Found Auth-Type = CHAP
<br>
# Executing group from file /etc/freeradius/radiusd.conf
<br>
+- entering group CHAP {...}
<br>
[chap] login attempt by "terezia" with CHAP password
<br>
[chap] Using clear text password "" for user terezia authentication.
<br>
[chap] Password check failed
<br>
<div style="background-color: #ff3333">++[chap] returns reject
</div>Failed to authenticate the user.
<br>
<div style="background-color: #ff3333">Using Post-Auth-Type Reject
</div># Executing group from file /etc/freeradius/sites-enabled/default
<br>
<div style="background-color: #ff3333">+- entering group REJECT {...}
</div><div style="background-color: #ff3333">[attr_filter.access_reject] expand: %{User-Name} -> terezia
</div> attr_filter: Matched entry DEFAULT at line 11
<br>
<div style="background-color: #ff3333">++[attr_filter.access_reject] returns updated
</div><div style="background-color: #ff3333">Delaying reject of request 0 for 1 seconds
</div></div>
<font style="color:#c3c3c3">Going to the next request
</font><br>
<font style="color:#c3c3c3">Waking up in 0.9 seconds.
</font><br>
<div style="border:1px solid #dadada;margin:20px 10px;padding:8px;background-color: #fcfcfc">
<b>Packet 1</b>
<hr>
<div style="background-color: #c5effd">rad_recv: Access-Request packet from host 192.168.1.11 port 42704, id=6, length=195
</div><div style="background-color: #ff3333">Waiting to send Access-Reject to client private-network-1 port 42704 - ID: 6
</div>Waking up in 0.7 seconds.
<br>
</div>
<div style="border:1px solid #dadada;margin:20px 10px;padding:8px;background-color: #fcfcfc">
<b>Packet 2</b>
<hr>
<div style="background-color: #c5effd">rad_recv: Access-Request packet from host 192.168.1.11 port 42704, id=6, length=195
</div><div style="background-color: #ff3333">Waiting to send Access-Reject to client private-network-1 port 42704 - ID: 6
</div>Waking up in 0.4 seconds.
<br>
<div style="background-color: #ff3333">Sending delayed reject for request 0
</div><div style="background-color: #ff3333">Sending Access-Reject of id 6 to 192.168.1.11 port 42704
</div>Waking up in 4.9 seconds.
<br>
Cleaning up request 0 ID 6 with timestamp +43
<br>
Ready to process requests.
<br>
</div>
<b>Packet 3</b>
<hr>
<div style="background-color: #c5effd">rad_recv: Access-Request packet from host 192.168.1.11 port 45935, id=7, length=192
</div><div style="background-color: #c5effd"> NAS-Port-Type = Wireless-802.11
</div><div style="background-color: #c5effd"> Calling-Station-Id = "68:A3:C4:37:A2:59"
</div><div style="background-color: #c5effd"> Called-Station-Id = "hotspot1"
</div><div style="background-color: #c5effd"> NAS-Port-Id = "wlan1"
</div><div style="background-color: #c5effd"> User-Name = "test"
</div><div style="background-color: #c5effd"> NAS-Port = 2163212291
</div><div style="background-color: #c5effd"> Acct-Session-Id = "80f00003"
</div><div style="background-color: #c5effd"> Framed-IP-Address = 10.5.50.253
</div><div style="background-color: #c5effd"> Mikrotik-Host-IP = 10.5.50.253
</div><div style="background-color: #c5effd"> CHAP-Challenge = 0x46d763209ae10ed864d0f7ddd0c804c4
</div><div style="background-color: #c5effd"> CHAP-Password = 0x98679418c360d0807088b3c0fff060452b
</div><div style="background-color: #c5effd"> Service-Type = Login-User
</div><div style="background-color: #c5effd"> WISPr-Logoff-URL = "http://10.5.50.1/logout"
</div><div style="background-color: #c5effd"> NAS-Identifier = "MikroTik"
</div><div style="background-color: #c5effd"> NAS-IP-Address = 192.168.1.11
</div># Executing section authorize from file /etc/freeradius/radiusd.conf
<br>
+- entering group authorize {...}
<br>
++[preprocess] returns ok
<br>
[chap] Setting 'Auth-Type := CHAP'
<br>
++[chap] returns ok
<br>
++[mschap] returns noop
<br>
[suffix] No '@' in User-Name = "test", looking up realm NULL
<br>
[suffix] No such realm "NULL"
<br>
++[suffix] returns noop
<br>
[eap] No EAP-Message, not doing EAP
<br>
++[eap] returns noop
<br>
[sql] expand: %{User-Name} -> test
<br>
[sql] sql_set_user escaped user --> 'test'
<br>
rlm_sql (sql): Reserving sql socket id: 3
<br>
[sql] expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'test' ORDER BY id
<br>
[sql] User found in radcheck table
<br>
[sql] expand: SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'test' ORDER BY id
<br>
[sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = 'test' ORDER BY priority
<br>
rlm_sql (sql): Released sql socket id: 3
<br>
++[sql] returns ok
<br>
<div style="background-color: yellow">[pap] WARNING: Auth-Type already set. Not setting to PAP
</div>++[pap] returns noop
<br>
Found Auth-Type = CHAP
<br>
# Executing group from file /etc/freeradius/radiusd.conf
<br>
+- entering group CHAP {...}
<br>
[chap] login attempt by "test" with CHAP password
<br>
[chap] Using clear text password "test" for user test authentication.
<br>
[chap] chap user test authenticated succesfully
<br>
++[chap] returns ok
<br>
# Executing section post-auth from file /etc/freeradius/sites-enabled/default
<br>
+- entering group post-auth {...}
<br>
++[exec] returns noop
<br>
<div style="background-color: #c5effd">Sending Access-Accept of id 7 to 192.168.1.11 port 45935
</div><div style="background-color: #c5effd"> Mikrotik-Recv-Limit = 104857600
</div>Finished request 1.
<br><br><div><div id="SkyDrivePlaceholder"></div>> From: fruiz002@hotmail.com<br>> To: freeradius-users@lists.freeradius.org<br>> Subject: Radacct table not working properly<br>> Date: Fri, 23 Mar 2012 16:30:11 +0100<br>> <br>> Hello,<br>> <br>> My Radacct table in mysql Freeradius saves only sometimes the values of my<br>> users when they log in, does anybody know why?<br>> <br>> Thanks<br>> <br>> regards<br>> <br>> -----Original Message-----<br>> From: freeradius-users-bounces+fruiz002=hotmail.com@lists.freeradius.org<br>> [mailto:freeradius-users-bounces+fruiz002=hotmail.com@lists.freeradius.org]<br>> On Behalf Of Alan DeKok<br>> Sent: viernes, 23 de marzo de 2012 13:07<br>> To: FreeRadius users mailing list; FreeRadius users mailing list<br>> Subject: Re: Disconnect a Mikrotik NAS client from Daloradius<br>> <br>> Javier Ruiz Escalante wrote:<br>> > I would like to disconnect a client which is connected through a <br>> > Mikrotik Hotspot and the command used normally via Chillispot does not <br>> > work, I know that I have to use several attributes like session id and <br>> > so on, but no clue how to use them. Can somebody give me a clue?<br>> <br>> Read the mikrotik documentation to see what it needs in order to<br>> disconnect a user. Then, configure FreeRADIUS to send those attributes.<br>> <br>> Alan DeKok.<br>> -<br>> List info/subscribe/unsubscribe? See<br>> http://www.freeradius.org/list/users.html<br></div> </div></body>
</html>