Problem "expand: %{Acct-Input-Gigawords} ->" always get nothing!

Alexandre Chapellon a.chapellon at horoa.net
Tue Sep 27 10:04:28 CEST 2011



Le 27/09/2011 09:52, snan4love a écrit :
> Hello Everybody:
> Thanks for opening this topic.
> Right now,I have set up the FreeRadius+Mysql+Wifi system, I could get into
> the internet via this system on my laptop.
> But my problem is :
> No matter how long i stay in the connection, the AcctInputOctets and
> AcctOutPutOctets are always 0;
> the debug information from radiusd -X mode regarding this issue is :
>
> [sql] 	expand: %{User-Name} ->  snan4love
> [sql] sql_set_user escaped user -->  'snan4love'
> [sql] 	expand: %{Acct-Input-Gigawords} ->
> [sql] 	... expanding second conditional
> [sql] 	expand: %{Acct-Input-Octets} ->
> [sql] 	... expanding second conditional
> [sql] 	expand: %{Acct-Output-Gigawords} ->
> [sql] 	... expanding second conditional
> [sql] 	expand: %{Acct-Output-Octets} ->
> [sql] 	... expanding second conditional
> [sql] 	expand: %{Acct-Delay-Time} ->
> [sql] 	... expanding second conditional
> [sql] 	expand:            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}' ->             UPDATE radacct SET
> acctstoptime       = '2011-09-27 15:45:35',              acctsessiontime
> = '1317',              acctinputoctets    = '0'<<  32 |
> '0',              acctoutputoctets   = '0'<<  32 |
>
> Every expand:%{Acct-Input-...} will get nothing.
> I know,there must be misconfiguration I made, but I dont know where to fix
> it.
> Please help me,
> Thank you very much.
Well, I guess you don't have those attributes in the accouting packets 
sent by your NAS... Have you checked this?

> --
> View this message in context: http://freeradius.1045715.n5.nabble.com/Problem-expand-Acct-Input-Gigawords-always-get-nothing-tp4844371p4844371.html
> Sent from the FreeRadius - User mailing list archive at Nabble.com.
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

-- 
<http://www.horoa.net>

Alexandre Chapellon

Ingénierie des systèmes open sources et réseaux.
Follow me on twitter: @alxgomz <http://www.twitter.com/alxgomz>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20110927/d013a4f1/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: horoa_sig.png
Type: image/png
Size: 6693 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20110927/d013a4f1/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: a_chapellon.vcf
Type: text/x-vcard
Size: 373 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20110927/d013a4f1/attachment.vcf>


More information about the Freeradius-Users mailing list