Hello, please help me with SQL integration

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


Hello,
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

Then
change settings /usr/local/etc/raddb/mods-enabled/sql
login and password for connection to mysql
and 
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
with
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. 

Alan


More information about the Freeradius-Users mailing list