[SR-Users] "kamdbctl create" failed

[Daniel-Constantin Mierla]

Hello,

you run a newer version of mysql that enabled more constraints than they
used to be at the time 4.0 was developed (4-5 years ago).

Any reason to install 4.0.x? These should have been fixed in 4.4 or 5.0.
It is practically about removing default values for BLOB/TEXT columns.
Also, I encountered issues with latest mysql versions and the datetime
defaulting to '0000-00-00 ...', which used to work in older versions.

Cheers,
Daniel


On 03.04.17 03:26, Tim Makarios wrote:
> Sorry; I forgot to specify the version of Kamailio I'm using: 4.0.4.
> <><
>
> On 03/04/17 13:15, Tim Makarios wrote:
>> Hi,
>>
>> Following
>> http://kamailio.org/docs/tutorials/devel/kamailio-install-guide-deb/
>> I got to the step where I had to run
>>      kamdbctl create
>> Unfortunately, this failed, with the following output:
>>> INFO: test server charset
>>> INFO: creating database kamailio ...
>>> INFO: granting privileges to database kamailio ...
>>> INFO: creating standard tables into kamailio ...
>>> ERROR 1101 (42000) at line 2: BLOB/TEXT column 'body' can't have a
>>> default value
>>> ERROR: Creating core tables failed at msilo!
>>
>> Searching for this error turned up http://tinyurl.com/lovr4aq , but the
>> link in the answer is broken, and it doesn't appear that
>> STRICT_TRANS_TABLES is relevant to my version of MySQL [1], which is
>> 5.5.54 (running on Trisquel 7, which is based on Ubuntu Trusty).
>>
>> Has anyone else encountered and overcome this problem, or does anyone
>> have any ideas about how I might proceed?
>>
>> Tim
>> <><
>>
>> [1] http://tinyurl.com/zmnc75c
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training - May 22-24 (USA) - www.asipto.com
Kamailio World Conference - May 8-10, 2017 - www.kamailioworld.com