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
