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

[Daniel-Constantin Mierla]

Hello,


On 10.04.17 07:16, Tim Makarios wrote:
> 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.

great, thanks for sharing how you solved, it may help others in the
future trying the Trisquel 7.

Cheers,
Daniel
>
> 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
>>>>
>>

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