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 :)
Brian!
You've done something tricky again! I'm interested! *wink*
Where do I get it?
;)
Ben
______________________________
Benjamin Wakefield
ben@team.dcsi.net.au
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:brian@bkw.org]
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
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
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 >Asterisk-Users@lists.digium.com >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:litw@iptel.org
> -----Original Message----- > From: Brian West [mailto:brian@bkw.org] > > 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 todo> 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
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:brian@bkw.org]
Sent: Tuesday, November 25, 2003 9:28 AM
To: asterisk-users@lists.digium.com
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
Asterisk-Users@lists.digium.com
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.
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@bkw.org> Date: Tue, 25 Nov 2003 07:19:27 -0600 (CST) To: asterisk-users@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@lists.digium.com > > http://lists.digium.com/mailman/listinfo/asterisk-users > > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@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
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 ben@team.dcsi.net.au 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:brian@bkw.org] 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 > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users >_______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users