<div dir="ltr"><div class="gmail_quote"><br><div dir="ltr">When you try to create a database using the "opensipsctl" the following error:<div><br></div><div><div><b>MySQL password for root:</b></div><div><b>INFO: creating presence tables into opensips ...</b></div><div><b>mysql: [Warning] Using a password on the command line interface can be insecure.</b></div><div><b>ERROR 1101 (42000) at line 2: BLOB/TEXT column 'extra_hdrs' can't have a default value</b></div><div><b>ERROR: Failed to create presence tables!</b></div><div><br></div><div>This problem occurs when you use MySQL5.6 and MySQL5.7<br></div><div><br></div><div><div>How to create a base of presence?</div><div>Of course, this problem is solved by correcting <b>/usr/share/opensips/mysql/presence-create.sql</b>, but would like to have corrected this error developers</div></div><span class="HOEnZb"><font color="#888888"><div><br></div><div><br></div><div><br></div>-- <br><div>С уважением Лукьяненко Роман<br></div>
</font></span></div></div>
</div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature">С уважением Лукьяненко Роман<br></div>
</div>