Ivan Kalik wrote:
I have read the sql how to and to my knowledge I have configured sql.conf correctly.
I am not certain about radiusd.conf it has the sql.conf include but when I run radiusd -X i don't see it loading the rlm_sql driver and I ran a netstat and I never see a sql connection.
attached are my config files any help you can provided is very appreciated.
I am thinking that when I compiled freeradius it didn't include the rlm_sql driver.
it would be helpful to know if I need to do a --with option in the ./configure when I complile it. the sql documentation said that I needed to do it but it didn't say how I would go about doing it.
No, it's not that. It's:
###################################################################### # # As of 2.0.0, the "authorize", "authenticate", etc. sections # are in separate configuration files, per virtual host. # ######################################################################
They are not in radiusd.conf anymore (sorry). In your version they should be in sites-enabled configuration files. Find sql entries in those sections and uncomment them.
Ivan Kalik Kalik Informatika ISP
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
thank you for your help I was able to find where to enable the sql but now I get this error. rlm_sql (sql): Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object file: No such file or directory rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. /usr/local/etc/raddb/sql.conf[21]: Instantiation failed for module "sql" /usr/local/etc/raddb/sites-enabled/default[124]: Failed to find module "sql". /usr/local/etc/raddb/sites-enabled/default[34]: Errors parsing authorize section.