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

19 May 2009

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 &lt;4lists(a)gmail.com&gt; 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(a)lists.kamailio.org
 http://lists.kamailio.org/cgi-bin/mailman/listinfo/devel
 http://lists.openser-project.org/cgi-bin/mailman/listinfo/devel

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