[OpenSIPS-Users] Errors in OpenSIPS

Jorge Ortea darham at hotmail.com
Thu Nov 15 12:20:46 CET 2012


Hello,

can someone said me if really modify dialog table and allow callee_contract field to be NULL on DB could break anything??

Thanks.
Regards.

Date: Tue, 13 Nov 2012 14:48:51 +0100
From: shaheryarkh at googlemail.com
To: users at lists.opensips.org
Subject: Re: [OpenSIPS-Users] Errors in OpenSIPS

Its db schema problem. The field dialog.callee_contact is set as "NOT NULL", while you are getting NULL contact from upstream (most likely in BYE from callee side, as some old PSTN gateways running at many termination providers do not add "Contact" header in BYE request). Please check SIP trace and confirm or attach that here for our review.

For a workaround you can modify dialog table and allow callee_contract field to be NULL. However i am not sure if this won't break anything else.
Thank you.


On Mon, Nov 12, 2012 at 1:52 PM, Jorge Ortea <darham at hotmail.com> wrote:




Hello,

I keep getting these errors.

My opensips version is 1.6.4-2-tls and my mysql version is 5.1.34

Would it be better to change the version of opensips?

What can mean  "Column 'callee_contact' cannot be null" ??


Thanks.
Regards.

From: darham at hotmail.com

To: users at lists.opensips.org
Date: Fri, 9 Nov 2012 08:30:03 +0100
Subject: Re: [OpenSIPS-Users] Errors in OpenSIPS




Hello Vlad,

You are right, I had searched for ERROR, but before each Error message I got this:

Nov  5 10:24:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12562]: CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error (1048): Column 'callee_contact' cannot be null 

Nov  5 10:24:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12562]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db 

Why could this be happening?


Thanks.
Regards.




Date: Thu, 8 Nov 2012 19:21:45 +0200
From: vladpaiu at opensips.org
To: users at lists.opensips.org

Subject: Re: [OpenSIPS-Users] Errors in OpenSIPS



  
    
  
  
    Hello Jorge,

    

    Do you see any other errors from the DB level in the OpenSIPS logs ?
    What DB backend are you using ?

    It seems that for some reason, the dialog DB inserts are failing,
    but more ERROR messages should appear in such a case from the
    db_mysql module..

    

    Regards,

    Vlad Paiu
OpenSIPS Developer
http://www.opensips-solutions.com 
    

    On 11/08/2012 07:10 PM, Ali Pey wrote:
    I think it's telling you it can't add another dialog
      to db. I am almost certain that's what's happening.
      

      
      Regards,
      Ali Pey
      

      
      

        

        
          On Thu, Nov 8, 2012 at 4:22 AM, Jorge Ortea <darham at hotmail.com> wrote:

          
            
              Hi all,

                

                I am getting the
                    following errors:

                

                

                Nov  7 11:47:19 hgt-tero45
                /usr/local/opensips/sbin/opensips[12582]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 11:47:19 hgt-tero45
                /usr/local/opensips/sbin/opensips[12548]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 11:47:20 hgt-tero45
                /usr/local/opensips/sbin/opensips[12558]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 11:57:32 hgt-tero45
                /usr/local/opensips/sbin/opensips[12554]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 11:57:32 hgt-tero45
                /usr/local/opensips/sbin/opensips[12578]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 11:59:07 hgt-tero45
                /usr/local/opensips/sbin/opensips[12556]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 11:59:07 hgt-tero45
                /usr/local/opensips/sbin/opensips[12574]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 12:23:23 hgt-tero45
                /usr/local/opensips/sbin/opensips[12580]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 12:23:24 hgt-tero45
                /usr/local/opensips/sbin/opensips[12544]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 12:23:25 hgt-tero45
                /usr/local/opensips/sbin/opensips[12572]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 12:24:47 hgt-tero45
                /usr/local/opensips/sbin/opensips[12558]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 12:24:47 hgt-tero45
                /usr/local/opensips/sbin/opensips[12562]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 12:26:45 hgt-tero45
                /usr/local/opensips/sbin/opensips[12550]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 12:26:45 hgt-tero45
                /usr/local/opensips/sbin/opensips[12556]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 12:26:46 hgt-tero45
                /usr/local/opensips/sbin/opensips[12570]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 12:28:20 hgt-tero45
                /usr/local/opensips/sbin/opensips[12558]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 12:28:20 hgt-tero45
                /usr/local/opensips/sbin/opensips[12564]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 12:28:21 hgt-tero45
                /usr/local/opensips/sbin/opensips[12568]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 12:30:23 hgt-tero45
                /usr/local/opensips/sbin/opensips[12550]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 12:30:23 hgt-tero45
                /usr/local/opensips/sbin/opensips[12572]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 12:30:25 hgt-tero45
                /usr/local/opensips/sbin/opensips[12576]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 13:12:13 hgt-tero45
                /usr/local/opensips/sbin/opensips[12548]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 13:12:13 hgt-tero45
                /usr/local/opensips/sbin/opensips[12546]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 13:12:13 hgt-tero45
                /usr/local/opensips/sbin/opensips[12576]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 13:23:34 hgt-tero45
                /usr/local/opensips/sbin/opensips[12582]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 13:23:34 hgt-tero45
                /usr/local/opensips/sbin/opensips[12566]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 13:23:34 hgt-tero45
                /usr/local/opensips/sbin/opensips[12580]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 13:33:09 hgt-tero45
                /usr/local/opensips/sbin/opensips[12572]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 13:33:09 hgt-tero45
                /usr/local/opensips/sbin/opensips[12578]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 13:33:09 hgt-tero45
                /usr/local/opensips/sbin/opensips[12574]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 14:10:19 hgt-tero45
                /usr/local/opensips/sbin/opensips[12556]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 14:10:19 hgt-tero45
                /usr/local/opensips/sbin/opensips[12564]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 14:10:21 hgt-tero45
                /usr/local/opensips/sbin/opensips[12558]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 17:58:43 hgt-tero45
                /usr/local/opensips/sbin/opensips[12572]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 17:58:43 hgt-tero45
                /usr/local/opensips/sbin/opensips[12548]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 17:58:44 hgt-tero45
                /usr/local/opensips/sbin/opensips[12578]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 19:08:33 hgt-tero45
                /usr/local/opensips/sbin/opensips[12558]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 19:08:33 hgt-tero45
                /usr/local/opensips/sbin/opensips[12578]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db 

                Nov  7 19:08:34 hgt-tero45
                /usr/local/opensips/sbin/opensips[12572]:
                ERROR:dialog:update_dialog_dbinfo: could not add another
                dialog to db

                

                

                
                  What
                      is happening?
                
                

                

                Thanks.

                Regards.

                

              
            
            

            _______________________________________________

            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

    
  


_______________________________________________
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 		 	   		  

_______________________________________________

Users mailing list

Users at lists.opensips.org

http://lists.opensips.org/cgi-bin/mailman/listinfo/users




-- 
Muhammad Shahzad
-----------------------------------
CISCO Rich Media Communication Specialist (CRMCS)
CISCO Certified Network Associate (CCNA)

Cell: +49 176 99 83 10 85
MSN: shari_786pk at hotmail.com
Email: shaheryarkh at googlemail.com




_______________________________________________
Users mailing list
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20121115/ecf05964/attachment-0001.htm>


More information about the Users mailing list