[OpenSIPS-Users] permission module

[Bogdan-Andrei Iancu]

This may be the problem - using dbtext..... What db_mode do you use for it ?
http://www.opensips.org/html/docs/modules/1.11.x/db_text.html#id293561

If 0 (caching), OpenSIPS will not "see" the changes over the file.

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 20.09.2014 01:37, discodog62 at aol.com wrote:
> 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.
>
>
>
>
>
>
> -----Original Message-----
> From: Bogdan-Andrei Iancu <bogdan at opensips.org>
> To: OpenSIPS users mailling list <users at lists.opensips.org>; 
> discodog62 <discodog62 at aol.com>
> Sent: Fri, Sep 19, 2014 1:59 am
> Subject: Re: [OpenSIPS-Users] permission module
>
> Hi,
>
> 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:
>     Sep 18 16:52:45 [1738] DBG:permissions:reload_address_table: 
> number of rows in address table: 1
>
> Regards,
> Bogdan-Andrei Iancu
> OpenSIPS Founder and Developer
> http://www.opensips-solutions.com
> On 19.09.2014 03:00, discodog62 at aol.com wrote:
>> 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.
>>
>> Here is what I am doing......
>>
>>
>>
>> vma / # opensipsctl address show
>> [1, 1, '192.168.2.5', 32, 5068, 'udp', '', 'James']
>> vma / # opensipsctl address fifo address_dump
>> Sep 18 16:51:51 [1738] DBG:mi_fifo:mi_fifo_server: entered consume
>> Sep 18 16:51:51 [1738] DBG:mi_fifo:mi_fifo_server: **** done consume
>> Sep 18 16:51:51 [1738] DBG:mi_fifo:mi_fifo_server: done parsing the 
>> mi tree
>>   97 <192.168.2.5,1, 5068, 1, NULL, James>
>> vma / # opensipsctl address add 1 192.168.2.100 32 5060 udp Me
>> Updated address, rows affected: 1
>> INFO: execute '/test/opensips/bin/opensipsctl address reload' to 
>> synchronize cache and database
>> vma / # opensipsctl address show
>> [1, 1, '192.168.2.5', 32, 5068, 'udp', '', 'James']
>> [2, 1, '192.168.2.100', 32, 5060, 'udp', '', 'Me']
>> vma / # opensipsctl fifo address_dump
>> Sep 18 16:52:28 [1738] DBG:mi_fifo:mi_fifo_server: entered consume
>> Sep 18 16:52:28 [1738] DBG:mi_fifo:mi_fifo_server: **** done consume
>> Sep 18 16:52:28 [1738] DBG:mi_fifo:mi_fifo_server: done parsing the 
>> mi tree
>>   97 <192.168.2.5,1, 5068, 1, NULL, James>
>> vma / # opensipsctl address show
>> [1, 1, '192.168.2.5', 32, 5068, 'udp', '', 'James']
>> [2, 1, '192.168.2.100', 32, 5060, 'udp', '', 'Me']
>> vma / # opensipsctl fifo address_reload
>> Sep 18 16:52:45 [1738] DBG:mi_fifo:mi_fifo_server: entered consume
>> Sep 18 16:52:45 [1738] DBG:mi_fifo:mi_fifo_server: **** done consume
>> Sep 18 16:52:45 [1738] DBG:mi_fifo:mi_fifo_server: done parsing the 
>> mi tree
>> Sep 18 16:52:45 [1738] DBG:db_text:dbt_db_get_table: cache or mtime 
>> succeeded for [address]
>> Sep 18 16:52:45 [1738] DBG:db_text:dbt_query: new res with 8 cols
>> Sep 18 16:52:45 [1738] DBG:db_text:dbt_result_new: new res with 8 cols
>> Sep 18 16:52:45 [1738] DBG:core:db_new_result: allocate 48 bytes for 
>> result set at 0x7f39d69735d0
>> Sep 18 16:52:45 [1738] DBG:core:db_allocate_columns: allocate 224 
>> bytes for result columns at 0x7f39d6974228
>> Sep 18 16:52:45 [1738] DBG:core:db_allocate_rows: allocate 272 bytes 
>> for result rows and values at 0x7f39d6974320
>> Sep 18 16:52:45 [1738] DBG:permissions:reload_address_table: number 
>> of rows in address table: 1
>> 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
>> Sep 18 16:52:45 [1738] DBG:core:db_free_columns: freeing result 
>> columns at 0x7f39d6974228
>> Sep 18 16:52:45 [1738] DBG:core:db_free_rows: freeing 1 rows
>> Sep 18 16:52:45 [1738] DBG:core:db_free_row: freeing row values at 
>> 0x7f39d6974330
>> Sep 18 16:52:45 [1738] DBG:core:db_free_rows: freeing rows at 
>> 0x7f39d6974320
>> Sep 18 16:52:45 [1738] DBG:core:db_free_result: freeing result set at 
>> 0x7f39d69735d0
>> Sep 18 16:52:45 [1738] DBG:permissions:reload_address_table: address 
>> table reloaded successfully.
>> vma / # opensipsctl fifo address_dump
>> Sep 18 16:52:53 [1738] DBG:mi_fifo:mi_fifo_server: entered consume
>> Sep 18 16:52:53 [1738] DBG:mi_fifo:mi_fifo_server: **** done consume
>> Sep 18 16:52:53 [1738] DBG:mi_fifo:mi_fifo_server: done parsing the 
>> mi tree
>>   97 <192.168.2.5,1, 5068, 1, NULL, James>
>> vma / # opensipsctl address reloadshow
>> [1, 1, '192.168.2.5', 32, 5068, 'udp', '', 'James']
>> [2, 1, '192.168.2.100', 32, 5060, 'udp', '', 'Me']
>> vma / # opensipsctl fifo debug 0
>> Sep 18 16:53:08 [1738] DBG:mi_fifo:mi_parse_tree: adding node <> ; 
>> val <0>
>> Sep 18 16:53:08 [1738] DBG:mi_fifo:mi_parse_node: end of input tree
>> Sep 18 16:53:08 [1738] DBG:mi_fifo:mi_fifo_server: done parsing the 
>> mi tree
>> DEBUG:: 0
>> vma / #
>>
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20140920/d080c5b0/attachment.htm>