3 Apr
2017
3 Apr
'17
12:05 p.m.
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:
--
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
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:
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users 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