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

[Edson - Lists]

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