Hello,
I’m trying to save cdr records in Oracle. I installed everthing but Oracle cdr tables is still empty.
I have installed Oracle Instant Client and I can connect to Oracle with using isql.
(I followed this great article to install Oracle drivers. itbdc.wordpress.com/2008/07/08/h … -products/)
My settings are following:
/etc/odbcinst.ini
[OracleODBC-10g]
Description = Oracle ODBC driver for Oracle 10g
Driver = /usr/lib/oracle/10.2.0.3/client/lib/libsqora.so.10.1
FileUsage = 1
Driver Logging = 7
/etc/odbc.ini
[OracleODBC-10g]
Driver = OracleODBC-10g
DSN = OracleODBC-10g
ServerName = 192.168.X.XXX
UserID = YYYYYY
Password = XXXXXXXX
res_odbc.conf
[TEST]
enabled => yes
dsn => OracleODBC-10g
username => YYYYYY
password => XXXXXXXX
pre-connect => yes
idlecheck => 3600
cdr_odbc.conf
[TEST]
dsn=OracleODBC-10g
username=YYYYYY
password=XXXXXXXX
loguniqueid=yes
dispositionstring=yes
table=cdr
usegmtime=no
/etc/oracle/tnsnames.ora
TEST=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.124)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = myservice)
)
)