Freeswitch Ubuntu to Oracle ODBC DSN not working

FreeSWITCH Troubleshooting
1

@ShaneHarrell-SW @BrianWest-SW

Using Odbc-dsn
Error
2024-09-27 12:16:13.921369 [ERR] switch_odbc.c:368 STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found and no default driver specified

2024-09-27 12:16:13.921369 [CRIT] switch_core_sqldb.c:646 Failure to connect to ODBC gvpivrdb_admin!
2024-09-27 12:16:13.921369 [ERR] mod_odbc_cdr.c:189 Error Opening DB
2024-09-27 12:16:13.921369 [CRIT] mod_odbc_cdr.c:486 Cannot open DB!
2024-09-27 12:16:13.921369 [CRIT] switch_loadable_module.c:1785 Error Loading module /usr/local/freeswitch/mod/mod_odbc_cdr.so
Module load routine returned an error

Configuration
Odbc.conf.xml

-------------------------------------------------------------------------------------- Configuration suggested by FS

Link ini files to FreeSWITCH Directory

mkdir /usr/local/freeswitch/etc
ln -s /etc/odbcinst.ini /usr/local/freeswitch/etc/odbcinst.ini
ln -s /etc/odbc.ini /usr/local/freeswitch/etc/odbc.ini

Working DSN fine in ubuntu
root@jmngd1bah070v8:/usr/local/freeswitch/conf/autoload_configs# sqlplus abc/xyz@JAASITDB

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Sep 27 12:33:56 2024
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Last Successful login time: Fri Sep 27 2024 12:31:10 +05:30

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.24.0.0.0

Problem with core-db-dsn

Configurtion

Module loading with core-db-dsn
2024-09-27 12:37:17.121371 [CONSOLE] switch_loadable_module.c:1803 Successfully Loaded [mod_odbc_cdr]
2024-09-27 12:37:17.121371 [INFO] switch_time.c:1430 Timezone reloaded 1750 definitions

Error with core-db-dsn we are not getting the table itself but table is present in DB

2024-09-27 12:39:47.341368 [ERR] switch_core_sqldb.c:732 [db=“odbc_cdr”,type=“core_db”] NATIVE SQL ERR [no such table: CDR_TABLE_A_LEG]
INSERT INTO CDR_TABLE_A_LEG (sip_hangup_disposition, digits_dialed, direction, answer_stamp, start_stamp, q850, MOS, TelNumberFull, prmid, CallId, call_result, sip_endpoint_disposition, orig_id, CallerID, CODEC, sip_current_application, IPInternal, IP, duration, term_id, ClientId, end_stamp) VALUES (‘recv_bye’, ‘none’, ‘outbound’, ‘2024-09-27 12:39:38’, ‘2024-09-27 12:39:34’, ‘16’, ‘4.31’, ‘12988451805927’, ‘6800001’, ‘a165a024-5f38-4e2a-9731-49393667d302’, ‘NORMAL_CLEARING’, ‘ANSWER’, ‘a165a024-5f38-4e2a-9731-49393667d302’, ‘1001’, ‘PCMU’, ‘jal_dev’, ‘10.144.16.165’, ‘10.144.21.242’, ‘9’, ‘4a50966d-f742-123d-07b2-0050569168a0’, ‘123456789’, ‘2024-09-27 12:39:47’)

2024-09-27 12:39:47.341368 [ERR] mod_odbc_cdr.c:348 Error executing query INSERT INTO CDR_TABLE_A_LEG (sip_hangup_disposition, digits_dialed, direction, answer_stamp, start_stamp, q850, MOS, TelNumberFull, prmid, CallId, call_result, sip_endpoint_disposition, orig_id, CallerID, CODEC, sip_current_application, IPInternal, IP, duration, term_id, ClientId, end_stamp) VALUES (‘recv_bye’, ‘none’, ‘outbound’, ‘2024-09-27 12:39:38’, ‘2024-09-27 12:39:34’, ‘16’, ‘4.31’, ‘12988451805927’, ‘6800001’, ‘a165a024-5f38-4e2a-9731-49393667d302’, ‘NORMAL_CLEARING’, ‘ANSWER’, ‘a165a024-5f38-4e2a-9731-49393667d302’, ‘1001’, ‘PCMU’, ‘jal_dev’, ‘10.144.16.165’, ‘10.144.21.242’, ‘9’, ‘4a50966d-f742-123d-07b2-0050569168a0’, ‘123456789’, ‘2024-09-27 12:39:47’)

2

What version of FreeSWITCH?

3

@LenGraham-sw We are using FreeSWITCH Version 1.10.6-release, also we tried in Windows with latest updated version still getting the issue when using core-db-dsn

4

@LenGraham-sw @BrianWest-SW @mickael, By any chance, have you had time to look into it?