<span>I </span>apologize, I copy n' paste the wrong config file to my email.<br><br>Below my signature is the correct openser.cfg with the load of mysql.so and the db_mode set.<br><br>It does crash openser. But this time I managed to have some more indication in the log file:<br>
[...]<br>Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27620]: CRITICAL:core:receive_fd: EOF on 11<br>Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27582]: INFO:core:handle_sigs: child process 27586 exited by a signal 4<br>
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27582]: INFO:core:handle_sigs: core was generated<br>Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27582]: INFO:core:handle_sigs: terminating due to SIGCHLD<br>Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27606]: INFO:core:sig_usr: signal 15 received<br>
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27609]: INFO:core:sig_usr: signal 15 received<br>Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27617]: INFO:core:sig_usr: signal 15 received<br>Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27620]: INFO:core:sig_usr: signal 15 received<br>
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27615]: INFO:core:sig_usr: signal 15 received<br>Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27613]: INFO:core:sig_usr: signal 15 received<br>Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27588]: INFO:core:sig_usr: signal 15 received<br>
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27590]: INFO:core:sig_usr: signal 15 received<br>Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27596]: INFO:core:sig_usr: signal 15 received<br>Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27611]: INFO:core:sig_usr: signal 15 received<br>
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27592]: INFO:core:sig_usr: signal 15 received<br>Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27598]: INFO:core:sig_usr: signal 15 received<br>Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27600]: INFO:core:sig_usr: signal 15 received<br>
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27602]: INFO:core:sig_usr: signal 15 received<br>Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27604]: INFO:core:sig_usr: signal 15 received<br>Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27594]: INFO:core:sig_usr: signal 15 received<br>
Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27595]: INFO:core:sig_usr: signal 15 received<br>Apr 16 15:00:41 vpngw /usr/local/sbin/openser[27619]: INFO:core:sig_usr: signal 15 received<br><br>Regards,<br>Pascal<br><br><br>
#<br># $Id: openser.cfg 3542 2008-01-16 15:00:34Z miconda $<br>#<br># OpenSER basic configuration script<br># by Anca Vamanu <<a href="mailto:anca@voice-system.ro">anca@voice-system.ro</a>><br>#<br># Please refer to the Core CookBook at <a href="http://www.openser.org/dokuwiki/doku.php">http://www.openser.org/dokuwiki/doku.php</a><br>
# for a explanation of possible statements, functions and parameters.<br>#<br><br><br>####### Global Parameters #########<br><br>debug=3<br>log_stderror=no<br>log_facility=LOG_LOCAL0<br><br>fork=yes<br>children=4<br><br>/* uncomment the following lines to enable debugging */<br>
#debug=6<br>#fork=no<br>#log_stderror=yes<br><br>/* uncomment the next line to disable TCP (default on) */<br>#disable_tcp=yes<br><br>/* uncomment the next line to enable the auto temporary blacklisting of <br> not available destinations (default disabled) */<br>
#disable_dns_blacklist=no<br><br>/* uncomment the next line to enable IPv6 lookup after IPv4 dns <br> lookup failures (default disabled) */<br>#dns_try_ipv6=yes<br><br>/* uncomment the next line to disable the auto discovery of local aliases<br>
based on revers DNS on IPs (default on) */<br>#auto_aliases=no<br><br>/* uncomment the following lines to enable TLS support (default off) */<br>#disable_tls = no<br>#listen = tls:your_IP:5061<br>#tls_verify_server = 1<br>
#tls_verify_client = 1<br>#tls_require_client_certificate = 0<br>#tls_method = TLSv1<br>#tls_certificate = "/usr/local/etc/openser/tls/user/user-cert.pem"<br>#tls_private_key = "/usr/local/etc/openser/tls/user/user-privkey.pem"<br>
#tls_ca_list = "/usr/local/etc/openser/tls/user/user-calist.pem"<br><br><br>port=5060<br><br>/* uncomment and configure the following line if you want openser to <br> bind on a specific interface/port/proto (default bind on all available) */<br>
#listen=udp:<a href="http://192.168.1.2:5060">192.168.1.2:5060</a><br><br>alias=<a href="http://ptt.domain.net">ptt.domain.net</a><br><br>####### Modules Section ########<br><br>#set module path<br>mpath="/usr/local/lib/openser/modules/"<br>
<br>/* uncomment next line for MySQL DB support */<br>loadmodule "mysql.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>loadmodule "uri_db.so"<br>loadmodule "uri.so"<br>loadmodule "xlog.so"<br>
loadmodule "acc.so"<br>/* uncomment next lines for MySQL based authentication support <br> NOTE: a DB (like mysql) module must be also loaded */<br>#loadmodule "auth.so"<br>#loadmodule "auth_db.so"<br>
/* uncomment next line for aliases support<br> NOTE: a DB (like mysql) module must be also loaded */<br>#loadmodule "alias_db.so"<br>/* uncomment next line for multi-domain support<br> NOTE: a DB (like mysql) module must be also loaded<br>
NOTE: be sure and enable multi-domain support in all used modules<br> (see "multi-module params" section ) */<br>#loadmodule "domain.so"<br>/* uncomment the next two lines for presence server support<br>
NOTE: a DB (like mysql) module must be also loaded */<br>#loadmodule "presence.so"<br>#loadmodule "presence_xml.so"<br><br><br># ----------------- setting module-specific parameters ---------------<br>
<br><br># ----- mi_fifo params -----<br>modparam("mi_fifo", "fifo_name", "/tmp/openser_fifo")<br><br><br># ----- rr params -----<br># add value to ;lr param to cope with most of the UAs<br>modparam("rr", "enable_full_lr", 1)<br>
# do not append from tag to the RR (no need for this script)<br>modparam("rr", "append_fromtag", 0)<br><br><br># ----- rr params -----<br>modparam("registrar", "method_filtering", 1)<br>
/* uncomment the next line to disable parallel forking via location */<br># modparam("registrar", "append_branches", 0)<br>/* uncomment the next line not to allow more than 10 contacts per AOR */<br>#modparam("registrar", "max_contacts", 10)<br>
<br><br># ----- uri_db params -----<br>/* by default we disable the DB support in the module as we do not need it<br> in this configuration */<br>modparam("uri_db", "use_uri_table", 0)<br>modparam("uri_db", "db_url", "")<br>
<br><br># ----- acc params -----<br>/* what sepcial events should be accounted ? */<br>modparam("acc", "early_media", 1)<br>modparam("acc", "report_ack", 1)<br>modparam("acc", "report_cancels", 1)<br>
/* by default ww do not adjust the direct of the sequential requests.<br> if you enable this parameter, be sure the enable "append_fromtag"<br> in "rr" module */<br>modparam("acc", "detect_direction", 0)<br>
/* account triggers (flags) */<br>modparam("acc", "failed_transaction_flag", 3)<br>modparam("acc", "log_flag", 1)<br>modparam("acc", "log_missed_flag", 2)<br>/* uncomment the following lines to enable DB accounting also */<br>
modparam("acc", "db_flag", 1)<br>modparam("acc", "db_missed_flag", 2)<br><br><br># ----- usrloc params -----<br>#modparam("usrloc", "db_mode", 0)<br>modparam("usrloc", "db_mode", 1)<br>
modparam("usrloc", "db_url", "mysql://openser:openserrw@localhost/openser")<br><br># ----- auth_db params -----<br>/* uncomment the following lines if you want to enable the DB based<br> authentication */<br>
#modparam("auth_db", "calculate_ha1", yes)<br>#modparam("auth_db", "password_column", "password")<br>#modparam("auth_db", "db_url",<br># "mysql://<a href="http://openser:openserrw@192.168.1.3/openser_1_3">openser:openserrw@192.168.1.3/openser_1_3</a>")<br>
#modparam("auth_db", "load_credentials", "")<br><br><br># ----- alias_db params -----<br>/* uncomment the following lines if you want to enable the DB based<br> aliases */<br>#modparam("alias_db", "db_url",<br>
# "mysql://<a href="http://openser:openserrw@192.168.1.3/openser_1_3">openser:openserrw@192.168.1.3/openser_1_3</a>")<br><br><br># ----- domain params -----<br>/* uncomment the following lines to enable multi-domain detection<br>
support */<br>#modparam("domain", "db_url",<br># "mysql://<a href="http://openser:openserrw@192.168.1.3/openser_1_3">openser:openserrw@192.168.1.3/openser_1_3</a>")<br>#modparam("domain", "db_mode", 1) # Use caching<br>
<br><br># ----- multi-module params -----<br>/* uncomment the following line if you want to enable multi-domain support<br> in the modules (dafault off) */<br>#modparam("alias_db|auth_db|usrloc|uri_db", "use_domain", 1)<br>
<br><br># ----- presence params -----<br>/* uncomment the following lines if you want to enable presence */<br>#modparam("presence|presence_xml", "db_url",<br># "mysql://<a href="http://openser:openserrw@192.168.1.3/openser_1_3">openser:openserrw@192.168.1.3/openser_1_3</a>")<br>
#modparam("presence_xml", "force_active", 1)<br>#modparam("presence", "server_address", "sip:<a href="http://192.168.1.2:5060">192.168.1.2:5060</a>")<br><br><br>####### Routing Logic ########<br>
<br><br># main request routing logic<br><br>route{<br><br> if (!mf_process_maxfwd_header("10")) {<br> sl_send_reply("483","Too Many Hops");<br> exit;<br> }<br><br> if (has_totag()) {<br>
# sequential request withing a dialog should<br> # take the path determined by record-routing<br> if (loose_route()) {<br> if (is_method("BYE")) {<br> setflag(1); # do accouting ...<br>
setflag(3); # ... even if the transaction fails<br> }<br> route(1);<br> } else {<br> /* uncomment the following lines if you want to enable presence */<br> ##if (is_method("SUBSCRIBE") && $rd == "your.server.ip.address") {<br>
## # in-dialog subscribe requests<br> ## route(2);<br> ## exit;<br> ##}<br> if ( is_method("ACK") ) {<br> if ( t_check_trans() ) {<br>
# non loose-route, but stateful ACK; must be an ACK after a 487 or e.g. 404 from upstream server<br> t_relay();<br> exit;<br> } else {<br> # ACK without matching transaction ... ignore and discard.\n");<br>
exit;<br> }<br> }<br> sl_send_reply("404","Not here");<br> }<br> exit;<br> }<br><br> #initial requests<br><br> # CANCEL processing<br>
if (is_method("CANCEL"))<br> {<br> if (t_check_trans())<br> t_relay();<br> exit;<br> }<br><br> t_check_trans();<br><br> # authenticate if from local subscriber (uncomment to enable auth)<br>
##if (!(method=="REGISTER") && from_uri==myself)<br> ##{<br> ## if (!proxy_authorize("", "subscriber")) {<br> ## proxy_challenge("", "0");<br>
## exit;<br> ## }<br> ## if (!check_from()) {<br> ## sl_send_reply("403","Forbidden auth ID");<br> ## exit;<br> ## }<br> ##<br> ## consume_credentials();<br>
## # caller authenticated<br> ##}<br><br> # record routing<br> if (!is_method("REGISTER|MESSAGE"))<br> record_route();<br><br> # account only INVITEs<br> if (is_method("INVITE")) {<br>
setflag(1); # do accouting<br> }<br> if (!uri==myself)<br> /* replace with following line if multi-domain support is used */<br> ##if (!is_uri_host_local())<br> {<br><br> append_hf("P-hint: outbound\r\n");<br>
# if you have some interdomain connections via TLS<br> ##if($rd=="<a href="http://tls_domain1.net">tls_domain1.net</a>") {<br> ## t_relay("tls:<a href="http://domain1.net">domain1.net</a>");<br>
## exit;<br> ##} else if($rd=="<a href="http://tls_domain2.net">tls_domain2.net</a>") {<br> ## t_relay("tls:<a href="http://domain2.net">domain2.net</a>");<br> ## exit;<br>
##}<br> route(1);<br> }<br><br> # requests for my domain<br><br> /* uncomment this if you want to enable presence server <br> and comment the next 'if' block<br> NOTE: uncomment also the definition of route[2] from below */<br>
##if( is_method("PUBLISH|SUBSCRIBE"))<br> ## route(2);<br><br> if (is_method("PUBLISH"))<br> {<br> sl_send_reply("503", "Service Unavailable");<br> exit;<br>
}<br> <br><br> if (is_method("REGISTER"))<br> {<br> # authenticate the REGISTER requests (uncomment to enable auth)<br> ##if (!www_authorize("", "subscriber"))<br> ##{<br>
## www_challenge("", "0");<br> ## exit;<br> ##}<br> ##<br> ##if (!check_to()) <br> ##{<br> ## sl_send_reply("403","Forbidden auth ID");<br>
## exit;<br> ##}<br><br> if (!save("location"))<br> sl_reply_error();<br><br> exit;<br> }<br><br> if ($rU==NULL) {<br> # request with no Username in RURI<br>
sl_send_reply("484","Address Incomplete");<br> exit;<br> }<br><br> # apply DB based aliases (uncomment to enable)<br> ##alias_db_lookup("dbaliases");<br><br> if (!lookup("location")) {<br>
switch ($retcode) {<br> case -1:<br> case -3:<br> t_newtran();<br> t_reply("404", "Not Found");<br> exit;<br> case -2:<br>
sl_send_reply("405", "Method Not Allowed");<br> exit;<br> }<br> }<br><br> # when routing via usrloc, log the missed calls also<br> setflag(2);<br><br> route(1);<br>
}<br><br><br>route[1] {<br> xlog("L_WARN", "Routing block 1. Method [$rm], request URI [$ru]\n");<br><br> # send it out now; use stateful forwarding as it works reliably<br> # even for UDP2TCP<br>
if (!t_relay()) {<br> sl_reply_error();<br> };<br> exit;<br><br>}<br><br><br># Presence route<br>/* uncomment the whole following route for enabling presence<br> NOTE: do not forget to enable the call of this route from the main<br>
route */<br>##route[2]<br>##{<br>## if (!t_newtran())<br>## {<br>## sl_reply_error();<br>## exit;<br>## };<br>##<br>## if(is_method("PUBLISH"))<br>## {<br>## handle_publish();<br>
## t_release();<br>## }<br>## else<br>## if( is_method("SUBSCRIBE"))<br>## {<br>## handle_subscribe();<br>## t_release();<br>## }<br>##<br>## exit;<br>##}<br><br><br>branch_route[2] {<br>
xlog("new branch at $ru\n");<br>}<br><br><br>onreply_route[2] {<br> xlog("incoming reply\n");<br>}<br><br><br>failure_route[1] {<br> if (t_was_cancelled()) {<br> exit;<br> }<br><br>
# uncomment the following lines if you want to block client <br> # redirect based on 3xx replies.<br> ##if (t_check_status("3[0-9][0-9]")) {<br> ##t_reply("404","Not found");<br>
## exit;<br> ##}<br><br> # uncomment the following lines if you want to redirect the failed <br> # calls to a different new destination<br> ##if (t_check_status("486|408")) {<br> ## sethostport("<a href="http://192.168.2.100:5060">192.168.2.100:5060</a>");<br>
## append_branch();<br> ## # do not set the missed call flag again<br> ## t_relay();<br> ##}<br>}<br><br><br><div class="gmail_quote">On Wed, Apr 16, 2008 at 2:01 PM, Henning Westerholt <<a href="mailto:henning.westerholt@1und1.de">henning.westerholt@1und1.de</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d">On Wednesday 16 April 2008, Pascal Maugeri wrote:<br>
> I've got a weird problem I do not manage to solve alone.<br>
><br>
> I'm using v1.3.0 with mysql.so and and usrloc.so, on redhat enterprise v4.<br>
><br>
> When there is a permanent user location in the database (added previously<br>
> with openserctl ul add), the server does not start:<br>
> - there is no log about any error,<br>
> - after starting the server, there is no running openser process<br>
><br>
> Is it a server bug or should I activate/configure something else ?<br>
><br>
> Below my signature is my configuration file.<br>
<br>
</div>Hi Pascal,<br>
<br>
looking to the config file it seems that you don't load the database driver at<br>
all. Perhaps you commented this out for debugging? Without a database driver<br>
the usrloc module will not load if you specify a db_mode that needs a db<br>
connection.<br>
<br>
Cheers,<br>
<font color="#888888"><br>
Henning<br>
</font></blockquote></div><br>