<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta name="Microsoft Theme 2.00" content="strtedge 011"><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><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;}
@font-face
        {font-family:"Times New Roman \, serif \;";
        panose-1:0 0 0 0 0 0 0 0 0 0;}
/* 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;}
tt
        {mso-style-priority:99;
        font-family:"Courier New";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
        {mso-style-priority:99;
        mso-style-link:"\0422\0435\043A\0441\0442 \0432\044B\043D\043E\0441\043A\0438 \0417\043D\0430\043A";
        margin:0cm;
        margin-bottom:.0001pt;
        font-size:8.0pt;
        font-family:"Tahoma","sans-serif";
        color:black;
        mso-fareast-language:EN-US;}
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.EmailStyle26
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:windowtext;}
span.hps
        {mso-style-name:hps;}
span.EmailStyle28
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
span.EmailStyle29
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
span.a
        {mso-style-name:"\0422\0435\043A\0441\0442 \0432\044B\043D\043E\0441\043A\0438 \0417\043D\0430\043A";
        mso-style-priority:99;
        mso-style-link:"\0422\0435\043A\0441\0442 \0432\044B\043D\043E\0441\043A\0438";
        font-family:"Tahoma","sans-serif";
        color:black;
        mso-fareast-language:EN-US;}
.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]--></head><body bgcolor=white lang=RU link="#660000" vlink="#003399"><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Yes, problem was there. Thank you very much.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p>&nbsp;</o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext;mso-fareast-language:RU'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext;mso-fareast-language:RU'> Bogdan-Andrei Iancu [mailto:bogdan@opensips.org] <br><b>Sent:</b> Friday, November 30, 2012 1:05 PM<br><b>To:</b> dpa<br><b>Cc:</b> 'OpenSIPS users mailling list'<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>&nbsp;</o:p></p><p class=MsoNormal><tt><span style='font-size:10.0pt'>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 -&gt; the mysql support in opensipsctl was not installed too.</span></tt><span style='font-size:10.0pt;font-family:"Courier New"'><br><br><tt>So do &quot;make install include_modules=modules/mysql&quot;. </tt><br><br><tt>Regards,</tt><br><br><br></span><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 href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a><o:p></o:p></pre><p class=MsoNormal><br>On 11/30/2012 06:19 AM, dpa wrote: <o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Hello, Bogdan</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>&nbsp;</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>No, there is no &#8220;opensipsdbctl.mysql&#8221; file in &#8220;</span><span lang=EN-US>&quot;</span><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>/usr/local/opensips1.7.0//lib/opensips/opensipsctl/&#8221; </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>I should make it myself?</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>&nbsp;</span><o:p></o:p></p><div><div style='border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0cm 0cm 0cm;border-color:-moz-use-text-color -moz-use-text-color'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'> Bogdan-Andrei Iancu [<a 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</span><o:p></o:p></p></div></div><p class=MsoNormal>&nbsp;<o:p></o:p></p><p class=MsoNormal>Hi,<br><br>and have you checked if the file &quot;<span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>/usr/local/opensips1.7.0//lib/opensips/opensipsctl/opensipsdbctl.mysql&quot;</span> really exists on your system ?<br><br>Regards,<br><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 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 ;","serif"'><img border=0 width=39 height=38 id="_x0000_i1025" src="cid:image001.gif@01CDCF23.BFC8DF30"></span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>Hello!</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>&nbsp;</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>I want to upgrade opensips &nbsp;from 1.6.4-2 to latest version (1.8).</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>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 lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>I have installed opensips 1.7.0. Make &#8220;./</span><span lang=EN-US>opensipsdbctl migrate opensips5 opensips51</span><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>&#8221; </span><o:p></o:p></pre><pre><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>where opensips5 &#8211; </span><span class=hps><span lang=EN>existing</span></span><span lang=EN style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>DB.</span><o:p></o:p></pre><pre><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>and receive such errors</span><o:p></o:p></pre><pre><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>&nbsp;</span><o:p></o:p></pre><pre><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>&#8220;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 lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>ERROR: database engine not loaded - tried 'MYSQL'&#8221;</span><o:p></o:p></pre><pre><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>&nbsp;</span><o:p></o:p></pre><pre><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Thank you for any help.</span><o:p></o:p></pre><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:windowtext'>&nbsp;</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>&nbsp;</span><o:p></o:p></p><pre>&nbsp;<o:p></o:p></pre><pre>&nbsp;<o:p></o:p></pre><pre>_______________________________________________<o:p></o:p></pre><pre>Users mailing list<o:p></o:p></pre><pre><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><o:p></o:p></pre><pre><a 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></body></html>