Problem solved. It appeared my version of the dialog table was incorrect. I didn't have them available at first due to the apt/deb install. I did a fresh SVN download of the 1.9 trunk to get a copy of them, and used them with the apt/dev/install. No more errors.<div>
<br></div><div><br></div><div>- Jeff</div><div><br>
<br><br><div class="gmail_quote">On Mon, Jul 29, 2013 at 1:03 PM, Jeff Pyle <span dir="ltr"><<a href="mailto:jpyle@fidelityvoice.com" target="_blank">jpyle@fidelityvoice.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hello,
<div><br></div><div><div>Version info (installed from deb):</div><div><br></div></div><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div><div>version: opensips 1.9.0-notls (x86_64/linux)</div></div><div><div>
flags: STATS: Off, USE_IPV6, USE_TCP, DISABLE_NAGLE, USE_MCAST, SHM_MEM, SHM_MMAP, PKG_MALLOC, F_MALLOC, FAST_LOCK-ADAPTIVE_WAIT</div></div><div><div>ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535</div>
</div><div><div>poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.</div></div><div><div>svnrevision: 2:9980M</div></div><div><div>@(#) $Id: main.c 9790 2013-02-15 10:14:34Z bogdan_iancu $</div></div><div><div>
main.c compiled on 13:25:11 Apr 28 2013 with gcc 4.4.5</div></div></blockquote><div><br></div><div>I'm trying to configure the dialog module to use the db_text backend for dialog storage to allow for dialog persistence between restarts. In my opensips.cfg I have:</div>
<div><br></div><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div><div># ----- dialog params -----</div></div><div><div>modparam("dialog", "dlg_match_mode", 2)</div></div><div><div>modparam("dialog", "profiles_with_value", "calls")</div>
</div><div><div>modparam("dialog", "db_url", "text:///etc/opensips/dbtext")</div></div><div><div>modparam("dialog", "db_mode", 1)</div></div></blockquote><div><br></div><div>
This is the error I see at debug=4:</div><div><br></div><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div><div>DBG:db_text:dbt_load_file: request for table [dialog]</div></div><div><div>DBG:db_text:dbt_load_file: db is [/etc/opensips/dbtext]</div>
</div><div><div>DBG:db_text:dbt_load_file: loading file [/etc/opensips/dbtext/dialog]</div></div><div><div>DBG:db_text:dbt_table_new: mtime is 1375117003</div></div><div><div>DBG:db_text:dbt_load_file: column[0] is BIGINT!</div>
</div><div><div>DBG:db_text:dbt_load_file: error at row=0 col=0 c=a</div></div><div><div>ERROR:db_text:dbt_query: table does not exist!</div></div><div><div>ERROR:dialog:select_entire_dialog_table: Error while querying database</div>
</div><div><div>ERROR:db_text:dbt_free_result: invalid parameter value</div></div></blockquote><div><br></div><div>The /etc/opensips/dbtext/dialog table itself contains only the header/field line:</div><div><br></div><blockquote style="margin:0 0 0 40px;border:none;padding:0px">
<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>
</blockquote><div><br></div><div>For what it's worth the version check works just fine against the version table. Any thoughts?</div><span class="HOEnZb"><font color="#888888"><div><br></div><div><br></div><div>- Jeff</div>
<div><br></div>
</font></span></blockquote></div><br></div>