[OpenSIPS-Devel] [ opensips-Bugs-2851051 ] db_does_uri_exist should respect use_uri_table

[SourceForge.net]

Bugs item #2851051, was opened at 2009-09-04 13:57
Message generated for change (Comment added) made by ironmissy
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2851051&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: trunk
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Thomas Gelf (thomas_gelf)
Assigned to: Irina-Maria Stanescu (ironmissy)
Summary: db_does_uri_exist should respect use_uri_table

Initial Comment:
As I reduced OpenSIPS DB structure and DB permissions to an absolute
minimum, I noticed that db_does_uri_exist() throws the following error:

> ERROR:db_mysql:get_new_stmt_ctx: driver error: SELECT command denied
>                to user 'opensips'@'proxy.domain.tld' for table 'uri'
> ERROR:db_mysql:get_new_stmt_ctx: failed while mysql_stmt_prepare()
> ERROR:db_mysql:db_mysql_do_prepared_query: failed to create new context
> ERROR:uri:does_uri_exist: Error while querying database

However, my config says:

> modparam("uri", "use_uri_table", 0)

IMO queries against uri-table shall not be issued in this case. I'm
running OpenSIPS from current trunk, r6069.

Best regards,
Thomas Gelf


----------------------------------------------------------------------

>Comment By: Irina-Maria Stanescu (ironmissy)
Date: 2009-09-04 15:48

Message:
I need more information (maybe the entire log and the configuration file)
because i cannot reproduce this behavior.
I tried db_does_uri_exist and it works just fine using the default table
(subscriber, not uri). The only parameter needed is db_url.

Regards,
Irina Stanescu

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2851051&group_id=232389