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@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@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