OpenVPN Database

bversini

Hi,

I have a question about the OpenVPN integration in PFSense. What is the type of the database ? (SQL, file...) And where are the file of OpenVPN Database.

Il would like access to the database with external script (external to pfsense) for automation

jimp

What do you mean by "database"? There is no "OpenVPN database" as such.

What exactly are you wanting to access?

ilbicio

PfSense stores its entire configuration in the config.xml file.
THe best way I found for interacting with the configurationis using something like fauxAPI (https://github.com/ndejong/pfsense_fauxapi), which adds REST API capabilties to pfSense.
I don't think is supported and consistent through updates, but the project seems alive.

Gertjan

This works https://serverfault.com/questions/571592/how-to-view-connected-users-to-open-vpn-server

Running

killall -USR2 openvpn

dumps the connected users to the log file.

Remember to use 'clog' to access the log file /var/log/openvpn.log.

bversini

Thanks @ilbicio
I want to create user by external (and automated) process (eg: an "Admin Panel") for my customer.