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.
Submitted By: Thomas Gelf (thomas_gelf)
Assigned to: Irina-Maria Stanescu (ironmissy)
Summary: db_does_uri_exist should respect use_uri_table
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.
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.