[SR-Users] [SOLVED] "kamdbctl create" failed

[Tim Makarios]

Hi,

I followed the instructions at
   https://www.kamailio.org/wiki/packages/debs
for getting kamailio50 on Ubuntu Trusty, and it successfully got me that 
version on Trisquel 7.

Then, after dropping the earlier Kamailio version's MySQL database, running
   sudo kamdbctl create
worked without a problem.

Now, time for me to see what Kamailio can do for me!

Thanks for your help,

Tim
<><

On 05/04/17 22:42, Daniel-Constantin Mierla wrote:
> 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
>>>
>