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

[Ali Pey]

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 <david at styleflare.com> 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" <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
>>
>
> _______________________________________________
> 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/82e0b024/attachment-0001.htm>