[SR-Users] kamailio with oracle data base

[Ovidiu Sas]

You need to use db_oracle just like any other db. Kamailio modules
that are using a db will make use of it.
For raw queries into the oracle db you can use the sqlops module.
Make sure that you use the db_oracle module in synchronous mode:
modparam("db_oracle", "timeout", "0")

The db url for oracle connections is in this format:
"oracle://[USER]:[PASSWORD]@[CONNECT_IDENTIFIER]"
For sqlops module:
"ca=>oracle://[USER]:[PASSWORD]@[CONNECT_IDENTIFIER]"

Regards,
Ovidiu Sas

On Thu, Jan 24, 2019 at 8:34 AM eyas barhouk <eyas37 at hotmail.com> wrote:
>
> 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 at kamailio.org>
> Sent: Thursday, January 24, 2019 12:59 PM
> To: sr-users at 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 at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users



-- 
VoIP Embedded, Inc.
http://www.voipembedded.com