[SR-Users] Problem when I want install kamailio on CENTOS 7 x64

[ANTHONY HESNAUX]

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:

[***@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!
[***@localhost kamailio-4.0.1]#

[Daniel-Constantin Mierla]

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

Post by ANTHONY HESNAUX
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
*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!*
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users