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

    how to config SQL in freeradius package

    Scheduled Pinned Locked Moved pfSense Packages
    5 Posts 2 Posters 1.1k 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.
    • E
      edicastro
      last edited by

      I tried to configure SQL in freeradius package but I dont has the sql schema of freeradius.

      alt text

      How to get SQL schema for pfsense freeradius config ?

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

        You'll find it here
        /usr/local/etc/raddb/mods-config/
        Using sql, so enter sql/
        Enter main/
        And enter mysql/
        where you find schema.sql
        Check also .sql files for examples.

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

        E 1 Reply Last reply Reply Quote 0
        • E
          edicastro @Gertjan
          last edited by

          @Gertjan work thank you, but users in table radcheck on database dont show in pfsense freeradius users tab. why?

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

            @edicastro said in how to config SQL in freeradius package:

            pfsense freeradius users tab. why?

            Because the implementation of the "users" list in the pfSense Freeradius isn't storing this list in the database (MySQL in this case). It's using it's own flat file.
            You could declare users in a SQL table (radcheck ?), but these won't het synced into this flat file.
            (Free)Radius has a huge list of possible operation possibilities. The pfSense GUI just choose some of them, and hard coded the into the GUI

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

            E 1 Reply Last reply Reply Quote 0
            • E
              edicastro @Gertjan
              last edited by

              @Gertjan said in how to config SQL in freeradius package:

              SQL table (radcheck ?)

              yes

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