<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
<tt>Hi Jeff,<br>
<br>
Maybe a different version? - the change was done with 1.9 version.
Previously, the dlg_int was int and auto incremented by DB.
Starting with 1.9 the dlg_int is computed and filled in by
OpenSIPS as DB long.<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<br>
On 10/22/2013 05:47 PM, Jeff Pyle wrote:
<blockquote
cite="mid:CACYJG3KLZMy+16VUYa34K2gX-A1S1gsUipfkgV_wAR5S03311w@mail.gmail.com"
type="cite">
<div dir="ltr">Hi Bogdan,
<div><br>
</div>
<div>Perfect. Strange that it continues to work on the "full"
system with 'auto'. I thought for sure it was something to do
with the embedded Atom box.</div>
<div>
<br>
</div>
<div>I'll start a new thread soon with the dialog restore
problem.</div>
<div><br>
</div>
<div><br>
</div>
<div>- Jeff</div>
<div><br>
</div>
<div class="gmail_extra">
<br>
<br>
<div class="gmail_quote">On Tue, Oct 22, 2013 at 9:37 AM,
Bogdan-Andrei Iancu <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:bogdan@opensips.org"
target="_blank">bogdan@opensips.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<div text="#000000" bgcolor="#ffffff"> Hi Jeff,<br>
<br>
Indeed, the flag "auto" should not be there starting
with 1.9 . It seems DB_TEXT spec file was not updated
:(, but I took care of that now - GIT is up to date.<br>
<br>
So, let's move the next issue, when auto is removed :)<br>
<br>
Regards,<br>
<pre cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre>
<div>
<div class="h5"> <br>
On 10/22/2013 06:55 AM, Jeff Pyle wrote: </div>
</div>
<blockquote type="cite">
<div>
<div class="h5">
<div dir="ltr">
<div>
<div dir="ltr">
<div>Hello,</div>
<div><br>
</div>
<div>On 1.9 I'm seeing the following problem
loading the dialog table from dbtext at
startup:</div>
<div><br>
</div>
</div>
</div>
<blockquote style="margin: 0pt 0pt 0pt 40px;
border: medium none; padding: 0px;">
<div>
<div>
<div>
<div>DBG:db_text:dbt_load_file: request
for table [dialog]</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>DBG:db_text:dbt_load_file: db is
[/etc/opensips/dbtext]</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>DBG:db_text:dbt_load_file: loading
file [/etc/opensips/dbtext/dialog]</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>DBG:db_text:dbt_table_new: mtime is
1382412942</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>DBG:db_text:dbt_load_file:
column[0] is BIGINT!</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>DBG:db_text:dbt_load_file: error at
row=0 col=0 c=a</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>ERROR:db_text:dbt_query: table does
not exist!</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>ERROR:dialog:select_entire_dialog_table:
Error while querying database</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>ERROR:db_text:dbt_free_result:
invalid parameter value</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>DBG:db_text:dbt_load_file: request
for table [dialog]</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>DBG:db_text:dbt_load_file: db is
[/etc/opensips/dbtext]</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>DBG:db_text:dbt_load_file: loading
file [/etc/opensips/dbtext/dialog]</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>DBG:db_text:dbt_table_new: mtime is
1382412942</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>DBG:db_text:dbt_load_file:
column[0] is BIGINT!</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>DBG:db_text:dbt_load_file: error at
row=0 col=0 c=a</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>ERROR:db_text:dbt_delete: failed to
load table <dialog>!</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>ERROR:dialog:remove_all_dialogs_from_db:
failed to delete database information</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>WARNING:dialog:init_dlg_db: failed
to properly remove all the dialogs
form DB</div>
</div>
</div>
</div>
</blockquote>
<div>
<div dir="ltr">
<div><br>
</div>
<div>The contents of the dialog file are
from the source tree file
scripts/dbtext/opensips/dialog:</div>
<div><br>
</div>
</div>
</div>
<blockquote style="margin: 0pt 0pt 0pt 40px;
border: medium none; padding: 0px;">
<div>
<div dir="ltr">
<div>dlg_id(long,auto) callid(string)
from_uri(string) from_tag(string)
to_uri(string) to_tag(string)
mangled_from_uri(string,null)
mangled_to_uri(string,null)
caller_cseq(string) callee_cseq(string)
caller_ping_cseq(int)
callee_ping_cseq(int)
caller_route_set(string,null)
callee_route_set(string,null)
caller_contact(string)
callee_contact(string)
caller_sock(string) callee_sock(string)
state(int) start_time(int) timeout(int)
vars(string,null) profiles(string,null)
script_flags(int) flags(int)</div>
</div>
</div>
</blockquote>
<div>
<div dir="ltr">
<div><br>
</div>
<div>Above I see "error at row=0 col=0 c=a"
which leads me to believe it doesn't like
the 'auto' in the dlg_id declaration.
Indeed, if I remove the 'auto' flag it
starts okay. But dialogs saved to the
table don't match if Opensips has been
restarted during the dialog's life. I
don't know if this is related to the
absence of the 'auto' flag. One problem
at a time.</div>
<div><br>
</div>
<div>This is on Voyage Linux 0.9 64-bit on
an Intel Atom board. Exactly the same
Opensips .deb packages with exactly the
same dbtext directory running on a
"normal" Debian 7 system do not cause this
error. The only difference I am aware of
is on the Voyage/Atom system the dbtext
directory is in a ramdisk while on the
Debian 7 system it's on a normal disk. </div>
<div><br>
</div>
<div>Any thought what might cause the 'auto'
flag to throw an error in this
environment?</div>
<div><br>
</div>
<div><br>
</div>
<div>- Jeff</div>
<div><br>
</div>
</div>
</div>
</div>
</div>
</div>
<pre><fieldset></fieldset>
_______________________________________________
Users mailing list
<a moz-do-not-send="true" href="mailto:Users@lists.opensips.org" target="_blank">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>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</blockquote>
</body>
</html>