[OpenSIPS-Users] db_text problem with dialog module initialization

[Jeff Pyle]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130729/2a0171ec/attachment.htm>