asterisk users - Jan 2006 - CDR reporting between two Asterisk servers

Anybody know if there is a way to get one Asterisk
server to report CDR information to another Asterisk
server?

I have a local Asterisk server and a remote Asterisk
server.  They talk via IAX2.  I have calls that go
as follows:

PSTN->remote server->IAX2->local server->IP phone
                    ->IP phone

When a call comes in from the PSTN it rings phones
at the remote site and the local site.  This
call is bridged so whoever picks it up first gets
the call.  I am trying to find a way for the local
server to report back to the remote server with
who answered the phone at the local site.

Is this even possible?

Use cdr_mysql

Log your CDRs to a common database
Query as needed from either server using realtime() or from an external
app
> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-
> bounces@lists.digium.com] On Behalf Of kwijibo@zianet.com
> Sent: Friday, January 27, 2006 2:22 PM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: [Asterisk-Users] CDR reporting between two Asterisk servers
> 
> Anybody know if there is a way to get one Asterisk
> server to report CDR information to another Asterisk
> server?
> 
> I have a local Asterisk server and a remote Asterisk
> server.  They talk via IAX2.  I have calls that go
> as follows:
> 
> PSTN->remote server->IAX2->local server->IP phone
>                     ->IP phone
> 
> When a call comes in from the PSTN it rings phones
> at the remote site and the local site.  This
> call is bridged so whoever picks it up first gets
> the call.  I am trying to find a way for the local
> server to report back to the remote server with
> who answered the phone at the local site.
> 
> Is this even possible?
> 
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
> 
> Asterisk-Users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users

Damon Estep wrote:
> Use cdr_mysql
> 
> Log your CDRs to a common database
> Query as needed from either server using realtime() or from an external
> app
>
Yeah, I thought about that.  If it works how I think it would
work though I would have two CDR records for one call though.
I would have one record from the remote server and one from
the local. Correlating one record with another could be a pain.

> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-
> bounces@lists.digium.com] On Behalf Of kwijibo@zianet.com
> Sent: Friday, January 27, 2006 2:56 PM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: Re: [Asterisk-Users] CDR reporting between two Asterisk
servers
> 
> Damon Estep wrote:
> > Use cdr_mysql
> >
> > Log your CDRs to a common database
> > Query as needed from either server using realtime() or from an
external
> > app
> >
> 
> Yeah, I thought about that.  If it works how I think it would
> work though I would have two CDR records for one call though.
> I would have one record from the remote server and one from
> the local. Correlating one record with another could be a pain.
> 
> 
True, but the CDR just logs what happens, and in your scenario you
actually do have 2 calls...

> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-
> bounces@lists.digium.com] On Behalf Of JP Carballo
> Sent: Friday, January 27, 2006 3:43 PM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: Re: [Asterisk-Users] CDR reporting between two Asterisk
servers
> 
> kwijibo@zianet.com wrote:
> 
> > Damon Estep wrote:
> >
> >> Use cdr_mysql
> >>
> >> Log your CDRs to a common database
> >> Query as needed from either server using realtime() or from an
external
> >> app
> >>
> >
> > Yeah, I thought about that.  If it works how I think it would
> > work though I would have two CDR records for one call though.
> > I would have one record from the remote server and one from
> > the local. Correlating one record with another could be a pain.
> 
> There are several fields you can use to sync records. You could also
set
> the accountcode and/or userfield to a value you generate per call..
> 
How would you sync the generated code between two servers?