<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi,<br>
<br>
I committed the patch in master branch, but I removed the condition
'ht_db_expires_flag!=0', because it is used to control if expires
column is saved in database, nothing else. If I misunderstood
something, let me know, if not and all works fine for you with the
commit, then the patch can be backported to 3.2.<br>
<br>
Ramona <br>
<br>
On 3/8/12 10:38 PM, Krishna Kurapati wrote:
<blockquote
cite="mid:CAOzCjAdC0BxGxa3ZbUUbuOHePi2KOHBS0J6FB8LedZpJ7hhREg@mail.gmail.com"
type="cite">Thanks Daniel for the help. I was looking at other
module parameters.
<div>I added this like and tried it again</div>
<div><br>
</div>
<div>modparam("htable",
"htable","xhash=>size=8;dbtable=htable;dbmode=1;")</div>
<div><br>
</div>
<div>However, it was still not backing up to the database. Seems
like there is bug when the expiration is not set or</div>
<div>set to 0. I modified the code and it worked.</div>
<div><br>
</div>
<div>Here is the change log:</div>
<div><br>
</div>
<div>
<div>--- a/modules_k/htable/ht_db.c</div>
<div>+++ b/modules_k/htable/ht_db.c</div>
<div>@@ -369,10 +369,12 @@ int ht_db_save_table(ht_t *ht, str
*dbtable)</div>
<div> it->name.len,
it->name.s, it->value.n);</div>
<div> }</div>
<div> </div>
<div>- if (it->expire <= now) {</div>
<div>+ if(ht->htexpire > 0
&& ht_db_expires_flag!=0) {</div>
<div>+ if (it->expire <= now) {</div>
<div> LM_DBG("skipping expired
entry");</div>
<div> it = it->next;</div>
<div> continue;</div>
<div>+ }</div>
<div> }</div>
<div> </div>
</div>
<div><br>
</div>
<div>If this is the right fix for the bug, can someone commit this
to the main?</div>
<div><br>
</div>
<div>Thanks</div>
<div>Krishna Kura</div>
<div><br>
<div class="gmail_quote">
On Wed, Mar 7, 2012 at 9:48 PM, Krishna Kurapati <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:kkurapat@gmail.com" target="_blank">kkurapat@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">Any help
on how to backup the htable content to database table?
<div><br>
</div>
<div>Thanks
<div>
<div><br>
<br>
<div class="gmail_quote">On Tue, Mar 6, 2012 at 5:28
PM, Krishna Kurapati <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:kkurapat@gmail.com" target="_blank">kkurapat@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">I
did little more digging into htable source code.
It looks like syncing to database is happening
when the module is being
<div>
destroyed. </div>
<div><br>
</div>
<div>To see if this is working, I tried to stop
Kamailio and looked into the database. The
htable is still empty. Any configuration</div>
<div>changes required to make the process happen?</div>
<div><br>
</div>
<div>Thanks</div>
<div>Krish Kura</div>
<div>
<div>
<div><br>
<div class="gmail_quote">On Tue, Mar 6, 2012
at 8:38 AM, Krishna Kurapati <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:kkurapat@gmail.com"
target="_blank">kkurapat@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="margin:0 0 0 .8ex;border-left:1px
#ccc solid;padding-left:1ex">Hi,
<div><br>
</div>
<div>This is my first time attempt using
htable module.</div>
<div>How can I back up the htable
content in the database incase the
server restarts. I saw a htable in the
MySQL database.</div>
<div>My observation has been that htable
module is not automatically backing up
to database even though I added</div>
<div>modparams to point to the database.
Do I need to explicitly backup htable
content to database using sqlops or
some</div>
<div>other mechanism?</div>
<div><br>
</div>
<div>Thanks</div>
<div>Krish Kura</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</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>
</body>
</html>