DBTEXT not properly working with opensips 2.3

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

DBTEXT not properly working with opensips 2.3

aqsyounas
Greetings of the day, 

I am having the following issues by using DBTEXT with opensips 2.3.2 (x86_64/linux).
  
1. If I add anything(new domain) through openipsctl it does not reflect in DBTEXT. 
2. If I manually insert entries in DBTEXT, reload command does not work. I had to restart opensips to make changes effective. 
3. I see this error on opensips restart no matter whatever value I set in 'state' column of the dispatcher. 

Dec  7 20:00:41 sbc2 /usr/local/opensips/sbin/opensips[2441]: CRITICAL:dispatcher:add_dest2list: BUG: unknown state -1953657376 for destination sip:172.31.0.107:5080

dispatcher table. 

id(int,auto) setid(int) destination(string) socket(string) state(string)  weight(int) priority(string) attrs(string) description(string)
1:21:sip\:172.31.0.107\:5080:udp\:172.31.0.188\:5060:0:50:1:backend=pbx.test.co-pbx.test.co:first


Any help would be much appreciated. 

Best Regards, 

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

Re: DBTEXT not properly working with opensips 2.3

Bogdan-Andrei Iancu-2
Hi,

What db_mode do you have in the dbtext module ?

Regards,
Bogdan-Andrei Iancu
  OpenSIPS Founder and Developer
  http://www.opensips-solutions.com
On 12/07/2017 10:09 PM, Aqs Younas wrote:
Greetings of the day, 

I am having the following issues by using DBTEXT with opensips 2.3.2 (x86_64/linux).
  
1. If I add anything(new domain) through openipsctl it does not reflect in DBTEXT. 
2. If I manually insert entries in DBTEXT, reload command does not work. I had to restart opensips to make changes effective. 
3. I see this error on opensips restart no matter whatever value I set in 'state' column of the dispatcher. 

Dec  7 20:00:41 sbc2 /usr/local/opensips/sbin/opensips[2441]: CRITICAL:dispatcher:add_dest2list: BUG: unknown state -1953657376 for destination sip:172.31.0.107:5080

dispatcher table. 

id(int,auto) setid(int) destination(string) socket(string) state(string)  weight(int) priority(string) attrs(string) description(string)
1:21:sip\:172.31.0.107\:5080:udp\:172.31.0.188\:5060:0:50:1:backend=pbx.test.co-pbx.test.co:first


Any help would be much appreciated. 

Best Regards, 


_______________________________________________
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: DBTEXT not properly working with opensips 2.3

aqsyounas
Never thought there would be such parameter, this leaves me with the 3rd error.  Upon dispatcher reload I see this CRITICAL log. 

Dec  7 20:00:41 sbc2 /usr/local/opensips/sbin/opensips[2441]: CRITICAL:dispatcher:add_dest2list: BUG: unknown state -1953657376 for destination sip:172.31.0.107:5080

dispatcher table. 

id(int,auto) setid(int) destination(string) socket(string) state(string)  weight(int) priority(string) attrs(string) description(string)
1:21:sip\:172.31.0.107\:5080:udp\:172.31.0.188\:5060:0:50:1:backend=pbx.test.co-pbx.test.co:first

On 8 December 2017 at 14:23, Bogdan-Andrei Iancu <[hidden email]> wrote:
Hi,

What db_mode do you have in the dbtext module ?

Regards,
Bogdan-Andrei Iancu
  OpenSIPS Founder and Developer
  http://www.opensips-solutions.com
On 12/07/2017 10:09 PM, Aqs Younas wrote:
Greetings of the day, 

I am having the following issues by using DBTEXT with opensips 2.3.2 (x86_64/linux).
  
1. If I add anything(new domain) through openipsctl it does not reflect in DBTEXT. 
2. If I manually insert entries in DBTEXT, reload command does not work. I had to restart opensips to make changes effective. 
3. I see this error on opensips restart no matter whatever value I set in 'state' column of the dispatcher. 

Dec  7 20:00:41 sbc2 /usr/local/opensips/sbin/opensips[2441]: CRITICAL:dispatcher:add_dest2list: BUG: unknown state -1953657376 for destination sip:172.31.0.107:5080

dispatcher table. 

id(int,auto) setid(int) destination(string) socket(string) state(string)  weight(int) priority(string) attrs(string) description(string)
1:21:sip\:172.31.0.107\:5080:udp\:172.31.0.188\:5060:0:50:1:backend=pbx.test.co-pbx.test.co:first


Any help would be much appreciated. 

Best Regards, 


_______________________________________________
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: DBTEXT not properly working with opensips 2.3

Bogdan-Andrei Iancu-2
The "state" column is of integer type, see:
    https://github.com/OpenSIPS/opensips/blob/2.3/scripts/dbtext/opensips/dispatcher

Why do you have it as "string" in your file ???

Regard,
Bogdan-Andrei Iancu
  OpenSIPS Founder and Developer
  http://www.opensips-solutions.com
On 12/08/2017 11:55 AM, Aqs Younas wrote:
Never thought there would be such parameter, this leaves me with the 3rd error.  Upon dispatcher reload I see this CRITICAL log. 

Dec  7 20:00:41 sbc2 /usr/local/opensips/sbin/opensips[2441]: CRITICAL:dispatcher:add_dest2list: BUG: unknown state -1953657376 for destination sip:172.31.0.107:5080

dispatcher table. 

id(int,auto) setid(int) destination(string) socket(string) state(string)  weight(int) priority(string) attrs(string) description(string)
1:21:sip\:172.31.0.107\:5080:udp\:172.31.0.188\:5060:0:50:1:backend=pbx.test.co-pbx.test.co:first

On 8 December 2017 at 14:23, Bogdan-Andrei Iancu <[hidden email]> wrote:
Hi,

What db_mode do you have in the dbtext module ?

Regards,
Bogdan-Andrei Iancu
  OpenSIPS Founder and Developer
  http://www.opensips-solutions.com
On 12/07/2017 10:09 PM, Aqs Younas wrote:
Greetings of the day, 

I am having the following issues by using DBTEXT with opensips 2.3.2 (x86_64/linux).
  
1. If I add anything(new domain) through openipsctl it does not reflect in DBTEXT. 
2. If I manually insert entries in DBTEXT, reload command does not work. I had to restart opensips to make changes effective. 
3. I see this error on opensips restart no matter whatever value I set in 'state' column of the dispatcher. 

Dec  7 20:00:41 sbc2 /usr/local/opensips/sbin/opensips[2441]: CRITICAL:dispatcher:add_dest2list: BUG: unknown state -1953657376 for destination sip:172.31.0.107:5080

dispatcher table. 

id(int,auto) setid(int) destination(string) socket(string) state(string)  weight(int) priority(string) attrs(string) description(string)
1:21:sip\:172.31.0.107\:5080:udp\:172.31.0.188\:5060:0:50:1:backend=pbx.test.co-pbx.test.co:first


Any help would be much appreciated. 

Best Regards, 


_______________________________________________
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: DBTEXT not properly working with opensips 2.3

aqsyounas
Apologies, Sorry for the fuss. Working perfectly. 

Thanks. 

On 8 December 2017 at 15:36, Bogdan-Andrei Iancu <[hidden email]> wrote:
The "state" column is of integer type, see:
    https://github.com/OpenSIPS/opensips/blob/2.3/scripts/dbtext/opensips/dispatcher

Why do you have it as "string" in your file ???

Regard,
Bogdan-Andrei Iancu
  OpenSIPS Founder and Developer
  http://www.opensips-solutions.com
On 12/08/2017 11:55 AM, Aqs Younas wrote:
Never thought there would be such parameter, this leaves me with the 3rd error.  Upon dispatcher reload I see this CRITICAL log. 

Dec  7 20:00:41 sbc2 /usr/local/opensips/sbin/opensips[2441]: CRITICAL:dispatcher:add_dest2list: BUG: unknown state -1953657376 for destination sip:172.31.0.107:5080

dispatcher table. 

id(int,auto) setid(int) destination(string) socket(string) state(string)  weight(int) priority(string) attrs(string) description(string)
1:21:sip\:172.31.0.107\:5080:udp\:172.31.0.188\:5060:0:50:1:backend=pbx.test.co-pbx.test.co:first

On 8 December 2017 at 14:23, Bogdan-Andrei Iancu <[hidden email]> wrote:
Hi,

What db_mode do you have in the dbtext module ?

Regards,
Bogdan-Andrei Iancu
  OpenSIPS Founder and Developer
  http://www.opensips-solutions.com
On 12/07/2017 10:09 PM, Aqs Younas wrote:
Greetings of the day, 

I am having the following issues by using DBTEXT with opensips 2.3.2 (x86_64/linux).
  
1. If I add anything(new domain) through openipsctl it does not reflect in DBTEXT. 
2. If I manually insert entries in DBTEXT, reload command does not work. I had to restart opensips to make changes effective. 
3. I see this error on opensips restart no matter whatever value I set in 'state' column of the dispatcher. 

Dec  7 20:00:41 sbc2 /usr/local/opensips/sbin/opensips[2441]: CRITICAL:dispatcher:add_dest2list: BUG: unknown state -1953657376 for destination sip:172.31.0.107:5080

dispatcher table. 

id(int,auto) setid(int) destination(string) socket(string) state(string)  weight(int) priority(string) attrs(string) description(string)
1:21:sip\:172.31.0.107\:5080:udp\:172.31.0.188\:5060:0:50:1:backend=pbx.test.co-pbx.test.co:first


Any help would be much appreciated. 

Best Regards, 


_______________________________________________
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