<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hello,</p>
<p>for the records, this should be fixed in the repos.</p>
<p>I noticed that newer versions of mysql server are more
restrictive in what can be the type of default values, in the past
numbers could be given in between quotes, no longer with some
recent versions. Maybe we will have to do a bit of a review in
this aspect. The issue on this case was a default value set to
empty string for a number column.</p>
<p>Cheers,<br>
Daniel<br>
</p>
<div class="moz-cite-prefix">On 07.05.20 22:16, Voip support wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAFCTnsKqw7f=r5LttGinT0YRir+yaoZd_TEo+R+xWmOwTyzjXw@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Hello Community,
<div><br>
I had created for my solution an installer using ansible.<br>
It worked great all the time but suddenly it started to crash
on step where i run the command : </div>
<div><br>
</div>
<div>kamdbctl create</div>
<div><br>
</div>
<div>root@nlb:/home/nlb# kamdbctl create<br>
-e \E[37;33mINFO: creating database kamailio ...<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
-e \E[37;33mINFO: granting privileges to database kamailio ...<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
-e \E[37;33mINFO: creating standard tables into kamailio ...<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
-e \E[37;33mINFO: Core Kamailio tables succesfully created.<br>
-e \E[37;33mINFO: creating presence tables into kamailio ...<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
-e \E[37;33mINFO: Presence tables succesfully created.<br>
-e \E[37;33mINFO: creating extra tables into kamailio ...<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
mysql: [Warning] Using a password on the command line
interface can be insecure.<br>
ERROR 1067 (42000) at line 1: Invalid default value for
'action'<br>
-e \E[37;31mERROR: Creating extra tables failed at secfilter!<br>
</div>
<div><br>
</div>
<div>Its saying some error about 'action' column default value.</div>
<div><br>
The installation is made using ubuntu 16.04 from repository: </div>
<div><br>
</div>
<div>deb <a href="http://deb.kamailio.org/kamailio53"
moz-do-not-send="true">http://deb.kamailio.org/kamailio53</a>
xenial main<br>
deb-src <a href="http://deb.kamailio.org/kamailio53"
moz-do-not-send="true">http://deb.kamailio.org/kamailio53</a>
xenial main<br>
</div>
<div><br>
</div>
<div>Maybe the issue is this change i dont know (it mention
default value 0 for action column): </div>
<div><a
href="https://github.com/kamailio/kamailio/commit/b0f1486f8a656922aac02020c9e3141639f2ecb9"
moz-do-not-send="true">https://github.com/kamailio/kamailio/commit/b0f1486f8a656922aac02020c9e3141639f2ecb9</a> </div>
<div><br>
</div>
<div>Best regards,<br>
Tom <br>
</div>
<div><br>
<br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Kamailio (SER) - Users Mailing List
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a>
<a class="moz-txt-link-freetext" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a>
<a class="moz-txt-link-abbreviated" href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a class="moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a>
Funding: <a class="moz-txt-link-freetext" href="https://www.paypal.me/dcmierla">https://www.paypal.me/dcmierla</a></pre>
</body>
</html>