<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:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><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:"Century Gothic";
panose-1:2 11 5 2 2 2 2 2 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:"Traditional Arabic";
panose-1:2 1 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
color:black;}
span.HTMLVorformatiertZchn
{mso-style-name:"HTML Vorformatiert Zchn";
mso-style-priority:99;
mso-style-link:"HTML Vorformatiert";
font-family:Consolas;
color:black;}
p.HTMLVorformatiert, li.HTMLVorformatiert, div.HTMLVorformatiert
{mso-style-name:"HTML Vorformatiert";
mso-style-priority:99;
mso-style-link:"HTML Vorformatiert Zchn";
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
span.SprechblasentextZchn
{mso-style-name:"Sprechblasentext Zchn";
mso-style-priority:99;
mso-style-link:Sprechblasentext;
font-family:"Tahoma","sans-serif";
color:black;}
p.Sprechblasentext, li.Sprechblasentext, div.Sprechblasentext
{mso-style-name:Sprechblasentext;
mso-style-priority:99;
mso-style-link:"Sprechblasentext Zchn";
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
span.EmailStyle26
{mso-style-type:personal;
font-family:"Century Gothic","sans-serif";
color:#1F497D;}
span.EmailStyle27
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle28
{mso-style-type:personal;
font-family:"Century Gothic","sans-serif";
color:#1F497D;}
span.EmailStyle29
{mso-style-type:personal-reply;
font-family:"Century Gothic","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Hello,<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>What version of MySQL I should use?<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Amr<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><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'> sr-users-bounces@lists.sip-router.org [mailto:sr-users-bounces@lists.sip-router.org] <b>On Behalf Of </b>Amr Elsharqawi<br><b>Sent:</b> Tuesday, March 12, 2013 11:34 AM<br><b>To:</b> 'Henning Westerholt'; 'Kamailio (SER) - Users Mailing List'<br><b>Subject:</b> Re: [SR-Users] Kamailio MySQL DB Creation<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Hello Henning,<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>MySQL Version is <u>5.6.10<o:p></o:p></u></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Amr<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><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'> Henning Westerholt [<a href="mailto:henning.westerholt@1und1.de">mailto:henning.westerholt@1und1.de</a>] <br><b>Sent:</b> Tuesday, March 12, 2013 11:26 AM<br><b>To:</b> Kamailio (SER) - Users Mailing List<br><b>Cc:</b> <a href="mailto:aelsharqawi@live.com">aelsharqawi@live.com</a><br><b>Subject:</b> RE: [SR-Users] Kamailio MySQL DB Creation<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=DE style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hello Amr,<o:p></o:p></span></p><p class=MsoNormal><span lang=DE style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>somehow the datatype default value that is used in the msilo table is not understood by your mysql server. Can you specify the version of the mysql? Maybe they changed something which is not compatible with the old ones.<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><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Best regards,<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><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Henning<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 style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span lang=DE style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>From:</span></b><span lang=DE style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'> <a href="mailto:sr-users-bounces@lists.sip-router.org">sr-users-bounces@lists.sip-router.org</a> [<a href="mailto:sr-users-bounces@lists.sip-router.org">mailto:sr-users-bounces@lists.sip-router.org</a>] <b>On Behalf Of </b>Amr Elsharqawi<br><b>Sent:</b> Tuesday, March 12, 2013 9:14 AM<br><b>To:</b> <a href="mailto:miconda@gmail.com">miconda@gmail.com</a>; 'Kamailio (SER) - Users Mailing List'<br><b>Subject:</b> Re: [SR-Users] Kamailio MySQL DB Creation<o:p></o:p></span></p></div></div><p class=MsoNormal><span lang=DE><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Hello Daniel,<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Thanks for your quick reply. You’re right it’s shell but got this<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>MySQL password for root:<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>INFO: test server charset<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Warning: Using a password on the command line interface can be insecure.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Warning: Using a password on the command line interface can be insecure.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>INFO: creating database kamailio ...<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Warning: Using a password on the command line interface can be insecure.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>INFO: granting privileges to database kamailio ...<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Warning: Using a password on the command line interface can be insecure.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>INFO: creating standard tables into kamailio ...<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Warning: Using a password on the command line interface can be insecure.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Warning: Using a password on the command line interface can be insecure.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Warning: Using a password on the command line interface can be insecure.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Warning: Using a password on the command line interface can be insecure.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Warning: Using a password on the command line interface can be insecure.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Warning: Using a password on the command line interface can be insecure.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Warning: Using a password on the command line interface can be insecure.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Warning: Using a password on the command line interface can be insecure.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Warning: Using a password on the command line interface can be insecure.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D;background:yellow;mso-highlight:yellow'>ERROR 1101 (42000) at line 2: BLOB/TEXT column 'body' can't have a default value<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D;background:yellow;mso-highlight:yellow'>ERROR: Creating core tables failed at msilo!</span><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>I’ve followed wiki installation for Kamailio git 4.0<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>There is something I couldn’t do you said in the wiki <o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>If you changed the password for the 'kamailio' user of MySQL, you have to update the value for 'db_url' parameters.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>In Fact I couldn’t change it because I don’t know what to put if I’ve change the db password @ kamdbctl<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Thanks,<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'>Amr<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><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'> <a href="mailto:sr-users-bounces@lists.sip-router.org">sr-users-bounces@lists.sip-router.org</a> [<a href="mailto:sr-users-bounces@lists.sip-router.org">mailto:sr-users-bounces@lists.sip-router.org</a>] <b>On Behalf Of </b>Daniel-Constantin Mierla<br><b>Sent:</b> Tuesday, March 12, 2013 10:53 AM<br><b>To:</b> Kamailio (SER) - Users Mailing List<br><b>Subject:</b> Re: [SR-Users] Kamailio MySQL DB Creation<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'>Hello,<br><br>could be sh (shell) constrain issue. Can you execute the script with bash?<br><br>Cheers,<br>Daniel<o:p></o:p></p><div><p class=MsoNormal>On 3/12/13 7:53 AM, Amr Elsharqawi wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal>Hello Kamailio Community!!<br><br>I am newbie to Kamailio & SIP. And I am interested in Kamailio. I've used asterisk for some time then I heard about FreeSWITCH unfortunately FreeSWITCH was not good enough for me like Asterisk. I've found NAT problem with Asterisk Finally I've decided to work with Kamailio as SIP server & Asterisk as PBX. to be fair I need to learn more about FreeSWICH to test it well.<br><br> My Question is about Kamailio installation; I am using FreeBSD 9 attached my <b><u>uname -a</u></b><br><br>FreeBSD PBX.XXXXX 9.1-RELEASE FreeBSD 9.1-RELEASE #0 r243826: Tue Dec 4 06:55:39 UTC 2012 <a href="mailto:root@obrian.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC">root@obrian.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC</a> i386<br><br>I've used <b><u>gmake</u></b> for building, compiling and installation. Everything goes smooth EXCEPT mysql db installation when I use <b><u>sh /usr/local/sbin/kamdbctl create</u></b><br><br>I am getting the following error:<br><br><b><u>/usr/local/lib/kamailio//kamctl/kamdbctl.base: 36: Syntax error: Missing '}'</u></b><br><br>Thanks a lot for your valuable time and that amazing project (Kamailio).<br><br>Amr<o:p></o:p></p></div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><pre><span style='font-size:10.0pt;font-family:"Courier New"'>_______________________________________________<o:p></o:p></span></pre><pre><span style='font-size:10.0pt;font-family:"Courier New"'>SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<o:p></o:p></span></pre><pre><span style='font-size:10.0pt;font-family:"Courier New"'><a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><o:p></o:p></span></pre><pre><span style='font-size:10.0pt;font-family:"Courier New"'><a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><o:p></o:p></span></pre></blockquote><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><pre><span style='font-size:10.0pt;font-family:"Courier New"'>-- <o:p></o:p></span></pre><pre><span style='font-size:10.0pt;font-family:"Courier New"'>Daniel-Constantin Mierla - <a href="http://www.asipto.com">http://www.asipto.com</a><o:p></o:p></span></pre><pre><span style='font-size:10.0pt;font-family:"Courier New"'><a href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a><o:p></o:p></span></pre><pre><span style='font-size:10.0pt;font-family:"Courier New"'>Kamailio World Conference, April 16-17, 2013, Berlin<o:p></o:p></span></pre><pre><span style='font-size:10.0pt;font-family:"Courier New"'> - <a href="http://conference.kamailio.com">http://conference.kamailio.com</a> -<o:p></o:p></span></pre></div></div></body></html>