Anybody tried to use the dialog module with sql server 2008 r2 back end?
Opensips will start ok if I use mysql as db for dialog module, but as soon
as I switch to sql server it give me this error in the log
Nov 7 19:59:50 OSIPIBD-2 /usr/local/sbin/opensips[16842]:
INFO:dialog:mod_init: Dialog module - initializing
Nov 7 19:59:50 OSIPIBD-2 kernel: [ 3628.711987] opensips[16842]: segfault
at 0 ip (null) sp 00007ffff1abbf78 error 14 in
opensips[400000+21f000]
Here is the script for my sql server dialog table:
CREATE TABLE [dbo].[dialog](
[dlg_id] [bigint] IDENTITY(1,1) NOT NULL,
[callid] [char](255) NOT NULL,
[from_uri] [char](128) NOT NULL,
[from_tag] [char](64) NOT NULL,
[to_uri] [char](128) NOT NULL,
[to_tag] [char](64) NOT NULL,
[mangled_from_uri] [char](64) NULL,
[mangled_to_uri] [char](64) NULL,
[caller_cseq] [char](11) NOT NULL,
[callee_cseq] [char](11) NOT NULL,
[caller_ping_cseq] [int] NOT NULL,
[callee_ping_cseq] [int] NOT NULL,
[caller_route_set] [varchar](max) NULL,
[callee_route_set] [varchar](max) NULL,
[caller_contact] [char](128) NOT NULL,
[callee_contact] [char](128) NOT NULL,
[caller_sock] [char](64) NOT NULL,
[callee_sock] [char](64) NOT NULL,
[state] [int] NOT NULL,
[start_time] [int] NOT NULL,
[timeout] [int] NOT NULL,
[vars] [varchar](max) NULL,
[profiles] [varchar](max) NULL,
[script_flags] [int] NOT NULL,
[flags] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
any thoughts? Thank you!
--
View this message in context:
http://opensips-open-sip-server.1449251.n2.nabble.com/Dialog-module-sql-server-2008-r2-database-backend-tp7588430.html
Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
