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@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@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
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@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@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@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-
Daniel-Constantin Mierla -
Вячеслав Панасов