Re: OpenVPNAS Accounting Issues
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
Re: OpenVPNAS Accounting Issues
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
Re: OpenVPNAS Accounting Issues
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. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
OpenVPNAS Accounting Issues
Hi all, I would just like to clarify the accepted format of Acct-Session-Id, when using mySQL to track the clients usage through accounting. 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. 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? Thx Nev - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html