[Asterisk-Users] cdr_unixodbc

[Brian West]

Pat,
	What i'm trying to figure out is how to keep the sql statement
globally prepaired then just call SQLExecute but the docs for all this are
hard to come by.  I really can't tell much diffrence in odbc over mysql in
speed but I don't have a bazillion calls going thru at once.  It does add
a layer of abstraction that should allow it to work with just bout any DB
server that has a driver for unixODBC

These include:
MySQL
Postgres
Oracle
DB2
and more...  http://www.unixodbc.org/drivers.html


bkw


On Tue, 25 Nov 2003, pat munis wrote:

> 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
>