<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi,<br>
<br>
Most probably not. OpenSIPS usually does updates/inserts on this
table. Only if OpenSIPS is configured to restore it's dialogs from
DB in case of restart then you might want to make a test just to
be sure it won't complain. <br>
<br>
Regards,<br>
Alex Ionescu<br>
On 11/15/2012 01:20 PM, Jorge Ortea wrote:<br>
</div>
<blockquote cite="mid:DUB002-W83DD457649E8F1EA88A847DC520@phx.gbl"
type="cite">
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style>
<div dir="ltr">Hello,<br>
<br>
can someone said me if really modify dialog table and allow
callee_contract field to be NULL on DB could break anything??<br>
<br>
Thanks.<br>
Regards.<br>
<br>
<div>
<hr id="stopSpelling">Date: Tue, 13 Nov 2012 14:48:51 +0100<br>
From: <a class="moz-txt-link-abbreviated" href="mailto:shaheryarkh@googlemail.com">shaheryarkh@googlemail.com</a><br>
To: <a class="moz-txt-link-abbreviated" href="mailto:users@lists.opensips.org">users@lists.opensips.org</a><br>
Subject: Re: [OpenSIPS-Users] Errors in OpenSIPS<br>
<br>
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.
<div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Thank you.</div>
<div><br>
<br>
<div class="ecxgmail_quote">On Mon, Nov 12, 2012 at 1:52
PM, Jorge Ortea <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:darham@hotmail.com">darham@hotmail.com</a>></span>
wrote:<br>
<blockquote class="ecxgmail_quote"
style="border-left:1px #ccc solid;padding-left:1ex">
<div>
<div dir="ltr">Hello,<br>
<br>
I keep getting these errors.<br>
<br>
My opensips version is 1.6.4-2-tls and my mysql
version is 5.1.34<br>
<br>
Would it be better to change the version of
opensips?<br>
<br>
What can mean "Column 'callee_contact' cannot be
null" ??<br>
<br>
Thanks.<br>
Regards.<span lang="en"><span><br>
</span></span>
<div class="ecxhm ecxHOEnZb"><br>
</div>
<div>
<div class="ecxhm ecxHOEnZb">
<hr>From: <a moz-do-not-send="true"
href="mailto:darham@hotmail.com">darham@hotmail.com</a><br>
To: <a moz-do-not-send="true"
href="mailto:users@lists.opensips.org">users@lists.opensips.org</a><br>
Date: Fri, 9 Nov 2012 08:30:03 +0100</div>
<div>
<div class="h5"><br>
Subject: Re: [OpenSIPS-Users] Errors in
OpenSIPS<br>
<br>
<div dir="ltr">Hello Vlad,<br>
<br>
You are right, I had searched for ERROR,
but before each Error message I got this:<br>
<br>
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 <br>
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 <br>
<br>
<span lang="en"><span>Why</span> <span>could</span>
<span>this be happening?</span></span><br>
<br>
Thanks.<br>
Regards.<br>
<br>
<br>
<br>
<br>
<div>
<hr>Date: Thu, 8 Nov 2012 19:21:45 +0200<br>
From: <a moz-do-not-send="true"
href="mailto:vladpaiu@opensips.org">vladpaiu@opensips.org</a><br>
To: <a moz-do-not-send="true"
href="mailto:users@lists.opensips.org">users@lists.opensips.org</a><br>
Subject: Re: [OpenSIPS-Users] Errors in
OpenSIPS<br>
<br>
Hello Jorge,<br>
<br>
Do you see any other errors from the DB
level in the OpenSIPS logs ? What DB
backend are you using ?<br>
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..<br>
<br>
Regards,<br>
<pre>Vlad Paiu
OpenSIPS Developer
<a moz-do-not-send="true" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a> </pre>
<br>
On 11/08/2012 07:10 PM, Ali Pey wrote:
<blockquote>I think it's telling you it
can't add another dialog to db. I am
almost certain that's what's
happening.
<div><br>
</div>
<div>Regards,</div>
<div>Ali Pey</div>
<div><br>
</div>
<div><br>
<br>
<div> On Thu, Nov 8, 2012 at 4:22
AM, Jorge Ortea <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:darham@hotmail.com">darham@hotmail.com</a>></span>
wrote:<br>
<blockquote
style="padding-left:1ex">
<div>
<div dir="ltr">Hi all,<br>
<br>
<span lang="en"><span>I am
getting</span> <span>the
following errors</span><span>:</span></span><br>
<br>
<br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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 <br>
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<br>
<br>
<br>
<div>
<div dir="ltr"><span
lang="en"><span>What</span>
<span>is happening?</span></span></div>
</div>
<br>
<br>
Thanks.<br>
Regards.<br>
<br>
</div>
</div>
<br>
_______________________________________________<br>
Users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a moz-do-not-send="true"
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"
target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br>
</blockquote>
</div>
<br>
</div>
<pre><fieldset></fieldset>
_______________________________________________
Users mailing list
<a moz-do-not-send="true" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a moz-do-not-send="true" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
_______________________________________________
Users
mailing list
<a moz-do-not-send="true"
href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a moz-do-not-send="true"
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"
target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a></div>
</div>
<br>
_______________________________________________
Users
mailing list
<a moz-do-not-send="true"
href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a moz-do-not-send="true"
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"
target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a></div>
</div>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a moz-do-not-send="true"
href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"
target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
Muhammad Shahzad<br>
-----------------------------------<br>
CISCO Rich Media Communication Specialist (CRMCS)<br>
CISCO Certified Network Associate (CCNA)<br>
Cell: +49 176 99 83 10 85<br>
MSN: <a moz-do-not-send="true"
href="mailto:shari_786pk@hotmail.com">shari_786pk@hotmail.com</a><br>
Email: <a moz-do-not-send="true"
href="mailto:shaheryarkh@googlemail.com">shaheryarkh@googlemail.com</a><br>
</div>
</div>
<br>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a></div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>