Alright.. here is some dbg level 9 output of my problem. Basically openser starts, says it starts successfully, and then quits. I think it may have something to do with the fact that it is trying to access a local database even though it has been configured to access a remote one. I am quite sure that it is accessing the proper cfg, cause when I put garbage in it I get an error. Any help, clues, snide remarks, cryptic-guru-riddle-answers would be appreciated.
Dec 1 11:48:41 amnesiac openser: 0(0) db_init: Connection 'mysql://openser:openserrw@localhost /openser' not found in pool Dec 1 11:48:41 amnesiac openser: 0(0) new_connection: Opening MySQL connection: mysql://opense r:openserrw@localhost/openser Dec 1 11:48:41 amnesiac openser: 0(0) new_connection: Can't connect to local MySQL server thro ugh socket '/var/lib/mysql/mysql.sock' (2) Dec 1 11:48:41 amnesiac openser: 0(0) register_udomain(): Can not open database connection Dec 1 11:48:41 amnesiac openser: 0(0) domain_fixup(): Error while registering domain Dec 1 11:48:41 amnesiac openser: ERROR: error -1 while trying to fix configuration Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: tm_shutdown : start Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: unlink_timer_lists : emptying DELETE list Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: tm_shutdown : emptying hash table Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: tm_shutdown : releasing timers Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: tm_shutdown : removing semaphores Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: tm_shutdown : destroying tmcb lists Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: tm_shutdown : done Dec 1 11:48:41 amnesiac openser: 0(3791) shm_mem_destroy Dec 1 11:48:41 amnesiac openser: 0(3791) destroying the shared memory lock Dec 1 11:48:41 amnesiac openser: openser startup succeeded
my config file is simply the sample config, modified with the suggestions to access a remote mysql database, it looks like this:
# # $Id: openser.cfg,v 1.5 2005/10/28 19:45:33 bogdan_iancu Exp $ # # simple quick-start config script #
# ----------- global configuration parameters ------------------------
debug=9 # debug level (cmd line: -dddddddddd) fork=yes log_stderror=yes # (cmd line: -E)
/* Uncomment these lines to enter debugging mode fork=no log_stderror=yes */
check_via=no # (cmd. line: -v) dns=no # (cmd. line: -r) rev_dns=no # (cmd. line: -R) port=5060 children=4 fifo="/tmp/openser_fifo" # Uncomment this if you want to use SQL database loadmodule "//lib/openser/modules/mysql.so"
loadmodule "//lib/openser/modules/sl.so" loadmodule "//lib/openser/modules/tm.so" loadmodule "//lib/openser/modules/rr.so" loadmodule "//lib/openser/modules/maxfwd.so" loadmodule "//lib/openser/modules/usrloc.so" loadmodule "//lib/openser/modules/registrar.so" loadmodule "//lib/openser/modules/textops.so"
# Uncomment this if you want digest authentication # mysql.so must be loaded ! loadmodule "//lib/openser/modules/auth.so" loadmodule "//lib/openser/modules/auth_db.so"
# ----------------- setting module-specific parameters ---------------
modparam("auth_db", "db_url", "mysql://serusr:testpass@192.168.0.54/ser")
# -- 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 -- # 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", "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==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_to_tls("IP_domain1","port_domain1"); # exit; #} else if(uri=~"@tls_domain2.net") { # t_relay_to_tls("IP_domain2","port_domain2"); # 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") {
# Uncomment this if you want to use digest authentication #if (!www_authorize("openser.org", "subscriber")) { # www_challenge("openser.org", "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; }
Hi Rick,
the error is generated by usrloc module - your script does not set the db_url for this module. Try to disable the DB support: modparam("usrloc", "db_mode", 0) or to set the db_url: modparam("usrloc", "db_url", "mysql://serusr:testpass@192.168.0.54/ser")
regards, bogdan
rick@eltopia.com wrote:
Alright.. here is some dbg level 9 output of my problem. Basically openser starts, says it starts successfully, and then quits. I think it may have something to do with the fact that it is trying to access a local database even though it has been configured to access a remote one. I am quite sure that it is accessing the proper cfg, cause when I put garbage in it I get an error. Any help, clues, snide remarks, cryptic-guru-riddle-answers would be appreciated.
Dec 1 11:48:41 amnesiac openser: 0(0) db_init: Connection 'mysql://openser:openserrw@localhost /openser' not found in pool Dec 1 11:48:41 amnesiac openser: 0(0) new_connection: Opening MySQL connection: mysql://opense r:openserrw@localhost/openser Dec 1 11:48:41 amnesiac openser: 0(0) new_connection: Can't connect to local MySQL server thro ugh socket '/var/lib/mysql/mysql.sock' (2) Dec 1 11:48:41 amnesiac openser: 0(0) register_udomain(): Can not open database connection Dec 1 11:48:41 amnesiac openser: 0(0) domain_fixup(): Error while registering domain Dec 1 11:48:41 amnesiac openser: ERROR: error -1 while trying to fix configuration Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: tm_shutdown : start Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: unlink_timer_lists : emptying DELETE list Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: tm_shutdown : emptying hash table Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: tm_shutdown : releasing timers Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: tm_shutdown : removing semaphores Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: tm_shutdown : destroying tmcb lists Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: tm_shutdown : done Dec 1 11:48:41 amnesiac openser: 0(3791) shm_mem_destroy Dec 1 11:48:41 amnesiac openser: 0(3791) destroying the shared memory lock Dec 1 11:48:41 amnesiac openser: openser startup succeeded
my config file is simply the sample config, modified with the suggestions to access a remote mysql database, it looks like this:
# # $Id: openser.cfg,v 1.5 2005/10/28 19:45:33 bogdan_iancu Exp $ # # simple quick-start config script #
# ----------- global configuration parameters ------------------------
debug=9 # debug level (cmd line: -dddddddddd) fork=yes log_stderror=yes # (cmd line: -E)
/* Uncomment these lines to enter debugging mode fork=no log_stderror=yes */
check_via=no # (cmd. line: -v) dns=no # (cmd. line: -r) rev_dns=no # (cmd. line: -R) port=5060 children=4 fifo="/tmp/openser_fifo" # Uncomment this if you want to use SQL database loadmodule "//lib/openser/modules/mysql.so"
loadmodule "//lib/openser/modules/sl.so" loadmodule "//lib/openser/modules/tm.so" loadmodule "//lib/openser/modules/rr.so" loadmodule "//lib/openser/modules/maxfwd.so" loadmodule "//lib/openser/modules/usrloc.so" loadmodule "//lib/openser/modules/registrar.so" loadmodule "//lib/openser/modules/textops.so"
# Uncomment this if you want digest authentication # mysql.so must be loaded ! loadmodule "//lib/openser/modules/auth.so" loadmodule "//lib/openser/modules/auth_db.so"
# ----------------- setting module-specific parameters ---------------
modparam("auth_db", "db_url", "mysql://serusr:testpass@192.168.0.54/ser")
# -- 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 -- # 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", "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==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_to_tls("IP_domain1","port_domain1"); # exit; #} else if(uri=~"@tls_domain2.net") { # t_relay_to_tls("IP_domain2","port_domain2"); # 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") { # Uncomment this if you want to use digest authentication #if (!www_authorize("openser.org", "subscriber")) { # www_challenge("openser.org", "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; }
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
-
Bogdan-Andrei Iancu -
rickļ¼ eltopia.com