[SR-Users] "kamdbctl create" scrip error "Invalid default value for 'action'"

[Вячеслав Панасов]

Hi all
I trying to install the test`s kamailio from repo in the new instance on
the CentOS 7 with MariaDB 5.5.6
and get this ERROR message

[user at testkamailio-002] # kamdbctl create
MySQL password for root:
INFO: test server charset
INFO: creating database kamailio ...
INFO: granting privileges to database kamailio ...
INFO: creating standard tables into kamailio ...
INFO: Core Kamailio tables succesfully created.
Install presence related tables? (y/n): y
INFO: creating presence tables into kamailio ...
INFO: Presence tables succesfully created.
Install tables for imc cpl siptrace domainpolicy carrierroute
                drouting userblacklist htable purple uac pipelimit mtree
sca mohqueue
                rtpproxy rtpengine secfilter? (y/n): y
INFO: creating extra tables into kamailio ...
ERROR 1067 (42000) at line 1: Invalid default value for 'action'
ERROR: Creating extra tables failed at secfilter!


after if i try reinit i get this error

[user at testkamailio-002] # kamdbctl reinit
MySQL password for root:
This will drop your current database and create a new one.
It is recommended to first backup your database.

Continue with reinit? (y/n): y
INFO: Database kamailio deleted
INFO: test server charset
INFO: creating database kamailio ...
INFO: granting privileges to database kamailio ...
ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'kamailio'@
'localhost'
ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'kamailioro'@
'localhost'
ERROR: granting privileges to database kamailio failed!

two weeks ago, the installation was successful, apparently there were some
changes in the script

cheers
Vjacheslav Panasov
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20200512/650176b2/attachment.html>