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

[Ovidiu Sas]

Follow the instructions provided here:
http://www.opensips.org/Documentation/TroubleShooting-Crash

Regards,
Ovidiu Sas

On Thu, Nov 7, 2013 at 3:07 PM, bluerain <frank21118 at yahoo.com> 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
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users



-- 
VoIP Embedded, Inc.
http://www.voipembedded.com