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

SourceForge.net noreply at sourceforge.net
Thu Jan 22 13:44:45 CET 2009


Bugs item #2528428, was opened at 2009-01-22 14:18
Message generated for change (Settings changed) made by bogdan_iancu
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: modules
>Group: trunk
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Lucian Marginean (voicemailtel)
>Assigned to: Bogdan-Andrei Iancu (bogdan_iancu)
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



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

Comment By: Lucian Marginean (voicemailtel)
Date: 2009-01-22 14:31

Message:
there are any changes on table structure not mentioned on drouting module
help page? I see some notes about drouting loading data on first child not
on starting opensips, maybe is related to this.

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

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



More information about the Devel mailing list