[OpenSIPS-Users] db_text problem with dialog module initialization

[Jeff Pyle]

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 <jpyle at fidelityvoice.com> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130729/088b6148/attachment.htm>