[OpenSIPS-Users] check_source_address not working with upgrade

[Duane Larson]

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 <rrb3942 at gmail.com> 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,  <duane.larson at gmail.com> 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:dfasdfasd@108.XXX.XXX.XXX
> /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
> > Users at lists.opensips.org
> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>



-- 
--
*--*--*--*--*--*
Duane
*--*--*--*--*--*
--
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20120202/a6ca0fbf/attachment.htm>