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
|