Hi all<br><br>I just manage to connect with oracle with the following URL :<br><br>modparam("sqlops","sqlcon","ca=>oracle://<a href="http://user:pass@alex.gr/cid_name.alex.gr">user:pass@alex.gr/cid_name.alex.gr</a>")<br>
<br>Now I run into other problems. The same query that from ./kamailio_orasel give me result, when I try that from kamailio.cfg I get an error and after that the system is getting very high load.<br><br>The error is :<br>
<br>kernel: kamailio[12442]: segfault at 0000000000000010 rip 00002b1b42952764 rsp 00007fff6b144d30 error 4<br><br>Does anyone had the same issue ?<br><br>Cheers<br>Alex<br><br><br><br><div class="gmail_quote">On Thu, Dec 31, 2009 at 10:51 AM, alex pappas <span dir="ltr"><<a href="mailto:rebel.pappas@gmail.com">rebel.pappas@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">HI Henning,<br><br>How was the restaurant last night? They have there great beer! ;-)<br><br>
I tried also :<br>modparam("sqlops","sqlcon","ca=>oracle://user/pass@IP:1521:cid")<br>but it gave me all the following errors<br>
<br><br>ERROR:db_oracle:db_oracle_new_connection: invalid parameter value <br>ERROR:core:db_do_init: could not add connection to the pool<br>ERROR:sqlops:sql_connect: failed to connect to the database [ca] <br><div class="im">
ERROR:core:init_mod_child: failed to initializing module sqlops, rank 2 <br>
ERROR:core:main_loop: init_child failed for UDP listener <br></div>ERROR:db_oracle:db_oracle_new_connection: invalid parameter value <br>ERROR:core:db_do_init: could not add connection to the pool<br>ERROR:sqlops:sql_connect: failed to connect to the database [ca] <br>
ERROR:core:init_mod_child: failed to initializing module sqlops, rank 3 <br><div class="im">ERROR:core:main_loop: init_child failed for UDP listener <br></div>INFO:mi_datagram:datagram_process: a new child 0/4893 <br> <br>
>From the script kamailio_orasel it runs only if I give the folowing format:<br>
<br>./kamailio_orasel user/pass@"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<a href="http://iota.alex.gr" target="_blank">iota.alex.gr</a>)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=<a href="http://cid_name.alex.gr" target="_blank">cid_name.alex.gr</a>)))" -e "select prefix from ported_numbers where number = '6937630910';"<br>
<br>When I try to add the above format in sqlops connection then I get many many errors..<br><br>have you any idea on how is the right way to write the sqlops URL ?<br><br>Cheers<br><font color="#888888">Alex</font><div>
<div></div><div class="h5"><br><br><br><br><div class="gmail_quote">
On Thu, Dec 31, 2009 at 12:05 AM, Henning Westerholt <span dir="ltr"><<a href="mailto:henning.westerholt@1und1.de" target="_blank">henning.westerholt@1und1.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>On Wed, December 30, 2009 8:43 pm, alex pappas wrote:<br>
> Dear friends I'm trying to setup a sqlops connection to an Oracle db. I<br>
> loaded the db_oracle module with (loadmodule "db_oracle.so") without<br>
> parameters. The connection string that I gave in sqlops module is :<br>
> modparam("sqlops","sqlcon","ca2=>user/pass@ip_addres:1521:db_name")<br>
><br>
> When i try to start kamailio I get the following errors and kamailio does<br>
> NOT start:<br>
><br>
> ERROR:core:db_check_api: module db_user/pass@ip does not export<br>
> db_use_table<br>
> function<br>
> ERROR:core:init_mod_child: failed to initializing module sqlops, rank 2<br>
> ERROR:core:main_loop: init_child failed for UDP listener<br>
<br>
</div>Hello Alex,<br>
<br>
you need to replace "db_name" with the name of a actual DB module. So for<br>
example "mysql", or "oracle" in your case. Here a complete example for<br>
mysql:<br>
<br>
modparam("sqlops","sqlcon","ca=>mysql://openser:abc@localhost/openser")<br>
<br>
Regards,<br>
<font color="#888888"><br>
Henning<br>
<br>
<br>
</font></blockquote></div><br>
</div></div></blockquote></div><br>