<div dir="ltr"><div><div><div>Daniel, <br></div>understood. Thank you.<br><br></div>Regards,<br></div>Takeshi<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Jul 16, 2015 at 6:30 PM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
the location_attrs table store extra attributes per contact record,
which can be set in config file via XAVP.<br>
<br>
You need to add the tables with _attrs suffix corresponding to the
name you use instead of 'location', using same structure as
location_attrs. In your case should be k1_location_attrs and
k2_location_attrs.<br>
<br>
Cheers,<br>
Daniel<div><div class="h5"><br>
<br>
<div>On 15/07/15 01:10, mayamatakeshi wrote:<br>
</div>
</div></div><blockquote type="cite"><div><div class="h5">
<div dir="ltr">Hello,
<div>I need to prepare two kamailio instances accessing the same
mysql db.</div>
<div>They will write to different location tables so i use
function calls like these:</div>
<div><br>
</div>
<div>Server1:</div>
<div> save("k1_location");</div>
<div> lookup("k1_location");</div>
<div><br>
</div>
<div>Server2:</div>
<div>
<div>
<div> save("k2_location");</div>
<div> lookup("k2_location");</div>
</div>
</div>
<div><br>
</div>
<div>This is working fine.</div>
<div><br>
</div>
<div>However, checking db, I can see there is also a table
called location_attrs and I am not sure what is its purpose
(is this documented?).</div>
<div>Anyway, I suspect I should also set a separate copy of it
for each kamailio instance, but I am not sure how to do it. </div>
<div><br>
</div>
<div>Regards,</div>
<div>Takeshi</div>
<div><br>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><span class="HOEnZb"><font color="#888888">
</font></span></pre><span class="HOEnZb"><font color="#888888">
</font></span></blockquote><span class="HOEnZb"><font color="#888888">
<br>
<pre cols="72">--
Daniel-Constantin Mierla
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Book: SIP Routing With Kamailio - <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a></pre>
</font></span></div>
<br>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br></div>