RE: [Asterisk-Users] cdr_unixodbc

2003-11-26 Thread Brian West
[mailto:[EMAIL PROTECTED] Posted At: Wednesday, 26 November 2003 7:22 AM Posted To: Asterisk Conversation: [Asterisk-Users] cdr_unixodbc Subject: Re: [Asterisk-Users] cdr_unixodbc Good idea. When do you want it? :P but that does give me an idea. http://www.bkw.org/~brian

RE: [Asterisk-Users] cdr_unixodbc

2003-11-25 Thread Asterisk
Brian! You've done something tricky again! I'm interested! *wink* Where do I get it? ;) Ben __ Benjamin Wakefield [EMAIL PROTECTED] http://www.dcsi.net.au/ DCSI - We do Internet. 64 Queen Street Warragul, VIC 3820 AU Ph: (+61) 1300 665 575 Fx: (+61) 1300 556 595

Re: [Asterisk-Users] cdr_unixodbc

2003-11-25 Thread Pavel Litvinenko
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:

Re: [Asterisk-Users] cdr_unixodbc

2003-11-25 Thread WipeOut
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

RE: [Asterisk-Users] cdr_unixodbc

2003-11-25 Thread Adams, Gavin
-Original Message- From: Brian West [mailto:[EMAIL PROTECTED] 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 --

Re: [Asterisk-Users] cdr_unixodbc

2003-11-25 Thread Brian West
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

RE: [Asterisk-Users] cdr_unixodbc

2003-11-25 Thread Vledder, Hans
Hi Brian, Excellent job, but how about calling the application 'cdr_odbc' instead of 'cdr_unixodbc', because up to now 'unix' is obvious/trivial when it comes to * isn't it? Besides, I think 'cdr_odbc' is more in line with cdr_mysql and cdr_csv and what have you ... Keep it up ! Hans

Re: [Asterisk-Users] cdr_unixodbc

2003-11-25 Thread Brian West
http://www.bkw.org/~brian/cdr_unixodbc.tar.gz asterisk root # cd /usr/src/ asterisk src # tar zxfv cdr_unixodbc.tar.gz cdr_unixodbc/ cdr_unixodbc/cdr_unixodbc.c cdr_unixodbc/Makefile cdr_unixodbc/mkdep cdr_unixodbc/cdr_unixodbc.conf.sample asterisk src # cd cdr_unixodbc asterisk cdr_unixodbc #

RE: [Asterisk-Users] cdr_unixodbc

2003-11-25 Thread Brian West
I called it that because i'm using the unixODBC libs. I guess I can change that! :P I just posted the code and install instructions to the list. Also if i'm thinking correct this will sidestep the issue with mysql and gpl since unixODBC is lgpl? bkw On Tue, 25 Nov 2003, Vledder, Hans wrote:

Re: [Asterisk-Users] cdr_unixodbc

2003-11-25 Thread Tilghman Lesher
On Tuesday 25 November 2003 07:50, Vledder, Hans wrote: Excellent job, but how about calling the application 'cdr_odbc' instead of 'cdr_unixodbc', because up to now 'unix' is obvious/trivial when it comes to * isn't it? Besides, I think 'cdr_odbc' is more in line with cdr_mysql and cdr_csv and

Re: [Asterisk-Users] cdr_unixodbc

2003-11-25 Thread 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 [EMAIL PROTECTED] Date: Tue, 25 Nov 2003 07:19:27 -0600 (CST) To: [EMAIL PROTECTED] Subject: Re: [Asterisk-Users] cdr_unixodbc

Re: [Asterisk-Users] cdr_unixodbc

2003-11-25 Thread Brian West
hit by using unixodbc as oppossed to for example using cdr_mysql for mysql? - Original Message - From: Brian West [EMAIL PROTECTED] Date: Tue, 25 Nov 2003 07:19:27 -0600 (CST) To: [EMAIL PROTECTED] Subject: Re: [Asterisk-Users] cdr_unixodbc Ok the basic requirement is unixODBC

Re: [Asterisk-Users] cdr_unixodbc

2003-11-25 Thread Brian West
Just an FYI I have cdr_unixodbc doing inserts using Text file driver now bkw ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [Asterisk-Users] cdr_unixodbc

2003-11-25 Thread Philipp von Klitzing
Hi! Indeed great move, Brian! 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

Re: [Asterisk-Users] cdr_unixodbc

2003-11-25 Thread Brian West
Good idea. When do you want it? :P but that does give me an idea. http://www.bkw.org/~brian/cdr_unixodbc.tar.gz I have done some cleaning. I added the ability for the cdr driver to retry the db connection. Like if your sql server went a way and it lost the connection it will retry the

RE: [Asterisk-Users] cdr_unixodbc

2003-11-25 Thread Asterisk
At: Wednesday, 26 November 2003 7:22 AM Posted To: Asterisk Conversation: [Asterisk-Users] cdr_unixodbc Subject: Re: [Asterisk-Users] cdr_unixodbc Good idea. When do you want it? :P but that does give me an idea. http://www.bkw.org/~brian/cdr_unixodbc.tar.gz I have done some cleaning. I added

RE: [Asterisk-Users] cdr_unixodbc

2003-11-25 Thread Brian West
: Re: [Asterisk-Users] cdr_unixodbc Good idea. When do you want it? :P but that does give me an idea. http://www.bkw.org/~brian/cdr_unixodbc.tar.gz I have done some cleaning. I added the ability for the cdr driver to retry the db connection. Like if your sql server went a way and it lost

RE: [Asterisk-Users] cdr_unixodbc

2003-11-25 Thread Brian West
Queen Street Warragul, VIC 3820 AU Ph: (+61) 1300 665 575 Fx: (+61) 1300 556 595 -Original Message- From: Brian West [mailto:[EMAIL PROTECTED] Posted At: Wednesday, 26 November 2003 7:22 AM Posted To: Asterisk Conversation: [Asterisk-Users] cdr_unixodbc Subject: Re: [Asterisk