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
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 >
What should I do? :) Add it to the bug tracker? Ben -----Original Message----- From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] 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 minewas> 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
What database server are you using? If you are using MSSQL, just use freetds without unixODBC. AK On 10/20/05, Ben merrills <b.merrills@node4.co.uk> 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 <http://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 >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20051020/346ced48/attachment.htm