<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'>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 id=stopSpelling>
Date: Wed, 30 Oct 2013 17:11:57 -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>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 class=ecxgmail_extra><BR><BR>
<DIV class=ecxgmail_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 style="BORDER-LEFT: #ccc 1px solid; PADDING-LEFT: 1ex" class=ecxgmail_quote>
<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><BR>_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users</DIV> </div></body>
</html>