|
That's good. The sql file I gave
you should create the correct table layout.
----- Original Message -----
Sent: Wednesday, July 28, 2004 11:32
PM
Subject: Re: [Asterisk-Users] MS SQL
& Free TDS
Duane,
you da man.. It's connecting, no segmentation or
crashing... just can't log the cdr's yet... probably a
table issue
working on it...
On Wed, 28 Jul 2004 22:22:31 -0500
"Duane Cox" <[EMAIL PROTECTED]>
wrote:
>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
>
>
>
>From: <[EMAIL PROTECTED]>
>To:
<[EMAIL PROTECTED]>
>Sent:
Wednesday, July 28, 2004 10:07 PM
>Subject: Re: [Asterisk-Users] MS SQL
& Free TDS
>
>
>> Didn't see it, but here's my reply
again... with none of
>> the
garbage...
>>
>>
>> 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.
>>
>>
>>
>>
_______________________________________________
>> 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
>>
>
>_______________________________________________
>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
_______________________________________________
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
|
