<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>