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

[Daniel-Constantin Mierla]

Hello,

can you give the output of 'kamailio -v'?

Also, try to fetch latest version from git, there was a fix related to it.

Cheers,
Daniel

On 12.05.20 09:54, Вячеслав Панасов wrote:
>
> 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
>
> _______________________________________________
> 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/20200513/5a40d589/attachment.html>