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@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users