Hello, I configured asterisk to use mysql for CDR. Well when i check from time to time I realize that asterisk loose connection with mysql (i use phpmyadmin and i watch the processes). Can anybody tell me how can i solve that problem? I want to have all cdr statistics logged in mysql, is very important for billing. Thank you for support. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20080624/29a19108/attachment.htm
On 09:54, Tue 24 Jun 08, Catalin S. wrote:> Hello, > I configured asterisk to use mysql for CDR. Well when i check from time to > time I realize > that asterisk loose connection with mysql (i use phpmyadmin and i watch the > processes). > Can anybody tell me how can i solve that problem? I want to have all cdr > statistics logged in mysql, > is very important for billing. > > Thank you for support.Use cdr_adaptive_odbc backport for 1.4. That one does a check if the connection is still working, and if not it will reconnect. -- Michiel van Baak michiel at vanbaak.eu http://michiel.vanbaak.eu GnuPG key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x71C946BD "Why is it drug addicts and computer aficionados are both called users?"
On Tuesday 24 June 2008 01:54:11 Catalin S. wrote:> Hello, > I configured asterisk to use mysql for CDR. Well when i check from time to > time I realize > that asterisk loose connection with mysql (i use phpmyadmin and i watch the > processes). > Can anybody tell me how can i solve that problem? I want to have all cdr > statistics logged in mysql, > is very important for billing.Are you actually missing CDRs, or are you just concerned that you MIGHT be? The only reason that you might be missing CDRs from the MySQL backend is if the MySQL server was completely down (i.e. not just disconnected from Asterisk, but completely down) at the time that the CDR was posted. All SQL insertions (for this backend) are automatically retried if the initial query failed. -- Tilghman