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/b0f1486f8a656922aac02020c9e3141639f2ecb9 > > > Best regards, > Tom > > > > _______________________________________________ > Kamailio (SER) - Users Mailing List > [email protected] > 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
_______________________________________________ Kamailio (SER) - Users Mailing List [email protected] https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
