Hello: I use postgresql to authorize the user.But it cann't work.Who can give me some suggestion? Thank you very much! My error log and openser.cfg fileas follows: #Error log
May 18 12:24:43 th016184 /usr/local/sbin/openser[4358]: INFO: statistics manager successfully initialized May 18 12:24:43 th016184 /usr/local/sbin/openser[4358]: PostgreSQL - initializing May 18 12:24:43 th016184 /usr/local/sbin/openser[4358]: StateLess module - initializing May 18 12:24:43 th016184 /usr/local/sbin/openser[4358]: TM - initializing... May 18 12:24:43 th016184 /usr/local/sbin/openser[4358]: Maxfwd module- initializing May 18 12:24:43 th016184 /usr/local/sbin/openser[4358]: INFO:ul_init_locks: locks array size 512 May 18 12:24:43 th016184 /usr/local/sbin/openser[4358]: TextOPS - initializing May 18 12:24:43 th016184 /usr/local/sbin/openser[4358]: AUTH module - initializing May 18 12:24:43 th016184 /usr/local/sbin/openser[4358]: AUTH_DB module - initializing May 18 12:24:44 th016184 /usr/local/sbin/openser[4358]: register_udomain(): Cannot open database connection file! May 18 12:24:44 th016184 /usr/local/sbin/openser[4358]: domain_fixup(): Error while registering domain May 18 12:24:44 th016184 /usr/local/sbin/openser[4358]: ERROR: fix_actions: fixing failed (code=-1) at cfg line 145 May 18 12:24:44 th016184 /usr/local/sbin/openser[4358]: INFO:mi_fifo:mi_destroy: process hasn't been created -> nothing to kill
#openser.cfg
loadmodule "postgres.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" loadmodule "xlog.so" # Uncomment this if you want digest authentication # mysql.so must be loaded ! 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) modparam("usrloc", "db_url", "postgres://openser:openserrw@localhost/openser") # -- auth params -- # 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", "db_url", "postgres://openser:openserrw@localhost/openser") modparam("auth_db", "password_column", "password") # -- 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"); exit; };
if (msg:len >= 2048 ) { sl_send_reply("513", "Message too big"); 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=~"localhost") { # mark routing logic in request # 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"); # exit; #} else if(uri=~"@tls_domain2.net") { # t_relay("tls: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=~"localhost") {
if (method=="REGISTER") {
# Uncomment this if you want to use digest authentication if (!www_authorize("localhost", "subscriber")) { www_challenge("localhost", "0"); exit; };
save("location"); exit; };
lookup("aliases"); if (!uri==myself) { append_hf("P-hint: outbound alias\r\n"); route(1); };
# native SIP destinations are handled using our USRLOC DB if (!lookup("location")) { sl_send_reply("404", "Not Found"); exit; }; append_hf("P-hint: usrloc applied\r\n"); };
route(1); }
route[1] { # send it out now; use stateful forwarding as it works reliably # even for UDP2TCP if (!t_relay()) { sl_reply_error(); }; exit; }