[OpenSIPS-Devel] [ opensips-Bugs-2528428 ] drouting not loading

[SourceForge.net]

Bugs item #2528428, was opened at 2009-01-22 07:18
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2528428&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Lucian Marginean (voicemailtel)
Assigned to: Nobody/Anonymous (nobody)
Summary: drouting not loading

Initial Comment:
Seems to not be able to load data from dr_rules

trunk used is 1.5 5185

Jan 22 16:13:08 osips-test opensips: WARNING:drouting:dr_load_routing_info: table "dr_rules" is empty
Jan 22 16:13:08 osips-test opensips: WARNING:drouting:dr_load_routing_info: no valid routing rules -> discarding all destinations
Jan 22 16:13:08 osips-test opensips: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now
Jan 22 16:13:08 osips-test opensips: ERROR:core:db_do_query: error while submitting query
Jan 22 16:13:08 osips-test opensips: ERROR:core:db_table_version: error in db_query
Jan 22 16:13:08 osips-test opensips: ERROR:core:db_check_table_version: querying version for table trusted
Jan 22 16:13:08 osips-test opensips: ERROR:permissions:init_child_trusted: error during table version check.
Jan 22 16:13:08 osips-test opensips: ERROR:core:init_mod_child: failed to initializing module permissions, rank 1
Jan 22 16:13:08 osips-test opensips: ERROR:core:main_loop: init_child failed in don't fork


This is the dr_rules content:

mysql> select * from dr_rules;
+--------+---------+--------+---------+----------+---------+--------+------------------------+
| ruleid | groupid | prefix | timerec | priority | routeid | gwlist | description            |
+--------+---------+--------+---------+----------+---------+--------+------------------------+
|      1 | 101     | 1416   |         |        1 |       0 | 1,2    | incoming               |
|      2 | 10      | 1416   |         |        1 |       0 | 1,2    | outgoing canada        |
|      3 | 20      | 011407 |         |        1 |       0 | 10,11  | outgoung international |
+--------+---------+--------+---------+----------+---------+--------+------------------------+
3 rows in set (0.00 sec)

I run the query using exactly the user/password set in .cfg to make sure there is not permission problem



----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2528428&group_id=232389