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

    Freeradius with oracle support in addition to mysql and postgresql

    Scheduled Pinned Locked Moved pfSense Packages
    2 Posts 2 Posters 568 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.
    • S
      starless_boi
      last edited by

      Hi there.
      thanks for great product
      inf pfsense, freeradius module only supports Mysql and PostgreSQL to connect for SQL base databases..at least what i see in webgui.
      is there any way to use oracle as backend database to connect freeradius? from webgui or shell
      is there any plan to add this option in webgui in near future?
      Thanks

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

        Hi,

        If you are ready to do some keyboard work, I guess it's possible :

        Enter console mode, and go to God mode (option 8).

        Goto the settings directory :

        cd /usr/local/etc/raddb/
        

        and ask if this  FreeRadius knows anything about 'oracle' :

        grep -R 'oracle' *
        
        

        You will see this :

        mods-available/sql:#  Where "DB" is mysql, mssql, oracle, or postgresql.
        mods-available/sql:     #    * rlm_sql_oracle
        mods-config/sql/ippool-dhcp/oracle/queries.conf:#  ippool-dhcp/oracle/queries.conf -- Oracle queries for dhcp-ippool
        mods-config/sql/ippool/oracle/queries.conf:#  ippool/oracle/queries.conf -- Oracle queries for rlm_sqlippool
        mods-config/sql/main/oracle/queries.conf:#  main/oracle/queries.conf -- Oracle configuration for default schema (schema.sql)
        
        

        The major part about how to set it up is there … but : FreeRadius needs a 'driver' that can talk to Oracle.
        The settings will learn you that the driver name of MySQL is "rlm_sql_mysql". For Oracle this would be  "rlm_sql_oracle" ...
        Check here :

        cd /usr/local/lib/freeradius-3.0.15
        ls -al
        

        Bad news : no Oracle driver in the FreeRadius 3.x package … (maybe you borrow a copy from an original FreeBSD 11.1 (current FreeBSD kernel used by pfSense) "FreeRadius" package ..

        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
        • First post
          Last post
        Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.