Re: [Asterisk-Users] cdr_odbc with tds
What database server are you using? If you are using MSSQL, just use freetds without unixODBC. AK On 10/20/05, Ben merrills <[EMAIL PROTECTED]> wrote: Does anyone know why, using latest cvs head, freetds 0.62.1-0 andunixODBC, when running cdr_odbc, it says it's logged the call successfully, however, when checking the table, nothing is there!I checked through the bug tracker; and a problem very much like mine wasin there, with status resolved as of last year (1339).Can anyone shed some light on this please? Cheers,Ben___--Bandwidth and Colocation sponsored by Easynews.com --Asterisk-Users mailing list Asterisk-Users@lists.digium.comhttp://lists.digium.com/mailman/listinfo/asterisk-usersTo UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation sponsored by Easynews.com -- Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] cdr_odbc with tds
...Or fix the problem yourself:-) On Thu, 2005-10-20 at 16:58 +0100, Ben merrills wrote: > What should I do? :) > > Add it to the bug tracker? > > Ben > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Sergey > Okhapkin > Sent: 20 October 2005 16:48 > To: Asterisk Users Mailing List - Non-Commercial Discussion > Subject: Re: [Asterisk-Users] cdr_odbc with tds > > Looks like a bug to me, I just took a look at cdr_odbc.c. I'm not a > specialist in ODBC, but what seems to me wrong is the module does INSERT > into the database, but does not make COMMIT. > > On Thu, 2005-10-20 at 16:31 +0100, Ben merrills wrote: > > Does anyone know why, using latest cvs head, freetds 0.62.1-0 and > > unixODBC, when running cdr_odbc, it says it's logged the call > > successfully, however, when checking the table, nothing is there! > > > > I checked through the bug tracker; and a problem very much like mine > was > > in there, with status resolved as of last year (1339). > > > > Can anyone shed some light on this please? > > > > Cheers, > > > > Ben > > ___ > > --Bandwidth and Colocation sponsored by Easynews.com -- > > > > Asterisk-Users mailing list > > Asterisk-Users@lists.digium.com > > http://lists.digium.com/mailman/listinfo/asterisk-users > > To UNSUBSCRIBE or update options visit: > >http://lists.digium.com/mailman/listinfo/asterisk-users > > > > ___ > --Bandwidth and Colocation sponsored by Easynews.com -- > > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: >http://lists.digium.com/mailman/listinfo/asterisk-users > ___ > --Bandwidth and Colocation sponsored by Easynews.com -- > > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: >http://lists.digium.com/mailman/listinfo/asterisk-users > ___ --Bandwidth and Colocation sponsored by Easynews.com -- Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] cdr_odbc with tds
> What should I do? :) > > Add it to the bug tracker? it might be a bug, but I don't think its due to lack of commit. sqlserver is normally in "implicit commit" mode where every sql statement is an individual transaction and is committed as its executed. I would start by having a look at the driver and database logs and see what is actually being executed first, then go from there. > > Ben > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Sergey > Okhapkin > Sent: 20 October 2005 16:48 > To: Asterisk Users Mailing List - Non-Commercial Discussion > Subject: Re: [Asterisk-Users] cdr_odbc with tds > > Looks like a bug to me, I just took a look at cdr_odbc.c. I'm not a > specialist in ODBC, but what seems to me wrong is the module does INSERT > into the database, but does not make COMMIT. > > On Thu, 2005-10-20 at 16:31 +0100, Ben merrills wrote: >> Does anyone know why, using latest cvs head, freetds 0.62.1-0 and >> unixODBC, when running cdr_odbc, it says it's logged the call >> successfully, however, when checking the table, nothing is there! >> >> I checked through the bug tracker; and a problem very much like mine > was >> in there, with status resolved as of last year (1339). >> >> Can anyone shed some light on this please? >> >> Cheers, >> >> Ben >> ___ >> --Bandwidth and Colocation sponsored by Easynews.com -- >> >> Asterisk-Users mailing list >> Asterisk-Users@lists.digium.com >> http://lists.digium.com/mailman/listinfo/asterisk-users >> To UNSUBSCRIBE or update options visit: >>http://lists.digium.com/mailman/listinfo/asterisk-users >> > > ___ > --Bandwidth and Colocation sponsored by Easynews.com -- > > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: >http://lists.digium.com/mailman/listinfo/asterisk-users > ___ > --Bandwidth and Colocation sponsored by Easynews.com -- > > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: >http://lists.digium.com/mailman/listinfo/asterisk-users > Jon Pounder _/_/_/ _/_/ _/ _/_/_/ _/_/ _/_/_/_/ _/_/_/ _/ _/ _/_/_/ _/ _/_/ _/_/ _/_/ _/ _/_/ _/_/ _/ _/_/_/ _/_/ _/_/_/_/ _/_/_/ _/_/ _/_/_/_/ Inline Internet Systems Inc. Thorold, Ontario, Canada Tools to Power Your e-Business Solutions www.inline.net www.ihtml.com www.ihtmlmerchant.com www.opayc.com ___ --Bandwidth and Colocation sponsored by Easynews.com -- Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] cdr_odbc with tds
What should I do? :) Add it to the bug tracker? Ben -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sergey Okhapkin Sent: 20 October 2005 16:48 To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] cdr_odbc with tds Looks like a bug to me, I just took a look at cdr_odbc.c. I'm not a specialist in ODBC, but what seems to me wrong is the module does INSERT into the database, but does not make COMMIT. On Thu, 2005-10-20 at 16:31 +0100, Ben merrills wrote: > Does anyone know why, using latest cvs head, freetds 0.62.1-0 and > unixODBC, when running cdr_odbc, it says it's logged the call > successfully, however, when checking the table, nothing is there! > > I checked through the bug tracker; and a problem very much like mine was > in there, with status resolved as of last year (1339). > > Can anyone shed some light on this please? > > Cheers, > > Ben > ___ > --Bandwidth and Colocation sponsored by Easynews.com -- > > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: >http://lists.digium.com/mailman/listinfo/asterisk-users > ___ --Bandwidth and Colocation sponsored by Easynews.com -- Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation sponsored by Easynews.com -- Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr_odbc with tds
Looks like a bug to me, I just took a look at cdr_odbc.c. I'm not a specialist in ODBC, but what seems to me wrong is the module does INSERT into the database, but does not make COMMIT. On Thu, 2005-10-20 at 16:31 +0100, Ben merrills wrote: > Does anyone know why, using latest cvs head, freetds 0.62.1-0 and > unixODBC, when running cdr_odbc, it says it's logged the call > successfully, however, when checking the table, nothing is there! > > I checked through the bug tracker; and a problem very much like mine was > in there, with status resolved as of last year (1339). > > Can anyone shed some light on this please? > > Cheers, > > Ben > ___ > --Bandwidth and Colocation sponsored by Easynews.com -- > > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: >http://lists.digium.com/mailman/listinfo/asterisk-users > ___ --Bandwidth and Colocation sponsored by Easynews.com -- Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users