Bug #10976
closedFreeradius dont start with SQL configuration
0%
Description
My Pfsense is 2.5
I tried run freeradius with mysql suport but the freeradius dont start. the follow error occur:
Oct 14 08:58:20 radiusd 34224 Debugger not attached
Oct 14 08:58:20 radiusd 34911 Could not link driver rlm_sql_mysql: Shared object "libmysqlclient.so.20" not found, required by "rlm_sql_mysql.so"
Oct 14 08:58:20 radiusd 34911 Make sure it (and all its dependent libraries!) are in the search path of your system's ld
Oct 14 08:58:20 radiusd 34911 /usr/local/etc/raddb/mods-enabled/sql2: Instantiation failed for module "sql1"
bellow, my config of
/usr/local/etc/raddb/mods-enabled/sql
sql sql1 {
database = "mysql"
driver = "rlm_sql_${database}"
dialect = "${database}"
server = "x.x.x.x"
port = 3306
login = "xxxx"
password = "xxxxx"
radius_db = "radius"
acct_table1 = "radacct"
acct_table2 = "radacct"
postauth_table = "radpostauth"
authcheck_table = "radcheck"
authreply_table = "radreply"
groupcheck_table = "radgroupcheck"
groupreply_table = "radgroupreply"
usergroup_table = "radusergroup"
read_groups = yes
delete_stale_sessions = yes
logfile = ${logdir}/sqltrace.sql
read_clients = yes
client_table = "nas"
pool {
start = ${thread[pool].start_servers}
min = ${thread[pool].min_spare_servers}
max = 5
spare = ${thread[pool].max_spare_servers}
uses = 0
retry_delay = 60
lifetime = 0
idle_timeout = 60
}
group_attribute = "${.:instance}-SQL-Group"
$INCLUDE ${modconfdir}/${.:name}/main/${dialect}/queries.conf
}