Problem connecting oracle database with odbc connector

[Fajar A. Nugraha]

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