Re: [SR-Users] db_text and caching/reloading

Some more investigation here and it looks like the kamctlrc value to set for db_text path is DBTEXT_PATH and not DB_PATH as listed in the default kamctlrc file.

[1] When I have DB_PATH set to the location of the db text files, the following happens (I cannot show the contents of the address table, but the memory dump works):

DB_PATH="/etc/kamailio/db_text"

# kamctl address dump 0 <10000, 10.7.0.0, 24, 0> [] 1 <10002, 10.7.0.0, 24, 0> [] # kamctl address show #

[2] When I have DBTEXT_PATH set to the location of the db text files, the following happens (I cannot reload contents of the address table, but the memory dump and table show works):

# kamctl address dump 0 <10000, 10.7.0.0, 24, 0> [] 1 <10002, 10.7.0.0, 24, 0> [] # kamctl address show [1, 10000, '10.7.0.0', 24, 0, ''] # kamctl address reload # kamctl address dump 0 <10000, 10.7.0.0, 24, 0> [] 1 <10002, 10.7.0.0, 24, 0> [] # kamctl address show [1, 10000, '10.7.0.0', 24, 0, '']

It also appears that the equivilent RPC commands dont work correctly too for the permissions module, the addressDump does not show in-memory values, and reload says it completed, but dump shows nothing too:

kamcmd> permissions.addressDump { } kamcmd> permissions.addressReload Reload OK kamcmd> permissions.addressDump { }

Am I missing something with my configuration, or have I come accross a bug?

Thanks for reading this far :)

Thanks

On 29/09/2015 13:07, Asgaroth wrote:

Hi,

Friendly "bump", any thoughts on this one?

I'm using kamailio v4.3.2

Thanks

On 28/09/2015 13:11, Asgaroth wrote:

...

Hi,

I am busy testing the db_text module for some modules who's configuration does not change that often.

If I set the db_mode for db_text to 0 (caching), it appears that if I modify the file directly (in this case the address dbtext file) and then issue a "kamctl address reload" the updated contents are *not* reloaded. However, if I set db_mode to 1, then the contents of the db_text file automatically reload when I change it on the file system.

Is it possible to run db_text in caching mode but to also force a reload if I manually update the underlying database file?

Additionally, in kamctlrc, I had to add the following variable:

DBTEXT_PATH="/etc/kamailio/db_text"

Whereas the original example for db_text path in kamctlrc is as follows:

# database path used by dbtext, db_berkeley or sqlite #DB_PATH="/etc/kamailio/db_text"

Is this just a typo in the kamctlrc distribution or is the variable meant to be DB_PATH or DBTEXT_PATH?

Thanks