<div dir="ltr"><div class="gmail_extra"><div><div dir="ltr"><div>Mystery solved. It's not working here either. I missed it before because logging shows up differently in this environment.</div><div><br></div><div><br>
</div><div>- Jeff</div><div><br></div></div></div><br><div class="gmail_quote">On Tue, Oct 22, 2013 at 10:50 AM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>
<div 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><div class="im">
<pre cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre>
<br></div><div><div class="h5">
On 10/22/2013 05:47 PM, Jeff Pyle wrote:
<blockquote 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 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 href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre>
<div>
<div> <br>
On 10/22/2013 06:55 AM, Jeff Pyle wrote: </div>
</div>
<blockquote type="cite">
<div>
<div>
<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 href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a 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>
</div></div></div>
</blockquote></div><br></div></div>