[asterisk-users] Asterisk Database Handling

[Sherwood McGowan]

Douglas Garstang wrote:
> I couldn't find one for cdr_mysql.conf.
> We're using odbc anyway. MySQL directly might be an option if it works.
> Don't think we want to modify the server.
>
>
> ----- Original Message ----
> From: Alex Balashov <abalashov at evaristesys.com>
> To: Asterisk Users Mailing List - Non-Commercial Discussion 
> <asterisk-users at lists.digium.com>
> Sent: Wednesday, May 21, 2008 3:02:07 PM
> Subject: Re: [asterisk-users] Asterisk Database Handling
>
> Douglas Garstang wrote:
>
> > We are sending CDR's to MySQL via odbc. It seems that Asterisk is
> > sometimes dropping CDR's, and they aren't being sent to the database
> > (they ARE in the Master.csv file though). We suspect that when the 
> MySQL
> > socket is idle, it gets disconnected, either by the MySQL server or by
> > our firewall, and when Asterisk goes to send the next CDR over the
> > socket, does not re-open the database, and drops that CDR. Possibly on
> > the next call, it connects ok and sends the next CDR.
>
> Isn't there a keepalive option somewhere for cdr_mysql.conf, or failing
> that, a keepalive mechanism that can be enabled for TCP connections on
> the server side?
>
> -- 
> Alex Balashov
> Evariste Systems
> Web    : http://www.evaristesys.com/
> Tel    : (+1) (678) 954-0670
> Direct : (+1) (678) 954-0671
> Mobile : (+1) (706) 338-8599
>
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
I personally can tell you I've never had a problem with either the 
PostgreSQL or MySQL cdr apps themselves losing records. However, I can't 
say personally how well the ODBC method works. I'll just stick to saying 
that if you're considering using the cdr_mysql addon, I would highly 
suggest it as I've used it with MUCH success on high load servers.

Sherwood McGowan