[Kamailio-Devel] Bugs on "kamctl" related to CR??? - Moving from Devel to User List

[Ovidiu Sas]

It seems that the kamctl tool was not updated to reflect the new cr db schema.
Please open a bug about this.
In the mean time, take a look at the docs and populate the tables
using mysql queries (kamctl is just a wrapper around mysql queries).

Regards,
Ovidiu Sas

On Tue, May 19, 2009 at 5:47 PM, Edson - Lists <4lists at gmail.com> wrote:
> Hi, Ovidiu
>
> I'm replicating this trade on User list, as You suggested, but take look on
> what I had done:
>
> Kamailio-151:/etc/kamailio # kamdbctl reinit kamailio
> MySQL password for root:
> INFO: Database kamailio deleted
> INFO: test server charset
> INFO: creating database kamailio ...
> INFO: Core Kamailio tables succesfully created.
> Install presence related tables? (y/n): y
> INFO: creating presence tables into kamailio ...
> INFO: Presence tables succesfully created.
> Install tables for imc cpl siptrace domainpolicy carrierroute userblacklist
> htable purple? (y/n): y
> INFO: creating extra tables into kamailio ...
> INFO: Extra tables succesfully created.
> Kamailio-151:/etc/kamailio # kamctl cr addrt 0 'XXXX'
> ERROR 1146 (42S02) at line 1: Table 'kamailio.route_tree' doesn't exist
> ERROR: cr - SQL Error
> Kamailio-151:/etc/kamailio #
>
> and the error/bug persist. Even with a clean DB definition...
>
> Where could the problem be? I understand that it's on the "kamctl" script,
> but I can be wrong...
>
> Edson.
>
> Ovidiu Sas escreveu:
>>
>> This is a question for users, not for devel.
>> Please install the extra tables via kamdbctl.
>> Take a look also at /etc/kamailio/kamctlrc where the extra tables are
>> defined.
>>
>>
>> Regards,
>> Ovidiu Sas
>>
>> On Tue, May 19, 2009 at 4:25 PM, Edson - Lists <4lists at gmail.com> wrote:
>>>
>>> Hi, Guys...
>>>
>>> After some tests, I realize that CarrierRoute will feet better on we
>>> want to do, but when trying to include a carrier, I got:
>>>
>>>   # kamctl cr addrt 1 XXXX
>>>   ERROR 1146 (42S02) at line 1: Table 'kamailio.route_tree' doesn't exist
>>>   ERROR: cr - SQL Error
>>>
>>> Then I try to include a route by hand with the commands:
>>>
>>>   INSERT INTO carrier_name (carrier) VALUES ("default");
>>>   INSERT INTO domain_name (domain) VALUES ("default");
>>>   INSERT INTO carrierroute
>>> (carrier,domain,scan_prefix,flags,mask,prob,strip,rewrite_host,rewrite_prefix,rewrite_suffix,description)
>>>
>>>  VALUES("1","1","1000","0","0","1","0","PEER-01","","","FRANCE");
>>>
>>> And try to see the results, but I got:
>>>
>>>   # kamctl cr show
>>>   cr routing tree
>>>   ERROR 1146 (42S02) at line 1: Table 'kamailio.route_tree' doesn't exist
>>>   cr routes
>>>
>>> Now is this resulting from bug(s) in the "kamctl" script or from wrong
>>> definitions on the "kamctlrc" file?
>>>
>>> Edson.
>>>
>>>
>>> _______________________________________________
>>> Kamailio (OpenSER) - Devel mailing list
>>> Devel at lists.kamailio.org
>>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/devel
>>> http://lists.openser-project.org/cgi-bin/mailman/listinfo/devel
>>>
>>
>