Hello,
for the records, this should be fixed in the repos.
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.
Cheers,
Daniel
On 07.05.20 22:16, Voip support wrote:
Hello Community,
I had created for my solution an installer using ansible.
It worked great all the time but suddenly it started to crash on step
where i run the command :
kamdbctl create
root@nlb:/home/nlb# kamdbctl create
-e \E[37;33mINFO: creating database kamailio ...
mysql: [Warning] Using a password on the command line interface can be
insecure.
-e \E[37;33mINFO: granting privileges to database kamailio ...
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
-e \E[37;33mINFO: creating standard tables into kamailio ...
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
-e \E[37;33mINFO: Core Kamailio tables succesfully created.
-e \E[37;33mINFO: creating presence tables into kamailio ...
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
-e \E[37;33mINFO: Presence tables succesfully created.
-e \E[37;33mINFO: creating extra tables into kamailio ...
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
mysql: [Warning] Using a password on the command line interface can be
insecure.
ERROR 1067 (42000) at line 1: Invalid default value for 'action'
-e \E[37;31mERROR: Creating extra tables failed at secfilter!
Its saying some error about 'action' column default value.
The installation is made using ubuntu 16.04 from repository:
deb
http://deb.kamailio.org/kamailio53 xenial main
deb-src
http://deb.kamailio.org/kamailio53 xenial main
Maybe the issue is this change i dont know (it mention default value 0
for action column):
https://github.com/kamailio/kamailio/commit/b0f1486f8a656922aac02020c9e3141…
Best regards,
Tom
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla --
www.asipto.com
www.twitter.com/miconda --
www.linkedin.com/in/miconda
Funding:
https://www.paypal.me/dcmierla