<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix"><tt>This may be the problem - using
dbtext..... What db_mode do you use for it ?<br>
<a class="moz-txt-link-freetext" href="http://www.opensips.org/html/docs/modules/1.11.x/db_text.html#id293561">http://www.opensips.org/html/docs/modules/1.11.x/db_text.html#id293561</a><br>
<br>
If 0 (caching), OpenSIPS will not "see" the changes over the
file.<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
On 20.09.2014 01:37, <a class="moz-txt-link-abbreviated" href="mailto:discodog62@aol.com">discodog62@aol.com</a> wrote:<br>
</div>
<blockquote
cite="mid:8D1A2716399DA42-7D4-C0E1@webmail-vm077.sysops.aol.com"
type="cite"><font size="2" color="black" face="arial">Yes I have
checked and I see the added record in the file. If I stop and
restart opensips then do a opensipsctl fifo address_dump I can
then see the 2 records. For the record I am using DBTEXT for my
database.
<div><br>
</div>
<div><br>
<div><br>
</div>
<div><br>
<br>
<br>
<div
style="font-family:arial,helvetica;font-size:10pt;color:black">-----Original
Message-----<br>
From: Bogdan-Andrei Iancu <a class="moz-txt-link-rfc2396E" href="mailto:bogdan@opensips.org"><bogdan@opensips.org></a><br>
To: OpenSIPS users mailling list
<a class="moz-txt-link-rfc2396E" href="mailto:users@lists.opensips.org"><users@lists.opensips.org></a>; discodog62
<a class="moz-txt-link-rfc2396E" href="mailto:discodog62@aol.com"><discodog62@aol.com></a><br>
Sent: Fri, Sep 19, 2014 1:59 am<br>
Subject: Re: [OpenSIPS-Users] permission module<br>
<br>
<div
id="AOLMsgPart_1_ed5b0b6e-0947-4b66-9e4f-0ec1ec5a0779">
<div class="aolReplacedBody" text="#000000"
bgcolor="#FFFFFF">
<div class="moz-cite-prefix"><tt>Hi,<br>
<br>
before doing the reload, can you check that you
actually have the 2 records in the "address" table
? It seems there is only one, according to the
reload logs:<br>
</tt><font size="2" color="black"
face="arial"><font face="arial"> Sep 18
16:52:45 [1738]
DBG:permissions:reload_address_table: number of
rows in address table: 1<br>
<br>
Regards,<br>
</font></font>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" class="moz-txt-link-freetext" target="_blank" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
On 19.09.2014 03:00, <a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:discodog62@aol.com">discodog62@aol.com</a>
wrote:<br>
</div>
<blockquote type="cite"><font size="2" color="black"
face="arial"><font size="2" face="arial">I am
using opensips 1.11.2. When I add a new IP to
the access list and then reload the newly added
IP is not reloaded into memory.</font>
<div style="color: black; font-family: arial;
font-size: 10pt;"><br>
</div>
<div style="color: black; font-family: arial;
font-size: 10pt;">Here is what I am doing......</div>
<div style="color: black; font-family: arial;
font-size: 10pt;"><br>
</div>
<div>
<div><font face="arial"><br>
</font></div>
<div>
<div><font face="arial"><br>
</font></div>
<div><font face="arial">vma / # opensipsctl
address show</font></div>
<div><font face="arial">[1, 1, '192.168.2.5',
32, 5068, 'udp', '', 'James']</font></div>
<div><font face="arial">vma / # opensipsctl
address fifo address_dump</font></div>
<div><font face="arial">Sep 18 16:51:51 [1738]
DBG:mi_fifo:mi_fifo_server: entered
consume</font></div>
<div><font face="arial">Sep 18 16:51:51 [1738]
DBG:mi_fifo:mi_fifo_server: **** done
consume</font></div>
<div><font face="arial">Sep 18 16:51:51 [1738]
DBG:mi_fifo:mi_fifo_server: done parsing
the mi tree</font></div>
<div><font face="arial"> 97
<192.168.2.5,1, 5068, 1, NULL,
James></font></div>
<div><font face="arial">vma / # opensipsctl
address add 1 192.168.2.100 32 5060 udp Me</font></div>
<div><font face="arial">Updated address, rows
affected: 1</font></div>
<div><font face="arial">INFO: execute
'/test/opensips/bin/opensipsctl address
reload' to synchronize cache and database</font></div>
<div><font face="arial">vma / # opensipsctl
address show</font></div>
<div><font face="arial">[1, 1, '192.168.2.5',
32, 5068, 'udp', '', 'James']</font></div>
<div><font face="arial">[2, 1,
'192.168.2.100', 32, 5060, 'udp', '',
'Me']</font></div>
<div><font face="arial">vma / # opensipsctl
fifo address_dump</font></div>
<div><font face="arial">Sep 18 16:52:28 [1738]
DBG:mi_fifo:mi_fifo_server: entered
consume</font></div>
<div><font face="arial">Sep 18 16:52:28 [1738]
DBG:mi_fifo:mi_fifo_server: **** done
consume</font></div>
<div><font face="arial">Sep 18 16:52:28 [1738]
DBG:mi_fifo:mi_fifo_server: done parsing
the mi tree</font></div>
<div><font face="arial"> 97
<192.168.2.5,1, 5068, 1, NULL,
James></font></div>
<div><font face="arial">vma / # opensipsctl
address show</font></div>
<div><font face="arial">[1, 1, '192.168.2.5',
32, 5068, 'udp', '', 'James']</font></div>
<div><font face="arial">[2, 1,
'192.168.2.100', 32, 5060, 'udp', '',
'Me']</font></div>
<div><font face="arial">vma / # opensipsctl
fifo address_reload</font></div>
<div><font face="arial">Sep 18 16:52:45 [1738]
DBG:mi_fifo:mi_fifo_server: entered
consume</font></div>
<div><font face="arial">Sep 18 16:52:45 [1738]
DBG:mi_fifo:mi_fifo_server: **** done
consume</font></div>
<div><font face="arial">Sep 18 16:52:45 [1738]
DBG:mi_fifo:mi_fifo_server: done parsing
the mi tree</font></div>
<div><font face="arial">Sep 18 16:52:45 [1738]
DBG:db_text:dbt_db_get_table: cache or
mtime succeeded for [address]</font></div>
<div><font face="arial">Sep 18 16:52:45 [1738]
DBG:db_text:dbt_query: new res with 8 cols</font></div>
<div><font face="arial">Sep 18 16:52:45 [1738]
DBG:db_text:dbt_result_new: new res with 8
cols</font></div>
<div><font face="arial">Sep 18 16:52:45 [1738]
DBG:core:db_new_result: allocate 48 bytes
for result set at 0x7f39d69735d0</font></div>
<div><font face="arial">Sep 18 16:52:45 [1738]
DBG:core:db_allocate_columns: allocate 224
bytes for result columns at 0x7f39d6974228</font></div>
<div><font face="arial">Sep 18 16:52:45 [1738]
DBG:core:db_allocate_rows: allocate 272
bytes for result rows and values at
0x7f39d6974320</font></div>
<div><font face="arial">Sep 18 16:52:45 [1738]
DBG:permissions:reload_address_table:
number of rows in address table: 1</font></div>
<div><font face="arial">Sep 18 16:52:45 [1738]
DBG:permissions:reload_address_table:
Tuple <192.168.2.5, 1, 5068, 1, ,
James> inserted into address hash table</font></div>
<div><font face="arial">Sep 18 16:52:45 [1738]
DBG:core:db_free_columns: freeing result
columns at 0x7f39d6974228</font></div>
<div><font face="arial">Sep 18 16:52:45 [1738]
DBG:core:db_free_rows: freeing 1 rows</font></div>
<div><font face="arial">Sep 18 16:52:45 [1738]
DBG:core:db_free_row: freeing row values
at 0x7f39d6974330</font></div>
<div><font face="arial">Sep 18 16:52:45 [1738]
DBG:core:db_free_rows: freeing rows at
0x7f39d6974320</font></div>
<div><font face="arial">Sep 18 16:52:45 [1738]
DBG:core:db_free_result: freeing result
set at 0x7f39d69735d0</font></div>
<div><font face="arial">Sep 18 16:52:45 [1738]
DBG:permissions:reload_address_table:
address table reloaded successfully.</font></div>
<div><font face="arial">vma / # opensipsctl
fifo address_dump</font></div>
<div><font face="arial">Sep 18 16:52:53 [1738]
DBG:mi_fifo:mi_fifo_server: entered
consume</font></div>
<div><font face="arial">Sep 18 16:52:53 [1738]
DBG:mi_fifo:mi_fifo_server: **** done
consume</font></div>
<div><font face="arial">Sep 18 16:52:53 [1738]
DBG:mi_fifo:mi_fifo_server: done parsing
the mi tree</font></div>
<div><font face="arial"> 97
<192.168.2.5,1, 5068, 1, NULL,
James></font></div>
<div><font face="arial">vma / # opensipsctl
address reloadshow</font></div>
<div><font face="arial">[1, 1, '192.168.2.5',
32, 5068, 'udp', '', 'James']</font></div>
<div><font face="arial">[2, 1,
'192.168.2.100', 32, 5060, 'udp', '',
'Me']</font></div>
<div><font face="arial">vma / # opensipsctl
fifo debug 0</font></div>
<div><font face="arial">Sep 18 16:53:08 [1738]
DBG:mi_fifo:mi_parse_tree: adding node
<> ; val <0></font></div>
<div><font face="arial">Sep 18 16:53:08 [1738]
DBG:mi_fifo:mi_parse_node: end of input
tree</font></div>
<div><font face="arial">Sep 18 16:53:08 [1738]
DBG:mi_fifo:mi_fifo_server: done parsing
the mi tree</font></div>
<div><font face="arial">DEBUG:: 0</font></div>
<div><font face="arial">vma / # </font></div>
</div>
</div>
<div><font face="arial"><br>
</font></div>
<div><font face="arial"><br>
</font></div>
</font> <br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
Users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" target="_blank" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
</div>
</div>
</div>
</div>
</font>
</blockquote>
<br>
</body>
</html>