You need to use ODBC and freetds. You can't directly connect to MS SQL. It works quite well with ODBC and freetds.
Regards, Ali Pey On Thu, Nov 7, 2013 at 3:38 PM, David J <[email protected]> wrote: > 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. > On Nov 7, 2013 3:07 PM, "bluerain" <[email protected]> wrote: > >> 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 >> > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
