RE: [Asterisk-Users] cdr_unixodbc
Oh its been tested with DB2, MySQL, Text Files and PostgreSQL... Works like a charm! :P bkw On Tue, 25 Nov 2003, Brian West wrote: > http://bugs.digium.com/bug_view_page.php?bug_id=578 > > Just in case anyone else wants more instructions. :) > > bkw > > On Wed, 26 Nov 2003, Asterisk wrote: > > > I'M AGAINST USING CAPS TO EXPRESS MYSELF BUT I'M SO HAPPY! > > > > I was a little scared of setting up the CDR because I couldn't find much > > documentation... turns out it's a piece of cake! > > > > You guys are right, read the code, not so hard after all! > > > > ...works with Microsoft SQL Server 7.0 too! > > > > > > Thanks Brian! > > > > :) > > 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 > > > > > > > > -----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-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 > > the connection it will retry the connection then try the insert again if > > the first insert fails. > > > > bkw > > PS: MySQL and Text Driver work... any others wanna test others? > > > > On Tue, 25 Nov 2003, Philipp von Klitzing wrote: > > > > > 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 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 > > > > > > Ok, next dream: Have new applications "DBputODBC", "DBdelODBC" etc? > > > > > > Philipp > > > > > > > > > ___ > > > Asterisk-Users mailing list > > > [EMAIL PROTECTED] > > > http://lists.digium.com/mailman/listinfo/asterisk-users > > > > > ___ > > Asterisk-Users mailing list > > [EMAIL PROTECTED] > > http://lists.digium.com/mailman/listinfo/asterisk-users > > ___ > > Asterisk-Users mailing list > > [EMAIL PROTECTED] > > http://lists.digium.com/mailman/listinfo/asterisk-users > > > ___ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] cdr_unixodbc
http://bugs.digium.com/bug_view_page.php?bug_id=578 Just in case anyone else wants more instructions. :) bkw On Wed, 26 Nov 2003, Asterisk wrote: > I'M AGAINST USING CAPS TO EXPRESS MYSELF BUT I'M SO HAPPY! > > I was a little scared of setting up the CDR because I couldn't find much > documentation... turns out it's a piece of cake! > > You guys are right, read the code, not so hard after all! > > ...works with Microsoft SQL Server 7.0 too! > > > Thanks Brian! > > :) > 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 > > > > -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-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 > the connection it will retry the connection then try the insert again if > the first insert fails. > > bkw > PS: MySQL and Text Driver work... any others wanna test others? > > On Tue, 25 Nov 2003, Philipp von Klitzing wrote: > > > 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 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 > > > > Ok, next dream: Have new applications "DBputODBC", "DBdelODBC" etc? > > > > Philipp > > > > > > ___ > > Asterisk-Users mailing list > > [EMAIL PROTECTED] > > http://lists.digium.com/mailman/listinfo/asterisk-users > > > ___ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > ___ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] cdr_unixodbc
Grab the latest tarball I added a few things :) If it fails to connect it will try to re-establish the connection... and so on. bkw On Wed, 26 Nov 2003, Asterisk wrote: > I'M AGAINST USING CAPS TO EXPRESS MYSELF BUT I'M SO HAPPY! > > I was a little scared of setting up the CDR because I couldn't find much > documentation... turns out it's a piece of cake! > > You guys are right, read the code, not so hard after all! > > ...works with Microsoft SQL Server 7.0 too! > > > Thanks Brian! > > :) > 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 > > > > -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-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 > the connection it will retry the connection then try the insert again if > the first insert fails. > > bkw > PS: MySQL and Text Driver work... any others wanna test others? > > On Tue, 25 Nov 2003, Philipp von Klitzing wrote: > > > 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 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 > > > > Ok, next dream: Have new applications "DBputODBC", "DBdelODBC" etc? > > > > Philipp > > > > > > ___ > > Asterisk-Users mailing list > > [EMAIL PROTECTED] > > http://lists.digium.com/mailman/listinfo/asterisk-users > > > ___ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > ___ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] cdr_unixodbc
I'M AGAINST USING CAPS TO EXPRESS MYSELF BUT I'M SO HAPPY! I was a little scared of setting up the CDR because I couldn't find much documentation... turns out it's a piece of cake! You guys are right, read the code, not so hard after all! ...works with Microsoft SQL Server 7.0 too! Thanks Brian! :) 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 -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-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 the connection it will retry the connection then try the insert again if the first insert fails. bkw PS: MySQL and Text Driver work... any others wanna test others? On Tue, 25 Nov 2003, Philipp von Klitzing wrote: > 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 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 > > Ok, next dream: Have new applications "DBputODBC", "DBdelODBC" etc? > > Philipp > > > ___ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
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 the connection it will retry the connection then try the insert again if the first insert fails. bkw PS: MySQL and Text Driver work... any others wanna test others? On Tue, 25 Nov 2003, Philipp von Klitzing wrote: > 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 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 > > Ok, next dream: Have new applications "DBputODBC", "DBdelODBC" etc? > > Philipp > > > ___ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_unixodbc
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 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 Ok, next dream: Have new applications "DBputODBC", "DBdelODBC" etc? Philipp ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_unixodbc
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
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 <[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 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 > > > [EMAIL PROTECTED] > > > http://lists.digium.com/mailman/listinfo/asterisk-users > > > > > ___ > > Asterisk-Users mailing list > > [EMAIL PROTECTED] > > http://lists.digium.com/mailman/listinfo/asterisk-users > > -- > ___ > Sign-up for Ads Free at Mail.com > http://promo.mail.com/adsfreejump.htm > ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_unixodbc
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 > 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 > > [EMAIL PROTECTED] > > http://lists.digium.com/mailman/listinfo/asterisk-users > > > ___ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_unixodbc
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 what have > you ... On the contrary, he's using the unixodbc library, not the iODBC library (also for Linux), so in case somebody ever creates that cdr driver, it will greatly lessen the confusion. -Tilghman ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] cdr_unixodbc
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: > 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 > > -Original Message- > From: Brian West [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 25, 2003 9:28 AM > To: [EMAIL PROTECTED] > Subject: [Asterisk-Users] cdr_unixodbc > > > 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. :) > > bkw > PS unixODBC is LGPL :) > ___ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > > > -- > The contents of this e-mail are intended for the named addressee only. It > contains information that may be confidential. Unless you are the named > addressee or an authorized designee, you may not copy or use it, or disclose > it to anyone else. If you received it in error please notify us immediately > and then destroy it. > > ___ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_unixodbc
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 # make ./mkdep -fPIC -I../asterisk `ls *.c` gcc -fPIC -I../asterisk -c -o cdr_unixodbc.o cdr_unixodbc.c gcc -shared -Xlinker -x -o cdr_unixodbc.so cdr_unixodbc.o -lodbc -lz -fPIC -I../asterisk asterisk cdr_unixodbc # make install for x in cdr_unixodbc.so; do install -m 755 $x /usr/lib/asterisk/modules ; done asterisk cdr_unixodbc #cp cdr_unixodbc.conf.sample to /etc/asterisk/cdr_unixodbc.conf vi /etc/asterisk/cdr_unixodbc.conf set the dsn, username, password from your odbc.ini file for the database you setup fro asterisk cdr. Also if you find a bug or can do something better in the code please feel free to do so. It took all of 3 hours total to write this(most of the time was finding unixODBC docs.. jesus they say * has bad docs... just try to find unixODBC docs). So i'm sure its not without its bugs. bkw ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] cdr_unixodbc
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 -Original Message- From: Brian West [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 25, 2003 9:28 AM To: [EMAIL PROTECTED] Subject: [Asterisk-Users] cdr_unixodbc 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. :) bkw PS unixODBC is LGPL :) ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users -- The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
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 > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] cdr_unixodbc
> -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 > -- 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. :) Good stuff _bkw! Anything that abstracts out the database connectivity is a good thing. Opens up the world to a host of databases! Makes * palatable for the non-MySQL/PostgreSQL crowd. Regards, --- Gavin ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_unixodbc
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 [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_unixodbc
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. :) bkw PS unixODBC is LGPL :) ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users Yes, I do :) where can I get it ? -- - Best Regards, Pavel Litvinenko. ICQ: 16224754 Ph: (8632) 923962, 923640 sip:[EMAIL PROTECTED] ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] cdr_unixodbc
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 -Original Message- From: Brian West [mailto:[EMAIL PROTECTED] Posted At: Tuesday, 25 November 2003 7:28 PM Posted To: Asterisk Conversation: [Asterisk-Users] cdr_unixodbc Subject: [Asterisk-Users] cdr_unixodbc 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. :) bkw PS unixODBC is LGPL :) ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users