Hello All;<br>I`m trying to tune openser-1.2.2 with dbtext data base<br>But have some problems.<br>I make db use - textdb.sh<br>Then add users use - sc.dbtext<br>and add to openser.cfg:<br>#set module path<br>mpath="/usr/local/lib/openser/modules/"
<br><br># use dbtext database<br>loadmodule "dbtext.so"<br>loadmodule "sl.so"<br>loadmodule "tm.so"<br>loadmodule "rr.so"<br>loadmodule "maxfwd.so"<br>loadmodule "usrloc.so
"<br>loadmodule "registrar.so"<br>loadmodule "textops.so"<br>loadmodule "mi_fifo.so"<br><br># Uncomment this if you want digest authentication<br>loadmodule "auth.so"<br>loadmodule "auth_db.so"
<br><br># ----------------- setting module-specific parameters ---------------<br><br># -- mi_fifo params --<br><br>modparam("mi_fifo", "fifo_name", "/tmp/openser_fifo")<br><br># -- usrloc params --
<br>#modparam("usrloc", "db_mode", 0)<br># Uncomment this if you want to use SQL database <br># for persistent storage and comment the previous line<br>#modparam("usrloc", "db_mode", 2)
<br><br># -- auth params --<br># use dbtext database for persistent storage<br>modparam("usrloc", "db_mode", 2)<br>modparam("usrloc|auth_db", "db_url", "dbtext:///usr/local/etc/openser/dbtext")
<br><br># Uncomment if you are using auth module<br>#<br>modparam("auth_db", "calculate_ha1", yes)<br>#<br># If you set "calculate_ha1" parameter to yes (which true in this config), <br># uncomment also the following parameter)
<br>modparam("auth_db", "user_column", "username")<br>modparam("auth_db", "password_column", "password")<br>modparam("auth_db", "domain_column", "domain")
<br><br># -- rr params --<br># add value to ;lr param to make some broken UAs happy<br>modparam("rr", "enable_full_lr", 1)<br><br># ------------------------- request routing logic -------------------<br>
<br># main routing logic<br><br>route{<br><br> # initial sanity checks -- messages with<br> # max_forwards==0, or excessively long requests<br> if (!mf_process_maxfwd_header("10")) {<br> sl_send_reply("483","Too Many Hops");
<br> log(1, "Too Many Hops\n");<br> exit;<br> };<br><br> if (msg:len >= 2048 ) {<br> sl_send_reply("513", "Message too big");<br> log(1, "Message too big\n");
<br> exit;<br> };<br><br> # we record-route all messages -- to make sure that<br> # subsequent messages will go through our proxy; that's<br> # particularly good if upstream and downstream entities<br>
# use different transport protocol<br> if (!method=="REGISTER")<br> record_route();<br><br> # subsequent messages withing a dialog should take the<br> # path determined by record-routing<br> if (loose_route()) {
<br> # mark routing logic in request<br> append_hf("P-hint: rr-enforced\r\n"); <br> route(1);<br> };<br> if (!uri==myself) {<br> # mark routing logic in request<br> append_hf("P-hint: outbound\r\n");
<br> # if you have some interdomain connections via TLS<br> #if(uri=~"@tls_domain1.net") {<br> # t_relay("tls:<a href="http://domain1.net">domain1.net</a>");<br> # exit;
<br> #} else if(uri=~"@tls_domain2.net") {<br> # t_relay("tls:<a href="http://domain2.net">domain2.net</a>");<br> # exit;<br> #}<br> route(1);<br> };<br><br>
# if the request is for other domain use UsrLoc<br> # (in case, it does not work, use the following command<br> # with proper names and addresses in it)<br> if (uri==myself) {<br><br> if (method=="REGISTER") {
<br> log(1, "this is a request REGISTER users\n");<br><br> if (!www_authorize("my.domain", "subscriber")) {<br> log(1, "this is a www_challenge\n");
<br> www_challenge("my.domain", "0");<br> exit;<br> };<br><br> save("location");<br> exit;<br> };<br><br>but when trying REGISTER user use(sjphone) in log i see:
<br>Nov 28 17:30:03 devel s-eltex[12797]: this is a request for my.domain users<br>Nov 28 17:30:03 devel s-eltex[12797]: this is a request REGISTER users<br>Nov 28 17:30:03 devel s-eltex[12797]: this is a www_challenge<br>
Nov 28 17:30:03 devel s-eltex[12794]: this is a request for my.domain users<br>Nov 28 17:30:03 devel s-eltex[12794]: this is a request REGISTER users<br>Nov 28 17:30:03 devel s-eltex[12794]: get_ha1(): Error while querying database
<br><br><br>In sjphone LOG i see:<br>Service unavailable<br>server error;<br><br>
What do I adjust not correctly?<br>