<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><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 <team@opensips-solutions.com><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>
# http://www.opensips.org/Resources/DocsCookbooks<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:127.0.0.1:5060 # 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 id=stopSpelling>
Date: Wed, 30 Oct 2013 16:30:19 -0400<BR>From: wilmar.campos@gmail.com<BR>To: users@lists.opensips.org<BR>Subject: Re: [OpenSIPS-Users] Help - WARNING: database engine not found - tried 'MYSQL'<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 class=ecxgmail_extra><BR><BR>
<DIV class=ecxgmail_quote>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" class=ecxgmail_quote>
<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">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 Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users</DIV> </div></body>
</html>