Re: [SR-Users] kamailio with oracle data base
Take a look at the oracle instaclient: https://www.oracle.com/technetwork/database/database-technologies/instant-client/overview/index.html 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 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 > 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 > 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 > > 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 -- VoIP Embedded, Inc. http://www.voipembedded.com ___ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] kamailio with oracle data base
hello dears , is there any simple way to compile and add db_oracle module to kamailio 5.1.X ??? regards Eyas From: eyas barhouk 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<https://aka.ms/ghei36> From: Henning Westerholt 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 > 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
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<https://aka.ms/ghei36> From: Henning Westerholt 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 > 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
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 > 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
Re: [SR-Users] kamailio with oracle data base
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 () 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 > 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 >> *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 >> > ___ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] kamailio with oracle data base
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 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 > *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 > ___ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] kamailio with oracle data base
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 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
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