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

[SourceForge.net]

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: Closed
>Resolution: Fixed
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: Bogdan-Andrei Iancu (bogdan_iancu)
Date: 2009-01-22 15:41

Message:
Yes, you are right - there was a bug in handling the case when the
dr_gw_list() table is empty - it is fixed now.

Thanks and regards,
Bogdan

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

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

Message:
It seems that dr_gw_list is mandatory to be completed, I don't know if is
necessary to be valid data, but at least 1 row solve the problem and
records are returned from dr_rules..

Please if you can post some example on help and the note that dr_gw_list
is mandatory to have at least 1 row.

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

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