Show date & time in OpenVPN log

[Hypnotoad]

I'm on UT6.0.1 stand-alone and mostly loving it. However, one issue has come up:

I am on the lookout for a connection attempt from a laptop that was stolen from one of our users. The laptop is running Ubuntu and has been configured to automatically initiate its VPN connection. Therefore, I am standing by to supply the police with the source IP address when it appears in the OpenVPN log when the thief connects to the internet for the first time.

Now the problem: it may be very important to note the exact time of the connection, but the new interface appears not to supply the connect/disconnect time as it used to do. Is there any way to restore that functionality? Or if not, where may I find the raw OpenVPN log file?

Clarification: The OpenVPN log shows date, of course, but no longer shows the time. C'mon, guys, show me some love here...

Thanks in advance to all you groovy UT cats.

[Hypnotoad]

This is NOT an insignificant issue. Knowing the exact connect/disconnect times for VPN (as opposed to just the date of connection) is potentially crucial in troubleshooting connection issues as well as for forensic purposes.

I have no idea why this functionality was removed in the new version, but I believe that it was a major oversight. Someone PLEASE respond to this thread!!!!

[sky-knight]

Sorry man that took some digging...

Get into the terminal and use the following command.

echo "select * from n_openvpn_connect_evt;" | psql -U postgres uvm > /tmp/openvpn_connections.txt

That will put all the raw database stuff into a text file for you to look at manually. It has a full time and date stamp of each connection.

If you don't want to output the stuff to a file and instead just want to look at it on the screen take off everything after the > and do...

echo "select * from n_openvpn_connect_evt;" | psql -U postgres uvm