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@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