Help! I've been using mysql for cdr storage, I need to switch to MS SQL. I must be stupid or something but I cannot figure out how to setup the cdr_tds. I have FreeTDS configured properly, but my unixodbc is not working properly either... I'd be happy with either solution, but I'm in need of assistance. Luke Catranis
On 28 July 2004, Luke Cantranis wrote:> > Help! > I've been using mysql for cdr storage, I need to switch to MS > SQL. I must be > stupid or something but I cannot figure out how to setup the > cdr_tds. I have > FreeTDS configured properly, but my unixodbc is not working properly > either... I'd be happy with either solution, but I'm in need > of assistance.Luke: Did you setup a profile for the database server in your freetds.conf? I've used FreeTDS with DBD::Sybase in the past, and although you can specify a hostname in the application you are using that hostname is supposed to be a profile name rather than an actual hostname. You should have a profile in your freetds.conf that looks something like the following: [profile] host = host.domain.tld port = 1433 tds version = 7.0 try domain login = yes try server login = no nt domain = DOMAIN If you have already setup a profile then please ignore this message. Regards, -- Tony Kava Senior Network Administrator Pottawattamie County, Iowa
I've had both cdr_odbc.c and cdr_tds.c working with MSSQL
What kind of specific problem are you having, we can get it working.
----- Original Message -----
From: Luke Catranis
To: asterisk-users@lists.digium.com
Sent: Wednesday, July 28, 2004 10:16 AM
Subject: [Asterisk-Users] MS SQL & Free TDS
Help!
I've been using mysql for cdr storage, I need to switch to MS SQL. I must
be
stupid or something but I cannot figure out how to setup the cdr_tds. I have
FreeTDS configured properly, but my unixodbc is not working properly
either... I'd be happy with either solution, but I'm in need of
assistance.
Luke Catranis
_______________________________________________
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20040728/998dd4bf/attachment.htm
Duane, Can you please Post your Config files and any Steps necessary to make a clean install, for the benefit of everyone. Thanks Seshu Kanuri -----Original Message----- From: asterisk-users-admin@lists.digium.com [mailto:asterisk-users-admin@lists.digium.com]On Behalf Of Duane Cox Sent: Wednesday, July 28, 2004 2:34 PM To: asterisk-users@lists.digium.com Subject: Re: [Asterisk-Users] MS SQL & Free TDS I've had both cdr_odbc.c and cdr_tds.c working with MSSQL What kind of specific problem are you having, we can get it working. ----- Original Message ----- From: Luke Catranis <mailto:luke@catranis.net> To: asterisk-users@lists.digium.com Sent: Wednesday, July 28, 2004 10:16 AM Subject: [Asterisk-Users] MS SQL & Free TDS Help! I've been using mysql for cdr storage, I need to switch to MS SQL. I must be stupid or something but I cannot figure out how to setup the cdr_tds. I have FreeTDS configured properly, but my unixodbc is not working properly either... I'd be happy with either solution, but I'm in need of assistance. Luke Catranis _______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20040728/4b6e388a/attachment.htm
On Wed, 28 Jul 2004 13:33:36 -0500 "Duane Cox" <duanec@mail.illicom.net> wrote:>I've had both cdr_odbc.c and cdr_tds.c working with MSSQL > >What kind of specific problem are you having, we can get >it working. > > > > >----- Original Message ----- >From: Luke Catranis >To: asterisk-users@lists.digium.com >Sent: Wednesday, July 28, 2004 10:16 AM >Subject: [Asterisk-Users] MS SQL & Free TDS > >Help! >I've been using mysql for cdr storage, I need to switch >to MS SQL. I must be >stupid or something but I cannot figure out how to setup >the cdr_tds. I have >FreeTDS configured properly, but my unixodbc is not >working properly >either... I'd be happy with either solution, but I'm in >need of assistance. > > >Luke Catranis > >_______________________________________________ >Asterisk-Users mailing list >Asterisk-Users@lists.digium.com >http://lists.digium.com/mailman/listinfo/asterisk-users >To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > >Two Specific Issues 1. With cdr_odbc unixodbc (2.2.9) I can connect with tsql and isql to my MS SQL server. But when I try to load the cdr_odbc in * I get a segmentation fault and the server crashes. 2. With cdr_tds, I have the .c file but that's it, I do not know what to do next, in order to compile the .so to load the module, I'm an Idiot please help.