Project

General

Profile

Actions

Bug #10976

closed

Freeradius dont start with SQL configuration

Added by Edivan Carneiro de castro over 3 years ago. Updated about 3 years ago.

Status:
Rejected
Priority:
High
Assignee:
-
Category:
FreeRADIUS
Target version:
-
Start date:
10/14/2020
Due date:
% Done:

0%

Estimated time:
Plus Target Version:
Affected Version:
Affected Plus Version:
Affected Architecture:

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
}

Actions #1

Updated by Viktor Gurov over 3 years ago

  • Category set to FreeRADIUS
  • Status changed from New to Rejected

no such issue on pfSense 2.5.0.a.20201013.1850 with FreeRADIUS pkg 0.15.7_18:

Wed Oct 14 18:15:02 2020 : Info: rlm_sql (sql1): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
Wed Oct 14 18:15:02 2020 : Info: rlm_sql_mysql: libmysql version: 5.7.31
Wed Oct 14 18:15:02 2020 : Info: rlm_sql (sql1): Attempting to connect to database "radius" 
...

Please update to the latest snapshot / pkg and use https://forum.netgate.com/ for further discussion

Actions #2

Updated by Viktor Gurov about 3 years ago

see #11001

Actions

Also available in: Atom PDF