openvpn script to monitor client usage
Budget: $50 – $150 USD
I cannot give you remote access, you will have to provide the code with information on how to use it and I will test it.
The script must keep track of the amount of data that each client is using for the month.
Usage details must be stored in a simple mysql table.
Correct and accurate logging must be done, no overlapping usage from a previous connection that was lost minutes ago for example. Clients can connect and re-connect many times per day so the usage must be accurate.
The usage must be broken down by the day so perhaps one column for each day of the month then a total.
The point is to cumulatively collect usage for all clients for for each 30 day period or better said, from the first day of each month to the last day of the month.
I am using openvpn-monitor which is useless because once the client disconnects, all of the data is lost.
I also use the status log but again, when the client disconnects, all data is lost.
Each client VIP could change but its name is its MAC address which can be used as the identifier.
Do a good job and this could turn into an ongoing job of adding and updating to this solution.
The script must keep track of the amount of data that each client is using for the month.
Usage details must be stored in a simple mysql table.
Correct and accurate logging must be done, no overlapping usage from a previous connection that was lost minutes ago for example. Clients can connect and re-connect many times per day so the usage must be accurate.
The usage must be broken down by the day so perhaps one column for each day of the month then a total.
The point is to cumulatively collect usage for all clients for for each 30 day period or better said, from the first day of each month to the last day of the month.
I am using openvpn-monitor which is useless because once the client disconnects, all of the data is lost.
I also use the status log but again, when the client disconnects, all data is lost.
Each client VIP could change but its name is its MAC address which can be used as the identifier.
Do a good job and this could turn into an ongoing job of adding and updating to this solution.