hello all,
I would like to use asterisk realtime with oracle and SIP , extensions tables.
my OS is CENTOS 6.5 x64
Asterisk 11
I installed
oracle-instantclient12.1-odbc-12.1.0.1.0-1.x86_64.rpm
oracle-instantclient12.1-sqlplus-12.1.0.1.0-1.x86_64.rpm
oracle-instantclient12.1-basic-12.1.0.1.0-1.x86_64.rpm
my configuration:
“cd /etc/odbcinst.ini”:
[OracleODBC-12.1]
Description = Oracle ODBC driver for Oracle
Driver = /usr/lib/oracle/12.1/client64/lib/libsqora.so.12.1
Setup = /usr/lib/oracle/12.1/client64/lib/libsqora.so.12.1
FileUsage = 1
Driver Logging = 7
“cd /etc/odbc.ini”:
[asteriskrealtime]
Application Attributes = T
Attributes = W
BatchAutocommitMode = IfAllSuccessful
BindAsFLOAT = F
CloseCursor = F
DisableDPM = F
DisableMTS = T
Driver = OracleODBC-12.1
DSN = asteriskrealtime
EXECSchemaOpt =
EXECSyntax = T
Failover = T
FailoverDelay = 10
FailoverRetryCount = 10
FetchBufferSize = 64000
ForceWCHAR = F
Lobs = T
Longs = T
MetadataIdDefault = F
QueryTimeout = T
ResultSets = T
ServerName = //XX.XX.XX.XX:1522/DBast
SQLGetData extensions = F
Translation DLL =
Translation Option = 0
DisableRULEHint = T
UserID = asterisk
Password = asterisk
Port = 1522
“cd /etc/asterisk/res_odbc.conf”:
[ENV]
ORACLE_HOME => /usr/lib/oracle/12.1/client64
LD_LIBRARY_PATH => /usr/lib/oracle/12.1/client64/lib
TWO_TASK => //XX.XX.XX.XX:1522/DBast
[asteriskrealtime]
enabled => yes
dsn => asteriskrealtime
username => asterisk
password => asterisk
Connection test:
isql -v asteriskrealtime
±--------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
±--------------------------------------+
SQL>
PROBLEM IS :
asterisk -rvvv
[May 26 13:47:16] NOTICE[19944]: res_odbc.c:793 load_odbc_config: Adding ENV var: ORACLE_HOME=/usr/lib/oracle/12.1/client64
[May 26 13:47:16] NOTICE[19944]: res_odbc.c:793 load_odbc_config: Adding ENV var: LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib
[May 26 13:47:16] NOTICE[19944]: res_odbc.c:793 load_odbc_config: Adding ENV var: TWO_TASK=//78.192.180.239:1522/DBast
[May 26 13:47:16] NOTICE[19944]: res_odbc.c:1537 odbc_obj_connect: Connecting asteriskrealtime
[May 26 13:47:16] WARNING[19944]: res_odbc.c:1562 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Can’t open lib ‘/usr/lib/oracle/12.1/client64/lib/libsqora.so.12.1’ : file not found
how I can resolve this problem with “libsqora.so.12.1”
thank you
HESNAUX