Thanks for the help. I was wondering if I needed remove from the cache also. I am now<div>removing from subscriber and xcap table just to make sure that the database does not</div><div>contain stale data.</div><div><br></div>
<div>Krish Kura</div><br><div class="gmail_quote">On Fri, Sep 30, 2011 at 3:01 AM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com">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>
just to add that besides having the records in xcap table, if the
user is removed, it should have no access to it because it will be
authenticated for that. But since there is no record in subscriber
table anymore, the authentication will fail always. So besides
taking harddrive space, it is no impact in SIP side. IIRC, siremis
has a web interface for xcap, but also the delete operation has to
be done manually.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
On 9/28/11 4:10 PM, Peter Dunkley wrote:
<blockquote type="cite">
Hello,<br>
<br>
You don't need to worry about the contents of the presentity,
watcher, and active watcher tables. Entries in these tables will
be deleted if the user un-subscribes or logs out properly, and
failing that automatically cleaned up when the records themselves
expire.<br>
<br>
When you remove a user you probably should remove any documents
belonging to them in xcap. At the moment this is a manual process
and not tied into the kamctl command.<br>
<br>
Regards,<br>
<br>
Peter<div><div></div><div class="h5"><br>
<br>
On Tue, 2011-09-27 at 13:49 -0500, Krishna Kurapati wrote:<br>
<blockquote type="CITE"> Hi,
</blockquote>
<blockquote type="CITE"> <br>
<br>
</blockquote>
<blockquote type="CITE"> When a user is removed using "kamctl rm",
is there way way to clean up presence information
</blockquote>
<blockquote type="CITE"> in the database (xcap, presentity,
watcher and active watcher tables) and in the cache? Is there a
</blockquote>
<blockquote type="CITE"> event that gets fired when the user is
removed from subscriber table which I could handle in config
</blockquote>
<blockquote type="CITE"> file and and cleanup?
</blockquote>
<blockquote type="CITE"> <br>
<br>
</blockquote>
<blockquote type="CITE"> <br>
<br>
</blockquote>
<blockquote type="CITE"> Thanks
</blockquote>
<blockquote type="CITE"> Krish Kura
</blockquote>
</div></div><blockquote type="CITE">
<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>
</pre>
</blockquote>
<br>
<table cellpadding="0" cellspacing="0" width="100%">
<tbody>
<tr>
<td>
<pre>--
Peter Dunkley
Technical Director
Crocodile RCS Ltd
</pre>
</td>
</tr>
</tbody>
</table>
<br>
<fieldset></fieldset>
<br>
<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>
</pre>
</blockquote><font color="#888888">
<br>
<pre cols="72">--
Daniel-Constantin Mierla -- <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
Kamailio Advanced Training, Oct 10-13, Berlin: <a href="http://asipto.com/u/kat" target="_blank">http://asipto.com/u/kat</a>
<a href="http://linkedin.com/in/miconda" target="_blank">http://linkedin.com/in/miconda</a> -- <a href="http://twitter.com/miconda" target="_blank">http://twitter.com/miconda</a></pre>
</font></div>
</blockquote></div><br>