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

[David J]

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" <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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20131107/83049839/attachment.htm>