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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
