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>