Re: [Asterisk-Users] MS SQL & Free TDS

Duane Cox Wed, 28 Jul 2004 17:50:04 -0700

Sure thing...

Luke Catranis, Seshu Kanuri, and any others:

Asterisk CVS-HEAD, CDR with MSSQL 7.0 database; via unixODBC and FreeTDS:

cd /usr/src &&
rm -fr unixODBC-2.2.9 &&
tar -zxvf unixODBC-2.2.9.tar.gz &&
cd unixODBC-2.2.9 &&
./configure --sysconfdir=/etc --prefix=/usr --disable-gui &&
make &&
make install

cd /usr/src &&
rm -fr freetds-0.62.4 &&
tar -zxvf freetds-0.62.4.tar.gz &&
cd freetds-0.62.4 &&
./configure --prefix=/usr --with-tdsver=7.0 --with-unixodbc=/usr/lib &&
make &&
make install

ldconfig -v

/etc/rc.d/init.d/asterisk stop

cd /usr/src/asterisk &&
make clean &&
make update &&
make &&
make install

cat > /etc/odbcinst.ini << "EOF"
[FreeTDS]
Description    = FreeTDS ODBC driver for MSSQL
Driver         = /usr/lib/libtdsodbc.so
Setup          = /usr/lib/libtdsS.so
FileUsage      = 1
EOF

cat > /etc/odbc.ini << "EOF"
[MSSQL-asterisk]
description         = Asterisk ODBC for MSSQL
driver              = FreeTDS
server              = IP.IP.IP.IP
port                = 1433
database            = your_database_name_here
tds_version         = 7.0
language            = us_english
EOF

[ -f /etc/asterisk/cdr_tds.conf ] > /etc/asterisk/cdr_tds.conf

cat > /etc/asterisk/cdr_odbc.conf << "EOF"
[global]
dsn=MSSQL-asterisk
username=your_sql_username_here
password=your_sql_password_here
loguniqueid=yes
EOF

cat > cdr_table.sql << "EOF"
CREATE TABLE cdr (
        [calldate]      [datetime]              NOT NULL ,
        [clid]          [varchar] (80)          NOT NULL ,
        [src]           [varchar] (80)          NOT NULL ,
        [dst]           [varchar] (80)          NOT NULL ,
        [dcontext]      [varchar] (80)          NOT NULL ,
        [channel]       [varchar] (80)          NOT NULL ,
        [dstchannel]    [varchar] (80)          NOT NULL ,
        [lastapp]       [varchar] (80)          NOT NULL ,
        [lastdata]      [varchar] (80)          NOT NULL ,
        [duration]      [int]                   NOT NULL ,
        [billsec]       [int]                   NOT NULL ,
        [disposition]   [varchar] (45)          NOT NULL ,
        [amaflags]      [int]                   NOT NULL ,
        [accountcode]   [varchar] (20)          NOT NULL ,
        [uniqueid]      [varchar] (32)          NOT NULL ,
        [userfield]     [varchar] (255)         NOT NULL
)
GO
EOF

echo "modify for your IP, database, username, and password"

/etc/rc.d/init.d/asterisk start

Asterisk CVS-HEAD, CDR with MSSQL 7.0 database; via FreeTDS directly (I like better):

cd /usr/src &&
rm -fr freetds-0.62.4 &&
tar -zxvf freetds-0.62.4.tar.gz &&
cd freetds-0.62.4 &&
./configure --prefix=/usr --with-tdsver=7.0 &&
make &&
make install

ldconfig -v

/etc/rc.d/init.d/asterisk stop

cd /usr/src/asterisk &&
make clean &&
make update &&
make &&
make install

[ -f /etc/asterisk/cdr_odbc.conf ] > /etc/asterisk/cdr_odbc.conf

cat > /etc/asterisk/cdr_tds.conf << "EOF"
[global]
hostname=IP.IP.IP.IP
port=1433
dbname=your_database_name_here
user=your_sql_username_here
password=your_sql_password_here
charset=BIG5
EOF

cat > cdr_table.sql << "EOF"
CREATE TABLE cdr (
        [accountcode]   [varchar] (20)          NULL ,
        [src]           [varchar] (80)          NULL ,
        [dst]           [varchar] (80)          NULL ,
        [dcontext]      [varchar] (80)          NULL ,
        [clid]          [varchar] (80)          NULL ,
        [channel]       [varchar] (80)          NULL ,
        [dstchannel]    [varchar] (80)          NULL ,
        [lastapp]       [varchar] (80)          NULL ,
        [lastdata]      [varchar] (80)          NULL ,
        [start]         [datetime]              NULL ,
        [answer]        [datetime]              NULL ,
        [end]           [datetime]              NULL ,
        [duration]      [int]                   NULL ,
        [billsec]       [int]                   NULL ,
        [disposition]   [varchar] (20)          NULL ,
        [amaflags]      [varchar] (16)          NULL ,
        [uniqueid]      [varchar] (32)          NULL
)
GO
EOF

echo "modify for your IP, database, username, and password"

/etc/rc.d/init.d/asterisk start

Duane Cox

----- Original Message -----

From: Kanuri, Seshu

To: [EMAIL PROTECTED]

Cc: [EMAIL PROTECTED]

Sent: Wednesday, July 28, 2004 3:55 PM

Subject: RE: [Asterisk-Users] MS SQL & Free TDS

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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Duane Cox
Sent: Wednesday, July 28, 2004 2:34 PM
To: [EMAIL PROTECTED]
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

To: [EMAIL PROTECTED]

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
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] MS SQL & Free TDS

Reply via email to