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