<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>The only moment OpenSIPS reads from DB is at startup.....at
runtime it only writes into DB (flushing the memory cache). So,
just pending record (in DB only) might have been added without
OpenSIPS being aware or they are bogus records which OpenSIPS
refuses to load.<br>
<br>
Check the expire time of those records ; also check for
errors/warnings from OpenSIPS when starting up - maybe it is
rejecting those records.<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>
OpenSIPS Summit May 2017 Amsterdam
<a class="moz-txt-link-freetext" href="http://www.opensips.org/events/Summit-2017Amsterdam.html">http://www.opensips.org/events/Summit-2017Amsterdam.html</a>
</pre>
<div class="moz-cite-prefix">On 04/05/2017 11:32 AM, Sasmita Panda
wrote:<br>
</div>
<blockquote
cite="mid:CALf-Q45g9HVjaP-1eRZftrj5QfLYwZuh0J3ZAFfcxgCxddhM5A@mail.gmail.com"
type="cite">
<div dir="auto">Ohk. I got it. You are saying, if I am using two
instance using single DB then both the instance must have same
scheme of writing domain.
<div dir="auto"><br>
</div>
<div dir="auto"> If I will make show, then everything will
be fine. </div>
<div dir="auto"><br>
</div>
<div dir="auto"> Yesterday, I have done the same setup,
but still when contact are present in the DB, in the same
time they are not visible in memory. </div>
<div dir="auto"> I am using same command </div>
<div dir="auto">opensipsctl fifo ul_dump : to see the memory </div>
<div dir="auto">opensipsctl dB exec " select * from location" :
to see the dB entry. </div>
<div dir="auto"><br>
</div>
<div dir="auto"> The machine in which I am using single
instance of opensips, they are absolutely fine. </div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Apr 5, 2017 1:30 PM, "Bogdan-Andrei
Iancu" <<a moz-do-not-send="true"
href="mailto:bogdan@opensips.org">bogdan@opensips.org</a>>
wrote:<br type="attribution">
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> <tt>Bingo...that is
your problem... Don't you think there is a bit of a
conflict in having 2 OpenSIPS with different use_domain
setting working over the same "location" table ? one
OpenSIPS is writing records without domain, the other is
complaining about reading record without :)<br>
<br>
Use different tables or databases.<br>
<br>
Regards,<br>
</tt>
<pre class="m_6252145392861642982moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" class="m_6252145392861642982moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.<wbr>com</a>
OpenSIPS Summit May 2017 Amsterdam
<a moz-do-not-send="true" class="m_6252145392861642982moz-txt-link-freetext" href="http://www.opensips.org/events/Summit-2017Amsterdam.html" target="_blank">http://www.opensips.org/<wbr>events/Summit-2017Amsterdam.<wbr>html</a>
</pre>
<div class="m_6252145392861642982moz-cite-prefix">On 04/05/2017 04:35 AM, Sasmita Panda
wrote:
</div>
<blockquote type="cite">
<div dir="auto">Yes... Both are sharing same DB. </div>
<div class="gmail_extra">
<div class="gmail_quote">On Apr 4, 2017 11:08 PM, "Bogdan-Andrei
Iancu" <<a moz-do-not-send="true" href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>>
wrote:
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> <tt>Are the 2
instances sharing the same database ?
Regards,
</tt>
<pre class="m_6252145392861642982m_8403115127019008851moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" class="m_6252145392861642982m_8403115127019008851moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.<wbr>com</a>
OpenSIPS Summit May 2017 Amsterdam
<a moz-do-not-send="true" class="m_6252145392861642982m_8403115127019008851moz-txt-link-freetext" href="http://www.opensips.org/events/Summit-2017Amsterdam.html" target="_blank">http://www.opensips.org/events<wbr>/Summit-2017Amsterdam.html</a>
</pre>
<div class="m_6252145392861642982m_8403115127019008851moz-cite-prefix">On 04/04/2017 06:59 PM, Sasmita Panda
wrote:
</div>
<blockquote type="cite">
<div dir="auto">I am running two different configuration file in a
machine with differ port.
<div dir="auto">
</div>
<div dir="auto"> In one configuration file, use_domain is
disable and in another it's enable. </div>
<div dir="auto">
</div>
<div dir="auto"> In this case, I am not able to see those
contacts in memory which are getting saved without domain. </div>
<div dir="auto"> </div>
<div dir="auto"> Is that can be a reason? I have tried a
lot to know the exact reason. But every time I am seeing
different behaviour. </div>
<div dir="auto">
</div>
<div dir="auto"> The system in which a single
configuration is running, that's working absolutely fine. </div>
<div dir="auto">
</div>
<div dir="auto"> I am stuck in this issue. </div>
</div>
<div class="gmail_extra">
<div class="gmail_quote">On Apr 4, 2017 4:49 PM, "Bogdan-Andrei
Iancu" <<a moz-do-not-send="true" href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>>
wrote:
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> <tt>Well, if the
"use_domain" is enabled for usrloc, OpenSIPS expects to
find a domain set for all the records in the "location"
table, otherwise it will ignore/discard them at loading
time.
The primary storage for registered contacts in the
memory cache - OpenSIPS will perform lookups only in
memory cache (and not it DB) - of course, unless you use
the DB ONLY mode.
You can check the in-memory registrations by
"opensipsctl ul dump"
Regards,
</tt>
<pre class="m_6252145392861642982m_8403115127019008851m_-467242501914628577moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" class="m_6252145392861642982m_8403115127019008851m_-467242501914628577moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.<wbr>com</a>
OpenSIPS Summit May 2017 Amsterdam
<a moz-do-not-send="true" class="m_6252145392861642982m_8403115127019008851m_-467242501914628577moz-txt-link-freetext" href="http://www.opensips.org/events/Summit-2017Amsterdam.html" target="_blank">http://www.opensips.org/events<wbr>/Summit-2017Amsterdam.html</a>
</pre>
<div class="m_6252145392861642982m_8403115127019008851m_-467242501914628577moz-cite-prefix">On 04/04/2017 01:39 PM, Sasmita Panda
wrote:
</div>
<blockquote type="cite">
<div dir="ltr">Hi Bogdan ,
<div>
</div>
<div> Yes , the domain corresponding to this username is
empty . But the domain for all the contact is not empty . </div>
<div>
</div>
<div>
</div>
<div> When the domain for a contact is not empty and its
present in the DB , I am not getting that in the memory . What
could be the reason for this .</div>
<div>
</div>
<div> Another strange thing happening . When I am setting
db_mode :2 , even if a contact is not present in the memory
(but present in db)</div>
<div>the call get connected . I was assuming when there is no
contact in the memory it should send "404 Not Found" . </div>
<div>
</div>
<div> When I am running opensips in AWS linux , everything
works fine . I am not seeing any issue regarding updating
memory .</div>
<div>But when I am running this in centos 7 , there is problem
in updating memory in every refresh . </div>
<div>
</div>
<div>
</div>
<div> So where was the problem . opensips is version is same
every where . My config file is same everywhere . But still
there is difference . Why this is happening ? </div>
<div> </div>
<div>
</div>
</div>
<div class="gmail_extra">
<div>
<div class="m_6252145392861642982m_8403115127019008851m_-467242501914628577gmail_signature" data-smartmail="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>
<div class="gmail_quote">On Tue, Apr 4, 2017 at 3:22 PM,
Bogdan-Andrei Iancu <span dir="ltr"><<a moz-do-not-send="true" class="m_6252145392861642982m_8403115127019008851m_-467242501914628577moz-txt-link-abbreviated" href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>></span> wrote:
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> <tt>Hello Sasmita,
The error means that at startup time (preloading the
usrloc content from DB into memory), OpenSIPS finds a
record (in the "location" table) with an empty domain
field (username '1111') - could you confirm this by
checking your DB ?
Best regards,
</tt>
<pre class="m_6252145392861642982m_8403115127019008851m_-467242501914628577m_-4777611178439648847moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" class="m_6252145392861642982m_8403115127019008851m_-467242501914628577m_-4777611178439648847moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.<wbr>com</a>
OpenSIPS Summit May 2017 Amsterdam
<a moz-do-not-send="true" class="m_6252145392861642982m_8403115127019008851m_-467242501914628577m_-4777611178439648847moz-txt-link-freetext" href="http://www.opensips.org/events/Summit-2017Amsterdam.html" target="_blank">http://www.opensips.org/events<wbr>/Summit-2017Amsterdam.html</a>
</pre><div><div class="m_6252145392861642982m_8403115127019008851m_-467242501914628577h5">
<div class="m_6252145392861642982m_8403115127019008851m_-467242501914628577m_-4777611178439648847moz-cite-prefix">On 03/31/2017 01:06 PM, Sasmita Panda
wrote:
</div>
</div></div><blockquote type="cite"><div><div class="m_6252145392861642982m_8403115127019008851m_-467242501914628577h5">
<div dir="ltr">
<div>Hi All ,</div>
<div>
</div>
I am using opensips-1.11 from long time . But today i faced
some issue .
<div>when a username det rigistered , it givind some error in
the logs like bellow .</div>
<div>
</div>
<div><b>CRITICAL:usrloc:preload_udomai<wbr>n: empty domain for user
1111...skipping </b></div>
<div><b>
</b></div>
<div><b> I am getting that entry in the DB but I am not
getting anything in the memory . Every call to this number
failing with error 404 Not found .</b></div>
<div><b>
</b></div>
<div><b> </b></div>
<div><b>loadmodule "usrloc.so"</b></div>
<div><b>modparam("usrloc", "db_url",
"mysql://yyyy:xxxx@localhost/o<wbr>pensips")</b></div>
<div><b>modparam("usrloc", "db_mode", 1)</b></div>
<div><b>
</b></div>
<div><b> Other default modules are loaded also . It not
giving any error when starting . But while register its
throughing such error . </b></div>
<div><b>
</b></div>
<div><b> What the problem i am not getting it . This is
happening in one machine . In other machine the same config
with same code is runnign fine .</b></div>
<div><b>
</b></div>
<div><b>Please help me if I am doing anything wrong .</b></div>
<div><b>
</b></div>
<div>
<div>
<div class="m_6252145392861642982m_8403115127019008851m_-467242501914628577m_-4777611178439648847gmail_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>
</div>
</div>
<fieldset class="m_6252145392861642982m_8403115127019008851m_-467242501914628577m_-4777611178439648847mimeAttachmentHeader"></fieldset>
</div></div><pre>______________________________<wbr>_________________
Users mailing list
<a moz-do-not-send="true" class="m_6252145392861642982m_8403115127019008851m_-467242501914628577m_-4777611178439648847moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a moz-do-not-send="true" class="m_6252145392861642982m_8403115127019008851m_-467242501914628577m_-4777611178439648847moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-<wbr>bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</div>
</blockquote></div>
</div>
</blockquote>
</div></blockquote></div></div>
</blockquote>
</div></blockquote></div></div>
</blockquote>
</div></blockquote></div></div>
</blockquote>
</body></html>