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

    Pfsense Freeradius2 sql not updating users in db

    Scheduled Pinned Locked Moved pfSense Packages
    1 Posts 1 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.
    • S
      skoenman
      last edited by

      Hello guys im having some issues with pfsense freeradius2 and mysql on another machine. For some reason it doesnt sync the usernames and groups from the database …. when i go and have a look in the database it doesnt show any data. But it does show it in the users field??? Any ideas ?? I see the radius connecting to the sql server without any issues.

      Jan 14 13:07:08 radiusd[96098]: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
      Jan 14 13:07:08 radiusd[96098]: rlm_sql (sql): Attempting to connect to radius@172.22.2.12:3306/radius
      Jan 14 13:07:08 radiusd[96098]: rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
      Jan 14 13:07:08 radiusd[96098]: rlm_sql_mysql: Starting connect to MySQL server for #0
      Jan 14 13:07:08 radiusd[96098]: rlm_sql (sql): Connected new DB handle, #0
      Jan 14 13:07:08 radiusd[96098]: rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
      Jan 14 13:07:08 radiusd[96098]: rlm_sql_mysql: Starting connect to MySQL server for #1
      Jan 14 13:07:08 radiusd[96098]: rlm_sql (sql): Connected new DB handle, #1
      Jan 14 13:07:08 radiusd[96098]: rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
      Jan 14 13:07:08 radiusd[96098]: rlm_sql_mysql: Starting connect to MySQL server for #2
      Jan 14 13:07:08 radiusd[96098]: rlm_sql (sql): Connected new DB handle, #2
      Jan 14 13:07:08 radiusd[96098]: rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
      Jan 14 13:07:08 radiusd[96098]: rlm_sql_mysql: Starting connect to MySQL server for #3
      Jan 14 13:07:08 radiusd[96098]: rlm_sql (sql): Connected new DB handle, #3
      Jan 14 13:07:08 radiusd[96098]: rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
      Jan 14 13:07:08 radiusd[96098]: rlm_sql_mysql: Starting connect to MySQL server for #4
      Jan 14 13:07:08 radiusd[96098]: rlm_sql (sql): Connected new DB handle, #4
      Jan 14 13:07:08 radiusd[96098]: Loaded virtual server <default>Jan 14 13:07:08 radiusd[96680]: Ready to process requests.

      Any help will help. Thanks</default>

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