[OpenSIPS-Users] Problem with drouting module

[Helmut Kuper]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

ok I solved it. There is an error in dr_groups table definition. groupid
field has to be integer instead of varchar.

Here my working table scheme:

CREATE TABLE `dr_groups` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(64) character set latin1 NOT NULL,
  `domain` varchar(128) character set latin1 NOT NULL default '',
  `groupid` int(11) unsigned NOT NULL,
  `description` varchar(128) character set latin1 NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


regards
Helmut




Helmut Kuper schrieb:
> Hello,
> 
> I try to use trunk's drouting module and I fount that there is a problem
> with using dr_routing() in opensips script. Console shows this:
> 
> 
> 
> Nov  4 16:52:25 [6434] INFO:drouting_new:dr_init: Dynamic-Routing -
> initializing
> Nov  4 16:52:25 [6434] INFO:core:probe_max_receive_buffer: using a UDP
> receive buffer of 255 kb
> Nov  4 16:52:25 [6436] INFO:mi_xmlrpc:xmlrpc_process: starting xmlrpc server
> 
> INVITE
> -------------------------- Tue Nov  4 16:52:28 2008
> ----------------------------
> Main    : Received message <INVITE>
> Nov  4 16:52:28 [6434] ERROR:drouting_new:get_group_id: null or
> non-integer group_id
> Nov  4 16:52:28 [6434] ERROR:drouting_new:do_routing: failed to get group id
> 
> 
> 
> And indeed the group_id field in database is defined as a varchar and
> not as an integer. Seems like a bug to me.
> 
> When I change the field to integer, drouting module can not initialize
> because it expects a varchar or string type.
> 
> 
> regards
> helmut

_______________________________________________
Users mailing list
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkkQdcMACgkQ4tZeNddg3dzUNwCggDAD10DrHQNXJz9m8pLRj8n6
QkkAoIUV4opPAuq9VurRJ4TRpudJ/Cm6
=GXY/
-----END PGP SIGNATURE-----