[Asterisk-Users] cdr_unixodbc

[pat munis]

Brian
   Good job!!! Is there any perfomance hit by using unixodbc as oppossed to for example using cdr_mysql for mysql?



----- Original Message -----
From: Brian West <brian at bkw.org>
Date: Tue, 25 Nov 2003 07:19:27 -0600 (CST)
To: asterisk-users at lists.digium.com
Subject: Re: [Asterisk-Users] cdr_unixodbc

> Ok the basic requirement is unixODBC and the MyODBC driver(for MySQL) or
> you can pick what ever you want(http://www.unixodbc.org/drivers.html).
> The table structure is the same as pgsql or mysql ... just duplicate that.
> 
> I would like to verify that I have done this in such a way that the
> database you choose to use won't matter(unixODBC is all about that)
> 
> odbc.ini info:
> 
> [ODBC Data Sources]
> MySQL-asterisk = MySQL ODBC Driver Asterisk DSN
> 
> [MySQL-asterisk]
> Description     = MySQL ODBC Driver Asterisk DSN
> Driver          = MySQL
> Socket          = /var/run/mysqld/mysqld.sock
> Server          = localhost
> User            = root
> Database        = asterisk
> Option          = 3
> #Port           =
> Password        = password
> 
> odbcinst.ini
> 
> [MySQL]
> Description     = MySQL ODBC MyODBC Driver
> Driver          = /usr/lib/libmyodbc3.so
> 
> ...  I will give you guys time to do that ... and i'm still cleaning up
> the code a bit more.  unixODBC is a bit more forgiving than the MySQL C
> API is.
> 
> 
> bkw
> 
> 
> On Tue, 25 Nov 2003, WipeOut wrote:
> 
> > Pavel Litvinenko wrote:
> >
> > > Brian West wrote:
> > >
> > >> asterisk*CLI> load cdr_unixodbc.so
> > >> Loaded /usr/lib/asterisk/modules/cdr_unixodbc.so => (unixODBC CDR
> > >> Backend)
> > >>  == Parsing '/etc/asterisk/cdr_unixodbc.conf':   == Parsing
> > >> '/etc/asterisk/cdr_unixodbc.conf': Found
> > >>    -- cdr_unixodbc: dsn is MySQL-asterisk
> > >>    -- cdr_unixodbc: username is root
> > >>    -- cdr_unixodbc: password is [secret]
> > >>    -- Connected to MySQL-asterisk
> > >>
> > >> it works.. it logs calls.  Anyone else intrested?  For now I have to do
> > >> more clean up... ya know make it pretty. :)
> > >>
> > >>
> > > Yes,  I do :) where can I get it  ?
> > >
> > What are the software requirements?
> >
> > I have never used unixodbc before.. :)
> >
> > Later..
> >
> > _______________________________________________
> > Asterisk-Users mailing list
> > Asterisk-Users at lists.digium.com
> > http://lists.digium.com/mailman/listinfo/asterisk-users
> >
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users

-- 
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm