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><div><br></div><div><br></div><div>- Jeff</div><div><br></div>