Problem connecting oracle database with odbc connector

Fajar A. Nugraha list at
Thu Sep 20 06:48:32 CEST 2018

On Thu, Sep 20, 2018 at 1:50 AM, Saurabh Lahoti <saurabh.astronomy at
> 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'.


More information about the Freeradius-Users mailing list