i'm trying to build kamailio on top of oracle D.B so is there any way to configure kamailio to deal with Oracle D.B and call functions from it ?

Hi eyas! I used db_unixodbc module to connect with oracle. I had to configure these files. vim /etc/odbc.ini [mydb] Driver = ORACLE DSN = ORACLE ServerName = MyDB UserID = proxysip Password = proxysip vim /etc/odbcinst.ini [ORACLE] Description Driver FileUsage Driver Logging = 7 = ODBC for Oracle = /usr/lib/oracle/12.1/client64/lib/libsqora.so.12.1 = 1 #Test de la conexion isql -v mydb +---------------------------------------+ | Connected! || | sql-statement | help [tablename] | quit || +---------------------------------------+ Cheers, Diego El El jue, 24 ene. 2019 a las 10:35, eyas barhouk <eyas37(a)hotmail.com> escribió:

i already read it, but i didn't find any function on it or any configuration to setup the connection between kamailio and oracle database. if there is any document or tutorial about how to configure kamailio with oracle D.B and request a function from database it will be great & i will be thankful.

________________________________ From: Henning Westerholt <hw(a)kamailio.org> Sent: Thursday, January 24, 2019 12:59 PM To: sr-users(a)lists.kamailio.org Cc: eyas barhouk Subject: Re: [SR-Users] kamailio with oracle data base Am Donnerstag, 24. Januar 2019, 13:25:30 CET schrieb eyas barhouk: Hello Eyas, have a look to the db_oracle module: https://kamailio.org/docs/modules/5.2.x/modules/db_oracle.html

hello dears , is there any simple way to compile and add db_oracle module to kamailio 5.1.X ??? regards Eyas ________________________________ From: eyas barhouk <eyas37(a)hotmail.com> Sent: Friday, January 25, 2019 9:18 AM To: Henning Westerholt Cc: sr-users(a)lists.kamailio.org Subject: Re: [SR-Users] kamailio with oracle data base Many thanks for your kind feedback dears. I will try it and feedback. Thanks again Regards Eyas Get Outlook for Android ________________________________ From: Henning Westerholt <hw(a)kamailio.org> Sent: Friday, January 25, 2019 10:54:07 AM To: eyas barhouk Cc: sr-users(a)lists.kamailio.org Subject: Re: [SR-Users] kamailio with oracle data base Am Donnerstag, 24. Januar 2019, 14:34:15 CET schrieb eyas barhouk: Hello Eyas, another option would be to use the db_unixodbc module, as already mentioned. If you load a database module (e.g. db_oracle) you just need to specify the correct db URL in the modules that needs a database connection. The modules then created a connection to the database. This is documented in the respective module documentation. If you want to execute arbitrary queries on your database you can do this with the sqlops module. Not sure about the exact details related to oracle, but it should be somehow possible. Best regards, Henning -- Henning Westerholt - https://skalatan.de/blog/ Kamailio services - https://skalatan.de/services Kamailio security assessment - https://skalatan.de/de/assessment _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users