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

[Daniel-Constantin Mierla]

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 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 
>
>
>
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20200511/d4789ba7/attachment.html>