28 Sep
2015
28 Sep
'15
3:11 p.m.
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
29 Sep
29 Sep
3:07 p.m.
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
5:16 p.m.
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
30 Sep
30 Sep
11:28 a.m.
I've tried this with the domain module now too, and the same thing
appears to be happening, I can show/showdb/add/rm but cannot *reload*
when using dbtext as database module with dbtext caching mode enabled.
I'm wondering if this is a configuration issue on my side. When I switch
to PGSQL I am able to reload properly after a table modification.
Here is an example of the domain scenario:
# kamctl domain
-- command 'domain' - manage local domains
domain reload ....................... reload domains from disk
domain show ......................... show current domains in memory
domain showdb ....................... show domains in the database
domain add <domain> ................. add the domain to the database
domain rm <domain> .................. delete the domain from the database
# kamctl domain showdb
[1, 'domain1.example.com', '', 1443435582]
# kamctl domain add domain2.example.com
Updated domain, rows affected: 1
INFO: execute '/usr/sbin/kamctl domain reload' to synchronize cache and
database
# kamctl domain showdb
[1, 'domain1.example.com', '', 1443435582]
[2, 'domain2.example.com', '', 1443600900]
# kamctl domain show
domain:: domain1.example.com
did:: domain1.example.com
# kamctl domain reload
# kamctl domain show
domain:: domain1.example.com
did:: domain1.example.com
# kamctl domain showdb
[1, 'domain1.example.com', '', 1443435582]
[2, 'domain2.example.com', '', 1443600900]
Thanks
On 29/09/2015 15:16, Asgaroth wrote:
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
3341
days inactive
3343
days old
3 comments
1 participants
participants (1)
-
Asgaroth