Problem connecting oracle database with odbc connector

19 Sep 2018

      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"

My SQL config is as below:

sql sqlADSL {
        driver = "rlm_sql_unixodbc"
        server = "RadiusDbProd"
        port = 3306
        login = "radius"
        password = <<< secret >>>
        radius_db = "RADSP01"
        read_groups = yes
        read_profiles = yes
        read_clients = no
        delete_stale_sessions = yes
        sql_user_name = ""
        logfile = "/usr/app/Radiuslogs/anathana/sqltrace_ADSL.sql"
        default_user_profile = ""
        client_query = "SELECT id,nasname,shortname,type,secret FROM nas"
        safe_characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
   accounting {
        reference = ".query"
    type {
     accounting-on {
     }
     accounting-off {
     }
     start {
     }
     interim-update {
     }
     stop {
     }
    }
   }
   post-auth {
        reference = ".query"
   }
  }

Could you help please..?
----

*Thanks & Kind Regards,*
Saurabh LAHOTI.
*Ideas enlighten Innovation**!!!*
Please consider the environment before printing this mail..!!

Problem connecting oracle database with odbc connector

Saurabh Lahoti