<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1400" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>
<DIV><FONT face=Arial size=2>Sure thing... </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>Luke Catranis, Seshu Kanuri, and any others:</DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Asterisk CVS-HEAD, CDR with MSSQL
7.0 database; via unixODBC and FreeTDS:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>cd /usr/src &&<BR>rm -fr unixODBC-2.2.9
&&<BR>tar -zxvf unixODBC-2.2.9.tar.gz &&<BR>cd unixODBC-2.2.9
&&<BR>./configure --sysconfdir=/etc --prefix=/usr --disable-gui
&&<BR>make &&<BR>make install</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>cd /usr/src &&<BR>rm -fr freetds-0.62.4
&&<BR>tar -zxvf freetds-0.62.4.tar.gz &&<BR>cd freetds-0.62.4
&&<BR>./configure --prefix=/usr --with-tdsver=7.0
--with-unixodbc=/usr/lib &&<BR>make &&<BR>make
install</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>ldconfig -v</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>/etc/rc.d/init.d/asterisk stop</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>cd /usr/src/asterisk &&<BR>make clean
&&<BR>make update &&<BR>make &&<BR>make
install</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>cat > /etc/odbcinst.ini <<
"EOF"<BR>[FreeTDS]<BR>Description = FreeTDS ODBC driver for
MSSQL<BR>Driver =
/usr/lib/libtdsodbc.so<BR>Setup
= /usr/lib/libtdsS.so<BR>FileUsage =
1<BR>EOF</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>cat > /etc/odbc.ini <<
"EOF"<BR>[MSSQL-asterisk]<BR>description
= Asterisk ODBC for
MSSQL<BR>driver
=
FreeTDS<BR>server
=
IP.IP.IP.IP<BR>port
=
1433<BR>database
=
your_database_name_here<BR>tds_version
=
7.0<BR>language
= us_english<BR>EOF</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>[ -f /etc/asterisk/cdr_tds.conf ] >
/etc/asterisk/cdr_tds.conf</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>cat > /etc/asterisk/cdr_odbc.conf <<
"EOF"<BR>[global]<BR>dsn=MSSQL-asterisk<BR>username=your_sql_username_here<BR>password=your_sql_password_here<BR>loguniqueid=yes<BR>EOF</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>cat > cdr_table.sql << "EOF"<BR>CREATE
TABLE cdr ( <BR>
[calldate]
[datetime]
NOT NULL ,<BR>
[clid] [varchar]
(80) NOT NULL
,<BR>
[src] [varchar]
(80) NOT NULL
,<BR>
[dst] [varchar]
(80) NOT NULL
,<BR>
[dcontext] [varchar]
(80) NOT NULL
,<BR>
[channel] [varchar]
(80) NOT NULL
,<BR> [dstchannel]
[varchar] (80) NOT NULL
,<BR>
[lastapp] [varchar]
(80) NOT NULL
,<BR>
[lastdata] [varchar]
(80) NOT NULL
,<BR>
[duration]
[int]
NOT NULL ,<BR>
[billsec]
[int]
NOT NULL ,<BR>
[disposition] [varchar]
(45) NOT NULL
,<BR>
[amaflags]
[int]
NOT NULL ,<BR>
[accountcode] [varchar]
(20) NOT NULL
,<BR>
[uniqueid] [varchar]
(32) NOT NULL
,<BR>
[userfield] [varchar]
(255) NOT
NULL<BR>)<BR>GO<BR>EOF</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>echo "modify for your IP, database, username, and
password"</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>/etc/rc.d/init.d/asterisk start</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Asterisk CVS-HEAD, CDR with MSSQL
7.0 database; via FreeTDS directly (I like better):</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>cd /usr/src &&<BR>rm -fr freetds-0.62.4
&&<BR>tar -zxvf freetds-0.62.4.tar.gz &&<BR>cd freetds-0.62.4
&&<BR>./configure --prefix=/usr --with-tdsver=7.0 &&<BR>make
&&<BR>make install</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>ldconfig -v</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>/etc/rc.d/init.d/asterisk stop</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>cd /usr/src/asterisk &&<BR>make clean
&&<BR>make update &&<BR>make &&<BR>make
install</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>[ -f /etc/asterisk/cdr_odbc.conf ] >
/etc/asterisk/cdr_odbc.conf</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>cat > /etc/asterisk/cdr_tds.conf <<
"EOF"<BR>[global]<BR>hostname=IP.IP.IP.IP<BR>port=1433<BR>dbname=your_database_name_here<BR>user=your_sql_username_here<BR>password=your_sql_password_here<BR>charset=BIG5<BR>EOF</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>cat > cdr_table.sql << "EOF"<BR>CREATE
TABLE cdr (<BR>
[accountcode] [varchar]
(20) NULL
,<BR>
[src] [varchar]
(80) NULL
,<BR>
[dst] [varchar]
(80) NULL
,<BR>
[dcontext] [varchar]
(80) NULL
,<BR>
[clid] [varchar]
(80) NULL
,<BR>
[channel] [varchar]
(80) NULL
,<BR> [dstchannel]
[varchar] (80) NULL
,<BR>
[lastapp] [varchar]
(80) NULL
,<BR>
[lastdata] [varchar]
(80) NULL
,<BR>
[start]
[datetime]
NULL ,<BR>
[answer]
[datetime]
NULL ,<BR>
[end]
[datetime]
NULL ,<BR>
[duration]
[int]
NULL ,<BR>
[billsec]
[int]
NULL ,<BR> [disposition]
[varchar] (20) NULL
,<BR>
[amaflags] [varchar]
(16) NULL
,<BR>
[uniqueid] [varchar]
(32)
NULL<BR>)<BR>GO<BR>EOF</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>echo "modify for your IP, database, username, and
password"</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>/etc/rc.d/init.d/asterisk start</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Duane Cox</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=seshu.kanuri@citigroup.com
href="mailto:seshu.kanuri@citigroup.com">Kanuri, Seshu</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=asterisk-users@lists.digium.com
href="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=duanec@mail.illicom.net
href="mailto:duanec@mail.illicom.net">duanec@mail.illicom.net</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, July 28, 2004 3:55
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [Asterisk-Users] MS SQL
& Free TDS</DIV>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial size=2></FONT><FONT
face=Arial size=2></FONT><BR></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=475585320-28072004>Duane,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=475585320-28072004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=475585320-28072004>Can
you please Post your Config files and any Steps necessary to make a clean
install, for the benefit of everyone.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=475585320-28072004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=475585320-28072004>Thanks</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=475585320-28072004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=475585320-28072004>Seshu Kanuri</SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> <A
href="mailto:asterisk-users-admin@lists.digium.com">asterisk-users-admin@lists.digium.com</A>
[mailto:asterisk-users-admin@lists.digium.com]<B>On Behalf Of </B>Duane
Cox<BR><B>Sent:</B> Wednesday, July 28, 2004 2:34 PM<BR><B>To:</B> <A
href="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.com</A><BR><B>Subject:</B>
Re: [Asterisk-Users] MS SQL & Free TDS<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>I've had both cdr_odbc.c and cdr_tds.c working
with MSSQL</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>What kind of specific problem are you having,
we can get it working.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=luke@catranis.net href="mailto:luke@catranis.net">Luke
Catranis</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=asterisk-users@lists.digium.com
href="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, July 28, 2004 10:16
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Asterisk-Users] MS SQL
& Free TDS</DIV>
<DIV><BR></DIV>Help!<BR>I've been using mysql for cdr storage, I need to
switch to MS SQL. I must be<BR>stupid or something but I cannot figure out
how to setup the cdr_tds. I have<BR>FreeTDS configured properly, but my
unixodbc is not working properly<BR>either... I'd be happy with either
solution, but I'm in need of assistance.<BR><BR><BR>Luke
Catranis<BR><BR>_______________________________________________<BR>Asterisk-Users
mailing list<BR><A
href="mailto:Asterisk-Users@lists.digium.com">Asterisk-Users@lists.digium.com</A><BR><A
href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</A><BR>To
UNSUBSCRIBE or update options visit:<BR> <A
href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</A><BR></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=seshu.kanuri@citigroup.com
href="mailto:seshu.kanuri@citigroup.com">Kanuri, Seshu</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=asterisk-users@lists.digium.com
href="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=duanec@mail.illicom.net
href="mailto:duanec@mail.illicom.net">duanec@mail.illicom.net</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, July 28, 2004 3:55
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [Asterisk-Users] MS SQL
& Free TDS</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=475585320-28072004>Duane,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=475585320-28072004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=475585320-28072004>Can
you please Post your Config files and any Steps necessary to make a clean
install, for the benefit of everyone.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=475585320-28072004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=475585320-28072004>Thanks</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=475585320-28072004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=475585320-28072004>Seshu Kanuri</SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> <A
href="mailto:asterisk-users-admin@lists.digium.com">asterisk-users-admin@lists.digium.com</A>
[mailto:asterisk-users-admin@lists.digium.com]<B>On Behalf Of </B>Duane
Cox<BR><B>Sent:</B> Wednesday, July 28, 2004 2:34 PM<BR><B>To:</B> <A
href="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.com</A><BR><B>Subject:</B>
Re: [Asterisk-Users] MS SQL & Free TDS<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>I've had both cdr_odbc.c and cdr_tds.c working
with MSSQL</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>What kind of specific problem are you having,
we can get it working.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=luke@catranis.net href="mailto:luke@catranis.net">Luke
Catranis</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=asterisk-users@lists.digium.com
href="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, July 28, 2004 10:16
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Asterisk-Users] MS SQL
& Free TDS</DIV>
<DIV><BR></DIV>Help!<BR>I've been using mysql for cdr storage, I need to
switch to MS SQL. I must be<BR>stupid or something but I cannot figure out
how to setup the cdr_tds. I have<BR>FreeTDS configured properly, but my
unixodbc is not working properly<BR>either... I'd be happy with either
solution, but I'm in need of assistance.<BR><BR><BR>Luke
Catranis<BR><BR>_______________________________________________<BR>Asterisk-Users
mailing list<BR><A
href="mailto:Asterisk-Users@lists.digium.com">Asterisk-Users@lists.digium.com</A><BR><A
href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</A><BR>To
UNSUBSCRIBE or update options visit:<BR> <A
href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</A><BR></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>