Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    Saving PFSense Admin Users on MySQL. is it Possible?

    Scheduled Pinned Locked Moved General pfSense Questions
    3 Posts 3 Posters 779 Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • D
      dmaxeeman
      last edited by

      Good Day

      I'm New on using PFSense, my i ask if is it possible to save admin users on a MySQL database?( if it is possible may i ask how would you do it :) ) and also where can i found the database of the Admin Users of PFSense.

      Thanks in Advance!

      1 Reply Last reply Reply Quote 0
      • GertjanG
        Gertjan
        last edited by

        Hi,
        @dmaxeeman:

        where can i found the database of the Admin Users of PFSense.

        With pfSense GUI => Diagnostics => Backup/restore you save (or load) all settings.
        All settings are stored in ONE file, called config.xcml

        @dmaxeeman:

        …  it possible to save admin users on a MySQL database?( if it is possible may i ask how would you do it :) )

        I guess its not possible.

        But, if you know what PHP is, and you can read/write it yourself, MySQL can be added to PHP used on pfSense.
        Then, you (YOU !) have to write some code.
        pfSense uses a local Manager (which stores everything in the 'config.xml' file) but this can be rewritten.

        Btw: a router/firewall that needs a MySQL server so people can login …. that's a little bit dangerous. If the MySQL server is down, you'll be locked out.

        No "help me" PM's please. Use the forum, the community will thank you.
        Edit : and where are the logs ??

        1 Reply Last reply Reply Quote 0
        • D
          doktornotor Banned
          last edited by

          Do yourself a big favour and use LDAP, if you want centralized auth usable pretty much for everything.

          1 Reply Last reply Reply Quote 0
          • First post
            Last post
          Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.