On 08/18/2014 05:46 AM, Leonardo Rodrigues wrote: > On 18/08/14 06:03, Dmitry Korzhevin wrote: >> Hi, >> >> I use 'log-append' directive in server side config file, to write all >> log data to specified file. >> >> My question - is there any way to log all connection info to mysql >> database? >> > > Not directly, as OpenVPN does not have MySQL support of any kind. > However, using client-connect and client-disconnect, you could easily > call your scripts that save the avaialble data however you want, MySQL > included.
I have an open-source project that does just this, and includes a number of helpful features aimed at providing flexible and robust connection logging. The project is available on GitHub: https://github.com/QueuingKoala/openvpn-db-log Due to recent interest, I tagged a 0.9.0 release today (see the release tab.) Notably lacking is logging of IPv6 VPN IPs issued to clients since this is not available to scripts today. I'm working to get this feature into OpenVPN, and will support it in this project when it is available. -- Josh ------------------------------------------------------------------------------ _______________________________________________ Openvpn-users mailing list Openvpn-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openvpn-users
