[asterisk-users] Write Asterisk CDR MySQL records to multiple servers

[Andres]

Ricardo Melendez wrote:

> Hi to all, I actually have an asterisk server configured to write CDR 
> mysql records in the same machine (localhost), but I want to write 
> this records to another machine also in mysql  at the same time, It is 
> possible? It means that I want save the records in both machines.
>
>  
>
> Thanks in advance.
>
>  
>
> Ricardo Melendez
>
I would customize my own cdr_addon_mysql.so by editing cdr_addon_mysql.c 
and recompiling.  It is fairly trivial to add a second MySQL server to 
the mix.   The query is on line 248 and it is:

if (mysql_real_query(&mysql, sqlcmd, strlen(sqlcmd))) {

Just define another MySQL connection and insert an addicional query.

Andres
http://www.neuroredes.com

>------------------------------------------------------------------------
>
>_______________________________________________
>-- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
>AstriCon 2008 - September 22 - 25 Phoenix, Arizona
>Register Now: http://www.astricon.net
>
>asterisk-users mailing list
>To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>