• Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Search
  • Register
  • Login
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 723 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 Aug 10, 2015, 6:47 AM

    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
    • G
      Gertjan
      last edited by Aug 10, 2015, 8:00 AM

      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 Aug 10, 2015, 9:04 AM

        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
        3 out of 3
        • First post
          3/3
          Last post
        Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.
          This community forum collects and processes your personal information.
          consent.not_received