<div dir="ltr">Can you please list the modules in: <span style="font-family:arial,sans-serif;font-size:13.333333969116211px">/usr/local/lib64/</span><span style="font-family:arial,sans-serif;font-size:13.333333969116211px">opensips/modules/</span><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:42 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">Wilmar:<br>
<br>
The database exists and I can connect to it<br>
<br>
[root@SDEVCCLM47 /]# mysql -popensipsrw -u opensips -D opensips<br>Reading table information for completion of table and column names<br>You can turn off this feature to get a quicker startup with -A<br>
Welcome to the MySQL monitor. Commands end with ; or \g.<br>Your MySQL connection id is 59<br>Server version: 5.1.52 Source distribution<br>
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.<br>This software comes with ABSOLUTELY NO WARRANTY. This is free software,<br>and you are welcome to modify and redistribute it under the GPL v2 license<br>
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.<br>
mysql> show tables;<br>+---------------------+<br>| Tables_in_opensips |<br>+---------------------+<br>| acc |<br>| active_watchers |<br>| address |<br>| aliases |<br>| carrierfailureroute |<br>
| carrierroute |<br>| cpl |<br>| dbaliases |<br>| dialog |<br>| dialplan |<br>| dispatcher |<br>| domain |<br>| domainpolicy |<br>....................<br>
<br>
<div>
<hr>
Date: Wed, 30 Oct 2013 17:11:57 -0400<div><div class="h5"><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'<br><br>
<div dir="ltr">Are you able to connect to the local Mysql DB using:
<div><span style="FONT-FAMILY:arial,sans-serif;FONT-SIZE:13px">modparam("usrloc", "db_url", "mysql://opensips:opensipsrw@</span><span style="FONT-FAMILY:arial,sans-serif;FONT-SIZE:13px">localhost/opensips")</span><br>
</div>
<div><span style="FONT-FAMILY:arial,sans-serif;FONT-SIZE:13px"><br></span></div>
<div><span style="FONT-FAMILY:arial,sans-serif;FONT-SIZE:13px">use: mysql -p</span><span style="FONT-FAMILY:arial,sans-serif;FONT-SIZE:13px">opensipsrw -u opensips -D opensips</span></div>
<div><span style="FONT-FAMILY:arial,sans-serif;FONT-SIZE:13px"><br></span></div>
<div><span style="FONT-FAMILY:arial,sans-serif;FONT-SIZE:13px">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:13px"><br></span></div>
<div><span style="FONT-FAMILY:arial,sans-serif;FONT-SIZE:13px">W</span></div></div>
<div><br><br>
<div>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 style="BORDER-LEFT:#ccc 1px 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><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" 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>