[SR-Users] "kamdbctl create" failed

[Daniel-Constantin Mierla]

Given that packaging there is not controlled by the kamailio project,
building from sources can be an option -- I guess that guidelines from
next link are more or less the same:

  - http://kamailio.org/docs/tutorials/5.0.x/kamailio-install-guide-git/

Also, you can build the deb packages yourself, the specs are available
inside pkg/kamailio/deb/.

Cheers,
Daniel


On 04.04.17 01:38, Tim Makarios wrote:
> 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
>>

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