Hello, After 2 weeks and 4 days without a problem, Asterisk went down. What happened is that I am using Asterisk 1.2.1 on a machine and have a MySQL for CDR on another machine. The machine with MySQL went down and the Asterisk box was unable to connect to MySQL. This made Asterisk to go down and it was unable to restart until MySQL was back. I know that Asterisk displays a lot of warnings, but still works, when the cdr table is corrupt. But isn't it a strange behaviour to go down when MySQL is down? Thank you Dov -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060116/70a1beed/attachment.htm
Did someone made or implement an script to move all the info from the standar cdr format to a PostgreSQL or MySQL? We're going to start moving all the last two years of cdr soon, and really I never take this point on my schedules. Thanks, Carlos Alperin _____ From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Dov Bigio Sent: Monday, January 16, 2006 7:02 AM To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] asterisk down because of cdr Hello, After 2 weeks and 4 days without a problem, Asterisk went down. What happened is that I am using Asterisk 1.2.1 on a machine and have a MySQL for CDR on another machine. The machine with MySQL went down and the Asterisk box was unable to connect to MySQL. This made Asterisk to go down and it was unable to restart until MySQL was back. I know that Asterisk displays a lot of warnings, but still works, when the cdr table is corrupt. But isn't it a strange behaviour to go down when MySQL is down? Thank you Dov -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060117/c6c16fc6/attachment.htm
When using asterisk real time, every time somehting occurs in asterisk it goes to the DB. If the DB isnt up natrually it dosent know what to do. So yes this behavior is perfectly normal. Dovid (Sorry about the spelling mistakes) --- Dov Bigio <dovb@terra.com.br> wrote:> Hello, > > After 2 weeks and 4 days without a problem, Asterisk > went down. > > What happened is that I am using Asterisk 1.2.1 on a > machine and have a MySQL for CDR on another machine. > The machine with MySQL went down and the Asterisk > box was unable to connect to MySQL. This made > Asterisk to go down and it was unable to restart > until MySQL was back. > > I know that Asterisk displays a lot of warnings, but > still works, when the cdr table is corrupt. But > isn't it a strange behaviour to go down when MySQL > is down? > > Thank you > Dov> _______________________________________________ > --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>__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Buffer! For how long? How big of a buffer? If I can buffer 10-20 calls that might work if I have a light use PBX but 100-2000 buffered calls may not hold a busy PBX. OK so make it configurable, With any luck you won't know how much to put so you will allocate more than you need, using more memory for a single senario. My solution, make sure your DB is stable. I would rather put my effort in building a better solution than counting on insurance to bail me out.> -----Original Message----- > From: asterisk-users-bounces@lists.digium.com > [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of > Jean-Michel Hiver > Sent: Tuesday, January 17, 2006 12:38 PM > To: Dov Bigio; Asterisk Users Mailing List - Non-Commercial Discussion > Subject: Re: [Asterisk-Users] asterisk down because of cdr > > Dov Bigio a ?crit : > > >Ok.. but I don't use Real Time at all. > >I just use cdr_mysql. It would be smarter if it simply ignored MySQL > >outages or at least just logged, but without stopping. > > > > > What would be even nicer would be for * to buffer it for a > while before it starts dropping cdrs... > > > _______________________________________________ > --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 >