Thanks for those hints. At the moment, I'm just experimenting with
different software like this in my spare time, so it might be a while
before I try it. Or I might try installing a newer version of Kamailio
instead. Or I might wait until Trisquel 8 is released. But if I get
impatient, I might try what you suggested.
Thanks again,
Tim
<><
On 03/04/17 21:56, Daniel-Constantin Mierla wrote:
One solution to fix it is to edit the sql files
located in:
/usr/share/kamailio/mysql/
Search for the BLOB/TEXT columns and just remove their default value.
Not remembering by heart if in 4.0 is present, but at some point
kamdbctl got the option to add only tables per module.
Like:
kamdbctl add-tables dispatcher
which adds the tables used by dispatcher. First you have to add the
'standard' tables, then choose only the tables for the modules you know
you are going to use. Before that, you may need to create the database
and grant access with the 'dbonly' and 'grant' commands for kamdbctl.
This may work as alternative when you don't use the modules with the
columns that have more restrictions with newer versions of mysql.
Cheers,
Daniel