DOES ANYONE HAVE ANY EXPERIENCE OF ASTERISK TO ORACLE
For the last 6 months trying to move my asterisk call logging from mysql to an Oracle DB. All existing questions raised on this forum do no show an answer, and have been through every asterisk/oracle resource I can find.
I have created the odbc/odbcinst ini files, and can connect to the database via isql without any problems, and retrieve data.
When connecting via asterisk, the message log states:
cdr_odbc.c: cdr_odbc: Unable to connect to datasource: ora11db
On the server where asterisk is located is a working 11db, which I can also connect to via other remote tools.
I have made the following configuration:
modules.conf - made sure that cdr_mysql is not loaded, and cdr_odbc is loaded.
The TNS connection via the listener is call ora11db, and also the DNS name in odbc.ini
Checking via the CLI, CDR shows the corect DNS, username and password.
There are configurations in cdr_odbc too.
Does anyone have a working CDR to unixodbc on Fedora ? I would be interested to compare configurations