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