Hmmm. That would suck if its a bug. Just to follow up on my last email here is what I see when I start OpenSIPS. You can see that OpenSIPS grabs all the info from the "address" table<br><br><br>Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:permissions:reload_address_table: number of rows in address table: 6<br>
Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:permissions:reload_address_table: Tuple <216.82.224.202, 2, 5060, 0, , > inserted into address hash table<br>Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:permissions:reload_address_table: Tuple <64.2.142.15, 4, 5060, 0, , > inserted into address hash table<br>
Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:permissions:reload_address_table: Tuple <173.XXX.XXX.63, 10, 5060, 0, , > inserted into address hash table<br>Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:permissions:reload_address_table: Tuple <173.XXX.XXX.10, 10, 5060, 0, , > inserted into address hash table<br>
Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:permissions:reload_address_table: Tuple <173.XXX.XXX.107, 3, 5060, 0, , > inserted into address hash table<br>Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:permissions:reload_address_table: Tuple <216.82.225.202, 2, 5060, 0, , > inserted into address hash table<br>
Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:db_free_columns: freeing result columns at 0x7fd95d243710<br>Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:db_free_rows: freeing 6 rows<br>
Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:db_free_row: freeing row values at 0x7fd95d244248<br>Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:db_free_row: freeing row values at 0x7fd95d244348<br>
Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:db_free_row: freeing row values at 0x7fd95d244448<br>Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:db_free_row: freeing row values at 0x7fd95d244548<br>
Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:db_free_row: freeing row values at 0x7fd95d244648<br>Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:db_free_row: freeing row values at 0x7fd95d244748<br>
Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:db_free_rows: freeing rows at 0x7fd95d2441e8<br>Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:db_free_result: freeing result set at 0x7fd95d2358e8<br>
Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:permissions:reload_address_table: address table reloaded successfully.<br>Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:pool_remove: removing connection from the pool<br>
Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:init_mod: register MI for permissions<br>Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:init_mod: initializing module uri<br><br><br><br>
<br><br><div class="gmail_quote">On Thu, Feb 2, 2012 at 10:43 AM, Ryan Bullock <span dir="ltr"><<a href="mailto:rrb3942@gmail.com">rrb3942@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I will chime into say that I ran into the same issue when attempting<br>
to upgrade to the latest trunk. I just have not had time to open a bug<br>
and get a test setup to do in-depth trouble shooting.<br>
<div><div class="h5"><br>
On Thu, Feb 2, 2012 at 8:38 AM, <<a href="mailto:duane.larson@gmail.com">duane.larson@gmail.com</a>> wrote:<br>
> I just upgraded my b2bua opensips server to the latest trunk version and now<br>
> my if statements using "check_source_address" from the permissions module<br>
> isn't working. I have the following set up<br>
><br>
> loadmodule "permissions.so"<br>
> modparam("permissions","db_url","mysql://adfasdf:dfasdfasd@108.XXX.XXX.XXX/opensips")<br>
><br>
><br>
> if (check_source_address("2") || check_source_address("3") ||<br>
> check_source_address("4")) {<br>
><br>
> The INVITE comes from my SIP Proxy and worked before the upgrade without<br>
> issue<br>
><br>
><br>
><br>
> Feb 1 22:41:01 proxy01 /usr/local/sbin/opensips[30163]:<br>
> DBG:permissions:check_src_addr_3: Looking for : <2, 173.XXX.XXX.XXX, 5060,<br>
> 1> in tables<br>
> Feb 1 22:41:01 proxy01 /usr/local/sbin/opensips[30163]:<br>
> DBG:permissions:hash_match: specified group does not exist in hash table<br>
> Feb 1 22:41:01 proxy01 /usr/local/sbin/opensips[30163]:<br>
> DBG:permissions:match_subnet_table: subnet table is empty<br>
> Feb 1 22:41:01 proxy01 /usr/local/sbin/opensips[30163]:<br>
> DBG:permissions:check_src_addr_3: Looking for : <3, 173.XXX.XXX.XXX, 5060,<br>
> 1> in tables<br>
> Feb 1 22:41:01 proxy01 /usr/local/sbin/opensips[30163]:<br>
> DBG:permissions:hash_match: specified group does not exist in hash table<br>
> Feb 1 22:41:01 proxy01 /usr/local/sbin/opensips[30163]:<br>
> DBG:permissions:match_subnet_table: subnet table is empty<br>
> Feb 1 22:41:01 proxy01 /usr/local/sbin/opensips[30163]:<br>
> DBG:permissions:check_src_addr_3: Looking for : <4, 173.XXX.XXX.XXX, 5060,<br>
> 1> in tables<br>
> Feb 1 22:41:01 proxy01 /usr/local/sbin/opensips[30163]:<br>
> DBG:permissions:hash_match: specified group does not exist in hash table<br>
> Feb 1 22:41:01 proxy01 /usr/local/sbin/opensips[30163]:<br>
> DBG:permissions:match_subnet_table: subnet table is empty<br>
><br>
><br>
><br>
><br>
> This is what I have in the database<br>
> Proxy01:/var/log# opensipsctl db show address<br>
> +-----+-----+----------------+------+------+-------+---------+--------------+<br>
> | id | grp | ip | mask | port | proto | pattern | context_info |<br>
> +-----+-----+----------------+------+------+-------+---------+--------------+<br>
> | 3 | 2 | 216.XXX.XXX.202 | 32 | 5060 | any | NULL | NULL |<br>
> | 258 | 4 | 64.XXX.XXX.15 | 32 | 5060 | any | NULL | NULL |<br>
> | 1 | 10 | 173.XXX.XXX.XXX | 32 | 5060 | any | NULL | NULL |<br>
> | 2 | 10 | 173.XXX.XXX.XXX | 32 | 5060 | any | NULL | NULL |<br>
> | 257 | 3 | 173.XXX.XXX.XXX | 32 | 5060 | any | NULL | NULL |<br>
> | 4 | 2 | 216.XXX.XXX.202 | 32 | 5060 | any | NULL | NULL |<br>
> +-----+-----+----------------+------+------+-------+---------+--------------+<br>
><br>
><br>
><br>
> I am not sure if OpenSIPS is really querying the mysql database because I<br>
> don't really see any connections from the server when a call is made. How<br>
> could this be possible? When I start OpenSIPS I see that it talks to the<br>
> database.<br>
</div></div>> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
><br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>--<br>*--*--*--*--*--*<br>Duane<br>*--*--*--*--*--*<br>--<br>