Problem connecting oracle database with odbc connector
Saurabh Lahoti
saurabh.astronomy at gmail.com
Wed Sep 19 20:50:27 CEST 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..!!
More information about the Freeradius-Users
mailing list