Query pfSense user expiration date on command line?

  • Hey Y'all,

    We are using the local pfSense user database to manage OpenVPN users. We have set expiration dates for each user, such that their account will auto-disable when the expiration date comes.

    Is there any way, from a shell on the pfSense box, to query the expiration date of all the users at once? I'm looking to write a little script that queries the expiration dates of the users but I don't know what command would get me that data from a shell prompt...?

    Thanks for any hints! We are running 2.4.3-RELEASE-p1.


  • Rebel Alliance Developer Netgate

    There is no command that will query the local database users in that way, you'd have to write your own script.

    You could use the changepassword script as a starting point. It is in /etc/phpshellsessions/ and you run it from ssh or console shell with pfSsh.php playback changepassword for example.

Log in to reply