<div dir="ltr">You need to use ODBC and freetds. You can't directly connect to MS SQL.<div><br></div><div>It works quite well with ODBC and freetds.</div><div><br></div><div>Regards,<br><div class="gmail_extra">Ali Pey</div>
<div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Nov 7, 2013 at 3:38 PM, David J <span dir="ltr"><<a href="mailto:david@styleflare.com" target="_blank">david@styleflare.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<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="HOEnZb"><div class="h5">
<div class="gmail_quote">On Nov 7, 2013 3:07 PM, "bluerain" <<a href="mailto:frank21118@yahoo.com" target="_blank">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" target="_blank">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>
</div></div><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>
<br></blockquote></div><br></div><img class="cm-tracker" src="https://contactmonkey.com/api/v1/tracker?cm_session=014f5453-7d4f-4310-a9f1-f80b8b673970&cm_type=open&cm_user_email=alipey@gmail.com"></div></div>