On Thu, Sep 20, 2018 at 1:50 AM, Saurabh Lahoti <saurabh.astronomy@gmail.com
wrote:
Hi,
While debugging freeradius build, following error is interpreted with odbc connector:
rlm_sql_unixodbc: IM002 [unixODBC][Driver Manager]Data source name not found and no default driver specified rlm_sql_unixodbc: Connection failed rlm_sql_unixodbc: Socket destructor called, closing socket rlm_sql (sqlADSL): Opening connection failed (0) rlm_sql (sqlADSL): Removing connection pool /usr/app/radius/etc/raddb/mods-enabled/sql[20]: Instantiation failed for module "sqlADSL"
The obvious question: can you use odbc to connect to the database? Test with isql (or similar tools) as user 'root' and 'freeradius' (or whatever user freeradius runs as). Make sure it works first before attempting to use it on FR.
My SQL config is as below:
sql sqlADSL { driver = "rlm_sql_unixodbc" server = "RadiusDbProd" port = 3306
I'm not sure, but if using odbc, it's probably 'radius_db' that is used instead of 'server' and 'port'. -- Fajar