thanks for your kind reply dear Henning.

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.

Regards Eyas

________________________________ From: Henning Westerholt hw@kamailio.org Sent: Thursday, January 24, 2019 12:59 PM To: sr-users@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:

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 ?

Hello Eyas,

have a look to the db_oracle module:

https://kamailio.org/docs/modules/5.2.x/modules/db_oracle.html

Best regards,

Henning

-- Henning Westerholt - https://skalatan.de/blog/ Kamailio services - https://skalatan.de/services Kamailio security assessment - https://skalatan.de/de/assessment

These last 3 lines were pasted by error I think.

*= ODBC for Oracle* *= /usr/lib/oracle/12.1/client64/lib/libsqora.so.12.1* *= 1*

Cheers.

Diego

El jue., 24 ene. 2019 a las 10:52, Diego Nadares (dnadares@gmail.com) escribió:

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@hotmail.com escribió:

...

thanks for your kind reply dear Henning.

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.

Regards Eyas

---

*From:* Henning Westerholt hw@kamailio.org *Sent:* Thursday, January 24, 2019 12:59 PM *To:* sr-users@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:

...

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 ?

Hello Eyas,

have a look to the db_oracle module:

https://kamailio.org/docs/modules/5.2.x/modules/db_oracle.html

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@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Many thanks for your kind feedback dears.

I will try it and feedback.

Thanks again Regards Eyas

Get Outlook for Androidhttps://aka.ms/ghei36

________________________________ From: Henning Westerholt hw@kamailio.org Sent: Friday, January 25, 2019 10:54:07 AM To: eyas barhouk Cc: sr-users@lists.kamailio.org Subject: Re: [SR-Users] kamailio with oracle data base

Am Donnerstag, 24. Januar 2019, 14:34:15 CET schrieb eyas barhouk:

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.

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

---

From: Henning Westerholt hw@kamailio.org Sent: Thursday, January 24, 2019 12:59 PM To: sr-users@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:

...

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 ?

Hello Eyas,

have a look to the db_oracle module:

https://kamailio.org/docs/modules/5.2.x/modules/db_oracle.html

-- Henning Westerholt - https://skalatan.de/blog/ Kamailio services - https://skalatan.de/services Kamailio security assessment - https://skalatan.de/de/assessment

Take a look at the oracle instaclient: https://www.oracle.com/technetwork/database/database-technologies/instant-cl... Go to the download section and install the packages related to your architecture.

The makefile for the module works out of the box for oracle instaclient 12.2.0.1.0. For instaclient 18.3, the path for DEFS and LIBS most likely will need to be updated.

Regards, Ovidiu Sas

On Wed, Feb 13, 2019 at 5:35 AM eyas barhouk eyas37@hotmail.com wrote:

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@hotmail.com Sent: Friday, January 25, 2019 9:18 AM To: Henning Westerholt Cc: sr-users@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@kamailio.org Sent: Friday, January 25, 2019 10:54:07 AM To: eyas barhouk Cc: sr-users@lists.kamailio.org Subject: Re: [SR-Users] kamailio with oracle data base

Am Donnerstag, 24. Januar 2019, 14:34:15 CET schrieb eyas barhouk:

...

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.

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

...

---

From: Henning Westerholt hw@kamailio.org Sent: Thursday, January 24, 2019 12:59 PM To: sr-users@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:

...

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 ?

Hello Eyas,

have a look to the db_oracle module:

https://kamailio.org/docs/modules/5.2.x/modules/db_oracle.html

-- 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@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users