<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Assuming that you have other files in that dir
(/usr/local/opensips1.7.0//lib/opensips/opensipsctl/), I suppose
you did not include mysql module in the list of modules to be
compiled + installed -> the mysql support in opensipsctl was
not installed too.<br>
<br>
So do "make install include_modules=modules/mysql". <br>
<br>
Regards,<br>
</tt><tt><br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<br>
On 11/30/2012 06:19 AM, dpa wrote:
<blockquote cite="mid:004d01cdceb1$d8026020$88072060$@mail.ru"
type="cite">
<meta name="Microsoft Theme 2.00" content="strtedge 011">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta name="Generator" content="Microsoft Word 14 (filtered
medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
<style><!--
/* Font Definitions */
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Arial","sans-serif";
        color:black;
        mso-fareast-language:EN-US;}
h1
        {mso-style-priority:9;
        mso-style-link:"\0417\0430\0433\043E\043B\043E\0432\043E\043A 1 \0417\043D\0430\043A";
        margin-top:24.0pt;
        margin-right:0cm;
        margin-bottom:0cm;
        margin-left:0cm;
        margin-bottom:.0001pt;
        page-break-after:avoid;
        font-size:16.0pt;
        font-family:"Arial","sans-serif";
        color:black;
        mso-fareast-language:EN-US;}
h2
        {mso-style-priority:9;
        mso-style-link:"\0417\0430\0433\043E\043B\043E\0432\043E\043A 2 \0417\043D\0430\043A";
        margin-top:10.0pt;
        margin-right:0cm;
        margin-bottom:0cm;
        margin-left:0cm;
        margin-bottom:.0001pt;
        page-break-after:avoid;
        font-size:14.0pt;
        font-family:"Arial","sans-serif";
        color:black;
        mso-fareast-language:EN-US;
        font-weight:normal;}
h3
        {mso-style-priority:9;
        mso-style-link:"\0417\0430\0433\043E\043B\043E\0432\043E\043A 3 \0417\043D\0430\043A";
        margin-top:10.0pt;
        margin-right:0cm;
        margin-bottom:0cm;
        margin-left:0cm;
        margin-bottom:.0001pt;
        page-break-after:avoid;
        font-size:13.0pt;
        font-family:"Arial","sans-serif";
        color:black;
        mso-fareast-language:EN-US;
        font-weight:normal;}
h4
        {mso-style-priority:9;
        mso-style-link:"\0417\0430\0433\043E\043B\043E\0432\043E\043A 4 \0417\043D\0430\043A";
        margin-top:10.0pt;
        margin-right:0cm;
        margin-bottom:0cm;
        margin-left:0cm;
        margin-bottom:.0001pt;
        page-break-after:avoid;
        font-size:14.0pt;
        font-family:"Arial","sans-serif";
        color:black;
        mso-fareast-language:EN-US;
        font-weight:normal;}
h5
        {mso-style-priority:9;
        mso-style-link:"\0417\0430\0433\043E\043B\043E\0432\043E\043A 5 \0417\043D\0430\043A";
        margin-top:10.0pt;
        margin-right:0cm;
        margin-bottom:0cm;
        margin-left:0cm;
        margin-bottom:.0001pt;
        page-break-after:avoid;
        font-size:13.0pt;
        font-family:"Arial","sans-serif";
        color:black;
        mso-fareast-language:EN-US;
        font-weight:normal;}
h6
        {mso-style-priority:9;
        mso-style-link:"\0417\0430\0433\043E\043B\043E\0432\043E\043A 6 \0417\043D\0430\043A";
        margin-top:10.0pt;
        margin-right:0cm;
        margin-bottom:0cm;
        margin-left:0cm;
        margin-bottom:.0001pt;
        page-break-after:avoid;
        font-size:11.0pt;
        font-family:"Arial","sans-serif";
        color:black;
        mso-fareast-language:EN-US;
        font-weight:normal;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:#660000;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:#003399;
        text-decoration:underline;}
pre
        {mso-style-priority:99;
        mso-style-link:"\0421\0442\0430\043D\0434\0430\0440\0442\043D\044B\0439 HTML \0417\043D\0430\043A";
        margin:0cm;
        margin-bottom:.0001pt;
        font-size:10.0pt;
        font-family:"Courier New";
        color:black;}
span.HTML
        {mso-style-name:"\0421\0442\0430\043D\0434\0430\0440\0442\043D\044B\0439 HTML \0417\043D\0430\043A";
        mso-style-priority:99;
        mso-style-link:"\0421\0442\0430\043D\0434\0430\0440\0442\043D\044B\0439 HTML";
        font-family:"Courier New";
        mso-fareast-language:RU;}
span.1
        {mso-style-name:"\0417\0430\0433\043E\043B\043E\0432\043E\043A 1 \0417\043D\0430\043A";
        mso-style-priority:9;
        mso-style-link:"\0417\0430\0433\043E\043B\043E\0432\043E\043A 1";
        font-family:"Arial","sans-serif";
        color:black;
        font-weight:bold;}
span.2
        {mso-style-name:"\0417\0430\0433\043E\043B\043E\0432\043E\043A 2 \0417\043D\0430\043A";
        mso-style-priority:9;
        mso-style-link:"\0417\0430\0433\043E\043B\043E\0432\043E\043A 2";
        font-family:"Arial","sans-serif";
        color:black;}
span.3
        {mso-style-name:"\0417\0430\0433\043E\043B\043E\0432\043E\043A 3 \0417\043D\0430\043A";
        mso-style-priority:9;
        mso-style-link:"\0417\0430\0433\043E\043B\043E\0432\043E\043A 3";
        font-family:"Arial","sans-serif";
        color:black;}
span.4
        {mso-style-name:"\0417\0430\0433\043E\043B\043E\0432\043E\043A 4 \0417\043D\0430\043A";
        mso-style-priority:9;
        mso-style-link:"\0417\0430\0433\043E\043B\043E\0432\043E\043A 4";
        font-family:"Arial","sans-serif";
        color:black;}
span.5
        {mso-style-name:"\0417\0430\0433\043E\043B\043E\0432\043E\043A 5 \0417\043D\0430\043A";
        mso-style-priority:9;
        mso-style-link:"\0417\0430\0433\043E\043B\043E\0432\043E\043A 5";
        font-family:"Arial","sans-serif";
        color:black;}
span.6
        {mso-style-name:"\0417\0430\0433\043E\043B\043E\0432\043E\043A 6 \0417\043D\0430\043A";
        mso-style-priority:9;
        mso-style-link:"\0417\0430\0433\043E\043B\043E\0432\043E\043A 6";
        font-family:"Arial","sans-serif";
        color:black;}
span.EmailStyle25
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:windowtext;}
span.hps
        {mso-style-name:hps;}
span.EmailStyle27
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:2.0cm 42.5pt 2.0cm 3.0cm;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);" lang="EN-US">Hello, Bogdan<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);" lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);" lang="EN-US">No, there is no “</span><span
style="font-size: 11pt; font-family:
"Calibri","sans-serif";" lang="EN-US">opensipsdbctl.mysql</span><span
style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);" lang="EN-US">” file in “</span><span lang="EN-US">"</span><span
style="font-size: 11pt; font-family:
"Calibri","sans-serif";" lang="EN-US">/usr/local/opensips1.7.0//lib/opensips/opensipsctl/</span><span
style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);" lang="EN-US">” <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);" lang="EN-US">I should make it myself?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color: rgb(31,
73, 125);" lang="EN-US"><o:p> </o:p></span></p>
<div>
<div style="border-right: medium none; border-width: 1pt
medium medium; border-style: solid none none; border-color:
rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color;
padding: 3pt 0cm 0cm;">
<p class="MsoNormal"><b><span style="font-size: 10pt;
font-family:
"Tahoma","sans-serif"; color:
windowtext;">From:</span></b><span style="font-size:
10pt; font-family:
"Tahoma","sans-serif"; color:
windowtext;"> Bogdan-Andrei Iancu
[<a class="moz-txt-link-freetext" href="mailto:bogdan@opensips.org">mailto:bogdan@opensips.org</a>] <br>
<b>Sent:</b> Thursday, November 29, 2012 9:36 PM<br>
<b>To:</b> OpenSIPS users mailling list<br>
<b>Cc:</b> dpa<br>
<b>Subject:</b> Re: [OpenSIPS-Users] DB migration from
1.6.4 to 1.7.0<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi,<br>
<br>
and have you checked if the file "<span style="font-size:
11pt; font-family:
"Calibri","sans-serif";" lang="EN-US">/usr/local/opensips1.7.0//lib/opensips/opensipsctl/opensipsdbctl.mysql"</span>
really exists on your system ?<br>
<br>
Regards,<br>
<br>
<br>
<o:p></o:p></p>
<pre>Bogdan-Andrei Iancu<o:p></o:p></pre>
<pre>OpenSIPS Founder and Developer<o:p></o:p></pre>
<pre><a moz-do-not-send="true" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a><o:p></o:p></pre>
<p class="MsoNormal"><br>
On 11/28/2012 10:46 AM, dpa wrote: <o:p></o:p></p>
<p class="MsoNormal"><span style="font-family: "Times New
Roman","serif";"><img id="_x0000_i1025"
src="cid:part1.09020901.08010307@opensips.org" border="0"
height="38" width="39"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color:
windowtext;" lang="EN-US">Hello!</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color:
windowtext;" lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color:
windowtext;" lang="EN-US">I want to upgrade opensips from
1.6.4-2 to latest version (1.8).</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color:
windowtext;" lang="EN-US">As I understand first I should
migrate my DB from 1.6.4 to 1.7.0 and then migrate 1.7.0 to
1.8</span><o:p></o:p></p>
<pre><span style="font-size: 11pt; font-family: "Calibri","sans-serif";" lang="EN-US">I have installed opensips 1.7.0. Make “./</span><span lang="EN-US">opensipsdbctl migrate opensips5 opensips51</span><span style="font-size: 11pt; font-family: "Calibri","sans-serif";" lang="EN-US">” </span><o:p></o:p></pre>
<pre><span style="font-size: 11pt; font-family: "Calibri","sans-serif";" lang="EN-US">where opensips5 – </span><span class="hps"><span lang="EN">existing</span></span><span style="font-size: 11pt; font-family: "Calibri","sans-serif";" lang="EN"> </span><span style="font-size: 11pt; font-family: "Calibri","sans-serif";" lang="EN-US">DB.</span><o:p></o:p></pre>
<pre><span style="font-size: 11pt; font-family: "Calibri","sans-serif";" lang="EN-US">and receive such errors</span><o:p></o:p></pre>
<pre><span style="font-size: 11pt; font-family: "Calibri","sans-serif";" lang="EN-US"> </span><o:p></o:p></pre>
<pre><span style="font-size: 11pt; font-family: "Calibri","sans-serif";" lang="EN-US">“ERROR: could not load the script in /usr/local/opensips1.7.0//lib/opensips/opensipsctl/opensipsdbctl.mysql for database engine MYSQL</span><o:p></o:p></pre>
<pre><span style="font-size: 11pt; font-family: "Calibri","sans-serif";" lang="EN-US">ERROR: database engine not loaded - tried 'MYSQL'”</span><o:p></o:p></pre>
<pre><span style="font-size: 11pt; font-family: "Calibri","sans-serif";" lang="EN-US"> </span><o:p></o:p></pre>
<pre><span style="font-size: 11pt; font-family: "Calibri","sans-serif";" lang="EN-US">Thank you for any help.</span><o:p></o:p></pre>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Calibri","sans-serif"; color:
windowtext;" lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"> </span><o:p></o:p></p>
<pre><o:p> </o:p></pre>
<pre><o:p> </o:p></pre>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>Users mailing list<o:p></o:p></pre>
<pre><a moz-do-not-send="true" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><o:p></o:p></pre>
<pre><a moz-do-not-send="true" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><o:p></o:p></pre>
</div>
</blockquote>
</body>
</html>