<div dir="ltr">Are you able to connect to the local Mysql DB using:<div><span style="font-family:arial,sans-serif;font-size:13.333333969116211px">modparam("usrloc", "db_url", "mysql://opensips:opensipsrw@</span><span style="font-family:arial,sans-serif;font-size:13.333333969116211px">localhost/opensips")</span><br>
</div><div><span style="font-family:arial,sans-serif;font-size:13.333333969116211px"><br></span></div><div><span style="font-family:arial,sans-serif;font-size:13.333333969116211px">use: mysql -p</span><span style="font-family:arial,sans-serif;font-size:13.333333969116211px">opensipsrw -u opensips -D opensips</span></div>
<div><span style="font-family:arial,sans-serif;font-size:13.333333969116211px"><br></span></div><div><span style="font-family:arial,sans-serif;font-size:13.333333969116211px">We have to make sure the database exists first and that you are able to connect to it.</span></div>
<div><span style="font-family:arial,sans-serif;font-size:13.333333969116211px"><br></span></div><div><span style="font-family:arial,sans-serif;font-size:13.333333969116211px">W</span></div></div><div class="gmail_extra"><br>
<br><div class="gmail_quote">On Wed, Oct 30, 2013 at 5:01 PM, Luis Pérez Urteaga <span dir="ltr"><<a href="mailto:devicer@hotmail.com" target="_blank">devicer@hotmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div dir="ltr">Hi Wilmar,<br>
<br>
This in my configuration:<br>
<br><span lang="ES-PE">
#<br>
# $Id$<br>
#<br>
# OpenSIPS residential configuration script<br>
# by OpenSIPS Solutions <<a href="mailto:team@opensips-solutions.com" target="_blank">team@opensips-solutions.com</a>><br>
#<br>
# This script was generated via "make menuconfig", from<br>
# the "Residential" scenario.<br>
# You can enable / disable more features / functionalities by<br>
# re-generating the scenario with different options.#<br>
#<br>
# Please refer to the Core CookBook at:<br>
# <a href="http://www.opensips.org/Resources/DocsCookbooks" target="_blank">http://www.opensips.org/Resources/DocsCookbooks</a><br>
# for a explanation of possible statements, functions and parameters.<br>
#<br>
<br>
####### Global Parameters #########<br>
debug=3<br>
log_stderror=no<br>
log_facility=LOG_LOCAL0<br>
fork=yes<br>
children=4<br>
/* uncomment the following lines to enable debugging */<br>
#debug=6<br>
#fork=no<br>
#log_stderror=yes<br>
/* uncomment the next line to enable the auto temporary blacklisting of <br>
not available destinations (default disabled) */<br>
#disable_dns_blacklist=no<br>
/* uncomment the next line to enable IPv6 lookup after IPv4 dns <br>
lookup failures (default disabled) */<br>
#dns_try_ipv6=yes<br>
/* comment the next line to enable the auto discovery of local aliases<br>
based on revers DNS on IPs */<br>
auto_aliases=no<br>
<br>
listen=udp:<a href="http://127.0.0.1:5060" target="_blank">127.0.0.1:5060</a> # CUSTOMIZE ME<br>
<br>
disable_tcp=no<br>
disable_tls=yes<br>
<br>
####### Modules Section ########<br>
#set module path<br>
mpath="/usr/local/lib64/opensips/modules/"<br>
loadmodule "db_mysql.so"<br>
loadmodule "auth.so" <br>
#loadmodule "auth_db.so"<br>
#modparam("auth_db", "password_column", "password")<br>
#modparam("auth_db", "calculate_ha1", yes)<br>
<br>
<br>
#### SIGNALING module<br>
loadmodule "signaling.so"<br>
#### StateLess module<br>
loadmodule "sl.so"<br>
#### Transaction Module<br>
loadmodule "tm.so"<br>
modparam("tm", "fr_timer", 5)<br>
modparam("tm", "fr_inv_timer", 30)<br>
modparam("tm", "restart_fr_on_each_reply", 0)<br>
modparam("tm", "onreply_avp_mode", 1)<br>
#### Record Route Module<br>
loadmodule "rr.so"<br>
/* do not append from tag to the RR (no need for this script) */<br>
modparam("rr", "append_fromtag", 0)<br>
#### MAX ForWarD module<br>
loadmodule "maxfwd.so"<br>
#### SIP MSG OPerationS module<br>
loadmodule "sipmsgops.so"<br>
#### FIFO Management Interface<br>
loadmodule "mi_fifo.so"<br>
modparam("mi_fifo", "fifo_name", "/tmp/opensips_fifo")<br>
modparam("mi_fifo", "fifo_mode", 0666)<br>
<br>
#### URI module<br>
loadmodule "uri.so"<br>
modparam("uri", "use_uri_table", 0)<br>
#### USeR LOCation module<br>
loadmodule "usrloc.so"<br>
modparam("usrloc", "nat_bflag", "NAT")<br>
##modparam("usrloc", "db_mode",0)<br>
modparam("usrloc", "db_mode", 2)<br>
modparam("usrloc", "db_url", "mysql://opensips:opensipsrw@localhost/opensips")<br>
#### REGISTRAR module<br>
loadmodule "registrar.so"<br>
modparam("registrar", "tcp_persistent_flag", "TCP_PERSISTENT")<br>
/* uncomment the next line not to allow more than 10 contacts per AOR */<br>
#modparam("registrar", "max_contacts", 10)<br>
#### ACCounting module<br>
loadmodule "acc.so"<br>
/* what special events should be accounted ? */<br>
modparam("acc", "early_media", 0)<br>
modparam("acc", "report_cancels", 0)<br>
/* by default we 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>
modparam("acc", "failed_transaction_flag", "ACC_FAILED")<br>
/* account triggers (flags) */<br>
modparam("acc", "log_flag", "ACC_DO")<br>
modparam("acc", "log_missed_flag", "ACC_MISSED")<br>
<br>
####### Routing Logic ########<br>
# main request routing logic<br>
route{<br>
if (!mf_process_maxfwd_header("10")) {<br>
sl_send_reply("483","Too Many Hops");<br>
exit;<br>
}<br>
if (has_totag()) {<br>
# sequential requests within a dialog should<br>
# take the path determined by record-routing<br>
if (loose_route()) {<br>
<br>
if (is_method("BYE")) {<br>
setflag(ACC_DO); # do accounting ...<br>
setflag(ACC_FAILED); # ... even if the transaction fails<br>
} else if (is_method("INVITE")) {<br>
# even if in most of the cases is useless, do RR for<br>
# re-INVITEs alos, as some buggy clients do change route set<br>
# during the dialog.<br>
record_route();<br>
}<br>
# route it out to whatever destination was set by loose_route()<br>
# in $du (destination URI).<br>
route(relay);<br>
} else {<br>
<br>
if ( is_method("ACK") ) {<br>
if ( t_check_trans() ) {<br>
# non loose-route, but stateful ACK; must be an ACK after <br>
# a 487 or e.g. 404 from upstream server<br>
t_relay();<br>
exit;<br>
} else {<br>
# ACK without matching transaction -><br>
# ignore and discard<br>
exit;<br>
}<br>
}<br>
sl_send_reply("404","Not here");<br>
}<br>
exit;<br>
}<br>
# CANCEL processing<br>
if (is_method("CANCEL"))<br>
{<br>
if (t_check_trans())<br>
t_relay();<br>
exit;<br>
}<br>
t_check_trans();<br>
if ( !(is_method("REGISTER") ) ) {<br>
if (from_uri==myself)<br>
{<br>
} else {<br>
# if caller is not local, then called number must be local<br>
if (!uri==myself) {<br>
send_reply("403","Rely forbidden");<br>
exit;<br>
}<br>
}<br>
}<br>
# preloaded route checking<br>
if (loose_route()) {<br>
xlog("L_ERR",<br>
"Attempt to route with preloaded Route's [$fu/$tu/$ru/$ci]");<br>
if (!is_method("ACK"))<br>
sl_send_reply("403","Preload Route denied");<br>
exit;<br>
}<br>
# record routing<br>
if (!is_method("REGISTER|MESSAGE"))<br>
record_route();<br>
# account only INVITEs<br>
if (is_method("INVITE")) {<br>
<br>
setflag(ACC_DO); # do accounting<br>
}<br>
if (!uri==myself) {<br>
append_hf("P-hint: outbound\r\n"); <br>
route(relay);<br>
}<br>
# requests for my domain<br>
if (is_method("PUBLISH|SUBSCRIBE"))<br>
{<br>
sl_send_reply("503", "Service Unavailable");<br>
exit;<br>
}<br>
if (is_method("REGISTER"))<br>
{<br>
if ( 0 ) setflag(TCP_PERSISTENT);<br>
if (!save("location"))<br>
sl_reply_error();<br>
exit;<br>
}<br>
if ($rU==NULL) {<br>
# request with no Username in RURI<br>
sl_send_reply("484","Address Incomplete");<br>
exit;<br>
}<br>
# do lookup with method filtering<br>
if (!lookup("location","m")) {<br>
t_newtran();<br>
t_reply("404", "Not Found");<br>
exit;<br>
} <br>
# when routing via usrloc, log the missed calls also<br>
setflag(ACC_MISSED);<br>
route(relay);<br>
}<br>
<br>
route[relay] {<br>
# for INVITEs enable some additional helper routes<br>
if (is_method("INVITE")) {<br>
t_on_branch("per_branch_ops");<br>
t_on_reply("handle_nat");<br>
t_on_failure("missed_call");<br>
}<br>
if (!t_relay()) {<br>
send_reply("500","Internal Error");<br>
};<br>
exit;<br>
}<br>
<br>
<br>
<br>
branch_route[per_branch_ops] {<br>
xlog("new branch at $ru\n");<br>
}<br>
<br>
onreply_route[handle_nat] {<br>
<br>
xlog("incoming reply\n");<br>
}<br>
<br>
failure_route[missed_call] {<br>
if (t_was_cancelled()) {<br>
exit;<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>
</span><br> <br>
<div>
<hr>
Date: Wed, 30 Oct 2013 16:30:19 -0400<br>From: <a href="mailto:wilmar.campos@gmail.com" target="_blank">wilmar.campos@gmail.com</a><br>To: <a href="mailto:users@lists.opensips.org" target="_blank">users@lists.opensips.org</a><br>
Subject: Re: [OpenSIPS-Users] Help - WARNING: database engine not found - tried 'MYSQL'<div><div class="h5"><br><br>
<div dir="ltr">Hi Luis,
<div>Can you include the configuration you have for the mysql DB in the opensips.cfg file?</div>
<div><br></div>
<div>Thanks,</div>
<div><br></div>
<div>W</div></div>
<div><br><br>
<div>On Wed, Oct 30, 2013 at 4:09 PM, Luis Pérez Urteaga <span dir="ltr"><<a href="mailto:devicer@hotmail.com" target="_blank">devicer@hotmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;PADDING-LEFT:1ex">
<div>
<div dir="ltr"><span lang="en"><span><span lang="en"><span>I could</span> <span>compile</span> <span>OpenSIPS</span> <span>but</span> <span>when I try to</span> <span>start it,</span> <span>I get the following</span> <span>error:</span><br>
<br><span>WARNING</span><span>:</span> <span>database engine</span> <span>not found -</span> <span>tried</span> <span>'</span><span>MYSQL</span><span>'</span><br><br><span>Db_mysql.so</span> <span>file</span> <span>was created</span> <span>but</span> <span>not copied</span> <span>in the folder</span> <span>./usr/local/lib64/opensips/modules</span> <span>/ so</span> <span>I copied</span> <span>by hand.</span><br>
<br><span>The error</span> <span>still remains.</span> ¿<span>Does anyone know</span> <span>why</span> <span>this happens</span><span>?</span></span></span></span> </div></div><br>_______________________________________________<br>
Users mailing list<br><a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div><br>_______________________________________________ Users mailing list <a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a></div>
</div></div>                                            </div></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>