Problem with rlm_sql_oracle.so

andreiv andrei20blond at yahoo.com
Wed Aug 6 15:37:03 CEST 2008


I tried to insert accounting requests in oracle db, but the following error
occurs when i try to start the radius server : rlm_sql_oracle.so: cannot
open shared object file: No such file or directory


Module: Linked to module rlm_sql
 Module: Instantiating sql
  sql {
        driver = "rlm_sql_oracle"
        server = "localhost"
        port = ""
        login = "system"
        password = "manager"
        radius_db =
"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=orcl)))"
        read_groups = yes
        sqltrace = yes
        sqltracefile = "/usr/local/var/log/radius/sqltrace.sql"
        readclients = no
        deletestalesessions = yes
        num_sql_socks = 5
        sql_user_name = "%{User-Name}"
        default_user_profile = ""
        nas_query = "SELECT id,nasname,shortname,type,secret FROM nas"
        authorize_check_query = ""
        authorize_group_check_query = ""
        authorize_group_reply_query = ""
        accounting_onoff_query = ""
        accounting_update_query = ""
        accounting_update_query_alt = ""
        accounting_start_query = "INSERT into RADACCT (ID,
CALLING_STATION_ID, DATE, TIME, ID_APEL, LOCATION)  VALUES('',
'%{Calling-Station-Id}', '%{Setup-Date}', '%{Setup-Time}',
'%{Acct-Session-Id}', '%{Location}')"
        accounting_start_query_alt = ""
        accounting_stop_query = ""
        accounting_stop_query_alt = ""
        connect_failure_retry_delay = 60
        simul_count_query = ""
        simul_verify_query = ""
        postauth_query = ""
        safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
  }
rlm_sql (sql): Could not link driver rlm_sql_oracle: rlm_sql_oracle.so:
cannot open shared object file: No such file or directory
rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the
search path of your system's ld.
/usr/local/etc/raddb/sql.conf[22]: Instantiation failed for module "sql"
/usr/local/etc/raddb/sites-enabled/default[341]: Failed to find module
"sql".
/usr/local/etc/raddb/sites-enabled/default[313]: Errors parsing accounting
section.
 }
}
Errors initializing modules

Can anyone help ?

-- 
View this message in context: http://www.nabble.com/Problem-with-rlm_sql_oracle.so-tp18851356p18851356.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.




More information about the Freeradius-Users mailing list