[SR-Users] kamdbctl create - failing create kamailio database on secfilter table action column default value

[Voip support]

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 at 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/b0f1486f8a656922aac02020c9e3141639f2ecb9


Best regards,
Tom
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20200507/2d35076a/attachment.html>