<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<tt>Hi Sasmita,<br>
<br>
The param for is_from_gw() is wrong -> you put "1" while in DB
yu have type "0"<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 24.09.2015 15:07, Sasmita Panda
wrote:<br>
</div>
<blockquote
cite="mid:CALf-Q45vT1Lj0cJOA8d=cqr2LbAkuUAn3AEJPDVsJhg0UQYYnQ@mail.gmail.com"
type="cite">
<div dir="ltr">Hi Andrei,
<div><br>
</div>
<div> I am wanted to do lookup in location table when a call
comes from a gateway .</div>
<div>What should I do for that ?</div>
<div><br>
</div>
<div>I have added the gateway in the dr_gateways table like :</div>
<div>
<div>+----+------+------+--------------------+-------+------------+-------+------------+-------+--------+-------------+</div>
<div>| id | gwid | type | address | strip |
pri_prefix | attrs | probe_mode | state | socket |
description |</div>
<div>+----+------+------+--------------------+-------+------------+-------+------------+-------+--------+-------------+</div>
<div>| 1 | gw1 | 0 | <a moz-do-not-send="true"
href="http://192.1.1.1:5506">192.1.1.1:5506</a> | 0
| NULL | NULL | 0 | 0 | NULL |
|</div>
<div>+----+------+------+--------------------+-------+------------+-------+------------+-------+--------+-------------+</div>
</div>
<div><br>
</div>
<div> And in my cfg i have written like bellow </div>
<div>I have added the drouting module .</div>
<div>loadmodule "drouting.so"<br>
</div>
<div>...............</div>
<div>modparam("drrouting", "db_url",
"mysql://root:root@localhost/opensips")<br>
</div>
<div>
<div>modparam("drouting", "use_domain", 1)</div>
<div>modparam("drouting", "drd_table", "dr_gateways")</div>
<div>modparam("drouting", "drr_table", "dr_rules")</div>
<div>modparam("drouting", "drg_table", "dr_groups")</div>
<div>modparam("drouting", "drc_table", "dr_carriers")</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div>
<div> if( is_from_gw("1") || (to_uri=~"@<a
moz-do-not-send="true" href="http://192.1.1.161">192.1.1.161</a>"))</div>
<div> {</div>
<div><br>
</div>
<div> xlog( "L_WARN", "Source IP sas : $Ri
To Uri : $tu From : $fU Request URI: $oU Call ID:$ci" );</div>
<div> #
alias_db_lookup("dbaliases");</div>
<div> if ( !lookup("location")){</div>
<div> sl_send_reply("404","NO
Match Found");</div>
<div> #
cache_store("redis:group1","method,$ci","$rm,$Ts");</div>
<div> exit;</div>
<div> }</div>
</div>
<div> }</div>
<div><br>
</div>
<div>When I am calling from <a moz-do-not-send="true"
href="http://192.1.1.1:5506">192.1.1.1:5506</a> , then call
wont enter this loop .</div>
<div><br>
</div>
<div> What is wrong in the configuration and please let me
know if I need to do something else for this ?</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br clear="all">
<div>
<div class="gmail_signature">
<div dir="ltr"><b><i>Thanks & Regards</i></b>
<div><i>Sasmita Panda</i></div>
<div><i>Network Testing and Software Engineer</i></div>
<div><i>3CLogic , ph:07827611765</i></div>
</div>
</div>
</div>
<br>
<div class="gmail_quote">On Wed, Sep 23, 2015 at 7:15 PM,
Bogdan-Andrei Iancu <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:bogdan@opensips.org"
target="_blank">bogdan@opensips.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF"> <tt>Sasmita,<br>
<br>
The dr_rules table contains the routing rules - please
carefully read the module docs, as this is explained
over there.<br>
<br>
A routing rule refers to gateway directly, or via a
carrier. Using carriers is optional.<br>
<br>
Regards,<br>
</tt><span class="">
<pre cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre>
</span>
<div>
<div class="h5">
<div>On 23.09.2015 16:36, Sasmita Panda wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">HI Andrei ,
<div><br>
</div>
<div> Thank you for your reply . what ever you
said , that is only for the gateway . </div>
<div>What about the route table of lcr module ? I
think I need to add the route in dr_carrier
table .</div>
<div>But in which format ? If I am wrong then
what about the dr_carrier and dr_group table do
in dynamic routing module ?</div>
<div><br>
</div>
<div>Can you please give me a brief knowledge? </div>
</div>
<div class="gmail_extra"><br clear="all">
<div>
<div>
<div dir="ltr"><b><i>Thanks & Regards</i></b>
<div><i>Sasmita Panda</i></div>
<div><i>Network Testing and Software
Engineer</i></div>
<div><i>3CLogic , ph:07827611765</i></div>
</div>
</div>
</div>
<br>
<div class="gmail_quote">On Wed, Sep 23, 2015 at
1:54 PM, Bogdan-Andrei Iancu <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:bogdan@opensips.org"
target="_blank">bogdan@opensips.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0
0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF"> <tt>Hi
Sasmita,<br>
<br>
Build a routing group (1, for example as
this):<br>
<br>
Put in dr_rules:<br>
+--------+---------+--------+---------+----------+---------+--------+-------+-------------+<br>
| ruleid | groupid | prefix | timerec |
priority | routeid | gwlist | attrs |
description |<br>
+--------+---------+--------+---------+----------+---------+--------+-------+-------------+<br>
| 100 | 1 | |
| 0 | NULL |asterisk| NULL
| |<br>
+--------+---------+--------+---------+----------+---------+--------+-------+-------------+<br>
<br>
and it dr_gateways:<br>
+----+--------+------+----------------+-------+------------+-------+------------+-------+--------------------+-------------+<br>
| id | gwid | type | address |
strip | pri_prefix | attrs | probe_mode |
state | socket | description |<br>
+----+--------+------+----------------+-------+------------+-------+------------+-------+--------------------+-------------+<br>
| 1 |asterisk| 0 | <a
moz-do-not-send="true"
href="http://127.0.0.1:5080"
target="_blank">127.0.0.1:5080</a> |
0 | NULL | NULL | 0 |
0 | NULL | |<br>
+----+--------+------+----------------+-------+------------+-------+------------+-------+--------------------+-------------+<br>
<br>
<br>
Best regards,<br>
</tt>
<pre cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre>
<div>
<div>
<div>On 22.09.2015 15:16, Sasmita Panda
wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div>
<div dir="ltr">Hi All ,
<div><br>
</div>
<div> I am trying to upgrade
opensips-1.6 to opensips-1.11 . </div>
<div>As everybody know opensips-1.11
uses dynamic routing in place of
lcr module .</div>
<div><br>
</div>
<div> I have a simple scenario
and , I wanted to and a route and
a gateway for the particular route
so that my call get routed to the
gw .</div>
<div><br>
</div>
<div> In lcr tables my schema is
looking like bellow :</div>
<div><br>
</div>
<div>
<div>lcr routes</div>
<div>+----+--------+-----------------------------+--------+----------+</div>
<div>| id | prefix | from_uri
| grp_id |
priority |</div>
<div>+----+--------+-----------------------------+--------+----------+</div>
<div>| 4 | |
.*@xyz.xxx.com.* | 5
| 0 |</div>
<div><br>
</div>
<div>lcr gateways</div>
<div>+---------------+----------------+------+------------+-----------+--------+-------+------+-------+</div>
<div>| gw_name | ip_addr
| port | uri_scheme |
transport | grp_id | strip | tag
| flags |</div>
<div>+---------------+----------------+------+------------+-----------+--------+-------+------+-------+</div>
<div>| asterisk | 127.1.1.200
| 5080 | 1 |
1 | 5 | 0 | |
0 |</div>
</div>
<div><br>
</div>
<div>I have simply add a route and
for the same grp_id I have added a
gateway .</div>
<div><br>
</div>
<div> How I will do the same
thing in dynamic routing ? I have
gone through the document of
dynamic routing module . But I am
not able to understand the schema
.</div>
<div><br>
</div>
<div>Can anyone pleas help me , how
to proceed ??</div>
<div><br>
</div>
<div> <br clear="all">
<div>
<div>
<div dir="ltr"><b><i>Thanks
& Regards</i></b>
<div><i>Sasmita Panda</i></div>
<div><i>Network Testing and
Software Engineer</i></div>
<div><i>3CLogic ,
ph:07827611765</i></div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
</div>
</div>
<pre>_______________________________________________
Users mailing list
<a moz-do-not-send="true" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a moz-do-not-send="true" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</body>
</html>