[OpenSIPS-Devel] [ opensips-Bugs-3038968 ] Problem with drouting using the db_text driver

[SourceForge.net]

Bugs item #3038968, was opened at 2010-08-03 22:42
Message generated for change (Settings changed) made by bogdan_iancu
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=3038968&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: None
Status: Open
>Resolution: Accepted
>Priority: 2
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Bogdan-Andrei Iancu (bogdan_iancu)
Summary: Problem with drouting using the db_text driver

Initial Comment:
When trying to use drouting and db_text, I place the following into db_gateways:

gwid(int,auto) type(int) address(str) strip(int) pri_prefix(str,null) attrs(str,null) probe_mode(int) description(str)
1:0:sip\:4.2.2.1:0:::0:BVX

And get the following:

Aug  3 14:27:19 atlcwdobp01 /usr/local/opensips/sbin/opensips[31772]: DBG:core:db_allocate_rows: allocate 240 bytes for result rows and values at 0x784448
Aug  3 14:27:19 atlcwdobp01 /usr/local/opensips/sbin/opensips[31772]: DBG:drouting:dr_load_routing_info: 1 records found in dr_gateways
Aug  3 14:27:19 atlcwdobp01 /usr/local/opensips/sbin/opensips[31772]: ERROR:drouting:dr_load_routing_info: column address has a bad type

Full summary of output here: http://pastebin.com/aC8cg1b7

Comment from bogdan:
This from drouting module - it expects a DB_STRING (null terminate), not a DB_STR (with len) data type

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

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