[SR-Users] "kamdbctl create" failed

[Tim Makarios]

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
>