Re: [Kamailio-Users] [Kamailio-Devel] Bugs on "kamctl" related to CR??? - Moving from Devel to User List
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
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
On Dienstag, 19. Mai 2009, Edson - Lists wrote:
I'm replicating this trade on User list, as You suggested, but take look on what I had done:
Hi Edson,
thanks for the report. I've did a fix to the kamctl code in the 1.5 branch, according my tests it works now. Would be great if you could also test.
Cheers,
Henning
Hi, Henning...
Just upgraded to SVN 5845 and tested.... works as expected....
Danke, Edson.
Henning Westerholt escreveu:
On Dienstag, 19. Mai 2009, Edson - Lists wrote:
I'm replicating this trade on User list, as You suggested, but take look on what I had done:
Hi Edson,
thanks for the report. I've did a fix to the kamctl code in the 1.5 branch, according my tests it works now. Would be great if you could also test.
Cheers,
Henning
-
Edson - Lists -
Henning Westerholt -
Ovidiu Sas