<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> </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> </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 -> 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 "make install include_modules=modules/mysql". </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"'> </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 “opensipsdbctl.mysql” file in “</span><span lang=EN-US>"</span><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>/usr/local/opensips1.7.0//lib/opensips/opensipsctl/” </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"'> </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> <o:p></o:p></p><p class=MsoNormal>Hi,<br><br>and have you checked if the file "<span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>/usr/local/opensips1.7.0//lib/opensips/opensipsctl/opensipsdbctl.mysql"</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'> </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 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 “./</span><span lang=EN-US>opensipsdbctl migrate opensips5 opensips51</span><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>” </span><o:p></o:p></pre><pre><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>where opensips5 – </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"'> </span><o:p></o:p></pre><pre><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>“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'”</span><o:p></o:p></pre><pre><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </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'> </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 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>