20 May
2009
20 May
'09
2:31 a.m.
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(a)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(a)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(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/devel
http://lists.openser-project.org/cgi-bin/mailman/listinfo/devel