Problem with drouting module

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Problem with drouting module

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

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
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkkQcxsACgkQ4tZeNddg3dzHBwCgjrf2chtzrTJ1ZpoktiNp1BM6
/rQAn2Kig3zozEGiJ41z9DNWc2yx6laj
=WcWU
-----END PGP SIGNATURE-----

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: 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
[hidden email]
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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: 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
> [hidden email]
> 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
> [hidden email]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>  


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: 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
> [hidden email]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>>
_______________________________________________
Users mailing list
[hidden email]
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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: 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
>> [hidden email]
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>>    
> _______________________________________________
> Users mailing list
> [hidden email]
> 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
> [hidden email]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>  


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users