No subject


Wed Jun 24 00:39:36 CEST 2009


./kamailio_orasel user/pass@
"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=iota.alex.gr
)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=cid_name.alex.gr)))" -e "select
prefix from ported_numbers where number = '6937630910';"

When I try to add the above format in sqlops connection then I get many many
errors..

have you any idea on how is the right way to write the sqlops URL ?

Cheers
Alex



On Thu, Dec 31, 2009 at 12:05 AM, Henning Westerholt <
henning.westerholt at 1und1.de> wrote:

> On Wed, December 30, 2009 8:43 pm, alex pappas wrote:
> > Dear friends I'm trying to setup a sqlops connection to an Oracle db. I
> > loaded the db_oracle module with (loadmodule "db_oracle.so") without
> > parameters. The connection string that I gave in sqlops module is :
> > modparam("sqlops","sqlcon","ca2=>user/pass at ip_addres:1521:db_name")
> >
> > When i try to start kamailio I get the following errors and kamailio does
> > NOT start:
> >
> > ERROR:core:db_check_api: module db_user/pass at ip does not export
> > db_use_table
> > function
> > ERROR:core:init_mod_child: failed to initializing module sqlops, rank 2
> > ERROR:core:main_loop: init_child failed for UDP listener
>
> Hello Alex,
>
> you need to replace "db_name" with the name of a actual DB module. So for
> example "mysql", or "oracle" in your case. Here a complete example for
> mysql:
>
> modparam("sqlops","sqlcon","ca=>mysql://openser:abc@localhost/openser")
>
> Regards,
>
> Henning
>
>
>

--000325555e76eb0a76047c025a65
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

HI Henning,<br><br>How was the restaurant last night? They have there great=
 beer!=A0 ;-)<br><br>I tried also :<br>modparam(&quot;sqlops&quot;,&quot;sq=
lcon&quot;,&quot;ca=3D&gt;oracle://user/pass@IP:1521:cid&quot;)<br>but it g=
ave 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:sql=
ops:sql_connect: failed to connect to the database [ca] <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>ERROR:db_oracl=
e:db_oracle_new_connection: invalid parameter value <br>ERROR:core:db_do_in=
it: could not add connection to the pool<br>ERROR:sqlops:sql_connect: faile=
d to connect to the database [ca] <br>
ERROR:core:init_mod_child: failed to initializing module sqlops, rank 3 <br=
>ERROR:core:main_loop: init_child failed for UDP listener <br>INFO:mi_datag=
ram:datagram_process: a new child 0/4893 <br>=A0<br>From the script kamaili=
o_orasel it runs only if I give the folowing format:<br>
<br>./kamailio_orasel user/pass@&quot;(DESCRIPTION=3D(ADDRESS_LIST=3D(ADDRE=
SS=3D(PROTOCOL=3DTCP)(HOST=3D<a href=3D"http://iota.alex.gr">iota.alex.gr</=
a>)(PORT=3D1521)))(CONNECT_DATA=3D(SERVICE_NAME=3D<a href=3D"http://cid_nam=
e.alex.gr">cid_name.alex.gr</a>)))&quot; -e &quot;select prefix from ported=
_numbers where number =3D &#39;6937630910&#39;;&quot;<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 th=
e sqlops URL ?<br><br>Cheers<br>Alex<br><br><br><br><div class=3D"gmail_quo=
te">
On Thu, Dec 31, 2009 at 12:05 AM, Henning Westerholt <span dir=3D"ltr">&lt;=
<a href=3D"mailto:henning.westerholt at 1und1.de">henning.westerholt at 1und1.de<=
/a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"border-=
left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left=
: 1ex;">
<div class=3D"im">On Wed, December 30, 2009 8:43 pm, alex pappas wrote:<br>
&gt; Dear friends I&#39;m trying to setup a sqlops connection to an Oracle =
db. I<br>
&gt; loaded the db_oracle module with (loadmodule &quot;db_oracle.so&quot;)=
 without<br>
&gt; parameters. The connection string that I gave in sqlops module is :<br=
>
&gt; modparam(&quot;sqlops&quot;,&quot;sqlcon&quot;,&quot;ca2=3D&gt;user/pa=
ss at ip_addres:1521:db_name&quot;)<br>
&gt;<br>
&gt; When i try to start kamailio I get the following errors and kamailio d=
oes<br>
&gt; NOT start:<br>
&gt;<br>
&gt; ERROR:core:db_check_api: module db_user/pass at ip does not export<br>
&gt; db_use_table<br>
&gt; function<br>
&gt; ERROR:core:init_mod_child: failed to initializing module sqlops, rank =
2<br>
&gt; ERROR:core:main_loop: init_child failed for UDP listener<br>
<br>
</div>Hello Alex,<br>
<br>
you need to replace &quot;db_name&quot; with the name of a actual DB module=
. So for<br>
example &quot;mysql&quot;, or &quot;oracle&quot; in your case. Here a compl=
ete example for<br>
mysql:<br>
<br>
modparam(&quot;sqlops&quot;,&quot;sqlcon&quot;,&quot;ca=3D&gt;mysql://opens=
er:abc at localhost/openser&quot;)<br>
<br>
Regards,<br>
<font color=3D"#888888"><br>
Henning<br>
<br>
<br>
</font></blockquote></div><br>

--000325555e76eb0a76047c025a65--



More information about the Users mailing list