[OpenSIPS-Users] check_source_address not working with upgrade

[Ryan Bullock]

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
>