> I have read 2 solutions....
> (a) Changing the Dial plan and capturing DNID and inserting it into
> one of the existing column in CDR table.
> (b) Copy new CDR related .c & .h files which have added the
> functionality of recording DNID into MySQL.
> For this, CDR table structure needs to be changed and a new field has
> be created in CDR table.
> But I am still not very sure on how to go about doing this.
> Since I only have a production server, I do not have the options of
> experimenting.
> Can someone help with a step-by-step?
> Thx
> Sanjay
>> On Mon, Mar 15, 2010 at 3:08 PM, Lee Archer <[email protected]>
>> wrote:
>> Isn't the use of DNID separate to the userfield? I'd like to have this
>> working also.
>>
>> Lee
>>
>> -----Original Message-----
>> From: [email protected]
>> [mailto:[email protected]] On Behalf Of Alex
>> Balashov
>> Sent: 15 March 2010 08:34
>> To: Asterisk Users Mailing List - Non-Commercial Discussion
>> Subject: Re: [asterisk-users] CDR: Add Dialed Number Identifierfield
>> (DNID) field into MySQL
>>
>> Use the userfield.
>>
>> On 03/15/2010 04:25 AM, RSCL Mumbai wrote:
>>
>>> Hi,
>>>
>>> I would like to see the DNID in my MySQL CDR logs.
>>>
>>> I have read one big thread in the Asterisk Developer List, but I could
>>> not figure out how to implement it ?
>>> Is there a simple step-by-step.
If this is Asterisk 1.6.*, then you can use the adaptive ODBC, which is
configured using /etc/asterisk/cdr_adaptive_odbc.conf. If you compiled
Asterisk with samples, you will find a sample file that has pretty much
everything that you need. From there, simply set the fieldname that you wish
to write to the CDR, like this:
; Using Adaptive ODBC CDR's, sets the caller ID DNID to the CDR's custom field
named "DNID"
Set(CDR(DNID)=${CALLERID(DNID)})
Personally, I like to set the DNID to a variable, just in case, when the
inbound call first hits Asterisk from the trunk. This probably isn't
necessary, but I am always afraid that the CALLERID(DNID) value will change
with a transfer or a channel redirect, which we use. From there I write the
variable to the CDR.
For more information on the adaptive concept, please see
http://www.asterisk.org/node/48492. There is also more detail from Tilghman
Lesher here:
http://www.mail-archive.com/[email protected]/msg210573.html
It's very elegant in it's design and it works like a champ- we use it in
production.
If you are using Asterisk 1.4.*, you can use the the CDR's userfield. This is
an optional, user defined field that can store just about whatever data you
wish depending on the data type defined in the database. You will have to
google around to find out more information on how to enable it, although I
believe that it's an option in the /etc/asterisk/cdr.conf configuration file
that you are using.
Again, if you are using Asterisk 1.6.* I would strongly recommend that you take
advantage of the Adaptive CDR system.
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
