Oracle ODBC DSN not working .

[rahulsonawane1518]

Describe the bug

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')

[petereames]

Can you confirm what company you work for? that'd help us look into this.

[rahulsonawane1518]

I am working for Reliance Industries Limited. Regards, Rahul +918451805927

…

On Sat, 19 Oct 2024 at 12:13 AM, petereames ***@***.***> wrote: Can you confirm what company you work for? that'd help us look into this. — Reply to this email directly, view it on GitHub <#2610 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BBG2QVGIHHDTXJBIKTFTKLLZ4FJGJAVCNFSM6AAAAABO6RHUYSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIMRTGA2DCMZUGU> . You are receiving this because you authored the thread.Message ID: ***@***.***>