[Asterisk-Users] CDR (cdr_odbc)

[Richard Cook]

Hello Matthew,

I guess the cdr_odbc is more accurate from what I understand with the
developers.  In any event, it turns out that cdr.h does contain the value,
they are using bitshifting.
	AST_CDR_ANSWERED = (1 << 2)   which equals 4 
:-)

Thanks
 
--
Richard Cook
richard at aspworld.com
Tel: 705-497-9320 - ext 2010
 

 

-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Matthew Boehm
Sent: Thursday, September 23, 2004 4:12 PM
To: richard at aspworld.com; ASterisk-users at lists.digium.com
Subject: Re: [Asterisk-Users] CDR (cdr_odbc)

If you are running MySQL, why are you using the ODBC drivers? There is alot
less overhead using the mysql libraries and connecting directly to mysql
server than going thru the odbc drivers.

But anyway:

grep -ir "cdr->disposition =" *

cdr->disposition = AST_CDR_ANSWERED;
cdr->disposition = AST_CDR_BUSY;
cdr->disposition = AST_CDR_FAILED;
cdr->disposition = AST_CDR_ANSWERED;
cdr->disposition = AST_CDR_NOANSWER;
cdr->disposition = AST_CDR_NOANSWER;

So its gotta be one of those. Defined in: include/asterisk/cdr.h

Matthew

----- Original Message -----
From: "Richard Cook" <richard at aspworld.com>
To: "'Matthew Boehm'" <mboehm at cytelcom.com>; "'Asterisk Users Mailing List -
Non-Commercial Discussion'" <asterisk-users at lists.digium.com>
Sent: Thursday, September 23, 2004 2:32 PM
Subject: RE: [Asterisk-Users] CDR (cdr_odbc)


> Hello,
>
> When using cdr_odbc, it is stored as a numeric value (cdr->disposition =
> numeric).
>
> I've looked in cdr.h, causes.h and still can't find where a 4 would be
> defined.  Looking in cdr_odbc.c, I see that's it is using cdr->disposition
> which is a numeric value.
>
> --
> Richard Cook
> richard at aspworld.com
> Tel: 705-497-9320 - ext 2010
>
>
>
> -----Original Message-----
> From: Matthew Boehm [mailto:mboehm at cytelcom.com]
> Sent: Thursday, September 23, 2004 3:26 PM
> To: richard at aspworld.com; Asterisk Users Mailing List - Non-Commercial
> Discussion
> Subject: Re: [Asterisk-Users] CDR (cdr_odbc)
>
> asterisk/include/asterisk/cdr.h
>
> #define AST_CDR_NOANSWER
> #define AST_CDR_BUSY
> #define AST_CDR_ANSWERED
> #define AST_CDR_FAILED
>
> Got 1100 calls in my cdr and only have these 3:
>
> NO ANSWER
> ANSWERED
> BUSY
>
> disposition isn't stored as a number in cdr_mysql
>
> Matthew
>
> ----- Original Message -----
> From: "Richard Cook" <richard at aspworld.com>
> To: "'Asterisk Users Mailing List - Non-Commercial Discussion'"
> <asterisk-users at lists.digium.com>
> Sent: Thursday, September 23, 2004 2:07 PM
> Subject: [Asterisk-Users] CDR (cdr_odbc)
>
>
> > Hello,
> >
> > I've perused through the source but can't seem to find it.
> >
> > In my CDR table (MySQL), I'm getting a disposition of 4 for normal,
> answered
> > calls.  Does anyone know what that number represents and where I can
find
> a
> > list?
> >
> > --
> > Richard Cook
> > richard at aspworld.com
> > Tel: 705-497-9320 - ext 2010
> >
> >
>
>
> --------------------------------------------------------------------------
--
> ----
>
>
> > _______________________________________________
> > Asterisk-Users mailing list
> > Asterisk-Users at 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
>
>
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at 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

_______________________________________________
Asterisk-Users mailing list
Asterisk-Users at 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