<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body 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<br>
<br>
<div class="moz-cite-prefix">On 15/07/15 01:10, mayamatakeshi wrote:<br>
</div>
<blockquote
cite="mid:CABaNFCaVmykgctQtxJrwCZhGO4W1s=136pvuVZKmCW5dhrVVuw@mail.gmail.com"
type="cite">
<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 class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Book: SIP Routing With Kamailio - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a></pre>
</body>
</html>