OpenVPNAS Accounting Issues

Neville nev at itsnev.co.uk
Thu Dec 31 10:34:45 CET 2009


>
> Neville wrote:
>> I would just like to clarify the accepted format of Acct-Session-Id, when
>> using mySQL to track the clients usage through accounting.
>
>  It's a string.
>
>> I'm currently testing OpenVPNAS and it seems to create a long string
>> such as
>> 'NASIPADDRESS.as0t0.1261084262.6899.1', however when the
>> 'Acct-Status-Type':
>> 'Stop' is sent, the SQL does not update the current row, but instead
>> creates
>> a NEW row, which seems identical, therefore leaving the session open in
>> sql.
>
>  Because the NAS isn't sending the same information in "stop" as it
> sent in "start".
>
>> Is the problem with the STRING being used by OpenVPNAS the reason why the
>> original ROW created by 'Acct-Status-Type': 'Start' is not being updated?
>
>  No.
>
>  As always, run the server in debugging mode to see what's happening.
>
>  Alan DeKok.
>

Thanks Alan,  acctsessionid field was limited to vchar(32), increased to 
vchar(64) and all is working correctly.

Thx
Nev 




More information about the Freeradius-Users mailing list