[OpenSIPS-Users] Problem with drouting module

[Helmut Kuper]

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

Hi Bogdan,

I just looked into trunk and still found goupid field in table dr_groups
as varchar ...

http://opensips.svn.sourceforge.net/viewvc/opensips/trunk/scripts/mysql/drouting-create.sql

regards
Helmut

Bogdan-Andrei Iancu schrieb:
> 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:
> 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
> 
> 
>>
_______________________________________________
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

iEYEARECAAYFAkkRvbMACgkQ4tZeNddg3dwYTQCfQuGC2F7ZXF5VAmpiC9QlOMar
WtcAmgNiiw0npP4NwjuftgzWX0p1OUDX
=nTDf
-----END PGP SIGNATURE-----