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

    Freeradius2 and SQlite backend

    Scheduled Pinned Locked Moved pfSense Packages
    2 Posts 2 Posters 1.2k 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.
    • F
      fsantaana
      last edited by

      has anyone had any success getting the Freeradius2 package to work with a SQLite backend DB?

      I tried to modify the freeradius.inc and add the config for SQL.conf but all i get is that the service no longer starts.

      I added the filename = to the SQL sql section of the SQL.conf and changed the database = sqlite. i'm guessing it doesn't have the sqlite driver. I looked on google and see that it is possible to connect to a sqlite DB using freeradius 2 and all that is needed should be the filename.

      I also saw that the freeradius 3 allows for sqlite by default. Is there a way to update the package to FR3? if that is the direction i must go.

      is there something else that i might be missing?

      any help or ideas would be appreciated.

      1 Reply Last reply Reply Quote 0
      • N
        Nachtfalke
        last edited by

        Hi,

        you could run freeradius in debugging mode with radiusd -X and have a look what is missing when using sqlite. If you change any files manually then you must not do any changes on GUI because this could overwrite your changes.

        Updatung to freeradius3 will be probably not possible with the existing GUI. Freeradius3 is a complete new developement and the config is - as far as I know - not compatible with freeradius2.

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