[OpenSIPS-Users] Dialog module sql server 2008 r2 database backend

[bluerain]

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.