I just noticed that if I select a single user in the OVPN Connections Log page, it does not show that single user’s connection logs. It still shows all users for the time period selected. The columns change, though. Is this intended behavior, or should it only show the connection logs for the single user selected?
User selection set to All:
User selection set to a specific user (blanked out for privacy) :
It does for me and always has done so on both my physical machine and my vm machines.
Here is my example. First the screen showing all clients (two in this case)
Then this next one is where I selected one of the clients in the list and then updated and I now get all the connections logs for that one selected client.
I also notice that all of your connections show 0.00B for Received and Sent while mine show actual numbers.
Also Connected should be a date and there should also be a date for Disconnected and minutes and seconds or hours minutes and seconds for the Duration.
There is something wrong with your logs but it is not intrinsically what should be happening.
Yesterdays test was done with my CU199 production system.
I have just run the same test on my vm systems running CU200 Testing and I had the same result. I can see the results for the selected connection name and with all columns with expected data.
Does it stay the same after a reboot. If yes then I would suggest that you do a backup with logs and then do a fresh install and then restore from your backup. There has to have been some sort of corruption of data or code somewhere and a fresh install is the safest way to be sure everything is correct.
Looking at the code for the ovpnclients.dat WUI page the data for that log status is kept in the /var/ipfire/ovpn/clients.db database.
The ownership of that file should be nobody:nobody and permissions 644 and the date/time should be from when your last openvpn road warrior connection stopped connecting.
So if you constantly have roadwarriors connected it should be the current date/time.
It is an sql database so it is a binary file and can’t just be easily read to check the contents.
I will check the next time I reboot the system. Thank you. It’s not a feature I use often, but I happened to check the other day which prompted my post.
