[OpenSIPS-Users] Problem with drouting module

[Bogdan-Andrei Iancu]

Hi Helmut,

Indeed there was this error which was reported and fixed couple of weeks 
ago. If you update from SVN, you will get the proper table definition 
and description.

Regards,
Bogdan

Helmut Kuper wrote:
> -----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-----
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>