Re: [SR-Users] "kamdbctl create" failed

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 >