freeradius disconnect user using accounting
Vijay S
vijay.hcr at gmail.com
Wed Apr 8 07:25:51 CEST 2015
Hi leandromelo,
What exactly you want to do, Kindly give clear idea so people here can help
you actually.
Regards
Vijay A.
On Apr 8, 2015 12:28 AM, "Leandro Melo - Netsul Telecom" <
leandromelo at netsulinternet.com.br> wrote:
> dear,
>
>
>
> use FreeRADIUS Version 2.1.12 and mikrotik as hub, set up the interim
> update
> for 10 seconds (for testing) so that the radius can drop the connection
> when
> the time is reached.
>
> set up the / etc / raddb / sites-avaliable / default to
>
>
>
> accounting {
>
> detail
>
> unix
>
> radutmp
>
> sqlippool
>
> sql1
>
> exec
>
> if ("% {Acct-Session-Time}"> 30) {
>
> reject
>
> }
>
> attr_filter.accounting_response
>
> }
>
>
>
> but the log returned by radius if he enters, but drops the connection, what
> command to derrumar the connection and return a "reply-message" to the hub?
>
>
>
> follows the log:
>
>
>
> ...
>
> [sql1] expand: UPDATE radacct SET FramedIPAddress =
> NULLIF('%{Framed-IP-Address}', '')::inet, AcctSessionTime =
> '%{Acct-Session-Time}', AcctInputOctets =
> (('%{%{Acct-Input-Gigawords}:-0}'::bigint << 32) +
> '%{%{Acct-Input-Octets}:-0}'::bigint), AcctOutputOctets =
> (('%{%{Acct-Output-Gigawords}:-0}'::bigint << 32) +
> '%{%{Acct-Output-Octets}:-0}'::bigint) WHERE AcctSessionId =
> '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress=
> '%{NAS-IP-Address}' AND AcctStopTime IS NULL -> UPDATE radacct SET
> FramedIPAddress = NULLIF('192.168.95.101', '')::inet, AcctSessionTime =
> '1101', AcctInputOctets = (('0'::bigint << 32) + '211907'::bigint),
> AcctOutputOctets = (('0'::bigint << 32) + '407325'::bigint) WHERE
> AcctSessionId = '81c00012' AND UserName = 'teste1' AND NASIPAddress=
> '192.168.1.41' AND AcctStopTime IS NULL
>
> rlm_sql (sql1): Reserving sql socket id: 0
>
> rlm_sql_postgresql: Status: PGRES_COMMAND_OK
>
> rlm_sql_postgresql: query affected rows = 1
>
> rlm_sql (sql1): Released sql socket id: 0
>
> ++[sql1] returns ok
>
> ++[exec] returns noop
>
> ++? if ("%{Acct-Session-Time}" > 30)
>
> expand: %{Acct-Session-Time} -> 1101
>
> ? Evaluating ("%{Acct-Session-Time}" > 30) -> TRUE
>
> ++? if ("%{Acct-Session-Time}" > 30) -> TRUE
>
> ++- entering if ("%{Acct-Session-Time}" > 30) {...}
>
> +++- if ("%{Acct-Session-Time}" > 30) returns noop
>
> ++- group accounting returns noop
>
> [attr_filter.accounting_response] expand: %{User-Name} -> teste1
>
> attr_filter: Matched entry DEFAULT at line 12
>
> ++[attr_filter.accounting_response] returns updated
>
> Sending Accounting-Response of id 232 to 10.0.2.2 port 37115
>
> Finished request 21.
>
> ...
>
>
>
> Att,
>
>
>
>
>
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
More information about the Freeradius-Users
mailing list