Hello, please help me with SQL integration

For Sinton forsin at inbox.kg
Fri Feb 28 03:35:34 CET 2014

I completely deleted freeradius: 
pkg remove freeradius3 
further renamed folder 
mv / usr / local / etc / raddb / usr/local/etc/raddb_old2 
install freeradius3 again
pkg install freeradius3
created a link with ln-s ln -s /usr/local/etc/raddb/mods-available/sql  /usr/local/etc/raddb/mods-enabled/sql
root at gateway:/usr/local/etc/raddb/mods-enabled # ls -al sql
lrwxr-xr-x  1 root  freeradius  39 Feb 28 07:10 sql -> /usr/local/etc/raddb/mods-available/sql

change settings /usr/local/etc/raddb/mods-enabled/sql
login and password for connection to mysql
read_groups = no

in default i replaced -sql with sql

one small question in file /usr/local/etc/raddb/mods-available/sql where is one section
sql {
# The sub-module to use to execute queries. This should match
# the database you're attempting to connect to.
#    * rlm_sql_mysql
#    * rlm_sql_mssql
#    * rlm_sql_oracle
#    * rlm_sql_postgresql
#    * rlm_sql_sqlite
#    * rlm_sql_null (log queries to disk)
if i'm using this:
driver = "rlm_sql_mysql"

i got:
Could not link driver rlm_sql_mysql: Shared object "rlm_sql_mysql.so" not found, required by "radiusd"
Make sure it (and all its dependent libraries!)are in the search path of your system's ld.
/usr/local/etc/raddb/mods-enabled/sql[47]: Instantiation failed for module "sql"

and there is no file rlm_sql_mysql.so in /usr/local/lib/freeradius-3.0.1

anyway ... issue fixed, i recompiled freeradius
./configure --without-rlm_krb5 --without-rlm_ldap --with-rlm_sql_mysql --prefix=/usr/local/freeradius

and now everything works ... Yahoooo :))

Thank you

----- Исходное сообщение -----
От: "Alan Buxey" <A.L.M.Buxey at lboro.ac.uk>
Кому: "FreeRadius users mailing list" <freeradius-users at lists.freeradius.org>, "For Sinton" <forsin at inbox.kg>
Отправленные: Пятница, 28 Февраль 2014 г 2:01:56
Тема: Re: Hello, please help me with SQL integration

.... and your last config appeared to show a config with everything but sql stripped out of it. That won't work. 

Take the default config and just uncomment sql in the eg authorize section. 


More information about the Freeradius-Users mailing list