Pfsense Freeradius2 sql not updating users in db



  • 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>


Locked