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
Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:permissions:reload_address_table: number of rows in address table: 6 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 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 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 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 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 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 Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:db_free_columns: freeing result columns at 0x7fd95d243710 Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:db_free_rows: freeing 6 rows Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:db_free_row: freeing row values at 0x7fd95d244248 Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:db_free_row: freeing row values at 0x7fd95d244348 Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:db_free_row: freeing row values at 0x7fd95d244448 Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:db_free_row: freeing row values at 0x7fd95d244548 Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:db_free_row: freeing row values at 0x7fd95d244648 Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:db_free_row: freeing row values at 0x7fd95d244748 Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:db_free_rows: freeing rows at 0x7fd95d2441e8 Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:db_free_result: freeing result set at 0x7fd95d2358e8 Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:permissions:reload_address_table: address table reloaded successfully. Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:pool_remove: removing connection from the pool Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:init_mod: register MI for permissions Feb 2 10:39:32 proxy01 /usr/local/sbin/opensips[14584]: DBG:core:init_mod: initializing module uri On Thu, Feb 2, 2012 at 10:43 AM, Ryan Bullock <[email protected]> wrote: > I will chime into say that I ran into the same issue when attempting > to upgrade to the latest trunk. I just have not had time to open a bug > and get a test setup to do in-depth trouble shooting. > > On Thu, Feb 2, 2012 at 8:38 AM, <[email protected]> wrote: > > I just upgraded my b2bua opensips server to the latest trunk version and > now > > my if statements using "check_source_address" from the permissions module > > isn't working. I have the following set up > > > > loadmodule "permissions.so" > > > modparam("permissions","db_url","mysql://adfasdf:[email protected] > /opensips") > > > > > > if (check_source_address("2") || check_source_address("3") || > > check_source_address("4")) { > > > > The INVITE comes from my SIP Proxy and worked before the upgrade without > > issue > > > > > > > > Feb 1 22:41:01 proxy01 /usr/local/sbin/opensips[30163]: > > DBG:permissions:check_src_addr_3: Looking for : <2, 173.XXX.XXX.XXX, > 5060, > > 1> in tables > > Feb 1 22:41:01 proxy01 /usr/local/sbin/opensips[30163]: > > DBG:permissions:hash_match: specified group does not exist in hash table > > Feb 1 22:41:01 proxy01 /usr/local/sbin/opensips[30163]: > > DBG:permissions:match_subnet_table: subnet table is empty > > Feb 1 22:41:01 proxy01 /usr/local/sbin/opensips[30163]: > > DBG:permissions:check_src_addr_3: Looking for : <3, 173.XXX.XXX.XXX, > 5060, > > 1> in tables > > Feb 1 22:41:01 proxy01 /usr/local/sbin/opensips[30163]: > > DBG:permissions:hash_match: specified group does not exist in hash table > > Feb 1 22:41:01 proxy01 /usr/local/sbin/opensips[30163]: > > DBG:permissions:match_subnet_table: subnet table is empty > > Feb 1 22:41:01 proxy01 /usr/local/sbin/opensips[30163]: > > DBG:permissions:check_src_addr_3: Looking for : <4, 173.XXX.XXX.XXX, > 5060, > > 1> in tables > > Feb 1 22:41:01 proxy01 /usr/local/sbin/opensips[30163]: > > DBG:permissions:hash_match: specified group does not exist in hash table > > Feb 1 22:41:01 proxy01 /usr/local/sbin/opensips[30163]: > > DBG:permissions:match_subnet_table: subnet table is empty > > > > > > > > > > This is what I have in the database > > Proxy01:/var/log# opensipsctl db show address > > > +-----+-----+----------------+------+------+-------+---------+--------------+ > > | id | grp | ip | mask | port | proto | pattern | context_info | > > > +-----+-----+----------------+------+------+-------+---------+--------------+ > > | 3 | 2 | 216.XXX.XXX.202 | 32 | 5060 | any | NULL | NULL | > > | 258 | 4 | 64.XXX.XXX.15 | 32 | 5060 | any | NULL | NULL | > > | 1 | 10 | 173.XXX.XXX.XXX | 32 | 5060 | any | NULL | NULL | > > | 2 | 10 | 173.XXX.XXX.XXX | 32 | 5060 | any | NULL | NULL | > > | 257 | 3 | 173.XXX.XXX.XXX | 32 | 5060 | any | NULL | NULL | > > | 4 | 2 | 216.XXX.XXX.202 | 32 | 5060 | any | NULL | NULL | > > > +-----+-----+----------------+------+------+-------+---------+--------------+ > > > > > > > > I am not sure if OpenSIPS is really querying the mysql database because I > > don't really see any connections from the server when a call is made. How > > could this be possible? When I start OpenSIPS I see that it talks to the > > database. > > _______________________________________________ > > Users mailing list > > [email protected] > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > -- -- *--*--*--*--*--* Duane *--*--*--*--*--* --
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
