[OpenSIPS-Users] Problem with drouting module

[Bogdan-Andrei Iancu]

Hi Helmut,

That is totally correct. Please see the description of the column :

    
http://www.opensips.org/html/docs/db/db-schema-devel.html#GEN-DB-DR-RULES

Regards,
Bogdan

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