<p dir="ltr">I hope this does not sound silly but what driver are you using to connect to mssql? Is it just odbc? I am not sure opensips will support mssql. </p>
<div class="gmail_quote">On Nov 7, 2013 3:07 PM, "bluerain" <<a href="mailto:frank21118@yahoo.com">frank21118@yahoo.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Anybody tried to use the dialog module with sql server 2008 r2 back end?<br>
<br>
Opensips will start ok if I use mysql as db for dialog module, but as soon<br>
as I switch to sql server it give me this error in the log<br>
<br>
Nov 7 19:59:50 OSIPIBD-2 /usr/local/sbin/opensips[16842]:<br>
INFO:dialog:mod_init: Dialog module - initializing<br>
Nov 7 19:59:50 OSIPIBD-2 kernel: [ 3628.711987] opensips[16842]: segfault<br>
at 0 ip (null) sp 00007ffff1abbf78 error 14 in<br>
opensips[400000+21f000]<br>
<br>
<br>
Here is the script for my sql server dialog table:<br>
<br>
CREATE TABLE [dbo].[dialog](<br>
[dlg_id] [bigint] IDENTITY(1,1) NOT NULL,<br>
[callid] [char](255) NOT NULL,<br>
[from_uri] [char](128) NOT NULL,<br>
[from_tag] [char](64) NOT NULL,<br>
[to_uri] [char](128) NOT NULL,<br>
[to_tag] [char](64) NOT NULL,<br>
[mangled_from_uri] [char](64) NULL,<br>
[mangled_to_uri] [char](64) NULL,<br>
[caller_cseq] [char](11) NOT NULL,<br>
[callee_cseq] [char](11) NOT NULL,<br>
[caller_ping_cseq] [int] NOT NULL,<br>
[callee_ping_cseq] [int] NOT NULL,<br>
[caller_route_set] [varchar](max) NULL,<br>
[callee_route_set] [varchar](max) NULL,<br>
[caller_contact] [char](128) NOT NULL,<br>
[callee_contact] [char](128) NOT NULL,<br>
[caller_sock] [char](64) NOT NULL,<br>
[callee_sock] [char](64) NOT NULL,<br>
[state] [int] NOT NULL,<br>
[start_time] [int] NOT NULL,<br>
[timeout] [int] NOT NULL,<br>
[vars] [varchar](max) NULL,<br>
[profiles] [varchar](max) NULL,<br>
[script_flags] [int] NOT NULL,<br>
[flags] [int] NOT NULL<br>
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]<br>
<br>
any thoughts? Thank you!<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://opensips-open-sip-server.1449251.n2.nabble.com/Dialog-module-sql-server-2008-r2-database-backend-tp7588430.html" target="_blank">http://opensips-open-sip-server.1449251.n2.nabble.com/Dialog-module-sql-server-2008-r2-database-backend-tp7588430.html</a><br>
Sent from the OpenSIPS - Users mailing list archive at Nabble.com.<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote></div>