OpenVPNAS Accounting Issues

[Alan DeKok]

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.