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@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@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@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/devel http://lists.openser-project.org/cgi-bin/mailman/listinfo/devel