<div dir="ltr">Hi Henning<br>Thanks for your answers, you are right and I was confusing the module names, my brain it will break at any time :-)...<br><br>I am using check_to(), check_from() and does_uri_exist() functions from uri_db module so I have to define those parameters to specify the other subscriber table (mysql view 'subscriber_v2'):<br>
<br>modparam("uri_db", "db_table", "subscriber_v2")<br>modparam("uri_db", "use_uri_table", 0) ;;; specify '1' just if the "uri" table should be used.<br><br>now it works, I will put kamailio 1.4 in production after doing and pass some tests, thank you very much.<br>
<br>rafael<br><br><br><div class="gmail_quote">On Tue, Aug 12, 2008 at 4:03 PM, Henning Westerholt <span dir="ltr"><<a href="mailto:henning.westerholt@1und1.de">henning.westerholt@1und1.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">On Tue, August 12, 2008 5:13 pm, Rafael Risco Gonzales-Vigil wrote:<br>
> Thanks Henning, I think it was my error because problem disapeer when I<br>
> comment these lines in my config:<br>
><br>
> # modparam("uri_db", "db_table", "uri")<br>
> # modparam("uri_db", "use_uri_table", 0)<br>
><br>
> so now kamailio use 'subscriber' table by default, btw I'm not sure but<br>
> the parameter 'db_table' should not be activated since parameter<br>
> 'use_uri_table' was '0'...<br>
<br>
</div>Hi Rafael,<br>
<br>
do you refer with "should not activated" to the config file, or the module<br>
code? The default value is subscriber, this fits to the use_uri_table<br>
default in my opinion.<br>
<div class="Ih2E3d"><br>
> Now I am testing kamailio 1.4 to use a VIEW from mya2billing DB as a<br>
> subscriber database, It works in 1.3.2 version of openser using this<br>
> modparam:<br>
><br>
> modparam("uri_db", "subscriber_table", "subscriber_v2") , where<br>
> 'subscriber_v2' its the VIEW shown below:<br>
><br>
> CREATE VIEW openser.subscriber_v2 AS<br>
</div>> [..]<br>
<div class="Ih2E3d">><br>
> Then you can authenticate users using if(!www_authorize("",<br>
> "subscriber_v2")) or if(!proxy_authorize("", "subscriber_v2")) in<br>
> register and invite request routes....<br>
<br>
</div>The function www_authorize and proxy_authorize are not in the uri_db<br>
module, there are in auth_db, but otherwise it should be fine i think.<br>
<div class="Ih2E3d"><br>
> In Kamailio version 1.4 the modparam "subscriber_table" was removed from<br>
> uri_db module, Is it enough to specify the new table in www_authorize and<br>
> proxy_authorize functions?<br>
<br>
</div>The uri_db module is not related to the auth_db module, so its not<br>
necessary to setup this module if you do not need function from it.<br>
<br>
Cheers,<br>
<font color="#888888"><br>
Henning<br>
<br>
</font></blockquote></div><br></div>