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.
- Jeff On Mon, Jul 29, 2013 at 1:03 PM, Jeff Pyle <[email protected]> wrote: > Hello, > > Version info (installed from deb): > > version: opensips 1.9.0-notls (x86_64/linux) > flags: STATS: Off, USE_IPV6, USE_TCP, DISABLE_NAGLE, USE_MCAST, SHM_MEM, > SHM_MMAP, PKG_MALLOC, F_MALLOC, FAST_LOCK-ADAPTIVE_WAIT > ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, > MAX_URI_SIZE 1024, BUF_SIZE 65535 > poll method support: poll, epoll_lt, epoll_et, sigio_rt, select. > svnrevision: 2:9980M > @(#) $Id: main.c 9790 2013-02-15 10:14:34Z bogdan_iancu $ > main.c compiled on 13:25:11 Apr 28 2013 with gcc 4.4.5 > > > 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: > > # ----- dialog params ----- > modparam("dialog", "dlg_match_mode", 2) > modparam("dialog", "profiles_with_value", "calls") > modparam("dialog", "db_url", "text:///etc/opensips/dbtext") > modparam("dialog", "db_mode", 1) > > > This is the error I see at debug=4: > > DBG:db_text:dbt_load_file: request for table [dialog] > DBG:db_text:dbt_load_file: db is [/etc/opensips/dbtext] > DBG:db_text:dbt_load_file: loading file [/etc/opensips/dbtext/dialog] > DBG:db_text:dbt_table_new: mtime is 1375117003 > DBG:db_text:dbt_load_file: column[0] is BIGINT! > DBG:db_text:dbt_load_file: error at row=0 col=0 c=a > ERROR:db_text:dbt_query: table does not exist! > ERROR:dialog:select_entire_dialog_table: Error while querying database > ERROR:db_text:dbt_free_result: invalid parameter value > > > The /etc/opensips/dbtext/dialog table itself contains only the > header/field line: > > 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) > > > For what it's worth the version check works just fine against the version > table. Any thoughts? > > > - Jeff > >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
