<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<tt>Hi Tito,<br>
<br>
A quick read on the topic shows that the "sql_mode" (SHOW
VARIABLES LIKE 'sql_mode';) has been changed from the default of
"", to include this option: STRICT_TRANS_TABLES.<br>
If STRICT_TRANS_TABLES is enabled, BLOB/TEXT cols can't have
default values :(<br>
<br>
So either change the "sql_mode" or edit
"/usr/local/share/opensips/mysql/presence-create.sql"<br>
<br>
Best regards,<br>
</tt>
<pre class="moz-signature" cols="72">Liviu Chircu
OpenSIPS Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 22.04.2015 17:14, Tito Cumpen wrote:<br>
</div>
<blockquote
cite="mid:CANZPVB7Ay70ow83VZN+HFr1z6U1v+zGNSywZrZ00hvO35Geq=Q@mail.gmail.com"
type="cite">
<div dir="ltr">Hello group,
<div><br>
</div>
<div>I am having issues creating the presence tables via
opensipsdbctl create using the trunk version of opensips. Here
is the error :</div>
<div><br>
</div>
<div>
<p class=""><span class="">opensipsdbctl create</span></p>
<p class=""><span class="">MySQL password for root: </span></p>
<p class=""><span class="">INFO: test server charset</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">INFO: creating database opensips
...</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">INFO: Core OpenSIPS tables
succesfully created.</span></p>
<p class=""><span class="">INFO: creating presence tables into
opensips ...</span></p>
<p class=""><span class="">Warning: Using a password on the
command line interface can be insecure.</span></p>
<p class=""><span class="">ERROR 1101 (42000) at line 2:
BLOB/TEXT column 'extra_hdrs' can't have a default value</span></p>
<p class=""><span class="">ERROR: Failed to create presence
tables!</span></p>
<p class=""><span class=""> I am using </span>mysql Ver
14.14 Distrib 5.6.24, for Linux (x86_64) using EditLine
wrapper</p>
</div>
<div>
<p class=""><span class=""><br>
</span></p>
<p class=""><span class=""><br>
</span></p>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>