<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
apparently mysql doesn't like a default value for blob columns,
might be because of a new version.<br>
<br>
You have to edit msilo-create.sql and remove DEFAULT part of the
statement for body column.<br>
<br>
On the other hand, I recommend using kamailio 4.1.x, 4.0.1 is quite
old.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 06/10/14 13:02, ANTHONY HESNAUX
wrote:<br>
</div>
<blockquote
cite="mid:963657AE-BAF7-4617-9221-2203CAE116AF@gmail.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">Hello
all,</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">I
want to install kamailio on CENTOS 7 x64</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">but
I have this problem when I execute "kamdbctl create »</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;"><br>
</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">Can
you help me ??</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">Thank
YOU</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;"><br>
</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">Anthony </div>
<div><br>
</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">Console
display:</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;"><br>
</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">[root@localhost
kamailio-4.0.1]# /usr/local/sbin/kamdbctl create</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">MySQL
password for root: </div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;
color: rgb(175, 173, 36);"><b>INFO: test server charset</b></div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">Warning:
Using a password on the command line interface can be insecure.</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">Warning:
Using a password on the command line interface can be insecure.</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;
color: rgb(175, 173, 36);"><b>INFO: creating database kamailio
...</b></div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">Warning:
Using a password on the command line interface can be insecure.</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;
color: rgb(175, 173, 36);"><b>INFO: granting privileges to
database kamailio ...</b></div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">Warning:
Using a password on the command line interface can be insecure.</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;
color: rgb(175, 173, 36);"><b>INFO: creating standard tables
into kamailio ...</b></div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">Warning:
Using a password on the command line interface can be insecure.</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">Warning:
Using a password on the command line interface can be insecure.</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">Warning:
Using a password on the command line interface can be insecure.</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">Warning:
Using a password on the command line interface can be insecure.</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">Warning:
Using a password on the command line interface can be insecure.</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">Warning:
Using a password on the command line interface can be insecure.</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">Warning:
Using a password on the command line interface can be insecure.</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">Warning:
Using a password on the command line interface can be insecure.</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">Warning:
Using a password on the command line interface can be insecure.</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">ERROR
1101 (42000) at line 2: BLOB/TEXT column 'body' can't have a
default value</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;
color: rgb(195, 55, 32);"><b>ERROR: Creating core tables failed
at msilo!</b></div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;">[root@localhost
kamailio-4.0.1]# </div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;"><br>
</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;"><br>
</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;"><br>
</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;"><br>
</div>
<div style="margin: 0px; font-size: 11px; font-family: Menlo;"><br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a></pre>
</body>
</html>