[SR-Users] Backing up htable to SQL table ...

[Krishna Kurapati]

Thanks Daniel for the help. I was looking at other module parameters.
I added this like and tried it again

modparam("htable", "htable","xhash=>size=8;dbtable=htable;dbmode=1;")

However, it was still not backing up to the database. Seems like there is
bug when the expiration is not set or
set to 0. I modified the code and it worked.

Here is the change log:

--- a/modules_k/htable/ht_db.c
+++ b/modules_k/htable/ht_db.c
@@ -369,10 +369,12 @@ int ht_db_save_table(ht_t *ht, str *dbtable)
                                        it->name.len, it->name.s,
it->value.n);
                        }

-                       if (it->expire <= now) {
+                       if(ht->htexpire > 0 && ht_db_expires_flag!=0) {
+                          if (it->expire <= now) {
                                LM_DBG("skipping expired entry");
                                it = it->next;
                                continue;
+                          }
                        }


If this is the right fix for the bug, can someone commit this to the main?

Thanks
Krishna Kura

On Wed, Mar 7, 2012 at 9:48 PM, Krishna Kurapati <kkurapat at gmail.com> wrote:

> Any help on how to backup the htable content to database table?
>
> Thanks
>
>
> On Tue, Mar 6, 2012 at 5:28 PM, Krishna Kurapati <kkurapat at gmail.com>wrote:
>
>> I did little more digging into htable source code. It looks like syncing
>> to database is happening when the module is being
>> destroyed.
>>
>> To see if this is working, I tried to stop Kamailio and looked into the
>> database. The htable is still empty. Any configuration
>> changes required to make the process happen?
>>
>> Thanks
>> Krish Kura
>>
>> On Tue, Mar 6, 2012 at 8:38 AM, Krishna Kurapati <kkurapat at gmail.com>wrote:
>>
>>> Hi,
>>>
>>> This is my first time attempt using htable module.
>>> How can I back up the htable content in the database incase the server
>>> restarts. I saw a htable in the MySQL database.
>>> My observation has been that htable module is not automatically backing
>>> up to database even though I added
>>> modparams to point to the database. Do I need to explicitly backup
>>> htable content to database using sqlops or some
>>> other mechanism?
>>>
>>> Thanks
>>> Krish Kura
>>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20120308/c0386b6f/attachment.htm>