[OpenSER-Users] auth_db module - get_ha1(): Error while querying database

[Daniel-Constantin Mierla]

Hello,

can you list the content of directory: /usr/local/etc/openser/dbtext ?

Also, if you can set the debug=9 in cofig, run again, get the output and 
send it to me, would help a lot.

Thanks,
Daniel

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