Hello,
apparently mysql doesn't like a default value for blob columns, might be
because of a new version.
You have to edit msilo-create.sql and remove DEFAULT part of the
statement for body column.
On the other hand, I recommend using kamailio 4.1.x, 4.0.1 is quite old.
Cheers,
Daniel
On 06/10/14 13:02, ANTHONY HESNAUX wrote:
Hello all,
I want to install kamailio on CENTOS 7 x64
but I have this problem when I execute "kamdbctl create »
Can you help me ??
Thank YOU
Anthony
Console display:
[root@localhost kamailio-4.0.1]# /usr/local/sbin/kamdbctl create
MySQL password for root:
*INFO: test server charset*
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
*INFO: creating database kamailio ...*
Warning: Using a password on the command line interface can be insecure.
*INFO: granting privileges to database kamailio ...*
Warning: Using a password on the command line interface can be insecure.
*INFO: creating standard tables into kamailio ...*
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
ERROR 1101 (42000) at line 2: BLOB/TEXT column 'body' can't have a
default value
*ERROR: Creating core tables failed at msilo!*
[root@localhost kamailio-4.0.1]#
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
http://twitter.com/#!/miconda -
http://www.linkedin.com/in/miconda